database prefix: missing table node_revisions
| Project: | Conference |
| Version: | 6.x-1.2-beta1 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | zyxware |
| Status: | needs review |
Jump to:
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
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
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