Previous Thread
Next Thread
Print Thread
Hop To
Joined: Apr 2007
Posts: 120
A
member
member
A Offline
Joined: Apr 2007
Posts: 120
User on the new 7.1 threads got this:

Quote
Andrew,

When trying to change my preferences (for example, to set the # posts per page to 99) I get the following error:

UBB Error
We encountered a problem. The reason reported was

Database error only visible to forum administrators

Please use your back button to return to the previous page.
THE ERROR IS:

Database error only visible to forum administrators

Thoughts, or things to get you more info from?


...usin' da classic UBB, since the beginning of time.
wink
Joined: Apr 2007
Posts: 120
A
member
member
A Offline
Joined: Apr 2007
Posts: 120
Correction: multiple users having the same problem.

just fyi. smile


...usin' da classic UBB, since the beginning of time.
wink
Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
Have you checked the error log via the control panel
for the sql error ?

As the output should be there.

You could also try the permissions test which
is one of the links on the left in the Control Panel.


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Joined: Apr 2007
Posts: 120
A
member
member
A Offline
Joined: Apr 2007
Posts: 120
Permission tests all pass.

Don't see anywhere that I can check the error log in the CP...?
Ok, got it, have to enable first, and then manually check the dir, ok, will get back to you. smile

Last edited by Andrew Bienhaus; 04/13/2007 4:12 PM.

...usin' da classic UBB, since the beginning of time.
wink
Joined: Apr 2007
Posts: 120
A
member
member
A Offline
Joined: Apr 2007
Posts: 120
here we go...
Quote
[ERROR][Fri, Apr 13 2007 16:15:36 -0400] [/forums/ubbthreads.php] [Rob Cauduro] Script: C:\Inetpub\ca.dsm.org\forums\scripts\changedisplay.inc.php - Line: 141
UPDATE ubbt_USER_PROFILE
SET
USER_START_VIEW = 'cfrm',
USER_FAVORITES_TAB = 'forums',
USER_FAVORITES_SORT = 'reply',
USER_TOPIC_VIEW_TYPE = 'flat',
USER_SHOW_AVATARS = 1,
USER_NOTIFY_ON_PM = 'yes',
USER_POSTS_PER_TOPIC = 40,
USER_TOPICS_PER_PAGE = 40,
USER_ACCEPT_PM = 'yes',
USER_TIME_FORMAT = 'Y m d | h:i a',
USER_TIME_OFFSET = 0,
USER_VISIBLE_ONLINE_STATUS = 'yes',
USER_SHOW_SIGNATURES = 'yes',
USER_STYLE = 0,
USER_UNAPPROVED_POST_NOTIFY = 0 ,
USER_HIDE_LEFT_COLUMN = 0 ,
USER_HIDE_RIGHT_COLUMN = 0 ,
USER_EMAIL_WATCHLISTS = 0 ,
USER_LANGUAGE = 'english' ,
USER_REPORT_POST_NOTIFY = '' ,
USER_RELATIVE_TIME = 1
WHERE USER_ID = 821
- Incorrect integer value: '' for column 'USER_REPORT_POST_NOTIFY' at row 1
[ERROR][Fri, Apr 13 2007 16:16:56 -0400] [/forums/ubbthreads.php] [Rob Cauduro] Script: C:\Inetpub\ca.dsm.org\forums\scripts\changedisplay.inc.php - Line: 141
UPDATE ubbt_USER_PROFILE
SET
USER_START_VIEW = 'cfrm',
USER_FAVORITES_TAB = 'forums',
USER_FAVORITES_SORT = 'reply',
USER_TOPIC_VIEW_TYPE = 'flat',
USER_SHOW_AVATARS = 1,
USER_NOTIFY_ON_PM = 'yes',
USER_POSTS_PER_TOPIC = 10,
USER_TOPICS_PER_PAGE = 10,
USER_ACCEPT_PM = 'yes',
USER_TIME_FORMAT = 'Y m d | h:i a',
USER_TIME_OFFSET = 0,
USER_VISIBLE_ONLINE_STATUS = 'no',
USER_SHOW_SIGNATURES = 'yes',
USER_STYLE = 0,
USER_UNAPPROVED_POST_NOTIFY = 0 ,
USER_HIDE_LEFT_COLUMN = 0 ,
USER_HIDE_RIGHT_COLUMN = 0 ,
USER_EMAIL_WATCHLISTS = 0 ,
USER_LANGUAGE = 'english' ,
USER_REPORT_POST_NOTIFY = '' ,
USER_RELATIVE_TIME = 1
WHERE USER_ID = 821
- Incorrect integer value: '' for column 'USER_REPORT_POST_NOTIFY' at row 1
[ERROR][Fri, Apr 13 2007 16:17:03 -0400] [/forums/ubbthreads.php] [Rob Cauduro] Script: C:\Inetpub\ca.dsm.org\forums\scripts\changedisplay.inc.php - Line: 141
UPDATE ubbt_USER_PROFILE
SET
USER_START_VIEW = 'cfrm',
USER_FAVORITES_TAB = 'forums',
USER_FAVORITES_SORT = 'reply',
USER_TOPIC_VIEW_TYPE = 'flat',
USER_SHOW_AVATARS = 1,
USER_NOTIFY_ON_PM = 'yes',
USER_POSTS_PER_TOPIC = 10,
USER_TOPICS_PER_PAGE = 10,
USER_ACCEPT_PM = 'yes',
USER_TIME_FORMAT = 'Y m d | h:i a',
USER_TIME_OFFSET = 0,
USER_VISIBLE_ONLINE_STATUS = 'yes',
USER_SHOW_SIGNATURES = 'yes',
USER_STYLE = 0,
USER_UNAPPROVED_POST_NOTIFY = 0 ,
USER_HIDE_LEFT_COLUMN = 0 ,
USER_HIDE_RIGHT_COLUMN = 0 ,
USER_EMAIL_WATCHLISTS = 0 ,
USER_LANGUAGE = 'english' ,
USER_REPORT_POST_NOTIFY = '' ,
USER_RELATIVE_TIME = 1
WHERE USER_ID = 821
- Incorrect integer value: '' for column 'USER_REPORT_POST_NOTIFY' at row 1
[ERROR][Fri, Apr 13 2007 16:17:16 -0400] [/forums/ubbthreads.php] [Rob Cauduro] Script: C:\Inetpub\ca.dsm.org\forums\scripts\changedisplay.inc.php - Line: 141
UPDATE ubbt_USER_PROFILE
SET
USER_START_VIEW = 'cfrm',
USER_FAVORITES_TAB = 'forums',
USER_FAVORITES_SORT = 'reply',
USER_TOPIC_VIEW_TYPE = 'flat',
USER_SHOW_AVATARS = 1,
USER_NOTIFY_ON_PM = 'yes',
USER_POSTS_PER_TOPIC = 10,
USER_TOPICS_PER_PAGE = 10,
USER_ACCEPT_PM = 'yes',
USER_TIME_FORMAT = 'Y m d | h:i a',
USER_TIME_OFFSET = 0,
USER_VISIBLE_ONLINE_STATUS = 'yes',
USER_SHOW_SIGNATURES = 'yes',
USER_STYLE = 0,
USER_UNAPPROVED_POST_NOTIFY = 0 ,
USER_HIDE_LEFT_COLUMN = 0 ,
USER_HIDE_RIGHT_COLUMN = 0 ,
USER_EMAIL_WATCHLISTS = 0 ,
USER_LANGUAGE = 'english' ,
USER_REPORT_POST_NOTIFY = '' ,
USER_RELATIVE_TIME = 1
WHERE USER_ID = 821
- Incorrect integer value: '' for column 'USER_REPORT_POST_NOTIFY' at row 1
[ERROR][Fri, Apr 13 2007 16:20:37 -0400] [/forums/ubbthreads.php] [Rob Cauduro] Script: C:\Inetpub\ca.dsm.org\forums\scripts\modifypost.inc.php - Line: 455
update ubbt_POSTS
set POST_SUBJECT = 'Re: New Forum Program....' ,
POST_BODY = ' <img src=\"http://www.fox-obel.com/images/cheese.jpg\" alt=\"\" /> <br /><br />There ya go Strelecki <img src=\"/forums/images/graemlins/default/smile.gif\" alt=\"\\:\\)\" title=\"smile\" height=\"15\" width=\"15\" />' ,
POST_DEFAULT_BODY = ' [Linked Image from fox-obel.com] \r\n\r\nThere ya go Strelecki :)',
POST_ICON = 'book.gif' ,
POST_LAST_EDITED_TIME= '' ,
POST_LAST_EDIT_REASON = '' ,
POST_LAST_EDITED_BY = 'Rob Cauduro' ,
POST_ADD_SIGNATURE = 1 ,
POST_HAS_FILE = 0

where POST_ID = 228217
- Incorrect integer value: '' for column 'POST_LAST_EDITED_TIME' at row 1
[ERROR][Fri, Apr 13 2007 16:20:43 -0400] [/forums/ubbthreads.php] [Rob Cauduro] Script: C:\Inetpub\ca.dsm.org\forums\scripts\modifypost.inc.php - Line: 455
update ubbt_POSTS
set POST_SUBJECT = 'Re: New Forum Program....' ,
POST_BODY = ' <img src=\"http://www.fox-obel.com/images/cheese.jpg\" alt=\"\" /> <br /><br />There ya go Strelecki <img src=\"/forums/images/graemlins/default/smile.gif\" alt=\"\\:\\)\" title=\"smile\" height=\"15\" width=\"15\" />' ,
POST_DEFAULT_BODY = ' [Linked Image from fox-obel.com] \r\n\r\nThere ya go Strelecki :)',
POST_ICON = 'book.gif' ,
POST_LAST_EDITED_TIME= '' ,
POST_LAST_EDIT_REASON = '' ,
POST_LAST_EDITED_BY = 'Rob Cauduro' ,
POST_ADD_SIGNATURE = 1 ,
POST_HAS_FILE = 0

where POST_ID = 228217
- Incorrect integer value: '' for column 'POST_LAST_EDITED_TIME' at row 1


...usin' da classic UBB, since the beginning of time.
wink
Joined: Apr 2007
Posts: 120
A
member
member
A Offline
Joined: Apr 2007
Posts: 120
<LOL>
Excuse the cheese... they were whining, and someone offered up some cheese to go with it.


...usin' da classic UBB, since the beginning of time.
wink
Joined: Apr 2007
Posts: 120
A
member
member
A Offline
Joined: Apr 2007
Posts: 120
and, it almost looks like it's also having an issue updating the last post time??


...usin' da classic UBB, since the beginning of time.
wink
Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
pmsl at the cheese..

2 things well 3.

1. Watch for a fella called Rick to come on line. (He built Threads)
2. Start a support ticket with your login info and so on.
3. I cant help as ive havent seen that error before.


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Joined: Apr 2007
Posts: 120
A
member
member
A Offline
Joined: Apr 2007
Posts: 120
Will do.
Have done.
No problem.

wink


...usin' da classic UBB, since the beginning of time.
wink
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Sounds like the MySQL Strict issue I think...

see the bottom part of this thread here


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Apr 2007
Posts: 120
A
member
member
A Offline
Joined: Apr 2007
Posts: 120
Yes, my first thought as well, but as you can see by that other thread, I've already entered that command once to relax things, or else the import never would have run.

It's not like I have to enter it and save it, or anything like that, is it?


...usin' da classic UBB, since the beginning of time.
wink
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Lol didn't read the thread to see if it where you, simply used the search and posted the link wink...

Well, if it isn'tthat, I'm not sure, will likely have to wait for Ricky wink


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Definitely looks like it's still the strict mode issue. One thing about this, when run it only holds the change until MySQL is restarted or reloaded. If it has been restarted, then you'll want to run that command again.

I've set my devel box to run in strict mode so I can make sure all of these are caught for the 7.1.1 update.

Joined: Apr 2007
Posts: 120
A
member
member
A Offline
Joined: Apr 2007
Posts: 120
ok, so is there a way to save this setting?

Or, are you saying that the UBB should be dealing with this, and in 7.1.1 you will have resolved it, and I won't have to do it any more?

thanks...


...usin' da classic UBB, since the beginning of time.
wink
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
I believe you can add something to your mysqld startup script that stores the default settings. However, this is something that UBB should be dealing with as more and more sites upgrade to MySQL 5 and strict mode is the default.

Joined: Apr 2007
Posts: 120
A
member
member
A Offline
Joined: Apr 2007
Posts: 120
Ok, will keep putting it in after reboots, until 7.1.1 hits the street.

Thanks...


...usin' da classic UBB, since the beginning of time.
wink

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (rootman), 641 guests, and 112 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)