what are the table names for VBgallery?

voglermc · January 2nd, 2009, 02:34 PM

And what are the table names for Photopost pro?

Chuck S · January 2nd, 2009, 08:05 PM

If you view your database they would be the ones prefixed with the table prefix you specified in the config section in admin most likely pp_.

voglermc · January 2nd, 2009, 08:09 PM

I have
pp_
adv_
ppgal_

I'm trying to import from vbgallery to photopost 62

and then want to drop the old tables

Chuck S · January 2nd, 2009, 08:15 PM

Well photopost would most likely be pp_ and vbgallery ppgal_

voglermc · January 2nd, 2009, 08:19 PM

Thanks Chuck

If I moved the data folder from the vbgallery location to the PP location, would I be missing any files. This is after running the import script

All I'm seeing is missing thumbnails

Chuck S · January 2nd, 2009, 08:47 PM

If you specify the correct paths etc all photos should be transfered.

voglermc · January 2nd, 2009, 08:52 PM

I'm hoping so
I cant locate mogrify to rebuild thumbnails

Chuck S · January 2nd, 2009, 08:53 PM

There should be no need to rebuild thumbnails if the paths are correct.

voglermc · January 2nd, 2009, 09:17 PM

They are not showing
I'm guessing I need to rebuild or edit the database
I get an error when trying to do it in the admin area

voglermc · January 2nd, 2009, 09:24 PM

Thanks

Chuck S · January 3rd, 2009, 09:32 AM

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tarheelm/public_html/events_gallery/vbag.php on line 340
Importing 1 Categories.... please wait

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/tarheelm/public_html/events_gallery/vbag.php on line 348
Click here to import photos

You do not have the correct information in your import script.

voglermc · January 3rd, 2009, 09:34 AM

k
Thanks

Chuck S · January 3rd, 2009, 09:36 AM

You would need to specify the correct database info and table prefixes for the tables and thats why you get those mysql errors.

also note server paths are full server paths to the data and files subdirectories of both products.

voglermc · January 3rd, 2009, 09:40 AM

right
I had this fixed last night and now its all gone again since you ran that script

Is there any way to get it back?
The old vbgallery is gone

Chuck S · January 3rd, 2009, 09:42 AM

I never ran anything. I simply pulled up the link and saw those errors which told me your mistake.

what do you mean your old vbgallery is gone you cant import if it does not exist.

voglermc · January 3rd, 2009, 09:46 AM

When you ran that script again it did something to my install
I was moving images within categories using the admin area
Now all my info is gone, like it was reset

Once I had it fixed last night I got up this morning and removed vbgallery from the server

voglermc · January 3rd, 2009, 09:58 AM

It cleared all the categories in the DB

Chuck S · January 3rd, 2009, 10:04 AM

anyone can click public links you post here on the forum. I would suggest you restore database backups and redo the categories section again if everything else is fine.

voglermc · January 3rd, 2009, 10:05 AM

k thanks

Chuck S · January 3rd, 2009, 10:13 AM

Glad to assist.