Forums Index > Mewsoft Products > Classifiedawy > SQL Error: Column doesn't match value count at row 1
bilal First Post Posted on: 11-01-10 01:05 AM
SQL Error: Column doesn't match value count at row 1

Got the following when tried to load the data:

Loading table Ads_Categories...
File Size: 36306 Bytes
File: /home/bilal/public_html/cgi-bin/classified/data/database/Ads_Categories.sql.pm
Content-type: text/html

SQL Error: Column doesn't match value count at row 1
Query:
INSERT INTO Ads_Categories VALUES
('1','0','1','1','0','0','0','0','0','0',Icon-Announcement.gif',")
Line 886, File /home/bilal/public_html/cgi-bin/classified/DatabaseMgr.pm

I am using CalassfiedAwry 8.0. I did the fresh install...
mewsoft Reply #: 1 Posted on: 11-01-10 05:24 PM
Re: SQL Error: Column doesn't match value count at row 1

Be sure to download the latest version from our site, your My Account. Second, you need to delete all files under data/database from older versions, if you did new install, be sure to delete all previous versions files and delete all SQL tables before lading to the new version.

Mewsoft Support
www.mewsoft.com

bilal Reply #: 2 Posted on: 11-02-10 01:36 AM
Re: SQL Error: Column doesn't match value count at row 1

I didn't have any previous installation. I recently purchased the product and downloaded the software through My Account. This is the first time I installed the product.