http://www.icyphoenix.com/viewtopic.php?f=35&t=8217 ----------------------------------- Renato71 Sat 12 Nov, 2011 01:17 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! ----------------------------------- spydie Sat 12 Nov, 2011 06:20 Re: Converting From SMF 1.1.15 ----------------------------------- You should convert first to PhpBB 2 , and that includes installing it first. ----------------------------------- Renato71 Sat 12 Nov, 2011 10:11 Re: Converting From SMF 1.1.15 ----------------------------------- [quote user="spydie" post="54562"]You should convert first to PhpBB 2 , and that includes installing it first.[/quote] OK, I will proceed in that manner. Thanks for reply. ----------------------------------- TheSteffen Sat 12 Nov, 2011 20:40 Re: Converting From SMF 1.1.15 ----------------------------------- If you have any problems, please let us know. :) ----------------------------------- Renato71 Sun 13 Nov, 2011 11:41 Re: Converting From SMF 1.1.15 ----------------------------------- [quote user="TheSteffen" post="54566"]If you have any problems, please let us know. :)[/quote] 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 linenumbers=false]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[/code] 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. ----------------------------------- spydie Sun 13 Nov, 2011 12:36 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 ----------------------------------- Joshua203 Sun 13 Nov, 2011 15:32 Re: Converting From SMF 1.1.15 ----------------------------------- Hi there Renato, Maybe this link will help you? http://www.phpbb.com/community/viewtopic.php?f=10&t=528056&start=195#p3020005 ----------------------------------- Renato71 Mon 14 Nov, 2011 17:30 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... ----------------------------------- Joshua203 Mon 14 Nov, 2011 17:56 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: [quote="realmsfan"] [code linenumbers=false]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[/code] SMF 1.1.2 to phpBB 2.0.22 Apache 2.2.3 MySQL 5.0.27 PHP 5.2.0[/quote] [quote="D¡cky"] realmsfan, What convertor are you using. You should not have that problem if you use [url=http://sourceforge.net/project/showfiles.php?group_id=141446&package_id=226078]smf 1.1.1 convertor. Check line 702 of index.php. It should be [code linenumbers=false]$sql .= "\nLIMIT $skip_rows, 18446744073709551615";[/code] There is another problem with index.php(I can't remember what)which is why I included the fixed version with my convertor.[/quote] [quote="realmsfan"]The line was [code linenumbers=false]$sql .= "\nLIMIT $skip_rows, -1";[/code] Thank you, that solved the error and there were no further errors.[/quote] I know the error report is not 100% the same but to me it looks somewhat similar :wink: ----------------------------------- Informpro Tue 15 Nov, 2011 12:16 Re: Converting From SMF 1.1.15 ----------------------------------- Maybe some RDBMS allows "-1" as "infinite", but apparently mysql does not.