Show Posts
1
Bugs and Issues / Re: Joomla Publishing Issue
« on: September 07, 2024, 02:52:15 am »
The error about the usys_system missing table is actually a (miss)consequence of another error. In my case:
INSERT INTO `ea_joomla`.`aba_assets` (`parent_id`,`lft`,`rgt`,`level`,`name`,`title`,`rules`) VALUES (?,?,?,?,?,?,?);
[ODBC 9.0(w) Driver][mysqld-5.5.5-10.4.32-MariaDB]No data supplied for parameters in prepared statement;
Fact is, this is a nasty effect of the ODBC driver version 9. Stepping down to mysql-connector-odbc-8.0.28-winx64.msi
AND Joomla 3.9.25 (unfortunately, Sparx EA developpers indicate that Joomla compatibility tests ended with v3.6, so avoid v4 and v5)
and XAMPP 7.4.33 (also old! but to retain compatibility with Joomla 3.9)
provides altogether a working combination
INSERT INTO `ea_joomla`.`aba_assets` (`parent_id`,`lft`,`rgt`,`level`,`name`,`title`,`rules`) VALUES (?,?,?,?,?,?,?);
[ODBC 9.0(w) Driver][mysqld-5.5.5-10.4.32-MariaDB]No data supplied for parameters in prepared statement;
Fact is, this is a nasty effect of the ODBC driver version 9. Stepping down to mysql-connector-odbc-8.0.28-winx64.msi
AND Joomla 3.9.25 (unfortunately, Sparx EA developpers indicate that Joomla compatibility tests ended with v3.6, so avoid v4 and v5)
and XAMPP 7.4.33 (also old! but to retain compatibility with Joomla 3.9)
provides altogether a working combination