SP Page Builder update problem (JInstaller: :Install: SQL error Duplicate column name ‘catid’) - Forum | JoomShaper
Solved SP Page Builder

SP Page Builder update problem (JInstaller: :Install: SQL error Duplicate column name ‘catid’)

Asked by DigitM 1 year ago Last activity 1 year ago

Hello Joomshaper team,
I am experiencing a problem after updating SP Page Builder 3.8.10 to version 5.3.2 (5.4.4.)
I get the following message:
JInstaller: :Install: SQL error Duplicate column name ‘catid’
An error has occurred
0 Failed opening required ‘/home/unikaccesm/www/components/com_sppagebuilder/builder/classes/base.php’ (include_path=‘.:/usr/local/php8.3/lib/php’)
Dashboard
and then it's impossible to return to the various admin modules...
And a small additional detail: the front-end site fell with the message: Page not found!
Thanks for your help.
Jack

Accepted answer

Marked as the solution
Ziaul Kabir Staff
1 year ago

Hello,

I apologize for not including the new access details earlier.

User: admin
Password: demodemodemo

Regarding the issues, I noticed that you are using the Flex template. Please note that this is not one of our templates. This template includes numerous overridden addons, and the issues seem to stem from there. Kindly reach out to their support team and request an upgrade to the template or assistance in resolving the issues.

Thank you!

Screenshots: https://prnt.sc/TG1A7d8iru-F

14 more replies

Oldest first Newest first Most helpful
Ziaul Kabir Staff
1 year ago

Dear Jack,

Thank you for reaching out to us. Could you kindly provide admin access in the hidden content section? Before proceeding, please ensure a full backup of your site is taken.

Looking forward to your response.

Best regards,

DigitM Asked this
1 year ago

Hello Ziaul,
I have just reinstalled the site in dev.
I went from Joomla 4.4.9 to 5.2.2 without any problems.
However, when I update SP Page Builder (3.8.10 to 5.4.4), on the front side, page not found and on the admin side on the EXtentions page for example :
Failed opening required ‘/home/unikaccesm/www/joom5/components/com_sppagebuilder/builder/classes/base.php’ (include_path=‘.:/usr/local/php8.3/lib/php’)
Dashboard
The information below is in response to your request.
Thanks in advance for your help.

Ziaul Kabir Staff
1 year ago · edited

Hello DigitM,

To resolve the issue, Please, follow these steps (Before doing this, Please, taking your database backup first.):

Navigated to cPanel -> phpMyAdmin.
Select the relevant database.
Executed the following SQL operation:

ALTER TABLE `yourDatabaseTablePrefix_sppagebuilder` DROP COLUMN `catid`

Here add your database table prefix in here yourDatabaseTablePrefix, You will found it in your Root Joomla folder -> configuration.php

After this sql operation, Please, Try to reinstall SP Page Builder Pro. Then clear your joomla cache.

Thank you.

Best regards,

DigitM Asked this
1 year ago

Hello Ziaul,
I've just followed your instructions but when I want to reinstall Sp Page Builder, I get the following message:
JInstaller: :Install: SQL error Duplicate column name ‘catid’.
Installation of the extension interrupted.
https://prnt.sc/RbqOgTompZ0-

Can I send you an export of the DB?
Thanks for your feedback.
Jack

Ziaul Kabir Staff
1 year ago

Hello Jack,

Yes, You can. Also, it would be great if you give your files as well. So, I can give you the fixed one.

Thanks.

DigitM Asked this
1 year ago

Hello Ziaul,
Below is the information you need to retrieve the BDD.
Thanks for your feedback.

Ziaul Kabir Staff
1 year ago

Hello,

I have addressed the issue you were facing and I have now fixed this. Please re-check your Admin Tools If needed, you can reconfigure the component. There have some files missing.

Let me know if you encounter any further issues.

Best regards,

DigitM Asked this
1 year ago

Hi Ziaul,
Thanks for your feedback.
I downloaded the archive and put it back on my server but 2 problems :

1/ the pages are still not displaying properly
https://prnt.sc/qL1W0qbT-BOm

2/ impossible to access the admin.
I've changed the password via the BDD to MD5 but even with that there's still no access.

Ziaul Kabir Staff
1 year ago · edited

Hello,

From your site, I noticed that your page is currently not selected for fr language. Please Go to french menu from menus, and then click on home page, then select a page for french version home page. You can check english version as well.

Check the screenshots.

Additionally, here is your administrator URL: https://unik-access.com/joom5/administrator/index.php.

At the moment, your admin tools aren’t functioning correctly. Once everything is running smoothly, you can reconfigure them as needed.

Best regards,

DigitM Asked this
1 year ago

Hello Ziaul,

I've just realised that on the version of the site you sent me, there are no longer any of the pages I created using SP Page Builder...
https://prnt.sc/Ul_Ro3u81M5w
Why did you delete them? I have to start from scratch.

I thought that by sending you an akeeba backup archive of the site, you could solve the problem by saving me having to start from scratch...

Ziaul Kabir Staff
1 year ago

Hello,

Thanks for your replay. My task is to solved your issues not create another one.

I am checking your provided file again.

Thanks.

DigitM Asked this
1 year ago

Thank you Ziaul

Log in to reply.