Installation Errors

Help
Kamal
2014-07-17
2014-07-17
  • Kamal
    Kamal
    2014-07-17

    Good Morning All,

    I had run into the following errors during the installation of Ipplan v6


    If you see this message, submit a detailed bug report on Sourceforge including the message below, the database platform used and the steps to perform to recreate the problem.

    PHP 5.5.9-1ubuntu4.2 (Linux)
    Unknown error type: [8192] Function set_magic_quotes_runtime() is deprecated Line: 68 File: /var/www/ipplanv6/ipplanlib.php

    snmp support not compiled into php

    importing from routing tables and direct query of device will not work

    zlib support compiled into php

    output to webrowser will be compressed for quicker loading of pages if web browser supports compression

    File uploads to ip records may not work - unable to create file in /var/spool/ipplanuploads - check permissions

    DNS zone file exports do not work - unable to create file in /tmp/dns/ - check permissions

    DHCP exports do not work - unable to create file in /tmp/dhcp/ - check permissions

    CREATE TABLE area (
    areaaddr VARCHAR(39) NOT NULL DEFAULT '',
    descrip VARCHAR(80) NOT NULL DEFAULT '',
    areaindex BIGINT NOT NULL AUTO_INCREMENT,
    customer SMALLINT UNSIGNED NOT NULL DEFAULT 0,
    PRIMARY KEY (areaindex)
    )TYPE=INNODB;

    Failed to execute above statement against database

    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 'TYPE=INNODB' at line 7


    My main question is that which file do I need to edit to change that "TYPE=INNODB" error?

     
  • Kamal
    Kamal
    2014-07-17

    Problem Solved - Albeit more than a few hair hairs were lost in this process

    For everyone that had a problem, This is the solution - Credits to Tuany

    For me I had to edit ipplanlib.php under this directory var/www/ipplanv6/, uncommenting 2 lines (67 and 69)
    if (phpversion()<"5.3") {
    set_magic_quotes_runtime(0);
    }

    Then go to var/www/ipplan/admin/schemacreate.php, on line 46 change:

    $taboptarray = array('mysql' => 'TYPE=INNODB');
    To:
    $taboptarray = array('mysql' => 'ENGINE=INNODB');

     
  • Kamal
    Kamal
    2014-07-17

    Well, I changed all instances of TYPE to ENGINE just to be sure