vBGallery install seems to have killed my database

[djrichards]

I was in the middle of installing vBGallery to replace my PP installation and I got to the part where the script imports product.

I received an error saying that it essentially couldn't find the XML. I went back and tried it again and now all I get is database errors.

My site won't load at all and I don't even see the tables the script supposedly created in the database.

Any insight into what happened here?

I'm running vB 3.8.3 (latest)

[Chuck S]

Did you upload the xml file?

I wonder if it has your product enabled but since the xml did not exist it could not import it

You can try running this query in your database make sure the plugin is not active. Also your vb should be sending you an email with the actual error which would help us assist.

UPDATE product SET active=0 WHERE productid='ppvbgallery';

[djrichards]

Although there are more than one XML files in the package the only one the instructions say to upload is cpnav_vbagallery.xml which was uploaded to the forum/includes/xml folder. I've just re-verified that.

I've received (and continue to get) several error emails. Here's the text of the first one.

Database error in vBulletin 3.8.3:

Invalid SQL:

SELECT administrator.*,
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_plugins AS phrasegroup_plugins,
language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
language.phrasegroup_adv_gallery_int AS phrasegroup_adv_gallery_int,
language.phrasegroup_adv_gallery_int AS phrasegroup_adv_gallery_int,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
, ppgal_user.*, ppgal_user.*
FROM vB_user AS user
LEFT JOIN vB_userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN vB_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN vB_administrator AS administrator ON (administrator.userid = user.userid) LEFT JOIN vB_language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

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

MySQL Error : Not unique table/alias: 'ppgal_user'
Error Number : 1066
Request Date : Friday, June 12th 2009 @ 12:25:49 PM
Error Date : Friday, June 12th 2009 @ 12:25:49 PM
Script : Log in - the Lancisti Forums - vBulletin Admin Control Panel
Referrer : Log in - the Lancisti Forums - vBulletin Admin Control Panel
IP Address : 71.208.44.112
Username :
Classname : vB_Database
MySQL Version :

I found the tables were created after all. I just wasn't looking for them to have a "vB_" on the front. I deleted those to see if I can reinstall but no dice.

[Chuck S]

Upload everything there is an xml in the admincp that needs to be uploaded.

[djrichards]

Originally Posted by Chuck S

Upload everything there is an xml in the admincp that needs to be uploaded.

Well, that's not what your instructions say. :-)

[djrichards]

I assume by "everything" you also mean the clientscript folder stuff too?

Same for cpstyles and images, too?

Instructions say nothing about them either.

[Chuck S]

Everything in the forums and gallery directories need to be uploaded to your server from our unzipped code.

[djrichards]

Originally Posted by Chuck S

Did you upload the xml file?

I wonder if it has your product enabled but since the xml did not exist it could not import it

You can try running this query in your database make sure the plugin is not active. Also your vb should be sending you an email with the actual error which would help us assist.

UPDATE product SET active=0 WHERE productid='ppvbgallery';

No dice. Here's what I get.

#1146 - Table 'lancisti_site.product' doesn't exist

Sorry, but I'm not particularly conversant in SQL. Site is still dead.

Everything is uploaded and I can't access anything via browser. Just get vB database errors.

[Chuck S]

You need to alter that query say to include your specific vbulletin table prefix. My example gives a default install with no table prefix on the product table.

[djrichards]

Thanks for the help, Chuck.

I just created a new database from my backup and have the site back up now. I'll try the install again later.

[Chuck S]

Not a problem let me know if you need anything else.