cant reload adoption mod

[Shelly]

i install adoption mod, didn't like it so i uninstalled the product, my wife wanted it back so when i tried to re-install the product i keep getting the error below:

Database error in vBulletin 3.5.4:

Invalid SQL:

CREATE TABLE adopt (
adoptableid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(20) NOT NULL,
img1url VARCHAR(255) NOT NULL,
img2url VARCHAR(255) NOT NULL,
img3url VARCHAR(255) NOT NULL,
img4url VARCHAR(255) NOT NULL,
img5url VARCHAR(255) NOT NULL,
generaldesc TEXT,
desc1 TEXT,
desc2 TEXT,
desc3 TEXT,
desc4 TEXT,
desc5 TEXT,
minposts MEDIUMINT UNSIGNED DEFAULT 0,
stage2posts SMALLINT UNSIGNED,
stage3posts SMALLINT UNSIGNED,
stage4posts SMALLINT UNSIGNED,
stage5posts SMALLINT UNSIGNED,
creatorid INT UNSIGNED NOT NULL,
ownerid INT UNSIGNED NOT NULL DEFAULT 0,
currentstage TINYINT UNSIGNED NOT NULL DEFAULT 1,
startposts INT UNSIGNED,
gender ENUM('Male','Female')
);

MySQL Error : Table 'adopt' already exists
Error Number : 1050
Date : Friday, June 2nd 2006 @ 05:45:25 AM
Script : http://www.globalmommies.com/gmadmin/plugin.php
Referrer : http://www.globalmommies.com/gmadmin...?do=productadd
IP Address : 68.170.36.229
Username : Tech~Support
Classname : vb_database


i understand that the table is created, however, i cant remove the table so that it can recreate it. the table is still there when i went to repair/optimize the tables, shouldn't the table be gone when the product is uninstalled?

[rogersnm]

Can you give me a link to your mod i can fix your problem.

is it this? https://vborg.vbsupport.ru/showthrea...light=adoption

[rogersnm]

By the looks of things it is. in which case import the attached file and the just unistall it. Then you should be able to install adoptables as normal.

[Shelly]

i imported the link you gave me and tried to install the adoptables mod and it still gave me the same error.



MySQL Error : Table 'adopt' already exists
Error Number : 1050
Date : Friday, June 2nd 2006 @ 02:41:14 PM
Script : http://www.globalmommies.com/gmadmin/plugin.php
Referrer : http://www.globalmommies.com/gmadmin...?do=productadd
IP Address : 68.170.36.229
Username : Tech~Support
Classname : vb_database



thanks for the quick reply

[FLMom]

That is the exact error message I recieved last night, I couldn't get rid of it at all. Will try what you suggested.

Wanted to add, that I will try again though to install it now that you gave me the suggestions in the other thread