can`t install phpdevshell correctly Installer Stage 2

Asked by Rafael A.A

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.....

Question information

Language:
English Edit question
Status:
Answered
For:
PHPDevShell Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Greg (gregfr) said :
#1

What is your version of the MySQL server?

Revision history for this message
Rafael A.A (rafsys) said :
#2

The version of MySql is:

5.0.51a-24+lenny5

OS Linux Debian Lenny

PHP version: PHP 5.2.6-1+lenny9

Revision history for this message
TitanKing (titan-phpdevshell) said :
#3

Are you sure you have latest PHPDevShell 3.0.1a?

Revision history for this message
TitanKing (titan-phpdevshell) said :
#4

First thing to check is to make sure that the created DB account you are using has write permission to the database.

Revision history for this message
Greg (gregfr) said :
#5

That's weird. Do you have access to the db, for example with phpMyAdmin? if so, please check that you can connect with the credentials you provided, and try to copy&paste the request and run it, to see what the server answers (I've tried it here the query is syntaxically correct). If the query is rejected, please try to remove first the CHARSET part, then the ENGINE part of the query.

Revision history for this message
Greg (gregfr) said :
#6

From this page:

http://dev.mysql.com/doc/refman/5.0/fr/legal-names.html

your server may be configured to use quotes other than the default backticks

Revision history for this message
TitanKing (titan-phpdevshell) said :
#7

Make sure you clean your database before trying again.

Revision history for this message
Rafael A.A (rafsys) said :
#8

Are you sure you have latest PHPDevShell 3.0.1a?
Yes, because I downloaded yesterday in the morning
PHPDevShell V3.0.1a-Stable

First thing to check is to make sure that the created DB account you are using has write permission to the database.
Yes, the user XXX has all permissions to the database DB

That's weird. Do you have access to the db, for example with phpMyAdmin? if so, please check that you can connect with the credentials you provided, and try to copy&paste the request and run it, to see what the server answers (I've tried it here the query is syntaxically correct). If the query is rejected, please try to remove first the CHARSET part, then the ENGINE part of the query.

Yes, I have phpmyadmin installed, and inside i can see these tables:

pds_core_cron
pds_core_filter
pds_core_hooks
pds_core_logs
pds_core_menu_access_logs

for some reason I obtain this error (after copy & paste the code in sql):
 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

MySQL ha dicho: Documentación
#1064 - 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 'USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8' at line 1

I went to the mysql documentation, I obtained this:

Error de Oracle Secure Enterprise Search
Se ha encontrado un problema al procesar la solicitud.
Según la información disponible, se podría deber a:

La excepción no contenía ningún mensaje de error. Informe de este problema al administrador o póngase en contacto con el representante de Oracle.

I simple words, the exception contains no error....

after all, I removed the charset and engine part, but the error is this:
#1064 - 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 'USING BTREE )' at line 1

that means: USING BTREE is the problem that could cause it...

Thanks for your answers

Revision history for this message
Greg (gregfr) said :
#9

so if you remove "USING BTREE" the query works?

Revision history for this message
Rafael A.A (rafsys) said :
#10

As I said before...

I removed the part:

using btree

it works

My question is, what consecuenses I will have ommiting this part of the query and how to solve this..

Can I change this part in the base file that contains the query in order to make funtion all proccess, also I need to remove all tables, because I did not tryed it yet.

Thaks for your answer

Revision history for this message
Greg (gregfr) said :
#11

Removing the use of BTREE has absolutly no consequences, since it's just a way of optimizing the table indexes. However, it might be a sign that your install of MySQL is incomplete, you might want to check that.

To clean up the tables, go to phpMyAdmin and simply delete all of them inside the database.

If you can't fix MySQL (or don't want to), you can simply open /other/service/PHPDevShell-db-3001-complete.sql and remove all occurences of USING BTREE and try the installation again.

We will study the possibility and impacts of removing it from the distributions files, your feedback is greatly appreciated

Can you help with this problem?

Provide an answer of your own, or ask Rafael A.A for more information if necessary.

To post a message you must log in.