PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Installs and Upgrade - vBulletin 3.6x (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-6x/)
-   -   Vbulleting down after uninstall (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-6x/135228-vbulleting-down-after-uninstall.html)

TomC18 January 31st, 2008 07:39 AM

Vbulleting down after uninstall
 
My site is down, I can't even get into my VBulitten admin CP.

I installed Photopost Pro a few weeks ago

This morning I delete the plugins for vbgallery

I now get the following database error.

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT administrator.*,
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_plugins AS phrasegroup_plugins,
language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
language.phrasegroup_adv_gallery AS phrasegroup_adv_gallery,
language.phrasegroup_global AS phrasegroup_global,
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

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 administrator AS administrator ON (administrator.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

WHERE user.userid = 1;

MySQL Error : Unknown column 'language.phrasegroup_adv_gallery' in 'field list' Error Number : 1054
Date : Thursday, January 31st 2008 @ 04:44:42 AM
Script : http://creativexposure.org/forums/ad...php?do=product
Referrer : http://creativexposure.org/forums/admincp/
IP Address : 72.218.144.237
Username :
Classname : vb_database

Zachariah January 31st, 2008 07:46 AM

Edit and Place:
Code:

Content visible to verified customers only.
in /forums/includes/config.php after <?php.

This will disable all hooks and allow your to get back into your AdminCP.

Run:
Code:

Content visible to verified customers only.
Choose: Uninstall

When done remove:
Code:

Content visible to verified customers only.
in /forums/includes/config.php to bring your Hook / plugin system back on line.

TomC18 January 31st, 2008 07:57 AM

Followed your instructions but still getting the same database error.

Here is my edit in Config.php

<?php
define('DISABLE_HOOKS', true);
define('SKIP_REFERRER_CHECK', true);
/*======================================================================*

TomC18 January 31st, 2008 08:40 AM

Thought I would go ahead and try the

http://www.website/forums/admincp/vbgallery_install.php

but get the same error

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT administrator.*,
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_plugins AS phrasegroup_plugins,
language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
language.phrasegroup_adv_gallery AS phrasegroup_adv_gallery,
language.phrasegroup_global AS phrasegroup_global,
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

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 administrator AS administrator ON (administrator.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

WHERE user.userid = 1;

MySQL Error : Unknown column 'language.phrasegroup_adv_gallery' in 'field list' Error Number : 1054
Date : Thursday, January 31st 2008 @ 06:37:49 AM
Script : http://www.creativexposure.org/forum...ry_install.php
Referrer :
IP Address : 72.218.144.237
Username :
Classname : vb_database

Zachariah January 31st, 2008 08:48 AM

If you were able to uninstall and remove the gallery.
Code:

Content visible to verified customers only.
- Uninstall

There must be another integration of the gallery in your forums system.
I recall this in vBGallery 2.1 at forum integration. Take a look for a line of code .

Edit:
forums/includes/init.php

Find:
Code:

Content visible to verified customers only.
Remove

TomC18 January 31st, 2008 08:52 AM

Yes, I seem to recall that mod. I'll give it a try and be back in a few minutes.l

TomC18 January 31st, 2008 08:57 AM

That did it:D Thanks for your speedy support on this Zack


All times are GMT -5. The time now is 04:22 PM.

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


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97