USING BTREE Wrong in Installation

Bug #754315 reported by TitanKing on 2011-04-08
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
PHPDevShell
Medium
TitanKing

Bug Description

in the installation proccess stage 2, I obtain this:

before this error, everything is OK. in green and check

Alert: An error occured;.
An error occured trying to send the queries (query 30/528).
The error was: [1064]
The offending query was: " CREATE TABLE `pds_core_menu_items` ( `menu_id` varchar(32) NOT NULL, `parent_menu_id` int(32) unsigned DEFAULT NULL, `menu_name` varchar(255) DEFAULT NULL, `menu_link` varchar(255) DEFAULT NULL, `plugin` varchar(255) DEFAULT NULL, `menu_type` int(1) DEFAULT NULL, `extend` varchar(255) DEFAULT NULL, `new_window` int(1) DEFAULT NULL, `rank` int(100) DEFAULT NULL, `hide` int(1) DEFAULT NULL, `template_id` int(32) unsigned DEFAULT NULL, `alias` varchar(255) DEFAULT NULL, `layout` varchar(255) DEFAULT NULL, PRIMARY KEY (`menu_id`), KEY `index` (`parent_menu_id`,`menu_link`,`plugin`,`alias`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8"

after that says:
Your server meets all the installation requirements

But I can`t continue
What is the problem, the mysql, the php code, I don`t know, please help me.....

TitanKing (titan-phpdevshell) wrote :

It has no impact and causes incompatibility.

Changed in phpdevshell:
importance: Undecided → Medium
assignee: nobody → TitanKing (titan-phpdevshell)
status: New → Fix Committed
Greg (gregfr) wrote :

For the record, the problem was "USING BTREE", it seems some MySQL installations, even in the latest versions, don't support it.

TitanKing (titan-phpdevshell) wrote :

This was actually a bug that creeped in with old software creating this query on export. It should def not be there.

Changed in phpdevshell:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers