posted 17 years ago
I recently did a merge from a phpbb forum to a jforum setup. Again, I'm quite happy with the package as always, but I wanted to let you guys know of a slight error I had to fix to make it all work. In the mysql_queries file of the phpbb2jforum tool, this entry was changed to reflect the actual name of the jforum table column without which an error was being thrown: 'cannot find topic_vote in forum list'
query.topics = INSERT INTO jforum_topics ( topic_id, forum_id, topic_title, user_id, topic_time, topic_views, \
topic_replies, topic_status, topic_vote_id, topic_type, topic_first_post_id, topic_last_post_id ) \
SELECT topic_id, forum_id, topic_title, topic_poster, FROM_UNIXTIME(topic_time), topic_views, \
topic_replies, topic_status, topic_vote, topic_type, topic_first_post_id, topic_last_post_id \
FROM phpbb_topics
Note: bolded segment was previously "topic_vote" This may not be the appropriate column for the data to fall into, but there was no other column with a similar name. I guess we should also confirm that the topic_vote field in a phpbb db is what you guys are wanting to be mapped to topic_vote_id, or if the actual schema is missing an overlooked column for topic_vote itself.
I also had a question regarding layout. For this problem, I haven't actually delved in and figured out what is going on, but my first impulse is that its some wacky CSS issue. Note that the only template change I have made thusfar is to place the forum into a containing HTML element, and then reduce its width to 900px from its default 100%. I have attached a screenshot of the issue; you will see the subject information being pushed off to the far left, past the edge of the forum on top of one another.
Thanks in advance for any insight.
[originally posted on jforum.net by uniq]