[SMF Converter] phpBB - 2.0.19+

[ThorstenE]

maybe it has a similar function like the modification Who voted What??

[allymcbeal]

I think yes, but it is only for 1.1.3.

[SleePy]

It should still function for 1.1.5

[ThorstenE]

Download & extract it.. then edit package-info.xml

change

Code Select Expand

<install for="1.1.3">
to

Code Select Expand

<install for="1.1.5">
and

Code Select Expand

<uninstall for="1.1.3">
to

Code Select Expand

<uninstall for="1.1.5">
then repack, upload and install via package-manager

[allymcbeal]

Thanks! It works.
For the old poll is possible recover the name of users?

Thank you.

[ThorstenE]

mhh, don't know if this works but try

change

Code Select Expand

/******************************************************************************/
--- Converting poll votes...
/******************************************************************************/

---* {$to_prefix}log_polls
SELECT vote_id AS ID_POLL, vote_user_id AS ID_MEMBER
FROM {$from_prefix}vote_voters
WHERE vote_user_id > 0
GROUP BY vote_id, vote_user_id;
---*

to

Code Select Expand

/******************************************************************************/
--- Converting poll votes...
/******************************************************************************/

---* {$to_prefix}log_polls
SELECT vote_id AS ID_POLL, vote_user_id AS ID_MEMBER , vote_cast AS ID_CHOICE
FROM {$from_prefix}vote_voters
WHERE vote_user_id > 0
GROUP BY vote_id, vote_user_id;
---*

[allymcbeal]

Sorry, I searched but I can't found this code?

[ThorstenE]

are you using the phpbb2_to_smf.sql from this topic? a block like this should be in there.. (search for "votes")
but you also can edit your phpbb2_to_smf.sql and put it at the end of that file..

Code Select Expand

/******************************************************************************/
--- Converting poll votes...
/******************************************************************************/

---* {$to_prefix}log_polls
SELECT vote_id AS ID_POLL, vote_user_id AS ID_MEMBER , vote_cast AS ID_CHOICE
FROM {$from_prefix}vote_voters
WHERE vote_user_id > 0
GROUP BY vote_id, vote_user_id;
---*

[allymcbeal]

Sorry, now I have understand. I try...

[allymcbeal]

I have this error:

Parse error: syntax error, unexpected '}' in /var/www/vhost/allymcbeal.it/home/html/forums/convert.php on line 5245

[SleePy]

What program did you use to edit the file?
Don't use MS Word.
I would suggest something such as notepad++ or context.

[allymcbeal]

Ok, I'll try. Sorry.

[allymcbeal]

I did it. It gives me this error

Parse error: syntax error, unexpected T_STRING in /var/www/vhost/allymcbeal.it/home/html/forums/convert.php on line 5250

This is my code
}

//******************************************************************************/
// Converting poll votes...
//******************************************************************************/

5249 //---*{$to_prefix}log_polls
5250 SELECT vote_id AS ID_POLL, vote_user_id AS ID_MEMBER , vote_cast AS ID_CHOICE
5251 FROM {$from_prefix}vote_voters
5252 WHERE vote_user_id > 0
5253 GROUP BY vote_id, vote_user_id;
5254 //---*
5255
5256
5257 ?>

[allymcbeal]

In my convert.php I have only once the "poll"

   $knownKeys = array(

         'PRIMARY' => 'ADD PRIMARY KEY (ID_TOPIC)',

         'lastMessage' => 'ADD UNIQUE lastMessage (ID_LAST_MSG, ID_BOARD)',

         'firstMessage' => 'ADD UNIQUE firstMessage (ID_FIRST_MSG, ID_BOARD)',

         'poll' => 'ADD UNIQUE poll (ID_POLL, ID_TOPIC)',



         'isSticky' => 'ADD KEY isSticky (isSticky)',

         'ID_BOARD' => 'ADD KEY ID_BOARD (ID_BOARD)',


Maybe it can help.

[SleePy]

try this one

[allymcbeal]

I'm a little idiot , because only now I understand that TE means phptosmf, I writed the code under convert.php...

Now I write the code under the right file and I have this error:

SELECT vote_id AS ID_POLL, vote_user_id AS ID_MEMBER , vote_cast AS ID_CHOICE
FROM `my0363`.phpbb_vote_voters
WHERE vote_user_id > 0GROUP BY vote_id, vote_user_id
LIMIT 0, 500;
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 'BY vote_id, vote_user_id
LIMIT 0, 500' at line 3


Now I try with yours sleepy.
Sorry TE for the trouble.


EDIT: Also with yours sleepy I have this message.

[SleePy]

Any better?

[allymcbeal]

No, I can't see the old users.

[ThorstenE]

maybe it's cause from:

Code Select Expand

GROUP BY vote_id, vote_user_id;

try the attached version..

[Squash]

I keep getting this error and the conversion keeps saying unsuccessful

Caused the error:
Duplicate entry '12446' for key 1

I am having issues with importing the posts and continue to have it say unsuccessful.

Some of the posts have come over but only up to 2007...no recent or newer posts?