If you are not registered or logged in, you may still use these forums but with limited features. Show recent topics
  [Search] Search   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [FAQ]  FAQ 
[Register] Register / 
[Login] Login 
Error 1406  XML
Forum Index » Advanced Guestbook Forum
Author Message
Kees van der Sar
Newbie

Joined: 08/02/2006 22:36:28
Messages: 2
Offline

Hello,

I installed Advanced Guest Book. All seems fine, but I get an error after adding an entry. I got:

1406 Data too long for column 'browser' at row 1

I filled in every field, pressed Submit and got this error.

What is wrong?

Thanks for your help.
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

The browsers useragent field was only given 100 characters and unfortunately some (Internet Explorer) now uses more.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
Kees van der Sar
Newbie

Joined: 08/02/2006 22:36:28
Messages: 2
Offline

Is there a way to resolve this? If so, what can I do?

Thanks for your reply.
pwheeler
Newbie

Joined: 13/10/2009 15:50:04
Messages: 3
Offline

Hi,

Sorry to dig this thread up but I am getting the same problem.

I have been using the advanced guestbook for years with no problems. I have just moved it to a new hosting server and I am now getting this error 1406 issue.

I have tried reinstalling the latest version, but it made no difference.

This is the link to the guestbook:

http://www.willowdene.greenwich.sch.uk/gbookphp/

Is there any resolution?

Thanks

Paul
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

Do you have phpMyAdmin (usually in cPanel) and if so do you know how to use it?

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
pwheeler
Newbie

Joined: 13/10/2009 15:50:04
Messages: 3
Offline

I do have phpmyadmin. If used it a couple of times before to reset the admin password.

Any help would be appreciated.

Thanks

Paul
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

Once in phpMyAdmin find the book_data table. Change the browser field so that it is 200 instead of the 100 it currently is.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
pwheeler
Newbie

Joined: 13/10/2009 15:50:04
Messages: 3
Offline

That fixed it!

Thanks very much for the swift support

Paul
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

Wonder how much crap you have to install to make the useragent go over 100 characters though

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
786sujit
Beginner
[Avatar]

Joined: 27/10/2015 19:37:54
Messages: 16
Offline

I too getting same error 1406 but for Advanced Poll v 2.09. pls refer attachment for both the errors.

It happens when I input the text in hindi (Indian language) font.

If I enter hindi text in question field and submit, I get this error :- Error Number: 1406 Data too long for column 'question' at row 1

& When I enter hindi text in option field and submit, I get this error :- Error Number: 1406 Data too long for column 'option_text' at row 1

pls guide.
[Thumb - Advanced poll error 1.jpg]
 Filename Advanced poll error 1.jpg [Disk] Download
 Description
 Filesize 95 Kbytes
 Downloaded:  1 time(s)

This message was edited 3 times. Last update was at 16/10/2016 17:45:23

 
Forum Index » Advanced Guestbook Forum
Go to:   
Based on the open source JForum