Comment 4 for bug 288919

Turns out the problem isn't as prevalent as I thought it might be. Line 802 is the only line that needs fixing for this type of error. So, if you feel up to hand patching some code, here are some instructions.

For the file C:\wamp\www\ladat\profiles\prosepoint\modules\prosepoint\prosepoint_channel\pp_ch.module, Line 802 says:

  $query_result = db_query("SELECT node.nid, node.vid FROM {node} LEFT JOIN {node_revisions} ON node.vid = node_revisions.vid WHERE node.type = '%s' && node.status = 1", 'channel');

Change that to

  $query_result = db_query("SELECT node.nid, node.vid FROM {node} node LEFT JOIN {node_revisions} node_revisions ON node.vid = node_revisions.vid WHERE node.type = '%s' && node.status = 1", 'channel');

When you do this, don't try typing in this code. Just copy and paste the entire line (and it is a single line even though the browser will line wrap it).

After you've done this, please visit either the Editions Manager or the Channels Manager to refresh some data.

If you don't want to hand patch code, you can wait for a couple of days when a bugfix release of ProsePoint will be made.

Oh, also, you don't have to reinstall the database. This source code fix (and the visit to the Channels or Edition Manager) should be sufficient.

Let me know how you go.