Closed GoogleCodeExporter closed 8 years ago
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
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:
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
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
[deleted comment]
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
I just released new zip, you can download it
Original comment by remdex
on 26 Jun 2011 at 8:30
Thank you, Will report back.
Original comment by brianmol...@gmail.com
on 26 Jun 2011 at 8:31
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
Original comment by remdex
on 28 Jun 2011 at 7:12
Just as an update, works great for me too...
Bage.
Original comment by bagerat...@gmail.com
on 28 Jun 2011 at 5:16
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
install php-pdo extension.
Original comment by remdex
on 14 Feb 2013 at 4:20
Original issue reported on code.google.com by
bagerat...@gmail.com
on 24 Jun 2011 at 12:18