Comment 5 for bug 288919

Thanks for this. I have changed the file, although I scrapped the original site and reinstalled prosepoint without a prefix. It now works fine. Should I use the altered pp_ch.module if I install on a live site? Or should I wait before using prosepoint on a live site?

Another question if I may. I have altered the css files in the tma directory and they are reflected using tma2. I am concerned that when I upgrade the installation, this will wipe out the changes I have made. Should I copy the tma and tma2 themes to sites/all/themes and make the changes there?

Edward

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of bengtan
Sent: 26 October 2008 06:26
To: <email address hidden>
Subject: [Bug 288919] Re: installation completion error message

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.

--
installation completion error message
https://bugs.launchpad.net/bugs/288919
You received this bug notification because you are a direct subscriber
of the bug.

Status in ProsePoint, A newspaper and magazine content management system: Confirmed

Bug description:
When I completed the installation without teh sample data. I received teh following message:

user warning: Unknown column 'node.nid' in 'field list' query: SELECT node.nid, node.vid FROM ladat_node LEFT JOIN ladat_node_revisions ON node.vid = node_revisions.vid WHERE node.type = 'channel' && node.status = 1 in C:\wamp\www\ladat\profiles\prosepoint\modules\prosepoint\prosepoint_channel\pp_ch.module on line 802.

I have not yet used teh site. I will do so now.

When I installed with the sample data, teh error message was much longer and teh site does not work properly. I gave up on it.

Thank you.