Widget error on mysql

Asked by:
glocon / 8 Points
Time:
2013-01-30 8:47 am EST
Category:
Website Troubleshooting
Hits:
251
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.

To ask this user for more information, please first login.

To submit an answer, please login.

ANSWERS

0

ScottM
Staff
13,342 Points
2013-01-30 10:54 am EST
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

To submit a comment on this answer, please first login.

Want to share this Question?

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!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.