Errors on upgrade

Geiri · January 27th, 2011, 10:08 AM

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?

How can I export language

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.