SQL Error: Query: DELETE FROM sessions WHERE ip='62.253.128.15' OR time<1168706124

Discussion in 'Databases' started by mightyb, Jan 14, 2007.

  1. #1
    Im having the following sql error:

    Query: DELETE FROM sessions WHERE ip='62.253.128.15' OR time<1168706124

    Any ideas what that could be? Thanks!
     
    mightyb, Jan 14, 2007 IP
  2. maiahost

    maiahost Guest

    Messages:
    664
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    0
    #2
    OR time < '1168706124' ?
     
    maiahost, Jan 14, 2007 IP
  3. mightyb

    mightyb Banned

    Messages:
    6,566
    Likes Received:
    405
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Yep, thats what it says :confused:
     
    mightyb, Jan 14, 2007 IP
  4. maiahost

    maiahost Guest

    Messages:
    664
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    0
    #4
    no I mean put ' around the time value
     
    maiahost, Jan 14, 2007 IP
  5. phantomddl

    phantomddl Well-Known Member

    Messages:
    2,856
    Likes Received:
    30
    Best Answers:
    0
    Trophy Points:
    160
    Articles:
    15
    #5
    DELETE FROM sessions WHERE ip='62.253.128.15' OR time<'1168706124'
    if it still gives error, u can try DELETE FROM sessions WHERE ip='62.253.128.15'
     
    phantomddl, Jan 14, 2007 IP
  6. T0PS3O

    T0PS3O Feel Good PLC

    Messages:
    13,219
    Likes Received:
    777
    Best Answers:
    0
    Trophy Points:
    0
    #6
    1. Give us the error.
    2. Use IP Numbers instead - a lot faster/more efficient
     
    T0PS3O, Jan 14, 2007 IP
  7. mightyb

    mightyb Banned

    Messages:
    6,566
    Likes Received:
    405
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Iv managed to figure it out. Just had a corrupt table. Just used: repair table sessions

    Thanks!
     
    mightyb, Jan 14, 2007 IP