Previous Thread
Next Thread
Print Thread
Hop To
Joined: Mar 2007
Posts: 36
Likes: 1
B
BB
Offline
Newbie
Newbie
B Offline
Joined: Mar 2007
Posts: 36
Likes: 1
Hello,

We upgraded MySQL from 5.5.20 to 5.6.10. After that we receive the following message while registering a user:

UBB Message
We encountered a problem. The reason reported was

Script: scripts/adduser.inc.php
Line#: 727
SQL Error: Incorrect integer value: 'wordsmith' for column 'USER_ID' at row 1
SQL Error #: 1366
Query: INSERT INTO ubbt_PRIVATE_MESSAGE_TOPICS (TOPIC_TIME,TOPIC_REPLIES,TOPIC_SUBJECT,USER_ID,TOPIC_LAST_REPLY_TIME) values ('1361222078','0','Welcome','wordsmith','1361222078')

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
This is to vague to answer.
Questions
Version of ubb?
Version of php?
Global Server settings?
Using mod security?
New install of ubb?
Or upgraded ubb version?
What else changed?
URL to site?

I suggest to open a ubb support ticket.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Mar 2007
Posts: 36
Likes: 1
B
BB
Offline
Newbie
Newbie
B Offline
Joined: Mar 2007
Posts: 36
Likes: 1
Here are the details:

Version of ubb? 7.5.7
Version of php? 5.4.8
Global Server settings? What are these?
Using mod security? No
New install of ubb? No
Or upgraded ubb version? No
What else changed? Nothing
URL to site? http://wordsmith.org/board

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
your config.inc.php has 'wordsmith' instead of the user ID ( 2 ) for the main admin id... not 'ID' and not 'name' in primary settings smile

so it has nothing to do with mysql. that is a valid error and it tells you what was wrong too wink


Joined: Mar 2007
Posts: 36
Likes: 1
B
BB
Offline
Newbie
Newbie
B Offline
Joined: Mar 2007
Posts: 36
Likes: 1
Not sure how the userid got changed, but thanks for catching it!


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
0 members (), 744 guests, and 147 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)