can`t install phpdevshell correctly Installer Stage 2
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_
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:
- 2011-04-07
- Last reply:
- 2011-04-07
Greg (gregfr) said : | #1 |
What is your version of the MySQL server?
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
TitanKing (titan-phpdevshell) said : | #3 |
Are you sure you have latest PHPDevShell 3.0.1a?
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.
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.
Greg (gregfr) said : | #6 |
From this page:
http://
your server may be configured to use quotes other than the default backticks
TitanKing (titan-phpdevshell) said : | #7 |
Make sure you clean your database before trying again.
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_
for some reason I obtain this error (after copy & paste the code in sql):
CREATE TABLE `pds_core_
`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
Greg (gregfr) said : | #9 |
so if you remove "USING BTREE" the query works?
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
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/
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.