PDA

View Full Version : MySQL error



susanth
10-27-2007, 03:32 PM
I installed the Webcards script through installatron months ago, and it's been running with no problems. Suddenly today I noticed that it's giving a MySql error when you try to go to the webcards page. This is the error:

*
MySQL said: Unknown column 'click_img' in 'field list'
Error number: 1054

The solutions below may help to resolve your error:

* Check your database settings in the configuration section.
* Ensure the database is switched on.


I know absolutely nothing about databases. I looked at the configuration section, but it looked ok, and I haven't changed anything. I've posted a message on the webcards forum, but I know from experience that I may never get an answer there, so I thought I would ask here. Can anyone tell me what the error means, and what to do about it?
Thanks

dbmasters
10-27-2007, 05:40 PM
It's just saying it's looking for a column in the database that isn't there...

susanth
10-27-2007, 06:15 PM
Ok. I looked at the tables in the database, and I don't see a column by that name. But, I don't understand why it's suddenly looking for something that has never been there. I haven't changed anything, and up until now the script hasn't had any problems. I wonder if I'm going to have to reinstall the darn thing.:confused: Maybe I'll just uninstall it and forget it; it's probably more trouble than it's worth. Thanks for your reply.

susanth
10-29-2007, 01:38 PM
I finally figured out what happened. Evidently I wasn't using the latest version, and the script was upgraded without my knowing it. I found the backup in itron backups today. I understand the reason, but it was very confusing...