Update SPPB From 1.0.4 To Latest - What A Dramma .. - Question | JoomShaper

Update SPPB From 1.0.4 To Latest - What A Dramma ..

D

Damian

SP Page Builder 4 years ago

Hello, I am writing to you because I am running out of ideas ;)

I was approached by a friend who needed to update his website. I agreed, because what is so difficult about it hehe ;) It turned out that Joomla had to be upgraded from 3.5.1 to the latest and SPPB from 1.0.4 to the latest. I had a bunch of problems along the way but eventually managed to upgrade Joomla to the latest version after disabling all SPPB add-ons at the time. The only problem I have left is when updating SPPB a message appears:

Ostrzeżenie JInstaller::Installation: Error SQL Duplicate column name 'catid'. Extension Update: SQL- error during query processing: The database function call ended with an error number 1060 Duplicate column name 'catid'. SQL = ALTER TABLE #__sppagebuilder ADD catid int(10) NOT NULL AFTER published;

. Error Component - error during installation.

at the moment I am working on a copy of the service so as not to damage the production version and to take the order of things in order to update the actual service later without any problems.

Please help to update the SPPB from the prechistoric version to the latest. I have been struggling with this since the day before yesterday and my brain has already evaporated after all the problems along the way.

0
18 Answers
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 4 years ago #21320
0
D
Damian
Accepted Answer
4 years ago #21380

Hi Rashida, thx for answer ^_^ ... yes but there is one problem, now i have onlu 3.7.12 version, ccan you provide me with older versions so that I can update from version 1.0.4 ?

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 4 years ago #21385

You are most welcome:)

Would you please give me your email address so that I can share the files?

0
D
Damian
Accepted Answer
4 years ago #21386

great, yes i give in the hidden section

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 4 years ago #21424

Hi,

I have just sent it.

Please check and let me know.

Best Regards

0
D
Damian
Accepted Answer
4 years ago #21449

Hello Rashida, how are you ? gee I haven't received any email from you :/ maybe it's a protonmail issue :/ can you try on google ?

0
D
Damian
Accepted Answer
4 years ago #21621

Hey, I didn't get older versions for either gmail or protonmail. Can you verify your emails?

0
D
Damian
Accepted Answer
4 years ago #21640

anyone can help me? plz?

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 4 years ago #21685

Really sorry about that!

I am trying to send it again...

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 4 years ago #21688

I have shared the folder with you through google drive.

Please check and let me know.

Best Regards

0
D
Damian
Accepted Answer
4 years ago #22049

Thank you Rashida, I was able to download the package. I will get on with the updates.

Ok so yes, (Joomla 3.5.1, PHP7.2.34) I updated the ajax_helix3 and system_helix3 plugins to the latest versions. Then i updated SPPB from version 1.0.4 to version 1.4 - everything works fine, then to 2.5.4 - everything works fine. I upgraded the PHP version to 7.3 - everything works correctly. I've updated Joomla from 3.5.1 to 3.6.5, I've checked the database structure after the update - it's good, an error has appeared on the main page:

".border-radius is undefined: /home/matten/domains/uptest.pl/public_html/templates/shaper_soccer/less/master.less on line 14"

So I disabled LESS to CSS compression and the page came back. - However, the articles are not displayed

Do you have any idea why ? Should I worry about it ? or should I go with the update and deal with it at the end ?

My test page:

production version:

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 4 years ago #22073

Hi,

You have supposed to share your test url. But I can not see the URL.

Would you check, please?

And where you can not see them? In blog page or elsewhere?

Best Regards

0
D
Damian
Accepted Answer
4 years ago #22277

The test site is hosted locally on a server and does not have its own address. However, you can get to it by adding the entry (given in the hidden section) in the hosts file

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 4 years ago #22375

Do you have a full site backup, please?

Then you may go ahead and continue the updating process...

It would be great if you give me a screenshot of the issue as you are saying the articles not show.

Best Regards

0
D
Damian
Accepted Answer
4 years ago #22563

Hi Rashida ;)

I went further with the update. I did SPPB and joomla one by one. Everything was stable until I switched from SPPB 3.6.3 to 3.7.11. As you can see on the screen we have among others sql table error. I think the problem is quite a big jump in versions between 3.6.3 and 3.7.11. Could I get intermediate packages between versions ? The previous archive you provided 1.4->3.6.3 worked perfectly and the update went without any problem.

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 4 years ago #22660

Hi!

May I have a screenshot of the issue? Is it saying about missmatch?

Best Regards

0
D
Damian
Accepted Answer
4 years ago #23019

Yes but screenshot is in message above.

Jinstaller:: installation: SQL error Duplicate column name 'media_attr." Update Extension: SQL - error while processing a query: Database function call ended with error number 1060 Duplicate column name 'media_attr'. SQL = ( and this what is in screenshot)

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 4 years ago #23107

Unfortunately I can not see any screenshot above.

However, the following FAQ may help you with this type of duplicate column issue:

https://www.joomshaper.com/documentation/sp-page-builder/sp-page-builder-3/faq-problems-solutions#install-error-sql-duplicate-column-name

Best Regards

0