URGENT Error Message on Forum

Discussion in 'PHP' started by MakeThatDollar, Mar 8, 2007.

0
  1. #1
    Database Error: Can't execute the query because you have a conflicting read lock
    File: /home/content/m/o/n/moneytalkpro/html/Sources/Subs.php
    Line: 2798

    What's this mean, and how can I fix it?

    Forum link: www.moneytalkpro.com
     
    MakeThatDollar, Mar 8, 2007 IP
  2. Richie_Ni

    Richie_Ni Illustrious Member

    Messages:
    10,721
    Likes Received:
    1,175
    Best Answers:
    0
    Trophy Points:
    410
    #2
    What software you use on the forum?
     
    Richie_Ni, Mar 8, 2007 IP
  3. MakeThatDollar

    MakeThatDollar Notable Member

    Messages:
    4,451
    Likes Received:
    158
    Best Answers:
    0
    Trophy Points:
    225
    #3
    I've been using SMF version 1.1 rc2 for several months now.

    The forum was working perfectly fine an hour ago, and just now noticed this error message.
     
    MakeThatDollar, Mar 8, 2007 IP
  4. MakeThatDollar

    MakeThatDollar Notable Member

    Messages:
    4,451
    Likes Received:
    158
    Best Answers:
    0
    Trophy Points:
    225
    #4
    // Otherwise, we have to delete and insert.
    if (empty($_SESSION['log_time']))
    {
    if ($do_delete || !empty($ID_MEMBER))
    db_query("
    DELETE FROM {$db_prefix}log_online
    WHERE " . ($do_delete ? "logTime < NOW() - INTERVAL " . ($modSettings['lastActive'] * 60) . ' SECOND' : '') . ($do_delete && !empty($ID_MEMBER) ? ' OR ' : '') . (empty($ID_MEMBER) ? '' : "ID_MEMBER = $ID_MEMBER"), __FILE__, __LINE__);

    db_query("
    " . ($do_delete ? 'INSERT IGNORE' : 'REPLACE') . " INTO {$db_prefix}log_online
    (session, ID_MEMBER, logTime, ip, url)
    VALUES ('$session_id', $ID_MEMBER, NOW(), IFNULL(INET_ATON('$user_info[ip]'), 0), '$serialized')", __FILE__, __LINE__);
    }

    Line 2798 is

    WHERE " . ($do_delete ? "logTime < NOW() - INTERVAL " . ($modSettings['lastActive'] * 60) . ' SECOND' : '') . ($do_delete && !empty($ID_MEMBER) ? ' OR ' : '') . (empty($ID_MEMBER) ? '' : "ID_MEMBER = $ID_MEMBER"), __FILE__, __LINE__);



    Errror message can be found at http://www.moneytalkpro.com/index1.php now
     
    MakeThatDollar, Mar 8, 2007 IP