skellish

Hi, I'm having the exact same problem. Did you every resolve you situation? Scott

Hi, I'm having the exact same problem. Did you every resolve you situation? Scott

Hello Geoff, Thanks for the response. Know about the password -- thanks I looked at the bug you mentioned but fail to see how its related to my issue. I'm getting an Access Denied error, not an error about bringing back the result set. I also did not mention that I'm using PDO to access the database. I don't have the version in front of me, but I will check

I have a PHP/MySQL site I developed using WAMP on my local dev box and which I now trying to move to this site. When the PHP code attempts to execute a stored procedure, I get the following error message: ERRNO: 256 TEXT: SQLSTATE[42000]: Syntax error or access violation: 1370 execute command denied to user 'skellish_eshop'@'localhost' for routine 'skellish_eshop.catalog_count_products_on_catalog' LOCATION: /home1/skellish/public_html/tshirtshop/business/database_handler.php, line 171, at November 28, 2010, 6:13 pm Showing backtrace: trigger_error("SQLSTATE[42000]: Syntax error or access violation: 1370 execute ...", "256") # line 171, file: /home1/skellish/public_html/tshirtshop/business/database_handler.php DB Info from Config.php is: // Database connectivity setup (skellish_eshop) define('DB_PERSISTENCY', 'true'); define('DB_SERVER', 'localhost'); define('DB_USERNAME', 'skellish_eshop'); define('DB_PASSWORD', 'eshoppwd'); define('DB_DATABASE', 'skellish_eshop'); If I try to execute a procedure from phpMyAdmin, I get the following error: #1312 - PROCEDURE skellish_eshop.catalog_count_products_on_catalog can't return a result set in the given context But, I can connect using MySQL Workbench from my local development PC (I setup Remote Database Access Host), and execute a stored procedure without any issue. Any ideas? Scott

I'm new to PHP. I'm getting the following error when executing the code below. I've tried reinstalling both PEAR Mail and PEAR Net/SMTP but the problem remains. Can someone tell me what I'm doing wrong? Error: Warning: include_once(Net/SMTP.php) [function.include-once]: failed to open stream: No such file or directory in /usr/lib/php/Mail/smtp.php on line 348 Warning: include_once() [function.include]: Failed opening 'Net/SMTP.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /usr/lib/php/Mail/smtp.php on line 348 Fatal error: Class 'Net_SMTP' not found in /usr/lib/php/Mail/smtp.php on line 349 Code: <?php require_once 'Mail.php'; $from = "Customer Service <customerservice@softsys.heliohost.org>"; $to = "msk7 <msk7@softsys.heliohost.org>"; $subject = "Hi!"; $body = "Hi,\n\nHow are you?"; $host = "ssl://stevie.heliohost.org"; $host = "65.19.143.2"; $port = "465"; $username = "customerservice+softsys.heliohost.org"; $password = "mypassword"; $headers = array ('From' => $from, 'To' => $to, 'Subject' => $subject); $smtp = Mail::factory('smtp', array ('host' => $host, 'port' => $port, 'auth' => true, 'username' => $username, 'password' => $password)); $mail = $smtp->send($to, $headers, $body); if (PEAR::isError($mail)) { echo("<p>" . $mail->getMessage() . "</p>"); } else { echo("<p>Message successfully sent!</p>"); } ?>