#30 sql on db_clean

Unstable (example)
closed-fixed
nobody
5
2015-04-30
2012-11-19
No

in db_clean.php the query

dbquery("delete * from mtalog where timestamp < (now() - INTERVAL ".RECORD_DAYS_TO_KEEP." DAY)");

is wrong and will always return an error because of the * after delete. This is the right sql syntax

dbquery("delete from mtalog where timestamp < (now() - INTERVAL ".RECORD_DAYS_TO_KEEP." DAY)");

Regards

Discussion

  • EndelWar

    EndelWar - 2015-04-30
    • status: open --> closed-fixed
    • Group: --> Unstable (example)
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks