This topic was marked solved by Nao, on November 7th, 2012, 11:45 PM
« Warn on new replies made while posting not working
Problem with pruning logs
Thoughts and Viewing All »

Alanthar

  • Congratulations. :)
  • Posts: 22
Problem with pruning logs
« on November 7th, 2012, 09:03 AM »
Running the task "Empty out unimportant logs" will throw me reproduceably the following error:
Quote
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' wedge_log_floodcontrol' at line 1
File: [~]/Sources/ManageMaintenance.php
Line: 329

Anthony`

  • Posts: 53
Re: Problem with pruning logs
« Reply #1, on November 7th, 2012, 10:01 PM »
I can confirm this. The issue,
Code: [Select]
wesql::query('
TRUNCATE {db_prefix}log_online, {db_prefix}log_floodcontrol');
Should be seperated for the two tables like so,
Code: [Select]
wesql::query('
TRUNCATE {db_prefix}log_online');

wesql::query('
TRUNCATE {db_prefix}log_floodcontrol');

Arantor

  • As powerful as possible, as complex as necessary.
  • Posts: 14,278
When we unite against a common enemy that attacks our ethos, it nurtures group solidarity. Trolls are sensational, yes, but we keep everyone honest. | Game Memorial

Nao

  • Dadman with a boy
  • Posts: 16,082
Re: Problem with pruning logs
« Reply #3, on November 7th, 2012, 11:45 PM »
Fixed locally, thanks.
Couldn't find any other TRUNCATE calls with multiple tables, so it should be fine from now on.
« Warn on new replies made while posting not working
Thoughts and Viewing All »