update error problems

Status
Not open for further replies.

dandanch

Network license
License owner
Description of the issue

For some reason after doing a server change I got image problems, and when I tried to do an update I got those sql errors as well.

My old server was using MariaDB 10.0 and the new server is using MariaDB 10.3 PHP 72.


ALTER TABLE `chv_settings` MODIFY `setting_name` varchar(191) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
ALTER TABLE `chv_deletions` MODIFY `deleted_content_ip` varchar(191) NOT NULL;
ALTER TABLE `chv_deletions` MODIFY `deleted_content_original_filename` varchar(191) DEFAULT NULL;
UPDATE `chv_settings` SET `setting_value` = "3.13.3" WHERE `setting_name` = "chevereto_version_installed";

Update query issues

SQLSTATE[01000]: Warning: 1265 Data truncated for column 'deleted_content_original_filename' at row 704
 

Attachments

Rodolfo

Chevereto Developer
Chevereto Staff
Images not showing with a broken image means that your file restore is not working and the system can't locate the content.
 

Rodolfo

Chevereto Developer
Chevereto Staff
The images (actual files) are delivered by your server so you should check if you actually migrated the files and that your webserver is properly serving these.
 

Support

New Member
Chevereto Staff
Unfortunately, this ticket has more than seven days without a reply or feedback from the original poster. We will now consider this ticket abandoned and its now closed.

Don't hesitate to create a new ticket if this matter is still causing you issues.

Ticket closed.
 
Status
Not open for further replies.
Top