I am getting this error i ran in update.php script and followed all the instruction i could find on the BG page

user warning: Table 'avisriva_com.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 /var/www/drupal6/sites/all/modules/brilliant_gallery/brilliant_gallery.module on line 109.

Comments

zoia’s picture

zoia CreditAttribution: zoia commented

For me could be my last attempt to use brilliand gallery although i loved this module to see it working. My log file that i get is :
The selected file /users/pel/1dim-giann/1dimgian/public_html/files/tmp/filevHaayp could not be copied.
The selected file /users/pel/1dim-giann/1dimgian/public_html/files/tmp/filewHaayp could not be copied

After a new installation and cleaning cache seems to try to put files in tmp. During previous attempts i tested the bg tag with picasa . Does this apply in some way to this fault?

In the log details
i find this An error occurred during creation of the JavaScript translation file for the language Greek.
Severity error

Do i need JavaScript translation?

ctrnz’s picture

ctrnz CreditAttribution: ctrnz commented

Got same error with fresh install.
user warning: Table 'database.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 /home/-httpd/site.lv/logi/sites/all/modules/brilliant_gallery/brilliant_gallery.module on line 109.

j. ayen green’s picture

j. ayen green CreditAttribution: j. ayen green commented

Yes, I received the above error regarding the missing table. So I deactivated, uninstalled, updated, rectivated, updated. Same error.

nedelman’s picture

nedelman CreditAttribution: nedelman commented

I had a problem with the table not being queryable. After some inspection I found that the queries in brilliant_gallery.module should have the table names wrapped in {}

So, I replaced all instances of from brilliant_gallery_checklist with from {brilliant_gallery_checklist}

j. ayen green’s picture

j. ayen green CreditAttribution: j. ayen green commented

I've made those changes, and now the error is gone. But now I just have empty content showing for the node. I have the correct directory configured in admin (I know because it brings up the photos to enable-how annoying is it doing that?!) and I have the body of the node set to Full HTML and Brilliant Gallery Tag filter selected for Full HTML. My gallery is in sites/default/files/photos and my tag reads [bg|photos|10|45|random|10|#000000] So...what have I missed?