database prefix: missing table node_revisions

infotrendy - February 13, 2009 - 01:31
Project:Conference
Version:6.x-1.2-beta1
Component:Code
Category:bug report
Priority:normal
Assigned:zyxware
Status:needs review
Description

An error appears when we look into revisions and have prefixed database: (in my case it_)

Error:

* user warning: Table 'konferencje4.node_revisions' doesn't exist query: SELECT COUNT(*) FROM it_node n , (node_revisions nr LEFT JOIN conference c on nr.vid = c.pvid AND nr.nid = c.pnid) WHERE n.type='conference_paper' AND nr.nid = n.nid in /sites/all/modules/conference/conference.module on line 2492.
* user warning: Table 'konferencje4.node_revisions' doesn't exist query: SELECT n.title, nr.uid, c.ruid, nr.log, n.nid, nr.timestamp, nr.vid, c.rnid FROM it_node n , (node_revisions nr LEFT JOIN conference c on nr.vid = c.pvid AND nr.nid = c.pnid) WHERE n.type='conference_paper' AND nr.nid = n.nid ORDER BY nr.timestamp DESC LIMIT 0, 25 in /sites/all/modules/conference/conference.module on line 2492.

Solution: (line 2489)

$sql .= " FROM {node} n , ({node_revisions} nr LEFT JOIN {conference} c on nr.vid = c.pvid AND nr.nid = c.pnid)";

#1

zyxware - February 26, 2009 - 14:46

Hello All

I am back, I was out for about 3 weeks I will look into the issue and update shorty. Thank You for your patience.

Regards
Zyxware

#2

zyxware - March 3, 2009 - 11:22
Assigned to:Anonymous» zyxware

I have corrected the code and put it back into the CVS Repository.

It should be available in the latest DEV by tonight.

Regards
Zyxware

#3

zyxware - March 3, 2009 - 11:22
Status:active» needs review
 
 

Drupal is a registered trademark of Dries Buytaert.