admin cannot login after upgrade to 511

[VIPHOSTZONE]

can you please help with this

cannot login after upgrade

errors:

1.

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /xyz/blablabla/blabalahtml/pp-inc.php on line 2879

2. An error was encountered during execution of the query:

SELECT id,ugnoupload,ugnoanno,ugnoview,ugnopost,ugnovote,password,watermark,cattype,ismember,catname,parent,children,thumbs,canzip,moderators,header,footer,headtags FROM categories

The query returned with an errorcode of:

Unknown column 'ismember' in 'field list'

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.

3. An error was encountered during execution of the query:

SELECT c.id,
c.catname,
c.description,
c.catorder,
c.parent,
c.thumbs,
c.children,
c.photos,
c.posts,
c.catdepth,
c.cattype,
c.ismember,
c.thumbnail,
p.id,
p.bigimage,
p.cat,
p.approved,
p.user,
p.userid,
p.date,
p.width,
p.height,
p2.bigimage,
p2.cat,
p2.storecat,
p2.userid,
p2.width,
p2.height,
com.username,
com.id,
com.date,
com.photo
FROM categories c
LEFT JOIN photos p ON c.lastphoto=p.id
LEFT JOIN photos p2 ON c.thumbnail=p2.id
LEFT JOIN comments com ON com.id=c.lastpost
ORDER BY c.catorder ASC

The query returned with an errorcode of:

Unknown column 'c.ismember' in 'field list'

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.


thanks

[Chuck S]

Please make sure you run the upgrade script and any necessary upgrades from the latest version you where running. You missed the upgrade from 5.0 to 5.1

[VIPHOSTZONE]

Originally Posted by omegatron

Please make sure you run the upgrade script and any necessary upgrades from the latest version you where running. You missed the upgrade from 5.0 to 5.1

thanks for reply

we move site to new host.
we change patch in config-inc.php
upload uor backup from old host
then upload new 5.1.1 script

our prev version is
// PhotoPost Pro Version Number
$VERSION = "5.02";

now we cannot login and there are two errors:

1. Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /blabla/blabla/blablahtml/pp-inc.php on line 2879

2. Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /blabla/blabla/blablahtml/pp-inc.php on line 765


http://www.viphostzone.com/

thanks for help in advance !

[Chuck S]

Please follow the upgrade instructions in the documentation folder and run the upgrade.php script as I stated above running any applicable upgrades you need to run so in your case run these

5.0-5.1
5.1-5.11

[VIPHOSTZONE]

Originally Posted by omegatron

Please follow the upgrade instructions in the documentation folder and run the upgrade.php script as I stated above running any applicable upgrades you need to run so in your case run these

5.0-5.1
5.1-5.11

ok - we erase all, restore site from backup (all works, great),

then upload over version 5.11...
then visit upgrade.php
all ok

but again - admin cannot login...

and get again this errors:

1.On main page:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /blablabla/pp-inc.php on line 2879



2. after admin login:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /blablabla/pp-inc.php on line 2879

Warning: Cannot modify header information - headers already sent by (output started at /blablabla/pp-inc.php:2879) in /blablabla/forums/photopost.php on line 155

Warning: Cannot modify header information - headers already sent by (output started at /blablabla/pp-inc.php:2879) in /blablabla/forums/photopost.php on line 157


Login Successful!

Click here if you do not want to wait any longer
(or if your browser does not automatically forward you)

.....
redirect back to index.php



so - where is error?


thank you in advance

[Chuck S]

As I have stated have your run the upgrade script per the upgrade instructions?

These mysql errors come from not running the upgrade. Line 2879 of pp-inc.php is the last line below which means the query is invalid

Content visible to verified customers only.

[VIPHOSTZONE]

Originally Posted by omegatron

As I have stated have your run the upgrade script per the upgrade instructions?

These mysql errors come from not running the upgrade. Line 2879 of pp-inc.php is the last line below which means the query is invalid

Content visible to verified customers only.

yes - we make upgrade twice
so now we restore back to version 5.02 and waiting for news :-)

another question - it is possible make clean install 5.11 and then import old data folder?

[Chuck S]

You need to run both the 5.0-5.1 and 5.1-5.11 upgrades

That query explicitly tells me your missing the field from the categories table ismember and album fields

[VIPHOSTZONE]

Originally Posted by omegatron

You need to run both the 5.0-5.1 and 5.1-5.11 upgrades

That query explicitly tells me your missing the field from the categories table ismember and album fields

ok - site restored back to 5.02 - all works great on new host.

hmm..
but where and how we can lost this tables if we press only upgrade.php ?

[Chuck S]

You must run the upgrade script and select the two upgrades from it and run them both to upgrade. The error your showing us says you have not done so.

[VIPHOSTZONE]

Originally Posted by omegatron

You must run the upgrade script and select the two upgrades from it and run them both to upgrade. The error your showing us says you have not done so.

ok, thanks
we'll try again tomorrow

[VIPHOSTZONE]

Originally Posted by omegatron

You must run the upgrade script and select the two upgrades from it and run them both to upgrade. The error your showing us says you have not done so.

we run all stages of upgrade - i'm hope we not beginners - so we all do correct.

maybe we found where error is.

one from our free/trial users from India or something else post a photos with names and description in non-latin characters - we delete this account 2-3 months back, but as we see because user use non-latin characters our mysql db and data folder is destroyed.

so now we needed manually check data folder and mysql db for any non-latin characters

we post result here later

[Chuck S]

ah there ya go you never meantioned a corrupt database.

[VIPHOSTZONE]

Originally Posted by omegatron

ah there ya go you never meantioned a corrupt database.

all ok now

all this because no link in upgrade.php version 5.02 > 5.11

[Chuck S]

So you did not have the proper upgrade script uploaded.

[jribz]

Actually, Omega, I just downloaded the upgrade script in the members area and there is no 5.02 to 5.11 script link in it either. It's in the latest download version.

[Michael P]

You want the Upgrade 5.0x link (which means 5.01 or 5.02, etc).

[jribz]

OK thanks Michael.