Save failed with the following error: Field 'ordering' doesn't have a default value | Oneclip Template

hillary_h Asked this

3 years ago

Joomshaper Team, PLEASE can i get support on this. It has been four (4) days. What am i paying a subscription for?!

Ofi Khan Staff

3 years ago

Hello hillary_h

Apology for the delay. I can't log in to the administrator. Please check it.

Best regards

hillary_h Asked this

3 years ago

Hi. that is so weird...

See new credentials below

hillary_h Asked this

3 years ago

Joomshaper Team, PLEASE can i get support on this.

Ofi Khan Staff

3 years ago

Please go to your database and run this SQL query.

ALTER TABLE `xxxxx_sppagebuilder` CHANGE `ordering` `ordering` INT(11) NOT NULL DEFAULT '0';

Use your database table prefix instead of xxxxx

PP

Peter Popik

3 years ago

Same problem. Resolved by SQL query. THANKS

hillary_h Asked this

3 years ago

I followed the SQL query above and still get this error
https://prnt.sc/KdJiF3MAy33L

"Save failed with the following error: Field 'ordering' doesn't have a default value"

The SQL query i ran is as below.

Ofi Khan Staff

3 years ago

Please take a full site backup with Akeeba Backup in ZIP format and share here. Follow this tutorial

hillary_h Asked this

3 years ago · edited

Please see link below.

thank you

Ofi Khan Staff

3 years ago

Please find the database zip file attached here.