Save failed with the following error: Duplicate entry '0' for key 'q2qdr_sppagebuilder.PRIMARY' - Forum | JoomShaper
Solved SP Page Builder

Save failed with the following error: Duplicate entry '0' for key 'q2qdr_sppagebuilder.PRIMARY'

Asked by Yofie Setiawan 5 years ago Last activity 4 years ago

Hi,

I have problem, everytime i save a new article, it shows error message box like this

Save failed with the following error: Duplicate entry '0' for key 'q2qdr_sppagebuilder.PRIMARY'

How can i fix this?

I just migrate to another web hosting server, could it be database issue? How can i fix this?

And this happen when i activate the spbb with joomla article integration.

And this happen to all of the websites i just migrate. I need a solution that i can copy and paste to all websites i migrated, please help, thank you....

Accepted answer

Marked as the solution

14 more replies

Oldest first Newest first Most helpful
Toufiq Senior Staff
5 years ago

Hi there,

Thanks for contacting us. Sorry for the inconvenience. Can you tell me the process that you applied to migrate your website?

-Thanks

Yofie Setiawan Asked this
5 years ago · edited

Hi,

FROM OLD SERVER</br>
I backup by zipping all the files inside "public_html" folder.</br>
I export the database with phpmyadmin</br>

TO NEW SERVER</br>
I upload the public_html zip file to public_html folder and extract</br>
I import the database with phpmyadmin</br>

This is basic common process i usually use to migrate and always works normal... But actually this is my first time migrate my websites with SPPB and Helix Ultimate.

Please check this screenshot. Everytime i save using SPPB, always fail, not saved, and error message.
https://ibb.co/fS71qfZ

Yofie Setiawan Asked this
5 years ago

Hi,

Thanks, but this is not the solution i expected. I already terminated the old server. I need solution to fix the database on the new server.

Toufiq Senior Staff
5 years ago

Provide me the database and file via google drive. I will check my end first and then let you know. Thanks

Yofie Setiawan Asked this
5 years ago

Hi,

Thanks Toufiq, here i share the link to download. I also already create super admin account for you can check.

Yofie Setiawan Asked this
5 years ago

Hi Toufiq,

Can you help to check on the live site? Details attached...

Yofie Setiawan Asked this
5 years ago

Hi Toufiq,

Try to open a Joomla Article, and save with SPPB as editor.

Log in to reply.