[metalguy639]

Originally Posted by ozione

hi, mates!

i have some really big issues with my site since uninstalling the project tools. i asked for help on it's official support forums but no one seems to care.

what i did was a complete uninstallation of the product. by the book. i'm getting these sql errors, so i tried to reinstall the product (no more errors) and uninstall it again. no luck.

the sql error:

Database error in vBulletin 4.2.0:

Invalid SQL:

					SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_projecttools AS phrasegroup_projecttools,
			phrasegroup_posting AS phrasegroup_posting,
			phrasegroupinfo AS lang_phrasegroupinfo,
			options AS lang_options,
			languagecode AS lang_code,
			charset AS lang_charset,
			locale AS lang_locale,
			imagesoverride AS lang_imagesoverride,
			dateoverride AS lang_dateoverride,
			timeoverride AS lang_timeoverride,
			registereddateoverride AS lang_registereddateoverride,
			calformat1override AS lang_calformat1override,
			calformat2override AS lang_calformat2override,
			logdateoverride AS lang_logdateoverride,
			decimalsep AS lang_decimalsep,
			thousandsep AS lang_thousandsep
					FROM vb4_language
					WHERE languageid = 2;

MySQL Error   : Unknown column 'phrasegroup_projecttools' in 'field list'
Error Number  : 1054
Request Date  : Saturday, October 6th 2012 @ 11:43:17 AM
Error Date    : Saturday, October 6th 2012 @ 11:43:17 AM
Script        : http://www.mydomain.com/vb4/project.php?do=issuelist&projectid=2&issuetypeid=&issuestatusid=0&appliesversionid=v1
Referrer      : 
IP Address    : 66.249.71.139
Username      : 
Classname     : vB_Database
MySQL Version :

ANY help would be REALLY appriciated.
thank you.

It looks like the phrasegroups did not uninstall for Project tools. Did you first go to Plugins & Products>Manage Products and click the drop down next to the Project Tools install and tick uninstall? That usually allows you to uninstall any tables found in your database that may cause errors otherwise.

If you did do that and you still get that error you may have to go into your database and drop that table from the database manually. Make sure and I cannot stress enough, make sure you completely back up the database first.