Advertisement:

Author Topic: IPB 1.3 -> SMF 1.1 RC3: Typing error in sql script  (Read 3585 times)

Offline jeichhorn

  • Newbie
  • *
  • Posts: 3
IPB 1.3 -> SMF 1.1 RC3: Typing error in sql script
« 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:

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

Offline Oldiesmann

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 24,872
  • Gender: Male
  • Ask me about the function DB :)
    • oldiesmann on Facebook
    • Oldiesmann on GitHub
    • https://www.linkedin.com/in/michaeleshom on LinkedIn
    • @oldiesmann on Twitter
    • Archie Comics Fan Forum
Re: IPB 1.3 -> SMF 1.1 RC3: Typing error in sql script
« Reply #1 on: November 20, 2006, 05:11:05 PM »
Thanks for the report!
Michael Eshom
Cincy Space - now open!