qenit
Posts: 6
|
| Posted: 11/08/2007, 6:48 PM |
|
Hai,
I failed to login into the system and this fatal error message popup. I want to know how to solve this problem. Really need somebody help. Thnks
Fatal error: Call to undefined function mysql_escape_string() in C:\inetpub\wwwroot\dbDirectory\db_mysql.php on line 424
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 11/08/2007, 7:49 PM |
|
qenit
What version of CCS are you using?? What version of MySQL are you using?? Are you using the MySQL or MySQLi CCS library?? We need more information.
|
|
|
|
qenit
Posts: 6
|
| Posted: 11/08/2007, 8:02 PM |
|
Thank for your reply.
im using CCS version 3.2.0.2
mysql: MySQL Server 5.0
|
|
|
|
qenit
Posts: 6
|
| Posted: 11/08/2007, 10:34 PM |
|
Hai,
im also got this error message when i want to show database table to the IE
Fatal error: Call to undefined function mysql_pconnect() in C:\inetpub\wwwroot\dbDirectory\db_mysql.php on line 97
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 11/11/2007, 10:54 PM |
|
qenit
When you setup your datasource for the webserver what db library do you use (MySQL or MySQLi)??
|
|
|
|
qenit
Posts: 6
|
| Posted: 11/11/2007, 11:08 PM |
|
mambobrown,
i use mySQL datasource.
One more thing;
When i opened the mySQL Control Center, and try to input some data into the table, This error message have popup:
[Local MySQL Server] ERROR 1146: Table 'cpit.1' doesn't exist
I really need some guides and solution to solve my problem.
Thank you
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 11/13/2007, 8:03 PM |
|
qenit
I would definitely change your MySQL library to MySQLi (and republish the project). Secondly, I would change from using MySQL Control Center to the New MySQL database suite of tools: MySQL Administrator and MySQL Query Browser ( http://mysql.com/products/tools/ ). Let me know what happens after you change your MySQL library to MySQLi.
|
|
|
|
qenit
Posts: 6
|
| Posted: 11/13/2007, 8:41 PM |
|
Thank you for you reply.
Its work! I can solve my problem by following what you have told me by changing the DB tools to MySQL administrator and MySQL Query Browser. Besides, i have changed the data source from mySQL to ODBC (it quite slow, but it working)
THANK YOU AGAIN mamboBROWN :)
|
|
|
|
