Database problems

General questions relating to Joomla! 3.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
davide73
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Wed Feb 14, 2024 4:19 pm

Database problems

Post by davide73 » Wed Feb 14, 2024 4:35 pm

hi I have problems with a joomla 3.10.12
if I insert an article for example, but also on forms or menu items, it is recorded without an ID and is then not visible.
I noticed on phpmyadmin that the option to edit doesn't appear on show table, see this image:

https://webmaster-roma.it/joomla1.png

while normally on a working Joomla database I see the possibility of modifying the line, see this image:

https://webmaster-roma.it/joomla2.png

I think I'm missing like the ID or something like that
How could I solve this?

thanks bye

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 30948
Joined: Mon Oct 27, 2008 9:27 pm
Location: Romerike, Norway

Re: Database problems

Post by Per Yngve Berg » Wed Feb 14, 2024 5:57 pm

Does the Primary Key have Autoincrement on those tables?

davide73
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Wed Feb 14, 2024 4:19 pm

Re: Database problems

Post by davide73 » Mon Feb 19, 2024 4:36 pm

Hi, I found the solution thanks to your consideration, thanks!

It was easy, comparing the healthy table and the broken one in fact the difference was on ID which was not auto increment, modifying it and inserting this field, everything works.

Hi, I hope it helps others.
DD


Post Reply

Return to “General Questions/New to Joomla! 3.x”