SP Pagebuilder Database Problems - Question | JoomShaper

SP Pagebuilder Database Problems

MN

Mika Nevala

SP Page Builder 3 years ago

i have several sites where sp pagebuilder is installed. the latest updates have brought a problem to many sites. error message: JInstaller:: Install: Error SQL Duplicate column name 'media_attr' Extension Update: SQL error processing query: DB function failed with error number 1060 Duplicate column name 'media_attr' SQL =

ALTER TABLE #__ spmedia ADDmedia_attr varchar (5120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '{}' AFTER type;

i have to downgrade to 3.70.

0
6 Answers
Toufiq
Toufiq
Accepted Answer
Senior Staff 3 years ago #4506

Hi there,

Thanks for contacting us. Sorry for the inconvenience. Please watch the video. I hope you can solve your issue.

https://drive.google.com/file/d/16Wuh2m8EBim_UUsvZYcicwkrng0qyZIl/view

-Thanks

0
D
[email protected]
Accepted Answer
2 years ago #18100

is there an easier way to fix this? I do not have access to the the database. Thanks!

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 2 years ago #18229

Please contact your hosting provider to provide the access or provide me the Joomla adinistrator accesss. Thanks

0
MasterMatrix
MasterMatrix
Accepted Answer
2 years ago #29668

Hi there!

Sorry, I got the same problem. I have access to phpmyadmin, but your video is without sound and not very sharp, so I can't see what to do. Would you please help me?

Thanks in advance!

0
Toufiq
Toufiq
Accepted Answer
Senior Staff 2 years ago #29848

Before watch the video, Please set 720px from the video settings

https://prnt.sc/1qhnakr

0
MasterMatrix
MasterMatrix
Accepted Answer
2 years ago #30161

Thank you very much, Toufiq!

0