Help, Error Converting IPB2 to SMF 1.1 RC3

[InvisibleMan78]

Ranks - Not sure why those aren't converted. What are the IDs of these groups? Are they stored in the groups table in IPB as well?

I think, it's saved in the table ibf_titles

Code Select Expand

+----+--------+-------+--------+
| id | posts  | title | pips   |
+----+--------+-------+--------+
|  1 |      0 | Rank1 | 1      |
|  2 |     10 | Rank2 | 2      |
|  4 |     30 | Rank3 | 3      |
|  5 |     50 | Rank4 | 4      |
|  6 |    100 | Rank5 | 5      |
|  7 |    150 | Rank6 | 6      |
|  8 |    200 | Rank7 | 7      |
|  9 |    250 | Rank8 | 8      |
| 10 |    300 | Rank9 | 9      |
+----+--------+-------+--------+

Icons - Admin -> Smileys and Smiley Sets, check the box next to "Enable custom smileys" and save the changes. Do they show up after that?

Unfortunately no: There are still two types of icons not displayed correctly: One type is the not translated one like :icon_exclaim: - the other one are "missing" *.gif. They are represented by the common white square with the red x on it.

Permissions/Board access - What permission in IPB controls board access?

I'm not sure about! There is a table called 'ibf_forum_perms'

Code Select Expand

+---------+---------------------------+
| perm_id | perm_name                 |
+---------+---------------------------+
|       1 | Validating Forum Mask     |
|       3 | Member Forum Mask         |
|       2 | Guest Forum Mask          |
|       4 | Admin Forum Mask          |
|       5 | Banned Forum Mask         |
|       6 | Spezial Member Forum Mask |
+---------+---------------------------+and there is another one called 'ibf_groups' with a field "g_view_board". I assume, that the perm_id "2" (Guest Forum Mask) in combination with "g_view_board" could be the access-right for viewing the board (as member of the group "guest"). But again: I'm not sure!

Thanks for the feedback.

You're welcome! Just let me know, If I can do some more tests - I will do "everything" to leave Matt's IBP behind me (I hate liars who just run for money! )

BTW:

Code Select Expand

UPDATE smf_members SET labels='-1'; doesn't work, because there is no field 'labels' in the table smf_members. If I change it to most similar 'messageLabels' it doesn't really help for the correct entry. I just see '-1' before (10) in my PM's.

[Oldiesmann]

Sorry. Wrong table.

Run these queries to fix the labels:

Code Select Expand

UPDATE smf_members SET messageLabels='';
UPDATE smf_pm_recipients SET label='-1';

Did you make sure all of your IPB emoticons are in the Smileys/default directory in SMF? That should fix most of the ones that are displaying the "missing image" thing in IE. I'll take a look at the code again and see if I can figure out what's going on.

I'll also work on making it convert ranks.

I'll be glad when we get an IPB 2.1 converter that works for everyone. It seems that whenever we fix it for one person, we break it for several others...

[devicenull]

Everything seems to have converted well.

SMTP was not configured correctly, I had to do that via the DB.

It forces everyone to reset their password, not a big deal though.

The only problem I still have is the polls were not converted correctly.  They don't have the questions or responses.

[InvisibleMan78]

@devicenull:
You mean: You don't have a single of my listed "problems"? You have thumbnails for attached pictures? You have all the avatars, ranks, icons, labels, PM's perfectly converted and without manually work?
The polls are the only thing?

@Oldiesmann:
Little typo with a missing 's' on 'label' on your second code-line

Code Select Expand

UPDATE smf_pm_recipients SET labels='-1';
Now: I can see all my PM's - but they are ALL in the Inbox (the sent-PM's as well).

I will try to convert my IBP from scratch again, maybe I have made to much changes manually...

[devicenull]

@devicenull:
You mean: You don't have a single of my listed "problems"? You have thumbnails for attached pictures? You have all the avatars, ranks, icons, labels, PM's perfectly converted and without manually work?
The polls are the only thing?

Thumbmails, nope.. don't care that much though.
Avatars, yes
Ranks, didn't have custom ones in IPB, so it really doesn't matter
Labels, I'm assuming you mean cusom titles for users.. No.
PM's, as far as I can tell.

The only extra thing I had to do was run the SM forum repair feature.  Which is a perfectly reasonable thing to do.

[Oldiesmann]

Everything seems to have converted well.

SMTP was not configured correctly, I had to do that via the DB.

It forces everyone to reset their password, not a big deal though.

The only problem I still have is the polls were not converted correctly.  They don't have the questions or responses.

Unless IPB has changed the way they hash passwords, your users should just get a message saying "Password security has been upgraded, please re-enter your password" the first time they login, and should be able to login after re-entering their password. SMF does check for IPB's method of password hashing.

I will look into the other problems when I have time. It's hard to make a converter that will work for everyone.

[devicenull]

Nope, everyone is having to go through the password recovery.. but it seems to recognize when they put in a valid password, then prompts them to recover the password.  I actually prefer it this way, as it ensures everyones email is valid.

I'm happy with what was converted, with the exception of polls.  Though I'm not worried about those enough to reconvert.  (We had people start posting to the converted forums, so it would be a pain)

[Rövarn]

On my board all members' passwords work direct without password recovery, only issue is the thumbnails witch don't convert. I am using this fixed converter found in this thread: http://www.simplemachines.org/community/index.php?topic=118829.msg770500#msg770500. I can see in the db how it should be done, but I don't have the knowledge to do a converter. Is there any better converter I have missed?

[Oldiesmann]

Send me a database dump of your IPB attachments table and I'll see what I can do about making it convert thumbnails.

[InvisibleMan78]

How exactly do we have to make that? Could you please give us some instructions?

[Oldiesmann]

Login to phpMyAdmin
Select the database that IPB is installed on
Click on the table name in the navigation frame
Click "Export" in the main window
Follow the instructions.
When you have the backup, you can either post it on the web someplace or email it to me (doesn't matter).

[Mickerovare]

I will... have some trouble with my computer now.. had to do an "format c:"  ... (nope, no xxx-sites  )

Again I have problem with login to this site, created a new member...

How much do you need, only the attachment-table or the whole IPB tables?

Mickerovare/Rövarn

[Oldiesmann]

Just the attachments table.

[InvisibleMan78]

Code Select Expand

'attach_id','attach_ext','attach_file','attach_location','attach_thumb_location','attach_thumb_width','attach_thumb_height','attach_is_image','attach_hits','attach_date','attach_temp','attach_pid','attach_post_key','attach_msg','attach_member_id','attach_approved','attach_filesize'
'1','jpg','06120019.JPG','post-3-1151839957.jpg','post-3-1151839957.jpg','128','96','1','2','1151839957','0','2104','e640add97ecfd9c5870a2e9c31dc7e18','0','3','1','1304813'
'2','jpg','06120020.JPG','post-3-1151839964.jpg','post-3-1151839964.jpg','128','96','1','2','1151839964','0','2104','e640add97ecfd9c5870a2e9c31dc7e18','0','3','1','1186693'
'3','jpg','Petra.jpg','post-2-1158868906.jpg','post-2-1158868906.jpg','87','128','1','3','1158868906','0','2116','a1ee026c643a179e23ffd1cbe8fd58cf','0','2','1','48728'
'4','jpg','Cadiz.jpg','post-2-1158868927.jpg','post-2-1158868927.jpg','128','128','1','7','1158868927','0','2116','a1ee026c643a179e23ffd1cbe8fd58cf','0','2','1','22705'
'5','jpg','Lyon.jpg','post-2-1158868955.jpg','post-2-1158868955.jpg','85','128','1','6','1158868955','0','2116','a1ee026c643a179e23ffd1cbe8fd58cf','0','2','1','23382'
'6','jpg','Krakau.jpg','post-2-1158868972.jpg','post-2-1158868972.jpg','85','128','1','3','1158868972','0','2116','a1ee026c643a179e23ffd1cbe8fd58cf','0','2','1','38811'
'7','jpg','Riga.jpg','post-2-1158868983.jpg','post-2-1158868983.jpg','128','101','1','3','1158868983','0','2116','a1ee026c643a179e23ffd1cbe8fd58cf','0','2','1','31445'
'8','jpg','Bilbao.JPG','post-2-1158869226.jpg','post-2-1158869226.jpg','128','54','1','5','1158869226','0','2116','a1ee026c643a179e23ffd1cbe8fd58cf','0','2','1','15953'
'9','jpg','Malmö_Cadiz.JPG','post-3-1159289796.jpg','post-3-1159289796.jpg','128','96','1','6','1159289796','0','2119','65faf967d9f1b45b865451b9566f278e','0','3','1','102619'
'10','jpg','Lyon.JPG','post-3-1159547315.jpg','post-3-1159547315.jpg','128','83','1','5','1159547315','0','2122','b55c7a7ab3d7802f431dd8ad28221114','0','3','1','83712'
'11','jpg','Europa.JPG','post-3-1159547329.jpg','post-3-1159547329.jpg','128','119','1','6','1159547329','0','2122','b55c7a7ab3d7802f431dd8ad28221114','0','3','1','116172'

HTH

[Mickerovare]

HTH

What version of invision do you have? I can see a different in your dump compared to my dump! The thumbs in my forum are named *_thumb.jpg

Code Select Expand

INSERT INTO `ibf_attachments` (`attach_id`, `attach_ext`, `attach_file`, `attach_location`, `attach_thumb_location`, `attach_thumb_width`, `attach_thumb_height`, `attach_is_image`, `attach_hits`, `attach_date`, `attach_temp`, `attach_pid`, `attach_post_key`, `attach_msg`, `attach_member_id`, `attach_approved`, `attach_filesize`) VALUES (26, 'jpg', 'b_tbilder_441.jpg', 'post-28-1139860127.jpg', 'post-28-1139860127_thumb.jpg', 70, 53, 1, 9, 1139860127, 0, 304, '723736ea657a5530a6be10bec329b837', 0, 28, 1, 45522),
(25, 'jpg', 'guldmedalj.jpg', 'post-9-1139770550.jpg', 'post-9-1139770550_thumb.jpg', 43, 70, 1, 34, 1139770550, 0, 292, 'eff60ea8c2574c6ac3c2a3390f7fceba', 0, 9, 1, 1844),
(24, 'jpg', 'DSC00001.JPG', 'post-2-1139605378.jpg', 'post-2-1139605378_thumb.jpg', 70, 53, 1, 35, 1139605378, 0, 264, '4b1840966f30f6abc6e263c299ffbfed', 0, 2, 1, 588558),
(23, 'jpg', 'drickinte.jpg', 'post-9-1139585979.jpg', 'post-9-1139585979_thumb.jpg', 70, 66, 1, 57, 1139585979, 0, 261, 'af6b04cffa10201a5e53807ed1e2796a', 0, 9, 1, 28631),




Code Select Expand

# phpMyAdmin SQL Dump
# version 2.5.7-pl1
# http://www.phpmyadmin.net
#
# Värd: localhost
# Skapad: 03 november 2006 kl 22:25
# Serverversion: 4.0.24
# PHP-version: 4.4.4
#
# Databas : `semestergardero`
#

# --------------------------------------------------------

#
# Struktur för tabell `ibf_attachments`
#

CREATE TABLE `ibf_attachments` (
  `attach_id` int(10) NOT NULL auto_increment,
  `attach_ext` varchar(10) NOT NULL default '',
  `attach_file` varchar(250) NOT NULL default '',
  `attach_location` varchar(250) NOT NULL default '',
  `attach_thumb_location` varchar(250) NOT NULL default '',
  `attach_thumb_width` smallint(5) NOT NULL default '0',
  `attach_thumb_height` smallint(5) NOT NULL default '0',
  `attach_is_image` tinyint(1) NOT NULL default '0',
  `attach_hits` int(10) NOT NULL default '0',
  `attach_date` int(10) NOT NULL default '0',
  `attach_temp` tinyint(1) NOT NULL default '0',
  `attach_pid` int(10) NOT NULL default '0',
  `attach_post_key` varchar(32) NOT NULL default '0',
  `attach_msg` int(10) NOT NULL default '0',
  `attach_member_id` mediumint(8) NOT NULL default '0',
  `attach_approved` int(10) NOT NULL default '1',
  `attach_filesize` int(10) NOT NULL default '0',
  PRIMARY KEY  (`attach_id`),
  KEY `attach_pid` (`attach_pid`),
  KEY `attach_msg` (`attach_msg`),
  KEY `attach_post_key` (`attach_post_key`),
  KEY `attach_mid_size` (`attach_member_id`,`attach_filesize`)
) TYPE=MyISAM AUTO_INCREMENT=827 ;

#
# Data i tabell `ibf_attachments`
#

INSERT INTO `ibf_attachments` VALUES (26, 'jpg', 'b_tbilder_441.jpg', 'post-28-1139860127.jpg', 'post-28-1139860127_thumb.jpg', 70, 53, 1, 9, 1139860127, 0, 304, '723736ea657a5530a6be10bec329b837', 0, 28, 1, 45522);
INSERT INTO `ibf_attachments` VALUES (25, 'jpg', 'guldmedalj.jpg', 'post-9-1139770550.jpg', 'post-9-1139770550_thumb.jpg', 43, 70, 1, 34, 1139770550, 0, 292, 'eff60ea8c2574c6ac3c2a3390f7fceba', 0, 9, 1, 1844);
INSERT INTO `ibf_attachments` VALUES (24, 'jpg', 'DSC00001.JPG', 'post-2-1139605378.jpg', 'post-2-1139605378_thumb.jpg', 70, 53, 1, 35, 1139605378, 0, 264, '4b1840966f30f6abc6e263c299ffbfed', 0, 2, 1, 588558);

...down to line 742


[Oldiesmann]

Code Select Expand

'attach_id','attach_ext','attach_file','attach_location','attach_thumb_location','attach_thumb_width','attach_thumb_height','attach_is_image','attach_hits','attach_date','attach_temp','attach_pid','attach_post_key','attach_msg','attach_member_id','attach_approved','attach_filesize'
'1','jpg','06120019.JPG','post-3-1151839957.jpg','post-3-1151839957.jpg','128','96','1','2','1151839957','0','2104','e640add97ecfd9c5870a2e9c31dc7e18','0','3','1','1304813'
'2','jpg','06120020.JPG','post-3-1151839964.jpg','post-3-1151839964.jpg','128','96','1','2','1151839964','0','2104','e640add97ecfd9c5870a2e9c31dc7e18','0','3','1','1186693'
'3','jpg','Petra.jpg','post-2-1158868906.jpg','post-2-1158868906.jpg','87','128','1','3','1158868906','0','2116','a1ee026c643a179e23ffd1cbe8fd58cf','0','2','1','48728'
'4','jpg','Cadiz.jpg','post-2-1158868927.jpg','post-2-1158868927.jpg','128','128','1','7','1158868927','0','2116','a1ee026c643a179e23ffd1cbe8fd58cf','0','2','1','22705'
'5','jpg','Lyon.jpg','post-2-1158868955.jpg','post-2-1158868955.jpg','85','128','1','6','1158868955','0','2116','a1ee026c643a179e23ffd1cbe8fd58cf','0','2','1','23382'
'6','jpg','Krakau.jpg','post-2-1158868972.jpg','post-2-1158868972.jpg','85','128','1','3','1158868972','0','2116','a1ee026c643a179e23ffd1cbe8fd58cf','0','2','1','38811'
'7','jpg','Riga.jpg','post-2-1158868983.jpg','post-2-1158868983.jpg','128','101','1','3','1158868983','0','2116','a1ee026c643a179e23ffd1cbe8fd58cf','0','2','1','31445'
'8','jpg','Bilbao.JPG','post-2-1158869226.jpg','post-2-1158869226.jpg','128','54','1','5','1158869226','0','2116','a1ee026c643a179e23ffd1cbe8fd58cf','0','2','1','15953'
'9','jpg','Malmö_Cadiz.JPG','post-3-1159289796.jpg','post-3-1159289796.jpg','128','96','1','6','1159289796','0','2119','65faf967d9f1b45b865451b9566f278e','0','3','1','102619'
'10','jpg','Lyon.JPG','post-3-1159547315.jpg','post-3-1159547315.jpg','128','83','1','5','1159547315','0','2122','b55c7a7ab3d7802f431dd8ad28221114','0','3','1','83712'
'11','jpg','Europa.JPG','post-3-1159547329.jpg','post-3-1159547329.jpg','128','119','1','6','1159547329','0','2122','b55c7a7ab3d7802f431dd8ad28221114','0','3','1','116172'

HTH

Do those attachments even have thumbnails? The "attach_thumb_location" is the same as the "attach_location" in every one of those lines...

I'll take a look at this soon and see what I can do to have it convert thumbnails for those images that have them.

[Mickerovare]

Thank you! 

[InvisibleMan78]

What version of invision do you have? I can see a different in your dump compared to my dump! The thumbs in my forum are named *_thumb.jpg

Invision Power Board(Trial) v2.0.0

Code Select Expand

CREATE TABLE `ibf_attachments` (
  `attach_id` int(10) NOT NULL auto_increment,
  `attach_ext` varchar(10) NOT NULL default '',
  `attach_file` varchar(250) NOT NULL default '',
  `attach_location` varchar(250) NOT NULL default '',
  `attach_thumb_location` varchar(250) NOT NULL default '',
  `attach_thumb_width` smallint(5) NOT NULL default '0',
  `attach_thumb_height` smallint(5) NOT NULL default '0',
  `attach_is_image` tinyint(1) NOT NULL default '0',
  `attach_hits` int(10) NOT NULL default '0',
  `attach_date` int(10) NOT NULL default '0',
  `attach_temp` tinyint(1) NOT NULL default '0',
  `attach_pid` int(10) NOT NULL default '0',
  `attach_post_key` varchar(32) NOT NULL default '0',
  `attach_msg` int(10) NOT NULL default '0',
  `attach_member_id` mediumint(8) NOT NULL default '0',
  `attach_approved` int(10) NOT NULL default '1',
  `attach_filesize` int(10) NOT NULL default '0',
  PRIMARY KEY  (`attach_id`),
  KEY `attach_pid` (`attach_pid`),
  KEY `attach_msg` (`attach_msg`),
  KEY `attach_post_key` (`attach_post_key`),
  KEY `attach_mid_size` (`attach_member_id`,`attach_filesize`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;