Hey all the XOOPS Community !
Well, due to the important numbers of forums on my site, i wanted to reduce them by merging 2 forums in 1, few times, and so, to move hundred posts from one forum to another, and this operation, for few forums.
I usually ask my questions on the French XOOPS support community (frxoops.org) who replied me to do this (after empty tables xoops_session and xoops_online) :
Quote:
update xoops_bb_topics set forum_id=id_forum_destination
where forum_id=id_forum_source;
or, more easier to understand :
update OPDxPJ91_bb_topics set forum_id=45 where forum_id=75;
I've done it, succefully, without any errors through phpMyAdmin.
The problem is that now i have this :
This is a screenshot of the forum index.
I must precise that i wanted to move the posts and topics from the forum named "Rencontres Sportives" to the other one named "Annuaire et recherche de Traceurs par Region". This screenshot has been taken AFTER the operation on MySQL, which, i repeat, gave me no error...
Here is another screenshot from the forum "Rencontres Sportives", the one i wanted to move out all the topics.
As you can see, even if on the index it shows 109 topics, there are no topics anymore in the forum, no one...
It's really annoying, and i don't know how to fix that...
Please help me ^^
(my website is currently closed during all the operations)
