Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 1
 
 
Reply with quote Download Post 
Post 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!
 



 
Renato71Send private message  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post Re: Converting From SMF 1.1.15 
 
You should convert first to PhpBB 2 , and that includes installing it first.
 




____________
Out of Order
 
spydieSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Converting From SMF 1.1.15 
 
spydie wrote: [View Post]
You should convert first to PhpBB 2 , and that includes installing it first.


OK, I will proceed in that manner.
Thanks for reply.
 



 
Renato71Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 
TheSteffenSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Converting From SMF 1.1.15 
 
TheSteffen wrote: [View Post]
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:

Code: [Download] [Hide] [Select]
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.
 



 
Renato71Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 
spydieSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Converting From SMF 1.1.15 
 
Hi there Renato,

Maybe this link will help you?

http://www.phpbb.com/community/view...rt=195#p3020005
 




____________
www.DutchaGoGo.com (development/under construction ...Forever?¿?)
 
Joshua203Send private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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...
 



 
Renato71Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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: 

Code: [Download] [Hide] [Select]
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
Code: [Download] [Hide] [Select]
$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

Code: [Download] [Hide] [Select]
$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?¿?)
 
Joshua203Send private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Converting From SMF 1.1.15 
 
Maybe some RDBMS allows "-1" as "infinite", but apparently mysql does not.
 



 
InformproSend private message  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
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


  

 

  cron