Quote:
Originally Posted by Dave
Does your MySQL user have access to the TRUNCATE function?
The query itself is correct to truncate the table.
I will fix the other error if you search for nothing, although it doesn't have any priority.
|
hmm ... not sure exactly how to check access to the truncate function
but running 'show grants' from the mysql command line for the user says:
GRANT ALL PRIVILEGES ON ...WITH GRANT OPTION
===============================
EDIT
running this manually from command line worked :
TRUNCATE vb_loginlog;
but using the loginlog control panel purge function just gives the first error above - like it's not getting any input