Problems :)

UnderEstimated · February 6th, 2009, 10:47 AM

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

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.