AGSQL 3.1 MySQL Error Message? Please Help!

[c-lo]

Hey, 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]

Anybody?

[mikesouth]

What its telling you is that you aren't supplying enough values to fill the columns in the table

do an info columns on your ags_categories table and make sure that you are inserting a value for every column and that they are in the correct order

barring that ue this syntax and name your columns explicitly

REPLACE INTO ags_Categories (column1, column2, ...) VALUES ( 'Amateur', 'Pictures', ... )

[broke]

Post the table schema... might help.

[mikesouth]

This may also be giving you problems

'jpg,gif,jpeg,bmp,png'

those commas could be illegal characters or may need to be "escaped" one way to test that would be to replace them with spaces and try it

[c-lo]

mikesouth: I'll work on it tomorrow now that I understand it a little better. I find it odd that it would say that since the only thing I have done is edit the main options and tried to make categories. I haven't edited any of the code or anything...so that would lead me to believe it could be a problem with my sql database.

Anyway, I appreciate the advice, and I'll let ya know what it was when I get it figured out.

Thanks,
c-lo