MySQL error reported - New Install

DHewes · February 5th, 2010, 03:19 PM

Installing Classifieds (final release 4) into same database of vB 4 CMS suite, completely clean install (all tables from previous install dropped) getting this on Step 3. I have wipped database twice and tried again, same error.

Step 3: MySQL error reported: [INSERT INTO PPC_stats VALUES (1, 0, 0, 0)]
Result: Column count doesn't match value count at row 1
Database: mysite_db

DHewes · February 5th, 2010, 03:34 PM

OK, thinking that something with vB may be conflicting I created a new, clean DB dedicated for just Classifieds and got the exact same error.

Chuck S · February 5th, 2010, 03:48 PM

The query in install.php should be this

Code:

Content visible to verified customers only.

DHewes · February 5th, 2010, 03:59 PM

That fixed it - thanks.

Chuck S · February 5th, 2010, 06:09 PM

enjoy your evening

Omar Al-Ansari · February 5th, 2010, 06:38 PM

Quote:

Originally Posted by Chuck S

The query in install.php should be this

Code:

Content visible to verified customers only.

I am doing a fresh install and I got the same error and the solution was perfect. However I had to edit it in the install.php

I think you guys have missed the last "zero"

just to make sure this is being fixed.

Chuck S · February 5th, 2010, 06:45 PM

As with any error here you can always redownload the build because anything reported and fixed here would be included.