Installation Problems
Jeren
Joined: 2009-02-12
Posts: 7 |
![]() |
I assume I can post a G3 bug here. If I'm wrong, please move this to the correct forum. I'm attempting to install Gallery 3.0 Alpha 1 on my VPS for testing. I'm running PHP 5.2.6, Apache 2.2.11, and MySQL 5.0.67. When entering in my MySQL data, the first time I try it, it says: "Failed to create tables in your database:Lost connection to MySQL server during query" Subsequent attempts then give me the error: "The database you provided already has other tables in it. Continuing with the install might overwrite an existing Gallery install. Please go back and choose a different database." The only table in there is one named access_cache, with no data (and apparently still being accessed, which sometimes prevents me from clearing the database and trying again). I've tried making several blank databases and all fail as stated above. Assistance would be appreciated. I'm really wanting to see what G3 looks like. Thanks. |
|
bharat
![]()
Joined: 2002-05-21
Posts: 7994 |
![]() |
I haven't seen this error before. I found this via Google: Can you check your mysql error logs to see if there's more information there? |
|
Jeren
Joined: 2009-02-12
Posts: 7 |
![]() |
Here are my logs. This is me attempting to use a fresh database. Note, I've tried using MySQL 4.1.22 and then MySQL 5.0.67, and both gave me the same errors. This is with MySQL 5.0.67 I've censored my account name. 090215 18:22:52 InnoDB: Error: table `<account>_g3/access_caches` does not exist in the InnoDB internal EDIT: This creates the first error message I reported. |
|
bharat
![]()
Joined: 2002-05-21
Posts: 7994 |
![]() |
I responded in the other thread, but I'll repost the same response here too since this is a better topic for it. Try emptying out your database and then do this: mysql -u<user> -p<pass> <dbname> < installer/install.sql That should reinstall all your tables. The SQL there is pretty straightforward (it's a snapshot of an install). Do you get an error doing it that way? |
|
Jeren
Joined: 2009-02-12
Posts: 7 |
![]() |
Yup, got an error. [root@host g3test]# mysql -u<user> -p<pass> <db>_g3 < installer/install.sql I tried looking up the other error but it gave info about timing out queries (which I don't think this is doing as it happens very fast). I'm a bit stumped... |
|
bharat
![]()
Joined: 2002-05-21
Posts: 7994 |
![]() |
Ok, that is very interesting. Next up, let's run the SQL queries separately. Look in installer/install.sql and you'll see a series of SQL statements, each ending in a semicolon. Clear out your mysql database and let's try running each command one at a time and see what it says. In the example below, mysql> is the prompt from the command line mysql client (you probably already know this, but others will read this too). Here's what the first set of commands would look like for the access_caches table: $ mysql <db>_g3 mysql> DROP TABLE IF EXISTS `access_caches`; mysql> SET @saved_cs_client = @@character_set_client; mysql> SET character_set_client = utf8; mysql> CREATE TABLE `access_caches` ( `id` int(9) NOT NULL auto_increment, `item_id` int(9) default NULL, `view_full_1` tinyint(2) NOT NULL default '0', `edit_1` tinyint(2) NOT NULL default '0', `view_full_2` tinyint(2) NOT NULL default '0', `edit_2` tinyint(2) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; mysql> SET character_set_client = @saved_cs_client; mysql> INSERT INTO `access_caches` VALUES (1,1,1,0,1,1); That's all the commands for the access_caches table. Repeat that for every table until either you get an error, or you successfully install all the tables. If you're successful doing it this way, then we're going to have a serious head-scratching wtf moment. If there's a failure, hopefully we'll learn something. |
|
Jeren
Joined: 2009-02-12
Posts: 7 |
![]() |
Quote:
mysql> use <account>_g3 It seems to have something to do with that table creation right there... I don't know why. But I am going to speculate that it may be an issue on my end (though I really don't know what it is right now). I attempted to make a simple, test InnoDB table and I received identical errors. I've got my server host techies looking into it. I'm hoping they'll have an idea on why that is happening, because I sure don't... |
|
bharat
![]()
Joined: 2002-05-21
Posts: 7994 |
![]() |
Let me know what your tech folks say. As far as I can tell, the SQL we've got there is perfectly valid (that SQL was in fact generated by MySQL itself!). My guess is that there's some InnoDB misconfiguration on your server. :-/ |
|
Jeren
Joined: 2009-02-12
Posts: 7 |
![]() |
Actually, it looks like the server is configured perfectly. What does appear to be a problem is a cPanel update that practically F-ed up InnoDB tables... Hooray for auto updates... (see http://blog.cpanel.net/?p=160 ) From what it looks like, to fix InnoDB on my system would probably wipe my existing InnoDB tables. Out of curiosity, could those G3 tables work as MyISAM? |
|
bharat
![]()
Joined: 2002-05-21
Posts: 7994 |
![]() |
They should work as MyISAM, so you could do a search/replace on install.sql and try that to see if it works. |
|
Jeren
Joined: 2009-02-12
Posts: 7 |
![]() |
Using MyISAM did indeed work. For anyone that may have been affected by corrupt InnoDB as a result of that cPanel update, that could be a workaround. Out of curiosity, why was the InnoDB engine chosen for G3 tables? |
|
bharat
![]()
Joined: 2002-05-21
Posts: 7994 |
![]() |
I think the main reason for InnoDB was so that we'd support transactions easily. I'll review this decision with the dev team. |
|