PhotoPost Community - New Fresh Install Error

PhotoPost Community (http://www.photopost.com/forum/)

- Classifieds Installation & Upgrades (http://www.photopost.com/forum/classifieds-installation-upgrades/)

- - New Fresh Install Error - INSERT INTO cp_categories (http://www.photopost.com/forum/classifieds-installation-upgrades/141450-new-fresh-install-error-insert-into-cp_categories.html)

Neal-UK

December 22nd, 2009 09:26 AM

New Fresh Install Error - INSERT INTO cp_categories

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

Quote:

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

December 22nd, 2009 09:37 AM

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

Code:

Content visible to verified customers only.

Neal-UK

December 22nd, 2009 09:42 AM

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

Neal-UK

December 22nd, 2009 09:50 AM

1 Attachment(s)

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

December 22nd, 2009 10:06 AM

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

December 22nd, 2009 10:08 AM

It's Main Index - Burnley Web Shop

Neal-UK

December 22nd, 2009 10:10 AM

Doing the upgrade gave me:

Quote:

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

December 22nd, 2009 10:13 AM

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

Chuck S

December 22nd, 2009 11:50 AM

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 ;)

All times are GMT -5. The time now is 04:43 AM.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97