Hello and Happy New Year to all,
I get the following error on Logging in to dokuwiki on my site
MySQL err: Table 'xx' was not locked with LOCK TABLES [mysql.class.php:793]
I have followed the directions for MySQL Authentification Backend. I have created the three required SQL User Authentication statements. With debug turned on for '2' it looks like the first SQL statement of Check Pass works. The second SQL statement gives me the error. That is the Get User Information SQL query. This one is different from the first as this uses multiple tables. I entered the tables and alias in the TableLocks array. When I run the whole set of queries from phpmyadmin as individual SQL statements they all work. Even the LOCK TABLES.
Best Regards
Tom
Update: I found an example that declared the TablesToLock array as a string as shown here
$conf['auth']['mysql']['TablesToLock']= 'array(.., .. )';
By enclosing the declaration of TablesToLock in single quotes the commands all execute with no errors. The directions at
http://www.dokuwiki.org/auth:mysql under
Option 'TablesToLock' does not have the quotes. Being a wiki I guess I could make that change there. However being a newbie I am reluctant to change the documentation unless someone verifies I am correct.
Best Regards
Tom