phpBB2 Members, Posts, Forums and Attachements > SMF

[zigx]

Is it possible?

i just bought vbulletin SOLEY based on the fact that an individual on hxxp:vbulletin.org [nonactive] wrote an attachment importer for vb's impex (importing system)


can smf import phpbb2 attachments?

i will ebay my vBulletin license lol

[zigx]

just fyi.... i dont understand code THAT well...i see in the phpbb importer that it has some lines regarding attadhments and i just wanted to clarify.

[Waste]

[packman]

can smf import phpbb2 attachments?

It should do, but as I never had attachments in my phpBB system I couldn't check this part of the code. It does all the other things you mention (as well as polls, smileys, avatars, PMs, etc), so give it a go on a test SMF install. If the attachment code doesn't work, it will be fixed.

[Grudge]

It should do attachments (Or the attachment mod specifically). I had tested it so it should work. Try it out, it won't touch your phpBB install so if it doesn't work you've lost nothing

[Jerry]

I tried running the attachments import for phpbb, and it showed as no having it installed. I have all the tables in the phbb database it is looking for . .. Any one have any ideas?

[Jerry]

sorry for the double post, but when I took out the lines the check for the tables in the converter the attachments went over fine  I don't think its the best way to do it but it worked.

[packman]

Which lines did you have to remove?

[Jerry]

the part that checks for the mod:

Code Select Expand

// Test whether they have the mod installed or not?
$result = mysql_query("
SHOW TABLES LIKE {$from_prefix}attachments");
list ($tableExists) = mysql_fetch_row($result);
mysql_free_result($result);

// if (empty($tableExists))
// {
// echo '
// <div style="color: red;">Fatal Error: Attachments MOD is not installed in your phpBB forum!!</div>';
//
// return;
// }

// Tell ummm...the if (emty($tableExists)) part.
I am also having a problem with the smilies, it turns them all into words like : goes to P and goes to D and :roll: turns to roll, etc. But the smilies of a post show up in quotes of a topic, but not in the post itself. confiusing :S

[[Unknown]]

What happens if you add:

var_dump($tableExists);die;

Before the commented section?

-[Unknown]

[packman]

Does the table name need single quotes round it, e.g.

SHOW TABLES LIKE 'phpbb2_attachments'

phpMyAdmin gives an error (on a different table in a different database) if I don't add the single quotes.

Code Select Expand

Error

SQL-query :

SHOW TABLES LIKE mmap_data

MySQL said:
#1064 - 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 'mmap_data' at line 1

[Jerry]

[Unknown] - I have not had time to try yours
packman - when I add the ' ' s in phpMyadmin the table will show, but without it will not. Maybe thats the problem? In an hour or 2 I will try the ' ' s then if that does not work I will do [Unknown]'s

[Jerry]

[Unknown] - That didn't help
[packman] - that probably was a problem, but didn't fix it.

[[Unknown]]

[Unknown] - That didn't help
[packman] - that probably was a problem, but didn't fix it.

Aha, yes, the problem is missing quotes.

My question was just to diagnose, not to fix.

-[Unknown]

[Jerry]

well when I added your code to it it said NULL, but when I added the quotes, it still says the mod is not installed.

[[Unknown]]

And, if you add both... does it still say NULL?

-[Unknown]

[Jerry]

I willl give that a try when my webhost is running normally, for some reason the mysql is going really slow

[Jerry]

yes it stil shows up as NULL with the new ' ' s.

[Jerry]

I have decided to go ahead and convert my forums over any way with the smiley problem, I was only worried about getting my Attachments which went smoothly other then the code commenting

[[Unknown]]

The correct line should be:

Code Select Expand

SHOW TABLES LIKE '" . preg_replace('~^`.+?`\.~', '', $from_prefix) . "attachments'");

! The phpBB converter didn't check for the attachments table properly. (phpbb2_to_smf.php)

-[Unknown]