You are not logged in. [Log In] UBB.threads Community » Forums » UBB.threads 7 Discussion » Bug Reports
      » Fixed Bugs » [FIXED for 7.2] error from database when setting prefs?
Register User    Portal Page     Forum List        Calendar     Active Topics     FAQ
Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
3 registered (blaaskaak, DougMM, Gizmo), 17 Guests and 24 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 07/07/05
Posts: 62
Top Posters (30 Days)
Ruben Rocha 179
Gizmo 112
Rick 109
Thelockman 80
driv 43
AllenAyres 35
ntdoc 28
Ian 24
Sirdude 23
ScriptKeeper 20
Latest Photos
My Home System
test photo gallery
Bernese Mountain Dogs
My Daimler
Dorado and shark
Page 1 of 2 1 2 >
Topic Options
Rate This Topic
#182639 - 04/13/07 12:34 PM [FIXED for 7.2] error from database when setting prefs?
Andrew Bienhaus Offline
member

Registered: 04/10/07
Posts: 108
Loc: Binbrook, Ontario, Canada
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 -- (and now trying to adapt to this 'upgrade')

Top
#182640 - 04/13/07 12:40 PM Re: error from database when setting prefs? [Re: Andrew Bienhaus]
Andrew Bienhaus Offline
member

Registered: 04/10/07
Posts: 108
Loc: Binbrook, Ontario, Canada
Correction: multiple users having the same problem.

just fyi. \:\)
_________________________
...usin' da classic UBB, since the beginning of time.
wink -- (and now trying to adapt to this 'upgrade')

Top
#182650 - 04/13/07 01:01 PM Re: error from database when setting prefs? [Re: Andrew Bienhaus]
Mark S Offline
Carpal Tunnel
***

Registered: 07/04/06
Posts: 4044
Loc: Liverpool : England : UK
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.
_________________________
Version v7.2.2 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
To answer the question you must first give a question.

Top
#182653 - 04/13/07 01:11 PM Re: error from database when setting prefs? [Re: Mark S]
Andrew Bienhaus Offline
member

Registered: 04/10/07
Posts: 108
Loc: Binbrook, Ontario, Canada
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. \:\)


Edited by Andrew Bienhaus (04/13/07 01:12 PM)
_________________________
...usin' da classic UBB, since the beginning of time.
wink -- (and now trying to adapt to this 'upgrade')

Top
#182654 - 04/13/07 01:22 PM Re: error from database when setting prefs? [Re: Andrew Bienhaus]
Andrew Bienhaus Offline
member

Registered: 04/10/07
Posts: 108
Loc: Binbrook, Ontario, Canada
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 = ' \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 = ' \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 -- (and now trying to adapt to this 'upgrade')

Top
#182655 - 04/13/07 01:23 PM Re: error from database when setting prefs? [Re: Andrew Bienhaus]
Andrew Bienhaus Offline
member

Registered: 04/10/07
Posts: 108
Loc: Binbrook, Ontario, Canada
<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 -- (and now trying to adapt to this 'upgrade')

Top
#182656 - 04/13/07 01:43 PM Re: error from database when setting prefs? [Re: Andrew Bienhaus]
Andrew Bienhaus Offline
member

Registered: 04/10/07
Posts: 108
Loc: Binbrook, Ontario, Canada
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 -- (and now trying to adapt to this 'upgrade')

Top
#182657 - 04/13/07 01:44 PM Re: error from database when setting prefs? [Re: Andrew Bienhaus]
Mark S Offline
Carpal Tunnel
***

Registered: 07/04/06
Posts: 4044
Loc: Liverpool : England : UK
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.
_________________________
Version v7.2.2 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
To answer the question you must first give a question.

Top
#182658 - 04/13/07 01:57 PM Re: error from database when setting prefs? [Re: Mark S]
Andrew Bienhaus Offline
member

Registered: 04/10/07
Posts: 108
Loc: Binbrook, Ontario, Canada
Will do.
Have done.
No problem.

;\)
_________________________
...usin' da classic UBB, since the beginning of time.
wink -- (and now trying to adapt to this 'upgrade')

Top
#182667 - 04/13/07 04:33 PM Re: error from database when setting prefs? [Re: Andrew Bienhaus]
Gizmo Moderator Online sleepy

***

Registered: 06/04/06
Posts: 12007
Loc: Portland, OR; USA
Sounds like the MySQL Strict issue I think...

see the bottom part of this thread here
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#182673 - 04/13/07 06:06 PM Re: error from database when setting prefs? [Re: Gizmo]
Andrew Bienhaus Offline
member

Registered: 04/10/07
Posts: 108
Loc: Binbrook, Ontario, Canada
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 -- (and now trying to adapt to this 'upgrade')

Top
#182676 - 04/13/07 06:16 PM Re: error from database when setting prefs? [Re: Andrew Bienhaus]
Gizmo Moderator Online sleepy

***

Registered: 06/04/06
Posts: 12007
Loc: Portland, OR; USA
Lol didn't read the thread to see if it where you, simply used the search and posted the link ;)...

Well, if it isn'tthat, I'm not sure, will likely have to wait for Ricky ;\)
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#182677 - 04/13/07 07:30 PM Re: error from database when setting prefs? [Re: Gizmo]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7898
Loc: Aberdeen, WA
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.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#182695 - 04/14/07 04:05 AM Re: error from database when setting prefs? [Re: Rick]
Andrew Bienhaus Offline
member

Registered: 04/10/07
Posts: 108
Loc: Binbrook, Ontario, Canada
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 -- (and now trying to adapt to this 'upgrade')

Top
#182701 - 04/14/07 08:34 AM Re: error from database when setting prefs? [Re: Andrew Bienhaus]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7898
Loc: Aberdeen, WA
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.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#182704 - 04/14/07 10:19 AM Re: error from database when setting prefs? [Re: Rick]
Andrew Bienhaus Offline
member

Registered: 04/10/07
Posts: 108
Loc: Binbrook, Ontario, Canada
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 -- (and now trying to adapt to this 'upgrade')

Top
Page 1 of 2 1 2 >


Moderator:  AllenAyres, Gizmo, Harold, Ian, Ian Spence, Ron M, Sirdude, usrbingeek 
Shout Box