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
Comment #1
anonIt 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.
Comment #2
joevansteen commentedThat 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.
Comment #3
anonYes, the links you have created should still be okey.