I've looked at various postings here and tried everything to resolve my issue as it's quite searchable, but none of these fixes have provided results as of yet. I'm hoping someone might be able to help, and thank you for giving of you effort and time. I did not originally create this script, and the one who did is no longer available, so I find myself without capability here.
I am running a 2.5 Joomla site. In an attempt to upgrade the PHP version from 5.3 to 5.4, I've acquired table errors as following(and found here: http://www.storysanctum.com/play/dice/wod-die-roller ):
Warning: mysql_connect(): Access denied for user 'storysanctum'@'220.127.116.11' (using password: YES) in /home/content/80/11429580/html/storysanctum/dice/roller_log_config.php on line 7
Warning: mysql_select_db() expects parameter 2 to be resource, boolean given in /home/content/80/11429580/html/storysanctum/dice/roller_log_config.php on line 8
Warning: mysql_query(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/80/11429580/html/storysanctum/dice/formquery.php on line 4
Warning: mysql_query(): A link to the server could not be established in /home/content/80/11429580/html/storysanctum/dice/formquery.php on line 4
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/content/80/11429580/html/storysanctum/dice/formquery.php on line 5
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/content/80/11429580/html/storysanctum/dice/formquery.php on line 43
Navigating to the formquery area, here then is my script:
Code: Select all
Line 4-5: $query = mysql_query("SELECT * FROM sj0m_ssdieroller order by roller_id DESC LIMIT 100");
$data = mysql_fetch_assoc($query);
echo "<tr bgcolor=\"".$bgcolor."\"><td>".$timestamp."</td><td>".$name."</td><td>".$action."</td><td>Pool: ".$numberofdice."</td><td>Results: ".$originalresults."<font color='green'>".$willpowerresults."<font color='blue'>".$aoaresults."<font color='indigo'>".$roteresults."<font color='red'>".$rollagainresults."</font></td><td>Suxx: ".$suxx."</td><td>Factors: ".$rollagaintype.$additionalfactors."</td></tr>";
}while($data = mysql_fetch_assoc($query))
I hope I'm posting to the right place, and forgive me for not being very code savvy.