convert Ipb 2.3.4 to SMF

LiamTheDuck · February 14, 2008, 08:09:50 PM

Im doing this for my m8

I need a 2.3.4 converter please

barrage time · February 14, 2008, 08:48:59 PM

Yeah, its for me :d.
Does anyone have it?

LiamTheDuck · February 15, 2008, 01:53:43 PM

We need this quickly, sorry for stupid post

Dragooon · February 17, 2008, 12:33:50 AM

Maybe Jay will be working on it, Have you tried using the 2.2 converter? Make sure to have a full backup though.

LiamTheDuck · February 19, 2008, 03:39:03 PM

I dont get the 2.2 converter

if someone can run me through it i will be greatful

Mudassar Ahmed · February 20, 2008, 04:16:04 AM

I also didn't find Convertor for 2.2, A direct link is much appreciated!! Thanks !

Chris IOW · March 10, 2008, 06:30:56 PM

Yep whats the direct link please?

Dragooon · March 10, 2008, 10:58:21 PM

Its stickied on this board
http://www.simplemachines.org/community/index.php?topic=145284.0

Rumbaar · March 21, 2008, 04:11:05 AM

Be sure to check out the http://www.simplemachines.org/download/?converters section, also to keep an eye on the list of in progress and requested converters. Jay is a busy man with a number of projects that he alone is doing, so it can take time.

http://support.simplemachines.org/converter_request.php

limo2005 · April 13, 2008, 02:40:16 PM

Quote from: Dragooon on February 17, 2008, 12:33:50 AM
Maybe Jay will be working on it, Have you tried using the 2.2 converter? Make sure to have a full backup though.

IBP 2.3.4

SMF SMF 1.1.4

Converter 2.2

Hi,

I have used the 2.2 converter and the members convert very well, However I do get the "Duplicate entry '255' for key 1" error!

Converting members..... Successful!
Converting categories... Unsuccessful!
This query:

INSERT INTO `web53-mickey`.smf_categories
(ID_CAT, name, catOrder)
VALUES

Code Select

('704', 'ANNOUNCEMENTS', '1'),
    ('705', 'CHATROOM', '2'),
    ('706', 'FOR SALE, WANTED or SWAP', '5'),
    ('707', 'TAKE A BREAK', '4'),
    ('708', 'PROPERTY OF THE MONTH', '7'),
    ('709', 'AVON:', '8'),
    ('710', 'BEDFORDSHIRE', '9'),
    ('711', 'BERKSHIRE', '10'),
    ('712', 'BUCKS', '11'),
    ('713', 'CAMBRIDGESHIRE', '12'),
    ('714', 'CHANNEL ISLANDS', '13'),
    ('715', 'CHESHIRE', '14'),
    ('716', 'CORNWALL', '15'),
    ('717', 'CUMBRIA', '16'),
    ('718', 'DERBYSHIRE:', '17'),
    ('719', 'DEVON', '18'),
    ('720', 'DORSET', '19'),
    ('721', 'DURHAM', '20'),
    ('722', 'EAST SUSSEX', '21'),
    ('723', 'ESSEX', '22'),
    ('724', 'GLOUCESTERSHIRE', '23'),
    ('725', 'GREATER LONDON NORTH', '24'),
    ('726', 'GREATER LONDON EAST', '25'),
    ('727', 'GREATER LONDON SOUTH', '26'),
    ('728', 'GREATER LONDON WEST', '27'),
    ('729', 'HAMPSHIRE', '28'),
    ('730', 'HEREFORDSHIRE', '29'),
    ('731', 'HERTFORDSHIRE', '30'),
    ('732', 'ISLE OF MAN', '31'),
    ('733', 'ISLE OF WIGHT', '32'),
    ('734', 'IRELAND', '33'),
    ('735', 'KENT', '34'),
    ('736', 'LANCASHIRE', '35'),
    ('737', 'LEICESTERSHIRE', '36'),
    ('739', 'MANCHESTER', '38'),
    ('740', 'MERSEYSIDE', '39'),
    ('741', 'MIDDLESEX', '40'),
    ('742', 'NORFOLK', '41'),
    ('743', 'NOTTINGHAMSHIRE', '42'),
    ('744', 'NORTHAMPTONSHIRE', '43'),
    ('745', 'NORTHUMBERLAND', '44'),
    ('746', 'OXFORDSHIRE', '45'),
    ('747', 'SCOTLAND', '46'),
    ('748', 'SHROPSHIRE', '47'),
    ('749', 'SOMERSET', '48'),
    ('750', 'STAFFORDSHIRE', '49'),
    ('751', 'SUFFOLK', '50'),
    ('752', 'SURREY', '51'),
    ('753', 'TYNE &amp; WEAR', '52'),
    ('754', 'WARWICKSHIRE', '53'),
    ('755', 'WALES', '54'),
    ('756', 'WEST MIDLANDS', '55'),
    ('757', 'WEST SUSSEX', '56'),
    ('758', 'WILTSHIRE', '57'),
    ('759', 'WORCESTERSHIRE', '58'),
    ('760', 'YORKSHIRE', '59'),
    ('761', 'MULTI EXCHANGE (3 Way or More)', '60'),
    ('762', 'SPECIALS NEEDS', '61'),
    ('763', 'I WOULD LIKE MORE ROOMS', '62'),
    ('764', 'I WOULD LIKE LESS ROOMS', '63'),
    ('765', 'PLANES, TRAINS AND AUTOMOBILES', '64'),
    ('766', 'NO REPLY / ON HOLD / EXCHANGE FOUND', '65'),
    ('767', 'FORUM STAFF ONLY', '66'),
    ('778', 'LINCOLNSHIRE', '37'),
    ('781', 'LATEST EXCHANGES', '3');

Caused the error:

Duplicate entry '255' for key 1

I got the very same error when I attempted this in July 2006, http://www.simplemachines.org/community/index.php?topic=102499.msg661441#msg661441only then it was ibp 2.1.7 and smf and was hoping that if I left it a while, Things would become easier as I became more experienced.

Never got it to work so I am attempting it now! But how do I get around this error and sucessfully convert the Forums into SMF?

Thanks for any advice / solution

Limo

SleePy · April 18, 2008, 12:35:44 PM

You need to alter the smf_categories table and change the id_cat to hold a bigger value.

limo2005 · May 27, 2008, 02:59:29 PM

Quote from: SleePy on April 18, 2008, 12:35:44 PM
You need to alter the smf_categories table and change the id_cat to hold a bigger value.

IBP 2.3.5,
SMF 1.1.5,
Converter 2.3

Which value do you suggest? It was set to 4 and I have set it to 255 as thats whats indicating as the maximum.

The conversion stops at:

Code Select



Recalculating forum statistics... Unsuccessful!
This query:

    ALTER TABLE `web53-hsf`.smf_smileys
    ORDER BY LENGTH(code) DESC;

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LENGTH(code) DESC' at line 2

.

The Cats are not converting resulting in all the forums being placed in one area. In the admin cp, i see the cats but the forums are just not there.

If i look at the db smf_categories, i see the ID_CAT for each one is 255, even before I changed the value from 4.

The images below are of the forum i wish to migrate and how the new forum looks after conversion.

Forum Maintenance reults in :

Code Select

Listing of forum errors
The following errors are fouling up your forum:
Topic #1206 is in board #704, which is missing.
Topic #1207 is in board #704, which is missing.
Board #0 is in category #255, which is missing.
Board #7 is in category #255, which is missing.
Board #10 is in category #255, which is missing.
Board #11 is in category #255, which is missing.
Board #12 is in category #255, which is missing.
Board #14 is in category #255, which is missing.
Board #15 is in category #255, which is missing.
Board #16 is in category #255, which is missing.
Board #17 is in category #255, which is missing.
Board #18 is in category #255, which is missing.
Board #40 is in category #255, which is missing.
Board #41 is in category #255, which is missing.
Board #42 is in category #255, which is missing.
Board #43 is in category #255, which is missing.
Board #44 is in category #255, which is missing.
Board #45 is in category #255, which is missing.
Board #46 is in category #255, which is missing.
Board #47 is in category #255, which is missing.
Board #48 is in category #255, which is missing.
Board #49 is in category #255, which is missing.
Board #50 is in category #255, which is missing.
Board #51 is in category #255, which is missing.
Board #56 is in category #255, which is missing.
Board #57 is in category #255, which is missing.
Board #58 is in category #255, which is missing.
Board #59 is in category #255, which is missing.
Board #60 is in category #255, which is missing.
Board #61 is in category #255, which is missing.
Board #63 is in category #255, which is missing.
Board #64 is in category #255, which is missing.
Board #65 is in category #255, which is missing.
Board #66 is in category #255, which is missing.
Board #67 is in category #255, which is missing.
Board #68 is in category #255, which is missing.
Board #69 is in category #255, which is missing.
Board #70 is in category #255, which is missing.
Board #71 is in category #255, which is missing.
Board #72 is in category #255, which is missing.
Board #73 is in category #255, which is missing.
Board #74 is in category #255, which is missing.
Board #75 is in category #255, which is missing.
Board #76 is in category #255, which is missing.
Board #77 is in category #255, which is missing.
Board #78 is in category #255, which is missing.
Board #79 is in category #255, which is missing.
Board #80 is in category #255, which is missing.
Board #81 is in category #255, which is missing.
Board #82 is in category #255, which is missing.
Board #83 is in category #255, which is missing.
Board #84 is in category #255, which is missing.
Board #85 is in category #255, which is missing.
Board #89 is in category #255, which is missing.
Board #90 is in category #255, which is missing.
Board #91 is in category #255, which is missing.
Board #92 is in category #255, which is missing.
Board #102 is in category #255, which is missing.
Board #107 is in category #255, which is missing.
Board #108 is in category #255, which is missing.
Board #109 is in category #255, which is missing.
Board #110 is in category #255, which is missing.
Board #115 is in category #255, which is missing.
Board #116 is in category #255, which is missing.
Board #158 is in category #255, which is missing.
Board #159 is in category #255, which is missing.
Board #162 is in category #255, which is missing.
Board #163 is in category #255, which is missing.
Board #164 is in category #255, which is missing.
Board #165 is in category #255, which is missing.
Board #166 is in category #255, which is missing.
Board #167 is in category #255, which is missing.
Board #168 is in category #255, which is missing.
Board #169 is in category #255, which is missing.
Board #170 is in category #255, which is missing.
Board #171 is in category #255, which is missing.
Board #172 is in category #255, which is missing.
Board #173 is in category #255, which is missing.
Board #174 is in category #255, which is missing.
Board #175 is in category #255, which is missing.
Board #176 is in category #255, which is missing.
Board #177 is in category #255, which is missing.
Board #178 is in category #255, which is missing.
Board #179 is in category #255, which is missing.
Board #180 is in category #255, which is missing.
Board #181 is in category #255, which is missing.
Board #182 is in category #255, which is missing.
Board #183 is in category #255, which is missing.
Board #184 is in category #255, which is missing.
Board #185 is in category #255, which is missing.
Board #186 is in category #255, which is missing.
Board #187 is in category #255, which is missing.
Board #188 is in category #255, which is missing.
Board #189 is in category #255, which is missing.
Board #190 is in category #255, which is missing.
Board #191 is in category #255, which is missing.
Board #192 is in category #255, which is missing.
Board #193 is in category #255, which is missing.
Board #194 is in category #255, which is missing.
Board #195 is in category #255, which is missing.
Board #196 is in category #255, which is missing.
Board #197 is in category #255, which is missing.
Board #198 is in category #255, which is missing.
Board #199 is in category #255, which is missing.
Board #200 is in category #255, which is missing.
Board #201 is in category #255, which is missing.
Board #202 is in category #255, which is missing.
Board #203 is in category #255, which is missing.
Board #204 is in category #255, which is missing.
Board #205 is in category #255, which is missing.
Board #206 is in category #255, which is missing.
Board #207 is in category #255, which is missing.
Board #208 is in category #255, which is missing.
Board #209 is in category #255, which is missing.
Board #210 is in category #255, which is missing.
Board #211 is in category #255, which is missing.
Board #212 is in category #255, which is missing.
Board #213 is in category #255, which is missing.
Board #214 is in category #255, which is missing.
Board #215 is in category #255, which is missing.
Board #216 is in category #255, which is missing.
Board #217 is in category #255, which is missing.
Board #218 is in category #255, which is missing.
Board #219 is in category #255, which is missing.
Board #220 is in category #255, which is missing.
Board #221 is in category #255, which is missing.
Board #222 is in category #255, which is missing.
Board #223 is in category #255, which is missing.
Board #224 is in category #255, which is missing.
Board #225 is in category #255, which is missing.
Board #226 is in category #255, which is missing.
Board #228 is in category #255, which is missing.
Board #230 is in category #255, which is missing.
Board #231 is in category #255, which is missing.
Board #232 is in category #255, which is missing.
Board #233 is in category #255, which is missing.
Board #234 is in category #255, which is missing.
Board #235 is in category #255, which is missing.
Board #236 is in category #255, which is missing.
Board #237 is in category #255, which is missing.
Board #238 is in category #255, which is missing.
Board #239 is in category #255, which is missing.
Board #240 is in category #255, which is missing.
Board #241 is in category #255, which is missing.
Board #242 is in category #255, which is missing.
Board #243 is in category #255, which is missing.
Board #244 is in category #255, which is missing.
Board #245 is in category #255, which is missing.
Board #246 is in category #255, which is missing.
Board #247 is in category #255, which is missing.
Board #248 is in category #255, which is missing.
Board #249 is in category #255, which is missing.
Board #250 is in category #255, which is missing.
Board #251 is in category #255, which is missing.
Board #252 is in category #255, which is missing.
Board #253 is in category #255, which is missing.
Board #254 is in category #255, which is missing.
Board #255 is in category #255, which is missing.
Board #256 is in category #255, which is missing.
Board #257 is in category #255, which is missing.
Board #258 is in category #255, which is missing.
Board #259 is in category #255, which is missing.
Board #260 is in category #255, which is missing.
Board #261 is in category #255, which is missing.
Board #262 is in category #255, which is missing.
Board #263 is in category #255, which is missing.
Board #264 is in category #255, which is missing.
Board #265 is in category #255, which is missing.
Board #266 is in category #255, which is missing.
Board #267 is in category #255, which is missing.
Board #268 is in category #255, which is missing.
Board #269 is in category #255, which is missing.
Board #270 is in category #255, which is missing.
Board #271 is in category #255, which is missing.
Board #272 is in category #255, which is missing.
Board #273 is in category #255, which is missing.
Board #274 is in category #255, which is missing.
Board #275 is in category #255, which is missing.
Board #276 is in category #255, which is missing.
Board #277 is in category #255, which is missing.
Board #278 is in category #255, which is missing.
Board #279 is in category #255, which is missing.
Board #280 is in category #255, which is missing.
Board #281 is in category #255, which is missing.
Board #282 is in category #255, which is missing.
Board #283 is in category #255, which is missing.
Board #284 is in category #255, which is missing.
Board #285 is in category #255, which is missing.
Board #286 is in category #255, which is missing.
Board #287 is in category #255, which is missing.
Board #288 is in category #255, which is missing.
Board #289 is in category #255, which is missing.
Board #290 is in category #255, which is missing.
Board #291 is in category #255, which is missing.
Board #292 is in category #255, which is missing.
Board #293 is in category #255, which is missing.
Board #294 is in category #255, which is missing.
Board #295 is in category #255, which is missing.
Board #296 is in category #255, which is missing.
Board #297 is in category #255, which is missing.
Board #298 is in category #255, which is missing.
Board #299 is in category #255, which is missing.
Board #300 is in category #255, which is missing.
Board #301 is in category #255, which is missing.
Board #302 is in category #255, which is missing.
Board #303 is in category #255, which is missing.
Board #304 is in category #255, which is missing.
Board #305 is in category #255, which is missing.
Board #306 is in category #255, which is missing.
Board #307 is in category #255, which is missing.
Board #308 is in category #255, which is missing.
Board #309 is in category #255, which is missing.
Board #310 is in category #255, which is missing.
Board #311 is in category #255, which is missing.
Board #312 is in category #255, which is missing.
Board #313 is in category #255, which is missing.
Board #314 is in category #255, which is missing.
Board #315 is in category #255, which is missing.
Board #316 is in category #255, which is missing.
Board #317 is in category #255, which is missing.
Board #318 is in category #255, which is missing.
Board #319 is in category #255, which is missing.
Board #320 is in category #255, which is missing.
Board #321 is in category #255, which is missing.
Board #322 is in category #255, which is missing.
Board #323 is in category #255, which is missing.
Board #324 is in category #255, which is missing.
Board #325 is in category #255, which is missing.
Board #326 is in category #255, which is missing.
Board #327 is in category #255, which is missing.
Board #328 is in category #255, which is missing.
Board #329 is in category #255, which is missing.
Board #330 is in category #255, which is missing.
Board #331 is in category #255, which is missing.
Board #332 is in category #255, which is missing.
Board #334 is in category #255, which is missing.
Board #335 is in category #255, which is missing.
Board #336 is in category #255, which is missing.
Board #337 is in category #255, which is missing.
Board #338 is in category #255, which is missing.
Board #339 is in category #255, which is missing.
Board #340 is in category #255, which is missing.
Board #341 is in category #255, which is missing.
Board #342 is in category #255, which is missing.
Board #343 is in category #255, which is missing.
Board #344 is in category #255, which is missing.
Board #345 is in category #255, which is missing.
Board #346 is in category #255, which is missing.
Board #347 is in category #255, which is missing.
Board #349 is in category #255, which is missing.
Board #350 is in category #255, which is missing.
Board #351 is in category #255, which is missing.
Board #352 is in category #255, which is missing.
Board #354 is in category #255, which is missing.
Board #355 is in category #255, which is missing.
Board #356 is in category #255, which is missing.
Board #357 is in category #255, which is missing.
Board #358 is in category #255, which is missing.
Board #359 is in category #255, which is missing.
Board #360 is in category #255, which is missing.
Board #361 is in category #255, which is missing.
Board #362 is in category #255, which is missing.
Board #363 is in category #255, which is missing.
Board #364 is in category #255, which is missing.
Board #365 is in category #255, which is missing.
Board #366 is in category #255, which is missing.
Board #367 is in category #255, which is missing.
Board #368 is in category #255, which is missing.
Board #369 is in category #255, which is missing.
Board #370 is in category #255, which is missing.
Board #371 is in category #255, which is missing.
Board #372 is in category #255, which is missing.
Board #373 is in category #255, which is missing.
Board #374 is in category #255, which is missing.
Board #375 is in category #255, which is missing.
Board #376 is in category #255, which is missing.
Board #377 is in category #255, which is missing.
Board #378 is in category #255, which is missing.
Board #379 is in category #255, which is missing.
Board #380 is in category #255, which is missing.
Board #381 is in category #255, which is missing.
Board #382 is in category #255, which is missing.
Board #383 is in category #255, which is missing.
Board #384 is in category #255, which is missing.
Board #385 is in category #255, which is missing.
Board #386 is in category #255, which is missing.
Board #387 is in category #255, which is missing.
Board #388 is in category #255, which is missing.
Board #389 is in category #255, which is missing.
Board #390 is in category #255, which is missing.
Board #391 is in category #255, which is missing.
Board #392 is in category #255, which is missing.
Board #393 is in category #255, which is missing.
Board #394 is in category #255, which is missing.
Board #395 is in category #255, which is missing.
Board #396 is in category #255, which is missing.
Board #397 is in category #255, which is missing.
Board #398 is in category #255, which is missing.
Board #399 is in category #255, which is missing.
Board #400 is in category #255, which is missing.
Board #401 is in category #255, which is missing.
Board #402 is in category #255, which is missing.
Board #403 is in category #255, which is missing.
Board #404 is in category #255, which is missing.
Board #405 is in category #255, which is missing.
Board #406 is in category #255, which is missing.
Board #407 is in category #255, which is missing.
Board #408 is in category #255, which is missing.
Board #409 is in category #255, which is missing.
Board #410 is in category #255, which is missing.
Board #411 is in category #255, which is missing.
Board #412 is in category #255, which is missing.
Board #413 is in category #255, which is missing.
Board #414 is in category #255, which is missing.
Board #415 is in category #255, which is missing.
Board #416 is in category #255, which is missing.
Board #417 is in category #255, which is missing.
Board #418 is in category #255, which is missing.
Board #419 is in category #255, which is missing.
Board #420 is in category #255, which is missing.
Board #421 is in category #255, which is missing.
Board #422 is in category #255, which is missing.
Board #423 is in category #255, which is missing.
Board #424 is in category #255, which is missing.
Board #425 is in category #255, which is missing.
Board #426 is in category #255, which is missing.
Board #427 is in category #255, which is missing.
Board #428 is in category #255, which is missing.
Board #429 is in category #255, which is missing.
Board #430 is in category #255, which is missing.
Board #431 is in category #255, which is missing.
Board #432 is in category #255, which is missing.
Board #433 is in category #255, which is missing.
Board #434 is in category #255, which is missing.
Board #435 is in category #255, which is missing.
Board #436 is in category #255, which is missing.
Board #437 is in category #255, which is missing.
Board #438 is in category #255, which is missing.
Board #439 is in category #255, which is missing.
Board #440 is in category #255, which is missing.
Board #441 is in category #255, which is missing.
Board #442 is in category #255, which is missing.
Board #443 is in category #255, which is missing.
Board #444 is in category #255, which is missing.
Board #445 is in category #255, which is missing.
Board #446 is in category #255, which is missing.
Board #447 is in category #255, which is missing.
Board #448 is in category #255, which is missing.
Board #449 is in category #255, which is missing.
Board #450 is in category #255, which is missing.
Board #451 is in category #255, which is missing.
Board #452 is in category #255, which is missing.
Board #453 is in category #255, which is missing.
Board #454 is in category #255, which is missing.
Board #455 is in category #255, which is missing.
Board #456 is in category #255, which is missing.
Board #457 is in category #255, which is missing.
Board #458 is in category #255, which is missing.
Board #459 is in category #255, which is missing.
Board #460 is in category #255, which is missing.
Board #461 is in category #255, which is missing.
Board #462 is in category #255, which is missing.
Board #463 is in category #255, which is missing.
Board #464 is in category #255, which is missing.
Board #465 is in category #255, which is missing.
Board #466 is in category #255, which is missing.
Board #467 is in category #255, which is missing.
Board #468 is in category #255, which is missing.
Board #469 is in category #255, which is missing.
Board #470 is in category #255, which is missing.
Board #471 is in category #255, which is missing.
Board #472 is in category #255, which is missing.
Board #473 is in category #255, which is missing.
Board #474 is in category #255, which is missing.
Board #475 is in category #255, which is missing.
Board #476 is in category #255, which is missing.
Board #477 is in category #255, which is missing.
Board #478 is in category #255, which is missing.
Board #479 is in category #255, which is missing.
Board #480 is in category #255, which is missing.
Board #481 is in category #255, which is missing.
Board #482 is in category #255, which is missing.
Board #483 is in category #255, which is missing.
Board #484 is in category #255, which is missing.
Board #485 is in category #255, which is missing.
Board #486 is in category #255, which is missing.
Board #488 is in category #255, which is missing.
Board #489 is in category #255, which is missing.
Board #490 is in category #255, which is missing.
Board #491 is in category #255, which is missing.
Board #492 is in category #255, which is missing.
Board #493 is in category #255, which is missing.
Board #494 is in category #255, which is missing.
Board #495 is in category #255, which is missing.
Board #496 is in category #255, which is missing.
Board #497 is in category #255, which is missing.
Board #498 is in category #255, which is missing.
Board #499 is in category #255, which is missing.
Board #500 is in category #255, which is missing.
Board #501 is in category #255, which is missing.
Board #502 is in category #255, which is missing.
Board #503 is in category #255, which is missing.
Board #504 is in category #255, which is missing.
Board #505 is in category #255, which is missing.
Board #506 is in category #255, which is missing.
Board #507 is in category #255, which is missing.
Board #508 is in category #255, which is missing.
Board #509 is in category #255, which is missing.
Board #510 is in category #255, which is missing.
Board #511 is in category #255, which is missing.
Board #512 is in category #255, which is missing.
Board #513 is in category #255, which is missing.
Board #518 is in category #255, which is missing.
Board #519 is in category #255, which is missing.
Board #520 is in category #255, which is missing.
Board #521 is in category #255, which is missing.
Board #522 is in category #255, which is missing.
Board #523 is in category #255, which is missing.
Board #524 is in category #255, which is missing.
Board #525 is in category #255, which is missing.
Board #526 is in category #255, which is missing.
Board #527 is in category #255, which is missing.
Board #528 is in category #255, which is missing.
Board #529 is in category #255, which is missing.
Board #530 is in category #255, which is missing.
Board #531 is in category #255, which is missing.
Board #532 is in category #255, which is missing.
Board #533 is in category #255, which is missing.
Board #534 is in category #255, which is missing.
Board #535 is in category #255, which is missing.
Board #536 is in category #255, which is missing.
Board #537 is in category #255, which is missing.
Board #538 is in category #255, which is missing.
Board #539 is in category #255, which is missing.
Board #540 is in category #255, which is missing.
Board #541 is in category #255, which is missing.
Board #542 is in category #255, which is missing.
Board #545 is in category #255, which is missing.
Board #546 is in category #255, which is missing.
Board #547 is in category #255, which is missing.
Board #548 is in category #255, which is missing.
Board #549 is in category #255, which is missing.
Board #550 is in category #255, which is missing.
Board #551 is in category #255, which is missing.
Board #552 is in category #255, which is missing.
Board #553 is in category #255, which is missing.
Board #554 is in category #255, which is missing.
Board #555 is in category #255, which is missing.
Board #556 is in category #255, which is missing.
Board #557 is in category #255, which is missing.
Board #558 is in category #255, which is missing.
Board #559 is in category #255, which is missing.
Board #560 is in category #255, which is missing.
Board #561 is in category #255, which is missing.
Board #562 is in category #255, which is missing.
Board #563 is in category #255, which is missing.
Board #564 is in category #255, which is missing.
Board #565 is in category #255, which is missing.
Board #566 is in category #255, which is missing.
Board #567 is in category #255, which is missing.
Board #568 is in category #255, which is missing.
Board #569 is in category #255, which is missing.
Board #570 is in category #255, which is missing.
Board #571 is in category #255, which is missing.
Board #572 is in category #255, which is missing.
Board #573 is in category #255, which is missing.
Board #574 is in category #255, which is missing.
Board #575 is in category #255, which is missing.
Board #576 is in category #255, which is missing.
Board #577 is in category #255, which is missing.
Board #578 is in category #255, which is missing.
Board #579 is in category #255, which is missing.
Board #580 is in category #255, which is missing.
Board #581 is in category #255, which is missing.
Board #582 is in category #255, which is missing.
Board #583 is in category #255, which is missing.
Board #584 is in category #255, which is missing.
Board #586 is in category #255, which is missing.
Board #587 is in category #255, which is missing.
Board #588 is in category #255, which is missing.
Board #589 is in category #255, which is missing.
Board #590 is in category #255, which is missing.
Board #591 is in category #255, which is missing.
Board #592 is in category #255, which is missing.
Board #593 is in category #255, which is missing.
Board #594 is in category #255, which is missing.
Board #595 is in category #255, which is missing.
Board #596 is in category #255, which is missing.
Board #597 is in category #255, which is missing.
Board #598 is in category #255, which is missing.
Board #599 is in category #255, which is missing.
Board #600 is in category #255, which is missing.
Board #601 is in category #255, which is missing.
Board #602 is in category #255, which is missing.
Board #603 is in category #255, which is missing.
Board #604 is in category #255, which is missing.
Board #605 is in category #255, which is missing.
Board #606 is in category #255, which is missing.
Board #607 is in category #255, which is missing.
Board #608 is in category #255, which is missing.
Board #609 is in category #255, which is missing.
Board #610 is in category #255, which is missing.
Board #611 is in category #255, which is missing.
Board #612 is in category #255, which is missing.
Board #613 is in category #255, which is missing.
Board #614 is in category #255, which is missing.
Board #615 is in category #255, which is missing.
Board #618 is in category #255, which is missing.
Board #619 is in category #255, which is missing.
Board #620 is in category #255, which is missing.
Board #621 is in category #255, which is missing.
Board #622 is in category #255, which is missing.
Board #623 is in category #255, which is missing.
Board #624 is in category #255, which is missing.
Board #625 is in category #255, which is missing.
Board #626 is in category #255, which is missing.
Board #627 is in category #255, which is missing.
Board #628 is in category #255, which is missing.
Board #629 is in category #255, which is missing.
Board #630 is in category #255, which is missing.
Board #631 is in category #255, which is missing.
Board #632 is in category #255, which is missing.
Board #633 is in category #255, which is missing.
Board #634 is in category #255, which is missing.
Board #635 is in category #255, which is missing.
Board #636 is in category #255, which is missing.
Board #637 is in category #255, which is missing.
Board #638 is in category #255, which is missing.
Board #639 is in category #255, which is missing.
Board #640 is in category #255, which is missing.
Board #641 is in category #255, which is missing.
Board #642 is in category #255, which is missing.
Board #643 is in category #255, which is missing.
Board #645 is in category #255, which is missing.
Board #646 is in category #255, which is missing.
Board #647 is in category #255, which is missing.
Board #648 is in category #255, which is missing.
Board #649 is in category #255, which is missing.
Board #650 is in category #255, which is missing.
Board #651 is in category #255, which is missing.
Board #653 is in category #255, which is missing.
Board #654 is in category #255, which is missing.
Board #655 is in category #255, which is missing.
Board #656 is in category #255, which is missing.
Board #657 is in category #255, which is missing.
Board #658 is in category #255, which is missing.
Board #659 is in category #255, which is missing.
Board #660 is in category #255, which is missing.
Board #661 is in category #255, which is missing.
Board #662 is in category #255, which is missing.
Board #663 is in category #255, which is missing.
Board #664 is in category #255, which is missing.
Board #666 is in category #255, which is missing.
Board #667 is in category #255, which is missing.
Board #668 is in category #255, which is missing.
Board #669 is in category #255, which is missing.
Board #670 is in category #255, which is missing.
Board #671 is in category #255, which is missing.
Board #673 is in category #255, which is missing.
Board #674 is in category #255, which is missing.
Board #675 is in category #255, which is missing.
Board #676 is in category #255, which is missing.
Board #677 is in category #255, which is missing.
Board #678 is in category #255, which is missing.
Board #680 is in category #255, which is missing.
Board #681 is in category #255, which is missing.
Board #682 is in category #255, which is missing.
Board #683 is in category #255, which is missing.
Board #684 is in category #255, which is missing.
Board #686 is in category #255, which is missing.
Board #687 is in category #255, which is missing.
Board #688 is in category #255, which is missing.
Board #689 is in category #255, which is missing.
Board #690 is in category #255, which is missing.
Board #691 is in category #255, which is missing.
Board #692 is in category #255, which is missing.
Board #693 is in category #255, which is missing.
Board #694 is in category #255, which is missing.
Board #695 is in category #255, which is missing.
Board #697 is in category #255, which is missing.
Board #700 is in category #255, which is missing.
Board #701 is in category #255, which is missing.
Board #703 is in category #255, which is missing.
Board #738 is in category #255, which is missing.
Board #769 is in category #255, which is missing.
Board #770 is in category #255, which is missing.
Board #771 is in category #255, which is missing.
Board #773 is in category #255, which is missing.
Board #775 is in category #255, which is missing.
Board #776 is in category #255, which is missing.
Board #777 is in category #255, which is missing.
Board #780 is in category #255, which is missing.
Message #509607 was posted by member #16, who is now missing.
Message #510459 was posted by member #16, who is now missing.
Message #510642 was posted by member #16, who is now missing.
Message #510875 was posted by member #16, who is now missing.
Message #511336 was posted by member #16, who is now missing.
Message #512482 was posted by member #16, who is now missing.
Message #513266 was posted by member #16, who is now missing.
Message #513690 was posted by member #16, who is now missing.
Message #513907 was posted by member #16, who is now missing.
Message #516239 was posted by member #16, who is now missing.
Message #516311 was posted by member #16, who is now missing.
Message #516546 was posted by member #16, who is now missing.
Message #516620 was posted by member #16, who is now missing.
Message #516779 was posted by member #16, who is now missing.
Message #516854 was posted by member #16, who is now missing.
Message #516900 was posted by member #16, who is now missing.
Message #517192 was posted by member #16, who is now missing.
Message #517642 was posted by member #16, who is now missing.
Message #518025 was posted by member #16, who is now missing.
Message #518180 was posted by member #16, who is now missing.
Message #520421 was posted by member #16, who is now missing.
Message #520485 was posted by member #16, who is now missing.
Message #520703 was posted by member #16, who is now missing.
Message #520826 was posted by member #16, who is now missing.
Message #521030 was posted by member #16, who is now missing.
Message #521185 was posted by member #16, who is now missing.
Message #521311 was posted by member #16, who is now missing.
Message #521333 was posted by member #16, who is now missing.
Message #521654 was posted by member #16, who is now missing.
Message #522282 was posted by member #16, who is now missing.
Message #522394 was posted by member #16, who is now missing.
Message #538638 was posted by member #16, who is now missing.
Message #538832 was posted by member #16, who is now missing.
Message #541991 was posted by member #16, who is now missing.
Message #546223 was posted by member #16, who is now missing.
Message #546289 was posted by member #16, who is now missing.
Message #546629 was posted by member #16, who is now missing.
Message #546651 was posted by member #16, who is now missing.
Message #547443 was posted by member #16, who is now missing.
Message #554444 was posted by member #16, who is now missing.
Message #561001 was posted by member #16, who is now missing.
Message #561089 was posted by member #16, who is now missing.
Message #574446 was posted by member #16, who is now missing.
Message #576053 was posted by member #16, who is now missing.
Message #576402 was posted by member #16, who is now missing.
Message #585602 was posted by member #16, who is now missing.
Message #596919 was posted by member #16, who is now missing.
Message #597044 was posted by member #16, who is now missing.
Message #612946 was posted by member #16, who is now missing.
Message #612998 was posted by member #16, who is now missing.
Message #613390 was posted by member #16, who is now missing.
Message #618034 was posted by member #16, who is now missing.
Message #625890 was posted by member #16, who is now missing.
Message #626160 was posted by member #16, who is now missing.
Message #626380 was posted by member #16, who is now missing.
Message #626898 was posted by member #16, who is now missing.
Message #628461 was posted by member #16, who is now missing.
Message #628541 was posted by member #16, who is now missing.
Personal message #1140 has been sent to one or more people, but does not exist.
Member #216 has received one or more personal messages, but does not exist.
Member #218 has received one or more personal messages, but does not exist.
Member #399 has received one or more personal messages, but does not exist.
Member #620 has received one or more personal messages, but does not exist.
Member #866 has received one or more personal messages, but does not exist.
Member #2262 has received one or more personal messages, but does not exist.
Member #2861 has received one or more personal messages, but does not exist.
Personal message #504 was sent by member #135, who does not exist.
Personal message #505 was sent by member #135, who does not exist.
Personal message #551 was sent by member #584, who does not exist.
Personal message #552 was sent by member #592, who does not exist.
Personal message #553 was sent by member #592, who does not exist.
Personal message #554 was sent by member #592, who does not exist.
Personal message #555 was sent by member #609, who does not exist.
Personal message #951 was sent by member #2262, who does not exist.
Personal message #993 was sent by member #2432, who does not exist.
Personal message #1118 was sent by member #2861, who does not exist.
Personal message #1142 was sent by member #2815, who does not exist.
Notifications have been requested by member #2053, who does not exist.
Notifications have been requested by member #2100, who does not exist.
Poll #1 has been given a vote from member #2 , who is now missing.
Poll #1 has been given a vote from member #16 , who is now missing.
Poll #1 has been given a vote from member #25 , who is now missing.
Poll #1 has been given a vote from member #149 , who is now missing.
Poll #1 has been given a vote from member #331 , who is now missing.
Poll #1 has been given a vote from member #597 , who is now missing.
Poll #1 has been given a vote from member #728 , who is now missing.
Poll #1 has been given a vote from member #736 , who is now missing.
Poll #1 has been given a vote from member #1988 , who is now missing.
Poll #1 has been given a vote from member #2432 , who is now missing.
Poll #1 has been given a vote from member #2815 , who is now missing.

Would you like to fix these errors?
Yes - No

Clicking yes returns:

Code Select

Duplicate entry '0' for key 1
File: /home/sites/houseswapforum.com/public_html/Sources/RepairBoards.php
Line: 1560

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.5, while your database is at version 1.1.4. The above error might possibly go away if you execute the latest version of upgrade.php.

I am really stuck now and would welcome any advice at this stage!

Thanks!

SleePy · May 27, 2008, 04:44:27 PM

No you need to alter it so it can hold a value bigger than 255. Depending on what you want to go at is up to you.
It holds by default a tinyint of 4. So a mediumn int would do better to hold larger numbers for your needs.

As for the length(code) problem see:
Common conversion errors.

limo2005 · May 27, 2008, 05:57:16 PM

Quote from: SleePy on May 27, 2008, 04:44:27 PM
No you need to alter it so it can hold a value bigger than 255. Depending on what you want to go at is up to you.
It holds by default a tinyint of 4. So a mediumn int would do better to hold larger numbers for your needs.

Code Select

SQL query:

ALTER TABLE `smf_categories` CHANGE `ID_CAT` `ID_CAT` BIGINT( 800 ) UNSIGNED NOT NULL AUTO_INCREMENT

MySQL said: Documentation
#1439 - Display width out of range for column 'ID_CAT' (max = 255)

Message recieved when I attempt to set to a larger int (800)

Quote from: SleePy on May 27, 2008, 04:44:27 PM

As for the length(code) problem see:
Common conversion errors.

Already done but error still remains with the cats and boards I'll give it another go in case I have missed something!

Thanks for the prompt response!

Limo2005

SleePy · May 27, 2008, 06:55:38 PM

try a bigint of 4. That should do you plenty.

limo2005 · May 28, 2008, 08:14:56 AM

Quote from: SleePy on May 27, 2008, 06:55:38 PM
try a bigint of 4. That should do you plenty.

Started from scratch. Clean forum and database. Uploaded the IPB forum and db dump (Using BIGDUMP) and confirmed all working ok with the cats in the correct order! http://mysite.com/forum. reset the forum to default values.

Installed SMF 1.1.5 to http://mysite.com on the same server using the same database.

ran CONVERT.PHP (2.3.x) http://mysite.com/convert.php and followed the instructions. Completed with no errors save for the attachments which were not installed due to size and time. All ran succesfully.

Now when I visit the site at http://mysite.com, I still get no categories whatsoever, the boards are there but some show child boards and some dont! The ordering is somewhat random.

So I had an idea that I would try and MOVE the boards but I am unable to as the boards list in Admin panel actually displays the categories (Pic in previous post) but not the boards. So I cannot move what is not there! At this time the database shows the categories as correctly ordered (pic below), but i still have the following problems:

Boards showing in forum with no categories

Admin panel shows categories with no boards.

Database in phpmyadmin show cats in the correct order (pic below)

I can confirm that ID_CAT is set to BIGINT(4).

When I use Forum Maintenance > Find and repair any errors, i get the following errors which I have no idea of resolving:

Code Select

The following errors are fouling up your forum:
Board #7 is in category #255, which is missing.
Board #10 is in category #255, which is missing.
Board #11 is in category #255, which is missing.
Board #12 is in category #255, which is missing.
Board #14 is in category #255, which is missing.
Board #15 is in category #255, which is missing.
Board #16 is in category #255, which is missing.
Board #17 is in category #255, which is missing.
Board #18 is in category #255, which is missing.
Board #40 is in category #255, which is missing.
Board #41 is in category #255, which is missing.
Board #42 is in category #255, which is missing.
Board #43 is in category #255, which is missing.
Board #44 is in category #255, which is missing.
Board #45 is in category #255, which is missing.
Board #46 is in category #255, which is missing.
Board #47 is in category #255, which is missing.
Board #48 is in category #255, which is missing.
Board #49 is in category #255, which is missing.
Board #50 is in category #255, which is missing.
Board #51 is in category #255, which is missing.
Board #56 is in category #255, which is missing.
Board #57 is in category #255, which is missing.
Board #58 is in category #255, which is missing.
Board #59 is in category #255, which is missing.
Board #60 is in category #255, which is missing.
Board #61 is in category #255, which is missing.
Board #63 is in category #255, which is missing.
Board #64 is in category #255, which is missing.
Board #65 is in category #255, which is missing.
Board #66 is in category #255, which is missing.
Board #67 is in category #255, which is missing.
Board #68 is in category #255, which is missing.
Board #69 is in category #255, which is missing.
Board #70 is in category #255, which is missing.
Board #71 is in category #255, which is missing.
Board #72 is in category #255, which is missing.
Board #73 is in category #255, which is missing.
Board #74 is in category #255, which is missing.
Board #75 is in category #255, which is missing.
Board #76 is in category #255, which is missing.
Board #77 is in category #255, which is missing.
Board #78 is in category #255, which is missing.
Board #79 is in category #255, which is missing.
Board #80 is in category #255, which is missing.
Board #81 is in category #255, which is missing.
Board #82 is in category #255, which is missing.
Board #83 is in category #255, which is missing.
Board #84 is in category #255, which is missing.
Board #85 is in category #255, which is missing.
Board #89 is in category #255, which is missing.
Board #90 is in category #255, which is missing.
Board #91 is in category #255, which is missing.
Board #92 is in category #255, which is missing.
Board #102 is in category #255, which is missing.
Board #107 is in category #255, which is missing.
Board #108 is in category #255, which is missing.
Board #109 is in category #255, which is missing.
Board #110 is in category #255, which is missing.
Board #115 is in category #255, which is missing.
Board #116 is in category #255, which is missing.
Board #158 is in category #255, which is missing.
Board #159 is in category #255, which is missing.
Board #162 is in category #255, which is missing.
Board #163 is in category #255, which is missing.
Board #164 is in category #255, which is missing.
Board #165 is in category #255, which is missing.
Board #166 is in category #255, which is missing.
Board #167 is in category #255, which is missing.
Board #168 is in category #255, which is missing.
Board #169 is in category #255, which is missing.
Board #170 is in category #255, which is missing.
Board #171 is in category #255, which is missing.
Board #172 is in category #255, which is missing.
Board #173 is in category #255, which is missing.
Board #174 is in category #255, which is missing.
Board #175 is in category #255, which is missing.
Board #176 is in category #255, which is missing.
Board #177 is in category #255, which is missing.
Board #178 is in category #255, which is missing.
Board #179 is in category #255, which is missing.
Board #180 is in category #255, which is missing.
Board #181 is in category #255, which is missing.
Board #182 is in category #255, which is missing.
Board #183 is in category #255, which is missing.
Board #184 is in category #255, which is missing.
Board #185 is in category #255, which is missing.
Board #186 is in category #255, which is missing.
Board #187 is in category #255, which is missing.
Board #188 is in category #255, which is missing.
Board #189 is in category #255, which is missing.
Board #190 is in category #255, which is missing.
Board #191 is in category #255, which is missing.
Board #192 is in category #255, which is missing.
Board #193 is in category #255, which is missing.
Board #194 is in category #255, which is missing.
Board #195 is in category #255, which is missing.
Board #196 is in category #255, which is missing.
Board #197 is in category #255, which is missing.
Board #198 is in category #255, which is missing.
Board #199 is in category #255, which is missing.
Board #200 is in category #255, which is missing.
Board #201 is in category #255, which is missing.
Board #202 is in category #255, which is missing.
Board #203 is in category #255, which is missing.
Board #204 is in category #255, which is missing.
Board #205 is in category #255, which is missing.
Board #206 is in category #255, which is missing.
Board #207 is in category #255, which is missing.
Board #208 is in category #255, which is missing.
Board #209 is in category #255, which is missing.
Board #210 is in category #255, which is missing.
Board #211 is in category #255, which is missing.
Board #212 is in category #255, which is missing.
Board #213 is in category #255, which is missing.
Board #214 is in category #255, which is missing.
Board #215 is in category #255, which is missing.
Board #216 is in category #255, which is missing.
Board #217 is in category #255, which is missing.
Board #218 is in category #255, which is missing.
Board #219 is in category #255, which is missing.
Board #220 is in category #255, which is missing.
Board #221 is in category #255, which is missing.
Board #222 is in category #255, which is missing.
Board #223 is in category #255, which is missing.
Board #224 is in category #255, which is missing.
Board #225 is in category #255, which is missing.
Board #226 is in category #255, which is missing.
Board #228 is in category #255, which is missing.
Board #230 is in category #255, which is missing.
Board #231 is in category #255, which is missing.
Board #232 is in category #255, which is missing.
Board #233 is in category #255, which is missing.
Board #234 is in category #255, which is missing.
Board #235 is in category #255, which is missing.
Board #236 is in category #255, which is missing.
Board #237 is in category #255, which is missing.
Board #238 is in category #255, which is missing.
Board #239 is in category #255, which is missing.
Board #240 is in category #255, which is missing.
Board #241 is in category #255, which is missing.
Board #242 is in category #255, which is missing.
Board #243 is in category #255, which is missing.
Board #244 is in category #255, which is missing.
Board #245 is in category #255, which is missing.
Board #246 is in category #255, which is missing.
Board #247 is in category #255, which is missing.
Board #248 is in category #255, which is missing.
Board #249 is in category #255, which is missing.
Board #250 is in category #255, which is missing.
Board #251 is in category #255, which is missing.
Board #252 is in category #255, which is missing.
Board #253 is in category #255, which is missing.
Board #254 is in category #255, which is missing.
Board #255 is in category #255, which is missing.
Board #256 is in category #255, which is missing.
Board #257 is in category #255, which is missing.
Board #258 is in category #255, which is missing.
Board #259 is in category #255, which is missing.
Board #260 is in category #255, which is missing.
Board #261 is in category #255, which is missing.
Board #262 is in category #255, which is missing.
Board #263 is in category #255, which is missing.
Board #264 is in category #255, which is missing.
Board #265 is in category #255, which is missing.
Board #266 is in category #255, which is missing.
Board #267 is in category #255, which is missing.
Board #268 is in category #255, which is missing.
Board #269 is in category #255, which is missing.
Board #270 is in category #255, which is missing.
Board #271 is in category #255, which is missing.
Board #272 is in category #255, which is missing.
Board #273 is in category #255, which is missing.
Board #274 is in category #255, which is missing.
Board #275 is in category #255, which is missing.
Board #276 is in category #255, which is missing.
Board #277 is in category #255, which is missing.
Board #278 is in category #255, which is missing.
Board #279 is in category #255, which is missing.
Board #280 is in category #255, which is missing.
Board #281 is in category #255, which is missing.
Board #282 is in category #255, which is missing.
Board #283 is in category #255, which is missing.
Board #284 is in category #255, which is missing.
Board #285 is in category #255, which is missing.
Board #286 is in category #255, which is missing.
Board #287 is in category #255, which is missing.
Board #288 is in category #255, which is missing.
Board #289 is in category #255, which is missing.
Board #290 is in category #255, which is missing.
Board #291 is in category #255, which is missing.
Board #292 is in category #255, which is missing.
Board #293 is in category #255, which is missing.
Board #294 is in category #255, which is missing.
Board #295 is in category #255, which is missing.
Board #296 is in category #255, which is missing.
Board #297 is in category #255, which is missing.
Board #298 is in category #255, which is missing.
Board #299 is in category #255, which is missing.
Board #300 is in category #255, which is missing.
Board #301 is in category #255, which is missing.
Board #302 is in category #255, which is missing.
Board #303 is in category #255, which is missing.
Board #304 is in category #255, which is missing.
Board #305 is in category #255, which is missing.
Board #306 is in category #255, which is missing.
Board #307 is in category #255, which is missing.
Board #308 is in category #255, which is missing.
Board #309 is in category #255, which is missing.
Board #310 is in category #255, which is missing.
Board #311 is in category #255, which is missing.
Board #312 is in category #255, which is missing.
Board #313 is in category #255, which is missing.
Board #314 is in category #255, which is missing.
Board #315 is in category #255, which is missing.
Board #316 is in category #255, which is missing.
Board #317 is in category #255, which is missing.
Board #318 is in category #255, which is missing.
Board #319 is in category #255, which is missing.
Board #320 is in category #255, which is missing.
Board #321 is in category #255, which is missing.
Board #322 is in category #255, which is missing.
Board #323 is in category #255, which is missing.
Board #324 is in category #255, which is missing.
Board #325 is in category #255, which is missing.
Board #326 is in category #255, which is missing.
Board #327 is in category #255, which is missing.
Board #328 is in category #255, which is missing.
Board #329 is in category #255, which is missing.
Board #330 is in category #255, which is missing.
Board #331 is in category #255, which is missing.
Board #332 is in category #255, which is missing.
Board #334 is in category #255, which is missing.
Board #335 is in category #255, which is missing.
Board #336 is in category #255, which is missing.
Board #337 is in category #255, which is missing.
Board #338 is in category #255, which is missing.
Board #339 is in category #255, which is missing.
Board #340 is in category #255, which is missing.
Board #341 is in category #255, which is missing.
Board #342 is in category #255, which is missing.
Board #343 is in category #255, which is missing.
Board #344 is in category #255, which is missing.
Board #345 is in category #255, which is missing.
Board #346 is in category #255, which is missing.
Board #347 is in category #255, which is missing.
Board #349 is in category #255, which is missing.
Board #350 is in category #255, which is missing.
Board #351 is in category #255, which is missing.
Board #352 is in category #255, which is missing.
Board #354 is in category #255, which is missing.
Board #355 is in category #255, which is missing.
Board #356 is in category #255, which is missing.
Board #357 is in category #255, which is missing.
Board #358 is in category #255, which is missing.
Board #359 is in category #255, which is missing.
Board #360 is in category #255, which is missing.
Board #361 is in category #255, which is missing.
Board #362 is in category #255, which is missing.
Board #363 is in category #255, which is missing.
Board #364 is in category #255, which is missing.
Board #365 is in category #255, which is missing.
Board #366 is in category #255, which is missing.
Board #367 is in category #255, which is missing.
Board #368 is in category #255, which is missing.
Board #369 is in category #255, which is missing.
Board #370 is in category #255, which is missing.
Board #371 is in category #255, which is missing.
Board #372 is in category #255, which is missing.
Board #373 is in category #255, which is missing.
Board #374 is in category #255, which is missing.
Board #375 is in category #255, which is missing.
Board #376 is in category #255, which is missing.
Board #377 is in category #255, which is missing.
Board #378 is in category #255, which is missing.
Board #379 is in category #255, which is missing.
Board #380 is in category #255, which is missing.
Board #381 is in category #255, which is missing.
Board #382 is in category #255, which is missing.
Board #383 is in category #255, which is missing.
Board #384 is in category #255, which is missing.
Board #385 is in category #255, which is missing.
Board #386 is in category #255, which is missing.
Board #387 is in category #255, which is missing.
Board #388 is in category #255, which is missing.
Board #389 is in category #255, which is missing.
Board #390 is in category #255, which is missing.
Board #391 is in category #255, which is missing.
Board #392 is in category #255, which is missing.
Board #393 is in category #255, which is missing.
Board #394 is in category #255, which is missing.
Board #395 is in category #255, which is missing.
Board #396 is in category #255, which is missing.
Board #397 is in category #255, which is missing.
Board #398 is in category #255, which is missing.
Board #399 is in category #255, which is missing.
Board #400 is in category #255, which is missing.
Board #401 is in category #255, which is missing.
Board #402 is in category #255, which is missing.
Board #403 is in category #255, which is missing.
Board #404 is in category #255, which is missing.
Board #405 is in category #255, which is missing.
Board #406 is in category #255, which is missing.
Board #407 is in category #255, which is missing.
Board #408 is in category #255, which is missing.
Board #409 is in category #255, which is missing.
Board #410 is in category #255, which is missing.
Board #411 is in category #255, which is missing.
Board #412 is in category #255, which is missing.
Board #413 is in category #255, which is missing.
Board #414 is in category #255, which is missing.
Board #415 is in category #255, which is missing.
Board #416 is in category #255, which is missing.
Board #417 is in category #255, which is missing.
Board #418 is in category #255, which is missing.
Board #419 is in category #255, which is missing.
Board #420 is in category #255, which is missing.
Board #421 is in category #255, which is missing.
Board #422 is in category #255, which is missing.
Board #423 is in category #255, which is missing.
Board #424 is in category #255, which is missing.
Board #425 is in category #255, which is missing.
Board #426 is in category #255, which is missing.
Board #427 is in category #255, which is missing.
Board #428 is in category #255, which is missing.
Board #429 is in category #255, which is missing.
Board #430 is in category #255, which is missing.
Board #431 is in category #255, which is missing.
Board #432 is in category #255, which is missing.
Board #433 is in category #255, which is missing.
Board #434 is in category #255, which is missing.
Board #435 is in category #255, which is missing.
Board #436 is in category #255, which is missing.
Board #437 is in category #255, which is missing.
Board #438 is in category #255, which is missing.
Board #439 is in category #255, which is missing.
Board #440 is in category #255, which is missing.
Board #441 is in category #255, which is missing.
Board #442 is in category #255, which is missing.
Board #443 is in category #255, which is missing.
Board #444 is in category #255, which is missing.
Board #445 is in category #255, which is missing.
Board #446 is in category #255, which is missing.
Board #447 is in category #255, which is missing.
Board #448 is in category #255, which is missing.
Board #449 is in category #255, which is missing.
Board #450 is in category #255, which is missing.
Board #451 is in category #255, which is missing.
Board #452 is in category #255, which is missing.
Board #453 is in category #255, which is missing.
Board #454 is in category #255, which is missing.
Board #455 is in category #255, which is missing.
Board #456 is in category #255, which is missing.
Board #457 is in category #255, which is missing.
Board #458 is in category #255, which is missing.
Board #459 is in category #255, which is missing.
Board #460 is in category #255, which is missing.
Board #461 is in category #255, which is missing.
Board #462 is in category #255, which is missing.
Board #463 is in category #255, which is missing.
Board #464 is in category #255, which is missing.
Board #465 is in category #255, which is missing.
Board #466 is in category #255, which is missing.
Board #467 is in category #255, which is missing.
Board #468 is in category #255, which is missing.
Board #469 is in category #255, which is missing.
Board #470 is in category #255, which is missing.
Board #471 is in category #255, which is missing.
Board #472 is in category #255, which is missing.
Board #473 is in category #255, which is missing.
Board #474 is in category #255, which is missing.
Board #475 is in category #255, which is missing.
Board #476 is in category #255, which is missing.
Board #477 is in category #255, which is missing.
Board #478 is in category #255, which is missing.
Board #479 is in category #255, which is missing.
Board #480 is in category #255, which is missing.
Board #481 is in category #255, which is missing.
Board #482 is in category #255, which is missing.
Board #483 is in category #255, which is missing.
Board #484 is in category #255, which is missing.
Board #485 is in category #255, which is missing.
Board #486 is in category #255, which is missing.
Board #488 is in category #255, which is missing.
Board #489 is in category #255, which is missing.
Board #490 is in category #255, which is missing.
Board #491 is in category #255, which is missing.
Board #492 is in category #255, which is missing.
Board #493 is in category #255, which is missing.
Board #494 is in category #255, which is missing.
Board #495 is in category #255, which is missing.
Board #496 is in category #255, which is missing.
Board #497 is in category #255, which is missing.
Board #498 is in category #255, which is missing.
Board #499 is in category #255, which is missing.
Board #500 is in category #255, which is missing.
Board #501 is in category #255, which is missing.
Board #502 is in category #255, which is missing.
Board #503 is in category #255, which is missing.
Board #504 is in category #255, which is missing.
Board #505 is in category #255, which is missing.
Board #506 is in category #255, which is missing.
Board #507 is in category #255, which is missing.
Board #508 is in category #255, which is missing.
Board #509 is in category #255, which is missing.
Board #510 is in category #255, which is missing.
Board #511 is in category #255, which is missing.
Board #512 is in category #255, which is missing.
Board #513 is in category #255, which is missing.
Board #518 is in category #255, which is missing.
Board #519 is in category #255, which is missing.
Board #520 is in category #255, which is missing.
Board #521 is in category #255, which is missing.
Board #522 is in category #255, which is missing.
Board #523 is in category #255, which is missing.
Board #524 is in category #255, which is missing.
Board #525 is in category #255, which is missing.
Board #526 is in category #255, which is missing.
Board #527 is in category #255, which is missing.
Board #528 is in category #255, which is missing.
Board #529 is in category #255, which is missing.
Board #530 is in category #255, which is missing.
Board #531 is in category #255, which is missing.
Board #532 is in category #255, which is missing.
Board #533 is in category #255, which is missing.
Board #534 is in category #255, which is missing.
Board #535 is in category #255, which is missing.
Board #536 is in category #255, which is missing.
Board #537 is in category #255, which is missing.
Board #538 is in category #255, which is missing.
Board #539 is in category #255, which is missing.
Board #540 is in category #255, which is missing.
Board #541 is in category #255, which is missing.
Board #542 is in category #255, which is missing.
Board #545 is in category #255, which is missing.
Board #546 is in category #255, which is missing.
Board #547 is in category #255, which is missing.
Board #548 is in category #255, which is missing.
Board #549 is in category #255, which is missing.
Board #550 is in category #255, which is missing.
Board #551 is in category #255, which is missing.
Board #552 is in category #255, which is missing.
Board #553 is in category #255, which is missing.
Board #554 is in category #255, which is missing.
Board #555 is in category #255, which is missing.
Board #556 is in category #255, which is missing.
Board #557 is in category #255, which is missing.
Board #558 is in category #255, which is missing.
Board #559 is in category #255, which is missing.
Board #560 is in category #255, which is missing.
Board #561 is in category #255, which is missing.
Board #562 is in category #255, which is missing.
Board #563 is in category #255, which is missing.
Board #564 is in category #255, which is missing.
Board #565 is in category #255, which is missing.
Board #566 is in category #255, which is missing.
Board #567 is in category #255, which is missing.
Board #568 is in category #255, which is missing.
Board #569 is in category #255, which is missing.
Board #570 is in category #255, which is missing.
Board #571 is in category #255, which is missing.
Board #572 is in category #255, which is missing.
Board #573 is in category #255, which is missing.
Board #574 is in category #255, which is missing.
Board #575 is in category #255, which is missing.
Board #576 is in category #255, which is missing.
Board #577 is in category #255, which is missing.
Board #578 is in category #255, which is missing.
Board #579 is in category #255, which is missing.
Board #580 is in category #255, which is missing.
Board #581 is in category #255, which is missing.
Board #582 is in category #255, which is missing.
Board #583 is in category #255, which is missing.
Board #584 is in category #255, which is missing.
Board #586 is in category #255, which is missing.
Board #587 is in category #255, which is missing.
Board #588 is in category #255, which is missing.
Board #589 is in category #255, which is missing.
Board #590 is in category #255, which is missing.
Board #591 is in category #255, which is missing.
Board #592 is in category #255, which is missing.
Board #593 is in category #255, which is missing.
Board #594 is in category #255, which is missing.
Board #595 is in category #255, which is missing.
Board #596 is in category #255, which is missing.
Board #597 is in category #255, which is missing.
Board #598 is in category #255, which is missing.
Board #599 is in category #255, which is missing.
Board #600 is in category #255, which is missing.
Board #601 is in category #255, which is missing.
Board #602 is in category #255, which is missing.
Board #603 is in category #255, which is missing.
Board #604 is in category #255, which is missing.
Board #605 is in category #255, which is missing.
Board #606 is in category #255, which is missing.
Board #607 is in category #255, which is missing.
Board #608 is in category #255, which is missing.
Board #609 is in category #255, which is missing.
Board #610 is in category #255, which is missing.
Board #611 is in category #255, which is missing.
Board #612 is in category #255, which is missing.
Board #613 is in category #255, which is missing.
Board #614 is in category #255, which is missing.
Board #615 is in category #255, which is missing.
Board #618 is in category #255, which is missing.
Board #619 is in category #255, which is missing.
Board #620 is in category #255, which is missing.
Board #621 is in category #255, which is missing.
Board #622 is in category #255, which is missing.
Board #623 is in category #255, which is missing.
Board #624 is in category #255, which is missing.
Board #625 is in category #255, which is missing.
Board #626 is in category #255, which is missing.
Board #627 is in category #255, which is missing.
Board #628 is in category #255, which is missing.
Board #629 is in category #255, which is missing.
Board #630 is in category #255, which is missing.
Board #631 is in category #255, which is missing.
Board #632 is in category #255, which is missing.
Board #633 is in category #255, which is missing.
Board #634 is in category #255, which is missing.
Board #635 is in category #255, which is missing.
Board #636 is in category #255, which is missing.
Board #637 is in category #255, which is missing.
Board #638 is in category #255, which is missing.
Board #639 is in category #255, which is missing.
Board #640 is in category #255, which is missing.
Board #641 is in category #255, which is missing.
Board #642 is in category #255, which is missing.
Board #643 is in category #255, which is missing.
Board #645 is in category #255, which is missing.
Board #646 is in category #255, which is missing.
Board #647 is in category #255, which is missing.
Board #648 is in category #255, which is missing.
Board #649 is in category #255, which is missing.
Board #650 is in category #255, which is missing.
Board #651 is in category #255, which is missing.
Board #653 is in category #255, which is missing.
Board #654 is in category #255, which is missing.
Board #655 is in category #255, which is missing.
Board #656 is in category #255, which is missing.
Board #657 is in category #255, which is missing.
Board #658 is in category #255, which is missing.
Board #659 is in category #255, which is missing.
Board #660 is in category #255, which is missing.
Board #661 is in category #255, which is missing.
Board #662 is in category #255, which is missing.
Board #663 is in category #255, which is missing.
Board #664 is in category #255, which is missing.
Board #666 is in category #255, which is missing.
Board #667 is in category #255, which is missing.
Board #668 is in category #255, which is missing.
Board #669 is in category #255, which is missing.
Board #670 is in category #255, which is missing.
Board #671 is in category #255, which is missing.
Board #673 is in category #255, which is missing.
Board #674 is in category #255, which is missing.
Board #675 is in category #255, which is missing.
Board #676 is in category #255, which is missing.
Board #677 is in category #255, which is missing.
Board #678 is in category #255, which is missing.
Board #680 is in category #255, which is missing.
Board #681 is in category #255, which is missing.
Board #682 is in category #255, which is missing.
Board #683 is in category #255, which is missing.
Board #684 is in category #255, which is missing.
Board #686 is in category #255, which is missing.
Board #687 is in category #255, which is missing.
Board #688 is in category #255, which is missing.
Board #689 is in category #255, which is missing.
Board #690 is in category #255, which is missing.
Board #691 is in category #255, which is missing.
Board #692 is in category #255, which is missing.
Board #693 is in category #255, which is missing.
Board #694 is in category #255, which is missing.
Board #695 is in category #255, which is missing.
Board #697 is in category #255, which is missing.
Board #700 is in category #255, which is missing.
Board #701 is in category #255, which is missing.
Board #703 is in category #255, which is missing.
Board #738 is in category #255, which is missing.
Board #769 is in category #255, which is missing.
Board #770 is in category #255, which is missing.
Board #771 is in category #255, which is missing.
Board #773 is in category #255, which is missing.
Board #775 is in category #255, which is missing.
Board #776 is in category #255, which is missing.
Board #777 is in category #255, which is missing.
Board #780 is in category #255, which is missing.
Board #783 is in category #255, which is missing.
Board #784 is in category #255, which is missing.
Board #785 is in category #255, which is missing.
Board #786 is in category #255, which is missing.
Board #787 is in category #255, which is missing.
Board #788 is in category #255, which is missing.

Would you like to fix these errors?
Yes - No

limo2005 · May 28, 2008, 08:53:34 AM

I RESOLVED this issue by changing the value TINYINT(4) to BIGINT(4) as suggested But did this in SMF_BOARDS.

Result! Boards with categories loaded without issues and I am a very happy happy man!

Thanks for the heads up!

Limo2005

SleePy · May 28, 2008, 12:32:35 PM

Ah yes, forgot about that one

I believe that there is a few other columns that hold a ID_CAT as well.
I don't get why some boards think having such a high cat id is good, its wasted space :|

limo2005 · June 01, 2008, 08:25:37 PM

The only other issue I had was that I ended up with 41 Forum Moderators, When I only have two global Moderators.

Is there a way I can reset / mass prune them as they do not seem to appear in the Listings for forum Moderator?

SleePy · June 01, 2008, 11:52:13 PM

Well if they are global moderators just go to
Admin -> Member groups
Click on the member group name.
Then check the boxes next to their name
Finally at the bottom click the Remove from group button

limo2005 · June 03, 2008, 09:19:04 AM

Thank you!

The Problem I am faced with is the the Moderator Group is unclickable and I am therefore unable to proceed further.

The Global Moderators are fine and your suggestion works a treat. But I am still looking for a way to Remove 40 Moderators from the group as they were not moderators initially and the conversion created them!

So any ideas how I could do this?

Thanking you in Advance!

Limo2005

SleePy · June 03, 2008, 11:52:57 AM

Are you using a custom theme?

I am sure that the global moderator group should be clickable.
The regular moderator group should not.

You could try this for the file name and such for your forum and see if it will direct you to edit the global moderator group.
index.php?action=membergroups;sa=members;group=2

limo2005 · June 04, 2008, 02:21:07 AM

Quote from: limo2005 on June 03, 2008, 09:19:04 AM
The Global Moderators are fine and your suggestion works a treat. But I am still looking for a way to Remove 40 Moderators from the group as they were not moderators initially and the conversion created them!

I am refering to the Moderators Group! Not the Global Moderators Group. As you can see from the Image! I have 39 Moderators who should not be so I would like to remove them from the Moderator Group which is unclickable.

The Global Moderator group is fully accessible but I don't have any problems there!

Thanks again!

Limo2005

SleePy · June 04, 2008, 12:02:54 PM

Ok that is odd.

I am hoping most of them have the moderators group as their primary group.
So doing this in phpMyAdmin should fix it

Code Select

UPDATE smf_members
SET ID_GROUP = 0
WHERE ID_GROUP = 3

If that doesn't remove all of them then they have it as additional and thats going to be a little trickier.

limo2005 · June 16, 2008, 01:45:00 PM

I think I tried this correctly as I have done similiar before to reset the Pm's and in this case it did not resolve the Members becoming Moderators during the conversion!

SleePy · June 16, 2008, 02:17:39 PM

The conversion script should be preventing them from getting becoming moderators.

IE:

QuoteIF(m.mgroup = {$INFO['admin_group']}, 1, IF(m.mgroup = 3, 0, IF(m.mgroup > 5, m.mgroup + 3, 0))) AS ID_GROUP,

That is the code that converts the groups over to SMF. If they are in the admin group, they are put in group 1 (for smf). If they are in group 3 from ipb, they are set with no group, if they have a group higher than 5, they are put in that group but with 3 added to the id number (to get around SMFs default groups).

The only thing I can think of is, do you have a group on ipb that has an id of 0?

limo2005 · June 18, 2008, 02:50:27 PM

I believe I do have a Group "0"

I have fixed the issue of Members being converted to Forum Moderators by doing the following:

Deleting members accounts that have not been active on the site for two years from the Forum Moderators Group.

By changing the remaining "Converted Forum Moderators" via their profiles in "Account Related Settings" from "no primary membergroup" to another "membergroup", saving profile and then changed them back to "no primary membergroup", and again saving the profile, resulted in the member being removed from the "Forum Moderator" Group.

These two actions, for my purposes, have resolved my issue and I have no idea why it worked!

Limo

SleePy · June 18, 2008, 03:33:52 PM

Well its invalid for a member to be in group 3. So thats why they where removed after you saved the profile.

It was that group 0 that was causing it. Though it should of only done it for groups above 5. So I am a bit lost why it did that :| Could be the alternate groups that was the issue though.

limo2005 · June 18, 2008, 03:51:18 PM

Quote from: SleePy on June 18, 2008, 03:33:52 PM
Well its invalid for a member to be in group 3. So thats why they where removed after you saved the profile.

It was that group 0 that was causing it. Though it should of only done it for groups above 5. So I am a bit lost why it did that :| Could be the alternate groups that was the issue though.

Does seem odd though!

. I have "Promoted" a member to forum Moderator and all seems to be well!

PAPABEAR · July 03, 2008, 12:27:06 PM

Sleepy, do you offer your services for conversions?

SleePy · July 03, 2008, 12:58:22 PM

I can try and help you with the conversion process. We have documentation on our docs site, and posts here that may help you along in the conversion.

If you are looking to hire, we have a help wanted board where you can request somebody. If you go this route, please check the history of the person who is willing to help you.

PAPABEAR · July 11, 2008, 10:36:38 AM

Thanks man.

News:

convert Ipb 2.3.4 to SMF