I get this error on the following page.

http://sandbox.ktit.dk/rikkedarlingdk/?q=node/2

user warning: Table 'rikkedarlingdk.brilliant_gallery_checklist' doesn't exist query: select qid from brilliant_gallery_checklist where qid like 'user-%' and state='1' in /home/e-smith/files/ibays/sbktitdk/html/rikkedarlingdk/modules/brilliant_gallery/brilliant_gallery.module on line 648.

Can anyone tell me what I need to do to fix it ? everything seems to work just fine, except that error is kind of ugly :)

Comments

zappi’s picture

zappi commented

Here is the line from the brilliant_gallery.module file

LINE 648  $dbresult = db_query("select qid from brilliant_gallery_checklist where qid like 'user-%' and state='1' ");
LINE 649  while ($data = db_fetch_object($dbresult)) {
LINE 650    $excludedimgs[] = $data->qid;
zappi’s picture

zappi commented

OK I fixed it by removing the

$dbresult = db_query("select qid from brilliant_gallery_checklist where qid like 'user-%' and state='1' ");

line from the brilliant_gallery.module file

It looks and works great now.. Is this an ok way to solve this problem ?

vacilando’s picture

vacilando commented
Status: Active » Postponed (maintainer needs more info)

Did you run /update.php after installing the module? If not, do that - it will create the table 'brilliant_gallery_checklist' and you can re-enable that line (it is responsible for hiding the images you hide in /admin/settings/brilliant_gallery/manage).

dan.crouthamel’s picture

dan.crouthamel commented

This is probably because the table names aren't enclosed with {} in the .module file - you'll run into a problem if you have drupal prefix your table names.

From the SQL coding conventions page :)

Enclose each table name with {} (this allows Drupal to prefix table names).

foxmarks’s picture

foxmarks commented

I’ve run the update, and added the {} to line 648 in my .module file. The 648 error seems corrected, but I still get this one:

user warning: Table 'audubonpark.brilliant_gallery_checklist' doesn't exist query: select qid,state from brilliant_gallery_checklist where nid=9999999 and qid not like 'user-%' and user=0 union select qid,state from brilliant_gallery_checklist where nid=9999999 and qid like 'user-%' and user=1 in /sites/all/modules/brilliant_gallery/brilliant_gallery.module on line 108.

dan.crouthamel’s picture

dan.crouthamel commented

There will be multiple places in the file that will have to be updated.

foxmarks’s picture

foxmarks commented

Thank you. I’ve added {} to several other instances of brilliant_gallery_checklist in .module and the table error warning no longer appears.

But now I can see that there’s an additional problem: no image appears, just a black box. :-(

Time to check the other tickets for my new issue…

dan.crouthamel’s picture

dan.crouthamel commented

Take a look at this issue #356459: Brillant gallery doesn't show the thumbs ! - that should solve the problem :)

vacilando’s picture

vacilando commented
Status: Postponed (maintainer needs more info) » Fixed

Added {} around table names and committed to dev earlier today.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.