Error when running importalbums.php

[asabet]

I just installed vBGallery at mu-43.com, with the kind help of Luc in another thread, and now I am trying to import our members vBulletin albums into vBGallery. When I run importalbums.php, I get this:

Content visible to verified customers only.

Can anyone please help me?

[asabet]

Deleted. Was irrelevant.

[Luciano]

does it meen it is working?

[asabet]

No, still not working.

I'm on the phone with Hostgator to see if anything they can do??

[Luciano]

Well this error comes from your portal script..
Get the rest working,
see if you can normally upload images, edit, delete them... etc...
And once everything is working.. then only go forward to import the album pictures...
I suspect there are conflicts with your different vbulletin installations..
(like copying config files from one site to another) but could be something else
disable in products vBadvanced CMPS and see if the error persists..

[asabet]

Originally Posted by Luciano

Well this error comes from your portal script..
Get the rest working,
see if you can normally upload images, edit, delete them... etc...
And once everything is working.. then only go forward to import the album pictures...

All of that is working except for the import. Import fails with the vbadvanced disabled also.

[Chuck S]

well lost connection to mysql server means mysql shut down. Pretty generic error but try turning off the entire plugin system.

[asabet]

Chuck, I tried that without success. Actually, when I shut off the whole plugin system, I can't even access the mu-43.com without a fatal error. I had to go through mu-43.com/forum.php and re-enable the plugin system in order to get things working. I guess it's because mu-43.com is my vBadvanced CMPS, and that relies on the plugin system...

[asabet]

I sent my info via the "Contact Us". Any help would be extremely appreciated. I feel like I'm groping around in the dark trying to fix this .

[asabet]

Chuck, I contacted HostGator and just got an email from them which says:

Hello,

Can you please provide us with the login information and link to the script you are attempting to run as well as the steps taken to reproduce the error you are getting? This way we can see the error from your end.

Regards,
Benjamin S.
Linux Systems Administrator
HostGator.com LLC

I submitted info to the Photopost "Contact Us" at the top of this page. Should I also send my vBulletin login information in reply to HostGator support or should I wait to hear from you or someone else from Photopost?

[asabet]

Chuck, please tell me if you're going to look at it, because if you're not I might as well start moving each photo over one at a time by hand .

[asabet]

Well, I tried and tried, and no luck. Having tried to work with vBGallery all day, I've gotten to know it a bit better and no longer want to import our albums into it. I like the vBulletin albums for what they are and will use vBGallery as a complementary feature for our forums or possibly not at all.

[Chuck S]

Okay well let us know as this is the weekend and I was out so if you still want someone to look at it let us know and I might be able to look at it tomorow.

[Luciano]

@chuck
I did some reading and found on mysql.com
MySQL :: MySQL 5.0 Reference Manual :: B.5.2.9 MySQL server has gone away
it gives you lots of possibilities why you get such an error..
among them:

You can also get these errors if you send a query to the server that is incorrect or too large. If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by setting the server's max_allowed_packet variable, which has a default value of 1MB. You may also need to increase the maximum packet size on the client end.

there are big blobs here.. more than 300 of them
and the script loads them all into memory.. (as the images are stored in database). All depends how much memory is allocated to php.. but i think php would loose connection if it is out of mem..

I would try to move the album pictures to filesystem..
and then try to import

[asabet]

Chuck,

I thought about it and would like to try to get it to work. Otherwise it's $129 wasted. I'll change the passwords back to what they were yesterday in the message I sent through "Contact Us"

Last night I deleted the userid 3 member galleries from our vbgallery, thinking that we would have to use vbgallery alongside our current member albums, and I don't know how to get that back properly prior to your trying to make the import script work.

I really appreciate your help.

Thanks,
Amin

[Chuck S]

Luc yeah that would be my first thing to try also

[asabet]

Thank you for your help, Chuck. I'm going to stay out of messing with mu-43 or vbgallery until I hear from you in this thread so as to not mess up what you are doing.

[Chuck S]

Nope that doesnt help either. I am gonna have to see if there is anything else I can think of

Lost connection to mysql is very very generic of an error

MySQL :: MySQL 5.0 Reference Manual :: B.5.2.3 Lost connection to MySQL server

Now these are some things you can try but you need to get your host involved here because obviously I am not going to be able to change your mysql setup on the server.

Have them increase those variables noted in that thread and then lets revisit this.

[asabet]

If there is a host problem, then this import script is not compatible with one of the most popular vBulletin hosts (Hostgator). Shouldn't that have been noted before advertising the ability to import albums as a feature?

[Chuck S]

You are the only one who has posted this problem in the 9 months since this importer was released.