I just killed my VB install with VBG 2.4.3

[voglermc]

Will someone please help me get it working
I'll send you info via a PM of the admin login

here is the error i'm getting

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
, ppgal_user.*
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)

LEFT JOIN ppgal_user AS ppgal_user ON (ppgal_user.userid = user.userid)
WHERE user.userid = 1;

MySQL Error : Table 'tarheelm_vb.ppgal_user' doesn't exist
Error Number : 1146
Request Date : Tuesday, August 12th 2008 @ 09:55:08 AM
Error Date : Tuesday, August 12th 2008 @ 09:55:08 AM
Script : Tar Heel MINI Motoring Club
Referrer : Log in - Tar Heel MINI Motoring Club - vBulletin Admin Control Panel

[Chuck S]

Did you try and install the gallery with the xml file versus running the install script?

My suggestion is to do this.

1. via SQL DELETE any products for vbgallery from the products table and in the plugins table delete any vbgallery plugins.

2. Clear the datastore table and from your vbulletin download upload in the do not upload folder upload the tools.php file and run it and select the rebuilt bitcache from the datastore part. delete tools.php off the server

3. you would then be able to login and go to adminpanel and run the vbgallery_install.php file to install the gallery

[voglermc]

I did run the installer script

will try and follow your suggestions and see how it goes

Thanks Chuck!

[voglermc]

when you say clear datastore table you mean empty it correct?

[Chuck S]

Correct and then you use the tools.php script to rebuild it That should get you to clear things out and then you reinstall. the first step of install is where we create the tables for vbGallery and hense here is your issue somehow your tables where never created

[voglermc]

ok done thanks but now a small issue on admin sidebar

Warning: implode() [function.implode]: Bad arguments. in [path]/admincp/index.php on line 228

Warning: array_keys() [function.array-keys]: The first argument should be an array in [path]/includes/adminfunctions_navpanel.php on line 167

Warning: implode() [function.implode]: Bad arguments. in [path]/includes/adminfunctions_navpanel.php on line 167

Warning: Invalid argument supplied for foreach() in [path]/includes/adminfunctions_navpanel.php on line 170

[Chuck S]

Might that be from some other plugin or product? That does not appear to be from vbgallery?

[voglermc]

yes but i dont even see the vb sidebar thats normally there
I had vb cpms and photopost pro there

[Chuck S]

Okay well you did not delete your vb cmps plugins did you?

Please post a url

[voglermc]

no i did not

http://www.tarheelminis.org

[voglermc]

I just did a reinstall of cmps

[Chuck S]

Tar Heel MINI Motoring Club

Your issue appears with CMPS

Tar Heel MINI Motoring Club

Your forum looks fine.

Have you tried to install your gallery yet?

[voglermc]

Looks like you are the best out there! Thanks for your time today.

[Chuck S]

THMMC Gallery

Not a problem you look up and running although your CMPS is still empty

[voglermc]

working on that now
Thanks again

[Chuck S]

No problem

[cosmin]

hello.

it looks like i have the same problem as the gentlemen above by getting the "adminfunctions_navpanel.php" error in the left navigation menu.

I removed vbgallery and i also uninstalled vbadvanced cmps.

I even re-uploaded all files in admincp and in includes from a fresh vbulletin 3.7.4 download. still get the error.

anyone can help or have a solution as I cannot do anything not in the admincp of my site!

website is: ROYOUTH.com - Powered by vBulletin

[Chuck S]

well where is your gallery installed uninstalled? I need more info here as your forum looks fine to me. I do not see any specific errors.

Make sure any plugins in admin are off in relation to the gallery.