• Welcome to the Chevereto User Community!

    Here, users from all over the world come together to learn, share, and collaborate on everything related to Chevereto. It's a place to exchange ideas, ask questions, and help improve the software.

    Please keep in mind:

    • This community is user-driven. Always be polite and respectful to others.
    • Support development by purchasing a Chevereto license, which also gives you priority support.
    • Go further by joining the Community Subscription for even faster response times and to help sustain this space
  • Chevereto Support CLST

    Support response

    Support checklist

    • Got a Something went wrong message? Read this guide and provide the actual error. Do not skip this.
    • Confirm that the server meets the System Requirements
    • Check for any available Hotfix - your issue could be already reported/fixed
    • Read documentation - It will be required to Debug and understand Errors for a faster support response

update error problems

Status
Not open for further replies.
D

dandanch

Chevereto Member
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

  • InkedScreenshot_2019-07-07 Upload Image, Free Image Hosting_LI.jpg
    InkedScreenshot_2019-07-07 Upload Image, Free Image Hosting_LI.jpg
    580.4 KB · Views: 8
  • Screenshot_2019-07-07 Update failed - Chevereto 3 13 3.png
    Screenshot_2019-07-07 Update failed - Chevereto 3 13 3.png
    20.7 KB · Views: 8
  • Screenshot_2019-07-11 148 251 88 71 localhost imgsnp_jenda1 phpMyAdmin 4 8 5.png
    Screenshot_2019-07-11 148 251 88 71 localhost imgsnp_jenda1 phpMyAdmin 4 8 5.png
    11.5 KB · Views: 6
Sort by date Sort by votes
Images not showing with a broken image means that your file restore is not working and the system can't locate the content.
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Status
Not open for further replies.
Back
Top