PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > vBGallery Support > vBGallery Import Scripts

vBGallery Import Scripts Here you will find import scripts to help convert your existing gallery to PhotoPost vBGallery.

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old July 5th, 2009, 09:49 PM   #1 (permalink)
Junior Member
Verified Customer
 
Join Date: Mar 2009
Posts: 1
DB Error importalbums.php

when i run the importalbums.php script i get the following error.

Database error in vBulletin 3.8.1:

Invalid SQL:
INSERT INTO vb_ppgal_posts (title,userid,username,dateline,pagetext,imageid,visible,allowsmilie,ipaddress,importpostid)
VALUES('', 397, 'D'Vine', 1243960905, 'Thanks even though I don\'t think the porportions work in my favor in this picture....but hell its recent!', 2076, 1, 1, '161.150.2.58', 108 );

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Vine', 1243960905, 'Thanks even though I don\'t think the porportions work in my' at line 2
Error Number : 1064
Request Date : Sunday, July 5th 2009 @ 09:45:18 PM
Error Date : Sunday, July 5th 2009 @ 09:45:19 PM
Script : Log in - EB - vBulletin Admin Control Panel
Referrer : Log in - EB - vBulletin Admin Control Panel
IP Address :
Username : Admin
Classname : vB_Database
MySQL Version : 5.0.45
jboyd is offline   Reply With Quote
Old July 6th, 2009, 06:59 AM   #2 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,654
At around line 325 of that script add the line in bold

Code:
Content visible to verified customers only.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old March 20th, 2011, 02:25 AM   #3 (permalink)
Junior Member
Verified Customer
 
Join Date: Mar 2011
Posts: 10
Hi Chuck,

Recently installed VBGallery in my forum. Was trying to import all the old pics from VB Albums but had the same error as in this post. I've corrected the line you said but once again it got stopped with another SQL Error:

Code:
Content visible to verified customers only.
Hope you can help me to know what's wrong with it.

Thanks

Eduardo
EduFabbri is offline   Reply With Quote
Old March 20th, 2011, 10:15 AM   #4 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,654
what specific script is this? This is a 2 year old thread here. There is no such supported scripting linked in our download area.

There is no official product support for such a script so my suggestion would be to post in whatever thread you found this script for assistance. Your issue is your category id is empty and you would need to find out why.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old March 20th, 2011, 01:21 PM   #5 (permalink)
Junior Member
Verified Customer
 
Join Date: Mar 2011
Posts: 10
Hi Chuck,

The script is the one you include within the "admincp" folder of the VBGallery in the Member's area. It's named: "importalbums.php"

As you sugested I've "hardcoded" the category for this script this way:

This is how it looked before:
Code:
Content visible to verified customers only.
This is how I hardcoded it
Code:
Content visible to verified customers only.
where 3 is the number of the User's category in my forum.

The point is... The script run, gave not error nor finishing sign. It imported something like this:

Photos 46,257
Categories 7,552
Disco Space Used 1.67 GB (Gigabytes)

None of this is a problem for me, since we have enough space in the server. But there's a big problem when accessing the admin panel and browsing or editing Categories. The page never loads and stays blank for ever (perhaps due to the huge amount of categories). Finally it shows the headers but no categories.

Second issue is the way it handled private albums, making them public. I'd rather preferred not to import them and let the user's decide on that subject.

Let me know if you have any advice on this so we can start using VBGallery (actually I've hidden it for the rest of the users)

Thanks in advance for your support.

Eduardo
EduFabbri is offline   Reply With Quote
Old March 20th, 2011, 02:32 PM   #6 (permalink)
Registered User
 
Join Date: Aug 2005
Posts: 1,229
the script you are using is for vbulletin 3 only !!!!
try this script.. if you are using vbulletin 4:
[very Beta] Import vB4 Albums to vBGallery 3

luc

PS: i doubt you will able to use the old script.. as i am not sure it is php > 5.1 compatible.
Luciano is offline   Reply With Quote
Old March 20th, 2011, 02:46 PM   #7 (permalink)
Junior Member
Verified Customer
 
Join Date: Mar 2011
Posts: 10
Hi Luciano,

As you may see in my first post, I'm running vBulletin 3.8.4. Thanks anyway.

BTW, What's more similar to "Private Albums" in VBGallery. Is there any way to let only friends view a Category?

Thanks
EduFabbri is offline   Reply With Quote
Old March 20th, 2011, 05:34 PM   #8 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,654
Well the issue as I brought up before is your category id is empty. That is why you get that error

Code:
Content visible to verified customers only.
That is the line that defines the category id. Now you will probally need to look at your database tables but for whatever reason I would suspect that some of your pictures the albumid field is empty in your vb albumpicture table is empty. It should not be empty and this is why you get an error.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old March 21st, 2011, 12:49 AM   #9 (permalink)
Registered User
 
Join Date: Aug 2005
Posts: 1,229
Quote:
Originally Posted by EduFabbri View Post
Hi Luciano,

As you may see in my first post, I'm running vBulletin 3.8.4. Thanks anyway.

BTW, What's more similar to "Private Albums" in VBGallery. Is there any way to let only friends view a Category?

Thanks
Nope, the friends only view is not implemented yet (in vbg 3)

Yes sorry, i went to the first post of the whole thread.. clicked on the link in the error message and that took me to a vb4 install.
Luc
Luciano is offline   Reply With Quote
Old March 21st, 2011, 08:22 AM   #10 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,654
Yeah he replied to a two year old thread which can be a confusion.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old March 21st, 2011, 09:51 AM   #11 (permalink)
Junior Member
Verified Customer
 
Join Date: Mar 2011
Posts: 10
Hi Chuck and Luciano,

Sorry for reopening a two year old thread. Just in case you can move the messages to a new thread if you consider it necessary.

BTW, I've fixed the "orphan" pictures issue in my database and the imported run without errors, but again without saying "done".

I've also noticed the "test" variable inside the script and understood (may be I'm wrong) is something like a "verbose mode". Set it at 1 and once again I've started over and tried the import script. It does all "albums to categories" stuff and then, when moving files it stops at a picture that it's not the last uploaded in VB Albums. Let me tell you that I'm using folders and files option to store VB Albums, so that the pictures are not in the DB.

Am I having a missing picture file? Is there any way to know it?

Thanks again, sorry for bother you so much.

Eduardo
EduFabbri is offline   Reply With Quote
Old March 21st, 2011, 10:13 AM   #12 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,654
Eduardo

The answer I provided should give you some idea of where to look for your issue. What I am saying is your mysql error where things stop is because your have an album id in the albumpicture table that is empty. It is not suppose to be empty.

vBulletin Albums Importer -> vBGallery

That is check to see your doing what is said there and see where you get and check your database table and see if there are any albumid fields in that table I meantion which are empty
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old March 21st, 2011, 10:27 AM   #13 (permalink)
Junior Member
Verified Customer
 
Join Date: Mar 2011
Posts: 10
I've already checked that as soon as I've read you the first time. That's what I've solved deleting 4 entries in my pictures database. There's no empty albumid field there, but I cannot assure there's no picture pointing to an "unexistent" album (another way of "orphan" pictures).
I know it sounds like extra work... but Why not testing the VB Albums data consistency prior to importing in the same script. Shouldn't be so difficult to tell us what the inconsistencies are so to correct them prior to importing and avoiding you such this headaches

I'll continue analyzing my db as far as I can. Maybe I can search for the last record printed by the verbose mode of the script and see the next one's data to gather if there's something odd in it.

Thanks.

Eduardo
EduFabbri is offline   Reply With Quote
Old March 21st, 2011, 12:57 PM   #14 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,654
Eduardo

Please realize this old beta importer was written a couple years ago. There has been no testing or changes since that time. It was merely written as an extra tool to help users.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old March 22nd, 2011, 08:16 AM   #15 (permalink)
Junior Member
Verified Customer
 
Join Date: Mar 2011
Posts: 10
Hi Chuck,

I realize that I'm asking for something extra VBGallery, and I do appreciate your dedication and effort to solve my problems. The importer didn't work even when I browsed all VB Albums (one by one) and checked for inconsistencies. Didn't find anything odd in the albums, pictures, albumpict, comments DB's (like blank fields).

I feel pretty lost. Do not know what to do next....

Thanks anyway.
EduFabbri is offline   Reply With Quote
Old March 22nd, 2011, 09:10 AM   #16 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,654
Do you get any more errors? I really do not know where your at. You say you have ran the importer. It should not be modified in any way and run it and what do you get?
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old March 22nd, 2011, 09:30 AM   #17 (permalink)
Junior Member
Verified Customer
 
Join Date: Mar 2011
Posts: 10
Hi Chuck,

I've run the script "as is... from the box" directly extracted from the ZIP file of your Member's Area:

The result is: It runs and hungs at certain point, no message displayed. The categories and photos imported are unaccessible even from admin's account. No comments are migrated. I can only access my own photos (that were not private). No other user can access my photos. Other users can access their own photos but no one else can. Tried setting permissions in Control Pannel but with no luck, photos are still unavailable for other users. Do not know (not sure) if all photos are migrated.

I undid changes with the same script.

Then I did a minor change to the script and put test="1" instead of test="0" at the beginning. It runs showing some arrays (albums to categories I presume). Then it starts moving files from one server folder to another and it stops without further notice or explanation...

Let me know if there's any further info I should give you to better solve this.

Thanks for your patience.

Last edited by EduFabbri; March 22nd, 2011 at 10:11 AM. Reason: Permission problem further explanation.
EduFabbri is offline   Reply With Quote
Old March 22nd, 2011, 01:01 PM   #18 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,654
You can send us ftp info and vb url login etc and we can take a peek to see if we see what is going on.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old March 24th, 2011, 02:05 PM   #19 (permalink)
Junior Member
Verified Customer
 
Join Date: Mar 2011
Posts: 10
Hi Chuck,

Sorry for the delay. Let me know where I can send you that info.

I'll be sending it asap.
EduFabbri is offline   Reply With Quote
Old March 24th, 2011, 05:12 PM   #20 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,654
the contact us link in our site header works
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Php Error... Devboy Photopost Pro Installation & Upgrades 3 November 18th, 2008 10:40 AM
PHP Error kewl1uk Installs and Upgrade - vBulletin 3.6x 1 March 30th, 2007 02:38 PM
pp-inc.php error after php upgrade Alfa1 Photopost Pro Installation & Upgrades 5 February 23rd, 2007 11:17 PM
Bug in slideshow.php: Parse error: parse error, unexpected '\"' in line 282 (FIXED) dontom Photopost Pro Bug Reports 2 September 30th, 2005 09:09 AM
Parse error: parse error, unexpected '}' ...usergroup.php on line 355 djjeffa Installs and Upgrade - vBulletin 3.0.X 4 April 14th, 2005 10:50 AM


All times are GMT -5. The time now is 01:21 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0