user warning : line 659 [#367310]

I am a real newb: I wanted to try this module so that I could use it with picasa. This is the error I keep seeing : Does anyone know how I might address solving this?

user warning: Table 'justinfrye0.brilliant_gallery_checklist' doesn't exist query: select qid from brilliant_gallery_checklist where qid like 'user-%' and state='1' in /export/home/ju/justinfrye/public_html/drupal/modules/brilliant_gallery/brilliant_gallery.module on line 659.

Thanks in advance!

Comment	File	Size	Author
#2	brilliant_gallery.module.txt	36.12 KB	smartmark

Comments

Comment #1

justinfrye commented 14 February 2009 at 16:45

Status:

Active

» Closed (fixed)

Comment #2

smartmark commented 9 April 2009 at 18:42

Status:

Closed (fixed)

» Reviewed & tested by the community

Status	File	Size
new	brilliant_gallery.module.txt	36.12 KB

I got the same error message. Since on line 659 is
$dbresult = db_query("select qid from <b>brilliant_gallery_checklist</b> where qid like 'user-%' and state='1' ");
I suppose it's the same problem as mentioned here - everytime "brilliant_gallery_checklist" appear in SQL query, it should be replaced by "{brilliant_gallery_checklist}". I found several other apperances, which haven't been pointed out in #356346: brilliant_gallery_checklist table doesn't exist (using table prefix) :

130
$existing = db_result(db_query("select count(state) from brilliant_gallery_checklist ".
->
$existing = db_result(db_query("select count(state) from {brilliant_gallery_checklist} ".

134
db_query("insert into brilliant_gallery_checklist (nid,user,qid,state) " . "values (%d,%d,'%s',%d)", $nid, $uid, $qid, $state);
->
db_query("insert into {brilliant_gallery_checklist} (nid,user,qid,state) " . "values (%d,%d,'%s',%d)", $nid, $uid, $qid, $state);

137
$current = db_result(db_query("select state from brilliant_gallery_checklist " . " where nid=%d and user=%d and qid='%s'", $nid, $uid, $qid));
->
$current = db_result(db_query("select state from {brilliant_gallery_checklist} " . " where nid=%d and user=%d and qid='%s'", $nid, $uid, $qid));

140
db_query("update brilliant_gallery_checklist " . "set state=%d where nid=%d and user=%d and qid='%s'", $state, $nid, $uid, $qid);
->
db_query("update {brilliant_gallery_checklist} " . "set state=%d where nid=%d and user=%d and qid='%s'", $state, $nid, $uid, $qid);

652
$result=db_query("select qid,state from brilliant_gallery_checklist ".
->
$result=db_query("select qid,state from {brilliant_gallery_checklist} ".

655
"select qid,state from brilliant_gallery_checklist ".
->
"select qid,state from {brilliant_gallery_checklist} ".

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

I attach a file including all these modifications, plus that mentioned at #356346: brilliant_gallery_checklist table doesn't exist (using table prefix) and #370747: Permissions not set correctly.