@HDcms I would request you to create new post with the details. Thanks

Hello Do I have to open a new thread? I seem to have the same problem even though a solution has been made (maybe) in a version of SPPB. To avoid the problems mentioned, I am forced to stay with the htacess disabled. Thanks for helping me

Hello Can you also answer me? Thank you

@regioprint How can I go from MySQL 8.x back to MySQL 5.x without breaking everything?

Contact your hosting provider.

Hello I have the same problem for the 1st time.

The maintenance action has no effect, I still have the notification. More annoying, I have difficulties to juggle between the backoffice and frontend pages to modify the content of a SPPB page!

The problem is old, I wonder if your patch is still functional. I'm using php 7.4.28 (but I'll have to upgrade to 8.1 soon), joomla 4.1.2, helix hultimate 2.0.7 and SPPB Pro 3.8.6

Database version 10.2.43-MariaDB Interclassification of the database latin1_swedish_ci Collation of the connection to the database utf8mb4_general_ci

2/ I end up with a blank administration page. This forces me to put back my .htacces => htaccess.txt. It seems to me that this is related to SPPB because for days I have been working only with SPPB pages

How can I go from MySQL 8.x back to MySQL 5.x without breaking everything?

Please use the PHP 7.4 and mysql 5

No it doesn't work, since I started using MySQL 8.x I can't create new pages. best regards regioprint

Hi

I just updated to the newest version of 3.8.6 with Joomla 4.1.0 php 7.4. and are now experincing the same error.

Does the fix you provided still work or should i ask for help?

We are working for PHP 7.4 and mysql 8. I hope dev team will release it soon. Thanks

Hi dear Joomshaper Team,

when will you finally fix this issue? It would be a lot easier for you to provide an update with the issue fix, than to laboriously answer every single person here in the forum the same thing over and over. It is not only a waste of time for you, but also annoying for the users. Don't get me wrong, I don't want to blame you, I want to show you an easier way for both sides to find a better solution to a very annoying problem. I hope something will happen soon in this direction.

@Frank, we need access as Super User !!

hello sent

@Elizabeth Rodriguez, Please create a new post with your administrator access. Thanks

Hello! It seems I have the same problem, or at least a very similar one.

I get this message:

Database update required SP Page Builder has been updated. To keep things running smoothly, we need to update your database. We strongly recommend you to take a backup in case anything goes wrong.

So I updated it, but then I keep getting the same message:

Database update required SP Page Builder has been updated. To keep things running smoothly, we need to update your database. We strongly recommend you to take a backup in case anything goes wrong.

So I updated it, again, and still getting that message. Over and over again.

Do you think the zip file will help me too?

Thank you very much for your time!

@Frank please ready my last reply carefully.

Note: Site URL and database access missing

hi.

@Frank Please provide me the Joomla administrator access & database access. I will check & get back to you soon. Thanks

Hi

There were no indications that it does not work with mySQL8.

We put this information (warning) in SPPB documenation. Really sorry, we have hope that upcoming update will improve it.

Updating the maintenance files and changing fields to auto-increment doesn't work (Mysql 8). It tells me it made all the necessary changes, but when I check the database, nothing has been updated aside from auto-increment has been turned off. I am continually prompted to update the database.

I just purchased this extension and it's a little disappointing that I cannot actually use it - in particular add new pages. There were no indications that it does not work with mySQL8. Is there a fix that works for eveyone as the supplied maintenance files and database alterations do not work in my case.

Download and install this zip file

maintenannce

I'm using version 3.7.9 and the problem remains. I can't add a new page.

thanks , this work for me..

Please follow the instruction. Download the zip file maintenannce.zip there are two files....

Sorry but you still have to wait for new version, it wasn't fixed in 3.7.9 otherwise you would read that info in changelog. Please try to use lower version of database.

But as Toufiq said with can test new code using your site to improve SPPB sooner.

Hello Toufiq,

I cannot add new pages. Helix 2.5.8 Joomla 3.9.23 SPPB 3.7.7 php: 7.3 database: MySQL 8.x

Your solution: Download your database create a database in your localhost Import the database in your localhost Click on the SQL option from your phpmyadmin SET sqlmode = ''; use this code https://prnt.sc/we4h1n Then try to change the auto increment

But i am not able to do this. Please help me in another way.

Paul says: If I may.... So far we noticed that this problem appears only on MySQL v8, not olders. It should be solved in the upcoming update SPPPB 3.7.9. Give us few days.

best regards regioprint

Hello again (update June 2021),

I am able to add new pages, but the "id" is = 0. So the result is: No page will be shown on frontend. I am using Helix 2.5.8 Joomla 3.9.27 SPPB 3.7.12 php 7.4 database: MySQL 8.x best regards regioprint

@BisDom please create a new forum post and share your credentials(administrator access, hosting access).

Hi Taufiq,

maintenance file did not work for me. im worrying it might have altered many tables then before. please advise proper solution.

Hello Toufiq, i am not sure with sql. Therefore i will wait for an update of SPPB, which will solve the problem, that I cannot add new pages, because i am using MySQL 8.* Thanks best regards

1. Download your database
2. create a database in your localhost
3. Import the database in your localhost
4. Click on the SQL option from your phpmyadmin
5. SET sql_mode = ''; use this code https://prnt.sc/we4h1n
6. Then try to change the auto increment

I cannot add new pages A few days before, you send me a solution via supportticket. Thanks for the maintenance file, this seem to have worked.

BUT: I cannot add new pages, or save and add section from my site.

When I try to set the AUTO_INCREMENT value for the id field in table sppagebuilder, my phpMyAdmin will throw error message "ERROR 1067: Invalid default value for 'created_on'".

Helix 2.5.8 Joomla 3.9.23 SPPB 3.7.7 php: 7.3 database: MySQL 8.x

best regards regioprint Happy New Year

Please read the blog post. It will help you to understand how works the new forum.

https://www.joomshaper.com/blog/introducing-more-optimized-and-private-support-forum

@Toufiq: Thanks, files are gone.For the future, I would prefer exchanging complete SQL dumps via e-mail instead of a public support forum. :-) All works fine now, thanks for your support.

Best regards, Ben

Please check now. Thanks

From the future, if anything sensitive then use private question.

Thanks

Hi,

I have downloaded the SQL files. Please urgently remove them from this site as they are visible publicly.

Thanks, Ben

Glad to know that your problem solved. Please mark as resoved your forum post. Thanks

AUTO_INCREMENT trick worked perfectly. Now I can add new pages. Thank you

Here is the update database. Create a new database name or delete your existing database all tables.

I have informed to our team. I hope they will help you within 72 hours. Thanks

I have added the database access to the hidden content area of this question. Please kindly let me know if you can see it.

Database access. Thanks

My provider is not using cPanel. What exactly do you need: Joomla backend acess? MySQL database access (this will be going via PHPmyAdmin)? Somthing else?

If you provide me the Cpanel access. I will share with my developer team. Thanks

This blog post will help you to share the hidden content https://www.joomshaper.com/blog/introducing-more-optimized-and-private-support-forum

Hi Toufiq,

thanks for the maintenance file, this seem to have worked. When I try to set the AUTO_INCREMENT value for the id field in table sppagebuilder, my phpMyAdmin will throw error message "ERROR 1067: Invalid default value for 'created_on'".

Any ideas?

Thanks, Ben

My personal solution : I've edit the file "/administrator/components/com_sppagebuilder/sql/install/mysql/install.mysql.utf8.sql" for table definitions with my own Database Tables Prefix (xxxx): #__sppagebuilder → 'xxxx_sppagebuilder' you can see your database tables prefix on Global Configuration/Server tab.

If I may.... So far we noticed that this problem appears only on MySQL v8, not olders. It should be solved in the upcoming update SPPPB 3.7.9. Give us few days.

Thanks for the information. We will try on our end and share a solution as soon as possible.

Thanks

Hello,

I have got the same problem. php: 7.4.3 MySQL: 8.0.22

Tried all kinds of options but until now, no result. Can you please help me with this problem?

Thankx in advance.

PHP: 7.3.25 MySQL: 8.0.21-12

Please share your PHP and Mysql version.

Thanks