Re: Fatal error
On 8/3/06, Martin Jespersen [EMAIL PROTECTED] wrote: Looks like drupal had an error when doing the backup - mysql is complaining over the fact that your backup.sql file contains a html formated fatal error message. Kaushal Shriyan wrote: Hi ALL I have taken backup of http://mydomain.com/?q=admin/database through drupal 4.6.3 by selecting all tables and it asked me to save as backup.sql. Now when i run [EMAIL PROTECTED] root]# mysql -u kaushal -h bdc31096e.in.office.aol.com -p drupal /home/kaushal/drupal/backup.sql Enter password: ERROR 1064 at line 55817: You have an error in your SQL syntax near 'br / bFatal error/b: Maximum execution time of 30 seconds exceeded in b' at line 1 [EMAIL PROTECTED] root]# I get the above error Any clue Please let me know if you need more info on this issue Thanks and Regards Kaushal Hi Martin How do i fix this issue Thanks Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fatal error
1) Throw away the backup.sql as it is useless 2) Talk to the guys who made drupal and make them aware of the flaw in their software 3) Change the php.ini settings for maximum execution time next time try to place non-mysql related questions elsewhere ;) Kaushal Shriyan wrote: On 8/3/06, Martin Jespersen [EMAIL PROTECTED] wrote: Looks like drupal had an error when doing the backup - mysql is complaining over the fact that your backup.sql file contains a html formated fatal error message. Kaushal Shriyan wrote: Hi ALL I have taken backup of http://mydomain.com/?q=admin/database through drupal 4.6.3 by selecting all tables and it asked me to save as backup.sql. Now when i run [EMAIL PROTECTED] root]# mysql -u kaushal -h bdc31096e.in.office.aol.com -p drupal /home/kaushal/drupal/backup.sql Enter password: ERROR 1064 at line 55817: You have an error in your SQL syntax near 'br / bFatal error/b: Maximum execution time of 30 seconds exceeded in b' at line 1 [EMAIL PROTECTED] root]# I get the above error Any clue Please let me know if you need more info on this issue Thanks and Regards Kaushal Hi Martin How do i fix this issue Thanks Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fatal error
Looks like drupal had an error when doing the backup - mysql is complaining over the fact that your backup.sql file contains a html formated fatal error message. Kaushal Shriyan wrote: Hi ALL I have taken backup of http://mydomain.com/?q=admin/database through drupal 4.6.3 by selecting all tables and it asked me to save as backup.sql. Now when i run [EMAIL PROTECTED] root]# mysql -u kaushal -h bdc31096e.in.office.aol.com -p drupal /home/kaushal/drupal/backup.sql Enter password: ERROR 1064 at line 55817: You have an error in your SQL syntax near 'br / bFatal error/b: Maximum execution time of 30 seconds exceeded in b' at line 1 [EMAIL PROTECTED] root]# I get the above error Any clue Please let me know if you need more info on this issue Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fatal error: Can't open privilege tables: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2)
Hello. Usually such error occurs on Windows boxes. If you can apply recomendations for Windows to FreeBSD :), look at: http://dev.mysql.com/doc/mysql/en/Windows_troubleshooting.html Can you upgrade to 4.0.22 or 4.1.7? Ricardo David Martins [EMAIL PROTECTED] wrote: Hi I am trying to run mysql 4.0.21 server on a freeBSD 5.3 box. I tried to run mysqld_safe to add a root password but i can't seem to run the safe command because it shuts down immediately. The following error is presented to me: Fatal error: Can't open privilege tables: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2) I would like it to load the latin1.conf charset. I can't find any variable that influences this choice. Probably there is something not configured or the configuration isn't supported. Anyway I would like to know how to choose this. I installed the binary freebsd package which is suppose to be very reliable to a quick start. Thanks --=20 Ricardo David Martins ___= __ AVISO Esta mensagem (incluindo quaisquer anexos) pode conter informa=E7=E3o confidencial para uso exclusivo do destinat=E1rio. Se n=E3o for o destinat=E1rio pretendido, n=E3o dever=E1 usar, distribuir ou copiar este e-mail. Se recebeu esta mensagem por engano, por favor informe o emissor e elimine-a imediatamente. Obrigado. DISCLAIMER This e-mail (including any attachments) may contain confidential information for exclusive use of its recipient. If you are not the intended recipient you must not use, distribute or copy this e-mail. If you have received this e-mail in error please notify the sender and delete it immediately. Thank You. ___= __ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fatal error: Can't open privilege tables: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2)
Have you run mysql_install_db yet? Have you read the freebsd platform notes http://dev.mysql.com/doc/mysql/en/FreeBSD.html and the post-install instructions http://dev.mysql.com/doc/mysql/en/Post-installation.html? If not, I'd suggest starting there. If that doesn't help, write back with some more details, such as: Is this your first attempt to start the server after install? When you say, the binary freebsd package, which do you mean, one of the two from mysql.com, or the packages from freebsd.org? You mention configuration. What, if any, configuration have you done? (Mysql ought to start fine with default settings.) Michael Ricardo David Martins wrote: Hi I am trying to run mysql 4.0.21 server on a freeBSD 5.3 box. I tried to run mysqld_safe to add a root password but i can't seem to run the safe command because it shuts down immediately. The following error is presented to me: Fatal error: Can't open privilege tables: File '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2) I would like it to load the latin1.conf charset. I can't find any variable that influences this choice. Probably there is something not configured or the configuration isn't supported. Anyway I would like to know how to choose this. I installed the binary freebsd package which is suppose to be very reliable to a quick start. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fatal Error on db
John [EMAIL PROTECTED] wrote: Not a MySQL error. it's a bug in the application. I am using php/mysql for a program and everything installed fine but when I try to open it up I get this error: Fatal Error : Couldn't find local config file. File Name : /program/admin/index.php Error Code : err01 Time :18 Oct 2004, 07:19:44 pm PHP Fatal error: Call to undefined function: make_last_processes() in /home/main/public_html/app/program/admin/index.php on line 16 Line 16 is : make_last_processes(false); Help please. :) ___ Do you Yahoo!? Express yourself with Y! Messenger! Free. Download now. http://messenger.yahoo.com -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fatal error
This means that the mod for mySQL is not installed. On the CD there is a package for PHP-MySQL. install that and then restart. Hope this helps. - Original Message - From: Pikasz Gyorgy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, December 29, 2002 1:11 PM Subject: Fatal error Hi all!!! Red Hat 7.3, MySQL, PHP I tried to connect to MySQL server with my login name and password, with the next command in my php's file: mysql_connect(localhost, webuser, webpass) In the mysql.user table exist webuser/webpass and in mysql.db table too for an specified database. ...then appear the next error and I don't understand why: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/vk/vk.php on line 11 Thanks picas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fatal error
1. This is a PHP syntax question. 2. The PHP manual gives a specific example in the MySQL Functions. $link = mysql_connect(localhost, webuser, webpass) Doug On Sun, 29 Dec 2002 20:11:14 +0200, Pikasz Gyorgy wrote: Hi all!!! Red Hat 7.3, MySQL, PHP I tried to connect to MySQL server with my login name and password, with the next command in my php's file: mysql_connect(localhost, webuser, webpass) In the mysql.user table exist webuser/webpass and in mysql.db table too for an specified database. ...then appear the next error and I don't understand why: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/vk/vk.php on line 11 Thanks picas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fatal error
Pikasz, ...then appear the next error and I don't understand why: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/vk/vk.php on line 11 Looks like MySQL has not been enabled in your PHP installation. Check with phpinfo() to find out. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Doug Thompson [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Pikasz Gyorgy [EMAIL PROTECTED] Sent: Sunday, December 29, 2002 8:58 PM Subject: Re: Fatal error 1. This is a PHP syntax question. 2. The PHP manual gives a specific example in the MySQL Functions. $link = mysql_connect(localhost, webuser, webpass) Doug On Sun, 29 Dec 2002 20:11:14 +0200, Pikasz Gyorgy wrote: Hi all!!! Red Hat 7.3, MySQL, PHP I tried to connect to MySQL server with my login name and password, with the next command in my php's file: mysql_connect(localhost, webuser, webpass) In the mysql.user table exist webuser/webpass and in mysql.db table too for an specified database. ...then appear the next error and I don't understand why: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/vk/vk.php on line 11 Thanks picas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: fatal error
compile php with mysql-support, i.e. configure --with-mysql and so on. If you are on a redhat system and using the installed apache-webserver, then there should be a package php-mysql*.rpm or similar which needs to be installed. Thats not a real mysql-problem. ;-) Thomas On Sun, 1 Dec 2002 07:34:19 +1000 Brendan Mansell [EMAIL PROTECTED] wrote: Hi all, I'm not really sure if I'm posting this to the right list or not, but I've recently installed mysql on a Linux machine in order to learn some mysql/php stuff. However, I've obviously configured something wrongly and can't work out what. The output i get when I try to do anything mysql-ish from my php code is: Fatal error: Call to undefined function: mysql_connect() in /var/www/testphp.php on line 7 To me this says 'mysql isn't installed as far as I can tell' since the connect function is the first thing it does.. but I've looked through documentation and configuration files and I'm stumped. Any help would be appreciated. Thanks, Brendan. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Fatal error: Please read Security section of the manual to find out how to run mysqld as root!
you say you chown -R mysql /usr/local/mysql/data, yet the error shows mysql trying to start with databases from /var/lib/mysql. check your startup script for basedir and datadir settings. -Original Message- From: Kenneth Illingsworth [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 3:30 PM To: Subject: Fatal error: Please read Security section of the manual to find out how to run mysqld as root! This happens when I try to start the mysql daemon. I have checked the manual, but cannot fathom what else I am supposed to do. Here is what has been done so far: ./scripts//mysql_install_db seemed to initialize the MySQL db's ok. I also executed the following statements without issue: chown -R root /usr/local/mysql chown -R mysql /usr/local/mysql/data chgrp -R mysql /usr/local/mysql ./bin/mysqladmin --version dows return the version of MySQL ok. ./bin/safe_mysqld --user=mysql and got the following: [root@cofr3 mysql]# ./bin/safe_mysqld --user=mysql Starting mysqld daemon with databases from /var/lib/mysql 021122 12:31:41 mysqld ended Regards, Ken Illingsworth - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Fatal error: Please read Security section of the manual to find out how to run mysqld as root!
i see. there is an option in my.cnf which says which user to run mysqld as. change this to mysql. make sure that mysql is a real user on your system. also, be sure to set the full path to the basedir and datadir in the my.cnf user = mysql basedir = /usr/local/mysql datadir = /usr/local/mysql/data or whatever your paths are. -Original Message- From: Kenneth Illingsworth [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 4:06 PM To: [EMAIL PROTECTED] Subject: RE: Fatal error: Please read Security section of the manual to find out how to run mysqld as root! Thank you for pointing that our. I never edited the my.cnf file, and those two variables were way off. I edited them to their correct values and here is the result: [root@cofr3 mysql]# ./bin/safe_mysqld --user=mysql [1] 4774 [root@cofr3 mysql]# Starting mysqld daemon with databases from /mysql/data 021122 15:57:25 mysqld ended [1]+ Done./bin/safe_mysqld --user=mysql -- I believe that this change is certainly a step in the right direction. However, the original error is quite persistant: [root@cofr3 mysql]# ./bin/mysqld -L /mysql/share/mysql/english Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 021122 16:00:58 Aborting 021122 16:00:58 ./bin/mysqld: Shutdown Complete Regards, Ken Illingsworth Shon Stephens [EMAIL PROTECTED] 11/22/02 03:40PM you say you chown -R mysql /usr/local/mysql/data, yet the error shows mysql trying to start with databases from /var/lib/mysql. check your startup script for basedir and datadir settings. -Original Message- From: Kenneth Illingsworth [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 3:30 PM To: Subject: Fatal error: Please read Security section of the manual to find out how to run mysqld as root! This happens when I try to start the mysql daemon. I have checked the manual, but cannot fathom what else I am supposed to do. Here is what has been done so far: ./scripts//mysql_install_db seemed to initialize the MySQL db's ok. I also executed the following statements without issue: chown -R root /usr/local/mysql chown -R mysql /usr/local/mysql/data chgrp -R mysql /usr/local/mysql ./bin/mysqladmin --version dows return the version of MySQL ok. ./bin/safe_mysqld --user=mysql and got the following: [root@cofr3 mysql]# ./bin/safe_mysqld --user=mysql Starting mysqld daemon with databases from /var/lib/mysql 021122 12:31:41 mysqld ended Regards, Ken Illingsworth - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Fatal error when using --skip-grant-tables option
Robert, Saturday, November 09, 2002, 10:23:03 PM, you wrote: RJ I tried using the instructions I found in the MySQL manual and got hung RJ up on starting the MySQL server in an unsecured state. The instructions RJ say to start mysqld with the --skip-grant-tables option. When I do I RJ get a Fatal Error: Please read Security section of the manual to find RJ out how to run mysqld as root. Then the server shuts down. RJ I tried looking in the documentation but found nothing. Run: shell safe_mysqld --skip-grant-tables -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fatal Error: Call to undefined function: mysql_connect()
1. I found I had a RPM Install of PHP and a compiled version. (Off my book cdrom) :-(( happened to me 2 4. I want to start from scratch but don't want to have to re-format nah. you've rpm -e'd the rpm. I had to build from scratch to compile mysql + php in as I couldn't find an off-the-shelf version which had 'em. 6. Could someone suggest where i could get a PHP copy that supports MYSQL ? http://www.php.net Donna - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fatal Error: Call to undefined function: mysql_connect()
On Thursday, 25. April 2002 08:17, Andrew Rich wrote: 5. I have determined I was running a copy of PHP that did not have MYSQL support compiled in. Yes, looks like this is an an very old version, without mysql-support. 6. Could someone suggest where i could get a PHP copy that supports MYSQL ? Go to www.php.net or some of the mirrors. The rpm-package has integrated mysql-support. Or download the source-tarball and compile it. The libmysql is integrated in the tarball to. Regards Georg (query,mysql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php