Error HY000, 1364, Field 'ordering' doesn't have a default value - Forum | JoomShaper
Solved Extensions

Error HY000, 1364, Field 'ordering' doesn't have a default value

Asked by David Martin Heras 3 years ago Last activity 2 years ago

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.

Accepted answer

Marked as the solution
Rashida Rahman Staff
3 years ago

Hi 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 )

https://prnt.sc/MhUD9dCC1E0z

In the table you'll see, it should mention a line for this column ( ordering).

https://prnt.sc/-9PaQWSbXmdz

Just set default value for colomn ordering and save.

https://prnt.sc/woMLzS9VW8ZD

Clearing your Joomla and browser cache is always important.

Please let me know if this solves the issue for you.

Best Regards

7 more replies

Oldest first Newest first Most helpful
Alexandr
3 years ago

These links don't open

David Martin Heras Asked this
3 years ago

Thank 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 Staff
3 years ago

Hi David,

Glad to know that it was helpful:)

Have a nice day!

Best Regards

Rashida Rahman Staff
3 years ago

Hello 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
3 years ago · edited

Hi 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!

Rashida Rahman Staff
3 years ago

Hello Rob,

Really glad that it helped you too:)

Have a nice day!

Petr
2 years ago

Thanks 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 ..

Rashida Rahman Staff
2 years ago

Hi Petr,

Glad that it helped you too:)

Wish you a great day!

Log in to reply.