PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Photopost Pro Installation & Upgrades (http://www.photopost.com/forum/photopost-pro-installation-upgrades/)
-   -   Upgrade error - MySQL in pp-inc.php line 4153 and no admin permissions (http://www.photopost.com/forum/photopost-pro-installation-upgrades/137859-upgrade-error-mysql-pp-inc-php-line-4153-no-admin-permissions.html)

jamesfrost September 11th, 2008 09:40 AM

Upgrade error - MySQL in pp-inc.php line 4153 and no admin permissions
 
Hi,

After upgrading from Photopost Pro 5.3 to the latest version (running with vBulletin 3.6.8PL2) we have an error on all pages of the gallery:

Quote:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/maplanet/public_html/photos/pp-inc.php on line 4153
While all comments and photo data is correct no photos are showing (though they are on the server) with an additional error on photo pages (showphoto.php):

Quote:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/maplanet/public_html/photos/showphoto.php on line 160
On top of that, when navigating to the adm-index page I get "You are not a valid administrator or moderator!" even though I have all admin permissions for the site.

If you wish to see for yourself, our Photopost install is at Main Index - Martial Arts Planet Photo Gallery

Any help would be brilliant :)

Chuck S September 11th, 2008 07:06 PM

Looks to me like you have not ran all your required upgrades. Please upload the upgrade script and run the upgrades from your version forward

jamesfrost September 12th, 2008 09:04 AM

I ran the upgrade script from version 5.3 (what I believe was running before the upgrade) to the latest version. I've just taken over responsibility for our gallery so theres a good chance that, while the 5.3 files were on the server, our last full upgrade was in June 2004 (:eek: ).

Would running the upgrade script from 4.82 cause any damage?

Chuck S September 12th, 2008 05:44 PM

I would suggest running the script from 5.0 forward do not do 4.85 as if you run that more then once you can mess things up but looks like I spoke too late

You need to restore a backup of your database and start over with the upgrade at the proper place and only do things once.


All times are GMT -5. The time now is 10:32 PM.

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