Trying to install SS2.4.2 with MySQL 4.1 on Yahoo! hosting, not a great combo I know! But in a bit of a rush.
Get the following error after hitting the install button (all initial checks on the install screen are fine apart from the "MySQL 5 recommended" line):
Setting up 'mysite/_config.php'...
Setting up //mysite/_config.php
Building database schema...
[User Error] Couldn't run query: CREATE TABLE "PageComment" ( "ID" int(11) not null auto_increment, "ClassName" enum('PageComment') character set utf8 collate utf8_general_ci default 'PageComment', "Created" datetime, "LastEdited" datetime, "Name" varchar(200) character set utf8 collate utf8_general_ci, "Comment" mediumtext character set utf8 collate utf8_general_ci, "IsSpam" tinyint(1) unsigned not null default 0, "NeedsModeration" tinyint(1) unsigned not null default 0, "CommenterURL" varchar(255) character set utf8 collate utf8_general_ci, "SessionID" varchar(255) character set utf8 collate utf8_general_ci, "ParentID" int(11) not null default 0, "AuthorID" int(11) not null default 0, index "ParentID" (ParentID), index "AuthorID" (AuthorID), index "ClassName" (ClassName), primary key (ID) ) ENGINE=MyISAM Access denied for user 'riverq'@'localhost' to database 'mysql'
Looks like an access problem from the last line there, although I am definitely using the correct db admin user and password (checks out ok on the first install screen).
The Yahoo! documentation has the following info on accessing the MySQL db:
"Please note that you can access your database using either PHP or Perl scripts run from your web site or the phpMyAdmin database management tool. You can create custom scripts or install publicly available packages that use a MySQL database, such as our advanced add-ons. You will not be able to access your database using a desktop client or other tools run outside of Yahoo!"
So wondering if this is a MySQL 4.1 issue or Yahoo! hosting issue. Question is, how does SS run SQL queries on install - through a php script? If so should be fine. As you can probably tell I'm pretty new to web development.
If anyone has any ideas, that would be very much appreciated. Don't fancy my chances of a quick response from Yahoo.