[PHP-DB] MySQL error...

2004-12-10 Thread NIPP, SCOTT V \(SBCSI\)
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 pag

[PHP-DB] mysql error...

2007-08-28 Thread John Pillion
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, Ma

[PHP-DB] MySQL Error???

2001-06-27 Thread Brian Grayless
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,

[PHP-DB] MySQL Error

2001-07-10 Thread Vivek Misra
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 Ma

[PHP-DB] MySQL Error

2003-01-27 Thread JordanW
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

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

2004-12-10 Thread Norland, Martin
> -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...

2004-12-10 Thread NIPP, SCOTT V \(SBCSI\)
: 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...

2004-12-13 Thread Norland, Martin
> -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

[PHP-DB] MySQL Error 1366

2007-05-28 Thread elk dolk
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 136

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

2007-08-28 Thread Bastien Koert
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

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

2007-08-28 Thread Chris
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???

2001-06-28 Thread CC Zona
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

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

2001-06-28 Thread Beau Lebens
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

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

2001-06-28 Thread Dobromir Velev
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: [P

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

2001-06-28 Thread Phil Driscoll
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???

2001-06-28 Thread Christian Sandfeld
'SMALLINT' and set it to 'unsigned'. 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

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

2001-06-28 Thread Andreas D. Landmark
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???

2001-06-28 Thread biorn
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???

2001-06-28 Thread Saul Diaz Carrillo
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

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

2001-06-28 Thread Paul Burney
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???

2001-06-28 Thread Jason Stechschulte
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???

2001-06-28 Thread Mark Roedel
> -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

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

2001-06-29 Thread Jonathan Hilgeman
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???

2001-06-29 Thread Brian Grayless
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???

2001-06-29 Thread Jonathan Hilgeman
27 is already taken. Thats why you get that error. - Jonathan -Original Message- From: Brian Grayless [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 9:24 AM To: PHP DB list (E-mail) Subject: [PHP-DB] MySQL Error??? Is anyone familiar with this MySQL error? "1062: Duplicate

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

2001-06-29 Thread Paul DuBois
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

2001-07-10 Thread Benjamin Bleything
gt; >list-post: <mailto:[EMAIL PROTECTED]> >Delivered-To: mailing list [EMAIL PROTECTED] >Date: Tue, 10 Jul 2001 22:23:08 +0530 >From: Vivek Misra <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Mime-Version: 1.0 >Content-Transfer-Encoding: 7bit >Subject: [PHP-DB] My

RE: [PHP-DB] MySQL Error

2003-01-28 Thread Rich Gray
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($li

Re: [PHP-DB] MySQL Error

2003-01-28 Thread John Krewson
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

2003-01-29 Thread Matthew Moldvan
ry 27, 2003 11:37 PM 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_clos

RE: [PHP-DB] MySQL Error

2003-01-29 Thread Jeffrey_N_Dyke
, [EMAIL PROTECTED] yintl.com> cc: Subject: RE: [PHP-DB] MySQL Er

[PHP-DB] MySQL error message...

2003-06-30 Thread Keith Spiller
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: \n"; $count++; } // IF MENU VALUE == COMMITTEES i

[PHP-DB] MySQL Error 1251 / phpMyAdmin

2005-02-07 Thread GH
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

Re: [PHP-DB] MySQL Error 1366

2007-05-28 Thread Chris
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 1366

2007-05-28 Thread Chetanji
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 message...

2003-06-30 Thread jeffrey_n_Dyke
Spiller <[EMAIL PROTECTED]> Subject: [PHP-DB] MySQL error message...

[PHP-DB] mysql error and resource ID:

2004-10-14 Thread Stuart Felenstein
First time setting something like this up. So probably making some major mistakes. Anyway I get this message : "mysql_error(Resource id #2)" I know it's pointing me to something but not sure what . My suspicion since I'm driving blind :) is that I'm attempting an insert using invalid or incorrect

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

2004-10-14 Thread Graham Cossey
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 and resource ID:

2004-10-14 Thread Stuart Felenstein
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:

2004-10-14 Thread dpgirago
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:

2004-10-14 Thread Graham Cossey
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:

2004-10-14 Thread Stuart Felenstein
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:

2004-10-14 Thread Stuart Felenstein
; > > > > 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:

2004-10-14 Thread Graham Cossey
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:

2004-10-14 Thread Stuart Felenstein
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:

2004-10-14 Thread Stuart Felenstein
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:

2004-10-18 Thread John Holmes
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

[PHP-DB] MySQL ERROR 1036: Table 'foo' is read only

2001-08-22 Thread Jay Paulson
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 '