Re: simple commands, no joy
Assuming you are trying to execute MySQL(SQL) commands from 'netsloth.dump', remove the 'redirect to' after the mysql command. This also assumes you are logged into the localhost using the command line interface. Your command would appear similar to the following: mysql -u jjames -psd342 dbtheNetee /Library/WebServer/web1/book/install/netsloth.dump Remove the trailing semi-colon from the command line. I hope this helps... Pat... [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 18, 2001 9:44 PM Subject: simple commands, no joy what's wrong with this please: mysql -u jjames -psd342 dbtheNetee /Library/WebServer/web1/book/install/netsloth.dump; - (as i understand it a .dump = .sql file) thanks. - 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: Relationships???
Referential integrity should be maintained by the program (programmer) using the file handler/database. We design all of our schemas with a Parent/Child hierarchy in mind. We always have a unique key and there is always a column or key in common where any relationship exists or could exist between tables. Consider an invoice with a 1-many relationship. Header information regarding the sold to, ship to, etc.. and the Detail containing the items, quantity, etc... . These two tables would have an invoice number field/column in common. The program used to Add,Edit,Delete would enforce the relationship, thereby, maintaining referential integrity. The concept of a DBA (read 'not a programmer') attempting to enforce referential integrity by pure schema design without consideration of the applications designed to use the data or the unlimited creativity of the end-user at the keyboard over simplifies the process and itself imposes data integrity questions. Pat... . - Original Message - From: Rolf Hopkins [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 14, 2001 9:28 PM Subject: Re: Relationships??? If you are really after referential integrity then perhaps you should consider another database or you could always modify the code. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 15, 2001 8:32 Subject: Relationships??? Hello all, Without explicitly creating foreign keys, what is the most common method to create a truly relational database that enforces referential integrity? Any responses to this question are greatly appreciated! Sincerely, N. Silverwise - 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: Can only create 127 records in a table :o(
Check your AUTO_INCREMENT column. You probably have it set to a TINYINT (0-128). Use ALTER TABLE to change it to an INT or BIGINT. I hope this helps. Pat... - Original Message - From: Mette Møller Madsen [EMAIL PROTECTED] To: mysql listserver [EMAIL PROTECTED] Sent: Friday, June 15, 2001 7:46 AM Subject: Can only create 127 records in a table :o( Hi there! When I try to insert more than 127 rows/records in a table I get this error: ERROR 1062: Duplicate entry '127' for key 1 (the key is an auto incremented primary key) Does anyone know how to store _more_ than 127 rows in a table? My guess is that I need to change to settings of my db, but I cannot find anything in the manual. (I'm running version 3.23.38 which should be a stable one.) best regards, Mette Madsen - 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: ADO RS.Update problem
Just a quick note about RecordCount. RecordCount only returns the number of records or rows from the recordset that have been 'seen'. Therefore it is only reliable if you have traversed the entire recordset before calling it. I agree, however, that direct SQL calls will generally produce a more predictable result Sorry for the interruption... Pat... - Original Message - From: "Dennis Salguero" [EMAIL PROTECTED] To: "Simon Abolnar" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, April 14, 2001 7:21 AM Subject: Re: ADO RS.Update problem Unfortunately, it doesn't seem like all ADO methods and properties and supported when working with MySQL. Update, as you know, is one of them, along with others like RecordCount. I would recommend using a connection object and then passing an SQL statement to run. If need be, you can add the results to a recordset object. You can write it like the following, where objConn is a ADO connection object: % strSQL = "SELECT * FROM Foo" objConn.Execute(strSQL) % Obviously, the above is ASP syntax, but you get the idea for VB :). Good luck, Dennis **' Beridney Computer Services [EMAIL PROTECTED] http://www.beridney.com - Original Message - From: "Simon Abolnar" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 14, 2001 4:46 AM Subject: ADO RS.Update problem Hello! I am using mysql with VB ADO under Windows 2000 Proffesional. I add data with: RS.Open "Query WHERE 0=1", Cn, , , adCmdText RS.AddNew RS.Fields(Cols).Value = xx . RS.Update After RS.Update RS.Fields(Cols).Value is NULL. If I use Access database, RS.Fields(Cols).Value has value of last inserted record. Would you like to tell me, why mysql works in different way and how to solve this problem to have compatible solution for mysql and Access? Thanks all! Simon - 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: Problem Setting up MyODBC Driver
Your workstation may not be in the host table of the MySQL Server. Pat... - Original Message - From: "Nick" [EMAIL PROTECTED] To: "mysql" [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 9:31 AM Subject: Problem Setting up MyODBC Driver HI I am trying to set up an ODBC connection between my Windows 2000 PC and my Web Server which has a MySQL database on it. I installed the MyODBC package for Windows NT and entered all the relevant information: DSN E-SkyMySQL MySQL host 192.168.1.100 MySQL Database Name eskylight User httpd and Password I did this as a machine data source When I try to connect I get the error message S1000[TCX][MYODBC] Host " is not allowed to connect to this MySQL Server. Any Ideas why this may be happening? Thanks Nick Steele - 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: Bug in MyODBC 2.50.36-nt ??
Try setting the use manager cursors in the MyODBC panel for the database in question. Pat... [EMAIL PROTECTED] - Original Message - From: "Uwe Hein" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 08, 2001 2:17 PM Subject: Bug in MyODBC 2.50.36-nt ?? Hi everybody, I am using a MySQL Database with MyOdbc 2.50.36-nt under WinNt SP6a and Win 2000 SP 1. The language of my frontend is CA Visual Objects (ClassMate library for SQL) When skipping through my data set with nRetCode = SQLExtendedFetch(HStatement,SQL_FETCH_NEXT,0,@nNumRows,@nRowStatus) the function returns 100 (SQL_NO_DATA), when I try to skip beyond EOF of my dataset. Doing the opposite with nRetCode =SQLExtendedFetch(HStatement,SQL_FETCH_PRIOR,0,@nNumRows,@nRowStatus) I never get nRetCode = 100 when going beyond BOF. Trying the same with the Visual FoxPro (6.0) ODBC driver or MS SQL 7, I get nRetcode = 100 as expected in both cases (going beyond EOF and BOF). As I am rather new to MySQL, I do not know, if this is really a bug. Perhaps someone could tell me another way how to determine, that I reached the top of my result set. regards Uwe Uwe Hein Folkwang Musikschule der Stadt Essen / Germany Voca Ruhrpott - Sun, 04 Mar 2001 23:20 +0100 Email: [EMAIL PROTECTED] Uwe Hein Folkwang Musikschule der Stadt Essen / Germany Voca Ruhrpott - Thu, 08 Mar 2001 19:33 +0100 Email: [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 - 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: Problem
If you are ftp'ing make sure your set to binary transfer method. Pat... - Original Message - From: "ALICE CHIAPPETTA" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 08, 2001 2:37 PM Subject: Problem I have downloaded the stable release for Solaris. Everytime I try to gunzip and tar it. Everything works till the end then I get a checksum error. It never creaed the var directory in the mysql directory. Could this be the problem. I have even try to download the software from the Wisconsin mirrored site, Thank You - 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: ODBC Driver documentation request (again)
ODBC API documentation is, of course, available from Microsoft and is included with Visual Studio or available from their website (I'm not sure of the exact URL). All of the MyODBC source is available from your closest MySQL Mirror site. ODBC and JDBC are not the same. Try Sun for JDBC specifications. Good luck... Pat... [EMAIL PROTECTED] - Original Message - From: "Fernando Rodrguez Sela" [EMAIL PROTECTED] To: "MySQL Mailing List" [EMAIL PROTECTED] Sent: Thursday, March 08, 2001 2:53 AM Subject: ODBC Driver documentation request (again) Hi, I wrote some days ago making this same question, but I had problems witch my mail, and I lost messages (and probably some answers) ... so if somebody answered me, please, re-send it. Thanks. -- -- I'm working in a project to simulate the database servers efficiency. The system consists in some modules, one of that is a protocol analyser (to spy the net). My problem, is that I need to work with Oracle servers, and I don't have the Oracle SQLNet protocol, so I decided to make an ODBC driver that operate as an spy, saving all the SQL sentences send by the client application, and then send it to the real ODBC Driver. This idea is very usefull, because, it could be used to work with all database engines that uses ODBC drivers ... MS ODBC - Spy - OracleODBC, MyODBC, ... | v XML file with the SQL statements Where can I find the ODBC API Documentation to create a new ODBC driver? and the JDBC API? Regards, Fernando. - 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: ODBC trouble - please help
Ensure each table has a TIMESTAMP(14) and a PRIMARY KEY (recommend an AUTO_INCREMENT field). Pat... - Original Message - From: "Wojciech Spychaa" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 07, 2001 4:14 AM Subject: ODBC trouble - please help I 've got problem with ODBC support for Microsoft Access Very ofeten i can't edit records because one error. ODBC driver says "there is another user editing same record in this time" This isn't true - because i work alone :-( Is anyone who can help me? Thanks Wojtek - 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: key lengths
BLOBS and TEXT columns used as indices require the length to be specifically enumerated. (Sec 7.26 of the manual) CREATE TABLE foo( id INT NOT NULL AUTO_INCREMENT, name BLOB NOT NULL, PRIMARY KEY(id), UNIQUE(name(500)) ); Pat... [EMAIL PROTECTED] - Original Message - From: "Mike Thompson" [EMAIL PROTECTED] To: "mysql" [EMAIL PROTECTED] Sent: Tuesday, March 06, 2001 1:51 PM Subject: key lengths How is key length for a table defined? It seems that the default is 255 bytes, but in the online docs it mentions 500 byte keys. I happen to have some very long case sensitive strings that I need to use as keys, but mysql complains when I try to create a table as such CREATE TABLE foo( id INT NOT NULL AUTO_INCREMENT, name BLOB NOT NULL, PRIMARY KEY(id), UNIQUE(name) ); Any thoughts? --m - 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: mysqld got signal 11
You may have a corrupt library or mysqld. Signal 11 is a memory error (likely overwrite). I would try deleting and reinstalling mysqld from a fresh download. Pat... [EMAIL PROTECTED] - Original Message - From: "Steven Roussey" [EMAIL PROTECTED] To: "Mysql" [EMAIL PROTECTED] Sent: Tuesday, March 06, 2001 6:29 PM Subject: Re: mysqld got signal 11 Hi, OK, I now still have the same problem after upgrading to 3.23.33-pc-linux-gnu-i686 binary. After myisamchking all tables, this time it took just about one minute before crashing: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong Bogus stack limit or frame pointer, aborting backtrace Number of processes running now: 0 010306 15:13:38 mysqld restarted I'm off to compiling a debug version. :( Will send a real bug report if it dies again. Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e - 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: winmysqladmin
I seem to get integer size exceeded error windows popping up using winmysqladmin (1.0) against mysqld-opt (3.23.22). This is all on a WIN98 Second Edition box. Any clues? (sorry for the vagueness, it's occurring on a machine not within my immediate reach) Pat... - 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: Connecting via MyODBC always brings up the TDX mysql Driver Connect dialog
Make sure you also have at least a user (and password as appropriate) filled out in the MyODBC Control Panel. Pat... [EMAIL PROTECTED] - Original Message - From: "Jan R Andersson" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 21, 2001 10:22 AM Subject: Connecting via MyODBC always brings up the "TDX mysql Driver Connect" dialog Hello, I've recently successfully downloaded and installed both MySQL and MyODBC on my Win2000 "box". Everything thing works great, except that for every connection via MyODBC I make, the ODBC-setup dialog "TDX mysql Driver Connect" pops up and I have to hit its OK button to close it. There is a checkbox named "Don't prompt on connect" which I thought was ment to have it stop poping up that dialog, but it has no effect. Any idea what to do? Thanks /Jan R Andersson /Kalix /Sweden WEB: www.jra.nu www.mobilesweden.org WAP: jra.nu/main.wml wap.mobilesweden.org - 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: special characters messing me up
When ftp'ing the file use the ASCII mode instead of the BINARY mode. All CR/LF conversions will take place automagically. Alternatively some linux distributions have a utility to strip CR's from ASCII files and there is always old reliable vi . I hope this helps... Pat... [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: "Irmund Thum" [EMAIL PROTECTED] Cc: "Mysql" [EMAIL PROTECTED] Sent: Tuesday, February 13, 2001 7:31 AM Subject: Re: special characters messing me up - Original Message - From: "John W Ford" [EMAIL PROTECTED] To: "Mysql" [EMAIL PROTECTED] Sent: Tuesday, February 13, 2001 15:04 Subject: special characters messing me up I can't figure out why my windows machine leaves "^M" character at the end of each line of code. This causes the file to be messed up when I put it on the Linux server. It makes my perl interpreter look for a file named ^M after the very first line. #!/usr/sbin/perl also... what else I can't figure out is why this special character is sometimes hidden and sometimes visible in my Emacs program in Linux... this is the program I used in which I found the problem. anybody know? John Ford this is a very old well-known Windows issue; you should use a text editor what can save your files in UNIX format: I guess every professinal editor has this option, see Textpad or Dreamweaver... -- http://it97.dyn.dhs.org/ IrmundThum +49 179 6998564 +49 6374 992541 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Disposition: attachment; filename="smime.p7s" Content-Description: Kryptographische Unterschrift mit S/MIME Attachment converted: Ionia:smime.p7s (/) (00013E6A) - 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: MS Access Checkbox equivalent format in MySQL
I use a short (0 unchecked, 1 checked).
Pat...
- Original Message -
From: "John Halladay" [EMAIL PROTECTED]
To: "MySQL List (E-mail)" [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 4:57 PM
Subject: MS Access Checkbox equivalent format in MySQL
If I am using MS Access and linking to tables in MySQL through MyODBC,
what
is the equivalent format of a checkbox (Yes/No) in MySQL?
Would it be ENUM('Yes','No') or ENUM('True','False')? All caps TRUE, YES,
etc.?
Thanks ahead of time for your input.
John Halladay
-
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: PHP does not work after upgrading MySQL to 3.23.32
The mysql version compiled into your web server uses shared libraries and your current version (upgrade) apparently is a statically linked version. Recompile your web server/php/mysql executable with consistent use of libraries i.e. either static or shared. I hope this helps... Pat... - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 7:43 PM Subject: Re: PHP does not work after upgrading MySQL to 3.23.32 Dear Fbio Ottolini, Thanks for your reply. I'm using Linux 2.2.16-22. The exact error that appears is: /usr/local/etc/httpd/httpd: error in loading shared libraries: libmysqlclient.so.6: cannot open shared object file: No such file or directory In MySQL version 3.22.32 there was a file ./lib/mysql/libmysqlclient.so.6 I suppose in MySQL version 3.23.32 this file corresponds to ./lib/libmysqlclient.a I thought it would be smart to alias link ./lib/mysql/libmysqlclient.so.6 to ./lib/libmysqlclient.a. But when I restart httpd, the following error appears /usr/local/etc/httpd/httpd: error in loading shared libraries: libmysqlclient.so.6: invalid ELF header I hope you can help me with this information. Thanks, Tim Samshuijzen At 22:21 3-2-2001 -0200, you wrote: I suppose your operational system is Windows... Or is it Linux? Regarding Windows at least, and I believe Linux also, MySQL has got nothing to do with your problem. If PHP is not working on your system, probabily this is something related to your web server. Are you sure the correct MIME types are being used? Please give as much information as you can. Otherwise it's very difficult to come to a conclusion. BR, Fbio Ottolini P.S.: Consider upgrading to PHP4.04Pl1. - Original Message - From: "Tim Samshuijzen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 03, 2001 10:02 PM Subject: PHP does not work after upgrading MySQL to 3.23.32 Hi, I have just upgraded from MySQL 3.22.32 to 3.23.32. Now PHP3 does not work. I've tried restarting httpd, but an error appears "file not found", and httpd fails to start up. HELP! What am I doing wrong? Thanks, Tim Samshuijzen - 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 - 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: myODBC question
John, To avoid the issues you mentioned, each table requires an AUTO_INCREMENT column and a TIMESTAMP(14) column. We have been coding with VC++ and using various third party ODBC clients, including MS Access, pretty much since the inception of MyODBC. When using the Jet Database Engine (MS Access) the ability to recognize uniqueness of a record/row is paramount. Adding the aforementioned columns assures uniqueness. Pat... [EMAIL PROTECTED] - Original Message - From: "John Jensen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 2:40 PM Subject: Re: myODBC question Speaking as one who tried working with such a connection, FORGET IT. While entering data, I might get all or half a record entered when the message arrives telling me the information cannot be posted, because another user was editing that record (which I could tell was simply NOT the case), and I had the option of either dropping my input, or put the whole record in the past buffer. Occasionally, I would get lucky and get a whole record entered and saved, but mostly, my datbase was getting filled with gaps. Get phpMyAdmin. It is far more reliable solution. On 1 Feb 2001, at 12:06, (Mr) Pekka Gaiser wrote: Hi there, A DB newbie question - can I use MS Access for remote mySQL databases using myODBC?? Thanks. John Jensen 520 Goshawk Court Bakersfield, CA 93309 - 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: myODBC time problems in Access
Actually to ensure updateable tables in MS Access you need a TIMESTAMP(14) and an AUTO_INCREMENT column. Pat... [EMAIL PROTECTED] - Original Message - From: "Scott Baker" [EMAIL PROTECTED] To: "Gregory King" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 31, 2001 11:43 AM Subject: Re: myODBC time problems in Access I'm trying to remember... yes I did have that problem. It's fixed now. I think you just need to have a primary key that is auto_incremented and the newest MyODBC. At 06:49 PM 1/30/2001 -0800, Gregory King wrote: Im trying to use myodbc to enter some data through MS access. The problem is, when I link to the table it shows the data in my data formatted fields all messed up. The data in the mysql table is fine, it is something the odbc driver or access is doing. I read on the Egroup that Scott Baker was having a simular problem in September, but I didnt see any responses to his request for help. - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "Children today are tyrants. They contradict their parents, gobble their food, and tyrannize their teachers." - Socrates - 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: setting autoincrement value help needed (Second post)
I would suggest you issue an ALTER TABLE command to change your AUTO_INCREMENT to unsigned. The concept of AUTO_INCREMENT negates the use of negative numbers. If you are using the change from positive to negative to flag for deletion or some other process, try adding a column for this purpose and not messing with the AUTO_INCREMENT column. ALTER TABLE can be executed on a production database. I hope this helps... Pat... - Original Message - From: "Enea Mansutti" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 29, 2001 2:44 AM Subject: setting autoincrement value help needed (Second post) First of all MySQL rocks!!! -- Now for my problem... Unfortunately, before I knew how autoincrement worked, I have setup a database with a signed autoincrement column in a production environment. When I insert columns, I usually pass NULL as the column value for the INSERT statement to correctly insert the next autoincrement value. Occasionally (for maintenance reasons) I have to MANUALLY insert values with negative numbers, this corrupts the autoincrement value (autoincrement seems to be unsigned) so i have to run myisamchk -A to fix it. I wanted to know if there is an sql command i can execute which has the same effect of myisamchk -A. I have tried to use SET INSERT_ID=# but it seems to set the autoincrement value only for the current connection and for the first insert only. Another question, is it safe to run myisamchk -A without shutting down the mysql in a production environment? regards, Enea -- P.Review srl +39 02 29061035 [EMAIL PROTECTED] www.presstoday.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 - 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: write problems via MS Access 97 in table with timestamp and primary key
Ensure that your TIMESTAMP definition is a TIMESTAMP(14). If it is, identify which workstations are failing and compare MDAC versions against those that are not failing (we are using MDAC 2.5 ). Upgrade/downgrade MDAC as appropriate. In any case, be sure to refresh all the link tables in MS Access. If some workstations still fail, delete the link tables in MS Access and set up link tables again. I hope this helps... Pat... [EMAIL PROTECTED] - Original Message - From: "John Jensen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 1:55 PM Subject: Re: write problems via MS Access 97 in table with timestamp and primary key I used to get this all the time, myself, when I was trying to update a mysql database with Access 2000 through myodbc. Funny, at the time, nobody else seemed to understand what I was talking about. Once I got phpMyAdmin working, the problem became academic, but it never did get solved. I'm still trying to find a solution to my $FORMATQUERY ORDER BY problem with a logic function on two values. Baring a solution, I can only hope for a workaround before a year of effort is not wasted, because someone else beat me to market. Please, this does not need to be a volunteer effort. If anyone thinks they can solve this, contact me directly and we can work something out. On 24 Jan 2001, at 6:34, Bob Hall wrote: One of our users is getting the message "another user has changed this database..etc save changes to clipboard or drop changes... etc", when he tries to update certain fields in the table. The table has a timestamp and a primary key. In fact, this user can change certain fileds without difficulty for certain types of data and not for others (i.e. Access accepts changes when the data is a document but not when its a collection). To make things more confusing., other users can change all fields in the same table via Access without receiving the error message. Any one else had and solved this problem? Susan Albright Ma'am, this is an ODBC problem, not a MySQL problem. I assume that the table is a linked table in Access. How is it accessed? Directly, through a query, or through a form? Are there any joins? Does the problem occur only through a query or form that joins the table with another table? What do you mean by 'the data is a document' and 'its a collection'? These aren't MySQL or Jet datatypes. What is the user who's having problems doing that the other users aren't doing? Things that people have done to solve this include dropping and adding primary keys and timestamp fields, setting up relationships between tables as much as possible (you can set up a relationship between linked tables, but I don't think you can specify what the relationship is), and selecting UniqueRecords in queries (DISTINCTROW in SQL). Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - 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 John Jensen 520 Goshawk Court Bakersfield, CA 93309 - 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: Problems Installing 3.23.31
Try compiling with the static switch set. Check the manual for exact syntax. Pat... - Original Message - From: "Robert Hough" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 23, 2001 8:10 AM Subject: Problems Installing 3.23.31 I compilied 3.23.31 and I keep getting this error: Cannot open "../libmysql/.libs/libmysqlclient.so" This happens with every client binary, and I can't seem to figure out where this is coming from during compile time. -- Robert Hough ([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 - 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
