Problems with Logging MySQL

English General
21

Thanks Torben,

I’ve changed the insert statements to only handle one variable, and it’s working perfectly now!

Thanks again!

Earl T

22

Great, thanks Torben.

I’ve tried the new snapshot and unfortunately it’s not logging at the moment to my MySQL database. I’ve just done a clean install with the latest snapshot, and used the above schema and statements, but it still doesn’t seem to log in the database, nor display any errors.

I assume a connection is being made, as by supplying an incorrect password the following appears;

Logging error (SQL Database): Cannot connect to SQL server

Is there anything else I can try?

Cheers,

James

Edit: Got it now. :slight_smile: Changed the command from

INSERT INTO 'mairlist' VALUES (NULL, NOW(), 'Started', %3)

to

INSERT INTO mairlist (id, date, action, filename) VALUES (NULL, NOW(), 'Started', %3)