Unable To Fix Database
Nicola
Good morning, I need your help, I have installed the SP Page Builder in my new site but I find that there was a problem with the installation and I do not know how I can solve this problem, I need you to solve it?
Image: https://ibb.co/ssX1pXT
Thank you very much.
Paul Frankowski
Accepted AnswerHi Nicola,
in general it will be fixed after upgrade to SPPB 5.0, but by now I can make it OK, but.....
Username and password do not match or you do not have an account yet.
so I cannot login into Joomla to correct that.
Nicola
Accepted AnswerI don't understand, is it the Sp Page Builder login error or the site login?
Paul Frankowski
Accepted Answersomehow I cannot. I tried from Firefox and Chrome.
I will ask other support team member to take look into that case. Please wait, help is on the way.
Paul Frankowski
Accepted AnswerAlso 2nd joomshaper member couldn't login :(
Maybe create me a new "support" account for one day.
Nicola
Accepted AnswerI can't wait because I really need it. I cannot even create a page in SP Page Builder.
Paul Frankowski
Accepted Answerso I am waiting/checking for a new account.
Why you cannot install SPPB 5.0.1 ?
Support for SPPB 3.x will end soon.
Nicola
Accepted AnswerIt seems that I already have 5.x installed, which is why I am having problems. I have already sent it, I hope I have received it.
Paul Frankowski
Accepted AnswerI didn't get any message from your Joomla yet.
Maybe share in classic way
Paul Frankowski
Accepted AnswerHow many pages you have there? 5-10-15 or more ?
If just a few, please Export them one by one. Then uninstall SPPB and install SPPB again, then import those pages if they will not apear in the list of pages.
It should help.
Nicola
Accepted AnswerI haven't started yet and I can't create a page, they tell me the error. It's the new site. I don't know how to do it?
Paul Frankowski
Accepted AnswerMaybe from different website export part of database with all prefix-sppagebuilder tables
I mean those which you shared with me: https://ibb.co/ssX1pXT
Use PHPMyAdmin (from cPanel) for Export task, then rename tables prefix to your current one using text editor, then Import those tables to current database.
Probably your database rights are not correcty set that's why component cannot create those tables.
This method will help you.
Paul Frankowski
Accepted AnswerI cannot login to your site.
Maybe make full website backup (Akeeba backup), upload .zip or .jpa file somewhere and share link. I will install your site on my server add needed steps and I will share database for you that you will just replace.
Nicola
Accepted Answerhttps://ibb.co/7RLGL40 What does that mean?
Paul Frankowski
Accepted AnswerI don't know. Can be damaged database.
Maybe first fix database using Joomla tools:
administrator/index.php?option=com_installer&view=database