Hi, since I was having some issues in the localhost, I decided to go live and see if that fixed the problems.
I used akeeba to make a full bkp and installed everything on the hosting provider using akeeba kickstarter.
The DB migration however threw up a bunch of errors, all on SPPB tables.
here are the screenshot of the errors.
I had to force akeeba not to stop for errors in order to complete the process, but now SPPB is not working on the backend, and the DB is missing a bunch of tables
after much cussing and cursing I figured out the issue... the localhost was using a more recent version of sql from what was enabled on the server... I switched that to 8.0 and the import of the DB went smoothly!
Thanks for looking into this.
Ciao.
As you know we are not Akeeba Support. So I can suggest you using PHPMyAdmin and manually export-import all tables from LocalHost or only those who keep SPPB. List: https://www.joomshaper.com/documentation/sp-page-builder/database-tables-used-by-sppb
Remember to use empty database on hosting if you decided to import all tables.
Bonus tip! Create a new empty database and try Akeeba installer again.
If you had old database with old tables - it may cause problems! One site one database!
the error seems to be in the tables. i started from an empty Db, and already tried to manually import the sppb tables manually from the localhost to the hosting, myphpadmin throws the same errors
my hosting provodes 5 databases on my hosting plan, so i started in a clean db
Ask Hosting support about advice, maybe there is limit of DB table size etc. It looks that you have Basic account.
In theory, I could recover your site on my hosting, but probably it will not help you. But I can try...
BTW
joomla is 5.5.3
akeeba is also the latest version
the DB is 8.3.14 on the localhost and 8.3.25 on the hosting platform
the whole DB takes up less than 3% of the available DB size :)
Try also those tips/steps:
Great, thanks for info.
