[katie hunter]

I really want to uninstall your mod and now i can't.

Database error in vBulletin 4.2.1:

Invalid SQL:

					SELECT 
						gi.*, 
						gin.shortname 
					FROM dbtech_gallery_images gi 
					LEFT JOIN dbtech_gallery_instances gin ON gi.instanceid = gin.instanceid 
					LEFT JOIN dbtech_gallery_albums ga ON gi.albumid = ga.albumid 
					WHERE 
						gi.instanceid IN (1) && 
						gi.approved	= 1 && 
						gi.deleted	= 0 && 
						((gi.albumid = 0) || ((ga.hidden = 0) && (ga.password = '')) || (gi.userid = 1)) && 
						gi.is_flash	= 0 
					ORDER BY 
						gi.dateline DESC 
					LIMIT 
						0, 5;

MySQL Error   : Table 'nihonoma_forum.dbtech_gallery_images' doesn't exist
Error Number  : 1146
Request Date  : Friday, November 1st 2013 @ 11:12:14 PM
Error Date    : Friday, November 1st 2013 @ 11:12:14 PM

Uninstalling xml gave me this error ^

Then after i deleted all the files which belongs to this mod, i get a blank page on my site, can't see anything.

Edit: I've re-uploaded the gallery files again but not importing the xml, now i can see the site instead of a blank page but i want to delete the files, i don't want it on my server. I think if i deleted the files again, i will get a blank page.

What should i do ?

I don't want to try install and uninstall the xml product again, it locks my table and takes 30+ min to complete and sometimes it fails, my browser gets disconnected.

_________

I've imported the xml again, but i really want to get rid of this modification, it is causing many issues. These are the entire list of the tables that were created after importing the xml. I presume if i uninstall the product, i will get the same db error again?

http://imagetwist.com/utqjtmizrftc/Capture.PNG.html


What should i do to install this plugin without issues?

Edit: i've installed the xml twice, and override it and now i see the admin side of it and the gallery url etc.. i guess when the table were locked because it alters many things, it did not finish installing completely. This mod looks very risk if i use it and decided to uninstall it in the future, it would cause many problems when it comes to uninstall.

It took 30 min to import the product, then i had to import it again to complete the entire installation. I have no idea what it will do if i try to uninstall it now. what should i do to completely remove it? I am getting db errors like these too

Database error in vBulletin 4.2.1:

Invalid SQL:

    UPDATE
        dbtech_gallery_images
    SET
        username    = ''
    WHERE
        userid    = 785326;

MySQL Error   : Table 'nihonoma_forum.dbtech_gallery_images' doesn't exist
Error Number  : 1146
Request Date  : Saturday, November 2nd 2013 @ 12:26:10 AM
Error Date    : Saturday, November 2nd 2013 @ 12:26:10 AM
Script        : http://forum.nihonomaru.com/private.php?do=showpm&pmid=704512Referrer      : http://forum.nihonomaru.com/private.php
IP Address    : 
Username      : Sun Seto
Classname     : vB_Database
MySQL Version :

I am trying again to uninstall the xml and i receive timeout. It takes around 30+ min to finish and when it happens, i guess because of the time out the product doesn't completely get uninstalled, what should i do ? This is a very heavy mod for big sites and does alter many tables.