sql_error_log's jak zażegnać błędy.

[Cleric]

Witam.

Ostatnio zauważyłem że mam troche błędów w logach. Wiekszość się powtarza i mam pytanie jak je usunąć raz na zawsze.

Oto logi:

upload.zip

[DawPi]

O kolego. Wybierz pojedyncze pozycje i je wklej w treść postu, nie będę przeglądać tyle tekstu.

[Cleric]

1

 Date: Thu, 26 Nov 2009 15:05:58 +0000
Error Number: 1146
Error: Table 'forum_DsNet.cache_store' doesn't exist
IP Address: 83.6.194.92
Page: /forum/index.php?&app=shoutbox&module=ajax&section=coreAjax&secure_key=880ea6a14ea49e853634fbdc5015a024&type=getShouts&lastid=0&global=1
Debug: array (
 1 => 
 array (
   'file' => '/var/www/forum/ips_kernel/classDb.php',
   'line' => 1010,
   'function' => 'query',
   'class' => 'db_driver_mysql',
 ),
 3 => 
 array (
   'file' => '/var/www/forum/admin/sources/base/ipsRegistry.php',
   'line' => 2466,
   'function' => '_loadCaches',
   'class' => 'ips_CacheRegistry',
 ),
 4 => 
 array (
   'file' => '/var/www/forum/admin/sources/base/ipsRegistry.php',
   'line' => 2302,
   'function' => 'init',
   'class' => 'ips_CacheRegistry',
 ),
 5 => 
 array (
   'file' => '/var/www/forum/admin/sources/base/ipsRegistry.php',
   'line' => 495,
   'function' => 'instance',
   'class' => 'ips_CacheRegistry',
 ),
)
mySQL query error: SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','shoutbox_shouts','shoutbox_mods','report_cache','emoticons','ranks','reputation_levels' )

2

Date: Thu, 26 Nov 2009 15:07:22 +0000
Error Number: 1064
Error: Something is wrong in your syntax obok 'AND cache_type IN ('css', 'replacements')' w linii 1
IP Address: 194.54.21.221
Page: /forum/
Debug: array (
 1 => 
 array (
   'file' => '/var/www/forum/ips_kernel/classDb.php',
   'line' => 1010,
   'function' => 'query',
   'class' => 'db_driver_mysql',
 ),
 3 => 
 array (
   'file' => '/var/www/forum/admin/sources/base/ipsRegistry.php',
   'line' => 540,
   'function' => '__construct',
   'class' => 'output',
 ),
)
mySQL query error: SELECT * FROM skin_cache WHERE cache_set_id= AND cache_type IN ('css', 'replacements')

3

Date: Fri, 27 Nov 2009 10:56:16 +0000
Error Number: 1064
Error: Something is wrong in your syntax obok ')  GROUP BY t.forum_id ORDER BY f_posts DESC LIMIT 0,1' w linii 1
IP Address: 79.184.52.239
Page: /index.php?/user/3-cleric/
Debug: array (
 1 => 
 array (
   'file' => '/var/www/forum/ips_kernel/classDb.php',
   'line' => 1010,
   'function' => 'query',
   'class' => 'db_driver_mysql',
 ),
 4 => 
 array (
   'file' => '/var/www/forum/admin/applications/members/modules_public/profile/view.php',
   'line' => 77,
   'function' => '_viewModern',
   'class' => 'public_members_profile_view',
 ),
 5 => 
 array (
   'file' => '/var/www/forum/admin/sources/base/ipsController.php',
   'line' => 291,
   'function' => 'doExecute',
   'class' => 'public_members_profile_view',
 ),
)
mySQL query error: SELECT COUNT(p.author_id) as f_posts,t.forum_id FROM posts p  LEFT JOIN topics t ON ( t.tid=p.topic_id )   WHERE p.author_id=3 AND t.forum_id IN ()  GROUP BY t.forum_id ORDER BY f_posts DESC LIMIT 0,1

4

 Date: Fri, 27 Nov 2009 12:25:06 +0000
Error Number: 1054
Error: Nieznana kolumna 'map_last_topic_reply' w  field list
IP Address: 80.50.238.78
Page: /index.php?&app=members&module=ajax&secure_key=be94c8af94350fd97cbda48245a26e2a&section=messenger&do=PMSend&toMemberID=2
Debug: array (
 1 => 
 array (
   'file' => '/var/www/forum/ips_kernel/classDb.php',
   'line' => 1095,
   'function' => 'query',
   'class' => 'db_driver_mysql',
 ),
 3 => 
 array (
   'file' => '/var/www/forum/admin/applications/members/sources/classes/messaging/messengerFunctions.php',
   'line' => 1857,
   'function' => 'insert',
   'class' => 'db_main_mysql',
 ),
 4 => 
 array (
   'file' => '/var/www/forum/admin/applications/members/modules_public/ajax/messenger.php',
   'line' => 153,
   'function' => 'sendNewPersonalTopic',
   'class' => 'messengerFunctions',
 ),
 5 => 
 array (
   'file' => '/var/www/forum/admin/applications/members/modules_public/ajax/messenger.php',
   'line' => 73,
   'function' => '_PMSend',
   'class' => 'public_members_ajax_messenger',
 ),
 6 => 
 array (
   'file' => '/var/www/forum/admin/sources/base/ipsController.php',
   'line' => 412,
   'function' => 'doExecute',
   'class' => 'public_members_ajax_messenger',
 ),
 7 => 
 array (
   'file' => '/var/www/forum/admin/sources/base/ipsController.php',
   'line' => 91,
   'function' => 'execute',
   'class' => 'ipsAjaxCommand',
 ),
)
mySQL query error: INSERT INTO message_topic_user_map (map_user_id,map_topic_id,map_folder_id,map_user_active,map_is_starter,map_has_unread,map_read_time,map_is_system,map_last_topic_reply) VALUES(2,1,'myconvo',1,0,1,0,0,1259324706)

5 wiele razy się powtarza.

 Date: Fri, 27 Nov 2009 12:26:22 +0000
Error Number: 1054
Error: Nieznana kolumna 'mm.map_last_topic_reply' w  order clause
IP Address: 83.6.194.92
Page: /index.php?app=members&module=messaging
Debug: array (
 1 => 
 array (
   'file' => '/var/www/forum/ips_kernel/classDb.php',
   'line' => 1010,
   'function' => 'query',
   'class' => 'db_driver_mysql',
 ),
 3 => 
 array (
   'file' => '/var/www/forum/admin/applications/members/modules_public/messaging/view.php',
   'line' => 762,
   'function' => 'getPersonalTopicsList',
   'class' => 'messengerFunctions',
 ),
 4 => 
 array (
   'file' => '/var/www/forum/admin/applications/members/modules_public/messaging/view.php',
   'line' => 143,
   'function' => '_showFolder',
   'class' => 'public_members_messaging_view',
 ),
 5 => 
 array (
   'file' => '/var/www/forum/admin/sources/base/ipsController.php',
   'line' => 291,
   'function' => 'doExecute',
   'class' => 'public_members_messaging_view',
 ),
)
mySQL query error: SELECT mm.*,mt.*,msg.*,mem.members_display_name FROM message_topic_user_map mm  LEFT JOIN message_topics mt ON ( mm.map_topic_id=mt.mt_id ) 
LEFT JOIN message_posts msg ON ( msg.msg_id=mt.mt_last_msg_id ) 
LEFT JOIN members mem ON ( mt.mt_to_member_id=mem.member_id )   WHERE mm.map_user_id=3 AND mm.map_user_active=1 AND mm.map_folder_id='myconvo' ORDER BY mm.map_last_topic_reply DESC LIMIT 0,50

6

Date: Sun, 06 Dec 2009 16:02:02 +0000
Error Number: 2006
Error: MySQL server has gone away
IP Address: 95.41.222.123
Page: /index.php?app=core&module=attach&section=attach&attach_id=29
Debug: array (
 1 => 
 array (
   'file' => '/var/www/forum/ips_kernel/classDb.php',
   'line' => 1010,
   'function' => 'query',
   'class' => 'db_driver_mysql',
 ),
 3 => 
 array (
   'file' => '/var/www/forum/admin/sources/classes/itemmarking/classItemMarking.php',
   'line' => 1167,
   'function' => 'manualCleanUp',
   'class' => 'classItemMarking',
 ),
 4 => 
 array (
   'file' => '/var/www/forum/admin/sources/base/ipsRegistry.php',
   'line' => 3098,
   'function' => '__myDestruct',
   'class' => 'classItemMarking',
 ),
 5 => 
 array (
   'file' => '/var/www/forum/admin/sources/base/ipsRegistry.php',
   'line' => 229,
   'function' => '__myDestruct',
   'class' => 'ips_MemberRegistry',
 ),
)
mySQL query error: SELECT item_member_id, item_last_updated, item_last_saved FROM core_item_markers_storage WHERE item_last_saved < 1260108122 ORDER BY item_last_saved ASC LIMIT 0,50

[DawPi]

1. Error: Table 'forum_DsNet.cache_store' doesn't exist
   
2. Error: Something is wrong in your syntax obok 'AND cache_type IN ('css', 'replacements')' w linii 1
   mySQL query error: SELECT * FROM skin_cache WHERE cache_set_id= AND cache_type IN ('css', 'replacements')
   
3. Error: Something is wrong in your syntax obok ') GROUP BY t.forum_id ORDER BY f_posts DESC LIMIT 0,1' w linii 1
   mySQL query error: SELECT COUNT(p.author_id) as f_posts,t.forum_id FROM posts p LEFT JOIN topics t ON ( t.tid=p.topic_id ) WHERE p.author_id=3 AND t.forum_id IN () GROUP BY t.forum_id ORDER BY f_posts DESC LIMIT 0,1
   
4. Error: Nieznana kolumna 'map_last_topic_reply' w field list
   
5. Error: MySQL server has gone away
   

Ad 1 - jak sama nazwa wskazuje - nie ma takiej tabeli w bazie.

Ad 2 - przebuduj cache. Powinno pomóc.

Ad 3 - poprawione w 3.0.5. Link.

Ad 4 - błąd, który pojawił się na forum już chyba kilkanaście razy. W szukajce wpisz frazę map_last_topic_reply i Ci znajdzie wyniki, oraz sposoby, jak sobie z nim radzić.

Ad 5 - błąd serwera SQL. Nie chciał/nie potrafił/nie mógł obsłużyć zapytania więc strzelił focha. A poważnie to nieokreślony błąd. Bez znajomości zarządzania serwerami i dostępu do logów etc. nie można jednoznacznie napisać o co chodzi.