Make sure that "cache/*" is writable and then try again error

[GoogleCodeExporter]

Hello,

I am trying installing hppg on my local server and on the third step it says 
"Make sure that "cache/*" is writable and then try again". But it is writable.

Any help please?

(I am going to upload it into my server and check, I will update on that too.)

Bage.

Original issue reported on code.google.com by bagerat...@gmail.com on 24 Jun 2011 at 12:18

[GoogleCodeExporter]

On my live server also, the installation produces the same error. 

Bage.

Original comment by bagerat...@gmail.com on 24 Jun 2011 at 2:01

[GoogleCodeExporter]

Same here, During step 3 when it's creating the database it errors out. 
When the install file tries to create tables some of them come back with the 
error:
"Specified key was too long; max key length is 1000 bytes" 

But even running the latest version of mysql doesn't fix the issue. Could it be 
a mysql setting?

Attached is the database tables that were created. There was no error checking 
on the create table and insert queries. So it appears as though it fails while 
creating the database then just spits out the "Make sure that cache/* is 
writable and then try again" error...

How can i get this working?! :)

Original comment by brianmol...@gmail.com on 24 Jun 2011 at 7:20

Attachments:

• db-tables.png

[GoogleCodeExporter]

On line 1196 in /modules/lhinstall/index.php i added 1 line of code so we could 
get more details about the error:
  echo $e;

I created a clean utf8 database and ran the install. Here's the error output:
exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access 
violation: 1071 Specified key was too long; max key length is 1000 bytes' in 
/var/www/ckb/modules/lhinstall/install.php:690 Stack trace: #0 
/var/www/ckb/modules/lhinstall/install.php(690): PDO->query('CREATE TABLE 
IF...') #1 /var/www/ckb/lib/core/lhcore/lhmodule.php(60): 
include_once('/var/www/ckb/...') #2 
/var/www/ckb/lib/core/lhcore/lhmodule.php(304): 
erLhcoreClassModule::runModule() #3 /var/www/ckb/index.php(35): 
erLhcoreClassModule::moduleInit() #4 {main}

Original comment by brianmol...@gmail.com on 25 Jun 2011 at 8:20

[GoogleCodeExporter]

Problem Sql: $db->query("CREATE TABLE IF NOT EXISTS `lh_oid_associations` (
                  `server_url` blob NOT NULL,
                  `handle` varchar(255) NOT NULL,
                  `secret` blob NOT NULL,
                  `issued` int(11) NOT NULL,
                  `lifetime` int(11) NOT NULL,
                  `assoc_type` varchar(64) NOT NULL,
                  PRIMARY KEY (`server_url`(255),`handle`)
                ) DEFAULT CHARSET=utf8;");

Problem: "PRIMARY KEY (`server_url`(255),`handle`)"

The 255 when setting the primary key is the problem. Can it be set to a lower 
number so the table can be created? I'm not sure what this will effect.. Can 
you let me know?

Original comment by brianmol...@gmail.com on 25 Jun 2011 at 8:24

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Use r1182 revision install file. O just change from 255 to 100 key length. And 
all should be fine. Thanx for bug report.

Original comment by remdex on 26 Jun 2011 at 8:19

[GoogleCodeExporter]

I just released new zip, you can download it

Original comment by remdex on 26 Jun 2011 at 8:30

[GoogleCodeExporter]

Thank you, Will report back.

Original comment by brianmol...@gmail.com on 26 Jun 2011 at 8:31

[GoogleCodeExporter]

works perfectly. Thank you very much. I will let you know if I run into any 
other problems or fix any other bugs.

Brian

Original comment by brianmol...@gmail.com on 26 Jun 2011 at 8:40

[GoogleCodeExporter]

Original comment by remdex on 28 Jun 2011 at 7:12

• Changed state: Fixed

[GoogleCodeExporter]

Just as an update, works great for me too...

Bage.

Original comment by bagerat...@gmail.com on 28 Jun 2011 at 5:16

[GoogleCodeExporter]

try to install this engine but I got
 Fatal error: Class 'PDO' not found in /home/..../Fatal error: Class 'PDO' not found in /home
how to fix it?

Original comment by prasetia...@gmail.com on 14 Feb 2013 at 4:11

[GoogleCodeExporter]

install php-pdo extension.

Original comment by remdex on 14 Feb 2013 at 4:20