Simple Machines Community Forum

SMF Support => Converting to SMF => IPB => Topic started by: jeichhorn on November 20, 2006, 04:32:04 PM

Title: IPB 1.3 -> SMF 1.1 RC3: Typing error in sql script
Post by: jeichhorn on November 20, 2006, 04:32:04 PM
SMF Version: SMF 1.1 RC3
There is a small typing error in the ipb 1.3 to smf 1.1 rc3 converter sql script, which prevents to run successfully 'subsring' instead of 'substring').
Here is the diff to fix this:


--- invision_to_smf.sql.orig    2006-11-20 21:51:54.427111252 +0100
+++ invision_to_smf.sql 2006-11-20 21:52:08.768488861 +0100
@@ -392,7 +392,7 @@
                                INSERT INTO {$to_prefix}membergroups
                                        (ID_GROUP, groupName, maxMessages, onlineColor, stars)
                                VALUES
-                                       ($row[ID_GROUP] + 3, SUBSRING('$row[groupName]', 1, 255), $row[maxMessages], '', '')");
+                                       ($row[ID_GROUP] + 3, SUBSTRING('$row[groupName]', 1, 255), $row[maxMessages], '', '')");
                        $groupID = $row['ID_GROUP'] + 3;
                }
                else


Jörg.
Title: Re: IPB 1.3 -> SMF 1.1 RC3: Typing error in sql script
Post by: Oldiesmann on November 20, 2006, 05:11:05 PM
Thanks for the report!