JInstaller: :Install: Error SQL Duplicate column name 'ordering'Extension installation aborted. - Forum | JoomShaper
Staff replied SP Page Builder

JInstaller: :Install: Error SQL Duplicate column name 'ordering'Extension installation aborted.

Asked by Alison 3 years ago Last activity 3 years ago

Hi I am getting the above error. Nia is very helpful and tells me to go to
Open the file installation\sql\mysql\joomla.sql to make changes

But I am being really stupid (sorry) and cannot find the folder installation
I always thought this was deleted after installation.

Can you point me in the right direction please so I can update ny Page Builder to version 5

Thanks
Alison

6 replies

Paul Frankowski Senior Staff
3 years ago · edited

Hi Alison,

NIA is AI and doesn't know everything, and sometimes tries to pretend to be smart, even if it's not right ;p

In your case - You don't want to update demo data, but real extension files.

Alison Asked this
3 years ago · edited

Thanks Paul

Alison Asked this

Hi Paul
Are you able to help with this? Sorry to ask again, I set you my login details above.
Many thanks
Alison

Paul Frankowski Senior Staff
3 years ago · edited

Sure, I already did. You have SPPB 5.08 Pro now :)

Alison Asked this

Oh gosh, thank you so much :)
Will it upgrade OK from now on?

Paul Frankowski Senior Staff

yes, now should be OK for next updates, database is correct.

You're welcome.

Alison Asked this
3 years ago · edited

Unfortunately it removed all the content from my pagebuilder pages but I have rebuilt them.

Paul Frankowski Senior Staff

Your hosting provider should have database backup in case of.... you can ask, all you need is database, and prefix_sppagebuilder table from it.

Log in to reply.