I screwed up and deleted the pp_ in the adm-index

[steve worcester]

What was I thinking, I didn't know any better.
Now I can't get into the admin control panel.

If I go to the main photopost page, I get

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/content/a/a/w/*domain_name*/html/photopost/pp-inc.php on line 1148

and if I go to the adm-index I get


Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/content/a/a/w/*domain_name*/html/photopost/forums/vb3.php on line 426

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/content/a/a/w/*domain_name*/html/photopost/pp-inc.php on line 3944

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/content/a/a/w/*domain_name*/html/photopost/forums/vb3.php on line 426

Am I totally hosed?

[Chuck S]

Looks to me like you deleted your forum table prefix

You would either need to rerun install.php or go in and physically update the proper fields in the photopost settings mysql table with the right info

[steve worcester]

THANXZ! That fixed the admin stuff. I can get there now.

I moved the photos over from the old photopost forum, they were in the /500 directory, can they be imported and thumbnails generated?

Also, now in the adm-index, if I go to all options, I get
Warning: opendir(/home/content/a/a/w/mydomain/html/photopost/stylesheets): failed to open dir: Permission denied in /home/content/a/a/w/mydomain/html/photopost/adm-misc.php on line 3227

Warning: readdir(): supplied argument is not a valid Directory resource in /home/content/a/a/w/mydomain/html/photopost/adm-misc.php on line 3232

Warning: closedir(): supplied argument is not a valid Directory resource in /home/content/a/a/w/mydomain/html/photopost/adm-misc.php on line 3246

Again, thanks for assist

[Chuck S]

Your host needs to set your permissions to 755 on your stylesheets directory we can not correct that with the permissions given to us

As far as importing photos that would depend what you did when you moved. If you moved things correctly you would have transfered the database tables and data directory and then things would be there so obviously the database table is missing try restoring the photos comments and categories tables from your previous install and then we can see about getting photos back. I had also noted you should be purchasing an install not upgrade. Not much else I can do to assist with that service until that is straightened out

[steve worcester]

If I browse the data, it is in the tables in comments and categories. We will work on the rest.

[Chuck S]

Okay yeah you need to get that photos table imported

[steve worcester]

(got the permissions changed and the error vanished)
I went to vBulletin, exported my 'photos' table, then went to the php admin on the new site, imported the table. Now I am guessing I have something else to do in photopost, 'cause I don't see the imported photos.

[Chuck S]

well the key is did you delete the photos table in the photopost photos table and then import that old photos table to the photopost database?

Cause if you do not see photos you did not do so

[steve worcester]

I should clear the table in the new database and then import the old one?

Here is what I tried.
In the old database, from vBulletin, exported the table 'photos'. Went to the phpadmin on the new database and emptyed the same table. I then imported the old table.

I can go into the new database and see it contains the data I want, but I don't see the old photos in the gallery, I only see the 'new' ones.

Am I missing a step, a refresh, a re-syncing? Is there more than one associated table I should be re-importing?

(Thank you for your continued patience as I learn)

[Chuck S]

I already answered you via email lets keep this discussion in one place