Hey,
I saw a solution to this for 1.3.1ipb, but I use 2.
It gets through most of the converting except for
QuoteConverting poll options... Unsuccessful!
This query:
INSERT INTO `dynamic1_SMF2`.smf_poll_choices
(ID_POLL, ID_CHOICE, label, votes)
VALUES (3, SUBSTRING('0', 1, 255), 'Hell yes, he had the 'hood going crazy!', 1, 255), '0'),
(3, SUBSTRING('1', 1, 255), 'Naw son, it's just a thread.', 1, 255), '1'),
(3, SUBSTRING('2', 1, 255), 'Cheesecake?', 1, 255), '5'),
(3, SUBSTRING('3', 1, 255), 'Reaganomics!', 1, 255), '0'),
(3, SUBSTRING('4', 1, 255), '06/6/2006 was a good day for mah.', 1, 255), '0'),
(3, SUBSTRING('5', 1, 255), '*SPEC* should be changed to *GOVENATOR*', 1, 255), '2'),
(9, SUBSTRING('0', 1, 255), 'yes', 1, 255), '7'),
(9, SUBSTRING('1', 1, 255), 'no', 1, 255), '4');
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 ''0'),
(3, SUBSTRING('1', 1, 255), 'Naw son, it's just a thread.', 1,' at line 3
Could anyone please help?
Also when I go to the converted forum, none of the forums or posts are there.
Try this one.
EDIT: Removed attachment. Read on for a working converter...
I got
QuoteFatal error: Call to undefined function: addslashes__recursive() in /home/dynamic1/public_html/forum2/convert.php(814) : eval()'d code on line 7
Whoops! One too many underscores there :)
EDIT: Removed another buggy converter. Keep reading...
QuoteNotice: Undefined index: 3 in /home/dynamic1/public_html/forum2/convert.php(814) : eval()'d code on line 8
Notice: Undefined index: 3 in /home/dynamic1/public_html/forum2/convert.php(814) : eval()'d code on line 8
Notice: Undefined index: 3 in /home/dynamic1/public_html/forum2/convert.php(814) : eval()'d code on line 8
Notice: Undefined index: 3 in /home/dynamic1/public_html/forum2/convert.php(814) : eval()'d code on line 8
Notice: Undefined index: 3 in /home/dynamic1/public_html/forum2/convert.php(814) : eval()'d code on line 8
Notice: Undefined index: 3 in /home/dynamic1/public_html/forum2/convert.php(814) : eval()'d code on line 8
Notice: Undefined index: 3 in /home/dynamic1/public_html/forum2/convert.php(814) : eval()'d code on line 8
Notice: Undefined index: 3 in /home/dynamic1/public_html/forum2/convert.php(814) : eval()'d code on line 8
Unsuccessful!
This query:
INSERT INTO `dynamic1_SMF2`.smf_poll_choices
(ID_POLL, ID_CHOICE, label, votes)
VALUES (3, 0, SUBSTRING('Hell yes, he had the 'hood going crazy!', 1, 255), )),
(3, 1, SUBSTRING('Naw son, it's just a thread.', 1, 255), )),
(3, 2, SUBSTRING('Cheesecake?', 1, 255), )),
(3, 3, SUBSTRING('Reaganomics!', 1, 255), )),
(3, 4, SUBSTRING('06/6/2006 was a good day for mah.', 1, 255), )),
(3, 5, SUBSTRING('*SPEC* should be changed to *GOVENATOR*', 1, 255), )),
(9, 0, SUBSTRING('yes', 1, 255), )),
(9, 1, SUBSTRING('no', 1, 255), ));
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 ')),
(3, 1, SUBSTRING('Naw son, it's just a thread.', 1, 255), )),
' at line 3
Whoops! Another typo. I had $choice[3] instead of $choice[2]...
I'm getting the same error... about the polls thing.
Make sure you overwrote the sql file on your server with the one in your package. There are definitely three items in that array, so $choice[2] should be defined.
Re uploaded it,
still got
QuoteConverting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Unsuccessful!
This query:
INSERT INTO `dynamic1_SMF2`.smf_poll_choices
(ID_POLL, ID_CHOICE, label, votes)
VALUES (3, 0, SUBSTRING('Hell yes, he had the 'hood going crazy!', 1, 255), 0)),
(3, 1, SUBSTRING('Naw son, it's just a thread.', 1, 255), 1)),
(3, 2, SUBSTRING('Cheesecake?', 1, 255), 5)),
(3, 3, SUBSTRING('Reaganomics!', 1, 255), 0)),
(3, 4, SUBSTRING('06/6/2006 was a good day for mah.', 1, 255), 0)),
(3, 5, SUBSTRING('*SPEC* should be changed to *GOVENATOR*', 1, 255), 2)),
(9, 0, SUBSTRING('yes', 1, 255), 7)),
(9, 1, SUBSTRING('no', 1, 255), 4));
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 '),
(3, 1, SUBSTRING('Naw son, it's just a thread.', 1, 255), 1)),
' at line 3
Ah. This time it's an extra ")"... Sorry about that :)
QuoteNotice: Undefined index: 3 in /home/dynamic1/public_html/forum2/convert.php(814) : eval()'d code on line 8
Notice: Undefined index: 3 in /home/dynamic1/public_html/forum2/convert.php(814) : eval()'d code on line 8
Notice: Undefined index: 3 in /home/dynamic1/public_html/forum2/convert.php(814) : eval()'d code on line 8
Notice: Undefined index: 3 in /home/dynamic1/public_html/forum2/convert.php(814) : eval()'d code on line 8
Notice: Undefined index: 3 in /home/dynamic1/public_html/forum2/convert.php(814) : eval()'d code on line 8
Notice: Undefined index: 3 in /home/dynamic1/public_html/forum2/convert.php(814) : eval()'d code on line 8
Notice: Undefined index: 3 in /home/dynamic1/public_html/forum2/convert.php(814) : eval()'d code on line 8
Notice: Undefined index: 3 in /home/dynamic1/public_html/forum2/convert.php(814) : eval()'d code on line 8
Unsuccessful!
This query:
INSERT INTO `dynamic1_SMF2`.smf_poll_choices
(ID_POLL, ID_CHOICE, label, votes)
VALUES (3, 0, SUBSTRING('Hell yes, he had the 'hood going crazy!', 1, 255), )),
(3, 1, SUBSTRING('Naw son, it's just a thread.', 1, 255), )),
(3, 2, SUBSTRING('Cheesecake?', 1, 255), )),
(3, 3, SUBSTRING('Reaganomics!', 1, 255), )),
(3, 4, SUBSTRING('06/6/2006 was a good day for mah.', 1, 255), )),
(3, 5, SUBSTRING('*SPEC* should be changed to *GOVENATOR*', 1, 255), )),
(9, 0, SUBSTRING('yes', 1, 255), )),
(9, 1, SUBSTRING('no', 1, 255), ));
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 ')),
(3, 1, SUBSTRING('Naw son, it's just a thread.', 1, 255), )),
' at line 3
Sorry about that. Somehow I attached the wrong package. This one should work.
Awesome! It works.
All my thanks go to you.
I think you should update your converter page so they download the right one.
Hi Oldiesman,Having yet another try at converting from ipb 2.13 to smf i.i rc3 but am getting this error
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Successful.
Converting board permissions...
Notice: unserialize(): Error at offset 5 of 160 bytes in /home/arnold/public_html/arnoldorg/smf/convert.php(653) : eval()'d code on line 89
Fatal error: Unsupported operand types in /home/arnold/public_html/arnoldorg/smf/convert.php(653) : eval()'d code on line 89
Cheers
Dave
Try this copy of invision2_to_smf.sql - slashes weren't getting stripped before unserialize() was called there, which is what was causing the error.
I have a similar problem like daveb47 (but on a win2k3-server with IIS), running your latest version of 'invision2_to_smf.sql'. The following error appears:
QuoteConverting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options...
Parse error: parse error in c:\Inetpub\wwwroot\smf\convert.php(814) : eval()'d code on line 10
Unsuccessful!
This query:
INSERT INTO `smf`.smf_poll_choices
(ID_POLL, choices)
VALUES ('1', 'a:3:{i:0;a:3:{i:0;i:0;i:1;s:59:\"Ja, mich stören "gestern", "heute" etc.\";i:2;i:3;}i:1;a:3:{i:0;i:1;i:1;s:42:\"Nein, ich finde die relativen Datümer cool\";i:2;i:2;}i:2;a:3:{i:0;i:2;i:1;s:13:\"Mir doch egal\";i:2;i:0;}}');
Caused the error:
Unknown column 'choices' in 'field list'
Thank you for your help in advance!!
Since the polls are not that important for my test-installation, I changed the the latest *.sql-script on line 227 to:
SELECT pid AS ID_POLL, 'ID_POLL', 'ID_CHOICE', 'label', 'votes'I have no idea why, but now the convert-process runs - until the final message about "recalculating counters". This will never end (I stopped it manually after more then 45 minutes).
Some more problems about this convert-process:
- The passwords for the existing users from IBP doesn't work! After a fresh install of SMF, the admin-account works perfect.
But the convert-process overwrite the password for the admin - unfortunately not with the same password as in the source (IBP). This is also true for all the other users - no one can login with the same password as in the original board. Is this "by design"?
- The attachments are all converted and saved on the right place with the right message. Unfortunately, there are no thumbnails for this attachments. If I add a new post with a picture, everything works fine. But the converted one doesn't have a thumbnail. Is it possible to generate them too?
- The avatars are not converted correctly. The picture-link points to /smf/avatars/Smiley_Avatars/smiley-punched.gif - but there is no subdirectory called "Smiley_Avatars" (only "Actors" and "Musicians").
- The ranking-names are not converted.
- Not all the icons are converted. Some of them like "smiley.gif", "wink.gif" or "cheesy.gif" are correct, others like ":ph34r:" or ":rolleyes:" are visible as text
- By default the (unregistered) guests can read the entire (converted) forum. This should be deactived for guests like in the original (IBP)-board. I think that every Administrator should enable the boards for specific groups, not for everyone...
- The PM's (in/out) are not available. I can see a Label called "(10)". The error-message in Admin-Center-Errorlog is:
Quotehttp://sitename.somewhere/smf/index.php?action=pm
8: Undefined index: id
Datei: c:\Inetpub\wwwroot\smf\Sources\PersonalMessage.php
Zeile: 258
It should convert 8 PM's (3 in / 5 out).
Quote from: InvisibleMan78 on October 26, 2006, 12:18:38 PM
I have a similar problem like daveb47 (but on a win2k3-server with IIS), running your latest version of 'invision2_to_smf.sql'. The following error appears:QuoteConverting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options...
Parse error: parse error in c:\Inetpub\wwwroot\smf\convert.php(814) : eval()'d code on line 10
Unsuccessful!
This query:
INSERT INTO `smf`.smf_poll_choices
(ID_POLL, choices)
VALUES ('1', 'a:3:{i:0;a:3:{i:0;i:0;i:1;s:59:\"Ja, mich stören "gestern", "heute" etc.\";i:2;i:3;}i:1;a:3:{i:0;i:1;i:1;s:42:\"Nein, ich finde die relativen Datümer cool\";i:2;i:2;}i:2;a:3:{i:0;i:2;i:1;s:13:\"Mir doch egal\";i:2;i:0;}}');
Caused the error:
Unknown column 'choices' in 'field list'
Thank you for your help in advance!!
That means that the unserialize() function isn't working for some reason.
Changing the polls thing the way you did won't fix things, and I'm actually a bit surprised that it worked since there are only 4 columns in SMF's table...
As for the other issues:
Passwords - SMF does attempt to detect IPB's password-hashing method. Unless they changed it, passwords should work. You might be asked to re-enter your password the first time you login, but after doing so you should be able to login just fine.
Thumbnails - I'll look into that.
Avatars - Apparently the converter doesn't try to copy over avatars. I'll look into that as well.
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?
Icons - Admin -> Smileys and Smiley Sets, check the box next to "Enable custom smileys" and save the changes. Do they show up after that?
Permissions/Board access - What permission in IPB controls board access?
Labels - this is due to a typo in the converter. Run the following query in phpMyAdmin to fix it:
UPDATE smf_members SET labels='-1';Thanks for the feedback. We're still trying to fix all the issues - some things that work for some users won't work for others...
Problem with Mysql5 and this converter..
QuoteConverting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:
INSERT INTO `newfrms`.smf_topics
(ID_TOPIC, isSticky, ID_BOARD, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_POLL, numReplies, numViews, ID_FIRST_MSG, ID_LAST_MSG, locked)
VALUES ('2', '0', '1', '1', '1', '', '0', '198', '2', '2', '0'),
('3', '0', '3', '2', '5', '', '30', '224', '3', '289', '0'),
('4', '1', '12', '1', '602', '', '155', '3205', '11', '52891', '0'),
...
Caused the error:
Incorrect integer value: '' for column 'ID_POLL' at row 1
To fix this:
The sql file, line 127 becomes " COALESCE(pl.pid,0) AS ID_POLL, t.posts AS numReplies, t.views AS numViews," minus the quotes. This may not work on mysql <5 though.
Similar error fixed: sql, line 184 becomes " COALESCE(p.edit_time,0) AS modifiedTime, SUBSTRING(p.edit_name, 1, 255) AS modifiedName,"
All I added is the COALESCE.. which makes the value 0 if it was null. Mysql5 doesn't like inserting '' into integer columns.
Quote from: Oldiesmann on October 27, 2006, 03:49:21 PM
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
+----+--------+-------+--------+
| 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 |
+----+--------+-------+--------+Quote from: OldiesmannIcons - 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.
Quote from: OldiesmannPermissions/Board access - What permission in IPB controls board access?
I'm not sure about! There is a table called 'ibf_forum_perms'
+---------+---------------------------+
| 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! :-X
Quote from: OldiesmannThanks 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:
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.
Sorry. Wrong table.
Run these queries to fix the labels:
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...
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.
@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
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...
Quote from: InvisibleMan78 on October 29, 2006, 05:05:28 AM
@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.
Quote from: devicenull on October 28, 2006, 09:58:23 PM
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.
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)
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 (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?
:(
Send me a database dump of your IPB attachments table and I'll see what I can do about making it convert thumbnails.
How exactly do we have to make that? Could you please give us some instructions?
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).
I will... have some trouble with my computer now.. had to do an "format c:" :( ... (nope, no xxx-sites ;D )
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
Just the attachments table.
'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
Quote from: InvisibleMan78 on November 02, 2006, 01:13:36 PM
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
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),
# 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
Quote from: InvisibleMan78 on November 02, 2006, 01:13:36 PM
'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.
Thank you! :D
Quote from: Mickerovare on November 03, 2006, 02:14:14 PM
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
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;