View Full Version : 1.8RC3/ASP client deletion problem
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?
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.
Powered by vBulletin® Version 4.1.4 Copyright © 2012 vBulletin Solutions, Inc. All rights reserved.