Again on DB error after installing pp 0.8.8.alpha

Tagged:  

Hi, herewith the error log i've got after finishing (step 5) the installation procedure.
Any ideas ?
Thanks

------------------------------------------------------------------------------- Session "default" started at 2011-11-14T10:55:32+0000 #1 FATAL: exception 'DBQueryError' with message 'Query failed with message 'Unknown table engine 'INNODB''' in /web/htdocs/www.jacleroi.com/home/361advertising/projectpier/environment/library/database/adapters/AbstractDBAdapter.class.php:373 Stack trace: #0 /web/htdocs/www.jacleroi.com/home/361advertising/projectpier/environment/library/database/adapters/AbstractDBAdapter.class.php(257): AbstractDBAdapter->prepareAndExecute('SET STORAGE_ENG...', NULL) #1 /web/htdocs/www.jacleroi.com/home/361advertising/projectpier/environment/library/database/DB.class.php(143): AbstractDBAdapter->execute('SET STORAGE_ENG...', NULL) #2 /web/htdocs/www.jacleroi.com/home/361advertising/projectpier/init.php(108): DB::execute('SET STORAGE_ENG...') #3 /web/htdocs/www.jacleroi.com/home/361advertising/projectpier/index.php(11): require('/web/htdocs/www...') #4 {main} #2 ERROR: Error: Use of undefined constant ROOT_URL - assumed 'ROOT_URL' in '/web/htdocs/www.jacleroi.com/home/361advertising/projectpier/application/layouts/error.php' on line 6 (error code: 8) Time since start: 0.035163879394531 seconds

At a closer check it seems the error has been thrown by:

/web/htdocs/www.jacleroi.com/home/361advertising/projectpier/index.php(11): require('/web/htdocs/www...') #4 {main}
#2 ERROR: Error: Use of undefined constant ROOT_URL - assumed 'ROOT_URL' in '/web/htdocs/www.jacleroi.com/home/361advertising/projectpier/application/layouts/error.php'
on line 6 (error code: 8) Time since start: 0.035163879394531 seconds

I've checked the /projectpier/application/layouts/error.php and here's the line:

<?php
echo link_tag(ROOT_URL.'favicon.ico', 'rel', 'Shortcut Icon', array("type"=>"image/x-icon"))
?>

This is it for now.

Hi,

It seems to me that your database configuration is incompatible with ProjectPier. Specifically, looks like your MySQL doesn't support the INNODB storage engine. That's what the actual error seems to be. Not sure how to help you with that...

Is this your own machine or a hosting account?

Just comment the string
//DB::execute("SET STORAGE_ENGINE=INNODB"); // try to set to INNODB, don't care if it fails

in init.php

I've read this fix somewhere in this forum.

In 0.8.8 development these kind of statements are wrapped in an error handling block, like this:

DB::attempt("SET STORAGE_ENGINE=INNODB"); // try to set to INNODB, don't care if it fails

For now your solution is the fix.