Mysql Error When Adding Categories in AGSQL 3.1. Please Help - GoFuckYourself.com

c-lo · 01-29-2006, 08:13 PM

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 · 01-31-2006, 12:32 AM

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 · 01-31-2006, 12:33 AM

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

everestcash · 02-01-2006, 04:22 PM

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

01-29-2006, 08:13 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	Mysql Error When Adding Categories in AGSQL 3.1. Please Help 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 __________________ The AlphaPhaze Network Traffic & Hardlink Trades \| Sponsors \| Resources The adult marketing network you can trust

01-31-2006, 12:32 AM	#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	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 __________________ The AlphaPhaze Network Traffic & Hardlink Trades \| Sponsors \| Resources The adult marketing network you can trust

02-01-2006, 04:22 PM	#4
everestcash Confirmed User Join Date: Apr 2002 Posts: 2,194	Try to google this query, but looks like it has to do with a script upgrade, usually. __________________ Got solo girls/teen traffic? Promote our exclusive solo girl sites and boost your income!

01-31-2006, 12:33 AM	#3
c-lo Confirmed User Join Date: May 2005 Location: On search pages, on ICQ @ 308 7 43669, and in the U.S. Posts: 925	I just noticed the replies to this thread are missing. Strange...must be due to the forum upgrade...