Kevin Carwile Posted June 8, 2015 Posted June 8, 2015 SQL database query error. You should look in your acp in the System -> Support -> System Logs page for more details.
Saurabh Jain Posted June 9, 2015 Author Posted June 9, 2015 Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | /system/Db/Db.php | [IPS\Db\_Exception].__construct | 121 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Session/Front.php | [IPS\_Db].i | 109 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [IPS\Session\_Front].read | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Session/Session.php | [].session_start | 91 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Member/Member.php | [IPS\_Session].i | 125 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Dispatcher/Standard.php | [IPS\_Member].loggedIn | 129 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Dispatcher/Front.php | [IPS\Dispatcher\_Standard].init | 139 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Dispatcher/Dispatcher.php | [IPS\Dispatcher\_Front].init | 86 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /index.php | [IPS\_Dispatcher].i | 13 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ------------------------------------------------------------------------ Mon, 08 Jun 2015 19:12:43 +0000 (Severity: 0) 82.145.216.26 - http://mechanical-engg.com/forum/forum/32-mechanical-engineering-applications.xml 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 'IS NULL AND forums_topics.forum_id=? AND forums_topics.moved_to IS NULL AND foru' at line 1 SELECT SQL_CALC_FOUND_ROWS forums_topics.*, author.*, last_commenter.*, core_tags_cache.tag_cache_text FROM `ibf_forums_topics` AS `forums_topics` LEFT JOIN `ibf_core_tags_cache` AS `core_tags_cache` ON tag_cache_key=MD5(CONCAT(?,forums_topics.tid)) LEFT JOIN `ibf_core_members` AS `author` ON author.member_id = forums_topics.starter_id LEFT JOIN `ibf_core_members` AS `last_commenter` ON last_commenter.member_id = forums_topics.last_poster_id WHERE starter_id = IS NULL AND forums_topics.forum_id=? AND forums_topics.moved_to IS NULL AND forums_topics.approved=1 ORDER BY forums_topics.pinned DESC, last_real_post desc LIMIT 0,25 Array ( [0] => forums;forums; [1] => 32 ) | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | /system/Db/Db.php | [IPS\Db\_Exception].__construct | 363 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Db/Select.php | [IPS\_Db].preparedQuery | 321 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Db/Select.php | [IPS\Db\_Select].runQuery | 516 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Patterns/ActiveRecordIterator.php | [IPS\Db\_Select].count | 62 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Helpers/Table/Content.php | [IPS\Patterns\_ActiveRecordIterator].count | 246 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /applications/forums/modules/front/forums/forums.php | [IPS\Helpers\Table\_Content].getRows | 336 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /applications/forums/modules/front/forums/forums.php | [IPS\forums\modules\front\forums\_forums]._forum | 39 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Dispatcher/Controller.php | [IPS\forums\modules\front\forums\_forums].manage | 94 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Dispatcher/Dispatcher.php | [IPS\Dispatcher\_Controller].execute | 129 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /index.php | [IPS\_Dispatcher].run | 13 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ------------------------------------------------------------------------ Mon, 08 Jun 2015 19:19:00 +0000 (Severity: 0) 82.145.216.26 - http://mechanical-engg.com/forum/forum/32-mechanical-engineering-applications.xml 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 'IS NULL AND forums_topics.forum_id=? AND forums_topics.moved_to IS NULL AND foru' at line 1 SELECT SQL_CALC_FOUND_ROWS forums_topics.*, author.*, last_commenter.*, core_tags_cache.tag_cache_text FROM `ibf_forums_topics` AS `forums_topics` LEFT JOIN `ibf_core_tags_cache` AS `core_tags_cache` ON tag_cache_key=MD5(CONCAT(?,forums_topics.tid)) LEFT JOIN `ibf_core_members` AS `author` ON author.member_id = forums_topics.starter_id LEFT JOIN `ibf_core_members` AS `last_commenter` ON last_commenter.member_id = forums_topics.last_poster_id WHERE starter_id = IS NULL AND forums_topics.forum_id=? AND forums_topics.moved_to IS NULL AND forums_topics.approved=1 ORDER BY forums_topics.pinned DESC, last_real_post desc LIMIT 0,25 Array ( [0] => forums;forums; [1] => 32 ) | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | /system/Db/Db.php | [IPS\Db\_Exception].__construct | 363 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Db/Select.php | [IPS\_Db].preparedQuery | 321 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Db/Select.php | [IPS\Db\_Select].runQuery | 516 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Patterns/ActiveRecordIterator.php | [IPS\Db\_Select].count | 62 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Helpers/Table/Content.php | [IPS\Patterns\_ActiveRecordIterator].count | 246 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /applications/forums/modules/front/forums/forums.php | [IPS\Helpers\Table\_Content].getRows | 336 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /applications/forums/modules/front/forums/forums.php | [IPS\forums\modules\front\forums\_forums]._forum | 39 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Dispatcher/Controller.php | [IPS\forums\modules\front\forums\_forums].manage | 94 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /system/Dispatcher/Dispatcher.php | [IPS\Dispatcher\_Controller].execute | 129 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | /index.php | [IPS\_Dispatcher].run | 13 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ------------------------------------------------------------------------ Mon, 08 Jun 2015 19:56:32 +0000 (Severity: 0) 82.145.216.26 - http://mechanical-engg.com/forum/forum/32-mechanical-engineering-applications.xml 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 'IS NULL AND forums_topics.forum_id=? AND forums_topics.moved_to IS NULL AND foru' at line 1
Saurabh Jain Posted June 9, 2015 Author Posted June 9, 2015 In forum/cache / i can see the sql error logs but how they are related to forums ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Mon, 08 Jun 2015 00:42:21 +0000 Error: 1146 - Table 'mechanic_ipmech.ibf_cache_store' doesn't exist IP Address: 66.220.155.214 - /forum/interface/facebook/index.php ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','ranks','reputation_levels','chatting','birthdays','calendar_events','calendars','support_staff','support_departments','support_statuses','donation_goals','blog_stats','blogmods','idm_cats','idm_mods','nexus_ads','ccs_menu' ) .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/sources/base/ipsRegistry.php | [ips_CacheRegistry]._loadCaches | 3047 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsRegistry.php | [ips_CacheRegistry].init | 2841 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsRegistry.php | [ips_CacheRegistry].instance | 580 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Mon, 08 Jun 2015 14:24:59 +0000 Error: 1146 - Table 'mechanic_ipmech.ibf_cache_store' doesn't exist IP Address: 180.76.15.20 - /forum/interface/twitter/index.php?_reg=1 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','ranks','reputation_levels','chatting','birthdays','calendar_events','calendars','support_staff','support_departments','support_statuses','donation_goals','blog_stats','blogmods','idm_cats','idm_mods','nexus_ads','ccs_menu' ) .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/sources/base/ipsRegistry.php | [ips_CacheRegistry]._loadCaches | 3047 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsRegistry.php | [ips_CacheRegistry].init | 2841 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsRegistry.php | [ips_CacheRegistry].instance | 580 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Mon, 08 Jun 2015 18:34:42 +0000 Error: 1146 - Table 'mechanic_ipmech.ibf_cache_store' doesn't exist IP Address: 66.249.65.103 - /forum/interface/facebook/index.php?_reg=1 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','ranks','reputation_levels','chatting','birthdays','calendar_events','calendars','support_staff','support_departments','support_statuses','donation_goals','blog_stats','blogmods','idm_cats','idm_mods','nexus_ads','ccs_menu' ) .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/sources/base/ipsRegistry.php | [ips_CacheRegistry]._loadCaches | 3047 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsRegistry.php | [ips_CacheRegistry].init | 2841 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsRegistry.php | [ips_CacheRegistry].instance | 580 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
Recommended Posts
Archived
This topic is now archived and is closed to further replies.