PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Installs and Upgrade - vBulletin 3.5.X (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-5-x/)
-   -   Massive DB Error Referring To Uninstalled vbaPP Gallery (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-5-x/125657-massive-db-error-referring-uninstalled-vbapp-gallery.html)

Neal-UK June 20th, 2006 01:30 PM

Massive DB Error Referring To Uninstalled vbaPP Gallery
 
I'm getting this error when trying to add a hack to my site as a product. It refers to vba pp gallery and no idea what to do. vba gallery has been uninstalled as the forum topic has changed and so was going to start fresh will gallery when forum version final..

Quote:

Database error in vBulletin 3.6.0 Beta 2:

Invalid SQL:
UPDATE language SET title = title, phrasegroup_style = 'a:311:{s:15:\"0_matches_found\";s:15:\"0 Matches Found\";s:15:\"add_child_style\";s:15:\"Add Child Style\";s:28************* blah blah blah

MySQL Error : Unknown column 'phrasegroup_adv_gallery_cp' in 'field list' Error Number : 1054
Date : Tuesday, June 20th 2006 @ 09:14:36 AM
Script : http://www.workerscommunity.com/***/...=productimport
Referrer : http://www.workerscommunity.com/****...?do=productadd
IP Address : ***********
Username : Neal
Classname : vB_Database

KW802 June 20th, 2006 01:34 PM

Neal,

The current version of vBGallery will not install or de-install from the vB 3.6 beta previews. Some of the coding methods, such as using phrasetypeid, has been replaced in the new vB 3.6 beta so any scripts that use those (in this case vBGallery uses it for both the install and uninstall scripts) won't run.

Which hack are you trying to install?

Neal-UK June 20th, 2006 01:39 PM

The IP Info hack for vb 3.6 beta 2

Can't install any hacks due to the above. No way of manually removing anything?

Going to remove most of the post above, it's too big!

Neal-UK June 20th, 2006 01:51 PM

First post edited after waiting 10 mins for the edit to load....

KW802 June 20th, 2006 01:57 PM

That IP Info hack is one of Zachariah's, right? If so then hopefully he'll poke his head in here as well.

Neal-UK June 20th, 2006 04:36 PM

That's the one, just hope there's a way for me to manually remove the problem tables / phrases in the db or through the admin cp. Would like to add the IP hack and some other things. No hacks will install due to the vb gallery error.

Zachariah June 20th, 2006 04:54 PM

England,
Just so I can follow whats up.

Quote:

MySQL Error : Unknown column 'phrasegroup_adv_gallery_cp' in 'field list'
Shows up only in the AdminCP ?

- If so there may be a few products / hacks installed that tap into the gallery that is still installed.

Take a look in your product manager and disable / uninstall gallery add-ons.

Neal-UK June 20th, 2006 05:03 PM

There are no plugins or products on the site, all removed via the plugin and product manager. I'll turn off the manager and see if that does anything.

Neal-UK June 20th, 2006 05:06 PM

Nope, nothing installed and I get DB errors again when installing any hack which shows in the product manager but don't want to risk running them incase it causes errors. Same when uninstalling any hack, db error again but they are removed from what I can see.

Zachariah June 20th, 2006 07:10 PM

look in your
Code:

Content visible to verified customers only.
Find:
Code:

Content visible to verified customers only.
Remove if it is there.

Neal-UK June 20th, 2006 07:16 PM

not there, new files and nothing altered. Removing all vba stuff manually from the db, loads of the shi....sugar

Neal-UK June 20th, 2006 07:25 PM

all working now, hacks installing. It was all products relating to vba not just the gallery. Links had to be removed manually from DB too.

Zachariah June 20th, 2006 07:36 PM

Quote:

Originally Posted by England
all working now, hacks installing. It was all products relating to vba not just the gallery. Links had to be removed manually from DB too.

ahhhhhhhhh


All times are GMT -5. The time now is 02:54 AM.

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