this is bugging me to no end (no pun intended)... I am getting the error:
invalid query: 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 'Condition, ConstructType, BldgDimensions, Stories,
CurrentParking,
Condition is a reserved word in mysql...you will need to change the field name
bastien Date: Tue, 28 Aug 2007 18:11:20 -0700 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: [PHP-DB] mysql error... this is bugging me to
no end (no pun intended)... I am getting the error: invalid
John Pillion wrote:
this is bugging me to no end (no pun intended)... I am getting the error:
invalid query: 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 'Condition, ConstructType, BldgDimensions,
Hi All,
I want to load data from dump file to MySQL table using LOAD DATA INFILE
but there is Error 1366 :
mysql LOAD DATA
- INFILE 'D:/SITE/SOMETABLE.SQL'
- INTO TABLE SOMETABLE
- FIELDS TERMINATED BY ','
- OPTIONALLY ENCLOSED BY ''
- LINES TERMINATED BY ')';
ERROR 1366
elk dolk wrote:
Hi All,
I want to load data from dump file to MySQL table using LOAD DATA INFILE
but there is Error 1366 :
mysql LOAD DATA
- INFILE 'D:/SITE/SOMETABLE.SQL'
- INTO TABLE SOMETABLE
- FIELDS TERMINATED BY ','
- OPTIONALLY ENCLOSED BY ''
- LINES TERMINATED BY
Chetanji says,
This may be a typo of yours.
Look at the header...
CREATE TABLE `sometableo`
The 'o' is added by mistake?
Blessings,
Chetanji
elk dolk wrote:
Hi All,
I want to load data from dump file to MySQL table using LOAD DATA INFILE
but there is Error 1366 :
mysql LOAD DATA
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
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
No... That is just some strange error generated by the cut and
paste. The IS NOT NU LL that is...
The other issue with 'tablename'... I simply typed 'tablename'
in the e-mail because I didn't
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
I have been using a PHP page to update a database table for a
long time now.
Unfortunately, I have noticed that frequently when I perform an update
I get back an error
saying Table 'tablename' doesn't
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MySQL error...
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
I have been using a PHP page to update a database table for a
long time now.
Unfortunately, I have noticed that frequently when I perform
I have been using a PHP page to update a database table for a
long time now. Unfortunately, I have noticed that frequently when I
perform an update I get back an error saying Table 'tablename' doesn't
exist. This is becoming more and more annoying. The table obviously
exists as the page
Stuart Felenstein wrote:
First time setting something like this up. So probably
making some major mistakes.
Anyway I get this message : mysql_error(Resource id
#2)
[snip]
echo . mysql_error($link);
Read the above line or use an editor that does syntax highlighting.
Also, you'll want to get the
]
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql error and resource ID:
Quote as in string or quote as in 'string' ?
Those two confuse me.
Stuart
--- [EMAIL PROTECTED] wrote:
If any of the variables used to insert data are
strings ($f1a, $f2a,
etc...), you'll need to have quotes
Anyone see something wrong here :
My error message is :
0: 1064: 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
'd',1,'d',1,1, 31, 33,10/15/2004))' at
line 5
Code:
$query = INSERT INTO MainTable
single
quotes around the whole date, like '10/15/2004'.
dave
Stuart Felenstein [EMAIL PROTECTED]
10/14/2004 10:02 AM
To:
Stuart Felenstein [EMAIL PROTECTED]
cc:
[EMAIL PROTECTED]
Subject:
RE: [PHP-DB] mysql error and resource ID:
Anyone see something
Hello,
Does anyone know what would cause this message?
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result
resource in c:\program files\easyphp\www\bod-rse\bod\menu.php3 on line 49...
Here is the code:
?
$command = SELECT * FROM central_fakepaths WHERE menu != '0' ORDER
]
Subject: [PHP-DB] MySQL error
message...
06/30/2003 12:47
January 2003 04:37
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Error
I'm getting this error message when I try the following code:
$link = mysql_connect(localhost)
or die(Could not connect);
print (Connected successfully);
mysql_close($link);
The scripts outputs:
Warning: Can't
Just a shot in the dark, but be sure the socket and port settings are
correct for your setup (whatever that might be since you did not include
that info in your post) and that mysql is actually running.
Be sure to scour
http://www.mysql.com/documentation/mysql/bychapter/index.html
especially
I'm getting this error message when I try the following code:
$link = mysql_connect(localhost)
or die(Could not connect);
print (Connected successfully);
mysql_close($link);
The scripts outputs:
Warning: Can't create TCP/IP socket (10106) in
C:\Projects\WebServer\admin.php on
Running on RH, Apache. I had this working on Win2K, then switched to Linux
by running the mysqldump then moving over the dump file and runing the
mysql -u root -p 'add_databases.sql'. It creates the database then the
table and then it tries to populate the table and i get an ERROR 1036: Table
Dear Experts
When ever i try to run MySQL under linux it gives me following error
ERROR 2002 : can't connect to local MYSQL server through socket '/var/lib/mysql.sock'
(111)
what could be possible remedy/rectification of the above ?
million thx in advance
Vivek Misra
--
PHP Database
I CC-ed the mailing list by accident. Below is my original reply to Brian.
-Original Message-
From: Jonathan Hilgeman
Sent: Thursday, June 28, 2001 8:14 AM
To: 'Brian Grayless'
Cc: PHP-DB (E-mail)
Subject: RE: [PHP-DB] MySQL Error???
Hi Brian,
Sounds like you have a tinyint field
Thanks guys. It was all very helpful and worked great!
Brian
-Original Message-
From: Christian Sandfeld [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 3:06 AM
To: 'Brian Grayless'; '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] MySQL Error???
Brian,
Sounds to me as if the field
Is anyone familiar with this MySQL error?
1062: Duplicate entry '127' for key 1
I wrote a great bookmark management program that works fine, but everytime I
insert bookmarks, I insert somewhere over 120 and I start getting this
error, and it won't add them anymore. Any suggestions???
Thanks,
DB list (E-mail)
// Subject: [PHP-DB] MySQL Error???
//
//
// Is anyone familiar with this MySQL error?
//
// 1062: Duplicate entry '127' for key 1
// I wrote a great bookmark management program that works fine,
// but everytime I
// insert bookmarks, I insert somewhere over 120 and I start
to have more records you may consider using BIGINT type
For more info check the MySQL language reference.
Dobromir Velev
-Original Message-
From: Brian Grayless [EMAIL PROTECTED]
To: PHP DB list (E-mail) [EMAIL PROTECTED]
Date: Thursday, June 28, 2001 9:29 AM
Subject: [PHP-DB] MySQL
'. This will allow for values from 0 to 65535 (depending ofc.
on how many digits you set as the max display size).
Hope I helped :)
/Christian
-Original Message-
From: Brian Grayless [mailto:[EMAIL PROTECTED]]
Sent: 27. juni 2001 18:24
To: PHP DB list (E-mail)
Subject: [PHP-DB] MySQL Error
At 27.06.2001 17:24, Brian Grayless wrote:
Is anyone familiar with this MySQL error?
1062: Duplicate entry '127' for key 1
I wrote a great bookmark management program that works fine, but everytime I
insert bookmarks, I insert somewhere over 120 and I start getting this
error, and it won't add
Most likely, your id (index, auto-increment field, whatever it is) data type
is tinyint which only goes to 127.
Brian Grayless [EMAIL PROTECTED] said:
Is anyone familiar with this MySQL error?
1062: Duplicate entry '127' for key 1
I wrote a great bookmark management program that works
Hi
You create a unique index (i think primary) an try to enter a key that is
already in the table.
greetings saul
- Original Message -
From: Brian Grayless [EMAIL PROTECTED]
To: PHP DB list (E-mail) [EMAIL PROTECTED]
Sent: Wednesday, June 27, 2001 12:24 PM
Subject: [PHP-DB] MySQL Error
on 6/27/01 9:24 AM, Brian Grayless at [EMAIL PROTECTED] wrote:
1062: Duplicate entry '127' for key 1
I wrote a great bookmark management program that works fine, but everytime I
insert bookmarks, I insert somewhere over 120 and I start getting this
error, and it won't add them anymore. Any
On Wed, Jun 27, 2001 at 10:24:13AM -0600, Brian Grayless wrote:
Is anyone familiar with this MySQL error?
1062: Duplicate entry '127' for key 1
The error means you are attempting to put a second record in with the
value of 127.
I wrote a great bookmark management program that works fine, but
-Original Message-
From: Brian Grayless [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 11:24 AM
To: PHP DB list (E-mail)
Subject: [PHP-DB] MySQL Error???
Is anyone familiar with this MySQL error?
1062: Duplicate entry '127' for key 1
I wrote a great bookmark
34 matches
Mail list logo