[PHP] Re: MySQL error
Wessley Roche wrote:
I'm having a problem with the following code:
$sql = LOAD DATA LOCAL INFILE '/path/to/file.txt' INTO TABLE `mytable`
FIELDS TERMINATED BY '\t' ESCAPED BY '\' LINES TERMINATED BY '\n';
mysql_query($sql) or die('brbr'.mysql_error());
I get this MySQL error:
You have an error in your SQL syntax. Check the manual that corresponds
to your MySQL server version for the right syntax to use near ''' at
line 2
You're on the wrong list. You want the MySQL mailing list.
Just as a pointer, you probably want ESCAPED BY '\'' rather than
ESCAPED BY '\' (added a ' to close the first quote, as the second one
is escaped.
Jasper
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: MySQL Error 1251 / phpMyAdmin
You have mysql 4.1.8, but your php was built with the library for an earlier version, which, as the error message says, doesn't support the new, more secure authentication protocol. Your choices are to tell mysql to use the older, less-secure protocol, or build a copy of php using your current mysql client library. See the manual for more http://dev.mysql.com/doc/mysql/en/old-client.html. Michael GH wrote: I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: MySQL Error 1251 / phpMyAdmin
I am still new to the PHP scene could you tell me how I rebuild the PHP with the client library... On Mon, 07 Feb 2005 12:20:26 -0500, Michael Stassen [EMAIL PROTECTED] wrote: You have mysql 4.1.8, but your php was built with the library for an earlier version, which, as the error message says, doesn't support the new, more secure authentication protocol. Your choices are to tell mysql to use the older, less-secure protocol, or build a copy of php using your current mysql client library. See the manual for more http://dev.mysql.com/doc/mysql/en/old-client.html. Michael GH wrote: I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: MySQL Error 1251 / phpMyAdmin
The short answer is, download the php source and add --with-mysql=/your/path/to/mysql to your build options. The long answer is in the directions in the php manual http://us4.php.net/manual/en/install.unix.php. Michael GH wrote: I am still new to the PHP scene could you tell me how I rebuild the PHP with the client library... On Mon, 07 Feb 2005 12:20:26 -0500, Michael Stassen [EMAIL PROTECTED] wrote: You have mysql 4.1.8, but your php was built with the library for an earlier version, which, as the error message says, doesn't support the new, more secure authentication protocol. Your choices are to tell mysql to use the older, less-secure protocol, or build a copy of php using your current mysql client library. See the manual for more http://dev.mysql.com/doc/mysql/en/old-client.html. Michael GH wrote: I just installed phpMyAdmin 2.6.1 on my Windows Laptop with PHP Version 4.3.10 [Build Date Dec 14 2004 17:46:48] and mySql 4.1.8 I am receiving the enclosed error when I attempt to go into phpMyAdmin and do not know how to solve the issue... Any assistance would be greatful. Thank you Gary //## ERROR RECIEVED // Welcome to phpMyAdmin 2.6.1 phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. Error MySQL said: #1251 - Client does not support authentication protocol requested by server -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: mysql error
also try to: echo mysql_error(); after the select-query, it will tell you what went wrong. Thomas On Fri, 17 May 2002 18:45:07 +0100 [EMAIL PROTECTED] (Randum Ian) wrote: Hi all, I have got this code but I can get it to work, it doesnt make sense! snip ?php $host=localhost; $username=user; $password=pass; $database=admin; $mysqlconnect = mysql_connect($host, $username, $password) or die (Cannot connect to mySQL server, check it is running); mysql_select_db($database, $mysqlconnect) or die (Cannot connect to the database, check it is set right); $result = mysql_query(SELECT * FROM user); $count = mysql_num_rows($result); $counted = number_format($count); echo $counted; ? snip but I am getting this error - Warning: Supplied argument is not a valid MySQL result resource in /usr/home/e/a/eagadmin/public_html/main.php on line 14 but I dont understand why! Can anyone help? Regards, Ian. --- Randum Ian DJ / Reviewer / Webmaster, DancePortal (UK) Limited [EMAIL PROTECTED] http://www.danceportal.co.uk DancePortal.co.uk - Global dance music media -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: mysql error on win2k
It would help if you gave us some more information. If you look in your MySQL folder you will see a folder call include. In that folder there is file call mysqld_error.h, this a list of some of the errors you will encounter. This will help you track down the problems you are having, in the MySQl manual. 1016=can't open file. HTH Gary Sagar N Chand wrote: hi, i have installed win2k and configured apache and php4.0.6 but mysql is giving error 1016 or so. why is this happening. /sagar -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re: mysql error
Maybe you run out of diskspace?? Greets, Leon Elias wrote: Table is full? did you try searching MySql.com for Table is full error message? Andreas ) [EMAIL PROTECTED] wrote in message 000c01c10b81$c765aa60$8d0a@devel01">news:000c01c10b81$c765aa60$8d0a@devel01... hi all, my script was now working for month but now suddenly get this error: The table 'SQL90cb_0' is full SELECT DISTINCT t1.id,t1.textd FROM tblEntry AS t1,tblTopic AS t2 ORDER BY t2.named,t1.textd anyone know whats the problem ? thank you andreas -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re: mysql error, dont see why.. please help
Correct, SET must be before WHERE. Joseph CollegeSucks.com -Original Message- From: Tyler Longren [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 22, 2001 4:04 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP] mysql error, dont see why.. please help Shouldn't it be: mysql_query(UPDATE user_polls SET url = '$file_name' WHERE uid = '$UserName' AND type = '$type) or die (mysql_error()); Maybe I'm wrong. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
