vBGallery installation problems

[asabet]

Trying to change from vBulletin albums to vBGallery at our photography website, mu-43.com. I think I did the installation correctly, but don't know. The installation script seemed to go fine, but I've no idea where to find vBGallery on our site .

Second issue is that when I try to run importalbums.php, I get this error:

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT p.*,a.albumid,u.username FROM picture p
LEFT JOIN albumpicture a ON (a.pictureid=p.pictureid)
LEFT JOIN user u ON (u.userid=p.userid);

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Request Date : Friday, January 22nd 2010 @ 10:16:58 PM
Error Date : Friday, January 22nd 2010 @ 10:16:58 PM
Script : Log in - Micro Four Thirds User Forum - vBulletin Admin Control Panel
Referrer : Log in - Micro Four Thirds User Forum - vBulletin Admin Control Panel
IP Address : 98.110.166.98
Username : Amin
Classname : vB_Database
MySQL Version :

[Luciano]

well, first question.. in what directory did you install vbgallery?
(i meen in what directory did you upload the gallery files????)

i tried mu-43.com/gallery
(that would have been the most obvious)

but did not find it..
on forum home your gallery statitiscs are there..
but they point to yoursite/stats.php wich they shouldnt..
(depending where you uploaded the gallery directory to, it should at least be yoursite/gallery/stats.php)

So my hint is.. go to acp...
into the vbgallery settings section..
and verify your paths.. make sure they point to where your gallery really is..

You got to have gallery running.. even empty before you can import anything..

Luc

[Chuck S]

secondly your mysql error does not have anything to do with vbgallery. The error though only points out mysql is shut down on your server so maybe it restarted.

[asabet]

Thanks for such quick replies.

I am using Hostgator. I have a forum (not the one I'm using with vbgallery) setup on my primary domain, which is ziforums.com, so that forum (Ziforums) is installed within my public_html directory.

Then I have another vBulletin forum installed within an addon directory (public_html > mu-43.com), and it is this forum (Mu-43) that I want to use with vBGallery.

I renamed the "forums" folder in the vBGallery installation files to "mu-43.com" and uploaded it so that those files were uploaded to:
public_html > mu-43.com > admincp
public_html > mu-43.com > clientscript
public_html > mu-43.com > cpstyles

etc

I then uploaded the "gallery" folder in the vBGallery installation files directly to my public_html directory (which happens to be where my other Ziforums forums are installed), so that I now have a directory of public_html > gallery

In my gallery_config.php, I specified the full path to my forum as follows:

$forumpath = /home/asabet/public_html/mu-43.com';

Is that right?

Also, while running the installation script, I left blank the settings for Gallery URL, Files Path, Files URL, FTP/FLASH User Folder Path, and FTP/FLASH User Folder URL because I have no clue what to put in these places and thought they'd be filled automatically. However, I see in my admin CP vBGallery settings that those are still blank.

Thank you for your help

[asabet]

Originally Posted by Chuck S

secondly your mysql error does not have anything to do with vbgallery. The error though only points out mysql is shut down on your server so maybe it restarted.

Above that error, it says

Warning: mysql_query() [function.mysql-query]: Unable to save result set in [path]/includes/class_core.php on line 408
PhotoPost vBGallery Photopost vBGallery Album Importer Script

[asabet]

A couple other things:

I remember at some point changing things so the forums would be at mu-43.com instead of mu-43.com/forums. Should I move the gallery directory to public_html > mu-43.com > gallery instead of public_html > gallery ?

Edit: I just moved the gallery to public_html > mu-43.com > gallery

Now when I go to mu-43.com/gallery, I get:

Warning: require_once(./gallery_config.php) [function.require-once]: failed to open stream: No such file or directory in /home/asabet/public_html/mu-43.com/gallery/gallery_global.php on line 55

Fatal error: require_once() [function.require]: Failed opening required './gallery_config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/asabet/public_html/mu-43.com/gallery/gallery_global.php on line 55

Also, I previously renamed cmps_index.php file to index.php so that mu-43.com would point to the vBadvanced CMPS instead of the main forum page. Does this matter for my vbgallery installation?

[asabet]

I took my best guess at the settings in the control panel:

Gallery URL: http://mu-43.com/gallery
Files Path: /home/asabet/public_html/mu-43.com/gallery/files
Files URL: http://mu-43.com/gallery/files
FTP/FLASH User Folder Path: /home/asabet/public_html/mu-43.com/gallery/users
FTP/FLASH User Folder URL: http://mu-43.com/gallery/users

Does that look right?

[Luciano]

the file settings seem correct..
BUT

Warning: require_once(./gallery_config.php) [function.require-once]: failed to open stream: No such file or directory in /home/asabet/public_html/mu-43.com/gallery/gallery_global.php on line 55

Fatal error: require_once() [function.require]: Failed opening required './gallery_config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/asabet/public_html/mu-43.com/gallery/gallery_global.php on line 55

That error comes from the fact that it didnt find gallery_config.php in your gallery directory....
it is searching for that file in /home/asabet/public_html/mu-43.com/gallery/

ie the same directory your gallery is in...
1 . did you rename gallery_config.php.new to gallery_config.php????

2 . after renaming it to gallery_config.php , check the syntax around line 22.. there might be a stray slash / hanging around..

Luc

[asabet]

Originally Posted by Luciano

ie the same directory your gallery is in...
1 . did you rename gallery_config.php.new to gallery_config.php????

Thanks Luc, No I hadn't. Didn't know that I should do that!

Okay, I just did so and now get this error:

Parse error: syntax error, unexpected '/' in /home/asabet/public_html/mu-43.com/gallery/gallery_config.php on line 22

Here's the entire contents of that file:

<?php
//////////////////////////// COPYRIGHT NOTICE //////////////////////////////
// This script is part of PhotoPost vBGallery, a software application by //
// All Enthusiast, Inc. Use of any kind of part or all of this //
// script or modification of this script requires a license from All //
// Enthusiast, Inc. Use or modification of this script without a license //
// constitutes Software Piracy and will result in legal action from All //
// Enthusiast, Inc. All rights reserved. //
// http://www.photopost.com legal@photopost.com //
// //
// PhotoPost Copyright 2008, All Enthusiast, Inc. //
////////////////////////////////////////////////////////////////////////////

error_reporting(E_ALL & ~E_NOTICE);
define('NO_REGISTER_GLOBALS', 1);

// ============================================
// Enter the full path to your forum here
// Example: /home/photopost/public_html/forum
// ============================================

$forumpath = /home/asabet/public_html/mu-43.com';

?>

[Luciano]

you have:

Content visible to verified customers only.

change to

Content visible to verified customers only.

i think you forgot a single quote..

Luc

[asabet]

Luc, thank you!!!

Content visible to verified customers only.

Now I just need to get the albums importer to work. Any advice about that??

[Luciano]

nope.. never even tried it out....
but your gallery does look better now...

[asabet]

Thanks again!!! I'll start a separate thread about the importing issue.

[Luciano]

if I were you.. I would rerun the installation script..
as gallery_config.php was pointing to wrong forum....
at least the image replacements part...
they are working.. allthough they shouldnt.. strange..

other hint.. you need to add the blog.php etc.. to your replacement navbar files in acp settings
Luc

[asabet]

Originally Posted by Luciano

if I were you.. I would rerun the installation script..
as gallery_config.php was pointing to wrong forum....
at least the image replacements part...
they are working.. allthough they shouldnt.. strange..

other hint.. you need to add the blog.php etc.. to your replacement navbar files in acp settings
Luc

Thanks Luc. I just uninstalled and reinstalled again (I had done this before after moving the gallery folder but did it again now)

I don't what you mean about adding blog.php etc to my replacement navbar files.

[Luciano]

ok,
in navbar, and header, as well as footer you have links like to blog.php, archive etc...
instead of pointing to mu-43.com/blog.php or mu-43.com/archive.php
they point to mu-43.com/gallery/blog.php or mu-43.com/gallery/archive.php

To fix this.. you have when you are in acp --> vbgallery --> settings
the first 3 sections...
in the fields you can add the filelinks you want to have a prefix to your forumdirectory..
you can add 1 filename per line..
so in your case, in the navbar replacements I would add

search.php
faq.php
blog.php
blog_search.php
register.php
login.php

to footer replacements
archive/index.php
archive

Now you probably have more links out there that now point to gallery when you are logged in.

PS.. as you have that tab hack.. i do not know if anything has moved from header template to navbar or vice versa...
You would have to test to see if it works when you add the filenames to header replacements or navbar replacements..
L.

[asabet]

Luc, thank you! I added those as you said.

Now if only I could get that importer to work. I don't want to have to tell our members to reupload their albums, because that would require leaving both album systems up temporarily, confusing everyone!

[asabet]

Luc, after adding those items to the lists as you said, I don't see any change. The blog link still points to mu-43.com/gallery/blog.php rather than mu-43.com/blog.php

Any idea why this might not be changing?

Thanks,
Amin