Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


This forum does not allow new topics to be created, please use the v2 forum from now on.

  • Bo Petersen 28 posts 61 karma points
    Dec 19, 2010 @ 12:37
    Bo Petersen
    0

    MySql Support

    I have tried installing the v1.3. and still no support for MySql powered umbraco installation,

    an installer for MySql databases would be appriciated, since many of our websites are running MySql, for several reasons.

     

     

  • Stefan Kip 1606 posts 4098 karma points c-trib
    Dec 19, 2010 @ 14:31
    Stefan Kip
    0

    I'm not creating an extra version especially for MySQL, sorry. You could look at the SQL command in the package.xml and convert it...

  • Bo Petersen 28 posts 61 karma points
    Dec 19, 2010 @ 14:53
    Bo Petersen
    0

    hello Kipuseop

    Thank you for answering.

    I have created the table needed in MySql and it seems to work out of the box from there, so it is only a matter of changing the install scripts, perhaps i can find the time to make one that works with MySql asweel.

    Thanks :-)

  • Stefan Kip 1606 posts 4098 karma points c-trib
    Dec 19, 2010 @ 15:04
    Stefan Kip
    0

    Ah ok, that sounds good.
    Please do find the time to create a SQL statement for creating the table, so you can share it here with others :-)

  • Bo Petersen 28 posts 61 karma points
    Dec 19, 2010 @ 20:05
    Bo Petersen
    1

    Hey Everybody

    I have this script for creating the MySql table.

    Just run the standard package installation and then apply this SQL to the MySql database afterwards, since there is no future plans for including MySql support with the InfoCaster 301 package :-)

    Otherwise you can edit the package.xml file and replace the MsSql script with this.

    1. MySql recognises only the ` and NOT the ' for tablenames, this is not a typo.
    2. If the table is expanded for future standard features, u need to manually update the MySql table.
    CREATE TABLE IF NOT EXISTS `infocaster301` 
    (
        `NodeID` int(11) NOT NULL,
        `OldUrl` varchar(400) NOT NULL,
        `IsCustom` bit(1) NOT NULL DEFAULT false,
        `IsRegex` bit(1) NOT NULL DEFAULT false,
        `Message` varchar(400) DEFAULT NULL,
        `Inserted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        PRIMARY KEY (`NodeID`,`OldUrl`)
    )

    www.boblog.dk - xslt and in time much more.

  • Stefan Kip 1606 posts 4098 karma points c-trib
    Dec 19, 2010 @ 20:36
    Stefan Kip
    0

    Nice job, thanks :-)

  • Bilal Isa 60 posts 76 karma points
    Jan 29, 2011 @ 04:56
    Bilal Isa
    0

    http://www.softpilar.com/media/11137/301_url_tracker_1.3_mysql.zip

    I came across the same problem, so I thought this might save people some time.

    /Bilal

  • Albert 27 posts 49 karma points
    Aug 05, 2012 @ 23:43
    Albert
    0

    Hi, can you post another time the url tracker package for mysql? It seems that the link is wrong..

    Thank you

  • Yarik Goldvarg 35 posts 84 karma points
    May 13, 2014 @ 09:32
    Yarik Goldvarg
    0

    Hi before installing the  plugin just create a table in mysql

    CREATE TABLE `icurltracker` (
      `Id` int(11) NOT NULL AUTO_INCREMENT,
      `OldUrl` varchar(400) DEFAULT NULL,
      `OldUrlQueryString` varchar(400) DEFAULT NULL,
      `OldRegex` varchar(400) DEFAULT NULL,
      `RedirectRootNodeId` int(11) DEFAULT NULL,
      `RedirectNodeId` int(11) DEFAULT NULL,
      `RedirectUrl` varchar(400) DEFAULT NULL,
      `RedirectHttpCode` int(11) DEFAULT '301',
      `RedirectPassThroughQueryString` bit(1) DEFAULT b'1',
      `Notes` varchar(400) DEFAULT NULL,
      `Is404` bit(1) DEFAULT b'0',
      `Referrer` varchar(400) DEFAULT NULL,
      `Inserted` datetime DEFAULT CURRENT_TIMESTAMP,
      `ForceRedirect` bit(1) DEFAULT b'0',
      PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8$$
    
    tested with  2.5.3 version
    Yarik
    www.uteam.co.il
  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies