Database tables getting very big..

Hi, on my testsite i've seen that the tables eventlog (10.8MB) and adodb_logsql (3.2MB) are becoming very large, this is a testsite so there's not much traffic. There are very much forum messages in the eventlog and table exists messages, is this a bug or not?

(Function 'getfileextension' used from jojo_forum.p...)

Hi, on my testsite i've seen that the tables eventlog (10.8MB) and adodb_logsql (3.2MB) are becoming very large, this is a testsite so there's not much traffic. There are very much forum messages in the eventlog and table exists messages, is this a bug or not? (Function 'getfileextension' used from jojo_forum.p...)

Hi Alex,

The adodbn_logsql table is only used while the site is in debug mode. Once you turn debug mode off, this will not conntinnue to grow and can be emptied.

The eventlog table logs errors including the use of some legacy functions which is what you are seeing with the forum plugin. These will reduce as we have time to locate and replace them all.

We welcome patches to the function name transitions. Most are just changing from the global name space to the Jojo namespace. eg tableexists() becomes Jojo::tablexists()

- Mike

Hi Alex, The adodbn_logsql table is only used while the site is in debug mode. Once you turn debug mode off, this will not conntinnue to grow and can be emptied. The eventlog table logs errors including the use of some legacy functions which is what you are seeing with the forum plugin. These will reduce as we have time to locate and replace them all. We welcome patches to the function name transitions. Most are just changing from the global name space to the Jojo namespace. eg tableexists() becomes Jojo::tablexists() - Mike

Hi Alex,

One of the items on my list is to automatically delete all non-critical log entries over a month old. I found a 1Gb event log on one of my sites, which is clearly a bit silly (A busy site packed with legacy code that needed to be updated).

As Mike says, we have been using these log messages to clean up old code from within Jojo, which has now largely been done for all our plugins.

Harvey.

Hi Alex, One of the items on my list is to automatically delete all non-critical log entries over a month old. I found a 1Gb event log on one of my sites, which is clearly a bit silly (A busy site packed with legacy code that needed to be updated). As Mike says, we have been using these log messages to clean up old code from within Jojo, which has now largely been done for all our plugins. Harvey.