XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module troubleshooting 
  4.  / URG : Error while moving posts from 1 forum to another
Register
1
SpeedAirMan
URG : Error while moving posts from 1 forum to another

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 :
Resized Image
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.
Resized Image
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)
2
SpeedAirMan
Re: URG : Error while moving posts from 1 forum to another

I've tried to synchronize the forum through the admin control panel... It doesn't work.
3
SpeedAirMan
SQL Problems : CBB

I've found some errors. The database (SQL) of CBB was an old database and wasn't updated. It was the database of the version 1.5 or 1.6...


I've found the file to update this database, but i get some errors.

Does anyone know how to solve them please ?!



1°
Quote:
requête SQL:

ALTER TABLE `prefixexoops_bb_categories` DROP `cat_state` ,
CHANGE `cat_url` `cat_url` varchar( 255 ) NOT NULL default '',
DROP `cat_showdescript` ;

MySQL a réponduocumentation
#1091 - Can't DROP 'cat_state'; check that column/key exists





2°
Quote:
requête SQL:

ALTER TABLE `prefixexoops_bb_categories` ADD INDEX `cat_order` ( `cat_order` ) ;

MySQL a réponduocumentation
#1061 - Duplicate key name 'cat_order'





3°
Quote:
requête SQL:

ALTER TABLE `prefixexoops_bb_forums` CHANGE `parent_forum` `parent_forum` smallint( 4 ) UNSIGNED NOT NULL default '0',
CHANGE `forum_moderator` `forum_moderator` varchar( 255 ) NOT NULL default '',
CHANGE `forum_topics` `forum_topics` int( 8 ) UNSIGNED NOT NULL default '0',
CHANGE `forum_posts` `forum_posts` int( 10 ) UNSIGNED NOT NULL default '0',
CHANGE `forum_last_post_id` `forum_last_post_id` int( 10 ) unsigned NOT NULL default '0',
CHANGE `cat_id` `cat_id` smallint( 3 ) UNSIGNED NOT NULL default '0',
CHANGE `forum_type` `forum_type` tinyint( 1 ) UNSIGNED NOT NULL default '0',
CHANGE `allow_html` `allow_html` tinyint( 1 ) UNSIGNED NOT NULL default '1',
CHANGE `allow_sig` `allow_sig` tinyint( 1 ) UNSIGNED NOT NULL default '1',
CHANGE `allow_subject_prefix` `allow_subject_prefix` tinyint( 1 ) UNSIGNED NOT NULL default '0',
CHANGE `forum_order` `forum_order` smallint( 4 ) UNSIGNED NOT NULL default '0',
CHANGE `attach_maxkb` `attach_maxkb` smallint( 3 ) UNSIGNED NOT NULL default '1000',
CHANGE `attach_ext` `attach_ext` varchar( 255 ) NOT NULL default '',
CHANGE `allow_polls` `allow_polls` tinyint( 1 ) unsigned NOT NULL default '0',
DROP `allow_attachments` ,
DROP `subforum_count` ;

MySQL a réponduocumentation
#1091 - Can't DROP 'allow_attachments'; check that column/key exists





4°
Quote:
requête SQL:

ALTER TABLE `prefixexoops_bb_forums` ADD INDEX `forum_last_post_id` ( `forum_last_post_id` ) ,
ADD INDEX `cat_forum` ( `cat_id` , `forum_order` ) ,
ADD INDEX `forum_order` ( `forum_order` ) ,
ADD INDEX `cat_id` ( `cat_id` ) ;

MySQL a réponduocumentation
#1061 - Duplicate key name 'forum_last_post_id'





5°
Quote:
requête SQL:

ALTER TABLE `prefixexoops_bb_moderates` ADD INDEX `mod_end` ( `mod_end` ) ,
ADD INDEX `forum_id` ( `forum_id` ) ;

MySQL a réponduocumentation
#1061 - Duplicate key name 'mod_end'


Thanks by advance !

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

289 user(s) are online (231 user(s) are browsing Support Forums)

Members: 0

Guests: 289

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits