Bug in Documentation ?
in Mysql documents section 4.16.5 Options files it is documented as : MySQL reads default options from the following files on Windows: Filename Purpose windows-system-directory\my.ini Global options C:\my.cnf Global options C:\mysql\data\my.cnf Server-specific options windows-system-directory\my.ini Global options line is incorrect it must be corrected as : windows-directory\my.ini ? Cause when i try to use my.ini option file which is located in c:\windows\system directory it doesn't works. But when i put it into a c:\windows directory it works fine. Regards. Yusuf INCEKARA Avukatpro Limited Sirketi
Some weird Linking errors :)
Hi! all, I am linking the mysql client library using -l option i.e. -lmysqlclient. I have also specified the path of the libmysqlclient.a. But every time i make, i get some undefined reference errors for compress and uncompress. The output of make is given below. I don't know why i am getting these errors. gcc -g -D__LINUX_PLATFORM -DSMM -L../../../../object -I. -I../../../../../common/include -I../../../../../common/element_management/sms/common -I../../dblib -I../../mysqldb/include aplstatsmanager.c ../../../../object/aplsmmpdu.o ../../../../object/libshm_host.a ../../../../object/apldblib.o -lmysqlclient -o smm ../../../../object/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x97): undefined reference to `uncompress' ../../../../object/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12b): undefined reference to `compress' collect2: ld returned 1 exit status make: *** [all] Error 1 Am i suppossed to link some other file apart from libmysqlclient.a?? If possible, Pl. help me out. Thanks and Regards, Rahul Gauba
sql: DATETIME - MONTH( select problem)
Hi, I'm having the following sql problem: I have two datetime fields (start and end), I need to find out if the month is either equal to start-month or equal to end-month but also if it's a month between start and end. I also check if the end-date is greater than today so it's a current one. My problem is that I can't get the months in between when, how do I do that? Any ideas? $current_month is a php variable. (MONTH(start)= '$current_month' OR MONTH(end) = '$current_month') AND end = CURDATE() Greetings from Sweden Jimmy. database query - 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
Compiling mysqlclient under Cygwin
Hi all! The perl module for Mysql expects to find libmysqlclient.a or libmysqlclient.so, at least when it's compiling under cygwin. An earlier report of the same issue seems to have turned up no responses, but that was a couple months back. Surely I can't be the only unix lover in the world who wants to do database access in a (fairly) portable environment? I find some client stuff for Cygwin b20, but lots of new stuff has come out since then and I'm surprised that I'm not finding anything newer. Any good news out there that wants to come out of the woodwork on this topic? Otherwise, is there anybody aware of the issues required to deal with it who could contribute that knowledge? Thanks in advance for any new information! Randy [please reply to all, 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
Re: Bug in Documentation ?
- Original Message - From: "Yusuf Incekara" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 9:09 AM Subject: Bug in Documentation ? in Mysql documents section 4.16.5 Options files it is documented as : MySQL reads default options from the following files on Windows: Filename Purpose windows-system-directory\my.ini Global options C:\my.cnf Global options C:\mysql\data\my.cnf Server-specific options windows-system-directory\my.ini Global options line is incorrect it must be corrected as : windows-directory\my.ini ? Cause when i try to use my.ini option file which is located in c:\windows\system directory it doesn't works. But when i put it into a c:\windows directory it works fine. Regards. Yusuf INCEKARA Avukatpro Limited Sirketi Hi ! You do not have right. windows-system-directory means:- c:\windows. That is windows system location.and don't c:\windows\system And there isn't bug in documentation. I see that way. Regards Ireneusz Piasecki [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
error help
DEAR SIR/MADAM, I am getting following error.Kindly help to correct it sql(): ErrorYou have an error in your SQL syntax near 'mysql SHOW DATABASE;' at line 1 www.kwwda.org asif - 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
Simple question
I've installed Mysql server version 3.23.36 from source distribution (*.tar.gz). When I show the php4 credits (?phpinfo(); ?) in my browser it shows: MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 3.23.22-beta Why it display other version of client api than I install. It would be nice that You answer me. Adrian Grygier - 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
HELP TO CORRECT ERROR
Dear sir/madam, Kindly help me to correct this error sql(): ErrorYou have an error in your SQL syntax near 'mysql SHOW DATABASES;' at line 1 thamks asif www.kwwda.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
Re: how is this done
I am using php for this project. Right now it is related to mysql. What I want is to display the names of the countries and cities from the Special table instead of the ids. What would be the correct syntax for the select statement? Take a look at websites like www.devshed.com www.phpnewbie.com www.phpbeginner.com and find out how to solve this. You might also want to take a look at www.php.net Or hire someone to do the job for you.. I could help you, so could others. But after this question we will soon see your next question.. Bye, B. - 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: Simple question
Why it display other version of client api than I install. It would be nice that You answer me. Did you compile PHP with --with-mysql=/path/to/mysql Bye, B. - 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
HELP TO CORRECT ERROR
Dear sir/madam, Kindly help me to correct this error sql(): ErrorYou have an error in your SQL syntax near 'mysql SHOW DATABASES;' at line 1 thamks asif www.kwwda.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
RE: [PHP] Time needed for a SQL-statement
Have you tried EXPLAIN ? EXPLAIN SELECT * FROM tables WHERE this='this' AND that='that' ORDER BY this, that ; A query like this would return you some of the stats. Catch the time it gives you and vuale... not sure though, it might be useless if the time taken to do that is equivalent as to select pulling the results out. (think it is) Sincerely, Maxim Maletsky Founder, Chief Developer PHPBeginner.com (Where PHP Begins) [EMAIL PROTECTED] www.phpbeginner.com -Original Message- From: B. Tenhumberg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 5:44 PM To: PHP General Cc: MySQL Subject: [PHP] Time needed for a SQL-statement Hi! Is there a way to get the time the database needed for execution a statement? I use MySQL and PHP... -- Berthold Tenhumberg (live long and prosper...) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [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
Time needed for a SQL-statement
Hi! Is there a way to get the time the database needed for execution a statement? I use MySQL and PHP... -- Berthold Tenhumberg (live long and prosper...) - 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: sql: DATETIME - MONTH( select problem)
Hi, I'm having the following sql problem: I have two datetime fields (start and end), I need to find out if the month is either equal to start-month or equal to end-month but also if it's a month between start and end. I also check if the end-date is greater than today so it's a current one. My problem is that I can't get the months in between when, how do I do that? Any ideas? $current_month is a php variable. (MONTH(start)= '$current_month' OR MONTH(end) = '$current_month') AND end = CURDATE() Greetings from Sweden Jimmy. Sir, try (MONTH(start) = $current_month AND MONTH(end) = $current_month) AND end = CURDATE() The MS Titanic (my wintel machine) just sank again, so I don't have a machine I can run the statement on to see if it is correct. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak MySQL list magic words: sql query database - 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't build mysqlgui-1.7.5
Hi! Your two problems are easily explained. You do not have edfile.o, because you have not built fl_editor. Second, 2.95.3 has some serious problems with STL libraries, that is why I suggest you downgrade to 2.95.2. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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't build mysqlgui-1.7.5
Adam Stein writes: I have just compiled fl_editor-0.4.1. Here is the list of .o files that get created: ./src/Fl_Editor.o ./src/Fl_FancyEditor.o ./src/Fl_FancyMultiEditor.o ./src/Fl_MultiEditor.o ./src/Fl_ProgressBox.o ./src/Fl_StatusPanel.o ./src/editengine.o ./src/lists.o ./src/wstring.o ./test/progress.o ./test/simple.o ./test/single.o ./test/status.o ./test/multiple.o ./test/multfunc.o There is still no "edfile.o". Adam -- Adam Stein @ Xerox Corporation Email: [EMAIL PROTECTED] Disclaimer: All views expressed here have been proved to be my own. [http://www.csh.rit.edu/~adam/] I have not used 0.4.1, only 0.4. Edit Makefile and kick out edfile.o. It was there due to the error in fl_editor building process. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: MYSQL Problem
Are you sure about that number? 1,000 queries per second is pretty high. Assuming that 10k per second is correct, that translates to 36,000,000 queries per hour. That is quite a lot. BTW, what DB were you using before and was its inability to handle your load a factor in your decision to switch? Have you tried setting limitations on the number of concurrent connections and such. Very possibly, your server is being completely overwhelmed. Also, with that much activity, your database will soon grow beyond your 10gb disk capacity. If you could supply a little more information: 1. What web server and version are you using? 2. What threads library and version? 3. What OS and version? 4. What other applications might you have loaded on the system? 5. What version of MySQL are you using? 6. Which type of DB tables are you using? (MySQL supports a number of table types). 7. Are you using binary distributions or did you compile from the source? 8. If compiled, which compiler and version did you use? 9. Are you using a server-side scripting language and if so what type and version? These basic questions need to get answered before moving forward. Happy hunting Dean -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 11:08 AM To: [EMAIL PROTECTED] Subject: MYSQL Problem Hi Everybody, We have a very popular greetings card site at http://gcards.com We recently switched to MYSQL as our backend database.. But recently we noticed that MYSQL cannot handle high load under normal installation. In our system we get more than 10,000 insert/update/delete/select queries per second sometime. And this creates the problem. Under this circumstances MYSQL failed to respond or get hanged. We have to restart MYSQL then. We are on a dedicated server with 256 MB of RAM and 10 GB disk space. We are trying to figure out the problem but if anybody could help on this that could be gr8. We've a good offer also for this. Whoever will solve this problem will get the source code of our card program FREE. Only dedicated and sound developer/engineer are need to be contacted in the following email address [EMAIL PROTECTED] Best Wishes, The Development Team http://www.gcards.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: Indexes on Nulls
Dennis, Innobase (= InnoDB starting from version 3.23.37) allows you to have an index on a column which may contain nulls. However, the ANSI SQL specification requires that the columns in a primary key are declared as not null. If your main key may can contain nulls, do not define a primary key at all, only an ordinary index. Example: CREATE TABLE D1 (A INT, B INT, INDEX (A)) TYPE = INNOBASE; Regards, Heikki "DG" == Dennis Gearon [EMAIL PROTECTED] writes: DG Is it true no indexing on Nulls In the Innobase database tables and DG MyIASMDG tables? Dunnow about Innobase tables, but MyISAM tables let you have indexes on nullable columns. ISAM did not.-- - 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: 'MY_MUTEX_INIT_FAST' undeclared
[EMAIL PROTECTED] writes: Description: When running make after ./configure, make stopped at an error stating debug.c: In function 'init_dbug_state': debug.c: 344: 'MY_MUTEX_INIT_FAST' undeclared. I found out later that this same variable is undeclared in other files as well. Could you tell me what type 'MY_MUTEX_INIT_FAST' is suppose to be so I can continue compliation? Thank you for any help you can give me. How-To-Repeat: Compile source under MacOS X Fix: So far, declare the this variable. Submitter-Id: submitter ID Originator:System Administrator Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.27-beta@MYSQL_SERVER_SUFFIX@ (Source distribution) Environment: MacOS X release version on iBook G3 System: Darwin localhost 1.3 Darwin Kernel Version 1.3: Thu Mar 1 06:56:40 PST\ 2001; root:xnu/xnu-123.5.obj~1/RELEASE_PPC Power Macintosh powerpc Some paths: /usr/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='cc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxr-xr-x 1 root wheel 15 Dec 31 1969 /usr/lib/libc.dylib - libSystem.dyl\ ib Configure command: ./configure --prefix=/usr/local/mysql Hi! Please try to build with version 3.23.37. It is also possible that your my_pthread.h is broken. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Changes to compile successfully on Mac OS X release
Rick Mann writes: I'd like to get a minor source change into the next revision of MySQL to make the standard source distribution compile on Mac OS X. I read somewhere to use some diffing tool when providing the bug report, but can't find those instructions. What's the proper way to get the revision into the tree? TIA, Roderick Mann rmann @ latencyzero.com.sansspam Hi! Just send us a diff output. Please do not forget to add your changes with conditionals. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Selecting rows for editing
That is what the autoincrement ID field is usually used for. UPDATE mytable SET thisfield=newvalue where id=THISID; Martin Skjldebrand wrote: Hi, Now I'm completely stuck. I am codeing a (basic at this point) stock inventory in PHP/MySQL. I have all items in a table displayed in a table in PHP. Like this: if ($isstock 0) { //get value from a check on mysql_num_rows if ($action != "Edit") { for ($i = 0; $i = $isstock -1; $i++) { $row = mysql_fetch_array($query_res); print "tr"; print " td".$row['s_id']."/td"; print " td".$row['s_description']."/td"; print " td".$row['s_price']."/td"; print " td".$row['s_stock_quantity']."/td"; print " tdN/I/td"; print " tdN/I/td"; print " tdinput name='action' value='Edit' type='submit'input name='action' value='Delete' type='submit'/td"; print "/tr"; } } Now I want to edit the specific ".$row['s_id']." How do I pass this to MySQL in a usefull manner? Is there a specific row number in a MySQL table I can access and pass to a variable? (Thought is too do something along the lines of (totally ficticous): $rownum = mysql_get_rownum($result); $rownum = "txtItem" . $rownum; and then input type='hidden' name='Item' value='$rownum' Any ideas? Martin S. - 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: question
Deneen Petty writes: Hello, I used to use a version of your client. The program I have is "mysqlgui-win-1.4a". I am using Windows 98. Could you tell me what the latest version of your software is and what the exact name is? There are so many programs and variations that I seem to be getting confused. I don't administer the databases, I just modify them for a game in a position called a deputy...such as changing room numbers, player descriptions/titles, etc. Any help you could give me would be greatly appreciated. Thank you. Deneen J. Petty Hi! Latest mysqlgui for Win32 is 1.7.4-2 and is located on our GUI clients page. If I understand you correctly, all you want to do is change data in some rows. For that purpose use UPDATE statement with ?var? strings in necessary places in MS Access fashion. You can read more about it in mysqlgui manual. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: HELP TO CORRECT ERROR
Go get the book "MySQL" by Paul DuBois ( New Riders Press ). [EMAIL PROTECTED] wrote: Dear sir/madam, Kindly help me to correct this error sql(): ErrorYou have an error in your SQL syntax near 'mysql SHOW DATABASES;' at line 1 thamks asif www.kwwda.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: Can't build mysqlgui-1.7.5
David Relson writes: Sinisa, Please provide a patch for Makefile showing how to "kick out edfile.o". FWIW, I have fl_editor-0.4 as well as fl_editor-0.4.1 and neither version creates edfile.o as best I can tell. David You can not use regular fl_editor. You must use the one from our site, as I have changed some code to make possible getting query results in the window. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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
ERROR 2013: Lost connection to MySQL server during query
I could not find a reference in the manual to this error message. What could be happening? It is the first problem I have with the database since installation two years ago- well almost three. Thanks, --- Claudia M. Castaneda Phone 301 286 3397 - 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't build mysqlgui-1.7.5
David Relson writes: from http://www.mysql.com/downloads/gui-clients.html, I used the link given in Please note that these are special versions needed to be downloaded from our site: FLTK editor widget 0.4 for MySQLGUI The newest MySQL C++ library Then, ./configure; make; find . -name edfile.o -print I still don't have edfile.o. Perhaps the link to sourceforge is providing the wrong tarball for fl_editor? David I repeat: Download fl_editor from mysqlgui page. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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
Apache upgrade goof up?
I think I might have goofed somewhere. I just upgraded Mysql and apache and php on my server, and the server logs state Apache/1.3.19 (Unix) PHP/4.0.4pl1 mod_ssl/2.8.2 OpenSSL/0.9.5a configured -- resuming normal operations but should'nt it also say something about mysql being tied in to? Troy [EMAIL PROTECTED] "I do not understand what I do, for what I want to do I do not do but what I hate I do" Rom 7:15 NIV --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.249 / Virus Database: 122 - Release Date: 04/13/01 - 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't build mysqlgui-1.7.5
from http://www.mysql.com/downloads/gui-clients.html, I used the link given in Please note that these are special versions needed to be downloaded from our site: FLTK editor widget 0.4 for MySQLGUI The newest MySQL C++ library Then, ./configure; make; find . -name edfile.o -print I still don't have edfile.o. Perhaps the link to sourceforge is providing the wrong tarball for fl_editor? David At 09:56 AM 4/17/01, Sinisa Milivojevic wrote: You can not use regular fl_editor. You must use the one from our site, as I have changed some code to make possible getting query results in the window. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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 David Relson Osage Software Systems, Inc. [EMAIL PROTECTED] Ann Arbor, MI 48103 www.osagesoftware.com tel: 734.821.8800 - 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
Fw: Returned mail: unknown mailer error 255
Hi, I got this funny response from [EMAIL PROTECTED]I thought someone would want to know. (I deleted my orginal message as it included my support contract number!). Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Mail Delivery Subsystem" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:26 AM Subject: Returned mail: unknown mailer error 255 The original message was received at Tue, 17 Apr 2001 16:25:04 +0200 from [EMAIL PROTECTED] [207.99.22.7] - The following addresses had permanent fatal errors - "| mail_to_db.pl --host=localhost --user=mail --db=mail_repository --tabl e=support_mails --stdin" (expanded from: support-db) - Transcript of session follows - Couldn't connect: Access denied for user: 'mail@localhost' (Using password: NO) 554 "| mail_to_db.pl --host=localhost --user=mail --db=mail_repository --tabl e=support_mails --stdin"... unknown mailer error 255 - 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: Apache upgrade goof up?
hi. the mysql code is compiled into the PHP module within apache, so apache wouldn't know anything about it. if you do a ? phpinfo(); ? you can find out information about the mysql version that php is using. hth. -ravi. -Original Message- From: N6REJ [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 10:29 AM To: [EMAIL PROTECTED] Subject: Apache upgrade goof up? I think I might have goofed somewhere. I just upgraded Mysql and apache and php on my server, and the server logs state Apache/1.3.19 (Unix) PHP/4.0.4pl1 mod_ssl/2.8.2 OpenSSL/0.9.5a configured -- resuming normal operations but should'nt it also say something about mysql being tied in to? Troy [EMAIL PROTECTED] "I do not understand what I do, for what I want to do I do not do but what I hate I do" Rom 7:15 NIV --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.249 / Virus Database: 122 - Release Date: 04/13/01 - 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: Fw: Returned mail: unknown mailer error 255
Ken Menzel writes: Hi, I got this funny response from [EMAIL PROTECTED]I thought someone would want to know. (I deleted my orginal message as it included my support contract number!). Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] HI! Don't worry, our sysadms are just changing sendmail and some other stuff. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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
'Sending data' takes 40 seconds ?
Hi peoples, I'm slightly confused as to exactly what 'Sending data' means in a processlist command. I have a query whch outputs precisely one row, and it takes 40+ seconds to 'Send data'. I'd assumed that this was simply the sending of the query result from server - client...am I incorrect ? regards, P mysql show processlist; +--+--+---+--+-+--+--+--+ | Id | User | Host | db | Command | Time | State| Info | +--+--+---+--+-+--+--+--+ | 7568 | hot | localhost | hot | Query | 55 | Sending data | select count(distinct(cookie)) from tbl_webevents where event_time = from_unixtime(983833200) and e | +--+--+---+--+-+--+--+--+ 1 row in set (0.00 sec) mysql show processlist; +--+--+---+--+-+--+--+--+ | Id | User | Host | db | Command | Time | State| Info | +--+--+---+--+-+--+--+--+ | 7568 | hot | localhost | hot | Query | 63 | Sending data | select count(distinct(cookie)) from tbl_webevents where event_time = from_unixtime(983833200) and e | +--+--+---+--+-+--+--+--+ 1 row in set (0.00 sec) mysql show processlist; +--+--+---+--+-+--+--+--+ | Id | User | Host | db | Command | Time | State| Info | +--+--+---+--+-+--+--+--+ | 7568 | hot | localhost | hot | Query | 67 | Sending data | select count(distinct(cookie)) from tbl_webevents where event_time = from_unixtime(983833200) and e | +--+--+---+--+-+--+-- -- --- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 --- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a - 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
can not find libz.a on an AIX RS/6000
Description: WHen running the mysql_install_db, the script failed because it could not find the lib libz.a, which is not on the AIX system. We are running AIX 4.3 How-To-Repeat: Run the script scripts/mysql_isntall_db Fix: Submitter-Id: submitter ID Originator: Organization: Software Techniques, inc [EMAIL PROTECTED] MySQL support: none Synopsis: can not run the install script mysql_install_db Severity: critical Priority: high Category: mysql Class: support Release: mysql-3.23.36 (Official MySQL binary) Environment: System: AIX ibm570h 3 4 12656700 Some paths: /usr/bin/perl /usr/bin/make /usr/vac/bin/cc Compilation info: CC='gcc' CFLAGS='-O3 -mcpu=powerpc -Wa,-many ' CXX='c++' CXXFLAGS='-O3 -mcpu=powerpc -Wa,-many -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 bin bin 19 Apr 28 1999 /lib/libc.a - /usr/ccs/lib/libc.a lrwxrwxrwx 1 bin bin 19 Apr 28 1999 /usr/lib/libc.a - /usr/ccs/lib/libc.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --disable-shared Perl: This is perl, version 5.005_02 built for aix - 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
Error: Didn't find any fields in table 'name'
Pentium III 667 mhz, 256mb ram, 20 gb hd OpenBSD 2.7 MySQL 3.22.32 (installed with pkg_add mysql-3.22.32.tgz) started with: safe_mysqld --user=mysql /dev/null I have several text files that look like this: use mydb; create table mytable ( (field defs) ); I run: mysql file.sql Then I run: mysql mydb mysql displays: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'table1' Didn't find any fields in table 'table2' Didn't find any fields in table 'table3' Didn't find any fields in table 'table4' Didn't find any fields in table 'table5' Didn't find any fields in table 'table6' Didn't find any fields in table 'table7' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 28 to server version: 3.22.32 Type 'help' for help. mysql When I go to the data directory and type ls -l *.ISD many of the *.ISD files are zero length. Why am I using OpenBSD 2.7? Because MySQL doesn't work on OpenBSD 2.8 because of a bug in OpenBSD (http://www.mysql.com/doc/O/p/OpenBSD_2.8.html) Please help! Thanks - Jim - 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 Documentation ?
Hi This is not a "bug" in the documentation, it is the way you have interpreted what it says On a Win9x/ME system the Windows-System-Directory is called x:\Windows but in Windows NT and Windows 2000 it is called WinNT. If the author meant to write windows(winnt)\system that is what he would have written, not windows-system-directory. So I am sorry to say it is you that is wrong not the documentation writer. At 10:00 17/04/2001 +0300, Yusuf Incekara wrote: in Mysql documents section 4.16.5 Options files it is documented as : MySQL reads default options from the following files on Windows: Filename Purpose windows-system-directory\my.ini Global options C:\my.cnf Global options C:\mysql\data\my.cnf Server-specific options windows-system-directory\my.ini Global options line is incorrect it must be corrected as : windows-directory\my.ini ? Cause when i try to use my.ini option file which is located in c:\windows\system directory it doesn't works. But when i put it into a c:\windows directory it works fine. Regards. Yusuf INCEKARA Avukatpro Limited Sirketi Regards John -- MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK ___/ - 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: Simple question
Hi Did you leave an old version of the shared libs lying around? At 10:16 17/04/2001 +0200, Administrator wrote: I've installed Mysql server version 3.23.36 from source distribution (*.tar.gz). When I show the php4 credits (?phpinfo(); ?) in my browser it shows: MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 3.23.22-beta Why it display other version of client api than I install. It would be nice that You answer me. Adrian Grygier - 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 Regards John -- MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK ___/ - 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
MySql: Cygwin Libraries
Greetings from Canada, Does anyone know of any c++ libraries that are compatible with Cygwin? I want to connect to mysql db Thanks, Kate - 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
Very weird problem
Hi, I am using the newest versions of MySQL,PHPMyAdmin, and PHP4 on IIS server. The MySQLdatabase and PHP is working like a champ, but when I connect to localhost/phpmyadmin it asks me for login/password and domain. The problem is domain. We have a virtual private network here. So the machine is not a part of any domains. It has ip number of 10.24.*.* I can connect to mysql thru mysqld -u root -pmypassword so I know the user name and password are working. Any ideas how I can disable the question for domain or how to get around that problem? Thanks, Oskar Kaszubski Berry College - 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
MySQL ./configure problem
While attempting to configure MySQL on a Sparc platform running Solaris 2.7 using GNU compiler gcc 2.95.2 the ./configure with the --prefix=prefix option failed with the following indications: These messages are from config.log: This file contains any messages produced by compilers while running configure, to aid debugging if configure makes a mistake. configure:810: checking host system type configure:831: checking target system type configure:849: checking build system type configure:884: checking for a BSD compatible install configure:937: checking whether build environment is sane configure:972: checking whether make sets ${MAKE} configure:1018: checking for working aclocal configure:1031: checking for working autoconf configure:1044: checking for working automake configure:1057: checking for working autoheader configure:1070: checking for working makeinfo configure:1172: checking whether to enable maintainer-specific portions of Makefiles configure:1214: checking whether build environment is sane configure:1231: checking whether make sets ${MAKE} configure:1299: checking for gawk configure:1331: checking for gcc configure:1444: checking whether the C compiler (gcc ) works configure:1460: gcc -o conftest conftest.c 15 configure:1486: checking whether the C compiler (gcc ) is a cross-compiler configure:1491: checking whether we are using GNU C configure:1500: gcc -E conftest.c configure:1519: checking whether gcc accepts -g configure:1555: checking for c++ configure:1587: checking whether the C++ compiler (c++ ) works configure:1603: c++ -o conftest conftest.C 15 configure:1629: checking whether the C++ compiler (c++ ) is a cross-compiler configure:1634: checking whether we are using GNU C++ configure:1643: c++ -E conftest.C configure:1662: checking whether c++ accepts -g configure:1694: checking how to run the C preprocessor configure:1715: gcc -E conftest.c /dev/null 2conftest.out configure:1819: checking for ranlib configure:1929: checking for ld used by GCC configure:1991: checking if the linker (/usr/ccs/bin/ld) is GNU ld configure:2007: checking for BSD-compatible nm configure:2043: checking whether ln -s works ltconfig:603: checking for object suffix ltconfig:604: gcc -cconftest.c 15 ltconfig:629: checking for executable suffix ltconfig:630: gcc -o conftest conftest.c 15 ltconfig:776: checking if gcc PIC flag -fPIC works ltconfig:777: gcc -c -fPIC -DPIC conftest.c 15 ltconfig:829: checking if gcc supports -c -o file.o ltconfig:830: gcc -c -o out/conftest2.o conftest.c 15 ltconfig:862: checking if gcc supports -c -o file.lo ltconfig:863: gcc -c -c -o conftest.lo conftest.c 15 ltconfig:914: checking if gcc supports -fno-rtti -fno-exceptions ltconfig:915: gcc -c -fno-rtti -fno-exceptions -c conftest.c conftest.c 15 ltconfig:958: checking if gcc static flag -static works ltconfig:959: gcc -o conftest -static conftest.c 15 ltconfig:1653: checking if global_symbol_pipe works ltconfig:1654: gcc -cconftest.c 15 ltconfig:1657: eval "/usr/ccs/bin/nm -p conftest.o | sed -n -e 's/^.*[ ]\([BDT]\)[ ][ ]*\(\)\([_A-Za-z][_A-Za-z0-9]*\)$/\1 \2\3 \3/p' conftest.nm" ltconfig:1709: gcc -o conftest -fno-builtin -fno-rtti -fno-exceptions conftest.c conftstm.o 15 configure:2248: checking for a BSD compatible install configure:2306: checking for bison configure:2339: checking for pdftex configure:2367: checking return type of sprintf This appears on the terminal window: creating cache ./config.cache checking host system type... sparc-sun-solaris2.7 checking target system type... sparc-sun-solaris2.7 checking build system type... sparc-sun-solaris2.7 checking for a BSD compatible install... /usr/local/bin/install -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... yes checking for working aclocal... found checking for working autoconf... found checking for working automake... found checking for working autoheader... found checking for working makeinfo... found checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for gawk... gawk checking for gcc... gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... yes checking whether gcc accepts -g... yes checking for c++... c++ checking whether the C++ compiler (c++ ) works... yes checking whether the C++ compiler (c++ ) is a cross-compiler... yes checking whether we are using GNU C++... yes checking whether c++ accepts -g... yes checking how to run the C preprocessor... gcc -E checking for ranlib... ranlib checking for ld used by GCC... /usr/ccs/bin/ld checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking for BSD-compatible nm... /usr/ccs/bin/nm -p checking whether ln -s works... yes updating cache ./config.cache checking
Re: Simple question
At 19:31 17-4-01 +0100, John Dean wrote: Hi Did you leave an old version of the shared libs lying around? The old version is packed with PHP.. Bye, B. query sql - 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
MySQL Reports No More Connections - How to Troubleshoot?
I have a Web app that uses PHP4 to connect to a mySQL server (3.22.26) on Red Hat 6.0 (Dual Pentium III). The site is very popular and every once and a while PHP can't connect to mySQL because of "Too Many Connections". I log in to the server and I am unable to execute a mysqladmin shutdown because it claims it can't find the mysql.sock file... Trying to login via mysql reports no more connections as well. I'm trying to figure out the best way to troubleshoot this. I increased the max connections to 150 but that didn't really seem to help. I assume there is a deadlock somewhere, probably with an INSERT? What's the best way to figure this out if I can't get into the server at all when it locks up? Hunter - 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
Mysql to Mdb
Hello I need export data from MySql to Access(MDB), but must to be in Web. I'm use PhpMyAdmin. Help-me please. See U, Silvio
RE: Mysql to Mdb
hi, Hello I need export data from MySql to Access(MDB), but must to be in Web. I'm use PhpMyAdmin. which platform do you use? i had a similar problem with access to mssql, where i could not access the sql server via the administration toolkit. so i wrote an asp script that created the tables in mssql (that could be done locally on your pc with access) and then opens access and transferred it to the server. may this be a way? ciao sascha - 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: MySQL Reports No More Connections - How to Troubleshoot?
What's the best way to figure this out if I can't get into the server at all when it locks up? Few thoughts: - release the connection in your code.. - use pconnect instead of connect.. Check the logs.. if you have any.. Bye, B. query sql - 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
Query with JOIN
Hi All, this is my problem: 2 tables.. 1) workgroup(id_survey,id_user,...) ..where i put reference of user with multiple istances. 2) user(id_user,name,surname,...) ..where there're all users i need to select with a single query what user aren't in workgroup. I've tried some query+join but i didn't retrieve right data. i tried: select distinct a.id_user,a.name, a.surname from user a, workgroup b where a.id_user b.id_user; Could someone help me? -- Daniele Medri - 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: Query with JOIN
SELECT a.id_user,a.name, a.surname from user a LEFT JOIN workgroup b ON a.id_user=b.id_user WHERE b.id_user IS NULL; Daniele Medri [EMAIL PROTECTED] wrote: Hi All, this is my problem: 2 tables.. 1) workgroup(id_survey,id_user,...) ..where i put reference of user with multiple istances. 2) user(id_user,name,surname,...) ..where there're all users i need to select with a single query what user aren't in workgroup. I've tried some query+join but i didn't retrieve right data. i tried: select distinct a.id_user,a.name, a.surname from user a, workgroup b where a.id_user b.id_user; Could someone help me? -- Daniele Medri - 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
C-ISAM / MySQL integration.
I have a program that creates C-ISAM files and I want to access the data via mysql. I have a question about integrating a C-ISAM library into the mysql source. I noticed that mysql uses myisam files, but I'm wondering what steps would be involved to have it support C-ISAM. Would creating a wrapper for the myisam library be enough (or rewriting the myisam lib functions for c-isam files)? 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
Re: problems with 'make test' under OS X 10.0.1
Hmm. I did the ./mysql-test-run script (/usr/local/mysql-test/) and I got the following results: Starting Tests TEST USER SYSTEM ELAPSEDRESULT alias 0.02 0.01 0.26 [ pass ] alter_table 0.03 0.02 0.39 [ pass ] analyse 0.04 0.00 0.20 [ pass ] auto_increment0.02 0.04 0.34 [ pass ] backup0.03 0.03 0.30 [ pass ] bdb-crash 0.02 0.02 0.08 [ pass ] bdb [ fail ] /usr/local/bin/mysqltest: Can't get stat of 'r/have_bdb.require' (Errcode: 2) real 0.09 user 0.04 sys 0.02 Aborting. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon Warning; Aborted waiting on pid file: '/usr/local/mysql- test/var/run/mysqld.pid' after 10 seconds Master shutdown finished Warning; Aborted waiting on pid file: '/usr/local/mysql- test/var/run/mysqld-slave.pid' after 10 seconds Slave shutdown finished Course I could only get that to work after moving mysqld from /usr/local/libexec/ to /usr/local/bin/ because mysql-test-run would fail saying it couldn't find mysqld (looking in ../bin). It looks like it will not actually shutdown mysqld -- which is a problem I have in general.. mysqladmin -u root shutdown will just hang. Looks like there is a file lock problem on the .pid file ??? I get lots of errors on the tests as well. host_bdb.required (and several others) missing. make test fails -- probably because the file it is looking for is mysql-test-run but the file in the directory it goes to look (srcdir/mysql-test/) contains mysql-test-run.sh (different file name, same file). so there are problems here and I'm afraid I don't know enough to either fix them or help you further. Anyone out there have more info, thoughts? peace, Tyler On Tuesday, April 17, 2001, at 05:59 PM, Eric Peden wrote: I find myself unable to successfully complete a 'make test' on Mac OS X 10.0.1 with MySQL 3.23.36. The build goes successfully, but one of the tests freezes up completely. After letting the test run for a good 12 hours (not a typo), no progress was made. I can find no errors in the system.log that would suggest a problem; things just freeze up. Any suggestions on getting more information on the error to help fix the problem? A snipped copy of where the tests freeze up is included below. --- snip --- replace 0.02 0.04 0.26 [ pass ] rollback 0.04 0.04 0.25 [ pass ] rpl01 0.04 0.02 0.61 [ pass ] --- snip --- And nothing else is output after that test. Suggestions are appreciated. --eric -- - 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 - 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: Administrator Software
You wrote: I am using KaneyanMySQLAdmin to administrator the linux mysql server remotely but i am unable to connect it. From: "Mitunobu Kaneko" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Sat, 14 Apr 2001 15:27:00 +0900 Subject: Administrator Software The English version of KaneyanMySQLAdmin currently exhibited in Japan was made. Please use, although it does not know whether to operate normally since there is no English development environment. This software is free software. http://sql.jnts.ne.jp/english/ http://database.jnts.ne.jp/download/KMYENG113.lzh #If it can do, I want you to introduce by Contributed software of MySQl Site. #Is it useless? -- Kaneyan mailto:[EMAIL PROTECTED] Join Ntwaork Total Service, - 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: inverse function
use the ORDER BY clause with the SELECT SELECT * FROM table ORDERBY fieldname ASC (or replace ASC with DESC for descending order) Siggy - Original Message - From: "Michael M. Ocana" [EMAIL PROTECTED] To: "Mysql Lists" [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 2:55 PM Subject: inverse function Subject: inverse function (database,sql,query) hello anybody knows how to invert selected records? example : i have selected records : apple mangoe cherry avocado if i invert it : avocado cherry mangoe apple how can i do this? in DBI? or in my SELECT statement? 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
Query help
I'm trying to build a query for a calendar program for a web site. Basically, I want a query that will print a word if there is an event booked on that day. Here's how the relevant tables are laid out and what they mean: TABLE: activities AID - Primary Key ALocation AEmail AName ADay AMonth AYear ACost ATime TABLE: clientactivities CAID - Primary key CUserName AID - Foreign key from activities Basically, activities lists all the activities announced by members. Client activities shows all the events that a person has signed up for. How can I build a query that will accommodate both tables. Currently, i've got: SELECT * FROM activities WHERE (activities.CUserName='$CUserName' AND ADay='$d' AND AMonth='$themonth' AND AYear='$y') OR activities.AID = clientactivity.AID) But it doesn't quite work. Thanks, Mike _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
Re: [PHP] select question
"Matt "TrollBoy" Wiseman" [EMAIL PROTECTED] wrote: How would I word a query to see what tables exist in a db that begin with box for example include boxTABLE1 boxTABLE2 boxTABLE3 but exclude sphereTABLE1 I'm basically trying lo populate a list box with the tables beginning with box in PHP. Use the SHOW TABLES command within PHP and loop through the results and grab those that match your criteria. Or use PHP directory functions (readdir and associated functions) or a system ls function within backticks (like `ls -1 $prefix*`) to read the files within the directory containing the database. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.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
RE: [PHP] select question
On 17-Apr-01 Matt \"TrollBoy\" Wiseman wrote: How would I word a query to see what tables exist in a db that begin with box for example include boxTABLE1 boxTABLE2 boxTABLE3 but exclude sphereTABLE1 I'm basically trying lo populate a list box with the tables beginning with box in PHP. mysql show tables; +-+ | Tables_in_cache | +-+ | admh020 | | ctl | | hs021132| | pending | | signc | | signd | | tmpc| | tmpd| | trnc| | trnd| +-+ 10 rows in set (0.02 sec) mysql show tables like 'tmp%'; ++ | Tables_in_cache (tmp%) | ++ | tmpc | | tmpd | ++ 2 rows in set (0.02 sec) Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - 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
select question
How would I word a query to see what tables exist in a db that begin with box for example include boxTABLE1 boxTABLE2 boxTABLE3 but exclude sphereTABLE1 I'm basically trying lo populate a list box with the tables beginning with box in PHP. Matt "Trollboy" Wiseman www.shoggoth.net/trollboy/trollboy.jpg [EMAIL PROTECTED] "I wish the world had one throat!!" -Al Bundy - Please do not resell my e-mail address to anyone or send me unsolicited e-mail - - 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
I got Virus alert!??
Hi, I recently downloaded MySQL RPM-packages from your site and right after my virusscanner started screaming that it has found a virus?!? It didn't display a name and was unable to clean it...here's where it was found: "mysql-3.23.36-ibm-linux-gnu-s390.tar.gz\mysql-3.23.36-ibm-linux-gnu-s390.ta r" False alarm?? My scanner is McAfee 5.16 with 4.0.4133 DAT files. Please reply. -Jari - 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
Problem in running mysqld
Hi, I have SuSE 7.1 installed on my machine. SuSE 7.1 comes with MySQL 3.23.32. When in try to run mysqld, i am getting the following error: Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!! But i couldn't find any section called "Security" in the manual. I also tried running safe_mysqld. The following is the message it got: Starting deamon with database from /var/lib mysql mysql ended. safe_mysqld atleast creates the mysql.sock socket. The manual says there will be a log created corresponding to the error in /var/log. But i couldn't see any log created. Any help will be highly appreciated. Regards, Ganesh Ganesh Krishnan Software Trainee iCOPE Technologies Pvt. Ltd. (www.icope.com) 111/112, 3rd Cross,1st Main, 7th Block Koramangala Bangalore - 560 095 Phone : 5716909, 5716939, 5715213 Fax : 5716908 - 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
Getting error while accessing from Apache
Hi I tried to connect with MySQL from Java Webserver, it was connected and got interacted with MySQL thru my programs. No problem for this. When i tried the same with Apache i am getting the following error [18/04/2001 05:53:12:063] (ERROR) ajp12: Servlet Error: java.lang.NullPointerException: null [18/04/2001 05:53:12:063] (ERROR) an error returned handling request via protocol "ajpv12" I tried with default servlet zone and user created servlet zone also. In both cases i am getting the same error. My servlets and htmls are working fine with default and user defined alias/zones in Apache. I am getting the problem when i am connecting to Database (MySQL). My Operating System is Windows NT. I am using org.gjt.mm.mysql.Driver to connect with MySQL from my program. Can any one send me the solution and reason why it is like this. Thanks in advance Rgds venkatesh - 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
Red Hat 6.2 hangs on Installing all prepared tables
I'm having big problems installing MySQL 3.23.36 on Red Hat 6.2. I've read some other accounts of the same problem in the archives. I've tried all the fixes there and nothing works. I've tried removing all files and starting fresh, changing ownerships, privs, etc. What's happening and how do I fix it? Some people have said to make sure the privs and ownerships are right. What should they be? Could anything else be causing this? Thank you, Ryan - 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