Custom Stock update script refusing to work

[longstockings]

Hi

My customer has a shoe store. I took over the hosting of this site about a year ago and have found that the previous web designer had a stock update script that could be run via cron. I've adjusted the database settings but I keep getting connection errors.

Here is the code

<?php

require'db_connect.php';

$arrLines = file('http://www.pleaserusa.com/download/Inv_stat.csv');
$arrLines = array_slice($arrLines, 1);
foreach ($arrLines as $line)
{
list($productCode, $size, $inStock) = explode(',',$line);
updateInsert($productCode, $size, $inStock);
}

function updateInsert($productCode, $size, $inStock)
{
if($inStock == '"YES"' || $inStock == '"LOW"')
{
$inStock = 1;
}
else
{
$inStock = 0;
}
$size = str_replace('"','', $size);


$sql_in = "REPLACE INTO tblPleaserStock (strProductCode, strSize, bolInStock) VALUES ($productCode, '$size', $inStock)";
mysql_query($sql_in) or die ("Error Inserting with query ".$sql_in);

$sql_up = "UPDATE tblPleaserStock SET bolInStock = $inStock WHERE strProductCode = $productCode AND strSize = '$size'";
mysql_query($sql_up) or die ("Error Updating with query ".$sql_up);
}

?>

and the error is

Warning: mysql_query() [function.mysql-query]: Access denied for user 'lingerie'@'localhost' (using password: NO) in /home/lingerie/public_html/scripts/update_stock.php on line 29

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/lingerie/public_html/scripts/update_stock.php on line 29
Error Inserting with query REPLACE INTO tblPleaserStock (strProductCode, strSize, bolInStock) VALUES ("AC103/B", '1', 1)

The database user is actually lingerie_zen and a password is set. The website is running on a standard cpanel server.
Any advice or help to get this script working correctly would be great.

Thanks

[kobra]

What is in your "db_connect.php" file??

[longstockings]

<?php
define('host', 'localhost');
define('username', 'lingerie_zen');
define('password', '******');
define('dbname', 'lingerie_zen');
?>

[kobra]

I would compare these settings to those in the cart configure.php file

[longstockings]

I took these settings from the Zen Cart configure file.

[kobra]

Does that user have "all privileges" allowed?

[longstockings]

Yes they do. I set up a new user just for this purpose.

[kobra]

Warning: mysql_query() [function.mysql-query]: Access denied for user 'lingerie'@'localhost' (using password: NO)

There is a reason that access is denied

[DrByte]

Warning: mysql_query() [function.mysql-query]: Access denied for user 'lingerie'@'localhost' (using password: NO) in /home/lingerie/public_html/scripts/update_stock.php on line 29

Um, "(using password: NO)" means your custom script isn't passing a password.