Tweet
Installation Problems starting on step 3
I have been tried installing 3.0.5 four times now (three fresh attempts and then I attempted installing 2.0 and then upgrading from that installation), all failed attempts. I am running PHP 4.3.10, and MYSQL 4.0.21. I created a new database, but I didnt create any tables. The first installation problem I have is several php warnings I get such as:
Warning: Constants may only evaluate to scalar values in /includes/init.php on line 806
Warning: Constants may only evaluate to scalar values in /includes/init.php on line 806
Warning: Constants may only evaluate to scalar values in /includes/init.php on line 806
Warning: Constants may only evaluate to scalar values in /includes/init.php on line 806
This is caused by line 806 not being serialized properly. Line 806 should be:
define(strtoupper($_constname), serialize($_constval));
Thats just an annoyance, but not too bad. The next problem is with the sql scripts that the installation is running:
Invalid SQL: INSERT INTO vbphrase
(languageid, phrasetypeid, varname, text) VALUES (-1, 0, 'access', 'Access'), (-1, 0, 'access_masks', 'Access Masks'),
..........(stuff cut out here)...........
, (-1, 0, 'zero_equals_no_display', 'Set to \'0\' to not display this item') mysql error: Duplicate entry 'admin_control_panel--1-0' for key 2
mysql error number: 1062
Date: Saturday 08th of January 2005 10:29:47 PM
This is caused by your index restraints and your script is trying to insert the same index information more than once.
This can also be fixed by changing line 556 of includes/adminfunctions_language.php to $sql = "INSERT IGNORE INTO ". This solves that problem, but I refuse to believe that I am the first person to ever install 3.0.5 from scratch, surely a blatant error like that would have been discovered by now.
The next error is step 7:
Invalid SQL:
SELECT t1.templateid AS templateid_1, t1.title , t1.templateid AS templateid_1, t1.title AS title1, t1.styleid, t2.templateid AS templateid_2, t2.title AS title2, t2.styleid
FROM vbtemplate AS t1
LEFT JOIN vbtemplate AS t1 ON (t1.title=t1.title AND t1.styleid=Array) LEFT JOIN vbtemplate AS t2 ON (t1.title=t2.title AND t2.styleid=Array)
WHERE t1.styleid = -1
ORDER BY t1.title
mysql error: Not unique table/alias: 't1'
mysql error number: 1066
Date: Saturday 08th of January 2005 10:53:29 PM
I fixed this error by editing a couple of lines of code, but I fail to see why all these errors are popping up. Surely, these installation scripts were tested? Why am I getting all these problems? These first three are minor compared to the ones I get later on, but I figure maybe someone else has had the same problems and the future errors were caused by things that were messed up here.
Warning: Constants may only evaluate to scalar values in /includes/init.php on line 806
Warning: Constants may only evaluate to scalar values in /includes/init.php on line 806
Warning: Constants may only evaluate to scalar values in /includes/init.php on line 806
Warning: Constants may only evaluate to scalar values in /includes/init.php on line 806
This is caused by line 806 not being serialized properly. Line 806 should be:
define(strtoupper($_constname), serialize($_constval));
Thats just an annoyance, but not too bad. The next problem is with the sql scripts that the installation is running:
Invalid SQL: INSERT INTO vbphrase
(languageid, phrasetypeid, varname, text) VALUES (-1, 0, 'access', 'Access'), (-1, 0, 'access_masks', 'Access Masks'),
..........(stuff cut out here)...........
, (-1, 0, 'zero_equals_no_display', 'Set to \'0\' to not display this item') mysql error: Duplicate entry 'admin_control_panel--1-0' for key 2
mysql error number: 1062
Date: Saturday 08th of January 2005 10:29:47 PM
This is caused by your index restraints and your script is trying to insert the same index information more than once.
This can also be fixed by changing line 556 of includes/adminfunctions_language.php to $sql = "INSERT IGNORE INTO ". This solves that problem, but I refuse to believe that I am the first person to ever install 3.0.5 from scratch, surely a blatant error like that would have been discovered by now.
The next error is step 7:
Invalid SQL:
SELECT t1.templateid AS templateid_1, t1.title , t1.templateid AS templateid_1, t1.title AS title1, t1.styleid, t2.templateid AS templateid_2, t2.title AS title2, t2.styleid
FROM vbtemplate AS t1
LEFT JOIN vbtemplate AS t1 ON (t1.title=t1.title AND t1.styleid=Array) LEFT JOIN vbtemplate AS t2 ON (t1.title=t2.title AND t2.styleid=Array)
WHERE t1.styleid = -1
ORDER BY t1.title
mysql error: Not unique table/alias: 't1'
mysql error number: 1066
Date: Saturday 08th of January 2005 10:53:29 PM
I fixed this error by editing a couple of lines of code, but I fail to see why all these errors are popping up. Surely, these installation scripts were tested? Why am I getting all these problems? These first three are minor compared to the ones I get later on, but I figure maybe someone else has had the same problems and the future errors were caused by things that were messed up here.
Comment