1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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