Need help with Joomla? We are available for hire to help with Joomla customization, upgrades, maintenance, and custom development.

All questions about EDocman extension

Category Manager: Edit Category - SQL save error J4

Noel Dixon
Topic Author
Offline
New Member

More

3 years 9 months ago - 3 years 9 months ago #155867 by Noel Dixon

Category Manager: Edit Category - SQL save error J4 was created by Noel Dixon

Hi, I recently migrated J3 to J4 and updated to latest 1.24.2 Edocman.

I'm getting this error message while saving particular Category changes.
Joomla red notification at top of /administrator
Save failed with the following error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups FROM ..._edocman_levels WHERE data_type = 0 and item_id = 50' at line 1

If I manually change the data_type in the database, it will rewrite the data_type to 0 (zero).

I get a "No documents available" message on the module - Modules: mod_edocman_documents

Is anyone else getting this behaviour?

I have attached several screenhots.

Kind regards,