• 27-05-2010, 18:28:49
    #1
    Arkadaşlar sürekli bu hatayı alıyorum . Nasıl düzeltebilirim yardımcı olurmusunuz...


    Invalid SQL:

    SELECT
    userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
    language.phrasegroup_global AS phrasegroup_global,
    language.phrasegroup_holiday AS phrasegroup_holiday,
    language.options AS lang_options,
    language.languagecode AS lang_code,
    language.charset AS lang_charset,
    language.locale AS lang_locale,
    language.imagesoverride AS lang_imagesoverride,
    language.dateoverride AS lang_dateoverride,
    language.timeoverride AS lang_timeoverride,
    language.registereddateoverride AS lang_registereddateoverride,
    language.calformat1override AS lang_calformat1override,
    language.calformat2override AS lang_calformat2override,
    language.logdateoverride AS lang_logdateoverride,
    language.decimalsep AS lang_decimalsep,
    language.thousandsep AS lang_thousandsep

    FROM user AS user
    LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
    LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 4, user.languageid))

    WHERE user.userid = 232667;

    MySQL Error : Lost connection to MySQL server during query
    Error Number : 2013
    Request Date : Thursday, May 27th 2010 @ 04:23:12 PM
    Error Date : Thursday, May 27th 2010 @ 04:23:38 PM
    Username :
    Classname : vB_Database
    MySQL Version :
  • 27-05-2010, 18:39:20
    #3
    Birde bunu verdi şimdi...


    Invalid SQL:

    SELECT
    post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
    user.*, userfield.*, usertextfield.*,
    icon.title as icontitle, icon.iconpath,
    avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,


    editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
    editlog.reason AS edit_reason, editlog.hashistory,
    postparsed.pagetext_html, postparsed.hasimages,
    sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
    sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid


    FROM post AS post
    LEFT JOIN user AS user ON(user.userid = post.userid)
    LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
    LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
    LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
    LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)


    LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
    LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 5 AND postparsed.languageid = 4)
    LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 5 AND sigparsed.languageid = 4)
    LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)

    WHERE post.postid IN (0,390547,390706,672603,697634,708342)
    ORDER BY post.dateline;




    Ayrıca birde bu :

    Invalid SQL:

    SELECT albumpicture.*, album.*, user.username, user.usergroupid,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
    FROM albumpicture AS albumpicture
    LEFT JOIN album AS album ON(album.albumid = albumpicture.albumid)
    LEFT JOIN user AS user ON(user.userid = album.userid)
    WHERE album.state = 'public' AND album.userid = '200106'
    ORDER BY dateline DESC
    LIMIT 0, 8;
  • 28-05-2010, 10:27:44
    #4
    hengame adlı üyeden alıntı: mesajı görüntüle
    Birde bunu verdi şimdi...


    Invalid SQL:

    SELECT
    post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
    user.*, userfield.*, usertextfield.*,
    icon.title as icontitle, icon.iconpath,
    avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,


    editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
    editlog.reason AS edit_reason, editlog.hashistory,
    postparsed.pagetext_html, postparsed.hasimages,
    sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
    sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid


    FROM post AS post
    LEFT JOIN user AS user ON(user.userid = post.userid)
    LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
    LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
    LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
    LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)


    LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
    LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 5 AND postparsed.languageid = 4)
    LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 5 AND sigparsed.languageid = 4)
    LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)

    WHERE post.postid IN (0,390547,390706,672603,697634,708342)
    ORDER BY post.dateline;




    Ayrıca birde bu :

    Invalid SQL:

    SELECT albumpicture.*, album.*, user.username, user.usergroupid,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
    FROM albumpicture AS albumpicture
    LEFT JOIN album AS album ON(album.albumid = albumpicture.albumid)
    LEFT JOIN user AS user ON(user.userid = album.userid)
    WHERE album.state = 'public' AND album.userid = '200106'
    ORDER BY dateline DESC
    LIMIT 0, 8;
    Size güncelleme öneriyorum.
  • 28-05-2010, 23:09:21
    #5
    Malasef hala devam ediyor...

    Bu sefer sıklıkla aldığım hata.

    Lost connection to MySQL server during query Error Number : 2013

    my.cnf nın içinde bunlar bu şekilde...

    [mysqld]
    tmpdir=/temp
    basedir =/usr/
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    safe-show-database
    old_passwords
    back_log = 50
    skip-innodb
    max_connections = 1000
    key_buffer_size = 256M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 3M
    table_cache = 5000
    thread_cache_size = 256
    wait_timeout = 300
    connect_timeout = 10
    tmp_table_size = 64M
    max_heap_table_size = 64M
    max_allowed_packet = 64M
    net_buffer_length = 16384
    max_connect_errors = 100000
    thread_concurrency = 8
    concurrent_insert = 2
    table_lock_wait_timeout = 30
    read_rnd_buffer_size = 786432
    bulk_insert_buffer_size = 8M
    query_cache_limit = 4M
    query_cache_size = 96M
    query_cache_type = 1
    query_prealloc_size = 262144
    query_alloc_block_size = 65536
    transaction_alloc_block_size = 8192
    transaction_prealloc_size = 4096
    default-storage-engine = MyISAM
    max_write_lock_count = 4
  • 29-05-2010, 10:13:03
    #6
    Problem devam ediyor bu konu hakkında bilgisi olan yokmu arkadaşlar ?
  • 30-05-2010, 04:20:29
    #7
    Kimlik doğrulama veya yönetimden onay bekliyor.
    tabloları tamir et optimize et sürekli yapıyorsa sql hatasıdır hostcunla görüş...
  • 31-05-2010, 10:25:12
    #8
    Tabloları belki 100 defa tamir ettirdim




    MySQL Error : Lost connection to MySQL server during query
    Error Number : 2013

    Hatası alıyorum sadece şu anda ...
  • 01-06-2010, 19:37:26
    #9
    Sorun hala devam ediyor arkadaşlar. Bu konuda bir bilgisi olan yokmu ???