Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 04 Jun 2016, 19:15
hakanyakar hakanyakar is offline
 
Join Date: Mar 2011
MySQL Error : Data too long for column 'useragent' at row 1

Hello I moved my site new server but chrome database error


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

how fix help me please
Reply With Quote
  #2  
Old 04 Jun 2016, 19:52
Dave Dave is online now
 
Join Date: Jun 2010
Real name: Dave
Increase the size of the useragent column in the session table.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #3  
Old 04 Jun 2016, 20:28
hakanyakar hakanyakar is offline
 
Join Date: Mar 2011
Originally Posted by Dave View Post
Increase the size of the useragent column in the session table.
how can I do it can you help me please ?
Reply With Quote
  #4  
Old 05 Jun 2016, 02:27
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
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.)
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #5  
Old 05 Jun 2016, 09:01
hakanyakar hakanyakar is offline
 
Join Date: Mar 2011
ok very very thank you i fixed it but i have new problem vbseo new topic


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

i did vbseo unistall and again install but not fix
Reply With Quote
  #6  
Old 05 Jun 2016, 15:20
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by Lynne View Post
(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.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #7  
Old 05 Jun 2016, 18:50
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Originally Posted by hakanyakar View Post
ok very very thank you i fixed it but i have new problem vbseo new topic


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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

Originally Posted by Paul M View Post
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. :/
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
[HowTo] Store USERAGENT and ALTIP in posts Floris vBulletin 3.0 Full Releases 19 19 May 2005 01:46
Show UserAgent in Who`s Online ian@TS vBulletin 2.x Beta Releases 6 06 Aug 2003 20:00



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 16:21.

Layout Options | Width: Wide Color: