Cannot delete images, cannot upload image

[Mikelandjelo]

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.

 

[Mikelandjelo]

Image deleted only from hdd, but stay in DB

 

[Rodolfo]

Image deleted only from hdd, but stay in DB

Chevereto doesn't map your HDD so changes you made in the filesystem won't be reflected in the DB.

 

[Mikelandjelo]

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

 

[Mikelandjelo]

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'

 

[Rodolfo]

Attach your chv_images table structure to take a look. Structure only, not data.

 

[Mikelandjelo]

done

 

[Rodolfo]

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.

 

[Mikelandjelo]

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

 

[Rodolfo]

Enable debug, get the actual error and paste it here.

Debug | V3 Docs

Documentation for Chevereto image hosting software (V3)

chevereto.com

 

[Mikelandjelo]

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

 

[Rodolfo]

Just uploaded without issues. http://fotoshara.ru/image/BPVQ

Seems to me that this is just a poorly configured server. I really doubt that this has anything to do with Chevereto.

 

[Mikelandjelo]

Last issue about delete images. Uploading is working now correctly

 

[Rodolfo]

You should repair all your tables auto_increment, most likely your DB dump put everything on 0.

 

[Mikelandjelo]

Where i can find original structure of DB?

 

[Rodolfo]

app/install/sql/*

 

[Mikelandjelo]

ok. working now. big thanks!