review.module,v 1.9 2005/12/18 12:57:55

my error message:

* user warning: Table 'quiptime_de.review' doesn't exist query: SELECT COUNT(*) FROM review rv INNER JOIN node n ON rv.nid = n.nid WHERE n.status = 1 in /is/htdocs/17593/www.quiptime.de/drupal/includes/database.mysql.inc on line 108.
* user warning: Table 'quiptime_de.review' doesn't exist query: SELECT n.nid FROM review rv INNER JOIN node n ON rv.nid = n.nid WHERE n.status = 1 ORDER BY n.changed DESC LIMIT 0, 10 in /is/htdocs/17593/www.quiptime.de/drupal/includes/database.mysql.inc on line 108.

Eliminate please this error. Post a patch.

Thanks, quiptime

In addition:
The same with the cvs version.

Comments

drewish’s picture

Did you remember to create the table from the review.mysql file?

drewish’s picture

Status: Active » Fixed

Just re-read the title of the issue and the error messages made sense. Thanks for the bug report. This has been fixed in CVS.

quiptime’s picture

Title: error with database table with prefix » error with database table with prefix - my source fix

my table has the name drupal_review

I regarded the module code and found the following error:

module version 4.7, in function review_block

line 235
wrong code:

$result = db_query('SELECT n.nid FROM review rv INNER JOIN node n ON rv.nid = n.nid WHERE n.status = 1 ORDER BY n.changed DESC LIMIT %d', variable_get('review_n_latest', 10));

change wrong code to:

$result = db_query('SELECT n.nid FROM {review} rv INNER JOIN {node} n ON rv.nid = n.nid WHERE n.status = 1 ORDER BY n.changed DESC LIMIT %d', variable_get('review_n_latest', 10));



module version cvs, in function review_page

line 259
wrong code:

$result = pager_query('SELECT n.nid FROM review rv INNER JOIN node n ON rv.nid = n.nid WHERE n.status = 1 ORDER BY n.changed DESC');

change wrong code to:

$result = pager_query('SELECT n.nid FROM {review} rv INNER JOIN {node} n ON rv.nid = n.nid WHERE n.status = 1 ORDER BY n.changed DESC');



My result

Only with these changes the module without errors works!


Many greet of quiptime and have a nice day.

drewish’s picture

quiptime, can you check the latest version in CVS and compare it to the changes you've listed here? i think you'll find that they've already been made.

quiptime’s picture

Sorry, forgot to look latest version in CVS.

drewish’s picture

No, worries, I'd forgotten to update the 4.7 branch. This fix (and some other, older ones) should now be applied.

Anonymous’s picture

Status: Fixed » Closed (fixed)