c0w Posted May 2, 2013 Share Posted May 2, 2013 My website has this error. How do I fix? SQL Log. https://mega.co.nz/#!U5UyCBpA!LgL3TShv7A7R4acKF9EUN39-xTYmCYDowlzdfQSAL5M Link to comment Share on other sites More sharing options...
0 c0w Posted May 2, 2013 Author Share Posted May 2, 2013 Date: Thu, 02 May 2013 16:05:23 +0000 Error: 1064 - 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 '4,) AND s.login_type NOT IN (1)' at line 2 IP Address: 187.14.165.170 - / ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT s.member_id, s.member_name, s.seo_name, s.member_group,p.pp_thumb_photo,m.title FROM sessions s LEFT JOIN profile_portal p ON ( p.pp_member_id = s.member_id ) LEFT JOIN members m ON ( m.member_id = s.member_id ) WHERE s.running_time > 1367509823 AND s.member_group IN (,4,) AND s.login_type NOT IN (1) .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admincp/sources/classes/output/publicOutput.php | [mmstaffOnlineSidebarBlock].getOutput | 3769 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admincp/sources/classes/output/publicOutput.php(3833) : eval()'d code | [output].templateHooks | 6 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admincp/sources/classes/output/formats/html/htmlOutput.php | [shoutboxGlobalJs].globalTemplate | 312 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admincp/sources/classes/output/publicOutput.php | [htmlOutput].fetchOutput | 2963 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admincp/applications/forums/modules_public/forums/boards.php | [output].sendOutput | 124 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admincp/sources/base/ipsController.php | [public_forums_forums_boards].doExecute | 306 | Link to comment Share on other sites More sharing options...
0 Administrator Tony Posted May 2, 2013 Administrator Share Posted May 2, 2013 The question(s) in this support topic have been answered and the owner has been able to solve the problem. Because of this, the support topic has been closed and moved.If you have other questions, please open a new topic. Link to comment Share on other sites More sharing options...
Question
c0w
My website has this error. How do I fix?
SQL Log. https://mega.co.nz/#!U5UyCBpA!LgL3TShv7A7R4acKF9EUN39-xTYmCYDowlzdfQSAL5M
Link to comment
Share on other sites
2 answers to this question
Recommended Posts