JInstaller: :Install: Error SQL Duplicate Column Name 'ordering'Extension Installation Aborted. - Question | JoomShaper
Black Friday sale is live with flat 50% OFF. Sale ends soon! Grab your deal now!
Back to the questions

JInstaller: :Install: Error SQL Duplicate Column Name 'ordering'Extension Installation Aborted.

Alison

Alison

SP Page Builder 2 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

0
Website
https://www.whitnashtowncouncil.gov.uk
8 Answers
Order by
Oldest Newest Votes
Paul Frankowski
Paul Frankowski
Accepted Answer
Senior Staff 2 years ago #126586

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.

0
Alison
Alison
Accepted Answer
2 years ago #126665

Thanks Paul

0
Alison
Alison
Accepted Answer
2 years ago #126845

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

0
Paul Frankowski
Paul Frankowski
Accepted Answer
Senior Staff 2 years ago #126855

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

1
Alison
Alison
Accepted Answer
2 years ago #126924

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

0
Paul Frankowski
Paul Frankowski
Accepted Answer
Senior Staff 2 years ago #126927

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

You're welcome.

0
Alison
Alison
Accepted Answer
2 years ago #126931

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

0
Paul Frankowski
Paul Frankowski
Accepted Answer
Senior Staff 2 years ago #126937

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

0