4
Hi I just downloaded and am trying to install
xoops-2.0.14-rc1
on my Arch Linux system.
I am currently using
MySQL 5.0.18
PHP 5
Apache 2.0.55
I am currently running into a blank page after the
Confirm Database Settings page. I checked all of the debug settings in the FAQ and set them all on, but I am still not receiving any error messages.
I decided to do some more investigation and by doing some tracing with print statements I have found that the error is occurring in the file
mysqldatabase.php around line 96. Specifically the following line of code
$this->conn = @mysql_connect(XOOPS_DB_HOST, XOOPS_DB_USER, XOOPS_DB_PASS);
When I saw this I figured that my PHP was not compiled for the MySQL functions so I recompiled but I am continuing to fail at the same place. I decided to check even more thoroughly to make sure that this was the problem so I ran the following test script.
// Connecting, selecting database
$link = mysql_connect('localhost', 'username', 'password')
or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db('gobandb') or die('Could not select database');
// Performing SQL query
$query = 'SELECT count(*) FROM b_move';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
// Printing results in HTML
echo "n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "tn";
foreach ($line as $col_value) {
echo "tt$col_value | n";
}
echo "t
n";
}
echo "
n";
// Free resultset
mysql_free_result($result);
// Closing connection
mysql_close($link);
?>
This script ran perfectly proving that my php is compiled correctly. I even used the same database_user, password, and host as my XOOPS setup. At this point I do not know what else to try. Does anyone have any suggestions for me?