[Tikiwiki-devel] SQL plugin causes SQL error on tiki_hotwords

[Diego Z. <d_z...@ya...>]

Hi,

I'm trying to use the SQL plugin to access our local hosts database,
stored in the "machines" table of the "machines" database. I have
defined the following DSN called "machines":

mysql://tiki:xyzwabc@localhost/machines

And then in a wiki page I have:

{SQL(db=>machines)}
select * from machines where Machine_Name='myhost'
{SQL}

When I save the page, I get the following error:

Warning: MYSQL error: DB Error: unknown error in query:
select * from tiki_hotwords
in /home/tiki16cvs-b/lib/tikilib.php on line 71

What am I doing wrong? The tiki user has select permission on the
machines database, plus the error seems to be when accessing
tiki_hotwords, not machines.

Thanks,
--Diego