Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Latest post by ANTISS on Friday, 05 July 2024 03:58 CDT
Hi, i have a bug with your extension:
Admin Toolsfor Joomla!- An unhandled Exception has been detected 1062 Duplicate entry '0' for key 'PRIMARY'File <root>/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php Line 442
...
how can i fix it please ?
thank
It looks like something is broken with your database, not a bug. When we insert new values to our tables we do not set a value for the primary key because it's an AUTONUMBER column, meaning that MySQL itself uses a monotonically increasing positive integer. Seeing an error with a zero (0) value means that MySQL believes the column is not an AUTONUMBER. But I checked our SQL (in the administrator/components/com_admintools/sql directory) and we definitely create them as AUTONUMBER.
This means that you or someone else exported and re-imported the database in a database other than SQL format, e.g. in CSV format. When you do that, the imported table's column types are wrong, and AUTONUMBER columns are no longer AUTONUMBER.
Please tell me what you did before this error appeared on your site.
Nicholas K. Dionysopoulos
Lead Developer and Director
🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!
ok , it was missing the the row for pkg_admintools in the table update_sites_extensions.
I just add a row update_site_id = 0 and update_site_id = 267 (=id of pkg_admintools) and no more error.
Thank you
Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.
Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!