Saurabh Jain Posted June 8, 2015 Share Posted June 8, 2015 Ticket raised too Link to comment Share on other sites More sharing options...
MADMAN32395 Posted June 8, 2015 Share Posted June 8, 2015 any logs, what are we looking at exactly? Link to comment Share on other sites More sharing options...
Kevin Carwile Posted June 8, 2015 Share Posted June 8, 2015 SQL database query error. You should look in your acp in the System -> Support -> System Logs page for more details. Link to comment Share on other sites More sharing options...
Saurabh Jain Posted June 9, 2015 Author Share 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 Link to comment Share on other sites More sharing options...
Saurabh Jain Posted June 9, 2015 Author Share 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 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.