Today I sucessfully downloaded everything and set it up on my laptop, then updated it from 3.0.8 to the latest version. Everything works great on my laptop. I then uploaded it to my webspace and now I get (I've changed the config.php to the new database settings);
I have even taken the config.php from the webspace and put it into my local install, which then connects with no problems. Further more I have written the following script;
General Error
SQL ERROR [ mysql4 ]
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [2002]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Code: Select all
<?php
error_reporting(E_ALL);
ini_set( 'display_errors','1');
$mysqli = mysqli_connect('213.171.218.233', 'groomermill', '8xAog5AhnUZ8VBSd', 'groomermill');
if (mysqli_connect_errno($mysqli))
echo "Failed to connect to MySQL: " . mysqli_connect_error();
$res = mysqli_query($mysqli, 'SELECT * FROM `phpbb_users` WHERE `username_clean`="scott"');
if (!$res)
echo "Nothing returned";
else
{
$row = $res->fetch_assoc();
echo 'UserID: ' . $row['user_id'];
}
I've tried uploading the files again and check everything is perfect. I'm totally stumped and after 3 hours of messing about I need some fresh eyes on the problem.