e107 icon indicating copy to clipboard operation
e107 copied to clipboard

[Bug]: v2.3.3 database issues

Open Vodhin opened this issue 1 year ago • 0 comments

What e107 version are you using?

v2.3.3

Bug description

All worked OK prior to the v2.3.3 update. I decided to add the table to my plugin's sql.php file and ran the [Check database validity] option to build the table. After clicking the [Fix Selected Items Button] it appeared that nothing happened after form submission:

Warning
1 table(s) have problems.
Table missing!

So I repeated the step and got:

Warning
Update Unsuccessful [CREATE TABLE `e107nf_estate_user` (`user_idx` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_name` varchar(25) NOT NULL, PRIMARY KEY (`user_idx`)) ENGINE=InnoDB;]
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'e107nf_estate_user' already exists

and

Success
Tables appear to be okay!

How to reproduce

Add a new table to your plugin's _sql.php file Run the Check Database Validity on your plugin Check the Items to Fix (Table Missing!) Click Fix Selected Items Get the same error message (Table Missing!)

Recheck the the Items to Fix (Table Missing!) Click Fix Selected Items Get the error message that Table Exists, Get Success Message that Tables OK

Expected behavior

I expected it to not return an error, since it worked anyway.

What browser(s) are you seeing the problem on?

Chrome / Brave

PHP Version

7.4.33

Vodhin avatar Feb 24 '24 16:02 Vodhin