Field 'id' Doesn't have A Default Value
Pilar
Hi I got this error message when try to create a new articule. Field 'id' Doesn't have A Default Value. When I have uninstalled the SPPB component, I can create new articles. I am on Joomla V5.2.5
I foudn this support but I dont understand the latest steps. https://www.joomshaper.com/forum/question/20981
Could you please support me? Thanks
Ziaul Kabir
Accepted AnswerHello,
Thanks for reaching out to us. Could you please share temporary administrator access to your Joomla backend? You can provide the credentials securely in the hidden content section. Also, please take a full backup of your site before we make any changes.
Once I have access, I’ll investigate further and see what’s causing the issue. Let me know once you’ve shared the details!
Best Regards,
Pilar
Accepted AnswerHi again I have found this in this forum this article, but doesnt work for me neither https://www.joomshaper.com/forum/question/33939
Thanks
Ziaul Kabir
Accepted AnswerHello,
I can see that this issue is coming from the database.
Please share your database access credentials so I can assist you further. Before proceeding, kindly make sure to take a backup of your database for safety.
Looking forward to your reply.
Thanks,
Pilar
Accepted AnswerHi Ziaul, Thanks for your prompt response. Please find below the requested access. Thanks
Pilar
Accepted AnswerHi Ziaul, Thanks for your prompt response. Please find below the requested access. Thanks
Pilar
Accepted AnswerThanks, Ziaul
Ziaul Kabir
Accepted AnswerThis link https://juanr193.sg-host.com/es/web-asesoramiento-visados-inmigracion-nueva-zelanda 500 error issues fixed.
Please, adjust your social media icon from site modules -> bottom 3 positions.
Thanks
Ziaul Kabir
Accepted AnswerHello,
Regarding the first issue, it’s not an error but rather a CSS code. The second issue has been fixed.
Thanks,
Pilar
Accepted AnswerHi Ziaul, Thanks for your prompt support.
Pilar
Accepted AnswerHi Ziaul, Thanks for your prompt support.
Ziaul Kabir
Accepted AnswerYou are welcome. We greatly value your opinion and would love to hear your feedback about SP Page Builder. If you could spare a moment, it would mean a lot to us!
You can share your review here:
Pilar
Accepted AnswerHi Ziaul
Ziaul Kabir
Accepted AnswerI’ve fixed the deprecated warning.
If the titles for Bottom 1 and Bottom 2 are not displaying, please create SP Page Builder modules for them — just like Bottom 3 — so the titles will show properly.
Pilar
Accepted AnswerHi Ziaul Thanks for your support. Yes it is a great idea, I will do it.
Ziaul Kabir
Accepted AnswerThe issue is in the _sppagebuilder table, the id column is not set to auto-increment.
To fix this:
- Check how many entries are in the table.
- If there are, for example, 518 entries, run a query to update the row where id = 0 and set it to id = 519. This ensures there is no entry with id = 0.
- After the update is successful, go to the table structure, edit the id column, enable the Auto Increment option, and save it.
This should resolve the issue.
Thanks!
Pilar
Accepted AnswerHi Ziaul, Thanks for your support.
Ziaul Kabir
Accepted AnswerCould you please share temporary administrator access to your Joomla backend? You can provide the credentials securely in the hidden content section. Also, please take a full backup of your site before we make any changes.
Once I have access, I’ll investigate further and see what’s causing the issue. Let me know once you’ve shared the details!
Thanks
Pilar
Accepted AnswerHi Ziaul
Pilar
Accepted AnswerHi Ziaul Thank you so much for youjr support and guideline.
Pilar
Accepted AnswerHi Ziaul Thank you so much for your support. I understand the process, I followed your advice and found new issues, but follow your logic, I have been able to fiz them. Thank you so much for your support and shareing knowlege, I learnt new thinhs with that. Thanks
Ziaul Kabir
Accepted AnswerYou are welcome. We greatly value your opinion and would love to hear your feedback about SP Page Builder. If you could spare a moment, it would mean a lot to us!
You can share your review here: