• Welcome to Simple Machines Community Forum. Please login or sign up.

[SMF Converter] phpBB - 2.0.19+

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

Previous topic - Next topic

bebo94

I did. That's the whole point of my post.

JayBachatero

Reupload the convert.php.  Seems like it's corrupt.  Make sure you set it to overwrite not resume when uploading.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

bebo94

Downloaded the PHP script from this forum and the sql file again. Deleted the other ones on the server, uploaded these new files (ASCII mode) and still received this error when running it:
Parse error: syntax error, unexpected T_VARIABLE in /[path name]/forums/convert.php on line 1

Both my phpBB database and my SMF database are UTF8.

Please advise.

JayBachatero

Post the convert.php that you are using here.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

bebo94


JayBachatero

It's good.  Are you on a free host?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

bebo94

November 14, 2007, 11:51:11 PM #346 Last Edit: November 14, 2007, 11:53:18 PM by bebo94
No. I'm not on a free host. I'm on lunar pages.

The first script that I downloaded from the simplemachines website worked just fine. It just had the bugs in it like not importing the signatures or avatars correctly.

The only difference that I can think of is the first time it worked my database was not in UTF8 format. The SMF database was actually in latin swedish. After I realized this I reinstalled the forum with UTF8 and also downloaded the latest PHP and SQL from the forum here.

JayBachatero

I looked at the convert file and there are no errors there.  Get this file. http://www.simplemachines.org/community/index.php?topic=140741.0
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

bebo94

That's the file that I was using. But I downloaded it again, replaced it on the web server and still get:
Parse error: syntax error, unexpected T_VARIABLE in /[path name]/forums/convert.php on line 1 when I run it.

Currently the permissions on the file are 644.

JayBachatero

Download the file from the server and see if its getting truncated.  You get that error right when you open the convert.php or you are able to insert your config info?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

bebo94

November 15, 2007, 12:16:41 AM #350 Last Edit: November 15, 2007, 12:26:49 AM by bebo94
I don't think it's getting truncated. But it is getting scrambled. I've uploaded the original file both with an FTP client and via command prompt and pulled it back down. Each time it's lost it's internal formatting. (see attached)

It is giving me the error when I immediately try to run the file. I don't get the dialog prompts.

JayBachatero

WTF.  It's losing all its formatting causing everything to be in one line.  So lines with // s comments, comment the whole script out.  Try using another FTP client.  Also is this a windows server or linux?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

bebo94

OK. Tried a couple more FTP clients and the script uploaded OK. Cyberduck and Mac terminal FTP were the ones messing it up.

Signatures and avatars converted but smilies came through as :wink:, etc. Any way I can get them back? Do I need to install another set? I have the default SMF 1.1.4 running.

JayBachatero

Using the converter files from this topic?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

bebo94

OK. I poked around the admin control panel and found out what was going on with the smileys. The converter worked great. By default however, the smileys are turned off. In order to get all of them to show up correctly I had to select both of these options in the smiley settings panel:
Enable smiley set selection by members
Enable customized smileys

Thanks Jay for all your help. I would suggest posting these php and sql files on the main smf website instead of the outdated ones that are out there now.

Thanks, again.

JayBachatero

Yea I've been meaning to update the main files but I havent had the time to go through all of them and update them.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

maxklr

November 16, 2007, 05:46:52 AM #356 Last Edit: November 16, 2007, 05:50:25 AM by maxklr
Well, well, well... I got the following message trying to convert from: phpBB 2.0.22 to SMF

Recalculating forum statistics... Unsuccessful!
This query:

    ALTER TABLE `reggaemusic_no`.smf_smileys
    ORDER BY LENGTH(code) DESC;

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 'LENGTH(code) DESC' at line 2



Any ideas?

thanks!

EDIT: New forum is working, though. But what are those errors I got actually affecting?

unjuster

Hello.

I would like start first greeting the whole comunity. And, ask if anyone can help me.

A few posts before, I asked for some help. And, I got the main issue sorted out, but, the second issue still not solved.

My problem is, that my host doesn't aloud to have the same username for the DB's in the same server for security reasons.
So, I can't give access from one DB to the other so it can conver the forums.
I would like to know, and if someone would help me to do it, if there is a way to specify on the converter the logging for the other DB? Seems to me that is the only way posible that it can be done, in order for the converter to work.

Thanks in advance.
Regards, Unjuster.

SleePy

maxklr

Open the .sql file and find
    ALTER TABLE {$to_prefix}smileys
    ORDER BY LENGTH(code) DESC;

and change to:
    ALTER TABLE {$to_prefix}smileys
    ORDER BY code DESC;


This is a mysql bug, we just have to deal with it sadly until they fix it.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

Ricky.

Hi Sleepy, I think .sql file I received is not having lines u mentioned.

Advertisement: