|
Page 1 of 1
|
Renato71
Joined: November 2011
Posts: 6
|
Converting From SMF 1.1.15
Hi,
I would like to convert my forum from SMF 1.1.15 into IP 1.3.24.77.
Searching this forum I did not find definite answer.
1) What is the best procedure? To convert from SMF to phpbb2, and then to IP?
2) Do I have to install phpbb2?
Thanks in advance!
|
#1 Sat 12 Nov, 2011 01:17 |
|
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
|
spydie
Joined: December 2008
Posts: 1796
Location: In the Boxes
|
Re: Converting From SMF 1.1.15
You should convert first to PhpBB 2 , and that includes installing it first.
____________ Out of Order
|
#2 Sat 12 Nov, 2011 06:20 |
|
Renato71
Joined: November 2011
Posts: 6
|
Re: Converting From SMF 1.1.15
You should convert first to PhpBB 2 , and that includes installing it first.
OK, I will proceed in that manner.
Thanks for reply.
|
#3 Sat 12 Nov, 2011 10:11 |
|
TheSteffen
Joined: August 2006
Posts: 1625
Location: Magdeburg
|
Re: Converting From SMF 1.1.15
If you have any problems, please let us know.
____________ TheSteffen
Often SEARCH is the quickest way to get support.
IcyPhoenix German Support
|
#4 Sat 12 Nov, 2011 20:40 |
|
Renato71
Joined: November 2011
Posts: 6
|
Re: Converting From SMF 1.1.15
If you have any problems, please let us know.
Ehm, yes. I do have some problems with converting form SMF to phpbb2.
I was going to do few more runs with it before reporting here, but since you ask
After several attempts, I managed to import boards, but no users and messages. On convert, there was an SQL error:
General Error
Couldn't obtain table information.
DEBUG MODE
SQL Error : 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 '-1' at line 3
SELECT messages.ID_MSG, messages.subject, messages.body FROM smf_messages messages LIMIT 9380, -1
Line : 711
File : index.php
Some time ago I experienced similar error, that I was able to solve. I'll check it out more.
If I'm allowed to post links as progress report, here is the current state of conversion:
http://lockonhr.com/phpbb2/
... and here is active SMF forum:
http://lockonhr.com/forum/index.php
I do have many mods on SMF, most importantly TinyPortal. I'll remove all mods and then do an export/import of such "clean" SMF forum.
But, I think that I will proceed with that on my local PC, rather then on a live website.
|
#5 Sun 13 Nov, 2011 11:41 |
|
spydie
Joined: December 2008
Posts: 1796
Location: In the Boxes
|
Re: Converting From SMF 1.1.15
you should convert on a separate instalicion, with a copy of your site.
never with the original.
and always make a backup of everything
____________ Out of Order
|
#6 Sun 13 Nov, 2011 12:36 |
|
Joshua203
Joshua 203
Dutch A Go Go
Joined: August 2008
Posts: 1754
Location: Earth, Europe, the Netherlands, Rotterdam
|
Re: Converting From SMF 1.1.15
____________ www.DutchaGoGo.com (development/under construction ...Forever?¿?)
|
#7 Sun 13 Nov, 2011 15:32 |
|
Renato71
Joined: November 2011
Posts: 6
|
Re: Converting From SMF 1.1.15
@spydie
Yes, I'm working with backup only
Current I lack free time to do everything in one go.
@Joshua203
Thanks, but what post exactly?
I'm cleaning up my (backup) smf from all the mods. I've done some serious customizations over last 4 years. God, what a waste of time...
|
#8 Mon 14 Nov, 2011 17:30 |
|
Joshua203
Joshua 203
Dutch A Go Go
Joined: August 2008
Posts: 1754
Location: Earth, Europe, the Netherlands, Rotterdam
|
Re: Converting From SMF 1.1.15
I'm not sure why you don't see the question and the reply to it because the link refers directly to the first post containing the question, but here you go:
realmsfan wrote:
Couldn't obtain table information.
DEBUG MODE
SQL Error : 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 '-1' at line 4
SELECT messages.ID_MSG, messages.ID_TOPIC, messages.ID_BOARD, messages.ID_MEMBER, messages.posterName, messages.posterTime, messages.posterIP, messages.smileysEnabled, messages.modifiedTime, messages.modifiedName FROM realms_messages messages LEFT JOIN realms_topics AS topics USING (ID_TOPIC) LIMIT 13060, -1
Line : 711
File : index.php
SMF 1.1.2 to phpBB 2.0.22
Apache 2.2.3
MySQL 5.0.27
PHP 5.2.0
D¡cky wrote:
realmsfan,
What convertor are you using. You should not have that problem if you use smf 1.1.1 convertor.
Check line 702 of index.php. It should be
$sql .= "\nLIMIT $skip_rows, 18446744073709551615";
There is another problem with index.php(I can't remember what)which is why I included the fixed version with my convertor.
realmsfan wrote: The line was
$sql .= "\nLIMIT $skip_rows, -1";
Thank you, that solved the error and there were no further errors.
I know the error report is not 100% the same but to me it looks somewhat similar
____________ www.DutchaGoGo.com (development/under construction ...Forever?¿?)
|
#9 Mon 14 Nov, 2011 17:56 |
|
Informpro
Joined: October 2008
Posts: 1110
Location:
|
Re: Converting From SMF 1.1.15
Maybe some RDBMS allows "-1" as "infinite", but apparently mysql does not.
|
#10 Tue 15 Nov, 2011 12:16 |
|
|
Page 1 of 1
|
Was this topic useful?
Was this topic useful?
Link this topic |
URL |
|
BBCode |
|
HTML |
|
You cannot post new topics You cannot reply to topics You cannot edit your posts You cannot delete your posts You cannot vote in polls You cannot attach files You can download files You cannot post calendar events
|
|
|
|