AGSQL 3.1 MySQL Error Message? Please Help! - GoFuckYourself.com

c-lo · 01-29-2006, 06:48 PM

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 · 01-29-2006, 07:30 PM

Anybody?

mikesouth · 01-29-2006, 08:38 PM

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 · 01-29-2006, 08:45 PM

Post the table schema... might help.

mikesouth · 01-29-2006, 08:49 PM

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 · 01-29-2006, 11:33 PM

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

01-29-2006, 06:48 PM	#1
c-lo Confirmed User Join Date: May 2005 Location: On search pages, on ICQ @ 308 7 43669, and in the U.S. Posts: 925	AGSQL 3.1 MySQL Error Message? Please Help! 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 __________________ The AlphaPhaze Network Traffic & Hardlink Trades \| Sponsors \| Resources The adult marketing network you can trust

01-29-2006, 07:30 PM	#2
c-lo Confirmed User Join Date: May 2005 Location: On search pages, on ICQ @ 308 7 43669, and in the U.S. Posts: 925	Anybody? __________________ The AlphaPhaze Network Traffic & Hardlink Trades \| Sponsors \| Resources The adult marketing network you can trust

01-29-2006, 08:38 PM	#3
mikesouth Confirmed User Industry Role: Join Date: Jun 2003 Location: My High Horse Posts: 6,334	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', ... ) __________________ Mike South It's No wonder I took up drugs and alcohol, it's the only way I could dumb myself down enough to cope with the morons in this biz.

01-29-2006, 08:45 PM	#4
broke Confirmed User Join Date: Aug 2003 Location: Someplace Windy Posts: 4,501	Post the table schema... might help. __________________ Perfect Gonzo

01-29-2006, 08:49 PM	#5
mikesouth Confirmed User Industry Role: Join Date: Jun 2003 Location: My High Horse Posts: 6,334	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 __________________ Mike South It's No wonder I took up drugs and alcohol, it's the only way I could dumb myself down enough to cope with the morons in this biz.

01-29-2006, 11:33 PM	#6
c-lo Confirmed User Join Date: May 2005 Location: On search pages, on ICQ @ 308 7 43669, and in the U.S. Posts: 925	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 __________________ The AlphaPhaze Network Traffic & Hardlink Trades \| Sponsors \| Resources The adult marketing network you can trust