[#24608] - New created content (articles,modules) have id=0
- Closed
- 16 Apr 2019
- Medium
- Build: staging
- # 24608
Steps to reproduce the issue
Create a new module, it is saved with id=0 and asset_id=0
Expected result
Module has in incremented id
Actual result
Actually id=0
Which results in module can't be edited or deleted (it can be Trashed with an error: Null primary key not allowed but when try to delete i have Delete not permitted.)
IF this module isn't deleted manually from the DB, no other module can't be created as it will trow a duplicated PRIMARY KEY.
The only similar thing found is #11468
I've reinstalled Joomla core files (trough com_joomlaupdate) and Fixed the DB (trough com_installer)
System information (as much as possible)
| Setting | Value |
|---|---|
| Database Version | MariaDB-10.3.14 |
| Database Collation | utf8mb4_general_ci |
| Database Connection Collation | utf8mb4_general_ci |
| Database driver | pdomysql |
| PHP Version | 7.2.17 |
| Web Server | Apache/2.4.39 (Unix) OpenSSL/1.1.0g |
| WebServer to PHP Interface | fpm-fcgi |
| Joomla! Version | Joomla! 3.9.5 Stable [ Amani ] 9-April-2019 15:00 GMT |
| Joomla! Platform Version | Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT |
Additional comments
joomla-cms-bot
- | Labels |
Added:
?
|
||
| Labels |
Added:
J3 Issue
|
||
| Title |
|
||||||
| Title |
|
||||||
| Status | New | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2019-04-16 12:27:06 |
| Closed_By | ⇒ | franz-wohlkoenig |
Ok thanks anyway, forum is completely useless, my last three questions had no answers at all since weeks. Cheers!
Sorry to hear that @acs-ferreira but here are also Forummember so if you Link to the Questions i'm sure they will answer (@wojsmol)
No problem, thanks.
I've managed to solve it myself, it was indeed an AUTO_INCREMENT problem.
I can't reproduce the issue with Database Type "MySql (PDO)", Joomla 3.9.5, 5.5.5-10.1.34-MariaDB, PHP 7.2.
Normally errors like this occur if your database tables are broken.
Check if the field
idof table#__modulesis marked asAUTO_INCREMENT.If not please ask in a forum to get help.