When I post a new links during editing documents (in this case a book page) I get a series of warning messages on the screen. Shown below are an extract from a series after placing 2 links:

•user warning: Access denied for user 'drupaladmin'@'localhost' to database 'afdrupalv00' query: CREATE TEMPORARY TABLE linkit_tmp_view_table (title VARCHAR(128) NOT NULL, path VARCHAR(128) NOT NULL) in R:\www\afV200\sites\all\modules\linkit\plugins\linkit_views\linkit_views.module on line 18.
•user warning: Table 'afdrupalv00.linkit_tmp_view_table' doesn't exist query: INSERT INTO linkit_tmp_view_table (title, path) VALUES ('applications', 'applications') in R:\www\afV200\sites\all\modules\linkit\plugins\linkit_views\linkit_views.module on line 24.
•user warning: Table 'afdrupalv00.linkit_tmp_view_table' doesn't exist query: SELECT * FROM linkit_tmp_view_table WHERE LOWER(path) LIKE LOWER('%content%') LIMIT 0, 10 in R:\www\afV200\sites\all\modules\linkit\plugins\linkit_views\linkit_views.module on line 27.

All messages seem to be from the same module. Referenced lines include the three shown: 18, 24 and 27. I assume these are harmless, but should have been supressed.

Comments

anon’s picture

It seems like your database user doent have permissions to create temporary tables.
Linkit most create this temoprary table when you link to a view page.

See if your DB user have permissions to create temporary tables.

joevansteen’s picture

Status: Active » Closed (fixed)

That was it. I added the create_tmp_table permission and the problem went away. Thanks! The links seemed to work even though I got the diagnostics, so I wasn't sure it was my problem. Are the links I created when I had the diagnostics okay, or do I have to 're-create' them? I'm not sure what I may have messed up in the processing by creating a problem around the use of a 'temporary' table.

anon’s picture

Yes, the links you have created should still be okey.