Page 1 of 1

Users error message

Posted: 30 Apr 2024, 23:08
by manonatelier
When I click on a user name, I get this error:

Database Error: 1064 - 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 '[409]=1' at line 1
Query: select e.* from app_entity_33 e where [409]=1
Page: /index.php?module=items/info&path=1-1&redirect_to=subentity&gotopage[108]=1
#0 includes/functions/database.php(99): mysqli_query(Object(mysqli), 'select e.* fro...')
#1 includes/classes/fieldstypes/fieldtype_items_by_query.php(106): db_query('select e.* fro...')
#2 includes/classes/fields_types.php(1077): fieldtype_items_by_query->output(Array)
#3 includes/classes/items/items_page.php(237): fields_types::output(Array)
#4 includes/classes/items/items_page.php(59): items_page->get_tab_fields('91')
#5 includes/classes/items/items_page.php(283): items_page->get_tabs()
#6 includes/classes/items/items_page.php(45): items_page->render_tabs()
#7 modules/items/views/info.php(210): items_page->render('one_column_tabs')
#8 template/layout.php(172): require('/home/robidoux/...')
#9 index.php(49): require('/home/robidoux/...')
#10 {main}

There is no entity 33. I may have created an entity, then deleted it. How do I fix this?

Re: Users error message

Posted: 30 Apr 2024, 23:38
by manonatelier
I fixed it! So no need to reply.

Went into PHPadmin and deleted the offending row with the query.