I created a test app and set up a Tests module.

I added 3 records under .../tests/manage

Then I added this to the top of the "Tests" Class.



When I refresh the tests/manage page I get this error:

"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 'order by title' at line 1 in #1 ....../modules/tests/controllers/Tests.php(59): Model->get('title')"

I didn't make any other changes to the default code. Here is line 59:



Any idea why this is happening?

I tested on Xampp 8.2 and Xampp 8.1 and using the latest Trongate v1.0.005 to create the app.

Hi mjim,

This was a weird one to debug but I think I've found the issue.

When you added the constructor to your 'Tests' module and call the '..tests/manage' method Trongate can't find the name of the database table from the URL and creates a malformed SQL - try adding a 'true' to $debug in Model.php.

So the simple workaround is to help Trongate with the database table


I'll have a deeper look into why this happening in Model.php as suspect that in the constructor $current_module is not being defined.

when a call tois made.

Cheers,
Si

Ah yes, forgot about the debug!

Adding the table works for now. :)

It was the only issue holding me back from setting up a multi-tenant app as I need to get the tenant id within the constructor based on the subdomain.

I need to change the $this->model->get() calls anyway since it requires a where clause for the tenant id.

Thank you for looking into this Si!

Jim

Hi,

I've added a little fix and it should now work - even without the table name being explicitly declared.

A new engine number was pushed out tonight and the desktop app should enable you to automatically update 'engine' (the directory) if you want it all set up quickly and without fuss.

If you that's not ideal then the quick fix is to open model.php and change the get_table_from_url() method to the following:



Thanks for bringing this to my attention, Simon, and - as always - thanks for keeping everything ticking over here.

Forever grateful!

DC

Excellent! Thanks Simon and DC!