Creating database tables: Database Alerts!

Hi all,
I am trying to install modx 1.0.5 in to a web host and I get the following error during the installation.

My Basic configurations

MySQL Server version: 5.0.92-community
MySQL charset: UTF-8 Unicode (utf8)
MySQL client version: 5.0.92
PHP Version 5.3.1 (http://violac.net/phpinfo.php)
Apache version 2.2.15


Install results
Setup will now attempt to setup the database:
Creating connection to the database: OK!
Selecting database `violacne_modx`: OK!

Creating database tables: Database Alerts!
MODx setup couldn’t install/alter some tables inside the selected database.

The following errors had occurred during installation

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 ’\’0\’, `username` varchar(50) NOT NULL default \’\’, `lasthit` int(20) NOT N’ at line 2 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_active_users` ( `internalKey` int(9) NOT NULL default \’0\’, `username` varchar(50) NOT NULL default \’\’, `lasthit` int(20) NOT NULL default \’0\’, `id` int(10) default NULL, `action` varchar(10) NOT NULL default \’\’, `ip` varchar(20) NOT NULL default \’\’, PRIMARY KEY (`internalKey`) ) ENGINE=MyISAM COMMENT=\’Contains data about active users.\’.

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 ’\’\’, PRIMARY KEY(`id`) ) ENGINE=MyISAM COMMENT=\’Categories to be used snippe’ at line 3 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_categories` ( `id` integer NOT NULL AUTO_INCREMENT, `category` varchar(45) NOT NULL DEFAULT \’\’, PRIMARY KEY(`id`) ) ENGINE=MyISAM COMMENT=\’Categories to be used snippets,tv,chunks, etc\’.
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 ’\’0\’, `document` int(10) NOT NULL default \’0\’, PRIMARY KEY (`id`), KEY’ at line 3 during the execution of SQL statement CREATE TABLE IF NOT EXISTS `modx_document_groups` ( `id` int(10) NOT NULL auto_increment, `document_group` int(10) NOT NULL default \’0\’, `document` int(10) NOT NULL default \’0\’, PRIMARY KEY (`id`), KEY `document` (document), KEY `document_group` (document_group) ) ENGINE=MyISAM COMMENT=\’Contains data used for access permissions.\’.

bla...bla...bla...bla...bla...bla...

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 ’\’MODxCarbon\’ WHERE `setting_name`=\’manager_theme\’’ at line 2 during the execution of SQL statement UPDATE `modx_user_settings` SET `setting_value`=\’MODxCarbon\’ WHERE `setting_name`=\’manager_theme\’.
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 ’\’manager_theme\’,\’MODxCarbon\’)’ at line 1 during the execution of SQL statement REPLACE INTO `modx_system_settings` (setting_name, setting_value) VALUES (\’manager_theme\’,\’MODxCarbon\’).

Some tables were not updated. This might be due to previous modifications.

SOMEBODY PLEASE HELP ME

tnx
vajira

Any chance the database user doesn’t have a complete set of permissions?
Matt

It has all the necessary permissions

Why does the query have the single quote delimiters escaped? Those are not in the .sql file itself and there is nothing in the sqlParser.class.php script to add them.

What happens if you import the setup.sql file directly through phpMyAdmin or a command line?

I have no idea how escaped character appears there. Those queries were generated by modx setup itself.
contents of setup.sql are working fine with phpMyAdmin.

Is this a PHP bug or something?

do you have the magic_quotes_gpc turned on?
never mind, just saw your php info.

Anybody ?????????

looks like you have the ’--enable-magic-quotes’ on your php’s default settings.
try to copy your php.ini into the install folder before running the installation.

My site is hosted in a shared host. So how do I get ’--enable-magic-quotes’ to my site? I have a php.ini file under /public_html and it contains

safe_mode = Off
register_globals = off
magic_quotes_gpc = off
max_execution_time = 120

so what should i do?

copy that to the public_html/install/ folder