Error HY000, 1364, Field 'ordering' Doesn't have A Default Value
David Martin Heras
I am using the Soccer template and when I try to create a new page it gives me this error, Error HY000, 1364, Field 'ordering' doesn't have a default value. But I have no problem editing existing pages. I suppose it will be an error in the 'ordering' field but I don't know which database table it is exactly. I'd appreciate your help.
Rashida Rahman
Accepted AnswerHi there!
Thanks for your query.
Please go to the phpMyAdmin, load up your site's database and then open the schema for the xxxxx_sppagebuilder. (here xxxxx is your database table prefix )
In the table you'll see, it should mention a line for this column ( ordering).
Just set default value for colomn ordering and save.
Clearing your Joomla and browser cache is always important.
Please let me know if this solves the issue for you.
Best Regards
David Martin Heras
Accepted AnswerThank you very much for your help Rashida Rahman, it was easy to follow the steps, and it works perfectly. Thanks again. Best regards
Rashida Rahman
Accepted AnswerHi David,
Glad to know that it was helpful:)
Have a nice day!
Best Regards
Rashida Rahman
Accepted AnswerHello Alexandr,
These are screenshot links taken with the help of online tool, lightshot. Should be opened as David can see them as well.
Best Regards
Rob
Accepted AnswerHi Rashida Rahman,
Super solution, I had this error after uploading a website from local to web. It using the helix ultimate template. I had no error on saving pagebuilder pages at all. The error occured on my side after I edit a Joomla article and try to save it. After I used your solution the error disappeared and I could save an article normally. Thank You!
Petr
Accepted AnswerThanks a lot Rashida... I had the same problem with sp page builder (template Empire)...wasn´t possible to create new sp page builder module ( the same solution just in "catID")...really appreciate Your solution ..