vBGallery Upgrade Error on first page of import_photopost_vb35_5_1.php

[WeST]

I am trying to upgrade my Photopost 5.2.1 to vBGallery and I have ran into a problem. I just upgraded my PP from 4.7 to 5.2.1 so I am using the import_photopost_vb35_5_1.php script. When I goto the script I get the following error. What is my problem?

Database error in vBulletin 3.5.2:

Invalid SQL:
DELETE FROM adv_gallery_categories;

MySQL Error : Table 'photopost.adv_gallery_categories' doesn't exist
Error Number : 1146
Date : Sunday, December 18th 2005 @ 08:04:28 PM
Script : http://www.zilvia.net/import_photopost_vb35_5_1.php
Referrer :
IP Address : 67.161.140.218
Username : WeST
Classname : vb_database

[KW802]

Did you run the vbagallery_install.php script first?

[WeST]

Before the upgrade?

I installed vBGallery before trying to upgrade.

[WeST]

Any help on this? I need to get my Gallery running. Thanks!

[KW802]

WeST,

What exactly are you "upgrading" -- PhotoPost 5.2.1 and vBGallery are two totally different products. Are you converting from PhotoPost 5.2.1 to vBGallery or are you trying to upgrade one of those products?

[WeST]

Sorry, I am trying to import/convert Photopost 5.2.1 to vBGallery 1.01

[KW802]

And you're positive that you ran the "vbagallery_install.php" script first? That would've created the tables for you.

Do you have your PhotoPost settings in a different table then you do your vB3 settings?

[WeST]

I have vBGallery installed, if thats what your asking if I ran vbgallery_install.php.

Photopost and my vbgallery are in different databases. vBGallery installs them into your vBulletin forums database.

[WeST]

Any ideas?

[Chuck S]

Well Honestly I do not see how any of these imports worked.

For one it is assumed the photopost database is in the same database as vbgallery.

Next I see nowhere in the import script where this is defined so the script never knows what the tableprefix of photopost is.

{$Globals['pp_db_prefix']}

Basically as the script is now I would suggest you at the top of the script try adding this line and see if it works

require "pp-inc.php";

[WeST]

Its just giving me errors on the line that I add that. I tried a few varients to make sure, and all result in the same thing.

[Chuck S]

well if this import is outside photopost directory you need the path to it

require "/path/to/pp-inc.php";

[WeST]

Now I get this.

Fatal error: Cannot redeclare typecast() (previously declared in D:\inetpub\wwwroot\Zilvia.net\photo\pp-inc.php:33) in d:\inetpub\wwwroot\zilvia.net\photo\pp-inc.php on line 33

Line 33 of pp-inc.php is:

function typecast(&$passtype, $typelist) {

[Chuck S]

Nevermind remove my line I see the include to pp-inc.php

Use a default script and let's go from there

[Chuck S]

I would ask the same as Kevin has, Have you installed vbgallery?

This query tells me your gallery categories table does not exist

$db->query_write("DELETE FROM " . TABLE_PREFIX . "adv_gallery_categories");

I go to your site all I see is your forum and the hack VBpicsgallery

[WeST]

http://www.zilvia.net/photo/

http://www.zilvia.net/gallery/

[WeST]

I changed some settings in the PP settings and got to the 2nd step and this is what I got.


Gathering images (Page 1 of 7)...

Warning: copy(d:inetpubwwwrootzilvia.netphoto/data/503/368368daishin2.jpg): failed to open stream: No such file or directory in D:\inetpub\wwwroot\Zilvia.net\import_photopost_vb35_5_1.php on line 237

Warning: copy(d:inetpubwwwrootzilvia.netphoto/data/503/368368daishin2.jpg): failed to open stream: No such file or directory in D:\inetpub\wwwroot\Zilvia.net\import_photopost_vb35_5_1.php on line 238

Warning: copy(d:inetpubwwwrootzilvia.netphoto/data/503/thumbs/368368daishin2.jpg): failed to open stream: No such file or directory in D:\inetpub\wwwroot\Zilvia.net\import_photopost_vb35_5_1.php on line 245

Warning: copy(d:inetpubwwwrootzilvia.netphoto/data/503/368368n03.jpg): failed to open stream: No such file or directory in D:\inetpub\wwwroot\Zilvia.net\import_photopost_vb35_5_1.php on line 242

Warning: copy(d:inetpubwwwrootzilvia.netphoto/data/503/thumbs/368368n03.jpg): failed to open stream: No such file or directory in D:\inetpub\wwwroot\Zilvia.net\import_photopost_vb35_5_1.php on line 245

Warning: copy(d:inetpubwwwrootzilvia.netphoto/data/508/852852Z_Desktop1.jpg): failed to open stream: No such file or directory in D:\inetpub\wwwroot\Zilvia.net\import_photopost_vb35_5_1.php on line 237

[Chuck S]

Your not going to be able to import anything from a broken photopost I can tell you that. None of your images exist. Looks to me like you ran the 485 upgrade twice. You need to restore a backup photopost photos table and rerun the upgrade. Once you get photopost running correctly you can attempt an import

As far as the import script I did not write it but try switching the order like so

Content visible to verified customers only.

[WeST]

Ok, let me try that. Thanks!

[WeST]

Alright, well I tried a few more attempts of a backup with some luck. I never switched the order of the code you mentioned above however as im not 100% sure what im switching.

Anyways, Step one works (or so it looks like). Then it goes to the 2nd step where its importing images. After a long while it will finally show some images on the index of my vBGallery, here are the statistics.

Statistics Categories: 2, Images: 0, Posts: 0, Total Views: 948,770, Total Disk Space: 23.92 MB

Here is the correct stats:

Statistics
Users: 24,234
Photos: 3,076
Comments: 16,891
Views: 2,044,426
Disk Space: 483.8mb

It looks like the catagories dont import right for one, as well as only move over a select ammount of images/stats, etc.

I can leave the import script running on step 2 for over an hour and the stats are still the same as mentinoed above.

Thanks for your help!