Black Friday 2026 50% off every plan Our biggest deal of the year on #1 Joomla products.
Ends in 12d 05h 08m 55s
Claim 50% off
Solved SP Page Builder

Field 'asset_id' doesn't have a default value

Asked by Elmir Mustafic 2 years ago Last activity 2 years ago

Hello,
On brand new Joomla 5.1.2 website I have installed SP Page Builder 5.3.4 Pro. When I enable Article integration I get the following error: Save failed with the following error: Field 'asset_id' doesn't have a default value.

If I disable integration there is no problems with saving. What should I do?

Accepted answer

Marked as the solution
Ofi Khan Staff

I don't know what is the use of tamper column in your content table. However, I have run this SQL query to solve this.

ALTER TABLE `fy0n7_content` CHANGE `tamper` `tamper` INT(11) NOT NULL DEFAULT '1';
Elmir Mustafic Asked this

Thank you, it works now.

Ofi Khan Staff

You are welcome 😊

I have a humble request. It would be very kind of you if you can manage some moment to give us feedback on 

  1. Joomla Extension Directory
  2. TrustPilot

This will inspire us to improve.

10 more replies

Ofi Khan Staff

Hello Elmir Mustafic

Apology for the inconvenience. Please share your administrator access here to check the issue. Use the Hidden Content box to share the credentials. Make sure that you have a full site backup with you before sharing.

Best regards

Elmir Mustafic Asked this

Hello, here we go.

Ofi Khan Staff

Sorry, I have checked but could not find the issue. Please share a screenshot of your issue to understand it better. Take a screenshot and share via any platform. For example: Lightshot or Imgur

Elmir Mustafic Asked this

Osrry, my bad, I forgot to to say that error occuors when I create new article and try to save. Here is the screenshot
https://imgur.com/a/PAhT8nO

Ofi Khan Staff

Please run this SQL query on your site and let me know.

ALTER TABLE `xxxxx_sppagebuilder` CHANGE `asset_id` `asset_id` INT NOT NULL DEFAULT '0';
Ofi Khan Staff
2 years ago · edited

Please try this SQL query

ALTER TABLE `fy0n7_content` CHANGE `asset_id` `asset_id` INT UNSIGNED NOT NULL DEFAULT '0' COMMENT 'FK to the #__assets table.';

The previous query is

ALTER TABLE `fy0n7_sppagebuilder` CHANGE `asset_id` `asset_id` INT NOT NULL DEFAULT '0';
Elmir Mustafic Asked this

I executed it but when saving new artcile I'm getting the following error: "Save failed with the following error: Field 'tamper' doesn't have a default value"
https://imgur.com/a/h1TVfeY

Elmir Mustafic Asked this

So any updates? Client need working website... After your second MYSQL querry now even disabling Article integration I can't save new articles getting the following error: "Save failed with the following error: Field 'tamper' doesn't have a default value" https://imgur.com/a/h1TVfeY

Ofi Khan Staff

Please take a full site backup with Akeeba Backup in ZIP format and share here. Follow this tutorial. I will check it on my localhost.

Elmir Mustafic Asked this

Can you donwload it directly from website? File is Backup taken on Friday, 26 July 2024 12:01 UTC (2 parts)

Elmir Mustafic Asked this

Did you download backup?

Ofi Khan Staff

Apology for the inconvenience. Because of a nationwide internet blackout, we could not respond to you earlier. We are still communicating with limited connectivity and trying to help as much as possible.

I have downloaded and installed the backup on my localhost. There are no issues. Please check this backup on your server. Follow this tutorial if needed.

Elmir Mustafic Asked this

Hello, thank you for the answer, but there is still a problem. The error occurs when you create a new article and try to save. I tried on 2 different servers and it's still there.
https://prnt.sc/isCrYq_X7kjp

Ofi Khan Staff

There is no field named tamper on the database table. Please check Content table structure on database.

Elmir Mustafic Asked this

Error showed after the SQL Query you provided me:

ALTER TABLE `fy0n7_content` CHANGE `asset_id` `asset_id` INT UNSIGNED NOT NULL DEFAULT '0' COMMENT 'FK to the #__assets table.';
Ofi Khan Staff

Please share your database access. I will fix it.

Elmir Mustafic Asked this

Here is the backup with just first error: Field 'asset_id' Doesn't have A Default Value
The error display if you try to save a new article.

Ofi Khan Staff

I have run this SQL Query on your database. Please check your issue.

ALTER TABLE `fy0n7_content` CHANGE `asset_id` `asset_id` INT UNSIGNED NOT NULL DEFAULT '0'
Elmir Mustafic Asked this
2 years ago · edited

Again, after that query the new error shows: Save failed with the following error: Field 'tamper' doesn't have a default value

Log in to reply.