e107
e107 copied to clipboard
[Bug]: v2.3.3 database issues
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