Hello,
I am new to zymic, and everything was fine until now..but I am wondering why is there no support for mySQL PDO?
the phpinfo() shows that sqlite, sqlite2 are available.. how come no mysql? "PDO drivers sqlite2, sqlite "
And this is the error I get on my site:
"ERRNO: 256 TEXT: could not find driver"
Thank you for the help.
Full Version: Pdo Mysql Driver
Should be in now, please check 
Thank you for the quick reply. I am performing some tweaks on the database, and I will report back here once I know if it's working or not.
Regards,
ochho.
Regards,
ochho.
I am trying to change the database through php script, because phpmyadmin doesnt work.
Everything was fine while creating Tables and populating data, but I can't create any SQL stored procedures, any idea why?
"Access denied for user 'prana_admin'@'localhost' to database 'prana_prana'"
I checked the info, and everything is good.. database="prana_prana", username="prana_admin" domain="prana.uuuq.com"
Here is the script:
EDIT: Resolved, Thank you Bread!
Everything was fine while creating Tables and populating data, but I can't create any SQL stored procedures, any idea why?
"Access denied for user 'prana_admin'@'localhost' to database 'prana_prana'"
I checked the info, and everything is good.. database="prana_prana", username="prana_admin" domain="prana.uuuq.com"
Here is the script:
CODE
<?php
$con = mysql_connect('localhost', 'prana_admin', '*****');
if(!$con){
echo 'Mysql did not connect: ' . mysql_error();
die();
}
$db_conn = mysql_select_db('prana_prana', $con);
if(!$db_conn){
echo mysql_error();
die();
} else {
echo 'Database selected <br />';
}
$sql = "CREATE PROCEDURE `catalog_get_categories_list`()
BEGIN
SELECT category_id, en_name, fr_name FROM category ORDER BY category_id;
END" ;
$query = mysql_query($sql);
if(!$query){
echo 'Table not created '.mysql_error();
die();
} else {
echo 'Table Created';
}
?>
$con = mysql_connect('localhost', 'prana_admin', '*****');
if(!$con){
echo 'Mysql did not connect: ' . mysql_error();
die();
}
$db_conn = mysql_select_db('prana_prana', $con);
if(!$db_conn){
echo mysql_error();
die();
} else {
echo 'Database selected <br />';
}
$sql = "CREATE PROCEDURE `catalog_get_categories_list`()
BEGIN
SELECT category_id, en_name, fr_name FROM category ORDER BY category_id;
END" ;
$query = mysql_query($sql);
if(!$query){
echo 'Table not created '.mysql_error();
die();
} else {
echo 'Table Created';
}
?>
EDIT: Resolved, Thank you Bread!
QUOTE(ochho @ Jun 15 2009, 02:17 AM) 
Hello,
I am new to zymic, and everything was fine until now..but I am wondering why is there no support for mySQL PDO?
the phpinfo() shows that sqlite, sqlite2 are available.. how come no mysql? "PDO drivers sqlite2, sqlite "
And this is the error I get on my site:
"ERRNO: 256 TEXT: could not find driver"
Thank you for the help.
I am new to zymic, and everything was fine until now..but I am wondering why is there no support for mySQL PDO?
the phpinfo() shows that sqlite, sqlite2 are available.. how come no mysql? "PDO drivers sqlite2, sqlite "
And this is the error I get on my site:
"ERRNO: 256 TEXT: could not find driver"
Thank you for the help.
Hello,
I'm new here, i have same problem with ochho.
The error i've got on my site:
Fatal error: Uncaught exception 'Exception' with message 'could not find driver' in /www/vndv.com/s/u/r/suryadharma/htdocs/config.php
'could not find driver' i think its mean the config file can't find PDO for Mysql
Thank's for the help
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.