• Welcome to the Chevereto user community!

    Here users from all over the world gather around to learn the latest about Chevereto and contribute with ideas to improve the software.

    Please keep in mind:

    • 😌 This community is user driven. Be polite with other users.
    • 👉 Is required to purchase a Chevereto license to participate in this community (doesn't apply to Pre-sales).
    • 💸 Purchase a Pro Subscription to get access to active software support and faster ticket response times.
  • Chevereto Support CLST

    Support response

    Support checklist

Cannot delete images, cannot upload image

Mikelandjelo

Chevereto Member
Hello!
Moved to new hosting.
If i upload a image i got error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'

If i delete image from admin - i get error: An error occurred. Please try again later.
 
i dont delete file from hdd, i deleted image from Dashboard Images and get error - An error occurred. Please try again later.
after Reload page i saw this picture screenshot i sent you

Script deleted images from hdd but dont delete from sql
 
Last edited:
Could you help me with uploading files? When I upload a picture I get an error.
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
 

Attachments

  • Clip_2.jpg
    Clip_2.jpg
    56.9 KB · Views: 1
Go to your conflicting db table and make sure to reclect an auto increment value = last id + 1.

Problem here is the missing auto increment value.
 
Fixed. (AUTO_INCREMENT for image_id) Uploads is working now. Thanks.

But second problem still existing..

Dashboard - Images - most recent - Delete an image (Error: An error occurred. Please try again later. )
Reload Page - and i see black square
attaches screenshots for show
 

Attachments

  • Clip_2.jpg
    Clip_2.jpg
    171.8 KB · Views: 1
  • Clip_3.jpg
    Clip_3.jpg
    121.2 KB · Views: 1
  • Clip_4.jpg
    Clip_4.jpg
    113.1 KB · Views: 0
debug_level = 3
dasboard - settings- system - PHP error reporting = enable

But see nothing any php error except for "An error occurred. Please try again later."

I see something in error.log:

[Fri Feb 01 18:21:33 2019] [warn] [client 1**] mod_fcgid: stderr: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' (LINE:467), referer: http://www.**.ru/dashboard/images
[Fri Feb 01 18:21:35 2019] [warn] [client 1***] mod_fcgid: stderr: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' (LINE:467), referer: http://www.**.ru/dashboard/images
 
Back
Top