Mysql Error When Adding Categories in AGSQL 3.1. Please Help

[c-lo]

Well I posted this in the main forum, but to no avail. So I'm hoping I'll have better luck here.

I started working on my new tgp tonight and have run into a problem. When I try to add categories in AGSQL I get this message:


MySQL Error
Error
Column count doesn't match value count at row 1

Query
REPLACE INTO ags_Categories VALUES ( 'Amateur', 'Pictures', 'jpg,gif,jpeg,bmp,png', '', '10', '', '20', '', '20000', '', '-1', '-1' )



I don't know what to do to fix this. Can anyone help me out here? I would ask jmbsoft, but they take 24 - 48 hours to reply (now that my priority support has expired.)

I would greatly appreciate any help, or even a link to an article that could possibly diagnose this.

Thanks,
c-lo

[c-lo]

Well, I believe the problem had something to do with having AGSQL 3.5 previously installed and using the same mysql database. I created a new database and it's working fine. Thanks for the help, though. Quite appreciated.

later
c-lo

[c-lo]

I just noticed the replies to this thread are missing. Strange...must be due to the forum upgrade...

[everestcash]

Try to google this query, but looks like it has to do with a script upgrade, usually.