Community Q&A:
Widget error on mysql
I have recently installed a classified ads script. But when I click on the widget link, the following error occur:
A Database Error Occurred
Error Number: 1366
Incorrect string value: '\xE1rea d...' for column 'description' at row 1
INSERT INTO `default_widgets` (`title`, `slug`, `description`, `author`, `website`, `version`, `enabled`, `order`, `updated_on`) VALUES ('a:3:{s:2:\"en\";s:10:\"Event List\";s:2:\"es\";s:16:\"Lista de eventos\";s:2:\"fr\";s:34:\"Liste des événements\";}', 'event_list', 'a:3:{s:2:\"en\";s:38:\"List upcoming events in a widget area.\";s:2:\"es\";s:36:\"Listar eventos en un ?rea de widget.\";s:2:\"fr\";s:71:\"Liste des événements à venir dans une zone widget.\";}', 'Verge Team', 'http://www.verge.in', '1.0', 1, 11, 1359578102)
Filename: /home/pabili5/public_html/modules/widgets/models/widget_m.php
Line Number: 170
***************************
I really wonder why this error appears when installed to webhostinghub when this same php script works well in another service provider.
Can anyone help me resolve this? I am not a php script wizard to be honest with you. I just bought the classified ads script - ClassifiedScript by http://buyclassifiedscript.com/
The link to problem:
http://pabili.biz/admin/widgets
The link that works well:
http://katribu.net/admin/widgets
Thank you.
A Database Error Occurred
Error Number: 1366
Incorrect string value: '\xE1rea d...' for column 'description' at row 1
INSERT INTO `default_widgets` (`title`, `slug`, `description`, `author`, `website`, `version`, `enabled`, `order`, `updated_on`) VALUES ('a:3:{s:2:\"en\";s:10:\"Event List\";s:2:\"es\";s:16:\"Lista de eventos\";s:2:\"fr\";s:34:\"Liste des événements\";}', 'event_list', 'a:3:{s:2:\"en\";s:38:\"List upcoming events in a widget area.\";s:2:\"es\";s:36:\"Listar eventos en un ?rea de widget.\";s:2:\"fr\";s:71:\"Liste des événements à venir dans une zone widget.\";}', 'Verge Team', 'http://www.verge.in', '1.0', 1, 11, 1359578102)
Filename: /home/pabili5/public_html/modules/widgets/models/widget_m.php
Line Number: 170
***************************
I really wonder why this error appears when installed to webhostinghub when this same php script works well in another service provider.
Can anyone help me resolve this? I am not a php script wizard to be honest with you. I just bought the classified ads script - ClassifiedScript by http://buyclassifiedscript.com/
The link to problem:
http://pabili.biz/admin/widgets
The link that works well:
http://katribu.net/admin/widgets
Thank you.
ANSWERS
|
0
|
Hello glocon, The error you saw is a MySQL error. This particular error occurs when a string is using a character that will not properly match the database or table collation. Typically. UTF-8 is the most permissive. I checked and did see that the database and tables were UTF-8. I also see the particular character it failed on was Á. I replaced it in your Query and it added to the database as it should. The server and MySQL accepted it without issue. The only explanation would be that there was an anomaly in the widget code when it initially created the string and tried to add it to the database. Best Regards, Scott M |
Want to share this Question?
Tweet
Help Center Login
Related Articles
It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
