PDA

View Full Version : 1.8RC3/ASP client deletion problem



spiv
08-05-2004, 12:46 PM
If i delete a client from the system, and then try to add them again I get a database error.

I looked at the tables and when a client named "xyz" is deleted, the program is not deleting all the tables "xyz_" in the database. When I manually deleted them using phpmyadmin, then it will work ok after that.

TurnkeyAdmin
08-06-2004, 12:42 PM
Do all of the tabes remain or just a few?

spiv
08-06-2004, 02:25 PM
Just created client "test" and then deleted it.

the table test_iplist and test_templates were not deleted.

Now if I try to create client "test" I get the error "There seems to be a slight problem with the database" and the "view source" error is:

<!-- Database Error In PHP Live Helper ASP Administration: Invalid SQL: CREATE TABLE test_iplist (
id INT NOT NULL AUTO_INCREMENT,
ip VARCHAR(15) NOT NULL,
blocklist ENUM('1','0') DEFAULT '1',
blockchat ENUM('1','0') DEFAULT '1',
blockreports ENUM('1','0') DEFAULT '1',
PRIMARY KEY (id)
)
MySQL Error: Table 'test_iplist' already exists
MySQL Error Number: 1050



Do all of the tabes remain or just a few?

TurnkeyAdmin
08-08-2004, 12:26 PM
ok that is a bug then in the RC3... its just forgetting to delete a few tables. Thanks.