MODx CMS and PHP Application Framework Bugtracker

Was this a clean install, with no previous attempts? A new install requires a completely empty database.

Yes, it was a clean install, with empty DB.

What version of MODx are you using?
What version of MySQL and PHP are you using?

I tried last release (3.2 tech preview), and the one just before that (don't remember number)
MySQL : 4.0.24
PHP : 4.3.11

Before install, only the database was created, not the content of this database.

After install, I see (in phpmyadmin) that 46 tables have been created. If it can help solve the problem...

Hmmm,

Try runing the setup.sql script on it's own via phpmyadmin

tried this: replacing {PREFIX} by the real one in the setup.sql files, running the file on phpmyadmin, and this gives me this error :

#1064 - Syntax error next to 'CREATE TABLE IF NOT EXISTS `modx_user_settings` (
`user` INTE' at line 67

here is the complete line :

TYPE = MYISAM COMMENT = 'Contains information describing the user roles.' CREATE TABLE IF NOT EXISTS `modx_user_settings` (
`user` INTEGER NOT NULL ,
`setting_name` varchar( 50 ) NOT NULL default '',
`setting_value` varchar( 255 ) NOT NULL default '',
KEY `setting_name` ( `setting_name` ) ,
KEY `user` ( `user` )
) TYPE = MYISAM COMMENT = 'Contains backend user settings.'

{PREFIX} needs to be batch replaced (on a copy) in the .sql file with the prefix of your database. Try that first, please.

After that, can you try emptying out the database of all tables and installing again, please?

thanks for trying to help me :)

I already replaced {PREFIX} with the right prefix - i got the comment I posted lately...
As the tables looked to be ok (there are 46 tables - is this OK ?), I created the config.inc.php and gave it the good settings.
Then I tried to connect to the modx site or manager : blank page, no error - the install procedure didn't have the time to set the admin login/pass in the DB.

I'm locked at this point !

philippe, please download the following test build of the next release to see if your issues persist: http://pixelhick.com/rev422.php

There are known issues with the new/4th layout so please do not use it. This is not a final release, btw.

Thanx, I'll try this and tell you what happens...

Any luck yet?

Actually, scratch that, please download the recently released stable version from the forums and see if it fixes it:

http://modxcms.com/forums/index.php/topic,1207.0.html

Sorry, I had lotsa work, couldn't test it before :)

No way, still the same error : everything works, till the final creation of tables : this message appears

MODx setup couldn't install/alter some tables inside the selected database

If I have a look to the DB, I see that the installer created 46 tables. After that, if I try to connect to the site, it takes me back to the installer...

Please note that I completely deleted all DB before installing modx.

Phillippe, I'm stumped ... but have an idea!

Please replace the setup.sql file with the one attached to this bug report in the tabs above.

All I did was make the spacing consistent. There were a few instances of spaces around the equal sign, and some double spaces in the SQL queries. I've seen double spaces cause odd problems in the past, and the first instance of the space around the equal sign was right above line 67 with the table type declaration.

Hopefully this will bring this to a resolution!

Ryan, I have the same problem philippe has been experiencing, down to the exact error messages.

I have downloaded the latest version here :
http://modxcms.com/forums/index.php/topic,1207.0.html

Luckily, a google search with
"MODx setup couldn't install/alter some tables inside the selected database."
lead me here and allowed me to get the attachment.

Problem is : attachment is not changing anything. I triple checked. FYI I am running Windows XP SP1 with EasyPHP 1.8.

When I tried to run setup.sql manually from phpMyAdmin, I got the same error message Philippe got (1064 - Syntax error next to 'CREATE TABLE IF NOT EXISTS.... at line 67).

Sorry forgot to add : PHP Version 4.3.10, MySQL 4.1.9, Apache/1.3.33 (Win32)

Report: It seems to be a problem with EasyPHP 1.8 configuration (MySQL or Apache version ?), I installed successfully with XAMPP 1.4.16.

See http://modxcms.com/forums/index.php/topic,1233.msg8381.html#msg8381

Thanks David... I think it's time to inquire with the EasyPHP team to find out if they can help us figure out what's going on... VERY odd indeed!

It seems it is not limited to EasyPHP, I have a french user reporting the same problem. He is running :

At home
OS : Ubuntu Hoary
PHP : 4.3.10-10ubuntu4.1
MySQL :
Cient API : 3.23.56
Apache : 2.0.53
MySQL : 4.1.10a-Debian_2-log

Laptop
OS : Ubuntu Breezy
PHP : 5.05-2ubuntu1
MySQL : 4.1.12-debian_1ubuntu3-log
Client API : 4.0.24
Apache : 2.0.54

He solved the problem by removing all the ALTER declaration in the sql file (he was doing a fresh install).

See : http://modxcms.com/forums/index.php/topic,1292.msg8913.html#msg8913

Hello,
I had the same problem today, installing the last modx release.

My solution was to remove all COMMENT clausole in the setup.sql script under install directory.

If you need the file, I can send it to you.

I'll double check the text in the comments and the ALTER statements and see if I can isolate the issue.

I removed some escaped single quotes in COMMENTS in a version of the .sql file (I'll post and attach this file in the forums so you guys can test it).

Also, no ALTER statements should be executed during a fresh install, so I do not understand how that be related to this problem.

File with double single-quotes removed from COMMENTS attached here...

Hi there,

Removing all ALTER things resolved the problem for me too... I guess there might be a problem with the detection of new or old version ?

Please test the latest setup.sql file attached to this post. I found a possible syntax errror in the alter statements and some formatting inconsistencies in the comments so hopefully one or both will fix our woes!

Ok Ryan I sent a PM to all people I had listed with this problem, telling them to download the new setup.sql fix and report on http://modxcms.com/forums/index.php/topic,1491.0.html for the french users and http://modxcms.com/forums/index.php/topic,1233.0.html for the english ones. We should have reports soon.

For reference, Raymond identified the cause of this error which was in sqlParserclass, see (http://modxcms.com/forums/index.php/topic,1292.msg8928.html#msg8928)

Susan has nailed it and here is the fix :
http://modxcms.com/forums/index.php/topic,1292.msg10954.html#msg10954

This is a temporary fix and she rewrite the lines involved using mysql_errno instead
see http://modxcms.com/forums/index.php/topic,1292.msg11065.html#msg11065

Has this been commited to SVN?

which part? -- I think we should close this and open new tasks for specific portions of the problems here