Obsolete Releases > SME 8.x Contribs

Changing php.ini question

<< < (3/3)

rogerbodger:

--- Quote from: mmccarn on March 13, 2013, 01:53:15 PM ---I have several ibays that require that magic_quotes_gpc is off (and which came with their own .htaccess files).

The .htaccess files in those ibays contain a line saying:
--- Code: ---php_flag magic_quotes_gpc          Off
--- End code ---

But in order for .htaccess to make any difference in an ibay you need to 'AllowOverride' for the ibay:

--- Code: ---db accounts setprop itop AllowOverride All
signal-event ibay-modify itop

--- End code ---

--- End quote ---
The AllowOverride has done the trick and the installer is now running - many thanks, I really appreciate your help.

Bud:
Please guys can you help me.

I have a new SME 8.1 64Bit Server with all updates installed

I am trying to install ITOP V 2.03

I get to 40% installed then i receive this error:

*******************************************

Failed to issue SQL query: query = CREATE TABLE `priv_changeop` (`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, `changeid` INT(11) NOT NULL, INDEX (`changeid`), `objclass` VARCHAR(255) NOT NULL, `objkey` VARCHAR(255) NOT NULL, `optype` VARCHAR(255) NOT NULL, INDEX (`optype`), INDEX `objclass_objkey` (`objclass`, `objkey`)) ENGINE = innodb CHARACTER SET utf8 COLLATE utf8_unicode_ci, mysql_error = Specified key was too long; max key length is 1000 bytes, mysql_errno = 1071

*******************************************

Any ideas what i must do with the MySQL Database ?

Any help greatly appreciated  :smile:

Stefano:
Bud

this has nothing to do with SME..

you should search the reason/solution with Google, then try to apply it (likely via a custom fragment) to your SME

Bud:
Stefano i understand.

However i need to start " InnoDB " as when i issue the following command in mysql " show engines; " i can see that InnoDB IS Disabled.

So you need to " Enable " InnoDB " and keep it enabled after a server reboot.

Please go to http://wiki.contribs.org/MySQL#Enable_InnoDB_engine

Or at the Shell enter the Following Command:

# db configuration setprop mysqld InnoDB enabled
# expand-template /etc/my.cnf
# sv t /service/mysqld

And there you go, ITOP can now be Installed

I know you guys are busy and am sorry for the noob questions. Thanks  :smile:

Stefano:
The answer is wiki

Navigation

[0] Message Index

[*] Previous page