13 replies to this topic

[Brad]

I have a little problem.

Everyone knows the dreaded sql error page. (The one with the box of writing).

Well, I have them on my website sometimes, and sometimes not. But I believe they should never come up. How can I fix it?

[Michael]

I'd have to know what the specific error is, it'll come up for any number of reasons and you have to see what it was trying to do when it got the error to find out how to fix it.

[Brad]

When the error appears again, I will show you a screenshot

[Brad]

Well, sorry for the long time waiting . I have the picture of it, and Im almost certain it has something to do with the HTML Signature Permission mod.



This doesnt happen all the time, but it would be nice if it didnt happen at all.

Thanks

[maruf]

Just shoot an e-mail to your host. Somehow your database got messed up. it happened to me a few days ago but they corrected it for me

[Brad]

Ok, I'll check that out, thanks

[DistantWords]

Your host isn't Vizaweb is it?  Because that's been happening to me a LOT as well.  I've been getting emails from the host talking about difficulties on their end or something...

[Brad]

Nah, I'm with http://1and1.com

[Michael]

I would need to see that full error message to know what the problem is.  Instead of posting a screenshot of the error, please copy and paste the error message into a post here.  The critical part of that error message, the part that it actually is having problems with, is below that actual text visual in your screenshot.

[Brad]

Ok, I'll get do that as soon as I can!

[Brad]

CODE

mySQL query error: SELECT m.id,m.name,m.mgroup,m.email,m.joined,m.posts, m.last_visit, m.last_activity,
                 m.warn_level, m.warn_lastwarn, m.members_display_name,
                 me.*,
                g.g_id, g.g_title, g.g_icon, g.g_dohtml, g.g_sightml mt.*, msg.*
                FROM RPmessage_topics mt
                 LEFT JOIN RPmessage_text msg ON (mt.mt_msg_id=msg.msg_id)
                 LEFT JOIN RPmembers m ON (mt.mt_from_id=m.id)
                 LEFT JOIN RPmember_extra me ON (mt.mt_from_id=me.id)
                 LEFT JOIN RPgroups g ON (g.g_id=m.mgroup)
                WHERE mt.mt_owner_id=1286 AND mt.mt_vid_folder='in' ORDER BY mt_date DESC LIMIT 0,1

SQL error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '.*, msg.*
                FROM RPmessage_topics mt
                 LEFT JOIN RPmessa
SQL error code:
Date: Tuesday 15th of November 2005 11:13:16 AM

I wonder if this is the problem behind my PM box problem aswel??

[Michael]

Open your sources/sql/mysql_queries.php file and find function msg_get_new_pm_notification.  Look for the g.g_sightml in that function and put a comma after it:

CODE

    # Updated (msg_get_new_pm_notification) in v2.1 [changed LIMIT ADDED m.members_display_name ]
    function msg_get_new_pm_notification( $a )
    {
        return "SELECT m.id,m.name,m.mgroup,m.email,m.joined,m.posts, m.last_visit, m.last_activity,
                 m.warn_level, m.warn_lastwarn, m.members_display_name,
                 me.*,
                g.g_id, g.g_title, g.g_icon, g.g_dohtml, g.g_sightml, mt.*, msg.*
                FROM ".SQL_PREFIX."message_topics mt
                 LEFT JOIN ".SQL_PREFIX."message_text msg ON (mt.mt_msg_id=msg.msg_id)
                 LEFT JOIN ".SQL_PREFIX."members m ON (mt.mt_from_id=m.id)
                 LEFT JOIN ".SQL_PREFIX."member_extra me ON (mt.mt_from_id=me.id)
                 LEFT JOIN ".SQL_PREFIX."groups g ON (g.g_id=m.mgroup)
                WHERE mt.mt_owner_id={$a['mid']} AND mt.mt_vid_folder='in' ORDER BY mt_date DESC LIMIT {$a['limit_a']},1";
    }

[Brad]

Errors have been fixed, and the PM box problem is now rectified. All this has been fixed from one little comma!

Thanks alot, you may now close this and the pm box topic

[Michael]

The issue this topic was opened for has now been resolved.  If you need further assistance, please open a new topic.  If this topic was closed prematurely, please contact me so I can re-open it.

Topic Closed