New Fresh Install Error - INSERT INTO cp_categories

[Neal-UK]

Got this during the install, vB4 and PP Classifieds Beta:

Step 3: MySQL error reported: [INSERT INTO cp_categories VALUES (1,'Main','',1,'no',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'2',0,0,0,0,0,0,0,'no', 0, '', 'no', NULL, NULL,'','0','', 0);]
Result: Column count doesn't match value count at row 1
Database: ****************

Step 3: MySQL error reported: [INSERT INTO cp_categories VALUES (2,'A Category','Products of a particular type',1,'yes',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,'no', 0, '', 'no', NULL, NULL,'','0','', 0);]
Result: Column count doesn't match value count at row 1
Database: *************

[Chuck S]

Does this help making those two queries in install.php this

Content visible to verified customers only.

[Neal-UK]

I continued with the install and the software appears to be working. Am I best running the query manually via phpmyadmin now?

[Neal-UK]

Infact, my SEO settings are not working properly. I click SEO and the box below that to yes but both instances show yes and there's a black bar through something. SEO url's don't show when in my shop.

Image attached:

[Chuck S]

What is the actual url? Try running the upgrade script 3.2-4.0 upgrade

yes you could run those queries if you want or simply just create your own categories in admin.

[Neal-UK]

It's Main Index - Burnley Web Shop

[Neal-UK]

Doing the upgrade gave me:

PhotoPost Upgrade

Preparing to update database...

Error performing MySQL command: ALTER TABLE cp_categories ADD ugnopay VARCHAR(255) NULL AFTER ugnopost

Error: Duplicate column name 'ugnopay'

Upgrade complete!

[Neal-UK]

But the SEO is now working and the black line has gone.

[Chuck S]

Yes dont worry about duplicate errors. I have adjusted the install script to set spider setting to none not no like it was which is what the upgrades does