News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

[SMF Converter] phpBB - 2.0.19+

Started by JayBachatero, January 13, 2007, 02:47:08 AM

Previous topic - Next topic

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 :)
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

ThorstenE

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

change
<install for="1.1.3">
to
<install for="1.1.5">
and
<uninstall for="1.1.3">
to
<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
/******************************************************************************/
--- 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
/******************************************************************************/
--- 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..

/******************************************************************************/
--- 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.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

allymcbeal


allymcbeal

#552
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

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

allymcbeal

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

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

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

allymcbeal


ThorstenE

maybe it's cause from:
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?

Advertisement: