USING BTREE Wrong in Installation

Bug #754315 reported by TitanKing
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
PHPDevShell
Fix Released
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.....

Revision history for this message
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
Revision history for this message
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.

Revision history for this message
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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.