PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Classifieds Installation & Upgrades (http://www.photopost.com/forum/classifieds-installation-upgrades/)
-   -   Errors on upgrade (http://www.photopost.com/forum/classifieds-installation-upgrades/145204-errors-upgrade.html)

Geiri January 27th, 2011 10:08 AM

Errors on upgrade
 
My config tels me I am running

// PhotoPost Classifieds Pro Version Number
$VERSION = "3.1";

So I started from there I get this errors

Error performing MySQL command: REPLACE INTO cp_settings VALUES (84,'PhotoPost Classifieds Version','pversion','4.0',53,0);
Error: Column count doesn't match value count at row 1

Chuck S January 27th, 2011 11:18 AM

You are on a later version of the software then. Is everything fine after running the upgrades forward?

Your config will not be updated ever unless you actually update it in admin so 3.1 could have been the version you started with.

Geiri January 27th, 2011 12:03 PM

I get errors through out the upgrade process.

This are the db tables I have
cp_admingroups
cp_admlog
cp_adtypes
cp_bidding
cp_bids
cp_board
cp_buddies
cp_cache
cp_captcha
cp_categories
cp_comments
cp_currency
cp_extrafields
cp_favorites
cp_feedback
cp_invites
cp_ipcache
cp_iponline
cp_laston
cp_messages
cp_notify
cp_paid_subscriptions
cp_payments
cp_productextras
cp_products
cp_searchids
cp_settings
cp_sort
cp_stats
cp_subscriptions
cp_usergroups
cp_users

No tables are added in the upgrade process not lang and phrases
Some errors are
Error: Table 'geirinn.cp_phrases' doesn't exist
Error: Duplicate column name 'ugnopay'
Error: Column count doesn't match value count at row 1

I can't see current version number in cp_settings table

Chuck S January 27th, 2011 12:17 PM

If your running the proper upgrades tables should be added.

Duplicates are no problem it just means you ran them before so they exist and since you ran certain things before you can not add options that already exist or dont match a row count since things change on upgrade

Your actually running version 3.0 database thats when phrases was added so run 3.0 forward and see where your at.

Chuck S January 27th, 2011 12:22 PM

Do not run the 3.1-3.2 upgrade more than once. With your errors looks to me like you skipped over some upgrades and ran newer ones which of course are going to give you issues if you do not do things in the proper order. Thats why you always need to know what version your on.

Geiri January 27th, 2011 12:24 PM

Aa that was it ;) upgrade went fine after that.

Now.... was there a way to import lang strings from the lang file?

Chuck S January 27th, 2011 12:26 PM

Did we not just cover this in another thread?

http://www.photopost.com/forum/revie...-language.html

Geiri January 27th, 2011 12:30 PM

Yes, I think you are right. I decided then not to upgrade it was to much work at the time.

you still got good memory, old man :)

Chuck S January 27th, 2011 01:02 PM

yeah it is surprising with the multitude of things I deal with daily it can get hard to keep issues from blurring together but I try. ;)

Geiri January 27th, 2011 01:28 PM

I bet :) I have a small problem I think we have solved before...

When I have translated page one page I am redirected to the search for new word...
I would like to go to next page and keep on translating ...

I think we solved this some how in review post...

Chuck S January 27th, 2011 01:34 PM

I will look and let you know

Chuck S January 27th, 2011 01:39 PM

Line 550 of adm-lang.php should be this

Code:

Content visible to verified customers only.

Geiri January 27th, 2011 03:32 PM

:) excellent

Chuck S January 27th, 2011 04:42 PM

Enjoy the upcoming weekend. Few days of snow here kids out of school so its a super long weekend end here still waiting to see if no school tomorow.

Geiri January 27th, 2011 06:26 PM

Thank you I will, and same to you Chuck

I canīt say that I have seen snow this winter here in Reykjavik we have had extremely mild weather well above the +

This image was taken outside my house last weekend, Christmas lights still up. :)
Code:

Content visible to verified customers only.

Chuck S January 27th, 2011 06:36 PM

Yeah cold here in the teens and snow quite a few times already have a total of about 16 inches right now.


All times are GMT -5. The time now is 10:21 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


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