Re: [PHP-DB] mysql error...

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, Stories

RE: [PHP-DB] mysql error...

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:> > inv

Re: [PHP-DB] MySQL Error 1366

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> LO

Re: [PHP-DB] MySQL 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 TERMINATE

RE: [PHP-DB] MySQL error...

> -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

RE: [PHP-DB] MySQL error...

: Friday, December 10, 2004 2:34 PM 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

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 an update I get back an error > saying "Table 'tablename' doesn

Re: [PHP-DB] mysql error and resource ID:

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 th

RE: [PHP-DB] mysql error and resource ID:

t; integers, right? So put single > quotes around the whole date, like '10/15/2004'. > > dave > > > > > > Stuart Felenstein <[EMAIL PROTECTED]> > > 10/14/2004 10:02 AM > > > > > > To: > Stuart Felenstein <[EM

RE: [PHP-DB] mysql error and resource ID:

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 MainTabl

RE: [PHP-DB] mysql error and resource ID:

From: Stuart Felenstein [mailto:[EMAIL PROTECTED] > Sent: 14 October 2004 15:43 > To: [EMAIL PROTECTED] > 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.

RE: [PHP-DB] mysql error and resource ID:

; > > > > Stuart Felenstein <[EMAIL PROTECTED]> > > 10/14/2004 08:26 AM > > > > > > To: > Graham Cossey <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] > cc: > > > > > > Subject: > RE: [PHP-DB] mysql error and reso

RE: [PHP-DB] mysql error and resource ID:

Well believe it or not I got it right finally. Just used the example from the manual. Meanwhile, the funny thing is , I think the error translates back to my original error abut Resource ID#2 Because not I get : Check the manual that corresponds to your MySQL server version for the right syntax t

RE: [PHP-DB] mysql error and resource ID:

Stuart, you need to define $link if you're going to use it ;) > > Not much luck here on placing the mysql_error($link); > I know the server and database is reachable. So I > imagine the error is happening in the query. I've > moved the $link around with no luck. > > Stuart > > Revised code below:

RE: [PHP-DB] mysql error and resource ID:

If any of the variables used to insert data are strings ($f1a, $f2a, etc...), you'll need to have quotes around them. dave Stuart Felenstein <[EMAIL PROTECTED]> 10/14/2004 08:26 AM To: Graham Cossey <[EMAIL PROTECTED]>, [EMAIL PROTECTED] cc: Subject: RE: [PH

RE: [PHP-DB] mysql error and resource ID:

Not much luck here on placing the mysql_error($link); I know the server and database is reachable. So I imagine the error is happening in the query. I've moved the $link around with no luck. Stuart Revised code below: --- Graham Cossey <[EMAIL PROTECTED]> wrote: -- PHP Database Mailing Lis

RE: [PHP-DB] mysql error and resource ID:

A few ideas... [snip] > Anyway I get this message : "mysql_error(Resource id > #2)" > [snip] > @mysql_connect("myserver","myusername", "mypassword") > or die(mysql_error()); > > @mysql_select_db("mydatabase") or die(mysql_error()); > $link = mysql_connect("myserver", "myusername", > "mypassword");

Re: [PHP-DB] MySQL error message...

mysql knows. this means your query failed, $command resulted in an invalid result set. try adding: or die(mysql_error()); to any call to mysql_query ()so in your code use this: $result = mysql_query("$command",$mysqlHandle) or die(mysql_error()); - and - $resultw = mysql_query("$commandw

RE: [PHP-DB] MySQL Error

, [EMAIL PROTECTED] yintl.com> cc: Subject: RE: [PHP-DB] MySQL Er

RE: [PHP-DB] MySQL Error

I would guess something is wrong with the services that are running on your machine, maybe MySQL isn't on the same machine as your PHP? ... Also, are you running this on a Windows machine or UNIX? Matt. -Original Message- From: JordanW [mailto:[EMAIL PROTECTED]] Sent: Monday, January 27,

Re: [PHP-DB] MySQL Error

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 t

RE: [PHP-DB] MySQL Error

Hi Jordan Made any recent changes to your network configuration? Can you access other IP ports OK e.g. http port 80? Do you have any firewall protection on your PC? Can you access MySQL from the command line OK? Rich -Original Message- From: JordanW [mailto:[EMAIL PROTECTED]] Sent: 28 Jan

Re: [PHP-DB] MySQL Error

ensure that your mysqld is actually running. Then try running 'mysql -hlocalhost -uroot' if it's a new install, or add '-p' at the end if you've set a root password. Alternately, specify another user after -u. That should help. I just figured this one out the other day... I had gone so far

Re: [PHP-DB] MySQL Error???

At 10:24 AM -0600 6/27/01, 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 i

RE: [PHP-DB] MySQL Error???

Hi Brian, Sounds like you have a tinyint field. Change it to something like int(4) or bigger, like int(6) or something. TinyInt fields can only hold up to 127, so when you add another record, the auto-incrementing field you're using cannot go any higher, so it tries to assign 127, but 127 is alrea

RE: [PHP-DB] MySQL Error???

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 t

RE: [PHP-DB] MySQL Error???

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 tin

RE: [PHP-DB] MySQL Error???

> -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 bo

Re: [PHP-DB] MySQL Error???

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,

Re: [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.

Re: [PHP-DB] MySQL Error???

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

Re: [PHP-DB] MySQL Error???

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 wor

Re: [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'

RE: [PHP-DB] MySQL Error???

Brian, Sounds to me as if the field you have as primary key is set to type 'TINYINT'. TINYINT's 'signed' range accepts values from -128 to 127, when set to 'unsigned' it accepts values from 0 to 255. In your place I would concider changing that column to a 'SMALLINT' and set it to 'unsigned'. Th

Re: [PHP-DB] MySQL Error???

The error is probably caused by you inserting a value (127) nto a unique or key field which is identical to one in another record. -- Phil Driscoll -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To

Re: [PHP-DB] MySQL Error???

Hi, This error occurs when your auto_increment index field is of type TINYINT. This field type can accept values form -128 to 127 so you cannot add records with index value greater than 127. I recommend you change it to INT(11) UNSIGNED which can accept values from 0 to 4294967295. If you expect

RE: [PHP-DB] MySQL Error???

sounds like your field definition is something like int(2) or something, it needs to be bigger so that it can handle higher numbers for the unique primary key :) // -Original Message- // From: Brian Grayless [mailto:[EMAIL PROTECTED]] // Sent: Thursday, 28 June 2001 12:24 AM // To: PHP DB

Re: [PHP-DB] MySQL Error???

In article , [EMAIL PROTECTED] (Brian Grayless) wrote: > Is anyone familiar with this MySQL error? > > "1062: Duplicate entry '127' for key 1" You have a unique key (likely the primary key field). There is already a record with value "127" in t