RE: Connection String?
Mike, I'm curious, is the value specified for the DRIVER argument the name of the ODBC driver? If so, is this a general trick that can be applied to ADO for use with other ODBC drivers, i.e. PostgreSQL? Thanks, -- Barry C. Hawkins Systems Consultant All Things Computed [EMAIL PROTECTED] 404-795-9147 voice/fax Quoting Mike Hillyer [EMAIL PROTECTED]: On the contrary, I use MyODBC and NEVER use a DSN, hate the things. Here is the connection string I use: DRIVER={MySQL ODBC 3.51 Driver};SERVER=123.456.789.100;DATABASE=mysqldatabase;UID=sampleuser;PWD=123 45; OPTION=16427 It works great, sometimes I add 2048 to the options value to use the compressed protocol(producing OPTION=18475), it is especially useful when dealing with blobs. Mike Hillyer http://www.dynamergy.com/mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 8:43 AM To: Tamayo, Nelson Cc: '[EMAIL PROTECTED]' Subject: Re: Connection String? Quoting Tamayo, Nelson [EMAIL PROTECTED]: I am trying to connect to MySQL without using a DSN entry, this is my connection string DRIVER={MySQL ODBC 3.51 Driver};SRVR=159.113.44.49;DB=csapps;UID=user;PWD=password The error I get is Invalid connection string attribute Any ideas? Nelson Tamayo Claims Automation (800) 237-7767 x3520 [EMAIL PROTECTED] The information contained in this transmission is legally privileged and confidential information intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copy of this transmission is strictly prohibited. If you have received this transmission in error, please contact the sender immediately. - 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 Nelson, It sounds like you are trying to connect to MySQL via ADO using a connection string. ADO connection in that manner requires an OLE-DB driver for the database platform if you wish to avoid using an ODBC DSN. I don't think that there's an OLE-DB (at least not a free one) for MySQL yet. Therefore, you will have to use a DSN. Regards, -- Barry C. Hawkins Systems Consultant All Things Computed [EMAIL PROTECTED] 404-795-9147 voice/fax - 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 - 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: converting MS SQL to MySQL
Hawk, While your script is fairly straightforward in terms of SQL syntax, Transact-SQL and MySQL's dialect of SQL are different enough that you will have to modify some things. Here's a link to the CREATE INDEX syntax page of the online MySQL manual: http://www.mysql.com/doc/en/CREATE_INDEX.html It could be as simple as placing a space between the table name and columns list. What sort of errors are you getting? Have you tried creating an index with the command-line utility to see if you can get more information on the issue? Also, what version of MySQL are you running? The manual states that prior to 3.22 this statement did nothing. Most folks are on 3.23.5x, but it never hurts to check. Regards, On Thursday, February 6, 2003, at 05:57 PM, Hawk wrote: Hi, I am new to SQL. I am attempting to create a database that was created in MS SQL to MySQL. The below SQL statements works with MS SQL. I am executing the following: CREATE TABLE 'Accounting'( 'Username' VARCHAR(254) NULL, 'CallerID' VARCHAR(128) NULL, 'Addr' VARCHAR(128) NULL, 'NAS' VARCHAR(128) NULL, 'Port' VARCHAR(128) NULL, 'Start' DATETIME NULL, 'Stop' DATETIME NULL, 'SessionTime' INTEGER DEFAULT 0, 'ExtraTime' INTEGER DEFAULT 0, 'TimeLeft' INTEGER DEFAULT 0, 'KBytesIn' INTEGER DEFAULT 0, 'KBytesOut' INTEGER DEFAULT 0, 'SessionKB' INTEGER DEFAULT 0, 'ExtraKB' INTEGER DEFAULT 0, 'KBytesLeft' INTEGER DEFAULT 0, ) GO CREATE INDEX IX_Username ON Accounting(Username) MySQL will not take this command GO CREATE TABLE 'ActiveUsers'( 'UserID' VARCHAR(254) PRIMARY KEY, 'NAS' VARCHAR(128) NULL, 'Port' VARCHAR(128) NULL, 'Username' VARCHAR(254) NULL, 'CallerID' VARCHAR(128) NULL, 'Address' VARCHAR(128) NULL, 'LoginTime' DATETIME NULL, ) GO CREATE TABLE 'TAC_GRP'( 'TAC_ID' VARCHAR(254) NOT NULL, 'TAC_Attr' VARCHAR(64) NOT NULL, 'TAC_Val' TEXT NULL ) GO CREATE UNIQUE INDEX IX_TAC_ID ON TAC_GRP(TAC_ID, TAC_Attr) MySQL will not take this command GO CREATE TABLE 'TAC_USR'( 'TAC_ID' VARCHAR(254) NOT NULL, 'TAC_Attr' VARCHAR(64) NOT NULL, 'TAC_Val' TEXT NULL ) GO CREATE UNIQUE INDEX IX_TAC_ID ON TAC_USR(TAC_ID, TAC_Attr) MySQL will not take this command GO Thanks in advance. --- [This E-mail scanned for viruses by Friend.ly.net.] - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Barry C. Hawkins Systems Consultant All Things Computed 404-795-9147 voice/fax [EMAIL PROTECTED] - 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: converting MS SQL to MySQL
Scott, Try using single quotes for the values in your INSERT statement. $sSql = INSERT INTO contacts (first_,last_ ) VALUES ('$first_','$last_'); Quoted identifiers is a setting usually enabled for SQL Server connections, and so it thinks you are indicating an attribute (column) of an entity (table) and therefore fails. At least that's my best guess for now. Regards, Barry I have had a crack at alering a php script written for a mysql database but instead I want it into a MS SQl database. I though am getting a unexplained T_variable. This is what I have got:- ?PHP $hostname = database; $username = login; $password = password; $dbName = database; MSSQL_CONNECT($hostname,$username,$password); mssql_select_db($dbName) or DIE(Table unavailable); $sSql = INSERT INTO contacts (first_,last_ ) VALUES ($first_,$last_); $pResult = mssql_query($sSql, $g_pDBServer); print Data submitted to database!p first_: $first_br last_: $last_br; // Close the database connection mssql_close(); ? Each time I run it though I am getting Parse error: parse error, unexpected T_VARIABLE in C:\Intranet\Intranet - Main Folder\access.php on line 10 Been looking in google and php.nt - and so far coming up a blank - can u help put me on the right track. Scott - Original Message - From: Barry C. Hawkins [EMAIL PROTECTED] To: Hawk [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, February 08, 2003 2:33 PM Subject: Re: converting MS SQL to MySQL Hawk, While your script is fairly straightforward in terms of SQL syntax, Transact-SQL and MySQL's dialect of SQL are different enough that you will have to modify some things. Here's a link to the CREATE INDEX syntax page of the online MySQL manual: http://www.mysql.com/doc/en/CREATE_INDEX.html It could be as simple as placing a space between the table name and columns list. What sort of errors are you getting? Have you tried creating an index with the command-line utility to see if you can get more information on the issue? Also, what version of MySQL are you running? The manual states that prior to 3.22 this statement did nothing. Most folks are on 3.23.5x, but it never hurts to check. Regards, On Thursday, February 6, 2003, at 05:57 PM, Hawk wrote: Hi, I am new to SQL. I am attempting to create a database that was created in MS SQL to MySQL. The below SQL statements works with MS SQL. I am executing the following: CREATE TABLE 'Accounting'( 'Username' VARCHAR(254) NULL, 'CallerID' VARCHAR(128) NULL, 'Addr' VARCHAR(128) NULL, 'NAS' VARCHAR(128) NULL, 'Port' VARCHAR(128) NULL, 'Start' DATETIME NULL, 'Stop' DATETIME NULL, 'SessionTime' INTEGER DEFAULT 0, 'ExtraTime' INTEGER DEFAULT 0, 'TimeLeft' INTEGER DEFAULT 0, 'KBytesIn' INTEGER DEFAULT 0, 'KBytesOut' INTEGER DEFAULT 0, 'SessionKB' INTEGER DEFAULT 0, 'ExtraKB' INTEGER DEFAULT 0, 'KBytesLeft' INTEGER DEFAULT 0, ) GO CREATE INDEX IX_Username ON Accounting(Username) MySQL will not take this command GO CREATE TABLE 'ActiveUsers'( 'UserID' VARCHAR(254) PRIMARY KEY, 'NAS' VARCHAR(128) NULL, 'Port' VARCHAR(128) NULL, 'Username' VARCHAR(254) NULL, 'CallerID' VARCHAR(128) NULL, 'Address' VARCHAR(128) NULL, 'LoginTime' DATETIME NULL, ) GO CREATE TABLE 'TAC_GRP'( 'TAC_ID' VARCHAR(254) NOT NULL, 'TAC_Attr' VARCHAR(64) NOT NULL, 'TAC_Val' TEXT NULL ) GO CREATE UNIQUE INDEX IX_TAC_ID ON TAC_GRP(TAC_ID, TAC_Attr) MySQL will not take this command GO CREATE TABLE 'TAC_USR'( 'TAC_ID' VARCHAR(254) NOT NULL, 'TAC_Attr' VARCHAR(64) NOT NULL, 'TAC_Val' TEXT NULL ) GO CREATE UNIQUE INDEX IX_TAC_ID ON TAC_USR(TAC_ID, TAC_Attr) MySQL will not take this command GO Thanks in advance. --- [This E-mail scanned for viruses by Friend.ly.net.] -- --- 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 mysql- [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Barry C. Hawkins Systems Consultant All Things Computed 404-795-9147 voice/fax [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php
RE: [MySQL] Access denied on LOAD DATA INFILE statement - no subject provided with posting
Amit, Perhaps try running your LOAD DATA INFILE statement typed at the command prompt of the mysql client, and maybe you will get more info as to what the problem is. You may have a MySQL installation where the 'LOAD DATA INFILE' statement is not permitted by default. However, these are just guesses. For future reference, please be sure to provide a meaningful subject line to your posting, and give us as much information as possible regarding the version of MySQL you are running, which platform you are running on, etc. Thanks, and best of luck. Sincerely, -- Barry C. Hawkins Systems Consultant All Things Computed [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] sql.com] Sent: Friday, April 26, 2002 3:57 AM To: [EMAIL PROTECTED] Subject: Hi All, Can someone help me figure out the following problem. If i fire the following command from D:\mysql\bin mysql --user=netaps --password=netaps --host=192.168.100.2 --port=3306 --database=netaps --execute=LOAD DATA INFILE 'D:\\NetapsFiles\\jobsequence.csv' INTO TABLE jobsequence FIELDS TERMINATED BY ','; It generates the following error:- ERROR 1045: Access denied for user netaps@NETAPS1(Using Password: YES) but now if i executete command as :- mysql --user=netaps --password=netaps --host=192.168.100.2 --port=3306 --database=netaps --execute=select count(*) from jobbatch; It works fine. Plase Help REgards Amit __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.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 - 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: more on 1049 errors
Clay, I have only been running MySQL on Mac OS 10.1.3 on a PowerBook G4 for development purposes, but a couple of things occurred to me: 1.) When the log says Got error 9 from select and that error shows as Bad file descriptor, I am reminded of the quirkiness that sometimes happens when applications interface with HFS/HFS+ volumes. Does your Mac OS X Server have HFS+ volumes, or do you use AIX filesystem volumes? 2.) Do any of your queries to the mysql filename reference a filename, and if so, is the filename part of your $PATH variable, or does it require a path prefix prepended to the filename? I know these are obscure questions, but you have quite an obscure issue on your hands. They're mostly a hacker's stab in the dark. Best wishes, and we all (particularly those of us dealing with Mac OS X :^) ) are interested in hearing how you finally figure this out. If you have not already visited his site, you might go to Mark Liyanage's site (http://www.entropy.ch/) and email him to see if he has anything to offer. Sincerely, -- Barry C. Hawkins Systems Consultant All Things Computed [EMAIL PROTECTED] -Original Message- From: Clay Loveless [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 8:20 PM To: Mark Matthews; [EMAIL PROTECTED] Subject: Re: more on 1049 errors Okay, this just happened again, and this time I did get an error in the logs. 020425 18:01:00 Error in accept: Resource temporarily unavailable 020425 18:01:00 mysqld: Got error 9 from select 'perror' says: Error code 9: Bad file descriptor ... Which still leaves me a bit in the dark. Has anyone else experienced error 9? As Paul DuBois mentioned in another response, MySQL and Mac OS X are pretty recent companions, so it's entirely possible this could be related to the OS and its file system routines. I'm using a pretty speedy disk on a dual processor G4 ... And noted today while perusing the support option price list that the use of a dual processor puts me in the advanced support category (as does the use of Mac OS X). Any possibility of the dual processing playing a role here? Our MySQL server is also a dual disk system, where the OS the MySQL application reside on one Ultra160 SCSI drive, and the MySQL data files reside on a second Ultra160 SCSI drive. I can also pass along my my.cnf parameters if they may be of use in diagnosing the problem ... I've based them off of the large example my.cnf settings. Thanks in advance for any additional assistance -- I really do appreciate the dialog on the problem. -Clay ___ Clay Loveless Webmaster, Crawlspace http://www.crawlspace.com/ From: Mark Matthews [EMAIL PROTECTED] Date: Thu, 25 Apr 2002 16:39:56 -0500 To: Clay Loveless [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: how to get support help? What does your MySQL error log say when this happens? (it should be in the same directory with your databases and be your hostname plus a .err extension). This information should shed some light on what's going on under the hood. -Mark Original message: Subject: Re: how to get support help? From: Clay Loveless [EMAIL PROTECTED] Date: 2002-04-25 17:50:48 [Download message RAW] Erik, et. al.-- Thanks for all the helpful advice. I'll make a note that the MySQL mailing list welcomes messages from people shrieking HELP!!! even though they clearly haven't bothered to read the manual, but offers little to those who've actually tried to resolve a problem on their own BEFORE wasting everyone else's time and bandwidth. This approach is contrary to other lists I'm a part of, so I'm glad you've helped me get my mind right on how *this* list (clearly an anomaly) works. Anyone else offering the buy a contract response can save their keystrokes, I'm now crystal clear on that solution. -Clay - 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 - 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
RE: more on 1049 errors
Clay, I am on remote assignment out of town, and I don't have my Mac or any of my MySQL books with me, so I am mostly going from memory. If I am not mistaken, Paul Dubois mentions in his book that the mysql_pconnect() function is definitely preferred from a scalability standpoint, and if the problem lies with the handling of the Unix socket, then I don't think that mysql_connect() will provide any advantage or resolution to your issue. Again, I am going from memory, but I think there is a way to use TCP instead of Unix sockets as your mode of connection. I can't remember if this is something that requires a recompile (which, if you are using a precompiled binary currently, would require some extra work) or not, but I am sure some of the more-experienced MySQL folk know by heart. Perhaps trying this alternate connection mode would help narrow down the issue. Also, are your servers Apache, and if so are they using the Apache MySQL functionality, or are they compiled to use the MySQL library of your MySQL installation? This, too, may have an effect on your issue. Keep at it, -- Barry C. Hawkins Systems Consultant All Things Computed [EMAIL PROTECTED] -Original Message- From: Clay Loveless [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 10:41 PM To: Barry C. Hawkins; [EMAIL PROTECTED] Subject: Re: more on 1049 errors Barry, Thanks for your input into this problem! 1) That's an interesting point about the HFS+ filesystem -- I've read that a G4 won't boot unless the startup volume is formatted as HFS+ (so sayeth the 10.1 Server Update README FIRST.pdf) ... So, just for consistency's sake, both drives in my server are formatted for HFS+. But, I assume HFS+ is not the most common filesystem MySQL is installed upon ... So who knows? That could be an issue. 2) I don't actually actually query an explicit filename reference -- I'm doing a standard mysql_connect/mysql_pconnect through PHP to a the hostname of our MySQL server. We have a two-webserver and one MySQL server setup, with all three machines running identical hardware and OS configurations, all in the same rack on a 100BaseT network (so there shouldn't be any real network latency issues) ... But connection is being made over a network, not to the localhost. But, that did get me to thinking about mysql_connect vs mysql_pconnect ... When I moved all our stuff from FreeBSD boxes to Mac OS X Server, all of our database calls through PHP were made via mysql_pconnect. I've had some other oddities (rapid memory consumption by only ONE of the OS X web servers) which popped up during that move, and I've been experimenting with switching back to mysql_connect(). Since a socket connection is considered a file descriptor, I wonder if something funny is going on that causes a persistent connection to go bad, thus generating bad file descriptor errors? If that were true, I could switch to using solely mysql_connect() calls, since I believe that opens a new connection, uses it, and closes it ... Leaving no real opportunity for that particular connection's file descriptor to go bad. ?? I'm definitely groping around on this one myself ... It's easy enough to switch to using only mysql_connect(), and I can do that and see how things go for awhile ... But it's one of those things where it's a wait and see with fingers crossed remedy. Barry, Paul, Mark, Erik ... Anyone else ... Opinion on that theory? Thanks again, folks -- I appreciate the group brainstorm. -Clay (PS -- I'd email Marc Liyanage, but I can only imagine how many people are bugging him already! I'm using his latest binary build at the moment.) ___ Clay Loveless Webmaster, Crawlspace http://www.crawlspace.com/ From: Barry C. Hawkins [EMAIL PROTECTED] Date: Thu, 25 Apr 2002 20:40:59 -0500 To: 'Clay Loveless' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: more on 1049 errors Clay, I have only been running MySQL on Mac OS 10.1.3 on a PowerBook G4 for development purposes, but a couple of things occurred to me: 1.) When the log says Got error 9 from select and that error shows as Bad file descriptor, I am reminded of the quirkiness that sometimes happens when applications interface with HFS/HFS+ volumes. Does your Mac OS X Server have HFS+ volumes, or do you use AIX filesystem volumes? 2.) Do any of your queries to the mysql filename reference a filename, and if so, is the filename part of your $PATH variable, or does it require a path prefix prepended to the filename? I know these are obscure questions, but you have quite an obscure issue on your hands. They're mostly a hacker's stab in the dark. Best wishes, and we all (particularly those of us dealing with Mac OS X :^) ) are interested in hearing how you finally figure this out. If you have not already visited his site, you might go to Mark Liyanage's site (http://www.entropy.ch/) and email him to see if he has anything
Re: GRANT questions on OS X.
Alex, Enclose the user string in quotes. This will allow you to use the global wildcard option. Example: GRANT ALL ON *.* TO myuser@% IDENTIFIED BY mypassword; For those not using Mac OS X, the default shell is tcsh. I am not sure if this quirk is a function of string handling in tcsh or what, but this is the workaround I am using. Happy granting, -- Barry C. Hawkins Systems Consultant All Things Computed [EMAIL PROTECTED] On Fri, 19 Apr 2002 13:45:56 -0400 Alex Pilson [EMAIL PROTECTED] wrote: Why is this producing a syntax error at the %? This is supposed to create a global user, yes? GRANT ALL ON *.* TO myuser@% IDENTIFIED BY mypassword; Is there a quick command to show all GRANTS? or Users? -- - Alex Pilson FlagShip Interactive, Inc. [EMAIL PROTECTED] 404.728.4417 404.642.8225 CELL // Web Design // Lasso Application Development // Filemaker Pro / SQL Development // Sonic Solutions Creator Authoring // Apple DVD Studio Pro Authoring // Macromedia Director/Flash Authoring - - 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: Somebody kindly get me off this list
on 6/21/01 16:04, Van at [EMAIL PROTECTED] wrote: Angela Neff wrote: I have tried numerous methods as instructed in the mySQL listerserv e-mail to get off this list but am still on it. Can somebody help me out? I got 779 e-mails today. Thanks, Angela Angela: It's not: Date: Thu, 11 Aug 1904 15:17:05 -0700 Might want to check on that. Van Angela, You may want to investigate these possible issues: *Are you sending your unsubscribe request from an email client that does not have the same email address that you are subscribed to the list under as its reply address? *Is your account on your email server one with several smtp aliases for your account, such as [EMAIL PROTECTED], [EMAIL PROTECTED], etc.? Servers like Exchange set a default reply address that may be causing your issue. Hope this helps, -- Barry C. Hawkins Systems Consultant, MCSE 4.0 [EMAIL PROTECTED] - 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: Newbie stumped by table error
on 6/13/01 10:58, Jeff Caron at [EMAIL PROTECTED] wrote: Hello- I'm just beginning to teach myself MySQL with the help of Michael Widenius' book MySQL. I've entered the create table statement exactly as shown in the book (pg. 28 if you have the book) and I get an error message every time. This is very frustrating as I can't go any further with the tutorial without creating all the tables first. Could someone on this list please help me so I can correctly create this table? Incidentally, I checked the corrections document on the book publisher's web site and there were no corrections for this page. This makes me even more stumped... Here's the statement I submitted: CREATE TABLE member ( last_name VARCHAR(20) NOT NULL, last_name VARCHAR(20) NOT NULL, suffix VARCHAR(5) NULL, expiration DATE NULL DEFAULT -00-00, email VARCHAR(100) NULL, street VARCHAR(50) NULL, city VARCHAR(50) NULL, state VARCHAR(2) NULL, zip VARCHAR(10) NULL, phone VARCHAR(20) NULL, interests VARCHAR(255) NULL ) Here's the error message I keep getting: ERROR 1064 at line 1: You have an error in your SQL syntax near '-00-00, email VARCHAR(100) NULL, street VARCHAR(50) NULL, city VARCHAR(50) NULL,' at line 6 Any help would be most appreciated. Jeff Caron - 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 Did you try leaving out the dashes? Also, I am sure you are putting a semicolon after the closing bracket of the CREATE TABLE statement, right? Hope this helps, -- Barry C. Hawkins Systems Consultant, MCSE 4.0 [EMAIL PROTECTED] - 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: special select ( try 2)
Is this French for This is a MIME format message in multiple parts? If so, Franky, try sending your message in plain text, please. Merci, -- Barry C. Hawkins Systems Consultant, MCSE 4.0 [EMAIL PROTECTED] -Original Message- From: franky [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 1:05 PM To: [EMAIL PROTECTED] Subject: Re: special select ( try 2) Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: C'est un message de format MIME en plusieurs parties. --=_NextPart_000_00A1_01C0F3F9.C56F8400 --=_NextPart_000_00A1_01C0F3F9.C56F8400-- - 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: Pregunta
on 6/13/01 17:12, Anita Rafaela Carrillo at [EMAIL PROTECTED] wrote: Hola. Hola. Soy estudiante de Sistemas y necesito ayuda por favor. En que sitio puedo encontrar un frontal gráfico de MySql para Linux, necesito generar mi base de datos y diseñar las tablas de un sistema. At. Anita C. Gracias _ http://www.latinmail.com. Gratuito, latino y en español. - 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 Sra. Gracias, Usted puede encontrar unas frontales graficos en este sitio: http://www.mysql.com/downloads/contrib.html#SEC592 Tambien usted puede usar phpMyAdmin si tiene Apache con PHP instalado en su servidor de Linux. Perdoname por la absenia de los acentos, pero no tengo soporte para espanol instalado en este computador Chao, Traduccion: Ms. Gracias, You can find graphical front ends en this site: http://www.mysql.com/downloads/contrib.html#SEC592 You can also use phpMyAdmin if you have Apache with PHP installed en your Linux server. Forgive me for the absence of accents, but I don't support for Spanish installed on this computer. -- Barry C. Hawkins Systems Consultant, MCSE 4.0 [EMAIL PROTECTED] - 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: Delete FROM Table does not function correctly
on 6/11/01 15:13, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: I am running MySql 3.23.38, Slackware Linux 7.1 (custom Kernel 2.4.4), PhP 4.0.5, and Apache 1.3.19. I have found what I believe is a bug with this release of MySql. When I try to delete an entry from a table (DELETE FROM articles WHERE article_id = '3') the database only deletes the article_id which is a primary key. It leaves the rest of the entry data in the table. This creates a problem when I no longer want certain records in my database. I have tried in multiple versions of MySql, and 3.23.38 seems to be the only version that has this particular bug. Has anyone else experienced this issue? Please let me know how to fix this problem. Thanks in advance, David - 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 Have you tried ( DELETE * FROM articles WHERE article_id = '3' ) ? -- Barry C. Hawkins Systems Consultant, MCSE 4.0 [EMAIL PROTECTED] - 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
parse error in config.inc.php3 on line 1 in phpMyAdmin
Esteemed colleagues, The php list is down, and I am sure someone knows what to do about this in this list. The issue is that I receive the error Parse error: parse error in config.inc.php3 on line 1 upon trying to access phpMyAdmin 2.1.0 from the web. MySQL 3.22.23 is on the same Linux box running Apache 1.36. Line 1 reads as follows: $cfgServers[1]['host'] = 'localhost'; // MySQL hostname I have tried 'localhost', '127.0.0.1', and 'hostname.com' (name provided by ISP who seems fairly clueless). What painfully obvious thing am I overlooking? Thanks in advance, -- Barry C. Hawkins Systems Consultant, MCSE 4.0 [EMAIL PROTECTED] - 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: parse error in config.inc.php3 on line 1 in phpMyAdmin
on 6/7/01 17:58, Zak Greant at [EMAIL PROTECTED] wrote: Barry C. Hawkins wrote: Esteemed colleagues, The php list is down, and I am sure someone knows what to do about this in this list. The issue is that I receive the error Parse error: parse error in config.inc.php3 on line 1 upon trying to access phpMyAdmin 2.1.0 from the web. MySQL 3.22.23 is on the same Linux box running Apache 1.36. Line 1 reads as follows: $cfgServers[1]['host'] = 'localhost'; // MySQL hostname I have tried 'localhost', '127.0.0.1', and 'hostname.com' (name provided by ISP who seems fairly clueless). What painfully obvious thing am I overlooking? The name of the server is not the issue. Chances are good that there is a syntax error in a line above the spot where config.inc.php3 is included. Try including a different file and seeing if you get the same error. --zak - 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 Including (they actually use require() ) a different file caused a timeout, but the syntax is so straightforward I am having trouble spotting the error. Take a look: *** Top of index.php3: ?php // Process config file to determine default server (if any) require(lib.inc.php3); ? *** Top of lib.inc.php3: ?php /* $Id: lib.inc.php3,v 1.62 2000/07/20 11:15:11 tobias Exp $ */ require(config.inc.php3); function show_table_navigation($pos_next, $pos_prev, $dt_result) { global $pos, $cfgMaxRows, $server, $db, $table, $sql_query, $sql_order, $sessionMaxRows, $SelectNumRows, $goto; global $strPos1, $strPrevious, $strShow, $strRowsFrom, $strEnd; ? *** Top of config.inc.php3: ?php /* $Id: config.inc.php3,v 1.28 2000/07/13 13:52:48 tobias Exp $ */ /* * phpMyAdmin Configuration File * All directives are explained in Documentation.html */ // The $cfgServers array starts with $cfgServers[1]. Do not use $cfgServers[0]. // You can disable a server config entry by setting host to ''. $cfgServers[1]['host'] = 'localhost'; // MySQL hostname etc. ... ? All the require() functions are at the tops of the pages, with almost nothing but comments in front of them. The only thing I find odd is that the ISP has both PHP3 and PHP4 active, and you get one or the other depending on the extension you use. However, this should still work. Any insight -- Barry C. Hawkins Systems Consultant, MCSE 4.0 [EMAIL PROTECTED] - 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