PhotoPlog

PhotoPlog (http://www.photoplog.com/forum/index.php)
-   Troubleshooting & Problems (http://www.photoplog.com/forum/forumdisplay.php?f=6)
-   -   Database error in vBulletin 3.8.4 (http://www.photoplog.com/forum/showthread.php?t=3452)

draque1 04-13-2010 07:25 PM

Database error in vBulletin 3.8.4
 
Code:

Invalid SQL:
SELECT photoplog_fileuploads.fileid,
                photoplog_fileuploads.filename,
                photoplog_fileuploads.userid,
                photoplog_fileuploads.username,
                photoplog_fileuploads.title,
                photoplog_fileuploads.catid,
                photoplog_fileuploads.dateline,
                photoplog_fileuploads.filesize,
                photoplog_fileuploads.dimensions,
                photoplog_fileuploads.views,
                photoplog_fileuploads.num_comments0 AS num_comments, ...

I have this error, can help me anyoane ?

Kuma 04-19-2010 08:19 PM

Can you please post the full error message?

draque1 05-02-2010 08:34 AM

Code:

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT photoplog_fileuploads.fileid,
                photoplog_fileuploads.filename,
                photoplog_fileuploads.userid,
                photoplog_fileuploads.username,
                photoplog_fileuploads.title,
                photoplog_fileuploads.catid,
                photoplog_fileuploads.dateline,
                photoplog_fileuploads.filesize,
                photoplog_fileuploads.dimensions,
                photoplog_fileuploads.views,
                photoplog_fileuploads.num_comments1 AS num_comments,
                                                photoplog_fileuploads.num_ratings1 AS num_ratings,
                                                photoplog_fileuploads.sum_ratings1 AS sum_ratings,
                                                IF(photoplog_fileuploads.num_ratings1 > 0,photoplog_fileuploads.sum_ratings1 / photoplog_fileuploads.num_ratings1,0) AS ave_ratings,
                                                photoplog_fileuploads.last_comment_dateline1 AS last_comment_dateline,
                                                photoplog_fileuploads.last_comment_id1 AS last_comment_id
                FROM photoplog_fileuploads
                WHERE 1=1
                AND photoplog_fileuploads.fileid >= 1
             
             
                ORDER BY photoplog_fileuploads.dateline DESC, photoplog_fileuploads.fileid DESC
                LIMIT 4;

MySQL Error  : MySQL server has gone away
Error Number  : 2006
Request Date  : Sunday, May 2nd 2010 @ 03:29:37 AM
Error Date    : Sunday, May 2nd 2010 @ 03:30:02 AM
Script        :
Referrer      :
IP Address    : 188.27.7.76
Username      :
Classname    : vB_Database
MySQL Version :


Morgan 05-02-2010 03:22 PM

Quote:

MySQL Error : MySQL server has gone away
That is not a PhotoPlog error. It is a MySQL problem. vBulletin has a page about it here: http://www.vbulletin.com/docs/html/t...mysql_goneaway

draque1 05-02-2010 09:12 PM

Thanks man.

parker 10-21-2010 04:35 AM

Thanks man.


All times are GMT. The time now is 08:08 PM.

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