Save Failed With The Following Error: Field 'ordering' Doesn't have A Default Value | Oneclip Template - Question | JoomShaper

Save Failed With The Following Error: Field 'ordering' Doesn't have A Default Value | Oneclip Template

hillary_h

hillary_h

Template 1 year ago

On editing or creating a new article and attempting to save it this error message pops up.

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

Please assist. Thank you

0
10 Answers
hillary_h
hillary_h
Accepted Answer
1 year ago #105424

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

0
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 1 year ago #105454

Hello hillary_h

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

Best regards

0
hillary_h
hillary_h
Accepted Answer
1 year ago #105492

Hi. that is so weird...

See new credentials below

0
hillary_h
hillary_h
Accepted Answer
1 year ago #105528

Joomshaper Team, PLEASE can i get support on this.

0
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 1 year ago #105545

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

0
PP
Peter Popik
Accepted Answer
1 year ago #105572

Same problem. Resolved by SQL query. THANKS

0
hillary_h
hillary_h
Accepted Answer
1 year ago #106144

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.

0
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 1 year ago #107973

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

0
hillary_h
hillary_h
Accepted Answer
1 year ago #108079

Please see link below.

thank you

0
Ofi Khan
Ofi Khan
Accepted Answer
Support Agent 1 year ago #110837

Please find the database zip file attached here.

0