PhotoPlog

PhotoPlog (http://www.photoplog.com/forum/index.php)
-   Bugs & Issues Tracker (http://www.photoplog.com/forum/forumdisplay.php?f=8)
-   -   [Closed via Lite v.2.0.2] Error when deleting image (http://www.photoplog.com/forum/showthread.php?t=124)

Morgan 03-09-2006 07:24 PM

[Closed via Lite v.2.0.2] Error when deleting image
 
Extraneous variable in query can cause this error:
Code:

Invalid SQL:
DELETE FROM photoplog_ratecomment
WHERE fileid = 228
AND photoplog_fileuploads.moderate = 0;

MySQL Error : Unknown table 'photoplog_fileuploads' in where clause
Error Number : 1109

In the PhotoPlog delete.php file find:
Code:

$db->query_write("DELETE FROM photoplog_ratecomment
                WHERE fileid = ".intval($photoplog_file_id)."
                $photoplog_admin_sql1
");

And replace with the following:
Code:

$db->query_write("DELETE FROM photoplog_ratecomment
                WHERE fileid = ".intval($photoplog_file_id)."
");


Morgan 03-10-2006 01:18 AM

Now that vBorg is back up, the Lite v.2.0.1 ZIP has been updated as of the date of this post. Either make the change shown in post one of this thread, or download the ZIP and FTP the PhotoPlog delete.php file, overwriting the old file.


All times are GMT. The time now is 02:29 AM.

Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.