Broken upload with mysql error (3.6.2)

[Pierre Lannoy]

Hello Rodolfo.
When I try to upload an image, the frontend give me an error and, in my logs I've got a mysql error :

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'modl_pics.chv_images' doesn't exist, referer: https://modl.pics/

The issue is the table prefix, I think... I've set no prefix, so my table name is :

modl_pics.images

Could you provide me a quick fix before 3.6.3 ?

Thanks in advance.
Pierre

 

[Rodolfo]

app/lib/classes/class.image.php

Replace this:

$db->query('SELECT * FROM chv_images WHERE image_md5=:md5 AND image_uploader_ip=:ip AND image_date_gmt > :date_gmt');

With this:

$db->query('SELECT * FROM ' . DB::getTable('images') . ' WHERE image_md5=:md5 AND image_uploader_ip=:ip AND image_date_gmt > :date_gmt');

This has been already patched in the v3.6.2 download. For those who already have 3.6.2 either apply this patch or just re-download v3.6.2 with the patched file.

 

[Pierre Lannoy]

Thank you, Rodolfo.
I've done the modification and all is ok now !

You are super responsive, thank you again to you!