Converting

New Member Joined: Jan 19, 2011 Posts: 6

Hi Im really hoping someone can help me.

Up to recently I have been using PNC 4.5 which is no longer supported and hasnt been for some time.

So I have finally decided to convert to raven (latest edition)

Ive managed to transfer most of the "gumph" over like users etc yet Im having no luck with the forums.

I keep getting..

Could not obtain topic information

DEBUG MODE

SQL Error : 1054 Unknown column 'f.auth_download' in 'field list'

SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments, f.auth_download, t.topic_attachment FROM nuke_bbtopics t, nuke_bbforums f WHERE t.topic_id = '1' AND f.forum_id = t.forum_id

Line : 164
File : viewtopic.php

Im a relative sql noob so can someone please help

Posted: Tue Jun 07, 2011 9:37 am

It looks to me like you may be using the viewtopic.php program from the PNC4.5 rather than the one from the Ravennuke distribution. You need to have both the tables and the programs from the Ravennuke distribution. If your forums tables from the PNC 4.5 distribution have different fields than the ones in the Ravennuke distribution do you are going to need to figure out how to convert them to the appropriate format, probably dropping fields such as f.auth_download. Of course, you will have a reliable backup before you start mucking with this stuff.

In the Ravennuke distribution, in the utilityfiles section there is a table comparison utility you can run. That might give you a good idea about what table discrepancies exist. Instructions are in the file(s). You might also want to read the RNWIKI section about installation and upgrading very carefully before you get going.

Involved Joined: Jul 03, 2006 Posts: 273

@nexusuck Not to discourage you from switching to Raven but more as a curiousity what support did you seek from PNC that you didn't receive? It is a much smaller crew supporting over there than you get here but rarely does any support question go unanswered (not to say it isn't possible as we get really busy and miss some things).

If you could link me to your question on the pnc site so I can make sure it is not an issue that also needs resolved for others it would be much appreciated.

Thanks! and Good Luck with your Conversion. One thing I recommend while Exporting your Data to Import is make sure to use extended inserts.