PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Photopost Pro Installation & Upgrades (http://www.photopost.com/forum/photopost-pro-installation-upgrades/)
-   -   Problems :) (http://www.photopost.com/forum/photopost-pro-installation-upgrades/139160-problems.html)

UnderEstimated February 6th, 2009 10:47 AM

Problems :)
 
I had some errors I accidently changed Database prefix in forum settings in ADMIN zone of photopost.

Now I can not access the photopost through my id. Please tell me how to change it back :)

Main Index - Friends Korner Urdu Photo Gallery

Chuck S February 6th, 2009 10:57 AM

Possibly use phpmyadmin and issue a query on your database to change it back to what it is?

UPDATE pp_settings SET setting='vb3_' WHERE id=83;

Make sure to put the proper prefix in the query above.

UnderEstimated February 6th, 2009 10:58 AM

If I dont have the prefix I leave it as is?

Because I tried vb_ this why all this happened.

Chuck S February 6th, 2009 11:03 AM

If you dont have a prefix then you take out what is between the '' correct

UPDATE pp_settings SET setting='' WHERE id=83;

UnderEstimated February 6th, 2009 11:06 AM

Ok that worked now I have these errors

Quote:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in [path]/photopost/pp-inc.php on line 4533

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in [path]/photopost/pp-inc.php on line 4402
It was all good until we moved to another server, and i Upgrade the forum to vBulletin 3.8.1

Chuck S February 6th, 2009 11:18 AM

Did you upgrade Photopost?

UnderEstimated February 6th, 2009 11:19 AM

Quote:

Originally Posted by Chuck S (Post 1240826)
Did you upgrade Photopost?

Yes I just did that too.

Chuck S February 6th, 2009 11:20 AM

Try this

REPAIR TABLE pp_iponline;

UnderEstimated February 6th, 2009 11:35 AM

First it says it is marked as crash.

Then in the end it says Table is already uptodate.

UnderEstimated February 6th, 2009 11:47 AM

But the error is still there :)

Chuck S February 6th, 2009 11:55 AM

Well there can only be two issues here.

1. The table is crashed and needs to be repaired.

2. You upgraded Photopost and did not run necessary upgrades.

I would still suspect number 1 though if it is marked crashed. Running that query should assist that issue.

Both your errors come from trying to query the iponline table.

UnderEstimated February 6th, 2009 11:58 AM

OK I run your query as well as I repaired database from cPanel too but still the problem is there. Any other suggestions?

Chuck S February 6th, 2009 12:04 PM

what version of the gallery where you running did you upgrade?

You can also in global options turn on debug option to display errors and while logged in as admin get the true error and post it here.

UnderEstimated February 6th, 2009 12:09 PM

As soon as I turned on debug options now all i see is repeated headers. Nothing else but headers and infinitly repeating.

http://www.friendskorner.com/forum/photopost/

Chuck S February 6th, 2009 12:49 PM

Yep your table is still crashed your repair did not work.

delete the iponline table and recreate it

Code:

Content visible to verified customers only.

UnderEstimated February 6th, 2009 01:06 PM

Artie that worked out perfectly. Thank You

Chuck S February 6th, 2009 01:43 PM

Have a good evening.


All times are GMT -5. The time now is 04:37 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