Try making it an admin option as to how long until ip data is deleted. (1 hour? 1 day? 1 week? 1 month? 3 months? 6 months? 1 year?) If it's too soon, it deems the ip logging feature useless (it might as well be disabled), if it's too long, the gained performance is useless. This happy medium will be at a different place for each forum depending on traffic, and admin capabilities.
undefined.undefined();
The error occurred on or near: 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 'WHERE `Name` LIKE 'LUM_%' AND `Data_free` > 0' at line 1
The IP history will be deleted when you either press the Button "Optimize tables now" or (if there is no overhead) the Button "Cleanup ip history now". For your setting it will then remove all entries from the IP history that are older than one month.
An automated feature would mean to either use a cron-job, or to check on every page request if its already the time and need to perfom the cleanup again. Most of the standard web-hosters do not offer cron-usage and in my opinion an extension like this should not affect the speed of the forum. But if there is need for an automatic cleanup feature, I can implement an admin option in the next release to activate something like this.
Actually mate, I prefer it as it is, we tend to forget about automatic jobs then when something goes wrong we don't know where to look.
You've done a massive job on this extension, I was satisfied to do the optimizing in the control panel provided by my host but it's much more convenient using your interface within Vanilla itself.
Could I suggest you include a little more information in the read-me? This would stop people like me bugging you with questions.
i tried this extension i hit optimize tables after setting it to '1 week' above & got the following errors :
Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47
Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47
Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47
Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47
Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47
Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47
Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47
fortunately the forum still works, but i was wondering if this was normal to get these errors?
Comments
cool stuff
undefined.undefined(); The error occurred on or near: 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 'WHERE `Name` LIKE 'LUM_%' AND `Data_free` > 0' at line 1So how often does it check to optimize?
Is it configurable?
Posted: Sunday, 13 April 2008 at 12:05PM
How come I can still see each user's "Last Known Ip"?
So how often does it check to optimize? Is it configurable?The optimization can only be started manually.
Is the IP history deleted automatically? I have it set to one month.
You should have the cron-job options separate in case someone wants only one option automated.
You've done a massive job on this extension, I was satisfied to do the optimizing in the control panel provided by my host but it's much more convenient using your interface within Vanilla itself.
Could I suggest you include a little more information in the read-me? This would stop people like me bugging you with questions.
Otherwise, a top job, thank you sincerely.
i hit optimize tables after setting it to '1 week' above
& got the following errors :
Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47
Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47
Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47
Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47
Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47
Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47
Notice: Undefined index: Engine in /home/content/D/e/a/Deadsy/html/forum/extensions/OptimizeTables/library/PostBackControl.OptimizeTablesForm.php on line 47
fortunately the forum still works, but i was wondering if this was normal to get these errors?