• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

update for phpbb2jforum tool and question about layout

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
We'll fix the migration tool, thanks. If you like (and I think it's a good idea), register this issue in the bug tracker, at http://www.jforum.net/jira

About the layout problem, can you please attach the changed template here, so I can try to reproduce the problem on my machine?

Thanks,
Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The problem was simply a css issue, floating divs that didn't have a fixed width expanded to 100% page width by default, thus they automatically cleared one another.
[originally posted on jforum.net by uniq]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Which issue? a jforum one? how to fix it?

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Their achilles heel is the noogie! Give them noogies tiny ad!
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic