Gün aşırı Veritabanı Hatası

[16melih]

alıyorum.. Veritabanını onarınca düzeliyor. Ancak her gün her gün ugrasılmaz bununla.

Fikirleriniz nelerdir?

smf_message kullanımda oluyor bu arada..

[dursunali]

tam olarak aldıgın hata nedir .

[16melih]

tam olarak aldıgın hata nedir .

"tekrar deneyin yine aynı hatayı verıiseyonetıcıye basvurun"

[dursunali]

sunucu tarafındaki logları inceleyin .

[16melih]

sunucu tarafındaki logları inceleyin .

loglarda php hataları gözüküyor? hangi log sisteminden bahsediyorsunuz?

Number of rows changed from 597524 to 1808474 hata bu

[dursunali]

MySQL loglari

[16melih]

buyrun..

Code Select Expand

[ 1328526182 ] [ ** ] [ 3846776 ] [ 139 ] [ *** ] [ Query ] [ KILLED ] [  ] [ SELECT    t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,    t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts,    t.id_last_msg + 1 AS new_from       FROM smf_topics AS t    INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg)   WHERE t.id_topic = 207431   LIMIT 1 ]
[ 1328526182 ] [ ** ] [ 3846775 ] [ 139 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,    t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts,    IFNULL(lt.id_msg, IFNULL(lmr.id_msg, -1)) + 1 AS new_from       FROM smf_topics AS t    INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg)    LEFT JOIN smf_log_topics AS lt ON (lt.id_topic = 23043 AND lt.id_member = 510389)    LEFT JOIN smf_log_mark_read AS lmr ON (lmr.id_board = 125 AND lmr.id_member = 510389)   WHERE t.id_topic = 23043   LIMIT 1 ]
[ 1328526182 ] [ ** ] [ 3846770 ] [ 140 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,    t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts,    t.id_last_msg + 1 AS new_from       FROM smf_topics AS t    INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg)   WHERE t.id_topic = 85505   LIMIT 1 ]
[ 1328526182 ] [ ** ] [ 3846769 ] [ 141 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,    t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts,    t.id_last_msg + 1 AS new_from       FROM smf_topics AS t    INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg)   WHERE t.id_topic = 50084   LIMIT 1 ]
[ 1328526182 ] [ ** ] [ 3846755 ] [ 144 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,    t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts,    t.id_last_msg + 1 AS new_from       FROM smf_topics AS t    INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg)   WHERE t.id_topic = 14875   LIMIT 1 ]
[ 1328526182 ] [ ** ] [ 3846750 ] [ 145 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,    t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts,    t.id_last_msg + 1 AS new_from       FROM smf_topics AS t    INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg)   WHERE t.id_topic = 34285   LIMIT 1 ]
[ 1328526182 ] [ ** ] [ 3846740 ] [ 146 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,    t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts,    t.id_last_msg + 1 AS new_from       FROM smf_topics AS t    INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg)   WHERE t.id_topic = 76259   LIMIT 1 ]
[ 1328526182 ] [ ** ] [ 3846739 ] [ 146 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,    t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts,    t.id_last_msg + 1 AS new_from       FROM smf_topics AS t    INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg)   WHERE t.id_topic = 25162   LIMIT 1 ]
[ 1328526182 ] [ ** ] [ 3846734 ] [ 147 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT m.id_msg    FROM smf_messages AS m     INNER JOIN smf_boards AS b ON (b.id_board = m.id_board)     INNER JOIN smf_topics AS t ON (t.id_topic = m.id_topic)    WHERE (FIND_IN_SET(-1, b.member_groups) != 0)    AND b.id_board != 298     AND m.id_msg <= b.id_last_msg AND m.id_msg >= 1869568    ORDER BY m.id_msg DESC    LIMIT 5 ]
[ 1328526182 ] [ ** ] [ 3846719 ] [ 148 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    c.id_cat, c.name AS cat_name,    b.id_board, b.name AS board_name, b.description,    CASE WHEN b.redirect != '' THEN 1 ELSE 0 END AS is_redirect,    b.num_posts, b.num_topics, b.unapproved_posts, b.unapproved_topics, b.id_parent,    IFNULL(m.poster_time, 0) AS poster_time, IFNULL(mem.member_name, m.poster_name) AS poster_name,    m.subject, m.id_topic, IFNULL(mem.real_name, m.poster_name) AS real_name,     1 AS is_read, 0 AS new_from,    IFNULL(mem.id_member, 0) AS id_member, m.id_msg,    IFNULL(mods_mem.id_member, 0) AS id_moderator, mods_mem.real_name AS mod_real_name   FROM smf_boards AS b    LEFT JOIN smf_categories AS c ON (c.id_cat = b.id_cat)    LEFT JOIN smf_messages AS m ON (m.id_msg = b.id_last_msg)    LEFT JOIN smf_members AS mem ON (mem.id_member = m.id_member)    LEFT JOIN smf_moderators AS mods ON (mods.id_board = b.id_board)    LEFT JOIN smf_members AS mods_mem ON (mods_mem.id_member = mods.id_member)   WHERE (FIND_IN_SET(-1, b.member_groups) != 0)    AND b.child_level BETWEEN 0 AND 1 ]
[ 1328526182 ] [ ** ] [ 3846716 ] [ 148 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,    t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts,    t.id_last_msg + 1 AS new_from       FROM smf_topics AS t    INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg)   WHERE t.id_topic = 80264   LIMIT 1 ]
[ 1328526182 ] [ ** ] [ 3846712 ] [ 149 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,    t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts,    IFNULL(lt.id_msg, IFNULL(lmr.id_msg, -1)) + 1 AS new_from       FROM smf_topics AS t    INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg)    LEFT JOIN smf_log_topics AS lt ON (lt.id_topic = 208416 AND lt.id_member = 519434)    LEFT JOIN smf_log_mark_read AS lmr ON (lmr.id_board = 25 AND lmr.id_member = 519434)   WHERE t.id_topic = 208416   LIMIT 1 ]
[ 1328526182 ] [ ** ] [ 3846706 ] [ 149 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,    t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts,    t.id_last_msg + 1 AS new_from       FROM smf_topics AS t    INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg)   WHERE t.id_topic = 65228   LIMIT 1 ]
[ 1328526182 ] [ ** ] [ 3846700 ] [ 150 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,    t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts,    t.id_last_msg + 1 AS new_from       FROM smf_topics AS t    INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg)   WHERE t.id_topic = 80264   LIMIT 1 ]
[ 1328526182 ] [ ** ] [ 3846695 ] [ 151 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,    t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts,    IFNULL(lt.id_msg, IFNULL(lmr.id_msg, -1)) + 1 AS new_from       FROM smf_topics AS t    INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg)    LEFT JOIN smf_log_topics AS lt ON (lt.id_topic = 203565 AND lt.id_member = 40542)    LEFT JOIN smf_log_mark_read AS lmr ON (lmr.id_board = 11 AND lmr.id_member = 40542)   WHERE t.id_topic = 203565   LIMIT 1 ]
[ 1328526182 ] [ ** ] [ 3846689 ] [ 152 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    b.id_board, b.name AS board_name, b.description,    CASE WHEN b.redirect != '' THEN 1 ELSE 0 END AS is_redirect,    b.num_posts, b.num_topics, b.unapproved_posts, b.unapproved_topics, b.id_parent,    IFNULL(m.poster_time, 0) AS poster_time, IFNULL(mem.member_name, m.poster_name) AS poster_name,    m.subject, m.id_topic, IFNULL(mem.real_name, m.poster_name) AS real_name,        (IFNULL(lb.id_msg, 0) >= b.id_msg_updated) AS is_read, IFNULL(lb.id_msg, -1) + 1 AS new_from,    IFNULL(mem.id_member, 0) AS id_member, m.id_msg,    IFNULL(mods_mem.id_member, 0) AS id_moderator, mods_mem.real_name AS mod_real_name   FROM smf_boards AS b    LEFT JOIN smf_messages AS m ON (m.id_msg = b.id_last_msg)    LEFT JOIN smf_members AS mem ON (mem.id_member = m.id_member)    LEFT JOIN smf_log_boards AS lb ON (lb.id_board = b.id_board AND lb.id_member = 589670)    LEFT JOIN smf_moderators AS mods ON (mods.id_board = b.id_board)    LEFT JOIN smf_members AS mods_mem ON (mods_mem.id_member = mods.id_member)   WHERE (FIND_IN_SET(0, b.member_groups) != 0 OR FIND_IN_SET(4, b.member_groups) != 0)    AND b.child_level BETWEEN 1 AND 2 ]
[ 1328526182 ] [ ** ] [ 3846681 ] [ 153 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,    t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts,    IFNULL(lt.id_msg, IFNULL(lmr.id_msg, -1)) + 1 AS new_from       FROM smf_topics AS t    INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg)    LEFT JOIN smf_log_topics AS lt ON (lt.id_topic = 31350 AND lt.id_member = 7748)    LEFT JOIN smf_log_mark_read AS lmr ON (lmr.id_board = 125 AND lmr.id_member = 7748)   WHERE t.id_topic = 31350   LIMIT 1 ]
[ 1328526182 ] [ ** ] [ 3846669 ] [ 155 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,    t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts,    t.id_last_msg + 1 AS new_from       FROM smf_topics AS t    INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg)   WHERE t.id_topic = 72996   LIMIT 1 ]
[ 1328526182 ] [ ** ] [ 3846667 ] [ 156 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,    t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts,    IFNULL(lt.id_msg, IFNULL(lmr.id_msg, -1)) + 1 AS new_from       FROM smf_topics AS t    INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg)    LEFT JOIN smf_log_topics AS lt ON (lt.id_topic = 23043 AND lt.id_member = 510389)    LEFT JOIN smf_log_mark_read AS lmr ON (lmr.id_board = 125 AND lmr.id_member = 510389)   WHERE t.id_topic = 23043   LIMIT 1 ]
[ 1328526182 ] [ ** ] [ 3846666 ] [ 156 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    c.id_cat, c.name AS cat_name,    b.id_board, b.name AS board_name, b.description,    CASE WHEN b.redirect != '' THEN 1 ELSE 0 END AS is_redirect,    b.num_posts, b.num_topics, b.unapproved_posts, b.unapproved_topics, b.id_parent,    IFNULL(m.poster_time, 0) AS poster_time, IFNULL(mem.member_name, m.poster_name) AS poster_name,    m.subject, m.id_topic, IFNULL(mem.real_name, m.poster_name) AS real_name,        (IFNULL(lb.id_msg, 0) >= b.id_msg_updated) AS is_read, IFNULL(lb.id_msg, -1) + 1 AS new_from,    c.can_collapse, IFNULL(cc.id_member, 0) AS is_collapsed,    IFNULL(mem.id_member, 0) AS id_member, m.id_msg,    IFNULL(mods_mem.id_member, 0) AS id_moderator, mods_mem.real_name AS mod_real_name   FROM smf_boards AS b    LEFT JOIN smf_categories AS c ON (c.id_cat = b.id_cat)    LEFT JOIN smf_messages AS m ON (m.id_msg = b.id_last_msg)    LEFT JOIN smf_members AS mem ON (mem.id_member = m.id_member)    LEFT JOIN smf_log_boards AS lb ON (lb.id_board = b.id_board AND lb.id_member = 589670)    LEFT JOIN smf_collapsed_categories AS cc ON (cc.id_cat = c.id_cat AND cc.id_member = 589670)    LEFT JOIN smf_moderators AS mods ON (mods.id_board = b.id_board)    LEFT JOIN smf_members AS mods_mem ON (mods_mem.id_member = mods.id_member)   WHERE (FIND_IN_SET(0, b.member_groups) != 0 OR FIND_IN_SET(4, b.member_groups) != 0)    AND b.child_level BETWEEN 0 AND 1 ]
[ 1328526182 ] [ ** ] [ 3846664 ] [ 156 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll,    t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts,    t.id_last_msg + 1 AS new_from       FROM smf_topics AS t    INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg)   WHERE t.id_topic = 46544   LIMIT 1 ]
[ 1328526182 ] [ ** ] [ 3846661 ] [ 156 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    c.id_cat, c.name AS cat_name,    b.id_board, b.name AS board_name, b.description,    CASE WHEN b.redirect != '' THEN 1 ELSE 0 END AS is_redirect,    b.num_posts, b.num_topics, b.unapproved_posts, b.unapproved_topics, b.id_parent,    IFNULL(m.poster_time, 0) AS poster_time, IFNULL(mem.member_name, m.poster_name) AS poster_name,    m.subject, m.id_topic, IFNULL(mem.real_name, m.poster_name) AS real_name,     1 AS is_read, 0 AS new_from,    IFNULL(mem.id_member, 0) AS id_member, m.id_msg,    IFNULL(mods_mem.id_member, 0) AS id_moderator, mods_mem.real_name AS mod_real_name   FROM smf_boards AS b    LEFT JOIN smf_categories AS c ON (c.id_cat = b.id_cat)    LEFT JOIN smf_messages AS m ON (m.id_msg = b.id_last_msg)    LEFT JOIN smf_members AS mem ON (mem.id_member = m.id_member)    LEFT JOIN smf_moderators AS mods ON (mods.id_board = b.id_board)    LEFT JOIN smf_members AS mods_mem ON (mods_mem.id_member = mods.id_member)   WHERE (FIND_IN_SET(-1, b.member_groups) != 0)    AND b.child_level BETWEEN 0 AND 1 ]
[ 1328526182 ] [ ** ] [ 3846637 ] [ 156 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT     t.id_topic, t.num_replies, t.locked, t.num_views, t.is_sticky, t.id_poll, t.id_previous_board,     IFNULL(lt.id_msg, IFNULL(lmr.id_msg, -1)) + 1 AS new_from,     t.id_last_msg, t.approved, t.unapproved_posts, ml.poster_time AS last_poster_time,     ml.id_msg_modified, ml.subject AS last_subject, ml.icon AS last_icon,     ml.poster_name AS last_member_name, ml.id_member AS last_id_member,     IFNULL(meml.real_name, ml.poster_name) AS last_display_name, t.id_first_msg,     mf.poster_time AS first_poster_time, mf.subject AS first_subject, mf.icon AS first_icon,     mf.poster_name AS first_member_name, mf.id_member AS first_id_member,     IFNULL(memf.real_name, mf.poster_name) AS first_display_name, SUBSTRING(ml.body, 1, 385) AS last_body,     SUBSTRING(mf.body, 1, 385) AS first_body, ml.smileys_enabled AS last_smileys, mf.smileys_enabled AS first_smileys    FROM smf_topics AS t     INNER JOIN smf_messages AS ml ON (ml.id_msg = t.id_last_msg)     INNER JOIN smf_messages AS mf ON (mf.id_msg = t.id_first_msg)     LEFT JOIN smf_members AS meml ON (meml.id_member = ml.id_member)     LEFT JOIN smf_members AS memf ON (memf.id_member = mf.id_member)     LEFT JOIN smf_log_topics AS lt ON (lt.id_topic = t.id_topic AND lt.id_member = 20918)     LEFT JOIN smf_log_mark_read AS lmr ON (lmr.id_board = 25 AND lmr.id_member = 20918)    WHERE t.id_board = 25    ORDER BY is_sticky DESC, id_last_msg DESC    LIMIT 0, 30 ]
[ 1328526182 ] [ ** ] [ 3846515 ] [ 156 ] [ *** ] [ Query ] [ KILLED ] [ 'hosting'] [ SELECT    b.id_board, b.name AS board_name, b.description,    CASE WHEN b.redirect != '' THEN 1 ELSE 0 END AS is_redirect,    b.num_posts, b.num_topics, b.unapproved_posts, b.unapproved_topics, b.id_parent,    IFNULL(m.poster_time, 0) AS poster_time, IFNULL(mem.member_name, m.poster_name) AS poster_name,    m.subject, m.id_topic, IFNULL(mem.real_name, m.poster_name) AS real_name,        (IFNULL(lb.id_msg, 0) >= b.id_msg_updated) AS is_read, IFNULL(lb.id_msg, -1) + 1 AS new_from,    IFNULL(mem.id_member, 0) AS id_member, m.id_msg,    IFNULL(mods_mem.id_member, 0) AS id_moderator, mods_mem.real_name AS mod_real_name   FROM smf_boards AS b    LEFT JOIN smf_messages AS m ON (m.id_msg = b.id_last_msg)    LEFT JOIN smf_members AS mem ON (mem.id_member = m.id_member)    LEFT JOIN smf_log_boards AS lb ON (lb.id_board = b.id_board AND lb.id_member = 20918)    LEFT JOIN smf_moderators AS mods ON (mods.id_board = b.id_board)    LEFT JOIN smf_members AS mods_mem ON (mods_mem.id_member = mods.id_member)   WHERE (FIND_IN_SET(0, b.member_groups) != 0 OR FIND_IN_SET(6, b.member_groups) != 0)    AND b.child_level BETWEEN 1 AND 2 ]

[dursunali]

Loglari mail at

[16melih]

Loglari mail at

Loglar bunlar, yardımcı olacaksanız buyrun