Avatar

2.4.24 --> 20240308.1 Upgrade Notes (Development)

by Auge ⌂, Sunday, March 31, 2024, 13:22 (29 days ago) @ Joe I

Hello

2) The one upgrade error I received was the following:
Error!
Database error in line 298: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' KEY `b8_spam` (`spam`), KEY `B8_training_type` (`training_type`)) ENGINE=Inn...' at line 1

With a quick check of Line 298 in update/update_2.4.19-2.5.php, I see 2 commas after PRIMARY KEY (`eid’):
if (!@mysqli_multi_query($connid, "CREATE TABLE IF NOT EXISTS `" . $db_settings['b8_rating_table'] . "` (`eid` int(11) NOT NULL, `spam` tinyint(1) NOT NULL DEFAULT '0', `training_type` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`eid`), , KEY `b8_spam` (`spam`), KEY `B8_training_type` (`training_type`)) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;")) $update['errors'][] = 'Database error in line '.__LINE__.': ' . mysqli_error($connid);

Thank you for spotting this. It was introduced by me with an addition I made after testing the specific section. I'll provide a fix.

Tschö, Auge

--
Trenne niemals Müll, denn er hat nur eine Silbe!


Complete thread:

 RSS Feed of thread