PDA

View Full Version : MySQL Error : Data too long for column 'useragent' at row 1

hakanyakar
06-04-2016, 04:15 PM
Hello I moved my site new server but chrome database error


Database error in vBulletin 3.8.8:

Invalid SQL:

UPDATE session
SET lastactivity = 1465047282, location = '/', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0, useragent = 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.102 Safari/537.36'

MySQL Error : Data too long for column 'useragent' at row 1
Error Number : 1406


how fix help me please
Dave
06-04-2016, 04:52 PM
Increase the size of the useragent column in the session table.
hakanyakar
06-04-2016, 05:28 PM
Increase the size of the useragent column in the session table.

how can I do it can you help me please ?
Lynne
06-04-2016, 11:27 PM
Use a tool like phpMyAdmin that your host supplies to you. Then go to the session table and click Structure (very top tab) and then click Change next to the useragent column and change it. (There is no useragent column in default vbulletin, so I can't tell you exactly what to change as I don't have that column.)
hakanyakar
06-05-2016, 06:01 AM
ok very very thank you i fixed it but i have new problem vbseo new topic


Database error in vBulletin 3.8.8:

Invalid SQL:
INSERT INTO vbseo_serviceupdate
(s_threadid, s_updated)
VALUES
('70181', 0);

MySQL Error : Field 's_dateline' doesn't have a default value
Error Number : 1364


i did vbseo unistall and again install but not fix
Paul M
06-05-2016, 12:20 PM
(There is no useragent column in default vbulletin, so I can't tell you exactly what to change as I don't have that column.)
I dont know what version you are running, but the session table has had a useragent column in all 3.x.x versions.

Its default size was 100, in 3.8.9 its updated to vchar 255.
Lynne
06-05-2016, 03:50 PM
ok very very thank you i fixed it but i have new problem vbseo new topic


Database error in vBulletin 3.8.8:

Invalid SQL:
INSERT INTO vbseo_serviceupdate
(s_threadid, s_updated)
VALUES
('70181', 0);

MySQL Error : Field 's_dateline' doesn't have a default value
Error Number : 1364


i did vbseo unistall and again install but not fix
You will need to ask the developer for help fixing this error.

I dont know what version you are running, but the session table has had a useragent column in all 3.x.x versions.

Its default size was 100, in 3.8.9 its updated to vchar 255.
Hmmm, I'm not sure how I missed it. :/