Support

Site Restoration

#37787 ErrNo #1101Not Null Default

Posted in ‘Site restoration’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version
8.0
CMS Type
Joomla!
CMS Version
4.2.3
Backup Tool Version
9.2.0
Kickstart version
7.1.2 Pro

Latest post by mooreman1 on Wednesday, 28 September 2022 07:35 CDT

mooreman1

We have taken a copy of a client's site we are building on Rochen:

Php 8.0 

DB: MariaDB -version: 10.3.36

and attempting to move a copy to it's new VPS. The VPS was created by a tech company Cloud Tech that the client has paid for a hosting account. The server there uses:

PHP: 8.0

DB: MySQL Community Server -version: 8.0.30 

I am attaching the error log we receive. We have been using Akeeba Backup and Restore for about a decade and have never run into this issue. I would bet that there is something going on with the different databases, but can't tell what. The db tables are created during the restoration, in fact the script almost completes, then just when it is almost done we get this error.

Have you ever seen this before? Are we doing something wrong or is there a particular setting that we aren't configuring correctly?

nicholas
Akeeba Staff
Manager

The problem is in the original site.

Some third party extension or someone with database access has modified the #__content table, fulltext column to have a default value of . (a single dot). This didn't do anything since MySQL 5.0 and is forbidden as of MySQL 8.0.

Edit the original site's table and remove the default value from that column.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

mooreman1

Ok, that makes sense. We'll remove that default value and figure out how it got there. We use a component that may modify that content table that I feel is probably responsible for it.

Thank you so much for your time!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!