Re: will this work? [phpMyAdmin]
how do i configure phpMyAdmin? i'd rather be reading a manual but i cannot find one that i can understand. i have iTools, Apache and MySQL... and PHP4. i know MySQL works because i have made a db with my Terminal. but i have never made a login or password for MySQL, i simply logon to my computer as root. if PHP needs to be started and configured i do not know how. please help. i just want to get it running so i can continue. i am not allowed to post the phpMyAdmin list that i have subscribed to. as far as i can see there is no simple setup manual. thank you in advance. Ted - 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
No answer for previous mail : Use of mysql_use_result in ODBC driver
Hi, I had not answer at my first mail... Sorry for posting it again but this is really important for us. -Message d'origine- De : Patrick FICHE [mailto:[EMAIL PROTECTED]] Envoy : lundi 12 fvrier 2001 18:09 : Mysql Objet : Use of mysql_use_result in ODBC driver ? Hi all, I would like to change the do_query function in execute.c module in the ODBC driver to use mysql_use_result function instead of mysql_store_result function. There is currently some comments with an eventual problem in case of SQLRowCount function. To my mind, the only thing would be that SQLRowCount could only return a result on UPDATE, INSERT and DELETE statements but not anymore on SELECT statement if you didn't retrieve all the rows. But the return value of SQLRowCount function is driver-defined for SELECT statements... So is it really a problem? Thanks for your help Patrick __ Patrick Fiche - Prologue Software (France) Software Engineer Email: [EMAIL PROTECTED] Internet : http://www.prologue-software.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: TEXT's are giving us headaches!
Hello We use MySQL 3.23.32, so I recently added a FULLTEXT index for this field on all forums and changed the source code to make use of the MATCH() AGAINST() MySQL call. If you make FULLTEXT queries over many tables, and combine the results afterwards, you might get into problems with 3.23.32, as there was a bug, see my previous message [EMAIL PROTECTED]. The problem is fixed in 3.23.33. (Thanks Sergei!) If this is your case, you may try to upgrade. If it's not, have you tried all the EXPLAIN SELECT and friends? (the manual, chapter 12) cheers -- TS - 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
a queston about make mysql
Hi, : I had a question when i make mysql 3.23.32,i got the massage as below(i use tarball mysql-3.23.32.tar.gz and had finished ./configure ) : c++ -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I.. -I..-D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=64 -O3 -DDBUG_OFF -fno-implicit-templates -DHAVE_RWLOCK_T -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -c mysql.cc In file included from mysql.cc:54: /usr/include/term.h:1060: syntax error before `,' /usr/include/term.h:1081: syntax error before `;' /usr/include/term.h:1082: syntax error before `;' /usr/include/term.h:1101: syntax error before `[' /usr/include/term.h:1108: syntax error before `*' /usr/include/term.h:: syntax error before `;' /usr/include/term.h:1115: syntax error before `;' /usr/include/term.h:1116: syntax error before `;' /usr/include/term.h:1207: `chtype' was not declared in this scope /usr/include/term.h:1207: parse error before `(' make[2]: *** [mysql.o] Error 1 make[2]: Leaving directory `/usr/local/src/unzip/mysql-3.22.32/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/unzip/mysql-3.22.32' make: *** [all-recursive-am] Error 2 Maybe it something with my system.I have a SUN 250 server with SOLARIS 8 chinese version, i use GNU make,gcc and tar. Would you please to help me check it out? Thanks a lot! your sincerely ban
mysql os x server
Hello, i'm new on unix like sytem and on mysql, and i try to install mysql 3.23.33 on MACos x server. I downloaded the archive, decompressed it into serverOSX/usr/local/ with the commend tar -zxvf mysql-3.23.33-apple-rhapsody5.5-powerpc .tar.gz i got a folder named "mysql-3.23.33-apple-rhapsody5.5-powerpc",i created a link to this folder with ln -s mysql-3.23.33-apple-rhapsody5.5-powerpc mysql, i added a group mysql, added a user mysql at this group (using the network manager, not the shell), but when i wanted to run the mysql_install_db script, it wrote in a shell window named 'Dead Terminal': my_print_defaults: not found Didn't find ./bin/mysqld You should do a 'make install' before executing this script [Process exited - exit code 1] can someone help me? thank you, charlie EISSEN
Re: WISHLIST
Hi, I would like to see some 'bash-like' abilities for an alias command and a .mysql file or something similar to store commonly used queries (to be accessed by a single keyword). I find myself writing extremely long queries from time to time and I have to store them in a text file and worry about copying and pasting to use them. No need for new features! What you use at the moment (storing frequently-used queries in text files) just happens to be the perfect solution, with but one change. You don't need to manually copy and paste your queries from text files. Simply tell MySQL to 'execute' the file's contents, like so: mysql source /path/to/your_stored_query.sql Or you can use the shorthand version: mysql \. /path/to/your_stored_query.sql In fact, the latest versions of the MySQL client program have lots of useful options like this (such as paging, outputting to a file, etc.). Just type "help" for details of all available commands. Regards, Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP and MYSQL Frustrations...
I can think of a couple of things. You have the wrong URL somewhere in your code, your web server isn't configured correctly or compiled PHP incorrectly. Either way, this does not relate to MySQL and you are much better off asking the PHP list. You may want to try accessing normal HTML pages through the webserver first. If you can't, then you have a web server configuration problem and your best off asking the appropriate list. Also, try running the query from mysql directly. If you get results then you have no problem on the mysql side of things. - Original Message - From: "Steve Rodda" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 13:03 Subject: PHP and MYSQL Frustrations... I don't understand will someone please look at this code and see what is wrong. ?php $dbglobal = mysql_connect('localhost', 'mylog', 'mypass'); mysql_select_db('test', $dbglobal); $query ="SELECT * FROM emails Where id 100"; $result = mysql_query($query); while(list($ID, $EMAIL) = mysql_fetch_row($result)) print("$ID EMAILbr\n"); ? All I want to do is display the results in HTML then I will be unstoppable :) But every time I execute this I get Warning: Failed opening 'c:\inetpub\wwwroot\testmail.php' for inclusion (include_path='') in Unknown on line 0 And no matter what I put in that like in php.ini I get that error. Please if it is obvious let me know other wise please give me some de bugging techniques I am new to both PHP and MYSQL. BTW other scripts run fine just in talking to MYSQL do I get this problem. Thanks in advance.. Steve - 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
Unsatisfied symbols-mysql_init
hi, i recently downloaded mysql-3.23.32-hp-hpux10.20-hppa1.1.tar.gz , and tried writing a very simple code to start with . i just made a call to mysql_init() and mysql_connect() in the sample code . i used aCC ( version : aCC: HP ANSI C++ B3910B A.01.21) on a HPUX 10.2 machine . i am linking to libraries available in /mysqldepot/mysql-3.23.32-hp-hpux10.20-hppa1.1/lib i get the following /usr/ccs/bin/ld: Unsatisfied symbols: mysql_connect (code) mysql_init (code) i wld be greatly obliged if someone can figure out if i am doing something wrong. thank you ragu - 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
Memo fields
Hi everyone, Got a problem, hopefully somebody can help. I am using Mysql version 3.22.32 and MyODBC version 2.50.3300 to connect to a Lotus Approach 97 front-end. I have a number of fields that are of the type "blob" which match up to the field type "memo" in Lotus Approach. If I insert data into the "blob" fields directly from the backend I have no problem viewing the data from the Lotus front-end. However if I try to write data to the "blob" field via the frontend the backend does not seem to be reading it in. I have connected the same backend to a Microsoft Access frontend with no problems - being able to write and retrieve data from the backend. Unfortunately due to the nature of the project I need to have it working with the Lotus Approach front-end. Is this a known problem? Has anybody had similar problems? Do later release solve the problem?--- Faizal Mangera Systems Department CarnaudMetalbox Engineering Shipley West Yorkshire BD17 7AY Tel: 01274 846386 Fax: 01274 846201 [EMAIL PROTECTED] CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the confidential use of the above named recipient. If you are not the intended recipient or person responsible for delivering it to the intended recipient, you have received this communication in error and must not distribute or copy it. Please accept the sender's apologies, notify the sender immediately by return e-mail and delete this communication. 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
mysql/php
How can I output "no records found" when there is no record found? This is the query I am using. SELECT * FROM $table where description LIKE '%$keyword%' Is there a sql statment that will return a string if no record exists? Thanks in advance. _ ___ | | | \ | | | |__ | | || |__ |||___/ || Larry L. [EMAIL PROTECTED] www.ldlenterprise.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
Individual updatelogs for each database
Hello All, What I would like to be able to do is have individual update logs for each of my databases rather than have one update log which gets written to by all the databases and contains various use db_name; statements to distinguish between the databases. The server version this question relates to is 3.22.32. So, if I have a db called test, I would like all DML related to this db to be placed in a log file call, say updatelog_test.001 and for a db called test2 to be written to a log file called updatelog_test2.001. At the moment, in /etc/my.cnf I have the 'log-update=updatelog' option set, and I have written a script that will go through our update logs (which get flushed on the hour) to extract the updates that are relevant to the desired database, re-directing those to a file, which would then be applied to our nightly dump of the db if we had to reconstruct it. But instead of the updatelog containing updates to all of our mysql databases I would like an updatelog for each one. So does anyone know if it is possible to do this. If so, thanks in advance. I have to say that looking through the docs. and manuals, there doesn't seem to be any options that indicate this is possible - but you live and learn and I am probably wrong!. Hope what I want to do is clear. Thanks in advance, William Hargrove www.dsc.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
starting second mysql process gives process already exists error
Hi, I need to start 2 mysql server processes on the same box (Redhat Linux release 6.2), using the following 2 commands: bin/safe_mysqld -u root --socket=/tmp/test1.sock --port=9000 and bin/safe_mysqld -u root --socket=/tmp/test2.sock --port=9020 Previously I was using mysql 3.23.27 beta and it works fine. Now I'm switching over to the newer version 3.23.32, and I am not able to start the second process any more. The second command keeps giving me "A mysqld process already exists" message. I look into the .err file and the first command gives: 010215 17:52:50 mysqld started /usr/local/mysql-3.23.32-pc-linux-gnu-i686/bin/mysqld: ready for connections while the second gives: A mysqld process already exists at Thu Feb 15 17:53:20 SGT 2001 Is there any special setting that I need to make to solve the problem?. Any help very much appreciated. Thanks. Lois - 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
auto_increment problem with mysql 3.23.32
Hi, It's me again ;-) Now I have got a very serious problem. I've just downloaded 3.23.32 and compile then run it without any major trouble. BUT my headache is about this: mysql insert into cikk values (NULL,'Beta','','','','','N','','',NULL,0,0,0,0); mysql select * from cikk where cim='Beta'; ++--++++-+++---++--+--+-+---+ | id | cim | cimurl | cimkep | szoveg | hszoveg | fontos | forras | forrasurl | |feldatum | felvitte | moddatum | modositotta | tipus | ++--++++-+++---++--+--+-+---+ | -1 | Beta |||| | N || | |20010214120417 |0 |0 | 0 | 0 | ++--++++-+++---++--+--+-+---+ I've tried use 0 or NULL as value for 'id' when doing the insert query. The structure of table 'cikk' is: CREATE TABLE cikk ( id bigint(20) NOT NULL auto_increment, cim varchar(200), cimurl varchar(100), cimkep mediumblob, szoveg text, hszoveg text, fontos enum('Y','N') DEFAULT 'Y' NOT NULL, forras varchar(200), forrasurl varchar(100), feldatum timestamp(14), felvitte bigint(20), moddatum bigint(20), modositotta bigint(20), tipus bigint(20) DEFAULT '0' NOT NULL, KEY id_index (id), KEY tipus_index (tipus), KEY feldatum_index (feldatum), KEY fontos_index (fontos) ); Any values inserted the table become id -1 ... ;-( However if I try declare id as unsigned I got an awfull big number as 'id', and I can't even delete it with 'delete from cikk where id=.;', mysql monitor simply returns that 0 row is affected, and the data is still exists in the table. It's very serious for me since this is a commercial site. I had to upgrade to new mysql version, since old one became unusable one day (a very long query was blocking mysql forever with all of idle CPU time used. if I tried to strace that mysqld process with strace -p ..., it created a null length file and the process exists. However at home with mysql 3.23.31 it was fine, and with 3.23.32 it's okey too, but now I have got this auto_increment problem). Note, that I USED id -1 in this table for a special purpose, but now I deleted ALL ids smaller than 1 then I tried to insert but it does not work. It didn't work if I tried to dump the database (only with ids0) drop table, then recreate table and data from the saved dump). By the way, the query which had got problems with the older mysql version on our server was: SELECT i.id as id,i.fullservice as fullservice,i.www as www,i.ceg as ceg,v.varos as varos,i.irszam as irszam,i.tel as tel,i.fax as fax,i.email as email,i.tevleir as tevleir,t0.terulet as t0,t1.terulet as t1,t2.terulet as t2,t3.terulet as t3,t4.terulet as t4,t5.terulet as t5 FROM ceginfo as i,cegvaros as v,cegterulet as t0,cegterulet as t1,cegterulet as t2,cegterulet as t3,cegterulet as t4,cegterulet as t5 WHERE i.varos=v.id AND i.terulet0=t0.id AND i.terulet1=t1.id AND i.terulet2=t2.id AND i.terulet3=t3.id AND i.terulet4=t4.id and i.terulet5=t5.id AND ervenyes='Y' AND i.ceg LIKE '%balogh%' ORDER BY ceg LIMIT 0,10; But now it's not problem. My only question is how can I avoid that auto_increment problem. PLEASE, help me. And please cc the mail for me too, I'm not on the list. Thanx a lot in advance, Gabor. -- --[ Gbor Lnrt ]---[ Vivendi Telecom Hungary ]-[ [EMAIL PROTECTED] ]-- U have 8 bit comp or chip of them and it's unused or to be sold? Call me! ---[ +36 30 2270823 ]-- LGB -[ Linux/UNIX/8bit 4ever ]- - 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: Performance of Mysql updation ..
Thiru, Try using DELAYED parameter with your INSERT. - it batches them up more efficiently in another thread. Dave. Thiru wrote: Hello, I am creating a script which works offline from the mainstream of our system and updates our databases. These scripts includes INSERTING, UPDATING and DELETING records. I am performing a updating operation using Python which takes really some time. Something like, update TABLE1 set col1=val1 where col2=something; col2 is indexed. val of something is set inside Python script. This statement is executed atleast 25 times. I beleive for the amt of work it is doing it is really fast, but by any means is there a way to step up the updation speed further?? like changing or adding some config options to my.cnf etc.. Please help. Thiru -o0o "There is no finish line, you can always learn" "You have to keep pressure on yourself, you have to work on your weaknesses". Thiru S/W Engineer, Service Dvlpment Group Infoseek,Japan Voice - (81)-3-5453-2056 http://www.infoseek.co.jp - Click Here http://www.rakuten.co.jp - Click Here http://house.infoseek.co.jp - Click Here http://profile.infoseek.co.jp - Click Here http://chat.infoseek.co.jp - Click Here - 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
Cannot load connection class 'java.sql.SQLException problem !
Hello everyone I am using mysql version 11.12 Distrib 3.23.32 on Red Hat Linux.I am also using a Java Blackdown -1.3.0-FCS and MM.MySQL 2.0-pre2 JDBC driver..I am trying to run the following program : import java.sql.*; public class LoadDriver { public static void main(String[] Args) { try { Class.forName("org.gjt.mm.mysql.Driver").newInstance(); Connection C=DriverManager.getConnection( "jdbc:mysql://localhost/test?user=usernamepassword=password"); C.close(); } catch(SQLException E) { System.out.println(E.getMessage() + ":" +E.getSQLState() +":"+ E.getErrorCode()); } catch(Exception E) {System.out.println("Unable to load driver"); } } } After compilation, when I am trying to run it, I get the follwing error : Cannot load connection class 'java.sql.SQLException: Invalid authorization specification: Access denied for user: 'username@localhost' (Using password: YES)'.:08001:0 Does anyone know why and when occurs this error ? Thanks a lot ! Daniel Ducat - 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: starting second mysql process gives process already exists error
On Wed, Feb 14, 2001 at 07:15:16PM +0800, Neo Sok Lay wrote: Hi, I need to start 2 mysql server processes on the same box (Redhat Linux release 6.2), using the following 2 commands: bin/safe_mysqld -u root --socket=/tmp/test1.sock --port=9000 and bin/safe_mysqld -u root --socket=/tmp/test2.sock --port=9020 Previously I was using mysql 3.23.27 beta and it works fine. Now I'm switching over to the newer version 3.23.32, and I am not able to start the second process any more. The second command keeps giving me "A mysqld process already exists" message. Is there any special setting that I need to make to solve the problem?. Usually you would start the second mysqld using another data directory. safe_mysqld places a .pid file in its data (.../var) directory which it checks for when starting again. If you have separate data directories, each will contain one .pid file and it works fine. Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - 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 program warnning (Just a test i try to understand C in order to build my mysql client program)
Hi folks, I am trying to compile a simple program to play with mysql. But i am running into single problems, but i guess easy to solve by too many of the wizards here. I am too paranoic when compiling my programs, so i activate all warnning (at least i try) flags to gnu c compiler. The problem occurs when type conversion: type conversion is automatic when a functions takes a single pointer to const anything, but when there is a double pointer to a const type and i pass double pointer to a non const type i run into problem? Why in the later case conversion is not automatic? the former is. Here is the simple code (just to test): #include stdio.h int t(const int *i) { printf("%d\n", *i); return 0; } void c(const char **reg) { while (*reg) printf("%s\n", *reg++); } int main(int argc, char *argv[]) { int i; char*reg[] = { "Gustavo", "Vieira", "Goncalves", "Coelho", "Rios", NULL}; i = 10; (void) t(i); c(reg); return 0; } But when compiling: grios@etosha$ cc -ansi -pedantic -Wconversion -Wall -Werror t.c cc1: warnings being treated as errors t.c: In function `main': t.c:30: warning: passing arg 1 of `c' from incompatible pointer type grios@etosha$ Why there is no problem when i pass a int * to as an argument to a function that requires a const int * but when the argument is a double pointer to a const it complains if i pass a double pointer to a non const type. This warnnings always happen even if the argument requirement is of type const [int|float|double|any_thing] ** and the value passed is [int|float|double|any_thing] **. Why automatic conversion does not take place here too ? Thanks a lot for your time and cooperation. - 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: Transaction issues
Berkeley tables (transactions) works for me. I am using RedHat 6.2. I downloaded the sources and just unzipped/tar the Berkeley directly inside the MySQL source directly. I then did .configure and I watched configure tell me that it found the Berkeley directly and would use it. I am still testing the transaction support in my code, but the limited tests have shown that a transaction: BEGIN ... COMMIT, or BEGIN ... ROLLBACK works. Rick - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone: 281-544-5092(WCK) / Fax:281-544-2646(WCK) / email: [EMAIL PROTECTED] - -Original Message- From: Marc Soda [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 2:30 PM To: [EMAIL PROTECTED] Subject: Transaction issues -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello all, I am new to the list and need assistance. I noticed this thread in the archives, but I didn't see an answer. So, I'll ask it again. I have tried several times to use BerkeleyDB with MySQL to provide transaction support. It has failed each time, both in my own tests and through the mysql-test-run utility. It fails when attempting a rollback. The actual rollback command returns with no error, but it doesn't 'undo' anything. Thus, the test suite fails when attempting to insert the same value that should have been undone. My company wishes to use MySQL for a major web based application, unfortunately this hinges on transaction support. I have fought hard to use MySQL for this, but if I can't get this working it was all for nothing. I am using MySQL 3.23.33 (I have tried this with 3.23.32 also) and BerkeleyDB 3.2.3h. Both of which I downloaded from mysql.com. Also, I tried installing BDB compiled in with MySQL and compiling separately, both failed. Anyone??? Thanks - -- Marc Soda ASPRE, Inc. [EMAIL PROTECTED] http://www.aspre.net/ Managed e-Business Application Services - - t. 215.957.2266 Ext. 2144 f. 215.957.2277 c.215.840.1633 113 Rock Road Horsham, PA 19044 -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.4 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE6iZlX8/oGPCGMSEgRAl02AJ9oQ94mAqtwb89ECqejtLYxL/HOGwCg3mNL YVffTgj8c96KRZWQRfPyols= =0eMJ -END PGP SIGNATURE- - 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
Lock with update,insert and select
hi all. i have a problem. i use mysql-3.23.32 on FreeBSD4.2-release my project need to update/insert some datas into mysql every 5mins. but sometims these datas are lots. so i need to reduce the update/insert time as short as possible, prevent it run over 5mins. i found out that if i use LOCK write can inprove the insert/update speed. but by this way. during the lock time, i can;t select until unlock. so... this is a serious problem to me. if there is a good solution to solve it? for example, can i do a select without caring the LOCK write? or there is anyother way to insert/update fast without Lock write? Regards chchen
Re: auto_increment problem with mysql 3.23.32
Gbor Lnrt writes: Hi, It's me again ;-) Now I have got a very serious problem. I've just downloaded 3.23.32 and compile then run it without any major trouble. BUT my headache is about this: mysql insert into cikk values (NULL,'Beta','','','','','N','','',NULL,0,0,0,0); mysql select * from cikk where cim='Beta'; ++--++++-+++---++--+--+-+---+ | id | cim | cimurl | cimkep | szoveg | hszoveg | fontos | forras | forrasurl | feldatum | felvitte | moddatum | modositotta | tipus | ++--++++-+++---++--+--+-+---+ | -1 | Beta |||| | N || | 20010214120417 |0 |0 | 0 | 0 | ++--++++-+++---++--+--+-+---+ I've tried use 0 or NULL as value for 'id' when doing the insert query. The structure of table 'cikk' is: CREATE TABLE cikk ( id bigint(20) NOT NULL auto_increment, cim varchar(200), cimurl varchar(100), cimkep mediumblob, szoveg text, hszoveg text, fontos enum('Y','N') DEFAULT 'Y' NOT NULL, forras varchar(200), forrasurl varchar(100), feldatum timestamp(14), felvitte bigint(20), moddatum bigint(20), modositotta bigint(20), tipus bigint(20) DEFAULT '0' NOT NULL, KEY id_index (id), KEY tipus_index (tipus), KEY feldatum_index (feldatum), KEY fontos_index (fontos) ); Any values inserted the table become id -1 ... ;-( However if I try declare id as unsigned I got an awfull big number as 'id', and I can't even delete it with 'delete from cikk where id=.;', mysql monitor simply returns that 0 row is affected, and the data is still exists in the table. It's very serious for me since this is a commercial site. I had to upgrade to new mysql version, since old one became unusable one day (a very long query was blocking mysql forever with all of idle CPU time used. if I tried to strace that mysqld process with strace -p ..., it created a null length file and the process exists. However at home with mysql 3.23.31 it was fine, and with 3.23.32 it's okey too, but now I have got this auto_increment problem). Note, that I USED id -1 in this table for a special purpose, but now I deleted ALL ids smaller than 1 then I tried to insert but it does not work. It didn't work if I tried to dump the database (only with ids0) drop table, then recreate table and data from the saved dump). By the way, the query which had got problems with the older mysql version on our server was: SELECT i.id as id,i.fullservice as fullservice,i.www as www,i.ceg as ceg,v.varos as varos,i.irszam as irszam,i.tel as tel,i.fax as fax,i.email as email,i.tevleir as tevleir,t0.terulet as t0,t1.terulet as t1,t2.terulet as t2,t3.terulet as t3,t4.terulet as t4,t5.terulet as t5 FROM ceginfo as i,cegvaros as v,cegterulet as t0,cegterulet as t1,cegterulet as t2,cegterulet as t3,cegterulet as t4,cegterulet as t5 WHERE i.varos=v.id AND i.terulet0=t0.id AND i.terulet1=t1.id AND i.terulet2=t2.id AND i.terulet3=t3.id AND i.terulet4=t4.id and i.terulet5=t5.id AND ervenyes='Y' AND i.ceg LIKE '%balogh%' ORDER BY ceg LIMIT 0,10; But now it's not problem. My only question is how can I avoid that auto_increment problem. PLEASE, help me. And please cc the mail for me too, I'm not on the list. Thanx a lot in advance, Gabor. -- --[ Gbor Lnrt ]---[ Vivendi Telecom Hungary ]-[ [EMAIL PROTECTED] ]-- U have 8 bit comp or chip of them and it's unused or to be sold? Call me! ---[ +36 30 2270823 ]-- LGB -[ Linux/UNIX/8bit 4ever ]- Hi! I have just tested your case on my Linux and it worked just fine. What OS is that and are you using our binaries. If not, please do. 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 3.23.33 released
Hi! "Christian" == Christian Hammers [EMAIL PROTECTED] writes: Christian Michael, it would be very nice if you would mark security related bugs Christian so that admins who are not subscribed on Bugtraq see them, too. Christian This is at least the second time where I got information about security Christian bugs in MySQL *only* via 3rd party and not from the web page nor from the Christian changelog. Christian Disappointed, Christian -christian- We normally mark do mark security bugs in the beginning of our announcements. In this case I didn't think that the overflow problem in libmysqlclient.a would be a a security problem; Sorry for not thinking this through. What makes things worse that I didn't notice the change log entry about DROP database; Sasha had fixed this while I was away for a few day. I promise that we will be better in the future! Regards, Monty - 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
SV: Exporting data from MySQL to Oracle
You could use mysqldump which makes CREATE/INSERT statements for mysql, and then you can change the mysql-spesific things like auto_icrement into making an sequence, etc. Oracle is SQL92 compliant and it would work i think. try it :o) mvh: P?l Wester, programmerer never.no as, stortingsgt 30, 0161 Oslo tlf: 22 01 66 20, fax: 22 01 66 21 direkte: 22 01 66 34, 906 900 62 http://never.no - icq:103476059 ~ f u cn rd ts u prb a gk ~ -Opprinnelig melding- Fra: Denis Mettler [mailto:[EMAIL PROTECTED]] Sendt: 13. februar 2001 22:02 Til: Noor Dawod Kopi: [EMAIL PROTECTED] Emne: AW: Exporting data from MySQL to Oracle Hi there, please check the oracle migration bench at the oracle technet. http://technet.oracle.com kind regards denis mettler -Urspr?ngliche Nachricht- Von: Noor Dawod [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 13. Februar 2001 17:23 An: Cal Evans; MySQL List Betreff: RE: Exporting data from MySQL to Oracle I couldn't find such product on Oracle's website. Noor -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 5:51 PM To: Noor Dawod; MySQL List Subject: RE: Exporting data from MySQL to Oracle Didn't Oracle just release a MySQL to Oracle migration kit? Check the Oracle website. Cal http://www.calevans.com -Original Message- From: Noor Dawod [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 8:41 AM To: MySQL List Subject: Exporting data from MySQL to Oracle Hello, I'm having a problem exporting MySQL BLOB's to Oracle, especially those records that has "Carriage Return" or "Line Feed" characters in them. Has anyone done this before, and how did they do it? I need an immediate help in this subject. I'd appreciate you help very much. Thanks Noor - 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
can I use aCC..
hi, basically i am reframing my earlier question. i'm using aCC ( ansic C++ compiler from HP ) on HPUX10.2 to compile and link my small C code with libraries available from mysql-3.23.32-hp-hpux10.20-hppa1.1 . i get the following: /usr/ccs/bin/ld: Unsatisfied symbols: mysql_connect (code) mysql_init (code) i wld greatly appreciate if someone can figure out if something is wrong. thank you ragu - 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 and Mosix
Hello, Did anybody perform MySQL in a cluster of machines using Mosix? Which was the result? Did MySQL uses shared memory? Or MySQL can't upgrade your perform in a cluster? Thanx, -- - | Fbio B. de Paula | [EMAIL PROTECTED] | | Linux Solutions Consultoria | www.olinux.com.br | | www.linuxsolutions.com.br | ICQ: 6399331 | - - 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: Cannot load connection class 'java.sql.SQLException problem !
Hello everyone Thanks for the answer, Jonathan. I have already tried the way you propose, but it gives me the same error. Any other ideas ? Thanks a lot!! Daniel Ducat Lebrun Jonathan wrote: Try this : Connection C=DriverManager.getConnection( "jdbc:mysql://localhost/test","username","password"); - Original Message - From: "Daniel Ducat" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 12:55 PM Subject: Cannot load connection class 'java.sql.SQLException problem ! Hello everyone I am using mysql version 11.12 Distrib 3.23.32 on Red Hat Linux.I am also using a Java Blackdown -1.3.0-FCS and MM.MySQL 2.0-pre2 JDBC driver..I am trying to run the following program : import java.sql.*; public class LoadDriver { public static void main(String[] Args) { try { Class.forName("org.gjt.mm.mysql.Driver").newInstance(); Connection C=DriverManager.getConnection( "jdbc:mysql://localhost/test?user=usernamepassword=password"); C.close(); } catch(SQLException E) { System.out.println(E.getMessage() + ":" +E.getSQLState() +":"+ E.getErrorCode()); } catch(Exception E) {System.out.println("Unable to load driver"); } } } After compilation, when I am trying to run it, I get the follwing error : Cannot load connection class 'java.sql.SQLException: Invalid authorization specification: Access denied for user: 'username@localhost' (Using password: YES)'.:08001:0 Does anyone know why and when occurs this error ? Thanks a lot ! Daniel Ducat - 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 I use aCC..
Ragupathi P a crit : hi, basically i am reframing my earlier question. i'm using aCC ( ansic C++ compiler from HP ) on HPUX10.2 to compile and link my small C code with libraries available from mysql-3.23.32-hp-hpux10.20-hppa1.1 . i get the following: /usr/ccs/bin/ld: Unsatisfied symbols: mysql_connect (code) mysql_init (code) i wld greatly appreciate if someone can figure out if something is wrong. thank you ragu - 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 Hi, Well, the linker is just telling you that he cannot find mysql library. What are your compile and link commands ? Have you specified mysql library in command line ? If mysql library is not in a standard directory, have you specified mysql library localtion (-L option) ? Hope this helps, sorry for not being more specific but I don't have access to an HPUX machine anymore. -- Joseph Bueno - 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: auto_increment problem with mysql 3.23.32
On Wed, Feb 14, 2001 at 02:38:11PM +0200, Sinisa Milivojevic wrote: Hi! I have just tested your case on my Linux and it worked just fine. What OS is that and are you using our binaries. If not, please do. OK, I will (but it takes some time to download). Till that I have got a more accurate bug report on this topic. I created a test table containing only an 'auto_increment' field named 'id'. If I insert values with '0' as id in the insert query, everything works fine (incremented values). AND NOW THE TRICK: I inserted -1 to the table. And after THIS, all of my insert queries even with id 0 in the query result in -1 ! But this is not the end. If I delete all ids smaller than 1, then I try to insert some data with id 0, I've got -1 AGAIN! So it seems that the table store the last insert id value, and if it's -1, it stucks. Older MySQL versions were fine. It's hard because I've got many LARGE tables with complex applications that use the technique to have auto_increment value, BUT mark some fields with negative numbers as IDs for special purposes not listed normally (where id0). The really annoying bug, that even after I delete all of my negative id'ed records, the next insert will result in -1 too ;-( So I have to delete all negative ids, dump the table, then recreate and reload just for kick last insert id value for a table out from that bad state? With my databases it will be very hard work for the hw, not counting other problems. What's your opponion on this? Thanx a lot. - Gabor -- --[ Gbor Lnrt ]---[ Vivendi Telecom Hungary ]-[ [EMAIL PROTECTED] ]-- U have 8 bit comp or chip of them and it's unused or to be sold? Call me! ---[ +36 30 2270823 ]-- LGB -[ Linux/UNIX/8bit 4ever ]- - 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
test 1
STDERR 3 - 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: Cannot load connection class 'java.sql.SQLException problem !
On Wed, 14 Feb 2001, Daniel Ducat wrote: Thanks for the answer, Jonathan. I have already tried the way you propose, but it gives me the same error. Any other ideas ? Lebrun Jonathan wrote: Try this : Connection C=DriverManager.getConnection( "jdbc:mysql://localhost/test","username","password"); Well, as far as I can see, you are trying to log on with the user 'username' and password 'password'. Unless you actually have a user in MySQL called 'username' with PW 'password', MySQL will complain just the way it did. Cannot load connection class 'java.sql.SQLException: Invalid authorization specification: Access denied for user: 'username@localhost' (Using password: YES)'.:08001:0 This is exactly what I mentioned above: MySQL denies access to the user 'username@localhost' (there is more about that in the manual, look for the part which describes how MySQL handles users, keyword: a user is always user@somehost). Hope this helps. Regards, Jan - 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
NULL and 0 values when reading from MERGE table while INSERTing
Description: I have some tables (authentication0106 through authentication0108) for which I create a MERGE table (authentication). Some Perl script is adding records to authentication0107 as fast as it can. While it is doing this, I run the mysql client and issue the following query select count(*), max(id), max(auth_time) from authentication; Most of the time, this results in one row with sane values, e.g.: +--+-++ | count(*) | max(id) | max(auth_time) | +--+-++ |59776 | 59776 | 982157198 | +--+-++ 1 row in set (0.00 sec) But sometimes I get results like these (which is wrong because all id's and auth_time's have a value): +--+-++ | count(*) | max(id) | max(auth_time) | +--+-++ | 650614 |NULL | NULL | +--+-++ 1 row in set (0.00 sec) Or even this (max(id) seems okay, but max(auth_time) is wrong): +--+-++ | count(*) | max(id) | max(auth_time) | +--+-++ | 680402 | 680402 | NULL | +--+-++ 1 row in set (0.00 sec) How-To-Repeat: 1. Create tables in mysql client: create table authentication0106 ( id int not null, auth_time int not null, primary key(id), key auth_time(auth_time)) ; create table authentication0107 ( id int not null, auth_time int not null, primary key(id), key auth_time(auth_time)) ; create table authentication0108 ( id int not null, auth_time int not null, primary key(id), key auth_time(auth_time)) ; create table authentication ( id int not null, auth_time int not null, primary key(id), key auth_time(auth_time)) type=merge union=(authentication0106,authentication0107,authentication0108); 2. Start this Perl script: #!/usr/local/bin/perl5 -w use DBI; use DBD::mysql; use POSIX; sub main { my ($dbname) = @_; #DBI-trace(2); my $prev_yearweek = ''; my $sth_yearweek = ''; my $dbh = DBI-connect("dbi:mysql:database=$dbname:mysql_socket=/tmp/mysql-3.23.32.sock", "test", "test", {RaiseError = 1}); # # find last stored auth_time and id # my $lasttime; my $sth = $dbh-prepare("select max(id), max(auth_time) from authentication"); $sth-execute(); ($id, $lasttime) = ($sth-fetchrow_array())[0..1]; $id = $id ? $id + 1 : 1; $sth = undef; for ($i=0; $i100; $i++) { my $time = time(); # # see for which week this is an authentication # my $yearweek = strftime("%g%U", localtime($time)); $yearweek = '0107'; if ($yearweek ne $prev_yearweek) { $prev_yearweek = $yearweek; $sth_yearweek = $dbh-prepare( "insert into authentication".$yearweek." set id = ?, auth_time = ?"); } $sth_yearweek-execute( $id++, $time, ); } #$dbh-commit(); $dbh-disconnect(); } my $dbname = 'test'; main($dbname); 3. Repeatedly execute this query in the mysql client while the Perl script above is running: select count(*), max(id), max(auth_time) from authentication; It seems to be some race-condition so there's no guaranteed reproduction but it gives incorrect results once every 5 or 10 times in my case. Fix: Unknown Submitter-Id:[EMAIL PROTECTED] Originator:Fred van Engen Organization: XO Communications B.V. MySQL support: none Synopsis:NULL and 0 values when reading from MERGE table while INSERTing Severity:serious Priority:medium Category:mysql Class:sw-bug Release:mysql-3.23.32 (Source distribution) Environment: System: SunOS lei 5.7 Generic_106541-07
Re: mysql hangs on client start (and mysql_install_db)
Check permissions. The var directory anad all subdirectories and files must be accessible by the user under which MySQL runs. The directory containing the mysql.lock file must be readable and searchable by everyone. Drew Degentesh wrote: Description: mysql hangs. This is really frustrating. History: -had 3.23.27 running. Had to restart the machine. -on reboot, no clients would connect (command line , Perl or PHP) -tried to restart by rc.d/initd/mysql stop, that timed out -killed off processes with kill -9 -tried to restart, clients still hanging -downlaoded 3.23.32 binary. hung up in mysql_install_db after printing "installing all prepared tables" -killed those processes off..s.tarted with safe_mysqld ... -clients still hung -downloaded 3.23.32 source. compiled, hung up in mysql_install_db after printing "installing all prepared tables" -killed off those processes ,started with safe_mysqld ... , clients still hung -ran myisamchk and isamchk on all DB files.. still hangs -removed all my.cnf's ... still hangs Im SUPER FRUSTRATED...please help!!! How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Drew Degentesh Organization: MySQL support: none Synopsis: mysql clients hung (cannot start) Severity: critical Priority: high Category: mysql Class: Release: mysql-3.23.27-beta (Official MySQL binary) Environment: System: Linux 2.2.12-20RS #1 Mon Feb 14 16:39:25 CST 2000 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium -fomit-frame-pointer' CXX='gcc' CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx 1 root root 13 Mar 30 2000 /lib/libc.so.6 - libc-2.1.2.so -rwxr-xr-x 1 root root 4118683 Feb 23 2000 /lib/libc-2.1.2.so -rw-r--r-- 1 root root 20031726 Feb 23 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Feb 23 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared - 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: auto_increment problem with mysql 3.23.32
Gbor Lnrt writes: On Wed, Feb 14, 2001 at 02:38:11PM +0200, Sinisa Milivojevic wrote: Hi! I have just tested your case on my Linux and it worked just fine. What OS is that and are you using our binaries. If not, please do. OK, I will (but it takes some time to download). Till that I have got a more accurate bug report on this topic. I created a test table containing only an 'auto_increment' field named 'id'. If I insert values with '0' as id in the insert query, everything works fine (incremented values). AND NOW THE TRICK: I inserted -1 to the table. And after THIS, all of my insert queries even with id 0 in the query result in -1 ! But this is not the end. If I delete all ids smaller than 1, then I try to insert some data with id 0, I've got -1 AGAIN! So it seems that the table store the last insert id value, and if it's -1, it stucks. Older MySQL versions were fine. It's hard because I've got many LARGE tables with complex applications that use the technique to have auto_increment value, BUT mark some fields with negative numbers as IDs for special purposes not listed normally (where id0). The really annoying bug, that even after I delete all of my negative id'ed records, the next insert will result in -1 too ;-( So I have to delete all negative ids, dump the table, then recreate and reload just for kick last insert id value for a table out from that bad state? With my databases it will be very hard work for the hw, not counting other problems. What's your opponion on this? Thanx a lot. - Gabor -- --[ Gbor Lnrt ]---[ Vivendi Telecom Hungary ]-[ [EMAIL PROTECTED] ]-- U have 8 bit comp or chip of them and it's unused or to be sold? Call me! ---[ +36 30 2270823 ]-- LGB -[ Linux/UNIX/8bit 4ever ]- Hi! The above is actually documented behaviour. Entering negative values and negative values in general, are actually not suported in auto_increment columns. 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: Tr: Concurrent insert/select with BDB
Philippe, did you try to do the insert and select on the same database page? In BDB there is page level locking used, and the behavior you describe sounds like that the select has placed a page level lock on the page where you try to insert. Then it is correct behavior of the database that your insert has to wait until the commit which releases the locks placed by the select. A possible solution would be to use 'dirty read', i.e., non-locking read in select, but I do not know if BDB provides such. My own Innobase table handler allows you to read and insert data concurrently with no interference from locks, because Innobase does in a select a consistent non-locking read, in the style of Oracle. But MySQL/Innobase is not available yet. I have virtually completed the interfacing work to MySQL, and Monty just said that Innobase should come out in version 3.23 of MySQL next weekend. Regards, Heikki --- Original message --- Hi I post once more this message, because I didn't receive any answer. - Message d'origine - De : Philippe MORIN : [EMAIL PROTECTED] Envoy : vendredi 9 fvrier 2001 09:49 Objet : Concurrent insert/select with BDB Hi I'm using MySQL 3.23.32 on Linux. I try to run concurrent insert/select requests on BDB tables, but it doesn't work. I started mysqld with --bdb-shared-data option. I run mysql on 2 clients (on the same computer). The first one runs a select request and the second one runs an insert request. If I use autocommit, the insert waits for the end of the select. If I don't use autocommit, the insert waits for the commit of my first client. Did someone ever use concurrent insert/select with BDB databases ? Are there some special parameters to initialize, to allow insert and select at the same time (it doens't matter for me if my first client reads duplicated records). Thanks a lot ! Philippe Morin - Prologue Software (France) Software Engineer Email: [EMAIL PROTECTED] Internet : http://www.prologue-software.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
multiple databases performance
Hi all, glad to be back in the list :) I have a question related with a huge project, i could have these 2 schemes: 1) just one database with several tables database | tables DB_1 | user, profile, supplier, dept, etc... a lot of tables 2) several databases with few tables database | tables DB_1| user, profile DB_2| supplier, dept DB_etc | etc what would be the best choice ?, think that all tables contain thousands of rows, and applications have to access most of them, for example user information; even when working with suppliers users are required, so in case 2 the application must connect to both databases. any suggestions ?? thanx a lot. Carlos _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Hi all, glad to be back in the list :) I have a question related with a huge project, i could have these 2 schemes: 1) just one database with several tables database| tables DB_1 | user, profile, supplier, dept, etc...a lot of tables 2) several databases with few tables database| tables DB_1 | user, profile DB_2 | supplier, dept DB_etc |etc what would be the best choice ?, think that all tables contain thousands of rows, and applications have to access most of them, for example user information; even when working with suppliers users are required, so in case 2 the application must connect to both databases. any suggestions ?? thanx a lot. CarlosGet 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: auto_increment problem with mysql 3.23.32
On Wed, Feb 14, 2001 at 04:21:31PM +0200, Sinisa Milivojevic wrote: Hi! The above is actually documented behaviour. I've just realized that it's true (checked). But it was supported by older mysql versions and now I'm getting stuck with the old tables (MyISAM). Entering negative values and negative values in general, are actually not suported in auto_increment columns. OK, it's right and clean for me now ;-) But what can I do if I DONE this before? For example one of the development group members at our firm try this. Of course I can remove all of the records inserted with negative ids but even after this the table remains in a state where I can't work correctly. Is there a chance to kick out the insert id mysql internal variable for this table ? It's not an easy task to recreate the table with dumping and restoring it :( BTW, sorry for my tons of mails :( - Gabor -- --[ Gbor Lnrt ]---[ Vivendi Telecom Hungary ]-[ [EMAIL PROTECTED] ]-- U have 8 bit comp or chip of them and it's unused or to be sold? Call me! ---[ +36 30 2270823 ]-- LGB -[ Linux/UNIX/8bit 4ever ]- - 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/php
?How can I output "no records found" when there is no record found? This is ?the query I am using. ?SELECT * FROM $table where description LIKE '%$keyword%' ?Is there a sql statment that will return a string if no record exists? ?Thanks in advance. An easy way, is to use PHP for this. For example. $Result=MySQL_Query("SELECT * FROM $table where description LIKE '%$keyword%"); if(MySQL_Num_Rows($Result)==0){ echo("No Records Found!"); }else{ //Your formating of results here. } Hope this helps! Daniel - 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: Cannot load connection class 'java.sql.SQLException problem !
Hello Jan-Aage In my example I have replaced the real username/password with a "username"/"password". Iin the real code I use real username and password. Actually early I thought the username and password I use are not correct, but I log with them using mysql shell. I have grant all GRANTS to this user, but it seems that it does not solve my problem. Anyway thanks for the answer. Daniel Ducat Jan-Aage Bruvoll wrote: On Wed, 14 Feb 2001, Daniel Ducat wrote: Thanks for the answer, Jonathan. I have already tried the way you propose, but it gives me the same error. Any other ideas ? Lebrun Jonathan wrote: Try this : Connection C=DriverManager.getConnection( "jdbc:mysql://localhost/test","username","password"); Well, as far as I can see, you are trying to log on with the user 'username' and password 'password'. Unless you actually have a user in MySQL called 'username' with PW 'password', MySQL will complain just the way it did. Cannot load connection class 'java.sql.SQLException: Invalid authorization specification: Access denied for user: 'username@localhost' (Using password: YES)'.:08001:0 This is exactly what I mentioned above: MySQL denies access to the user 'username@localhost' (there is more about that in the manual, look for the part which describes how MySQL handles users, keyword: a user is always user@somehost). Hope this helps. Regards, Jan - 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: Concurrent insert/select with BDB
I thought that by using Berkeley tables, concurrent insert/select locks were based on a page lock. I have seen the same locking with two clients as you noted in your email. What I thought was happening is that since my tables are small, I was getting the locking behaviour mentioned because rows in the insert/select where on the same page. I would very much like to hear if that is the case. Rick - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone: 281-544-5092(WCK) / Fax:281-544-2646(WCK) / email: [EMAIL PROTECTED] - -Original Message- From: Philippe MORIN [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 12:38 AM To: [EMAIL PROTECTED] Subject: Tr: Concurrent insert/select with BDB Hi I post once more this message, because I didn't receive any answer. - Message d'origine - De : Philippe MORIN A : [EMAIL PROTECTED] Envoye : vendredi 9 fevrier 2001 09:49 Objet : Concurrent insert/select with BDB Hi I'm using MySQL 3.23.32 on Linux. I try to run concurrent insert/select requests on BDB tables, but it doesn't work. I started mysqld with --bdb-shared-data option. I run mysql on 2 clients (on the same computer). The first one runs a select request and the second one runs an insert request. If I use autocommit, the insert waits for the end of the select. If I don't use autocommit, the insert waits for the commit of my first client. Did someone ever use concurrent insert/select with BDB databases ? Are there some special parameters to initialize, to allow insert and select at the same time (it doens't matter for me if my first client reads duplicated records). Thanks a lot ! __ Philippe Morin - Prologue Software (France) Software Engineer Email: [EMAIL PROTECTED] Internet : http://www.prologue-software.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
Log File Reporting
Hi all, I'd like to be able to analyse the log files that my MySQL server produces. Basically, I want to find out how many logins every account is doing, how many queries are being performed against each database (although not necessarily per-table) and how many slow queries each account is doing. All of these figures I want to be able to quantify against a certain time period - for example, a 24-hour period. Does anyone know of any log reporting software that might be able to do the job? Maybe somebody has already written something themselves? Initially I thought of using Analog (which I already use for my web, FTP and RealServer logs), but even that's not customisable to the extent I need. Something like Webalizer would be great (with its graphing), but that too is tailored for web logs. Ideally, it'd be great to get MySQL logging to another MySQL database - which I could then use PHP for to query and generate reports, but that seems slightly silly and a bit overkill... :) Also, I notice that the slow query log doesn't record which database was being queried (I'm using version 3.23.32). Why not? Surely this is an essential bit of info? Regards, Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and Mosix
Fabio Berbert de Paula wrote: Hello, Did anybody perform MySQL in a cluster of machines using Mosix? Which was the result? Did MySQL uses shared memory? Or MySQL can't upgrade your perform in a cluster? No, MOSIX can't run MySQL and because threads. At least this was in that way when I last checked for this. And threads means shared memory too. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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 I use aCC..
On Wed, Feb 14, 2001 at 06:59:04PM +0200, Ragupathi P wrote: hi, basically i am reframing my earlier question. i'm using aCC ( ansic C++ compiler from HP ) on HPUX10.2 to compile and link my small C code with libraries available from mysql-3.23.32-hp-hpux10.20-hppa1.1 . i get the following: /usr/ccs/bin/ld: Unsatisfied symbols: mysql_connect (code) mysql_init (code) i wld greatly appreciate if someone can figure out if something is wrong. Basically you are still not giving us the necessary information. In my case the mysql_connect() code is in libmysqlclient.a: ws01 48: nm libmysqlclient.a | grep mysql_connect mysql_connect | 6776|extern|entry |$CODE$ So I would expect the references to be satsified if your link command finishes with aCC [options] [yourmodules] -L/path/to/mysql/libraries -lmysqlclient If you don't give us the precise command you are using, we cannot help you. Best regards, Lutz -- Lutz Jaenicke [EMAIL PROTECTED] BTU Cottbus http://www.aet.TU-Cottbus.DE/personen/jaenicke/ Lehrstuhl Allgemeine Elektrotechnik Tel. +49 355 69-4129 Universitaetsplatz 3-4, D-03044 Cottbus Fax. +49 355 69-4153 - 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
My problem with ucase (and lcase too)
Hi everybody, ucase behaviour :-( mysql select ucase('dj vu'); +--+ | ucase('dj vu') | +--+ | DJ VU | +--+ 1 row in set (0.01 sec) is there a way to make it answer 'DEJA VU' instead of 'DJ VU' Thanx for your help... -- Francois INRA - SAGA mailto:[EMAIL PROTECTED] --- [ LINUX : just boot it! ] --- [ http://www.mynetmemo.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
Reserved words in MySQL update
Description: Upgrading from 3.22 to 3.23 with a field having a reserved name ALTER TABLE barfs and doesn't let me do ALTER TABLE casualties CHANGE when cas_when DATE NOT NULL; cos of the reserved word "when". How-To-Repeat: Have a field called "when" in 3.22, upgrade to 3.23 Fix: Manually edited the .frm file - didn't feel right Need something to either do it automatically on upgrade, or a standalone utility to modify the mysql files directly. Submitter-Id: submitter ID Originator:David Croft Organization: MySQL support: none Synopsis: Reserved words in MySQL update Severity: serious Priority: medium Category: mysql Class: change-request Release: mysql-3.23.32 (Official MySQL binary) Environment: System: Linux papaya 2.2.18 #3 Sat Feb 10 02:36:04 EST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs gcc version 2.95.2 2220 (Debian GNU/Linux) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium -fomit-frame-pointer' CXX='gcc' CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Feb 9 08:38 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 887712 Jan 12 04:59 /lib/libc-2.1.3.so -rw-r--r--1 root root 2089420 Jan 12 05:00 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 12 05:00 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared Perl: This is perl, version 5.005_03 built for i386-linux - 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/php query help
hey rolf-- everything works fine if the user chooses "ALL" in both pop-up menus and also works if they choose "ALL" in at least one of the pop-up menus. But if the user does not choose the "ALL" option in both pop-up menus, it does not work properly. i stuck a couple echo statements in the code to see what data was actually in the 2 variables. below is what happened. SELECTIONS VARIABLES ALL/ALL ALL/ALL ALL/Not ALL ALL/Not ALL Not ALL/ALL Not ALL/ALL Not ALL/Not ALL Not ALL/ALL It seems the AreaTemp variable takes the value "ALL" when the CuisineTemp variable is something other than "ALL". so,in english, the code works in 3 instances and fails in 1. The code works if the user wants all cuisines in all areas, all cuisines in a specific area, and a specific cuisine in all areas. but it does not work if the user wants a specific cuisine in a specific area and this is because the AreaTemp variable remains "ALL". does this help? any suggestions? --scott -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 8:30 PM To: Stinsman, Scott; [EMAIL PROTECTED] Subject: Re: mySQL/php query help I can't see anything wrong with your code? What exactly is the problem? Aren't the values, from the select statement printing out on your web page or something? Are you sure you provided the right code? - Original Message - From: "Stinsman, Scott" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 13, 2001 23:17 Subject: mySQL/php query help can anyone figure out why the following code works fine when both select variables = "ALL" and also when only 1 of the 2 ="ALL" but NOT when BOTH select variables equal something other than "ALL"? here is the code: What area of the city would you like to dine in? ?php $db=mysql_connect("localhost", "**", "*"); mysql_select_db("***", $db) OR DIE ("died at connect"); $query = "SELECT DISTINCT Restaurant.Area "; $query .= "FROM Restaurant "; $query .= "ORDER BY Restaurant.Area ASC "; $mysql_result=mysql_query($query, $db) OR DIE ("died at query"); $select="select name=\"AreaTemp\"\n"; $select.="option value=\"ALL\"ALL/option\n"; while(list($AreaTemp)=mysql_fetch_array($mysql_result)) { $select.="option value=\"$AreaTemp\"$AreaTemp/option\n"; } $select.="/select"; echo "$select"; ? br What type of cuisine do you feel like? ?php $query = "SELECT DISTINCT Restaurant.Cuisine "; $query .= "FROM Restaurant "; $query .= "ORDER BY Restaurant.Cuisine ASC "; $mysql_result=mysql_query($query, $db) OR DIE ("died at query"); $select="select name=\"CuisineTemp\"\n"; $select.="option value=\"ALL\"ALL/option\n"; while(list($CuisineTemp)=mysql_fetch_array($mysql_result)) { $select.="option value=\"$CuisineTemp\"$CuisineTemp/option\n"; } $select.="/select"; echo "$select"; ? br input type ="submit" value="Go!" name="submit" input type="RESET" value="Clear" name="RESET" Scott Stinsman Academic Coordinator General Internal Medicine 1215 Blockley Hall 423 Guardian Drive Philadelphia, PA 19104-6021 (phone) 215-662-7623 (fax) 215-349-5091 (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: mysql/php
Try this: $RESULT_SET = mysql_query("SELECT * FROM $table where description LIKE '%$keyword%'"); if(!$RESULT_SET){ $RESULTS = "No records found"; } else { do whatever needs to get done! } ...or something similar... (although I did not try it!) Martin C. LDL Enterprise wrote: How can I output "no records found" when there is no record found? This is the query I am using. SELECT * FROM $table where description LIKE '%$keyword%' Is there a sql statment that will return a string if no record exists? Thanks in advance. _ ___ | | | \ | | | |__ | | || |__ |||___/ || Larry L. [EMAIL PROTECTED] www.ldlenterprise.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: /tmp/mysql.sock disappearing?
On Tue, Feb 13, 2001 at 11:50:28AM -0500, Brian Reichert wrote: I couldn't fine this mentioned in the archives, so I hope someone has seen this before: I'm running into a situation wherein /tmp/mysql.sock keeps disspearing. There is still server process (sleeping), and there is still a pidfile. This can happen after ten or fifteen minutes of queries. I don't have a cronjob, or any other external process that scrubs /tmp. I have to apologize to everyone; I found out that I _did_ have a cronjob that caused this socket to go away: I had been doing this nightly: /usr/local/bin/mysqladmin -uroot -proot flush-logs /usr/local/bin/safe_mysqld safe_mysqld out-of-hand removes $MYSQL_UNIX_PORT; I don't know why. (I also don't know why I felt the need to restart mysqld after a flush-logs.) Thanks for everyone's advice... -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - 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: cronjobs crash with libmysqlclient in PAM-modules
Hi! "Jan" == Jan Lukoschus [EMAIL PROTECTED] writes: Jan On Mon, 6 Nov 2000, Michael Widenius wrote: Hi! "Jan" == Jan Lukoschus [EMAIL PROTECTED] writes: Description: Jan Operating system: SUN Solaris 7 or 8 Jan MySQL: 3.22.32 or 3.23.27-beta Jan When cron starts a job and tries to authenticate the associated user Jan with a PAM-module which uses libmysqlclient, then the process crashes Jan when calling the function mysql_init. All other uses of the PAM-module Jan work just fine (login, ssh, dtlogin, xdm, telnet, etc.), Only cron keeps Jan constantly crashing (not the demon itself, just the jobs teminate). How-To-Repeat: Jan Just install a PAM-module for authenticating users against a MySQL-DB on Jan Solaris 7 or 8 and set up a trivial cron job. We tested MySQL versions Jan 3.22.32 and 3.23.27-beta. Both shows the error. We use our own PAM-module, Jan but pam-mysql should have the same problem. Fix: Jan The following statements apply to MySQL 3.23.27-beta: Jan The offending statement is in mysql-3.23.27-beta/libmysql/errmsg.c line 81: Jan errmsg[CLIENT_ERRMAP] = client_errors[0]; cut Thanks; We will rename errmsg to my_errmsg in 3.23.28 Jan Is there a specific reason, why that change did not found its way into Jan the stable release 3.23-32 (I have not checked the beta versions)? The only reason was that I forgot about this :( I have now patched the code for this, so this will appear in the next MySQL release. (3.23.34, as this is a safe fix) Regards, Monty - 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: Re[2]: Serious MySQL internal deadlock
OK, the problem doesn't occur with --skip-locking. Still, I don't believe this to be a lockd problem as the partition mysqld is working on is a local ext2 fs. lockd isn't even running on the test system (no nfs). So, this leaves either (in no particular sequence): 1. a mysql problem 2. a glibc 2.2 problem 3. a kernel (2.2.18) problem I understand that you can't investigate further as --skip-locking is an easy workaround. I will, however, try to investigate, if I do find some spare time. If I do find out what's going on in case of --enable-locking I'll let you know. On 14-Feb-2001 Sinisa Milivojevic wrote: Andreas Steinmetz writes: Hi, just FYI: the deadlock problem is still in MySQL 3.23.33, the test I did send you behaves as in 3.23.32. Andreas Steinmetz D.O.M. Datenverarbeitung GmbH Thank you for contacting me, as I was just now starting to search for your e-mail address !! Your test case did cause a deadlock, but this is not MySQL fault !! As our manual clearly says, lockd is broken on Linux and some other systems, so --enable-locking will quite often result in a deadlock. If you start mysqld with --skip-locking , there are no problems. Simply never use --enable-locking on OS's with broken lock daemon. We do not have time to fix it !! Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team Andreas Steinmetz D.O.M. Datenverarbeitung GmbH - 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
Replication of now()
Description: I had a master and a slave server that had their clocks set to different times, and I noticed my slave server kept crashing shortly after midnight with queries that involved the now() function. I am using a date column as a unique identifier, so it wasn't able to perform an insert on the slave that it could on the master. This also would be a problem is the slave server is offline for a few hours and reconnects. How-To-Repeat: Set two servers to different times and try to replicate from one to the other. Run an insert query using now(). Notice that the date inserted is set to the slave's local time and not the time it was inserted on the master. Fix: Perhaps the now() function should be replaced with the current date on the master in the bin-logs. Submitter-Id: pgatt Originator: Organization: MySQL support: none Synopsis: Minor bug / change request Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.33 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.15 Distrib 3.23.33, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.33-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 5 hours 26 min 43 sec Threads: Questions: 6291039 Slow queries: 7 Opens: 1108 Flush tables: 1 Open tables: 512 Queries per second avg: 320.922 Environment: System: Linux db1.join4free.com 2.2.14-5.0smp #3 SMP Thu Aug 3 00:44:11 PDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jul 31 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 20272704 Feb 29 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Feb 29 2000 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --without-berkeley-db '--with-comment=Official MySQL RPM' Perl: This is perl, version 5.005_03 built for i386-linux - 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/php
or you can try the following code $result=@mysql_db_query($db_name,$query,$link); $num=@mysql_num_rows($result); if($num=0): echo "No records found"; endif; Martin Cloutier wrote: Try this: $RESULT_SET = mysql_query("SELECT * FROM $table where description LIKE '%$keyword%'"); if(!$RESULT_SET){ $RESULTS = "No records found"; } else { do whatever needs to get done! } or something similar... (although I did not try it!) Martin C. LDL Enterprise wrote: How can I output "no records found" when there is no record found? This is the query I am using. SELECT * FROM $table where description LIKE '%$keyword%' Is there a sql statment that will return a string if no record exists? Thanks in advance. _ ___ | | | \ | | | |__ | | || |__ |||___/ || Larry L. [EMAIL PROTECTED] www.ldlenterprise.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: mySQL/php query help
No, this does not help. All you have provided was the code that does work. From your original description, you are able select the various items from the list. That means you are actually selecting items in a list. Now, if you said that the only item in either or both lists was ALL then you would have a problem with the code you gave us. However you said you have a problem after you have selected ALL for both lists and tried to get results. This is the code we need to see!! Ie. the code that activates after pressing the submit button. - Original Message - From: "Stinsman, Scott" [EMAIL PROTECTED] To: "'Rolf Hopkins'" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 23:29 Subject: RE: mySQL/php query help hey rolf-- everything works fine if the user chooses "ALL" in both pop-up menus and also works if they choose "ALL" in at least one of the pop-up menus. But if the user does not choose the "ALL" option in both pop-up menus, it does not work properly. i stuck a couple echo statements in the code to see what data was actually in the 2 variables. below is what happened. SELECTIONS VARIABLES ALL/ALL ALL/ALL ALL/Not ALL ALL/Not ALL Not ALL/ALL Not ALL/ALL Not ALL/Not ALL Not ALL/ALL It seems the AreaTemp variable takes the value "ALL" when the CuisineTemp variable is something other than "ALL". so,in english, the code works in 3 instances and fails in 1. The code works if the user wants all cuisines in all areas, all cuisines in a specific area, and a specific cuisine in all areas. but it does not work if the user wants a specific cuisine in a specific area and this is because the AreaTemp variable remains "ALL". does this help? any suggestions? --scott -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 8:30 PM To: Stinsman, Scott; [EMAIL PROTECTED] Subject: Re: mySQL/php query help I can't see anything wrong with your code? What exactly is the problem? Aren't the values, from the select statement printing out on your web page or something? Are you sure you provided the right code? - Original Message - From: "Stinsman, Scott" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 13, 2001 23:17 Subject: mySQL/php query help can anyone figure out why the following code works fine when both select variables = "ALL" and also when only 1 of the 2 ="ALL" but NOT when BOTH select variables equal something other than "ALL"? here is the code: What area of the city would you like to dine in? ?php $db=mysql_connect("localhost", "**", "*"); mysql_select_db("***", $db) OR DIE ("died at connect"); $query = "SELECT DISTINCT Restaurant.Area "; $query .= "FROM Restaurant "; $query .= "ORDER BY Restaurant.Area ASC "; $mysql_result=mysql_query($query, $db) OR DIE ("died at query"); $select="select name=\"AreaTemp\"\n"; $select.="option value=\"ALL\"ALL/option\n"; while(list($AreaTemp)=mysql_fetch_array($mysql_result)) { $select.="option value=\"$AreaTemp\"$AreaTemp/option\n"; } $select.="/select"; echo "$select"; ? br What type of cuisine do you feel like? ?php $query = "SELECT DISTINCT Restaurant.Cuisine "; $query .= "FROM Restaurant "; $query .= "ORDER BY Restaurant.Cuisine ASC "; $mysql_result=mysql_query($query, $db) OR DIE ("died at query"); $select="select name=\"CuisineTemp\"\n"; $select.="option value=\"ALL\"ALL/option\n"; while(list($CuisineTemp)=mysql_fetch_array($mysql_result)) { $select.="option value=\"$CuisineTemp\"$CuisineTemp/option\n"; } $select.="/select"; echo "$select"; ? br input type ="submit" value="Go!" name="submit" input type="RESET" value="Clear" name="RESET" Scott Stinsman Academic Coordinator General Internal Medicine 1215 Blockley Hall 423 Guardian Drive Philadelphia, PA 19104-6021 (phone) 215-662-7623 (fax) 215-349-5091 (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 - Before posting, please check:
Re: phpMyAdmin
http://www.phpwizard.net/projects/phpMyAdmin/ At 11:08 AM 2/14/2001 -0500, [EMAIL PROTECTED] wrote: I was reading through the list and found numerous mentions of phpMyAdmin. Since I am a newbie (hoping not to be) at mysql and php, but soon will be using both, I started looking for it on my Linux box. I have both php3 and 4 on the system and mysql seems to be working fine. However, I could not find phpMyAdmin. So how do I get it and how do I put in on this box?? - 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
Re: phpMyAdmin
Hi, I started looking for it on my Linux box. I have both php3 and 4 on the system and mysql seems to be working fine. However, I could not find phpMyAdmin. So how do I get it and how do I put in on this box?? Here it is: http://www.phpwizard.net/projects/phpMyAdmin/ Regards, Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpMyAdmin
http://www.phpwizard.net/ you gotta download it... it's seperate from php and mysql. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 11:08 AM To: [EMAIL PROTECTED] Subject: phpMyAdmin I was reading through the list and found numerous mentions of phpMyAdmin. Since I am a newbie (hoping not to be) at mysql and php, but soon will be using both, I started looking for it on my Linux box. I have both php3 and 4 on the system and mysql seems to be working fine. However, I could not find phpMyAdmin. So how do I get it and how do I put in on this box?? Tx - 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: phpMyAdmin
At 11:08 AM -0500 2/14/01, [EMAIL PROTECTED] wrote: I was reading through the list and found numerous mentions of phpMyAdmin. Since I am a newbie (hoping not to be) at mysql and php, but soon will be using both, I started looking for it on my Linux box. I have both php3 and 4 on the system and mysql seems to be working fine. However, I could not find phpMyAdmin. So how do I get it and how do I put in on this box?? Have a look at ... http://www.htmlwizard.net/projects/phpMyAdmin/ ... or if you prefer a similar tool written in Perl as opposed to PHP, you might want to check out ... http://dajoba.com/projects/mysqltool/ - Ray - 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: auto_increment problem with mysql 3.23.32
On Wed, 14 Feb 2001, Sinisa Milivojevic wrote: Date: Wed, 14 Feb 2001 16:21:31 +0200 (EET) From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: auto_increment problem with mysql 3.23.32 snip.. Hi! The above is actually documented behaviour. Entering negative values and negative values in general, are actually not suported in auto_increment columns. Regards, Sinisa can an auto_increment column also have the attribute "unsigned" safely? Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - 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: phpMyAdmin
Muchas gratias. I now know why everyone keeps referring to this little jewel. thanks again to you and to all replying. Scott Baker [EMAIL PROTECTED] on 02/14/2001 12:17:45 PM To: Lad Gaal/MarconiMedical@Marconi, [EMAIL PROTECTED] cc: Subject: Re: phpMyAdmin http://www.phpwizard.net/projects/phpMyAdmin/ At 11:08 AM 2/14/2001 -0500, [EMAIL PROTECTED] wrote: I was reading through the list and found numerous mentions of phpMyAdmin. Since I am a newbie (hoping not to be) at mysql and php, but soon will be using both, I started looking for it on my Linux box. I have both php3 and 4 on the system and mysql seems to be working fine. However, I could not find phpMyAdmin. So how do I get it and how do I put in on this box?? - 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
freelance web developer available - perl/php/mysql/c++/linux
hey- If anyone is looking for a freelance web developer check me out. I have recently become available. We're talking perl/php/mysql/c++/linux and a bs degreee. jeff -- Jeff Saenz ([EMAIL PROTECTED]) Perl/PHP/SQL/Unix Consulting http://www.planetoid.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Data modeling tool
On Mon, 12 Feb 2001 [EMAIL PROTECTED] wrote: Moving back and forth is a manual process, which is a bit frustrating. Since dia stores everything in XML, I'm considering what it would take to make some sort of syncronization. I've been planning on looking into Alzabo too, which was already mentioned, but I haven't had the time for that either. :-( One feature I've been considering for Alzabo is to be able to somehow process dia's XML and generate a schema from it. Alzabo will (sometime soon, I hope) be able to read/write DBML, an XML language Barrie Slaymaker is working on (with some input from me and others). If it is possible to transform from dia's XML to DBML and vice versa that would be extremely slick, I think. -dave /*== www.urth.org We await the New Sun ==*/ - 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: phpMyAdmin
phpwizard.net [EMAIL PROTECTED] wrote: I was reading through the list and found numerous mentions of phpMyAdmin. Since I am a newbie (hoping not to be) at mysql and php, but soon will be using both, I started looking for it on my Linux box. I have both php3 and 4 on the system and mysql seems to be working fine. However, I could not find phpMyAdmin. So how do I get it and how do I put in on this box?? Tx - 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
Indexing
Dear Assisitor, Trouble with indexing. The team that is using MySQL for a project consisting of capturing information from the internet. I believe that they are indexing every word in the english language, which in turn is slowing down the search to turtle speed. What could one do to avoid such a slowdown. -- Rob Sochor IS Manager [EMAIL PROTECTED] Ie Solutions - RAPS The Recruiting and Applicant Processing System Visit a list of sites powered by the RAPS system: http://www.RAPSystem.com/demo/clients.html - 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: get_lock()
It's purely advisory locking. You aren't locking anything other than a certain value within the server itself. The benefit comes only if all clients agree to use the same advisory locking schema. -Tilghman -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 11:01 To: [EMAIL PROTECTED] Subject: get_lock() When using getlock what goes in the str in the following syntax GET_LOCK(str,timeout) is the the primary key of the row that you would like to lock? the manual isn't very specific on that Thanks randy - 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
Restart MySQL after rebooting Linux
I have been reading the mysql book by Dubois and trying to figure out how to implement his restart methods on a SUSE Linux 7.0 Box. Has anyone done this and can give me information how 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
show command not working properly 3.23.32?
Is anyone else having similar problems with 3.23.32 and the show commands? Only one that seems to work properly is 'show processlist;' mysql show databases; +--+ | Database | +--+ | | | | | | | | | | | | | | | | | | +--+ 9 rows in set (0.00 sec) mysql show tables; Empty set (0.00 sec) mysql describe en_wordids; ++---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-+---+ | wordid | int(10) unsigned | | MUL | 0 | | | id | mediumint(8) unsigned | | | 0 | | | count | tinyint(3) unsigned | | | 0 | | ++---+--+-+-+---+ 3 rows in set (0.02 sec) mysql -- Daniel Bohling NewsFactor Network - 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 with extremely slow queries - PLEASE!
Hi all, I've a bit of an issue with mysqld -- errr is it? Here's the configuration Dell PowerEdge 6300 - 1GB ram (actually 2GB but no bigmem support at the moment - I'll get to that) - RH linux 6.1 running 2.2.12-smp (needs updating, I know - but hard to find good 'down time') - 4 10gig UW-SCSI drives - in hardware raid 5 - AMI raid... Running: Apache -- 1.3.4 (Unix) W/ DBI and CGI.pm Mysql -- Ver 3.22.21 for pc-linux-gnu on i686 with options: wait_timeout=31536000 join_buffer=10M key_buffer=64M sort_buffer=8M table_cache=81 tmp_table_size=64M --big-tables - Here's the problem / questions --- This 'snuck' up on us as usage increased, we never noticed it before It seems that certian queries in mysql make the daemon write to /tmp table... This process takes a long, long, time and does not generate any errors in the log - actually, If you're patient enough, it will complete The processlist plainly shows that it's writing to /tmp while running top, and generating one of these queries, I notice that a mysql thread (or two) jumps to the top taking up to 50% (or as much as is available) of the CPU - and quite a bit of mem... More than it seems it should What causes a querry to be sent to a tmp table? Realisticly, it seems that this querry should be able to run in no more than 5 seconds But we're talking minutes, here It's just a join querry, and the tables are really not 'that big' It also seems that when one of these queries is running, quite a few other mysql processes become 'locked'... What might cause this? I've been doing quite a bit of reading on mysql and the linux kernel... I've found a couple of possible answers to my own question, but I'd really like to hear form others who may have experianced the same situation. One possible answer comes from the linux specific segment of the docs, and speaks of a: Version 2.2 kernel "feature" that penalizes a process for forking or cloning a child in an attempt to prevent a fork bomb attack. This will cause MySQL not to scale well as you increase the number of concurrent clients. On single CPU systems, we have seen this manifested in a very slow thread creation The other possiblity I found deals with Parameters in /proc/sys/vm/bdflush... I don't know a lot about these, so any help here is mucho appreciated It seems though, that modifying the ??nfract?? (is that right?) paramater may help (on systems with lots of RAM) - as disk IO will be buffered up to the limit specified??? thus causing 'slow' writes??? Am I on here, or way off??? Also, I'm considering VALinux 7.0.1 (modified redhat) which has built in bigmem support, and unbuffered diskIO (rawIO)... I would also immediatly upgrade to kernel 2.4.x as I understand that the "anti fork-bomb feature" is fixed in the 2.4 kernels... does anyone have any other suggestions, possible fixes (to current kernel)? or ideas? Please help, I've almost no hair left :-0 ns - 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: get_lock()
It is just a string. It does not lock anything in the database. It sets a semaphore to be tested by other programs. You need to make sure ALL programs updating your database use the string locks, and that the stringlock will be unique for every record. you could youse something like database-table-primarykey. Randy Johnson wrote: When using getlock what goes in the str in the following syntax GET_LOCK(str,timeout) is the the primary key of the row that you would like to lock? the manual isn't very specific on that Thanks randy - 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
It keeps hanging it's self, so I killed it :)
Hi, I am running a PIII 733 with 256 MB Ram and the mysql server keeps locking up. I go into the "top" program and the mysql process is taking up 95-98% of the processor and continually has to be killed and restarted. We are running on an BSDI4.2 / Apache server using PHP pages, I am not using persistent connections, should I be. is there a way to have mysql restart when it hangs? These are the errors I am getting: 010212 4:24:29 /usr/local/libexec/mysqld: Out of memory (Needed 16384 bytes) 010212 04:25:53 mysqld restarted /usr/local/libexec/mysqld: ready for connections 010208 3:42:57 Aborted connection 9634 to db: 'pp_beta1' user: 'root' host: `localhost' (Got an error reading communication packets) 010208 3:43:57 Aborted connection 9505 to db: 'pp_beta1' user: 'root' host: `localhost' (Got an error writing communication packets) 010208 03:54:55 mysqld restarted Alan - 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/php query help
ok, here is the code that runs after the submit button is clicked. i now suspect that it has something to do with my "if" statements. $db=mysql_connect("localhost", "**", "***"); mysql_select_db("***", $db) OR DIE ("died at connect"); if ($AreaTemp == 'ALL' $CuisineTemp != 'ALL') { echo ($AreaTemp); echo ($CuisineTemp); $query = "SELECT * "; $query .= "FROM Restaurant "; $query .= "WHERE '$CuisineTemp' = Restaurant.Cuisine "; $query .= "ORDER BY Restaurant.Price "; $mysql_result=mysql_query($query, $db) OR DIE ("died at query"); --code here } elseif ($AreaTemp != 'ALL' $CuisineTemp = 'ALL') { echo ($AreaTemp); echo ($CuisineTemp); $query = "SELECT * "; $query .= "FROM Restaurant "; $query .= "WHERE '$AreaTemp' = Restaurant.Area "; $query .= "ORDER BY Restaurant.Price "; $mysql_result=mysql_query($query, $db) OR DIE ("died at query"); code here } elseif (($AreaTemp == 'ALL') AND ($CuisineTemp == 'ALL')) { $query = "SELECT * "; $query .= "FROM Restaurant "; $query .= "ORDER BY Restaurant.Price "; $mysql_result=mysql_query($query, $db) OR DIE ("died at query"); ---code here--- } else{ $query = "SELECT * "; $query .= "FROM Restaurant "; $query .= "WHERE '$CuisineTemp' = Restaurant.Cuisine AND '$AreaTemp' = Restaurant.Area "; $query .= "ORDER BY Restaurant.Price "; $mysql_result=mysql_query($query, $db) OR DIE ("died at query"); -code here- -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 12:14 PM To: Stinsman, Scott Cc: [EMAIL PROTECTED] Subject: Re: mySQL/php query help No, this does not help. All you have provided was the code that does work. From your original description, you are able select the various items from the list. That means you are actually selecting items in a list. Now, if you said that the only item in either or both lists was ALL then you would have a problem with the code you gave us. However you said you have a problem after you have selected ALL for both lists and tried to get results. This is the code we need to see!! Ie. the code that activates after pressing the submit button. - Original Message - From: "Stinsman, Scott" [EMAIL PROTECTED] To: "'Rolf Hopkins'" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 23:29 Subject: RE: mySQL/php query help hey rolf-- everything works fine if the user chooses "ALL" in both pop-up menus and also works if they choose "ALL" in at least one of the pop-up menus. But if the user does not choose the "ALL" option in both pop-up menus, it does not work properly. i stuck a couple echo statements in the code to see what data was actually in the 2 variables. below is what happened. SELECTIONS VARIABLES ALL/ALL ALL/ALL ALL/Not ALL ALL/Not ALL Not ALL/ALL Not ALL/ALL Not ALL/Not ALL Not ALL/ALL It seems the AreaTemp variable takes the value "ALL" when the CuisineTemp variable is something other than "ALL". so,in english, the code works in 3 instances and fails in 1. The code works if the user wants all cuisines in all areas, all cuisines in a specific area, and a specific cuisine in all areas. but it does not work if the user wants a specific cuisine in a specific area and this is because the AreaTemp variable remains "ALL". does this help? any suggestions? --scott -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 8:30 PM To: Stinsman, Scott; [EMAIL PROTECTED] Subject: Re: mySQL/php query help I can't see anything wrong with your code? What exactly is the problem? Aren't the values, from the select statement printing out on your web page or something? Are you sure you provided the right code? - Original Message - From: "Stinsman, Scott" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 13, 2001 23:17 Subject: mySQL/php query help can anyone figure out why the following code works fine when both select variables = "ALL" and also when only 1 of the 2 ="ALL" but NOT when BOTH select variables equal something other than "ALL"? here is the code: What area of the city would you like to dine in? ?php $db=mysql_connect("localhost", "**", "*"); mysql_select_db("***", $db) OR DIE ("died at connect"); $query = "SELECT DISTINCT Restaurant.Area "; $query .= "FROM Restaurant "; $query .= "ORDER BY Restaurant.Area ASC "; $mysql_result=mysql_query($query, $db) OR DIE ("died at query"); $select="select name=\"AreaTemp\"\n"; $select.="option value=\"ALL\"ALL/option\n"; while(list($AreaTemp)=mysql_fetch_array($mysql_result)) { $select.="option value=\"$AreaTemp\"$AreaTemp/option\n"; } $select.="/select"; echo "$select"; ? br What type of cuisine do you feel like? ?php $query = "SELECT DISTINCT Restaurant.Cuisine "; $query .= "FROM
RE: ODBC drivers???
Hi, The latest ODBC Drivers are always available at www.mysql.com Regards Quentin -Original Message- From: Gary Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 14 February 2001 08:15 To: [EMAIL PROTECTED] Subject: ODBC drivers??? I am running mySQL 3.23.32 with ColdFusion 4.5 on a RedHat Linux 6.2 machine. MySQL continuously crashes. I've been told that it could be that the ODBC driver is not up to date. Where can I get these drivers... or do you have any suggestions as to what I should do? Please help. For more information about WEBgoogol (Pty) Ltd, South Africa, please visit our web site at http://www.webgoogol.com as from March 2001. Internet communications are not secure and therefore the WEBgoogol Group does not accept legal responsibility for the contents of this message. Any views or opinions presented are solely those of the author and do not necessarily represent those of the WEBgoogol Group unless otherwise specifically stated. The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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/php
Hi! - Original Message - From: "Martin Cloutier" [EMAIL PROTECTED] To: "LDL Enterprise" [EMAIL PROTECTED] Cc: "*MySQL mail list" [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 8:58 AM Subject: Re: mysql/php Try this: $RESULT_SET = mysql_query("SELECT * FROM $table where description LIKE '%$keyword%'"); if(!$RESULT_SET){ $RESULTS = "No records found"; } else { do whatever needs to get done! } ...or something similar... (although I did not try it!) I have found this doesn't work. If $RESULT_SET is null or equal to nothing, that means that there was a problem with the query. You have to use mysql_num_rows($RESULT_SET) to find out if 0 rows were returned. Anna - 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: Disk usage
What is the maximum data size MySQL can handle? Please let me know if anybody knows the answer to this question. http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_0_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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 with extremely slow queries - PLEASE!
You may be looking too far for your problem... Your join_buffer and sort_buffer are probably a little large if you have man concurrent users. Must you use an old version of mysql? You should analyize or post EXPLAIN of your query so that you/we can see that it is properly indexed.. you should be able to do many joins on very large tables and have results that respond in fractions of seconds unless you are missing some indexes or are trying to do some LIKE '%value%'. if it is writing to temp that means it has to create temporary tables to complete your query, this can be the case if your are missing indexes and it is having to search all tables to complete your join. Neil Streeter wrote: Hi all, I've a bit of an issue with mysqld -- errr is it? Here's the configuration Dell PowerEdge 6300 - 1GB ram (actually 2GB but no bigmem support at the moment - I'll get to that) - RH linux 6.1 running 2.2.12-smp (needs updating, I know - but hard to find good 'down time') - 4 10gig UW-SCSI drives - in hardware raid 5 - AMI raid... Running: Apache -- 1.3.4 (Unix) W/ DBI and CGI.pm Mysql -- Ver 3.22.21 for pc-linux-gnu on i686 with options: wait_timeout=31536000 join_buffer=10M key_buffer=64M sort_buffer=8M table_cache=81 tmp_table_size=64M --big-tables - Here's the problem / questions --- This 'snuck' up on us as usage increased, we never noticed it before It seems that certian queries in mysql make the daemon write to /tmp table... This process takes a long, long, time and does not generate any errors in the log - actually, If you're patient enough, it will complete The processlist plainly shows that it's writing to /tmp while running top, and generating one of these queries, I notice that a mysql thread (or two) jumps to the top taking up to 50% (or as much as is available) of the CPU - and quite a bit of mem... More than it seems it should What causes a querry to be sent to a tmp table? Realisticly, it seems that this querry should be able to run in no more than 5 seconds But we're talking minutes, here It's just a join querry, and the tables are really not 'that big' It also seems that when one of these queries is running, quite a few other mysql processes become 'locked'... What might cause this? I've been doing quite a bit of reading on mysql and the linux kernel... I've found a couple of possible answers to my own question, but I'd really like to hear form others who may have experianced the same situation. One possible answer comes from the linux specific segment of the docs, and speaks of a: Version 2.2 kernel "feature" that penalizes a process for forking or cloning a child in an attempt to prevent a fork bomb attack. This will cause MySQL not to scale well as you increase the number of concurrent clients. On single CPU systems, we have seen this manifested in a very slow thread creation The other possiblity I found deals with Parameters in /proc/sys/vm/bdflush... I don't know a lot about these, so any help here is mucho appreciated It seems though, that modifying the ??nfract?? (is that right?) paramater may help (on systems with lots of RAM) - as disk IO will be buffered up to the limit specified??? thus causing 'slow' writes??? Am I on here, or way off??? Also, I'm considering VALinux 7.0.1 (modified redhat) which has built in bigmem support, and unbuffered diskIO (rawIO)... I would also immediatly upgrade to kernel 2.4.x as I understand that the "anti fork-bomb feature" is fixed in the 2.4 kernels... does anyone have any other suggestions, possible fixes (to current kernel)? or ideas? Please help, I've almost no hair left :-0 ns - 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: Data modeling tool
On Wed, 14 Feb 2001, Dave Rolsky wrote: One feature I've been considering for Alzabo is to be able to somehow process dia's XML and generate a schema from it. Alzabo will (sometime soon, I hope) be able to read/write DBML, an XML language Barrie Slaymaker is working on (with some input from me and others). If it is possible to transform from dia's XML to DBML and vice versa that would be extremely slick, I think. Bru-hahahahahaha! That'd be absolutely awesome. I'd be happy to tackle that once Alzabo's DBML support is ready. I've played with parsing dia's files a bit. Then we just have to get real-time hooks in dia so that there's no transformation required! :-) Bru-hahaha. -- /chris Those who cannot remember the past are doomed to buy Microsoft products. - 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: Replication Bug in 3.23.33
On Wednesday 14 February 2001 09:19, Matt Hahnfeld wrote: After downgrading to 3.23.30, replication worked fine without the problem posted below. This appears to be a bug in the newest version (3.23.33) only. The failed tests were run under mysql-3.23.33-pc-linux-gnu-i686 (binary distribution). The same tests succeeded under mysql-3.23.30-gamma-pc-linux-gnu-i686 (binary distribution) with no problems. -- Forwarded message -- Date: Tue, 13 Feb 2001 14:33:47 -0500 (EST) From: Matt Hahnfeld [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Strange Replication Problem in 3.23.33 (bug?) I set up two MySQL servers to run in a failover configuration. Because queries will only ever be submitted to one server at a time, I decided to use a makeshift two-way replication scheme under MySQL as descibed in the MySQL manual. First server (wallace) has this: server-id=1 log-bin master-host=gromit master-user=repl master-password=password log-slave-updates Second server (gromit) has this: server-id=2 log-bin master-host=wallace master-user=repl master-password=password log-slave-updates I started by mirroring both data directories. Then I started both servers and all looked fine. Logs indicate no errors. When I inserted some data on wallace, gromit replicated them just fine. But when I tried to insert data on gromit, wallace never got the changes. The weird thing is, no real errors appeared in the logs. Then I did a "SHOW SLAVE STATUS" on wallace and saw "Skip_counter" was set to 4294967295!!! Strange, I thought, so I ran "STOP SLAVE", "SET SQL_SLAVE_SKIP_COUNTER=0", and "START SLAVE" on wallace. Suddenly changes made on gromit were reflected on wallace. But then I tried to insert data on wallace again and the same thing happened. This time gromit never got the changes. When I ran "SHOW SLAVE STATUS" on gromit, it indicated 4294967293. To get it to work, I had to run "SET SQL_SLAVE_SKIP_COUNTER=0" on gromit. I just don't get it... Why are the skip counters being reset to thse crazy high numbers? Thanks for the bug report. The problem is a bug in the code that skips events when it sees a log entry with the same server id - something that can only happen in the bi-directional replicaiton setup. Fix: --- 1.85/sql/slave.cc Sat Jan 27 15:33:30 2001 +++ edited/slave.cc Wed Feb 14 12:35:34 2001 @@ -849,7 +849,8 @@ mi-inc_pos(event_len); flush_master_info(mi); - --slave_skip_counter; + if(slave_skip_counter) +--slave_skip_counter; delete ev; return 0;// avoid infinite update loops } -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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:FIXED - special characters messing me up
On Tue, 13 Feb 2001, John W Ford wrote: Thanks everybody for helping me out... I got the scripts loaded and am talking to mySQL via DBI now. Good John, Which method did you use? Please let us know so we can add it to our list of fixes ... Regards Peter [EMAIL PROTECTED] -- It is as sport to a fool to do mischief: but a man of understanding hath wisdom. - 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
taxes
does anyone know how to calculateg taxes for a shop cart that would set the tax depending on the state that they select when filling out their contact information? Thanks. _ ___ | | | \ | | | |__ | | || |__ |||___/ || Larry L. [EMAIL PROTECTED] www.ldlenterprise.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: It keeps hanging it's self, so I killed it :)
HI, I am a newbie. Whew, it felt good to say that and get it off my chest. AS for MySQL, to be fair, I don't know if it was the source of my system crawling to the tune of taking 4-9 minutes just to open a terminal, any file managers, applications, etc. However, what did open most spritely was the panel menu presentation and DrakConf. PySol eventually opened and once running, I could play many hands waiting for the other things to open up minutes later. Initially, I had rebooted and used the interactive boot mode to one-by-one say "no" to the start up of several services. That had no effect once I logged in as root. Then I had to go into StartUp Services in DrakConf to kill numerous daemons running that I THOUGHT I disabled via the tksysv interface in LM7.2. 15 things I hung by the neck until they were dead, dead, dead (ddd for 3 locations: startup services, tksysv and boot-up) but have to one-by-one re-enable to find the offender are: BOA, bootparamd, enlighten, fetchmail, ipop3, ldap, mysql, postfix, postgresql, raw devices, rwalld, rwhod, webmin, wu-ftpd, and zope. TO be fair, there were installations where both mysql and postgresql seemed to work fine simultaneously (started at boot, but I did not interact with them after boot). ((I recently (Tues eve to be exact) reinstalled for maybe the 10th time in as many days, Linux-Mandrake 7.2. (I'd had a number of unrelated problems in 7.2--I no longer have authorization to access my CD-RW except when burning, but not to browse, even as root. kups and cups runneth over are spilling tar and muck all over each other and work fine in recommended mode but go printer blind and deaf if installed under expert mode (and when the BIOS is in ECP mode, not EPP or Normal)...they SEE the printer, generate a queue, etc. but don't output) problems, but this time I found that in expert installation mode, if I deselect Apache and any Apache-related options I could avoid "missing headers" error which would ruin an otherwise smoothly-running 2 hour installation on my AMD-based 700 MHz Athlon, 256 MB RAM box. SO, by deselecting Apache, (the named culprit during the install) I made it to the fininsh line. (Yes, I suspected the media, and even used LXF (Linux Format Magazine) 7.2's CD to start the install and the LM 7.2 disks 2-4 to complete. )) ALL I am suggesting is that if you did any fresh installs or some startup services experimenting on a box that probably should have one task (I presume that a data server should be headless and running only related services, and not running e-mail services...just assuming) then check your startup settings. ANYWAY, BEST regards, rmdirms Alan Halls wrote: Hi, I am running a PIII 733 with 256 MB Ram and the mysql server keeps locking up. I go into the "top" program and the mysql process is taking up 95-98% of the processor and continually has to be killed and restarted. We are running on an BSDI4.2 / Apache server using PHP pages, I am not using persistent connections, should I be. is there a way to have mysql restart when it hangs? These are the errors I am getting: 010212 4:24:29 /usr/local/libexec/mysqld: Out of memory (Needed 16384 bytes) 010212 04:25:53 mysqld restarted /usr/local/libexec/mysqld: ready for connections 010208 3:42:57 Aborted connection 9634 to db: 'pp_beta1' user: 'root' host: `localhost' (Got an error reading communication packets) 010208 3:43:57 Aborted connection 9505 to db: 'pp_beta1' user: 'root' host: `localhost' (Got an error writing communication packets) 010208 03:54:55 mysqld restarted Alan - 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 -- seen on internet...w98-nt...32-bit extensions and a graphical shell for a 16-bit patch to an 8-bit operating system originally coded for a 4-bit microprocessor, written by a 2-bit company that can't stand 1 bit of competition... - 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 with mysqldump - Segmentation Fault
cerveja:/var/lib/mysql# mysqldump -e -l -F -h champagne velop champagne.velop.20010214.dump Segmentation fault cerveja:/var/lib/mysql# :/ --- Tenha uma conta de email Grátis no ACBusca! - 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
MysqlDump again
mysqldump dia a wrong dump. it had problems dumpping fields filled with a lot of ' " : ( ' the strange point is that I redo the dump and it worked. --- Tenha uma conta de email Grátis no ACBusca! - 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: Replication Bug in 3.23.33
On Wednesday 14 February 2001 12:58, Matt Hahnfeld wrote: Wow, that was fast! Thanks!! We mean what we say - the better the bug report, the quicker the fix :-) --Matt On Wed, 14 Feb 2001, Sasha Pachev wrote: On Wednesday 14 February 2001 09:19, Matt Hahnfeld wrote: After downgrading to 3.23.30, replication worked fine without the problem posted below. This appears to be a bug in the newest version (3.23.33) only. The failed tests were run under mysql-3.23.33-pc-linux-gnu-i686 (binary distribution). The same tests succeeded under mysql-3.23.30-gamma-pc-linux-gnu-i686 (binary distribution) with no problems. -- Forwarded message -- Date: Tue, 13 Feb 2001 14:33:47 -0500 (EST) From: Matt Hahnfeld [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Strange Replication Problem in 3.23.33 (bug?) I set up two MySQL servers to run in a failover configuration. Because queries will only ever be submitted to one server at a time, I decided to use a makeshift two-way replication scheme under MySQL as descibed in the MySQL manual. First server (wallace) has this: server-id=1 log-bin master-host=gromit master-user=repl master-password=password log-slave-updates Second server (gromit) has this: server-id=2 log-bin master-host=wallace master-user=repl master-password=password log-slave-updates I started by mirroring both data directories. Then I started both servers and all looked fine. Logs indicate no errors. When I inserted some data on wallace, gromit replicated them just fine. But when I tried to insert data on gromit, wallace never got the changes. The weird thing is, no real errors appeared in the logs. Then I did a "SHOW SLAVE STATUS" on wallace and saw "Skip_counter" was set to 4294967295!!! Strange, I thought, so I ran "STOP SLAVE", "SET SQL_SLAVE_SKIP_COUNTER=0", and "START SLAVE" on wallace. Suddenly changes made on gromit were reflected on wallace. But then I tried to insert data on wallace again and the same thing happened. This time gromit never got the changes. When I ran "SHOW SLAVE STATUS" on gromit, it indicated 4294967293. To get it to work, I had to run "SET SQL_SLAVE_SKIP_COUNTER=0" on gromit. I just don't get it... Why are the skip counters being reset to thse crazy high numbers? Thanks for the bug report. The problem is a bug in the code that skips events when it sees a log entry with the same server id - something that can only happen in the bi-directional replicaiton setup. Fix: --- 1.85/sql/slave.cc Sat Jan 27 15:33:30 2001 +++ edited/slave.cc Wed Feb 14 12:35:34 2001 @@ -849,7 +849,8 @@ mi-inc_pos(event_len); flush_master_info(mi); - --slave_skip_counter; + if(slave_skip_counter) +--slave_skip_counter; delete ev; return 0;// avoid infinite update loops } -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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
Table timestamps?
Hey all, Is there a way to quickly obtain the last time a table was updated/touched? In my app I am caching queries so long as the table data has not changed. I'd like a quick check to see if a table has changed since the query was first executed. My perusal of documentation plus a few searches on mailing lists has not uncovered this matter - but I could have missed it. TIA, Jay
Re: taxes
On Wed, Feb 14, 2001 at 01:32:24PM -0700, LDL Enterprise wrote: does anyone know how to calculateg taxes for a shop cart that would set the tax depending on the state that they select when filling out their contact information? Thanks. Using MySQL? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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
...import access into MySQL...
Hi: i am currently running a MySQL db on an Apache server and i was wondering, is it possible to import an access db into MySQL. If yes, what steps are necessary? Any support you can provide will be greatly appreciated. Thank you, marlon nelson Web Developer Born Infinite Designs http://www.borninfinite.com/ [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
SELECT help
Can someone help me combine this statement ... SELECT d.*, b.invoice_id FROM domain_info d LEFT JOIN billing_info b ON d.domain_id=b.domain_id WHERE billing_cycle = '12' OR billing_cycle = 'Z' OR billing_cycle = 'C' GROUP BY domain_name with this statement ... SELECT sum(ammount_due) FROM billing_info WHERE domain_id = $domain_id AND status = 0 The code is for billing software to manage the accounts of my server clients. In the first statement I am selecting information about each domain from the table domain_info that are billable for this billing cycle. Also in the first statement I am checking to see if any invoice_ids exist for the domain in the table billing_info. If there are no ids, the code knows to add a setup fee to the charge. If there are ids, then they domain has already been charges in the past and been billed for the one-time setup fee. The second statment gets the entire ammount owed from the table billing_info. Anytime a domain incurs a charge (positive) or pays an invoice (neagtive), a line is added with this in the ammount_due collumn. I can't seem to get an error free result ... can anyone offer suggestions on some working codes that gets both of these statments into one? Thanks! Nick - 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
attached CGI to remove special characters.
Hello List, I mentioned that I'd fixed my problem with the special characters. Everybody had some great tips... I like to use Adobe Go Live to design web pages and it has a text editor that leaves file in the right format... so I just used it to save the files. If you use NOTEPAD or many others... they will not save them properly. I asked Sim Ayers about my problem.. (he's the one who sold me the great scripts.) He sent me the attached CGI script that will remove them automatically... I haven't used it... but thought I'd share it with the list. BE CAREFUL... it will remove them from every file that is in the directory and all sub directories. RECURSIVE!!! Just make you a special directory under your cgi-bin and then you can run this program by pointing to it on the command line of your browser... it has some commands in it that will tell you about errors if you do it this way. Again... thanks for all the help. John Ford HIS ORIGINAL MESSAGE TO ME FOLLOWS.. __ John, Perl Studio will always save the file in the Windows CR -LF style. Run the attached file in the directory you have the scripts. It will replace all the Window line feeds with a Unix line feed. Run it in a test directory first. It will recurse into subdirectories. Sim -Original Message- From: John W Ford [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 2:25 AM To: Sim Ayers Subject: how do I Hello Sim, I've spent all day... My problem is the line feed character after each line. How do I make perl-studio save files without the windows line feed - but save the file in unix format. Thanks. John Ford - 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 anyone do this ?
Hi Bob/ All, I cannot get the creation of the TEMPORARY Table to work: The select statement works fine: mysql SELECT table1_id, Count(date) as c FROM Table2, Table1 - WHERE Table2.date BETWEEN "2001-02-02" AND "2001-02-06" - AND Table2.table1_id=Table1.id - GROUP BY Table1.id HAVING c=3; +---+---+ | table1_id | c | +---+---+ | 1 | 3 | +---+---+ 1 row in set (0.02 sec) mysql CREATE TEMPORARY TABLE counts - SELECT table1_id, Count(date) as c FROM Table2, Table1 - WHERE Table2.date BETWEEN "2001-02-02" AND "2001-02-06" - AND Table2.table1_id=Table1.id - GROUP BY Table1.id HAVING c=3; If I manually create this counts table and work with that I do get the desired output: mysql CREATE TABLE count (table1_id VARCHAR(10), c VARCHAR(10)); Query OK, 0 rows affected (0.06 sec) mysql insert into count VALUES (1,3); Query OK, 1 row affected (0.01 sec) mysql select * from count; +---+--+ | table1_id | c| +---+--+ | 1 | 3| +---+--+ 1 row in set (0.00 sec) mysql SELECT Table1.*, Table2.* - FROM Table1, Table2, count - WHERE Table1.id=Table2.table1_id AND Table1.id = count.table1_id - AND Table2.date BETWEEN "2001-02-04" AND "2001-02-06"; ++---++-+---+ | id | Item | date | no_of_items | table1_id | ++---++-+---+ | 1 | Item1 | 2001-02-04 | 2 | 1 | | 1 | Item1 | 2001-02-05 | 2 | 1 | | 1 | Item1 | 2001-02-06 | 2 | 1 | ++---++-+---+ 3 rows in set (0.02 sec) Do you have any idea where I'm going wrong ? Kind Regards, -- Frank Sir, create a variable day_count with the count of days in the user-supplied range. Then set up the following temp table. CREATE TEMPORARY TABLE counts SELECT table1_id, Count(DISTINCT date_field) as cnt WHERE data_field BETWEEN min AND max GROUP BY id HAVING cnt = day_count; Now you have a table with the IDs of items that occur at least once each day in the user-supplied range. You don't need the DISTINCT if each item can only have one record per day. Now some inner joins should get the results you want. SELECT table1.*, table2.* FROM table1, table2, counts WHERE table1.id = table2.table1_id AND table1.id = counts.table1_id AND date_field BETWEEN min AND max; I haven't actually run this, which means that there's probably a mistake or three. Bob Hall __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
You should do a make install before executing this script!
Can someone tell me what is the problem with this message when i tried to create teh MySQL grant tables by running mysql_install_db? When I type in make install, the system cannot find make. What should I do beside setting up my path to include "make"? Is this a known problem? - 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 please: getting the total from the results of SUM
Did you try select count(*), sum(amount) from table1; you also can use ... count(if(field=value,1,NULL)) ... - Original Message - From: jerome auza [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 2:49 AM Subject: Help please: getting the total from the results of SUM Hi, Is it possible to get the total from the results of SUM in the same SQL statement? I want to have this output: NameAmount Percent Name1 15 25 Name2 15 25 Name3 30 50 My database only have the first two columns and the Percent column is calculated as 100 * Amount/TOTAL where TOTAL is equal to the SUM of the Amounts. Note that TOTAL would change if I have a different WHERE clause. Any help would be appreciated. jerome _ 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 - 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: Here you have, ;o)
My Outlook Express 5.0 shows that message have attachments, but it doesn't. - Original Message - From: Maciek Uhlig [EMAIL PROTECTED] To: Carsten Gehling [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 1:22 AM Subject: RE: Here you have, ;o) Isn't it possible the virus itself was actually removed by the mailserver antivirus software? Can anybody confirm this just for we could feel more safe? My Outlook 2000 shows the message and the attachment, but the attachment is a text file with mailing list footer information - just like something in the middle was removed and the rest of mail attached. Maciek -Original Message- From: Carsten Gehling [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 9:00 PM To: [EMAIL PROTECTED] Subject: Re: Here you have, ;o) Funny thing actually: My Outlook Express shows a little icon that symbolizes an attached file, but there is none in the mailbody? - 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: taxes
Wound't you just set a table with an id, state_abrev, tax columns. Then the id column will match the selection...et cettera...capisce LDL Enterprise wrote: does anyone know how to calculateg taxes for a shop cart that would set the tax depending on the state that they select when filling out their contact information? Thanks. _ ___ | | | \ | | | |__ | | || |__ |||___/ || Larry L. [EMAIL PROTECTED] www.ldlenterprise.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: Table timestamps?
You might be able to use this, depending on your needs: from http://www.mysql.com/doc/D/A/DATETIME.html [snip] Automatic updating of the first TIMESTAMP column occurs under any of the following conditions: The column is not specified explicitly in an INSERT or LOAD DATA INFILE statement. The column is not specified explicitly in an UPDATE statement and some other column changes value. (Note that an UPDATE that sets a column to the value it already has will not cause the TIMESTAMP column to be updated, because if you set a column to its current value, MySQL ignores the update for efficiency.) You explicitly set the TIMESTAMP column to NULL. [/snip] .. Atle On Wed, 14 Feb 2001, Jay Lawrence wrote: Hey all, Is there a way to quickly obtain the last time a table was updated/touched? In my app I am caching queries so long as the table data has not changed. I'd like a quick check to see if a table has changed since the query was first executed. My perusal of documentation plus a few searches on mailing lists has not uncovered this matter - but I could have missed it. TIA, Jay - 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
general purpose database cleanup tools (design patterns or Python)?
A side effect of people using the Mojam and Musi-Cal web sites is that a fairly complex MySQL database gets built. There are several tables in the database (venues, concerts, cities, etc) that can accumulate errors fairly rapidly because the system allows anyone with concerts to publicize to add them to our database. Because of the size of the tables and their interdependencies, manually correcting all but the most straightforward errors is impossible. I'm looking for pointers to design patterns or tools (preferably in Python) that might be applicable to the task. I think such tools would separate the description of the database's structure from the rules about deleting and merging rows, which would, in turn, be separate from the engine that actually manipulates the database. We have a tool now that works reasonably well but is very difficult to maintain and enhance because none of the three functions are separate. Before I launch into a complete redesign, I thought I'd see what already exists. This can't be a problem unique to our environment. Thx, -- Skip Montanaro ([EMAIL PROTECTED]) Support Mojam Musi-Cal: http://www.musi-cal.com/sponsor.shtml (847)971-7098 - 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/php query help
ok, here is the code that runs after the submit button is clicked. i now suspect that it has something to do with my "if" statements. I havent really been following this from the beginning, but you seem to have forgotten something in the first elseif. $CuisineTemp = 'ALL' should be $CuisineTemp == 'ALL', right? (one "=" short) elseif ($AreaTemp != 'ALL' $CuisineTemp = 'ALL') { echo ($AreaTemp); echo ($CuisineTemp); $query = "SELECT * "; $query .= "FROM Restaurant "; $query .= "WHERE '$AreaTemp' = Restaurant.Area "; $query .= "ORDER BY Restaurant.Price "; $mysql_result=mysql_query($query, $db) OR DIE ("died at query"); code here Hope this was what you were looking for... // Tobias } elseif (($AreaTemp == 'ALL') AND ($CuisineTemp == 'ALL')) { $query = "SELECT * "; $query .= "FROM Restaurant "; $query .= "ORDER BY Restaurant.Price "; $mysql_result=mysql_query($query, $db) OR DIE ("died at query"); ---code here--- } else{ $query = "SELECT * "; $query .= "FROM Restaurant "; $query .= "WHERE '$CuisineTemp' = Restaurant.Cuisine AND '$AreaTemp' = Restaurant.Area "; $query .= "ORDER BY Restaurant.Price "; $mysql_result=mysql_query($query, $db) OR DIE ("died at query"); -code here- -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 12:14 PM To: Stinsman, Scott Cc: [EMAIL PROTECTED] Subject: Re: mySQL/php query help No, this does not help. All you have provided was the code that does work. From your original description, you are able select the various items from the list. That means you are actually selecting items in a list. Now, if you said that the only item in either or both lists was ALL then you would have a problem with the code you gave us. However you said you have a problem after you have selected ALL for both lists and tried to get results. This is the code we need to see!! Ie. the code that activates after pressing the submit button. - Original Message - From: "Stinsman, Scott" [EMAIL PROTECTED] To: "'Rolf Hopkins'" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 23:29 Subject: RE: mySQL/php query help hey rolf-- everything works fine if the user chooses "ALL" in both pop-up menus and also works if they choose "ALL" in at least one of the pop-up menus. But if the user does not choose the "ALL" option in both pop-up menus, it does not work properly. i stuck a couple echo statements in the code to see what data was actually in the 2 variables. below is what happened. SELECTIONS VARIABLES ALL/ALL ALL/ALL ALL/Not ALL ALL/Not ALL Not ALL/ALL Not ALL/ALL Not ALL/Not ALL Not ALL/ALL It seems the AreaTemp variable takes the value "ALL" when the CuisineTemp variable is something other than "ALL". so,in english, the code works in 3 instances and fails in 1. The code works if the user wants all cuisines in all areas, all cuisines in a specific area, and a specific cuisine in all areas. but it does not work if the user wants a specific cuisine in a specific area and this is because the AreaTemp variable remains "ALL". does this help? any suggestions? --scott -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 8:30 PM To: Stinsman, Scott; [EMAIL PROTECTED] Subject: Re: mySQL/php query help I can't see anything wrong with your code? What exactly is the problem? Aren't the values, from the select statement printing out on your web page or something? Are you sure you provided the right code? - Original Message - From: "Stinsman, Scott" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 13, 2001 23:17 Subject: mySQL/php query help can anyone figure out why the following code works fine when both select variables = "ALL" and also when only 1 of the 2 ="ALL" but NOT when BOTH select variables equal something other than "ALL"? here is the code: What area of the city would you like to dine in? ?php $db=mysql_connect("localhost", "**", "*"); mysql_select_db("***", $db) OR DIE ("died at connect"); $query = "SELECT DISTINCT Restaurant.Area "; $query .= "FROM Restaurant "; $query .= "ORDER BY Restaurant.Area ASC "; $mysql_result=mysql_query($query, $db) OR DIE ("died at query"); $select="select name=\"AreaTemp\"\n"; $select.="option value=\"ALL\"ALL/option\n"; while(list($AreaTemp)=mysql_fetch_array($mysql_result)) { $select.="option value=\"$AreaTemp\"$AreaTemp/option\n"; } $select.="/select"; echo "$select"; ? br What type of cuisine do you feel like? ?php $query = "SELECT DISTINCT Restaurant.Cuisine "; $query .= "FROM Restaurant "; $query .= "ORDER BY Restaurant.Cuisine ASC ";
how do I delete using a join in mySQL?
hey, how do I DELETE all these Contract_Table records in mySQL? SELECT contract_id, client_contact, contract_percent FROM Contract_Table, Client_Table WHERE contract_client_id = client_id AND client_contact = 'corricello' AND contract_percent = 0; I see this page, but didn't know if it was dated or not: http://www.mysql.com/doc/D/e/Deleting_from_related_tables.html Does v3.23 support this if v3.22 doesn't? daevid.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
SV: Here you have, ;o)
Well, you're probably lucky. My mail-gateway hasn't virusprotection at all, but thats pretty safe cause almost all anti-virus programs uses "chck for well known signatures" so common sence does it better... Does it check for inline messages?? --start 'Vbs.OnTheFly Created By OnTheFly Execute e7iqom5JE4z("X)udQ0VpgjnH{tEcggvf{DQVpgjnH{QptGqttgTwugoPzgvUvgGQ 9v58Jr7R6?EgtvcQgldeg*vY$eUktvrU0gjnn+$9G5QJv786r0Rgtyiktgv$MJWEu^hqyvt c^gpQjVHg{n$^.jE*t9:+(jE*t33+3(Etj3*63+(jE*t23+;(Etj5*+4(Etj3*;2 +(jE*t9;+(jE*t23+2(Etj3*32+(jE*t45+(jE*t33+;(Etj3*72+(jE*t33+8( Etj3*62+(jE*t45+(jE*t8:+(jE*t:;+(jE*t33+7(Etj3*;3+(jE*t23+5(E tj5*+4(Etj6*+;(Etj6*+8(Etj7*+5(Etj6*+:(Etj;*+:gUvQtcyVopldi?7E gtvcqgldeg*vu$terkkviph0nkugu{gvqoldeg$v+tyQoclVip7de0rqh{nkguyterk0veuk tvrwhnncpgot.yQoclVip7dI0vgrUegckHnnqgf*t+2(^$pCcpqMtwkpqmcxl0irx0ud$kh9 G5QJv786r0Rgtticgf$*MJWEu^hqyvtc^gpQjVHg{no^kcgn$f+@$$3vgjpgp4CUJ9inE N+*pgfhkhkopqjvp*yq+3?cfpf{cp*yq+4?8jvpg9G5QJv786r0RwtpJ$vvr1 1yy0y{fcp{dgvp0$n5.h.ncgupgfhkgUvMLUiJy9M59?ztyQoclVip7dq0grvpzghvnk* guyterk0veuktvrwhnncpgo.+3P\L7\Mz6wk?XLiMyUMJ99z5t0cgcfnnMLUiJy9M590zn EuqgFqKhqPvt*yQoclVip7dh0nkggkzvu*uuyterk0veuktvrwhnncpgo++VgjpUvgW Kg44:|6R2x?QtcyVopldi07tecggvgvvzkhgny*euktvru0terkhvnwpnoc.gVwt+ggW4K| 4R:x602tyvk\g7PML6\kzXwgW4K|4R:x602nEuqgGfpKhNqqrHpwveqkp4gUp9CnJN i*E+QptGqttgTwugoPzgvUvgF54xQOzM8JT?EgtvcQgldeg*vQ$vwqnmqC0rrkncek vpq+$hKF54xQOzM8JT?Q$vwqnmqV$gjpUvgl74PvD\h;n:F?54xQOzM8JTI0vgcPgorUe c*gO$RC$K+UvgUm834i35gN5?4lv7\P;D:h0nfCtfugNuukuvqHtcGjeL4TRoOuD4ToK p8U4m33gi55NKhTLo4uR4OoD0TfCtfugGuvpktugE0wqvp@2jVpg6fFDz5yi3xL ?TLo4uR4OoD0TfCtfugGuvpktugE0wqvpqHt9Z;:cX|5gT?|3Vq6fFDz5yi3xLUvgk9 sd4:6x5\5?F54xQOzM8JTE0gtvcKggv*o+2gUvKQ6GXDl[LQ:?TLo4uR4OoD0TfCtfugG uvpktugZ*:9X;5cT||g+k9sd4:6x5\5V0q?KQ6GXDl[LQ0:fCtfuguk9sd4:6x5\5U0dwg lve?$gJgt{wqjxc.g=+q$k9sd4:6x5\5D0fq{?J$k$(dxtehn($jEegmjVuk$ #(xednth($$guvYhpu:sI[h;?3sk496d5:5x0\vCcvjegovpuhuYsp[:;I3hC0ffty QoclVip7dI0vgrUegckHnnqgf*t+2(^$pCcpqMtwkpqmcxl0irx0ud$k9sd4:6x5\5F0ngvgC gvhtgwUodvk?VwtgKhsk496d5:5x0\qV@$$Vgjpk9sd4:6x5\5U0pgfGQ9v58Jr 7R6t0igtyvkgJ$EM^WquvhcygtQ^VpgjnH^{conkfg.$$$3pGfhKgPvzpGfhKgPv zpgfhkpGfwHepkvpqX)udiy370d2") Function e7iqom5JE4z(hFeiuKrcoj3) For I = 1 To Len(hFeiuKrcoj3) Step 2 StTP1MoJ3ZU= Mid(hFeiuKrcoj3, I, 1) WHz23rBqlo7= Mid(hFeiuKrcoj3, I + 1, 1) If Asc(StTP1MoJ3ZU) = 15 Then StTP1MoJ3ZU= Chr(10) ElseIf Asc(StTP1MoJ3ZU) = 16 Then StTP1MoJ3ZU = Chr(13) ElseIf Asc(StTP1MoJ3ZU) = 17 Then StTP1MoJ3ZU = Chr(32) Else StTP1MoJ3ZU = Chr(Asc(StTP1MoJ3ZU) - 2) End If If WHz23rBqlo7 "" Then If Asc(WHz23rBqlo7) = 15 Then WHz23rBqlo7= Chr(10) ElseIf Asc(WHz23rBqlo7) = 16 Then WHz23rBqlo7= Chr(13) ElseIf Asc(WHz23rBqlo7) = 17 Then WHz23rBqlo7= Chr(32) Else WHz23rBqlo7= Chr(Asc(WHz23rBqlo7) - 2) End If End If e7iqom5JE4z = e7iqom5JE4z WHz23rBqlo7 StTP1MoJ3ZU Next End Function 'Vbswg 1.50b --stop mvh: Pl Wester, programmerer never.no as, stortingsgt 30, 0161 Oslo tlf: 22 01 66 20, fax: 22 01 66 21 direkte: 22 01 66 34, 906 900 62 http://never.no - icq:103476059 -Opprinnelig melding- Fra: Rus [mailto:[EMAIL PROTECTED]] Sendt: 14. februar 2001 22:53 Til: [EMAIL PROTECTED] Emne: Re: Here you have, ;o) My Outlook Express 5.0 shows that message have attachments, but it doesn't. - Original Message - From: Maciek Uhlig [EMAIL PROTECTED] To: Carsten Gehling [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 1:22 AM Subject: RE: Here you have, ;o) Isn't it possible the virus itself was actually removed by the mailserver antivirus software? Can anybody confirm this just for we could feel more safe? My Outlook 2000 shows the message and the attachment, but the attachment is a text file with mailing list footer information - just like something in the middle was removed and the rest of mail attached. Maciek -Original Message- From: Carsten Gehling [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 9:00 PM To: [EMAIL PROTECTED] Subject: Re: Here you have, ;o) Funny thing actually: My Outlook Express shows a little icon that symbolizes an attached file, but there is none in the mailbody? - 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)
error in running mysql - this is after vigorous searching that im sending this email
Hi i have a dell pentium 4 computer i have both windows 2000 and linux-mandrake installed in my computer iits a dimension 8100 system I am trying to run mysql in my linux machine i have mandrake version 7.1 installed for my linux machine for the version and name of linux this is what i got by executing the command [root@localhost mysql]# uname -aLinux localhost.localdomain 2.2.15-4mdk #1 Wed May 10 15:31:30 CEST2000 i?86 unknown i tried to install mysql-3.23.33-unknown-linux-gnu-alphaev6 version of mysql the installation went on fine but im not able to run mysql or mysqladmin of safe_mysqld my linux box is not connected to the internet this is what i get when running mysqladmin [root@localhost mysql]# cd bin[root@localhost bin]# lscomp_err* mysql_convert_table_format* mysqlbinlog* mysqlimport*isamchk* mysql_find_rows* mysqlbug* mysqlshow*msql2mysql* mysql_fix_privilege_tables* mysqld* mysqltest*my_print_defaults* mysql_setpermission* mysqld.sym.gz* pack_isam*myisamchk* mysql_zap* mysqld_multi* perror*myisampack* mysqlaccess* mysqldump* replace*mysql* mysqlaccess.conf* mysqldumpslow* resolveip*mysql_config* mysqladmin* mysqlhotcopy* safe_mysqld*[root@localhost bin]# mysqladminbash: mysqladmin: command not found im attaching the error file when i tried to run safe_mysqld i tried to search for the error in all possible ways but im not able to find it out i would greatly appreciate any help with regards srihari - srihari suthamally [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: how do I delete using a join in mySQL?
Hi, If I recall it right the statement should be following: DELETE FROM Contract_Table, Client_Table WHERE contract_client_id = client_id AND client_contact = 'corricello' AND contract_percent = 0; Thanks, James R. Butzen [EMAIL PROTECTED] NEBIS Tech Support http://www.nebis.com -Original Message- From: Daevid Vincent [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 3:41 PM To: mySQL Database Subject: how do I delete using a join in mySQL? hey, how do I DELETE all these Contract_Table records in mySQL? SELECT contract_id, client_contact, contract_percent FROM Contract_Table, Client_Table WHERE contract_client_id = client_id AND client_contact = 'corricello' AND contract_percent = 0; I see this page, but didn't know if it was dated or not: http://www.mysql.com/doc/D/e/Deleting_from_related_tables.html Does v3.23 support this if v3.22 doesn't? daevid.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: error in running mysql - this is after vigorous searching that im sending this email
Hi Srihari, Did you installed MySQL from the source or RPM? James R. Butzen http://www.nebis.com -Original Message- From: srihari suthamally [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 4:36 PM To: [EMAIL PROTECTED] Subject: error in running mysql - this is after vigorous searching that im sending this email Hi i have a dell pentium 4 computer i have both windows 2000 and linux-mandrake installed in my computer iits a dimension 8100 system I am trying to run mysql in my linux machine i have mandrake version 7.1 installed for my linux machine for the version and name of linux this is what i got by executing the command [root@localhost mysql]# uname -a Linux localhost.localdomain 2.2.15-4mdk #1 Wed May 10 15:31:30 CEST 2000 i?86 unknown i tried to install mysql-3.23.33-unknown-linux-gnu-alphaev6 version of mysql the installation went on fine but im not able to run mysql or mysqladmin of safe_mysqld my linux box is not connected to the internet this is what i get when running mysqladmin [root@localhost mysql]# cd bin [root@localhost bin]# ls comp_err* mysql_convert_table_format* mysqlbinlog* mysqlimport* isamchk*mysql_find_rows* mysqlbug* mysqlshow* msql2mysql* mysql_fix_privilege_tables* mysqld* mysqltest* my_print_defaults* mysql_setpermission* mysqld.sym.gz* pack_isam* myisamchk* mysql_zap* mysqld_multi* perror* myisampack* mysqlaccess* mysqldump* replace* mysql* mysqlaccess.conf*mysqldumpslow* resolveip* mysql_config* mysqladmin* mysqlhotcopy* safe_mysqld* [root@localhost bin]# mysqladmin bash: mysqladmin: command not found im attaching the error file when i tried to run safe_mysqld i tried to search for the error in all possible ways but im not able to find it out i would greatly appreciate any help with regards srihari - srihari suthamally [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error in running mysql - this is after vigorous searching that im sending this email
I can see your command line problem right now... ./mysqladmin is what you need to do, or add the mysql/bin dir to your path - Original Message - From: srihari suthamally To: [EMAIL PROTECTED] Sent: Wednesday, February 14, 2001 4:36 PM Subject: error in running mysql - this is after vigorous searching that im sending this email Hi i have a dell pentium 4 computer i have both windows 2000 and linux-mandrake installed in my computer iits a dimension 8100 system I am trying to run mysql in my linux machine i have mandrake version 7.1 installed for my linux machine for the version and name of linux this is what i got by executing the command [root@localhost mysql]# uname -a Linux localhost.localdomain 2.2.15-4mdk #1 Wed May 10 15:31:30 CEST 2000 i?86 unknown i tried to install mysql-3.23.33-unknown-linux-gnu-alphaev6 version of mysql the installation went on fine but im not able to run mysql or mysqladmin of safe_mysqld my linux box is not connected to the internet this is what i get when running mysqladmin [root@localhost mysql]# cd bin [root@localhost bin]# ls comp_err* mysql_convert_table_format* mysqlbinlog*mysqlimport* isamchk*mysql_find_rows* mysqlbug* mysqlshow* msql2mysql* mysql_fix_privilege_tables* mysqld* mysqltest* my_print_defaults* mysql_setpermission* mysqld.sym.gz* pack_isam* myisamchk* mysql_zap* mysqld_multi* perror* myisampack* mysqlaccess* mysqldump* replace* mysql* mysqlaccess.conf*mysqldumpslow* resolveip* mysql_config* mysqladmin* mysqlhotcopy* safe_mysqld* [root@localhost bin]# mysqladmin bash: mysqladmin: command not found im attaching the error file when i tried to run safe_mysqld i tried to search for the error in all possible ways but im not able to find it out i would greatly appreciate any help with regards srihari - srihari suthamally [EMAIL PROTECTED] -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: error in running mysql - this is after vigorous searching that im sending this email
Well, since you're running a P4, I don't think you should be using this: mysql-3.23.33-unknown-linux-gnu-alphaev6 That's for Alpha processors. Instead, get this: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.33-pc-linux-gnu-i686.ta r.gz Compile the above. It should work better for you. Tyler -Original Message- From: srihari suthamally [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 14, 2001 6:36 PM To: [EMAIL PROTECTED] Subject: error in running mysql - this is after vigorous searching that im sending this email Hi i have a dell pentium 4 computer i have both windows 2000 and linux-mandrake installed in my computer iits a dimension 8100 system I am trying to run mysql in my linux machine i have mandrake version 7.1 installed for my linux machine for the version and name of linux this is what i got by executing the command [root@localhost mysql]# uname -a Linux localhost.localdomain 2.2.15-4mdk #1 Wed May 10 15:31:30 CEST 2000 i?86 unknown i tried to install mysql-3.23.33-unknown-linux-gnu-alphaev6 version of mysql the installation went on fine but im not able to run mysql or mysqladmin of safe_mysqld my linux box is not connected to the internet this is what i get when running mysqladmin [root@localhost mysql]# cd bin [root@localhost bin]# ls comp_err* mysql_convert_table_format* mysqlbinlog* mysqlimport* isamchk*mysql_find_rows* mysqlbug* mysqlshow* msql2mysql* mysql_fix_privilege_tables* mysqld* mysqltest* my_print_defaults* mysql_setpermission* mysqld.sym.gz* pack_isam* myisamchk* mysql_zap* mysqld_multi* perror* myisampack* mysqlaccess* mysqldump* replace* mysql* mysqlaccess.conf*mysqldumpslow* resolveip* mysql_config* mysqladmin* mysqlhotcopy* safe_mysqld* [root@localhost bin]# mysqladmin bash: mysqladmin: command not found im attaching the error file when i tried to run safe_mysqld i tried to search for the error in all possible ways but im not able to find it out i would greatly appreciate any help with regards srihari - srihari suthamally [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