vb.org Archive - MySQL Error : Data too long for column 'useragent' at row 1

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - MySQL Error : Data too long for column 'useragent' at row 1 (https://vborg.vbsupport.ru/showthread.php?t=322775)

hakanyakar

06-04-2016 04:15 PM

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

Hello I moved my site new server but chrome database error

Code:

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

Quote:

Originally Posted by Dave (Post 2571646)

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

Code:

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

Quote:

Originally Posted by Lynne (Post 2571654)

(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

Quote:

Originally Posted by hakanyakar (Post 2571656)

ok very very thank you i fixed it but i have new problem vbseo new topic

Code:

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.

Quote:

Originally Posted by Paul M (Post 2571665)

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. :/

All times are GMT. The time now is 06:28 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01091 seconds Memory Usage 1,723KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: