Field 'asset_id' Doesn't have A Default Value
Elmir Mustafic
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?
Ofi Khan
Accepted AnswerI 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';Ofi Khan
Accepted AnswerYou 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Â
This will inspire us to improve.
Ofi Khan
Accepted AnswerHello 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
Ofi Khan
Accepted AnswerElmir Mustafic
Accepted AnswerOsrry, 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
Accepted AnswerPlease 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';Elmir Mustafic
Accepted AnswerI did https://imgur.com/fjCtGbh but still the same error
Ofi Khan
Accepted AnswerPlease 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
Accepted AnswerI 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
Accepted AnswerSo 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
Accepted AnswerPlease 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
Accepted AnswerCan you donwload it directly from website? File is Backup taken on Friday, 26 July 2024 12:01 UTC (2 parts)
Ofi Khan
Accepted AnswerApology 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
Accepted AnswerHello, 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
Elmir Mustafic
Accepted AnswerError 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
Accepted AnswerPlease share your database access. I will fix it.
Elmir Mustafic
Accepted AnswerHere 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.