SMF Support > Install and Upgrade Help

Topics not visible after conversion

(1/2) > >>

doomslu:
Hello,

Have been looking for 2 days on this forum to find a solution, but didn’t find it… so here’s the problem.

I’ve been converting a forum from Snitz to SMF.
As I didn’t find any information about this kind of conversion, I did a lot ‘by hand’.
As the old forum was on a Windows server and used a MS-Access database, I first had to convert the tables to a Sql database (on a Windows PC) and then imported everything in the same database as used by the fresh installed SMF-forum.
The conversions tool that I found here didn’t work, but helped me a lot to find out which SQL-statements to use. So I converted table per table.
Finally I got everything in the right tables: members, categories, boards, topics and messages. Al id’s are correct and refer to each other, as it should be.

Unfortunately something doesn’t work.
If you want to open a board, SMF does nothing.
The only way to see a topic is clicking on the last message of the board, or by watching the latest messages (which proves that topics and messages are there).

When creating on the forum some new categories, boards, topics and messages, it all works fine, except for the converted topics.
When I move an old message to a newly created board it shows up!
But… I don’t think it would be a good idea to move more than 11.000 topics by hand…
So I would appreciate if someone could help me.

Thanks in advance.

Luc

TE:
try "Find and Fix any errors" ( Admin - Forum Maintenance ).

doomslu:
Thanks, but I've tried that. "No errors found"...  :-\

CapadY:
I don't know how you did this but I think the best way is:

First installing a fresh SMF forum so you are sure it is working properly and settings are right.

Maybe makning a backup from the new SMF to be able restoring it prety fast

After that overwrite the new tables by the converted tables

Don't expext themes to work properly from the Snitz database.

emanuele:
Try this query:

--- Code: --- UPDATE {db_prefix}messages as mes, {db_prefix}topics as top
SET mes.id_board = top.id_board
WHERE mes.id_topic = top.id_topic
--- End code ---
of course change {db_prefix} with the prefix you used to install smf (default is "smf_").

Navigation

[0] Message Index

[#] Next page