Topic: Trouble accessing MySQL database

[laanes]

There's no way the code you have been posting with the @'s in it could have been outputting the posted errors. You must have some other code at the file/line number being reported in the errors.

Only the first error is relevant to this problem. The other errors are follow-on errors caused because the mysql_connect() is failing.

So most definately some of the credentials must be wrong?

[PFMaBiSmAd]

/home/scrptz/functions.php on line 25

For anyone here to directly be able to help, it would take seeing what lines 1 - 25 of that file is.

[laanes]

/home/scrptz/functions.php on line 25

For anyone here to directly be able to help, it would take seeing what lines 1 - 25 of that file is.

<?php
define("VAT", 17.5);
define("JIFFY", 5);
define("HTMLSIGNATURE", "<br><br><br><br><br><br>LOCK-TECH&reg; a division of<br>Swansea Timber & Ply Co. Ltd.<br>57-60 Oxford Street, Swansea SA1 3JD<br><br>[t] 01792 655680 [f] 01792 462243<br>[e] <a href=\"mailto:sales@lock-tech.co.uk\">sales@lock-tech.co.uk</a> [w] <a href=\"http://www.lock-tech.co.uk\">www.lock-tech.co.uk</a>");
define("TEXTSIGNATURE", "\n\n\n\n\n\nLOCK-TECH&#65533; a division of\nSwansea Timber & Ply Co. Ltd.\n57-60 Oxford Street, Swansea SA1 3JD\n\n[t] 01792 655680 [f] 01792 462243\n[e] sales@lock-tech.co.uk [w] www.lock-tech.co.uk");
///////////////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////////////
$bArray=array();
$sessions=array();
@set_time_limit(3);

// Database vars
$hostName="localhost";
$dbUser="swansea3_lockT";
$dbName="swansea3_locktech";
$pwd="****";
$qMain="SELECT * FROM pDetails

INNER JOIN products ON (pDetails.code = products.SCode)

INNER JOIN PRanges ON (products.PRange = PRanges.RangeID)

INNER JOIN PGroups ON (products.PGroup = PGroups.PG)

INNER JOIN SubG ON (products.PSubG = SubG.SPG)

INNER JOIN SubSubG ON (products.SSPG = SubSubG.SSPG) ";

mysql_connect($hostName, $dbUser, $dbName, $pwd);         <-------  LINE 25
mysql_select_db($dbName);

Ok, now when you pointed where to look, I can see that there is one too many variables listed in the MySQL connection. No need to have dbname in there.

However, when I remove it, a whole new error message is being displayed:

ERROR {2.1a}! Please navigate to a different page and then try this page again.

I can see that this is an "or die" message added to every function in functions.php file.


functions with this output in functions.php:

function inDaList($addy)
{

$result=@mysql_query("SELECT email FROM mailinglist") or die("<font color=\"#FF0000\">ERROR {2.0a}! Please navigate to a <a href=\"main.php?uid=".$sessions['uid']."\">different page</a> and then try this page again.</font>");

while($row=@mysql_fetch_array($result))foreach($row as $data)$addyArray[]=strtoupper($data);

return in_array($addy, $addyArray);
}


// Session functions
function startSession()
{

$result=mysql_query("SELECT uid FROM sessions")

or die("<font color=\"#FF0000\">ERROR {2.1a}! Please navigate to a <a href=\"main.php?uid=".$sessions['uid']."\">different page</a> and then try this page again.</font>");

while($row=mysql_fetch_array($result))foreach($row as $data)$sArray[]=$data;

$result=mysql_query("SELECT sessionID FROM basket")

or die("<font color=\"#FF0000\">ERROR {2.1b}! Please navigate to a <a href=\"main.php?uid=".$sessions['uid']."\">different page</a> and then try this page again.</font>");

while($row=mysql_fetch_array($result))foreach($row as $data)$bArray[]=$data;

srand((float)microtime()*100000000);

$theID=md5(rand());

if(!count($sArray))$sArray=array();

if(!count($bArray))$bArray=array();

while(in_array($theID, $sArray) || in_array($theID, $bArray))$theID=md5(rand());

mysql_query("INSERT INTO sessions SET uid='".$theID."',theTime='".time()."'")

or die("<font color=\"#FF0000\">ERROR {2.2}! Please navigate to a <a href=\"main.php\">different page</a> and then try this page again.</font>");

global $getVars;

$getVars["uid"]=$theID;
}


function destroySession($ID)
{

global $getVars, $sessions;

mysql_query("DELETE FROM sessions WHERE ID='".$ID."' LIMIT 1")

or die("<font color=\"#FF0000\">ERROR {2.3}! Please navigate to a <a href=\"main.php?uid=".$sessions['uid']."\">different page</a> and then try this page again.</font>");

// Remove session ID from getVars

unset($getVars['uid']);
}

function readSessionVars($ID)
{

global $getVars, $sessions;

$result=mysql_query("SELECT * FROM sessions WHERE uid='".$ID."' AND theTime>='".(time()-(3600*8))."'")

or die("<font color=\"#FF0000\">ERROR {2.4}! Please navigate to a <a href=\"main.php?uid=".$sessions['uid']."\">different page</a> and then try this page again.</font>");

while($row=mysql_fetch_array($result))foreach($row as $i=>$data)$sessions[$i]=$data;

mysql_query("UPDATE sessions SET theTime='".time()."' WHERE ID='".$sessions["uid"]."' LIMIT 1")

or die("<font color=\"#FF0000\">ERROR {2.5}! Please navigate to a <a href=\"main.php?uid=".$sessions['uid']."\">different page</a> and then try this page again.</font>");
}

function updateSession($ID, $var, $value)
{

global $getVars, $sessions;

mysql_query("UPDATE sessions SET ".$var."='".$value."' WHERE ID='".$ID."' LIMIT 1")

or die("<font color=\"#FF0000\">ERROR {2.6}! Please navigate to a <a href=\"main.php?uid=".$sessions['uid']."\">different page</a> and then try this page again.</font>");

readSessionVars($getVars["uid"]);
}

include('efunctions.php');
include('sessions.php');

[PFMaBiSmAd]

The current symptom means that the query failed due to an error (I'm going to guess a problem with the table name or the column name or permissions or the database...)

For debugging purposes (restore the code to what it currently is now when you are done), change the or die(.....) to

or die(mysql_error());

P.S. Are you sure this code worked before it was moved to the current server? All the @'s tell me that whoever wrote this was in favor of hiding problems in the code rather than finding and fixing them. For example, @set_time_limit(3); won't ever produce an error unless that function has been disabled on the server (which is highly unlikely), but you would want to know if that was the case and you would want to have that error reported.

[laanes]

I have now added - or die(mysql_error()); to every function that used to have - or die("<font color=\"#FF0000\">ERROR {2.6}! Please navigate to a <a href=\"main.php?uid=".$sessions['uid']."\">different page</a> and then try this page again.</font>"); instead.

I have also tried to add a comment to every function to help myself to understand what each of them means. It is possible that I have misunderstood some of them in which case the comments would not be very helful.


function inDaList($addy)
{

$result=@mysql_query("SELECT email FROM mailinglist") or die(mysql_error());

while($row=@mysql_fetch_array($result))foreach($row as $data)$addyArray[]=strtoupper($data);

return in_array($addy, $addyArray);
}

// Session functions
function startSession()
{

// Read all sessionIDs from session table

$result=mysql_query("SELECT uid FROM sessions")

or die(mysql_error());

// Stick them in an array

while($row=mysql_fetch_array($result))foreach($row as $data)$sArray[]=$data;

// Read all sessionIDs from basket table

$result=mysql_query("SELECT sessionID FROM basket")
    or die(mysql_error());

// Stick them in an array

while($row=mysql_fetch_array($result))foreach($row as $data)$bArray[]=$data;

// Generate random id string

srand((float)microtime()*100000000);

$theID=md5(rand());

// Make sure that the id is unique

if(!count($sArray))$sArray=array();

if(!count($bArray))$bArray=array();

while(in_array($theID, $sArray) || in_array($theID, $bArray))$theID=md5(rand());

// Insert values in db

mysql_query("INSERT INTO sessions SET uid='".$theID."',theTime='".time()."'")

or die(mysql_error());

// Add sessionid to Getvars array

global $getVars;

$getVars["uid"]=$theID;
}

function destroySession($ID)
{

global $getVars, $sessions;

mysql_query("DELETE FROM sessions WHERE ID='".$ID."' LIMIT 1")

or die(mysql_error());

// Remove session ID from getVars

unset($getVars['uid']);
}

function readSessionVars($ID)
{

global $getVars, $sessions;

$result=mysql_query("SELECT * FROM sessions WHERE uid='".$ID."' AND theTime>='".(time()-(3600*8))."'")

or die(mysql_error());

// Stick session variables into an array

while($row=mysql_fetch_array($result))foreach($row as $i=>$data)$sessions[$i]=$data;

// Update session with current time

mysql_query("UPDATE sessions SET theTime='".time()."' WHERE ID='".$sessions["uid"]."' LIMIT 1")

or die(mysql_error());
}

function updateSession($ID, $var, $value)
{

global $getVars, $sessions;

// Update requested variable in session table

mysql_query("UPDATE sessions SET ".$var."='".$value."' WHERE ID='".$ID."' LIMIT 1")

or die(mysql_error());

readSessionVars($getVars["uid"]);
}

[laanes]

I have now added - or die(mysql_error()); to every function that used to have - or die("<font color=\"#FF0000\">ERROR {2.6}! Please navigate to a <a href=\"main.php?uid=".$sessions['uid']."\">different page</a> and then try this page again.</font>"); instead.

I have also tried to add a comment to every function to help myself to understand what each of them means. It is possible that I have misunderstood some of them in which case the comments would not be very helful.


function inDaList($addy)
{

$result=@mysql_query("SELECT email FROM mailinglist") or die(mysql_error());

while($row=@mysql_fetch_array($result))foreach($row as $data)$addyArray[]=strtoupper($data);

return in_array($addy, $addyArray);
}

// Session functions
function startSession()
{

// Read all sessionIDs from session table

$result=mysql_query("SELECT uid FROM sessions")

or die(mysql_error());

// Stick them in an array

while($row=mysql_fetch_array($result))foreach($row as $data)$sArray[]=$data;

// Read all sessionIDs from basket table

$result=mysql_query("SELECT sessionID FROM basket")
    or die(mysql_error());

// Stick them in an array

while($row=mysql_fetch_array($result))foreach($row as $data)$bArray[]=$data;

// Generate random id string

srand((float)microtime()*100000000);

$theID=md5(rand());

// Make sure that the id is unique

if(!count($sArray))$sArray=array();

if(!count($bArray))$bArray=array();

while(in_array($theID, $sArray) || in_array($theID, $bArray))$theID=md5(rand());

// Insert values in db

mysql_query("INSERT INTO sessions SET uid='".$theID."',theTime='".time()."'")

or die(mysql_error());

// Add sessionid to Getvars array

global $getVars;

$getVars["uid"]=$theID;
}

function destroySession($ID)
{

global $getVars, $sessions;

mysql_query("DELETE FROM sessions WHERE ID='".$ID."' LIMIT 1")

or die(mysql_error());

// Remove session ID from getVars

unset($getVars['uid']);
}

function readSessionVars($ID)
{

global $getVars, $sessions;

$result=mysql_query("SELECT * FROM sessions WHERE uid='".$ID."' AND theTime>='".(time()-(3600*8))."'")

or die(mysql_error());

// Stick session variables into an array

while($row=mysql_fetch_array($result))foreach($row as $i=>$data)$sessions[$i]=$data;

// Update session with current time

mysql_query("UPDATE sessions SET theTime='".time()."' WHERE ID='".$sessions["uid"]."' LIMIT 1")

or die(mysql_error());
}

function updateSession($ID, $var, $value)
{

global $getVars, $sessions;

// Update requested variable in session table

mysql_query("UPDATE sessions SET ".$var."='".$value."' WHERE ID='".$ID."' LIMIT 1")

or die(mysql_error());

readSessionVars($getVars["uid"]);
}

And there we are:

Table 'swansea3_locktech.sessions' doesn't exist

I guess the next thing now is to find out where is the correct sql file located as the one i imported does not have all the tables needed and can not therefore be the right one.

Re-hosting a website which isn't developed by yourself and is without any documentation seems to be a whole lot of fun.

[laanes]

After re-importing the database with the missing sessions table, the website came up, hurray! But with missing features - can not get the products from the database.

No Products Found.
Sorry, but there are no products in this section at the moment. The products are constantly being updated, however. Please try again later or contact us.

I found this line in a file is called groups.php

<td height="416" valign="top" class="mainbold"><?php if($totalGroups>0){?><img src="grp_pics/<?php echo $groupDetails["PG"] ?>.jpg" alt="Group Picture" galleryimg="no"><br><img src="imgz/pixel.gif" width="306" height="5"><br> <?php echo $groupDetails["GPText"] ?><?php }else{?><p class="noresult">No Products Found.</p><p class="mainbold">Sorry, but there are no products in this section at the moment. The products are constantly being updated, however. Please try again later or <a href="mailto:sales@lock-tech.co.uk" class="link1" onmouseover="window.status='Send us an Email.'; return true">contact us</a>.</p><?php }?></td>

What is that telling me?

Would there be a way of adding an or die element into that line instead of that please try again later message?

[laanes]

Or,

it fails before it even gets to that line - when trying to select second level sub groups in the database?

groups.php:

<?php
include 'scrptz/functions.php';

// Page vars
$thisPage=$getVars["page"];
if($thisPage<1)$thisPage=1;
$firstGroup=($thisPage*16)-16;

// Get group details and stick them into an array
$qMain="SELECT * FROM PGroups WHERE PG = '".$getVars["prodg"]."'";
$result=mysql_query($qMain)
or die("<font color=\"#FF0000\">ERROR {9.1}! Please navigate to a <a href=\"main.php?uid=".$getVars['uid']."\">different page</a> and then try this page again.</font>");
$groupDetails=mysql_fetch_array($result);

// Get all sub groups in current product group
$qMain="SELECT * FROM SubG WHERE ProdG = '".$getVars["prodg"]."'";
$result=mysql_query($qMain)
or die("<font color=\"#FF0000\">ERROR {9.2}! Please navigate to a <a href=\"main.php?uid=".$getVars['uid']."\">different page</a> and then try this page again.</font>");

// Stick sub groups in a 2D associative array
$j=0;
while ($row=mysql_fetch_array($result))
{

foreach($row as $i=>$data)$array[$j][$i]=$data;

$j++;
}

// Calculate vars for navigation
$totalGroups=$j;
$totalPages=ceil($totalGroups/16);

// Set page title (for bookmark)
$pageTitle=$groupDetails["GPname"];

// Set top title
if($totalGroups>0){$topTitle="VIEW PRODUCTS";}else{$topTitle="ERROR";}
?>
<html>
<head>
<script language="JavaScript" type="text/javascript">var theID="<?php echo $getVars['uid']; ?>";</script>
<script language="JavaScript" src="scrptz/content.js" type="text/javascript"></script>
<script language="JavaScript" src="scrptz/menu.js" type="text/javascript"></script>
<script language="JavaScript" src="scrptz/scripts.js" type="text/javascript"></script>
</head>
<body background="imgz/bg.gif" leftmargin="0" topmargin="0" marginheight="0" marginwidth="0"<?php echo $notify ?>>
<?php include("top.php"); ?>
<table width="952" height="509" border="0" cellpadding="0" cellspacing="0" class="maintext">
<?php if($sessions['accCode']){?><form action="http://www.lock-tech.co.uk/index.php" method="post" name="logout" target="_parent"><input name="account" type="hidden" value="<?php echo $sessions['accCode']; ?>"><input name="killSession" type="hidden" value="<?php echo $getVars['uid']; ?>"></form><?php }?>
  <tr> 
    <td width="1" rowspan="5" bgcolor="#000000"></td>
    <td height="21" background="imgz/topbar.gif" bgcolor="#14359E">&nbsp;</td>
    <td height="21" colspan="5" valign="middle" background="imgz/topbar.gif" bgcolor="#14359E" class="mainyellow"><?php include("scrptz/dd_menu.php"); ?></td>
    <td height="21" background="imgz/topbar.gif" bgcolor="#14359E">&nbsp;</td>
    <td width="1" rowspan="5" bgcolor="#000000"></td>
  </tr>
  <tr> 
    <td width="5" rowspan="3">&nbsp;</td>
    <td width="306" height="30" valign="bottom" class="title2"><?php echo $groupDetails["GPname"] ?></td>
    <td width="11" rowspan="3"><img src="imgz/maindiv.gif" width="11" height="466"></td>
    <td width="306" height="30" align="center" valign="bottom" class="title2"><?php if($totalGroups>0){?><a href="g_view.php?pgroup=<?php echo $groupDetails["PG"] ?>&amp;uid=<?php echo $getVars['uid']; ?>" class="link4" onmouseover="window.status='View List of all Products in <?php echo $groupDetails["GPname"] ?>'; return true">VIEW ALL</a> | <a href="g_browse.php?pgroup=<?php echo $groupDetails["PG"] ?>&amp;uid=<?php echo $getVars['uid']; ?>" class="link4" onmouseover="window.status='Browse all Products in <?php echo $groupDetails["GPname"] ?>'; return true">BROWSE ALL</a><?php }?></td>
    <td width="11" rowspan="3"><img src="imgz/maindiv.gif" width="11" height="466"></td>
    <td width="306" height="30" align="center" valign="bottom">&nbsp;</td>
    <td width="5" rowspan="3">&nbsp;</td>
  </tr>
  <tr> 
    <td height="20" valign="top" class="mainbold"></td>
    <td width="306" rowspan="2" valign="top" class="maintext">
      <?php for($i=$firstGroup; $i<($firstGroup+8) && $i<$totalGroups; $i++){?>
      <a href="sub.php?PSubG=<?php echo $array[$i]["SPG"] ?>&amp;uid=<?php echo $getVars['uid']; ?>" class="link1" onmouseover="window.status='View Products in <?php echo $array[$i]["SPGname"] ?>'; return true"><?php echo $array[$i]["SPGname"] ?></a><br>

<?php

// Get all subsubs in current sub group

$qMain="SELECT * FROM SubSubG WHERE SPG = '".$array[$i]["SPG"]."'";

$result=mysql_query($qMain)

or die("<font color=\"#FF0000\">ERROR {9.3}! Please navigate to a <a href=\"main.php?uid=".$getVars['uid']."\">different page</a> and then try this page again.</font>");

// Print subsubs

while ($row=mysql_fetch_array($result))

{

?>

[<a href="subsub.php?PSubSubG=<?php echo $row["SSPG"]?>&amp;uid=<?php echo $getVars['uid']; ?>" class="link3" onmouseover="window.status='View Products in <?php echo $row["SSPGName"]?>'; return true"><?php echo $row["SSPGName"]?></a>]&nbsp;

<?php

}

?>

<br><br>

<?php }?></td>
    <td width="306" rowspan="2" valign="top" class="maintext">
      <?php for($i=$firstGroup+8; $i<($firstGroup+16) && $i<$totalGroups; $i++){?>
      <a href="sub.php?PSubG=<?php echo $array[$i]["SPG"] ?>&amp;uid=<?php echo $getVars['uid']; ?>" class="link1" onmouseover="window.status='View Products in <?php echo $array[$i]["SPGname"] ?>'; return true"><?php echo $array[$i]["SPGname"] ?></a><br>

<?php

// Get all subsubs in current sub group

$qMain="SELECT * FROM SubSubG WHERE SPG = '".$array[$i]["SPG"]."'";

$result=mysql_query($qMain)

or die("<font color=\"#FF0000\">ERROR {9.4}! Please navigate to a <a href=\"main.php?uid=".$getVars['uid']."\">different page</a> and then try this page again.</font>");

// Print subsubs

while ($row=mysql_fetch_array($result))

{

?>

[<a href="subsub.php?PSubSubG=<?php echo $row["SSPG"]?>&amp;uid=<?php echo $getVars['uid']; ?>" class="link3" onmouseover="window.status='View Products in <?php echo $row["SSPGName"]?>'; return true"><?php echo $row["SSPGName"]?></a>]&nbsp;

<?php

}

?>

<br><br>
<?php }?></td>
  </tr>
  <tr> 
    <td height="416" valign="top" class="mainbold"><?php if($totalGroups>0){?><img src="grp_pics/<?php echo $groupDetails["PG"] ?>.jpg" alt="Group Picture" galleryimg="no"><br><img src="imgz/pixel.gif" width="306" height="5"><br> <?php echo $groupDetails["GPText"] ?><?php }else{?><p class="noresult">No Products Found.</p><p class="mainbold">Sorry, but there are no products in this section at the moment. The products are constantly being updated, however. Please try again later or <a href="mailto:sales@lock-tech.co.uk" class="link1" onmouseover="window.status='Send us an Email.'; return true">contact us</a>.</p><?php }?></td>
  </tr>
  <tr> 
    <td width="5" height="22" background="imgz/btmbar.gif" bgcolor="#14359E">&nbsp;</td>
    <td width="306" height="22" align="center" valign="top" background="imgz/btmbar.gif" bgcolor="#14359E"><a href="javascript:history.back()" onmouseover="prev_btn.src='imgz/prev2.gif';window.status='Previous Page'; return true" onmouseout="prev_btn.src='imgz/prev.gif'"><img name="prev_btn" src="imgz/prev.gif" width="124" height="16" border="0"></a></td>
    <td width="11" height="22" bgcolor="#14359E"><img src="imgz/btmdiv.gif" width="11" height="22"></td>
    <td width="306" height="22" align="center" background="imgz/btmbar.gif" bgcolor="#14359E" class="nav"><? include 'scrptz/nav.php' ?></td>
    <td width="11" height="22" bgcolor="#14359E"><img src="imgz/btmdiv.gif" width="11" height="22"></td>
    <td width="306" height="22" align="center" valign="top" background="imgz/btmbar.gif" bgcolor="#14359E"><a href="javascript:directLink('<?php echo $prodLink; ?>','<? echo $pageTitle ?>')" onmouseover="link_btn.src='imgz/link2.gif'; window.status='Direct Link to This Page'; return true" onmouseout="link_btn.src='imgz/link.gif'"><img name="link_btn" src="imgz/link.gif" alt="" width="182" height="16" border="0"></a></td>
    <td width="5" height="22" background="imgz/btmbar.gif" bgcolor="#14359E">&nbsp;</td>
  </tr>
</table>
</body>
</html>

[laanes]

I am not getting any further with it.

Anyone willing to help?

[fenway]

So have you proven you can actually connect?