Crash when loading data from file
Hi We have problem with moving data to new server. We dumped database with mysqldump on old server and used "mysql dbname < db.sql" syntax for database import. When mysql imports one of our biggest table, then the import fails and after some minutes gives an error message: "ERROR 1030 at line 244654: Got error 28 from table handler" What might be the problem? MySQL version on new server is 3.23.49a-log. Server have RedHat 7.2 installed, RAID disks, 512MB RAM, CPU is Intel PIII. If the problem is caused with RAID, then, how to set the "have_raid" variable to "ON" (I hasn't find this operation from manual). regards Hendrik === tel: 046 31634 DC Doora AS gsm: 051 51789 Heltermaa mnt 6 fax: 046 31455 Kärdla, Hiiumaa - 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
How to control the number of mysqld processes
I have checked all the configurable parameters, but still is wondering what controls the number of processes started on the mysql startup. I am especially interested in bin/mysqld Ver 3.23.48-max for pc-linux-gnu on i686 Even with small configuration, I have 4 processes without and addition 7 processes with InnoDb support. Thank you. -- Anatoly Osiko Analyst Programmer Reservoir Team Ltd. - 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 ordering select
Hello! I'm not a very experienced SQL user and I cam accross a problem. But first I will explain the database structure. There are two tables: "mieszkania" whis contains some fields, one of them being "miasto_id" of int type, and the other called "miasta" with the same firld name joining these two tables. mysql> select mieszkania.powierzchnia,miasta.nazwa from mieszkania,miasta where mieszkania.miasto_id=miasta.miasto_id; +--+---+ | powierzchnia | nazwa | +--+---+ |76.45 | ŁódĽ | |92.79 | ŁódĽ | |75.58 | ŁódĽ | |86.55 | ŁódĽ | |44.78 | ŁódĽ | |84.43 | ŁódĽ | |98.76 | ŁódĽ | | 102.09 | ŁódĽ | |123.7 | ŁódĽ | +--+---+ 9 rows in set (0.00 sec) mysql> select mieszkania.powierzchnia,miasta.nazwa from mieszkania,miasta where mieszkania.miasto_id=miasta.miasto_id order by mieszkania.powierzchnia; ERROR 1030: Got error 28 from table handler Why can't I use "order by"? Do I need to make some indexes on the tables? What If I have more tables joined by such a relation? Please help. Michal. - 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: NT service problem
Hi, What version of MySQL are you trying to get up and running ? If this version is the mysql max, You will have to run the standalone first in order to create the InnoDB datafiles, then it should start as a service. I have had this exact same issue and it seemed to go away once I have run the --standalone option. Hope this helps Tommy -Original Message- From: Alexander Hampel [mailto:[EMAIL PROTECTED]] Sent: Mon, 18 Mar 2002 09:38 To: [EMAIL PROTECTED] Subject: NT service problem Hi Pierre, Thanks, for your help. That's what I exaclty do and this is for '--standalone' fine. But the point ist, I want to start mysqld-nt as NT service - and this is the problem - it wouldn't let me start it as service: >C:\>net start mysql >System error 1069 >Could not start service The service is an important issue. Lets you run a programm under different user rights. Probably I'll find some other solution. Thanks, A:lex >-Ursprüngliche Nachricht- >Von: Pierre du Parte [mailto:[EMAIL PROTECTED]] >Gesendet: Montag, 18. März 2002 08:04 >An: [EMAIL PROTECTED] >Cc: [EMAIL PROTECTED] >Betreff: Re: New to MySQL - can't start server :-( > > >Hi Alexander, >I use the PHPDEV compilation for local PHP/mySQL development work >(http://www.firepages.com.au/devindex.htm for a no-brainer approach to >getting PHP/mySQL/Apache up and running in seconds!) > >Anyway, for me > >start c:\phpdev\mysql\bin\mysqld-nt.exe --standalone > >kicks mySQL off on Win2K, NT and XP very nicely, thank you :) > >If your mySQL is in c:\ then > >start c:\mysql\bin\mysqld-nt.exe --standalone > >should work > >But I could be wrong, I often am > > >Pierre > > > > > >Alexander Hampel wrote: > >> Hi mailing list, >> >> I can't start mysqld-nt as I get the eror message 1067. If I start >> winmysqladmin.exe there is no server visible. >> >> The manual tell me in part 2.4 Post-installation Setup and Testing that I >> should start the script ./scripts/mysql_install_db but this script is not >> availabale (at all) at my Windows distribution. >> >> Any ideas what's wrong? >> >> >> Thank you, >> A:lex >> >> >> >> >> >> >> - >> 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 >> >> >> >> > > >-- >Pierre du Parté >Final Filer Software >349 Worrigee Road >Worrigee, NSW, Australia 2540 >http://www.finalfiler.com > >Phone 61 2 44216374 >Mobile 0413 483 066 > >"If it feels good, 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 > - 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
NT service problem
Hi Pierre, Thanks, for your help. That's what I exaclty do and this is for '--standalone' fine. But the point ist, I want to start mysqld-nt as NT service - and this is the problem - it wouldn't let me start it as service: >C:\>net start mysql >System error 1069 >Could not start service The service is an important issue. Lets you run a programm under different user rights. Probably I'll find some other solution. Thanks, A:lex >-Ursprüngliche Nachricht- >Von: Pierre du Parte [mailto:[EMAIL PROTECTED]] >Gesendet: Montag, 18. März 2002 08:04 >An: [EMAIL PROTECTED] >Cc: [EMAIL PROTECTED] >Betreff: Re: New to MySQL - can't start server :-( > > >Hi Alexander, >I use the PHPDEV compilation for local PHP/mySQL development work >(http://www.firepages.com.au/devindex.htm for a no-brainer approach to >getting PHP/mySQL/Apache up and running in seconds!) > >Anyway, for me > >start c:\phpdev\mysql\bin\mysqld-nt.exe --standalone > >kicks mySQL off on Win2K, NT and XP very nicely, thank you :) > >If your mySQL is in c:\ then > >start c:\mysql\bin\mysqld-nt.exe --standalone > >should work > >But I could be wrong, I often am > > >Pierre > > > > > >Alexander Hampel wrote: > >> Hi mailing list, >> >> I can't start mysqld-nt as I get the eror message 1067. If I start >> winmysqladmin.exe there is no server visible. >> >> The manual tell me in part 2.4 Post-installation Setup and Testing that I >> should start the script ./scripts/mysql_install_db but this script is not >> availabale (at all) at my Windows distribution. >> >> Any ideas what's wrong? >> >> >> Thank you, >> A:lex >> >> >> >> >> >> >> - >> 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 >> >> >> >> > > >-- >Pierre du Parté >Final Filer Software >349 Worrigee Road >Worrigee, NSW, Australia 2540 >http://www.finalfiler.com > >Phone 61 2 44216374 >Mobile 0413 483 066 > >"If it feels good, 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 > - 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: New to MySQL - can't start server :-(
Hi Alexander, I use the PHPDEV compilation for local PHP/mySQL development work (http://www.firepages.com.au/devindex.htm for a no-brainer approach to getting PHP/mySQL/Apache up and running in seconds!) Anyway, for me start c:\phpdev\mysql\bin\mysqld-nt.exe --standalone kicks mySQL off on Win2K, NT and XP very nicely, thank you :) If your mySQL is in c:\ then start c:\mysql\bin\mysqld-nt.exe --standalone should work But I could be wrong, I often am Pierre Alexander Hampel wrote: > Hi mailing list, > > I can't start mysqld-nt as I get the eror message 1067. If I start > winmysqladmin.exe there is no server visible. > > The manual tell me in part 2.4 Post-installation Setup and Testing that I > should start the script ./scripts/mysql_install_db but this script is not > availabale (at all) at my Windows distribution. > > Any ideas what's wrong? > > > Thank you, > A:lex > > > > > > > - > 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 > > > > -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 "If it feels good, 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
InnoDB Question
Hi there I am busy evaluating InnoDB to decide whether to use it in our live environment, simultaneously (which proberly isn't the best thing) I am making changes to my code (I am using Visual Basic), to stream line my transactions and make full use of the "transaction" facility. My question to you is this: I am running with AutoCommit set to 1, but every time I am going to update an invoice I set it to 0, execute the tranactions queries updating in the region of 8 inno db tables while readnig some information from other InnoDb tables/Mysql Tables, then I commit and reset AutoCommit to 1. Part of my transactions are queries like "Update GenMas2002 Set Balance1=Balance1 + 500 where code='150100'" Now, my question is, what happens with a query above running simulatenously with another similar query, and then the first query is rolled back. I.e. if Balance1 was $100, the first query would then assume $100 + $500, the second query would assume ? would it be $600 or would it too assume $100? I am guessing it would assume $100 as mysql is set to READ COMMITED, and therefore it would not have seen the first transaction yet as it was either not yet comitted, or rolled back. So if the first query is then updated after the second query what would happen? It's timestamp is less than query two, yet query two has already updated the table, so would query one still pick up $100 or would it read the $600 after the query two transaction? Is this the right way to do this? i.e. using the "update balance1=balance1 + 500" in side a transaction which has the potentially to be rolled back and there could be any number of simulatenous queries of this nature executing on the same row in the same table at once? Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 Any views expressed in this message are the sender's own, and do not represent the views of RedTie Software except where the sender specifically states them to be the views of RedTie Software. This e-mail should only be read by those persons to whom it is addressed. Accordingly, we disclaim all responsibility and accept no liability (including in negligence) for the consequences of any person other than the intended recipients acting, or refraining from acting, on such information. If you have received this e-mail in error, please accept our apologies and we simply request that you delete this document. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail is strictly prohibited. - 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: Large table problems
On Mon, Mar 11, 2002 at 09:30:27AM -0500, Dan Patnaude wrote: > Hi- > > We are running mysql version 3.23.33, along with resin. The tables > we are using are large, but not overly so. We also, for reasons I > cannot comprehend, but for which my manager thinks is a good idea, > have index files that are as big as the data files themselves. So, > here is the problem: > > Every now and then (say once every two weeks), our table crashes, > saying that there is an invalid key file. I can repair the table, > but it is troubling that it happens so frequently. So, is the > problem with the size of the table (900,000 records =~ 220 MB), or > is it the overly large indexes my boss has set up. Also, could it be > resin not closing its sessions nicely? I know that this is vague, > but any help would be useful. Again the problem is: what causes a > table to lose its keyfile. In MySQL terms, that's not very big. Can you upgrade to the latest stable release and see if the problem persists? The one you are running is a bit old. A bug you're hitting may have been fixed already. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 38 days, processed 1,146,170,436 queries (343/sec. avg) - 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: processes stuck in "Opening table" state
hi all, since i haven't got any suggestion to the following problem, i'm wondering if anyone could point me to a source where i could seek help (i can't get my boss to pay for the support contract...) thanks a lot. Sammy Lau wrote: > > hi all, > > i've got a mysql server running around 100 queries per sec for most of > the time. > i got only 1 table in MyISAM format. > i got only around 6000 updates to this table per day. > max_connection is set to 600 > thread_cache is set to 600 > table_cache is set to 600 (there is NO join operation) > > everything seems fine, right. > my problem is, sometimes, i see a lot of processes (200+) got stuck in > "Opening table" state. at the same time mysqladmin status tells me the # > of open table is 583. this number never reaches the max setting. > > anyone got an idea why i'm seeing this behavior. please let me know if > i'm missing any information here. > > thanks a lot. > > -- > Sammy Lau > mailto: [EMAIL PROTECTED] > - Tell me what you want and I'll tell you how you can live without 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 -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without 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
Re: IS THIS BETTER?
> -> "Cannot add new record set to the database > Error Description: Current Recordset does not support > updating. This may be a limitation of the provider, or > of the selected locktype. > > Error Number: 3251 > > Error Source: ADODB.Recordset Better than what? SHOUTING better than not shouting? That was hard to read, and I ignored it until Todd, Dan and others commented on blocking posts that are mostly capitals. Maybe I'll make myself a little de-capitation^H^H^H^Hlization filter. MySQL better than ACCESS? I think so. BTW, I did a quick search on Google: "mysql error 3251", and found this: http://www.geocrawler.com/archives/3/13/2001/11/0/7183423/ Like Todd says. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sql help examining log table
Hi Viraj, You can do it using temporary table. Create temporary table tmp select subject from outgoing where auth='USER' order by timestamp desc limit 50; Select count(distinct subject) from tmp group by subject; drop table tmp; If the result of the second query is 1 all the last 50 messages have the same subject. It is assumed there are at least 50 rows for auth = 'USER'. Regards Anvar. At 03:34 PM 17/03/2002 -0500, you wrote: >Hello, > >We use mysql to store outgoing email headers from our users and do throttling >on users that appear to be spamming based on some simple queries to this >table. We use the Communigate mail server and this throttling script is a PERL >program implemented as a content filter. More information is here for those >interested: > >http://www.cse.fau.edu/~valankar/ > >I am trying to figure out what is the best way to do a certain query. My >outgoing log table looks like this: > >mysql> desc outgoing; >+---+--+--+-+-+---+ >| Field | Type | Null | Key | Default | Extra | >+---+--+--+-+-+---+ >| rpath | varchar(80) | YES | | NULL| | >| auth | varchar(80) | | MUL | | | >| ip| varchar(80) | YES | | NULL| | >| hfrom | varchar(80) | YES | | NULL| | >| hto | varchar(80) | YES | | NULL| | >| subject | varchar(80) | YES | | NULL| | >| messageid | varchar(80) | YES | | NULL| | >| timestamp | timestamp(14)| YES | | NULL| | >| rcpts | smallint(5) unsigned | YES | | 0 | | >+---+--+--+-+-+---+ > >What I would like to do is reject a message if the last 50 messages have the >same subject. > >In other words, I want to look at the 50 latest entries in this table for a >certain user (identified by the auth field) to find out if all of these >messages have the same subject. > >The only way I can think of doing this is basically: > >select subject from outgoing where auth='USER' order by timestamp desc >limit 50 > >And then going through each one of these rows in my program to see if they are >all the same subject. Is there a way I can do this logic in the select query >instead? > >Thanks, > >Viraj. > >- >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.sock
I get drwxr-xr-x 4 mysqldaemon 540 Mar 17 17:44 mysql Art -Original Message- From: Dan Vande More [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 5:27 PM To: [EMAIL PROTECTED] Subject: RE: mysql.sock That's because you get this: '020317 16:48:10 mysqld ended.' It means there was an error, and the database server is no longer running. Check your mysql log files to find out why. Does the user, 'mysql' have permissions to write into the directory mysql is using, normally /var/lib/mysql Who is the owner, and group for that directory? And what are the permissions? Do an 'ls -la /var/lib/' You should have something like: 'drwxrwxr-x 25 mysqlroot 3072 Mar 16 23:00 mysql' or even 'drwxrwxr-x 25 rootmysql 3072 Mar 16 23:00 mysql' -Original Message- From: Art Fore [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 6:04 PM To: [EMAIL PROTECTED] Subject: RE: mysql.sock Found the file there, guess I missed it or it got created after I looked before If I run ./safe_mysqld --user=mysql & I get Starting mysqld-max daemon with databases from /var/lib/mysql 020317 16:48:10 mysqld ended. I run mysqladmin u root -p piccolo 'new-password' Enter password: I then get connect to server at 'localhost failed If I run mysqld -ping, I get all kinds of info back. So guess I am completely lost. Art -Original Message- From: Mark Maunder [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 4:12 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: mysql.sock Art, Do you mean, whenever you try to run the 'mysql' client you get that error? That usually happens because you are trying to connect to the mysql server using the mysql client running on the same machine i.e. localhost. It's because the mysql client uses a socket file when connecting locally and the mysqld server is not storing the file in the default location where the client expects it. Fix it by putting this entry in the file /etc/my.cnf under the [client] section. socket = /tmp/mysql.sock or whatever the location of your socket file is. If you can't find it do a find / -name "mysql.sock" Hope that helps, ~mark. http://www.workzoo.com/ Art Fore wrote: > When I try to run the mysqld or safe_mysql, I get "connot connect to local > MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'. Check that > mysql is running and that the socket : '/var/lib/mysql/mysql.sock' exists! > > This file does not exist. Where does it come from or how do you create it? I > have done a search on the website, but no results. /etc/hosts file is also > correct. > > Art > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql.sock
That's because you get this: '020317 16:48:10 mysqld ended.' It means there was an error, and the database server is no longer running. Check your mysql log files to find out why. Does the user, 'mysql' have permissions to write into the directory mysql is using, normally /var/lib/mysql Who is the owner, and group for that directory? And what are the permissions? Do an 'ls -la /var/lib/' You should have something like: 'drwxrwxr-x 25 mysqlroot 3072 Mar 16 23:00 mysql' or even 'drwxrwxr-x 25 rootmysql 3072 Mar 16 23:00 mysql' -Original Message- From: Art Fore [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 6:04 PM To: [EMAIL PROTECTED] Subject: RE: mysql.sock Found the file there, guess I missed it or it got created after I looked before If I run ./safe_mysqld --user=mysql & I get Starting mysqld-max daemon with databases from /var/lib/mysql 020317 16:48:10 mysqld ended. I run mysqladmin u root -p piccolo 'new-password' Enter password: I then get connect to server at 'localhost failed If I run mysqld -ping, I get all kinds of info back. So guess I am completely lost. Art -Original Message- From: Mark Maunder [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 4:12 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: mysql.sock Art, Do you mean, whenever you try to run the 'mysql' client you get that error? That usually happens because you are trying to connect to the mysql server using the mysql client running on the same machine i.e. localhost. It's because the mysql client uses a socket file when connecting locally and the mysqld server is not storing the file in the default location where the client expects it. Fix it by putting this entry in the file /etc/my.cnf under the [client] section. socket = /tmp/mysql.sock or whatever the location of your socket file is. If you can't find it do a find / -name "mysql.sock" Hope that helps, ~mark. http://www.workzoo.com/ Art Fore wrote: > When I try to run the mysqld or safe_mysql, I get "connot connect to local > MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'. Check that > mysql is running and that the socket : '/var/lib/mysql/mysql.sock' exists! > > This file does not exist. Where does it come from or how do you create it? I > have done a search on the website, but no results. /etc/hosts file is also > correct. > > Art > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql.sock
Found the file there, guess I missed it or it got created after I looked before If I run ./safe_mysqld --user=mysql & I get Starting mysqld-max daemon with databases from /var/lib/mysql 020317 16:48:10 mysqld ended. I run mysqladmin u root -p piccolo 'new-password' Enter password: I then get connect to server at 'localhost failed If I run mysqld -ping, I get all kinds of info back. So guess I am completely lost. Art -Original Message- From: Mark Maunder [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 4:12 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: mysql.sock Art, Do you mean, whenever you try to run the 'mysql' client you get that error? That usually happens because you are trying to connect to the mysql server using the mysql client running on the same machine i.e. localhost. It's because the mysql client uses a socket file when connecting locally and the mysqld server is not storing the file in the default location where the client expects it. Fix it by putting this entry in the file /etc/my.cnf under the [client] section. socket = /tmp/mysql.sock or whatever the location of your socket file is. If you can't find it do a find / -name "mysql.sock" Hope that helps, ~mark. http://www.workzoo.com/ Art Fore wrote: > When I try to run the mysqld or safe_mysql, I get "connot connect to local > MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'. Check that > mysql is running and that the socket : '/var/lib/mysql/mysql.sock' exists! > > This file does not exist. Where does it come from or how do you create it? I > have done a search on the website, but no results. /etc/hosts file is also > correct. > > Art > > - > 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
Updating a column from a second table
How can I update the values of a column in one table from the values in a second table where there is are matching columns in the two tables using mysql. Table1 has columns DonorID and DonorPhone. Table2 has columns PersonID and PersonPhone. I want to sent Table1.DonorID = Table2.PersonID where Table2.PersonPhone = Table1.DonorPhone. Does UPDATE do this? Eldon Ziegler ProAtion Systems, Inc. [EMAIL PROTECTED] http://www.proation.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
MySQL 4.0.0-alpha "lock tables" fails for non-root users
>Description: Locking tables seems to be broken for non-root mysql users, giving the following error: ERROR 1142: select command denied to user: 'foo@localhost' for table 'bog' Works fine for root. This is using the standard Linux mysql-4.0.1 alpha RPMs. >How-To-Repeat: $ mysql -u foo test mysql> create table bog (x char(1)); Query OK, 0 rows affected (0.08 sec) mysql> lock tables bog write; ERROR 1142: select command denied to user: 'foo@localhost' for table 'bog' mysql> lock tables bog read; ERROR 1142: select command denied to user: 'foo@localhost' for table 'bog' mysql> drop table bog; Query OK, 0 rows affected (0.15 sec) >Fix: Unknown. >Submitter-Id: >Originator:Gavin Carr >Organization: Open Fusion Pty Ltd (Australia) >MySQL support: None >Synopsis: MySQL 4.0.1-alpha "lock tables" fails for non-root users >Severity: >Priority: low >Category: mysql >Class: sw-bug >Release: mysql-4.0.0-alpha (Official MySQL RPM) >Environment: System: Linux calix.syd.ot 2.4.3-20mdk #1 Sun Apr 15 23:03:10 CEST 2001 i686 unknown Architecture: i686 Some paths: /opt/perl5.6/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux/2.96/specs gcc version 2.96 2731 (Linux-Mandrake 8.0 2.96-0.48mdk) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Apr 29 2001 /lib/libc.so.6 -> libc-2.2.2.so -rwxr-xr-x1 root root 1222404 May 3 2001 /lib/libc-2.2.2.so -rw-r--r--1 root root 26499142 May 3 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 May 3 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --with-innodb --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 --with-embedded-server '--with-comment=Official MySQL RPM' - 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.sock
Art, Do you mean, whenever you try to run the 'mysql' client you get that error? That usually happens because you are trying to connect to the mysql server using the mysql client running on the same machine i.e. localhost. It's because the mysql client uses a socket file when connecting locally and the mysqld server is not storing the file in the default location where the client expects it. Fix it by putting this entry in the file /etc/my.cnf under the [client] section. socket = /tmp/mysql.sock or whatever the location of your socket file is. If you can't find it do a find / -name "mysql.sock" Hope that helps, ~mark. http://www.workzoo.com/ Art Fore wrote: > When I try to run the mysqld or safe_mysql, I get "connot connect to local > MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'. Check that > mysql is running and that the socket : '/var/lib/mysql/mysql.sock' exists! > > This file does not exist. Where does it come from or how do you create it? I > have done a search on the website, but no results. /etc/hosts file is also > correct. > > Art > > - > 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
mysql.sock
When I try to run the mysqld or safe_mysql, I get "connot connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'. Check that mysql is running and that the socket : '/var/lib/mysql/mysql.sock' exists! This file does not exist. Where does it come from or how do you create it? I have done a search on the website, but no results. /etc/hosts file is also correct. Art - 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 not run multiple command scripts
Be sure to separate your command with semi-colon(;) Besides...i havent seen here your script...just try and add it... R.B.Roa Traffic Management Engineer PhilCom Corporation Tel.No. (088) 858-1028 Mobile No. (0919) 30856267 -Original Message- From: Steven Gearhart [SMTP:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 1:39 PM To: [EMAIL PROTECTED] Subject:Can not run multiple command scripts As usual, I am a newbie to MySQL. I have been studying the user manual and Paul DuBois' book, MySQL. I have tried to run the scripts for "menagerie" and "samp_db" on both a Windows 2000 machine and a Linux machine, both local and remote with version 3.23.49a. I have used the command line and several GUI interfaces with the same result. I am able to run a single command, however, if I try and run a script with two or more commands, I receive an error number 1064 - syntax error. This usually shows the error at line 1. What am I doing wrong? I am about to give up. /*/ Steven Gearhart Gearhart, Inc. Phone/Fax: 770.466.2898 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: white background
> -Original Message- > From: denonymous [mailto:[EMAIL PROTECTED]] > Sent: Sunday, March 17, 2002 10:40 AM > To: [EMAIL PROTECTED] > Subject: Re: white background > > From: "Andreas Dau" <[EMAIL PROTECTED]> > > > Well, it's not really a mysql topic, but it's a bit connected to it. I > > have a website that uses frames. My php script retrieves data from a > > mysql database and displays it. My problem now is: each time that > > specific page loads it first displays a white background, retrieves the > > data and then displays it. It's just a cosmetic issue but I'd like to > > avoid that ;-) > > Honestly, now -- what could possibly make you think that a MySQL list > could > solve this? This seems, at the most broad level, an HTML problem and, most > likely, a browser problem. This has nothing to do with MySQL, chap. > > Well, it's not really a mysql topic, but it's a bit connected to it. I You can read? Btw, I already got a much helping and appreciated answer from the list. > > > > P.S. Oh, and... disallowing html mails? Huh? We're in stoneage? > > HTML mail is unnecessary and, for many, complete gibberish. It's not even > close to an argument that should be approached in this forum but, if you'd > really like, you can mail me for some info relating to the issue. No thanks, you already sufficently discovered your skills to me. Furthermore, why should I discuss anything with someone who I learned to know first bitching then thinking? > > > > -- > denonymous > www.coldcircuit.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 - 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
Solution for server error 1061 and 1067
Found a solution by searching google 'mysql-nt 1067' ... don't ask me why it is working ... => deleted the my.ini in c:\winnt (or where ever) and the server will start up! Strange, isn't it? So long A:lex >-Ursprüngliche Nachricht- >Von: Alexander Hampel [mailto:[EMAIL PROTECTED]] >Gesendet: Sonntag, 17. März 2002 17:57 >An: [EMAIL PROTECTED] >Betreff: Re: problem running the mysql server! > > >Hi Aleksander, > >Seems to be a problem to get MySQL started. >=> but no one of the advanced users/admins in this newsgroup > is interested in helping other users out :-( > >Can't help you with your problem but probably will find it out together. > >Did you get error messages like mine too? >Include here my problem here again (Win2000, MySQL 3.23.49): > >> >>Von: Alexander Hampel [mailto:[EMAIL PROTECTED]] >>Gesendet: Sonntag, 17. März 2002 10:11 >>An: [EMAIL PROTECTED] >>Betreff: New to MySQL - can't start server :-( >> >> >>Hi mailing list, >> >>I can't start mysqld-nt as I get the eror message 1067. If I start >>winmysqladmin.exe there is no server visible. >> >>The manual tell me in part 2.4 Post-installation Setup and Testing that I >>should start the script ./scripts/mysql_install_db but this script is not >>availabale (at all) at my Windows distribution. >> >>Any ideas what's wrong? >> > >Do you know if there exists a document where error messages are listed? > >I installed 4.0.1-alpha-win and I could start the server - >strange, isn't it? >Try this version too - probably it helps :-) > >So long A:lex > > > > >>-Ursprüngliche Nachricht- >>Von: Aleksander Gziut [mailto:[EMAIL PROTECTED]] >>Gesendet: Sonntag, 17. März 2002 18:24 >>An: [EMAIL PROTECTED] >>Betreff: problem running the mysql server! >> >> >> >>i installed mysql-3.23.36 (*.rpm) on my redhat linux 7.1 (kernel >2.4.2-2 on >>an >>i686) and ran "mysql_install_db" script. then i tried to start the server: >> >>[root@localhost]# safe_mysqld & <<>> >>[1] 1360 >>[root@localhost]# Starting mysqld daemon with databases from >/var/lib/mysql >> >>020317 hh:mm:ss mysqld ended >> >>one question - what's that? why i can't run the server? can anybody help >>me? >> >>- >>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: sql help examining log table
Ditch the Limit 50 in those queries I wrote, they won't work, they only limit the result set, not the searched set. I don't know what I was thinking. If you need to searched set to be limited by the last 50 of the user, I cannot think of anything at this time, perhaps after a few more cups of coffee:) -Original Message- From: Dan Vande More [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 1:44 PM To: [EMAIL PROTECTED] Subject: RE: sql help examining log table I might be wrong, but this may get you going in the right direction: select count(subject) as count, subject from outgoing where auth='USER' group by subject order by timestamp desc limit 50 This would tell you each subject ever sent by the user, and how many times that subject has been sent. Such as: +---+--+ | count | subject | +---+--+ | 12| Subject 1| | 36| Subject 2| | 2| Another subject | +---+--+ And you can narrow it down if you know the subject such as: select count(subject) as count, subject from outgoing where auth='USER' and subject = 'Subject 2' group by subject order by timestamp desc limit 50 This would return +---+--+ | count | subject | +---+--+ | 36| Subject 2| +---+--+ I think this is right, if not hopefully my logic is. Regardless, hopefully something can be useful. Dan -Original Message- From: Viraj Alankar [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 1:35 PM To: [EMAIL PROTECTED] Subject: sql help examining log table Hello, We use mysql to store outgoing email headers from our users and do throttling on users that appear to be spamming based on some simple queries to this table. We use the Communigate mail server and this throttling script is a PERL program implemented as a content filter. More information is here for those interested: http://www.cse.fau.edu/~valankar/ I am trying to figure out what is the best way to do a certain query. My outgoing log table looks like this: mysql> desc outgoing; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | rpath | varchar(80) | YES | | NULL| | | auth | varchar(80) | | MUL | | | | ip| varchar(80) | YES | | NULL| | | hfrom | varchar(80) | YES | | NULL| | | hto | varchar(80) | YES | | NULL| | | subject | varchar(80) | YES | | NULL| | | messageid | varchar(80) | YES | | NULL| | | timestamp | timestamp(14)| YES | | NULL| | | rcpts | smallint(5) unsigned | YES | | 0 | | +---+--+--+-+-+---+ What I would like to do is reject a message if the last 50 messages have the same subject. In other words, I want to look at the 50 latest entries in this table for a certain user (identified by the auth field) to find out if all of these messages have the same subject. The only way I can think of doing this is basically: select subject from outgoing where auth='USER' order by timestamp desc limit 50 And then going through each one of these rows in my program to see if they are all the same subject. Is there a way I can do this logic in the select query instead? Thanks, Viraj. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Delete User problem.
On Sun, 17 Mar 2002, Dan Vande More wrote: > You would have a hard time removing the privileges using GRANT, I would > suggest using revoke: > http://www.mysql.com/doc/G/R/GRANT.html Will it delete user from table mysql.user ? > > > > > > > But How should I use Grant command to delete user from MySQL? > > > > > -- Pozdrawiam, Marcin Pyla (o_ [ <@ Marcin Pyla - Cubbi <[EMAIL PROTECTED]> | <<+ NetArt ISP +>> @> ] (/)_ [ Każdy programista powie Ci, że lepiej napisać nowy program ] [ niż poprawiać cudzy.] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: sql help examining log table
I might be wrong, but this may get you going in the right direction: select count(subject) as count, subject from outgoing where auth='USER' group by subject order by timestamp desc limit 50 This would tell you each subject ever sent by the user, and how many times that subject has been sent. Such as: +---+--+ | count | subject | +---+--+ | 12| Subject 1| | 36| Subject 2| | 2| Another subject | +---+--+ And you can narrow it down if you know the subject such as: select count(subject) as count, subject from outgoing where auth='USER' and subject = 'Subject 2' group by subject order by timestamp desc limit 50 This would return +---+--+ | count | subject | +---+--+ | 36| Subject 2| +---+--+ I think this is right, if not hopefully my logic is. Regardless, hopefully something can be useful. Dan -Original Message- From: Viraj Alankar [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 1:35 PM To: [EMAIL PROTECTED] Subject: sql help examining log table Hello, We use mysql to store outgoing email headers from our users and do throttling on users that appear to be spamming based on some simple queries to this table. We use the Communigate mail server and this throttling script is a PERL program implemented as a content filter. More information is here for those interested: http://www.cse.fau.edu/~valankar/ I am trying to figure out what is the best way to do a certain query. My outgoing log table looks like this: mysql> desc outgoing; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | rpath | varchar(80) | YES | | NULL| | | auth | varchar(80) | | MUL | | | | ip| varchar(80) | YES | | NULL| | | hfrom | varchar(80) | YES | | NULL| | | hto | varchar(80) | YES | | NULL| | | subject | varchar(80) | YES | | NULL| | | messageid | varchar(80) | YES | | NULL| | | timestamp | timestamp(14)| YES | | NULL| | | rcpts | smallint(5) unsigned | YES | | 0 | | +---+--+--+-+-+---+ What I would like to do is reject a message if the last 50 messages have the same subject. In other words, I want to look at the 50 latest entries in this table for a certain user (identified by the auth field) to find out if all of these messages have the same subject. The only way I can think of doing this is basically: select subject from outgoing where auth='USER' order by timestamp desc limit 50 And then going through each one of these rows in my program to see if they are all the same subject. Is there a way I can do this logic in the select query instead? Thanks, Viraj. - 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
sql help examining log table
Hello, We use mysql to store outgoing email headers from our users and do throttling on users that appear to be spamming based on some simple queries to this table. We use the Communigate mail server and this throttling script is a PERL program implemented as a content filter. More information is here for those interested: http://www.cse.fau.edu/~valankar/ I am trying to figure out what is the best way to do a certain query. My outgoing log table looks like this: mysql> desc outgoing; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | rpath | varchar(80) | YES | | NULL| | | auth | varchar(80) | | MUL | | | | ip| varchar(80) | YES | | NULL| | | hfrom | varchar(80) | YES | | NULL| | | hto | varchar(80) | YES | | NULL| | | subject | varchar(80) | YES | | NULL| | | messageid | varchar(80) | YES | | NULL| | | timestamp | timestamp(14)| YES | | NULL| | | rcpts | smallint(5) unsigned | YES | | 0 | | +---+--+--+-+-+---+ What I would like to do is reject a message if the last 50 messages have the same subject. In other words, I want to look at the 50 latest entries in this table for a certain user (identified by the auth field) to find out if all of these messages have the same subject. The only way I can think of doing this is basically: select subject from outgoing where auth='USER' order by timestamp desc limit 50 And then going through each one of these rows in my program to see if they are all the same subject. Is there a way I can do this logic in the select query instead? Thanks, Viraj. - 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] Invalid Argument ??? Not sure how to debug this
On Sun, 17 Mar 2002, Daniel Negron/KBE wrote:
> $sql= "SELECT * FROM cd_list WHERE $searchstring LIKE '%searchstring%'
> ORDER BY artist ASC";
How about:
SELECT * FROM cd_list WHERE searchstring LIKE '%{$searchstring}%'
Then again, do you actually have a column called "searchstring" in your
table?
In any case, the way you had it didn't seem to make much sense unless you
wanted to search a user-supplied column for a string that literally
contained the string "searchstring".
miguel
-
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: IS THIS BETTER?
> -Original Message- > From: denonymous [mailto:[EMAIL PROTECTED]] > Sent: Sunday, 17 March 2002 8:2 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: IS THIS BETTER? > > From: "Todd Williamsen" <[EMAIL PROTECTED]> > > > Try turning the CAPs off first... Makes it easier to read... > > I second that motion. :) I'll third it! > > > > Second... > > > > You are using ADOB to connect to mySQL? Is that what you are doing? > > Using ASP? Try using PHP, easier to learn and is much more compatible > > with mySQL. ASP/mySQL can be used, but it's a pain, plus ASP has its > > limitation that is more limiting than PHP. I use to use ASP, but it > > sucks and a pain in the ass to configure and just to connect the > > database. Yes, Access has its limitations. You can use it, but your > > load would need to be light. Mysql is a very lightweight DB and barely > > uses any ram to run it. It is very, very fast (with PHP), and I prefer > > it over MS SQL server and Oracle, both which I have experience in. > > Further to that... > > If you end up going with PHP over ASP, you're two thirds of the way there. > Leave IIS behind and try out Apache (www.apache.org/httpd). It's also > free, > fast, and reliable. From what I can tell, you're running the servers on a > Win32 or NT box; I've run the Apache/PHP/MySQL combination on both > platforms > before, and just as stable as the IIS combo could be. If you configure it well, even more so :) And it wont make your server unusable under relatively small loads. > > I don't have a lot of experience with IIS, but what I do know is that > getting MySQL up and running on a Windows box was the hardest part (of > Apache, PHP, and MySQL). If you've already got that, Apache really > shouldn't > be too hard. The documentation for Apache is pretty good, too, even on > Windows platforms. > > (never thought I'd be one of those guys that sits on lists and plugs open > source, but hey -- the times are a-changin'!) > I too highly recommend using PHP/Apache/MySQL it is a proven solution known to work incredibly well (even under very high loads of huge sites :D) Should you wish to continue using IIS/ASP, then I highly recommend that you get the MyODBC drivers from mysql and use those directly from ASP (don't know whether FrontPage does that for you, but it can be done, I do it regularly) :) I must forewarn you that unless you are using Win2K Server or better (or should I say more expensive), your IIS is crippled (by Microsoft) to support only 10 connections, or pay up (>$800)! If these suggestions make you uncomfortable, better stick to a Web Hosting company :\. Stephano Mariani - 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: system error 1067 - can't start mysqld
Hello, This is a classical problem ... when you install mysql into an other path than c:/mysql/ , you remove it and reinstall into an other directory. At first you must verify the my.ini file into c:/winnt/ . If mysql has been installed into an other directory than c:/mysql/ you can verify basedir and datadir paths in c:/winnt/my.ini file. If mysql is installed in c:/mysql/ , c:/winnt/my.ini must be deleted. After that, in a command schell type: cd "your mysql directory" cd bin mysqld-nt --remove mysqld-nt --install NET START mysql" and now everything should be OK. Bye,Jerome Alexander Hampel wrote: >Hi mailing list, > >I can't start mysqld-nt as I get the eror message 1067. If I start >winmysqladmin.exe there is no server visible. > >The manual tell me in part 2.4 Post-installation Setup and Testing that I >should start the script ./scripts/mysql_install_db but this script is not >availabale (at all) at my Windows distribution. > >Any ideas what's wrong? > >Thank you, > A:lex > > > > > > >- >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: IS THIS BETTER?
From: "Todd Williamsen" <[EMAIL PROTECTED]> > Try turning the CAPs off first... Makes it easier to read... I second that motion. :) > Second... > > You are using ADOB to connect to mySQL? Is that what you are doing? > Using ASP? Try using PHP, easier to learn and is much more compatible > with mySQL. ASP/mySQL can be used, but it's a pain, plus ASP has its > limitation that is more limiting than PHP. I use to use ASP, but it > sucks and a pain in the ass to configure and just to connect the > database. Yes, Access has its limitations. You can use it, but your > load would need to be light. Mysql is a very lightweight DB and barely > uses any ram to run it. It is very, very fast (with PHP), and I prefer > it over MS SQL server and Oracle, both which I have experience in. Further to that... If you end up going with PHP over ASP, you're two thirds of the way there. Leave IIS behind and try out Apache (www.apache.org/httpd). It's also free, fast, and reliable. From what I can tell, you're running the servers on a Win32 or NT box; I've run the Apache/PHP/MySQL combination on both platforms before, and just as stable as the IIS combo could be. I don't have a lot of experience with IIS, but what I do know is that getting MySQL up and running on a Windows box was the hardest part (of Apache, PHP, and MySQL). If you've already got that, Apache really shouldn't be too hard. The documentation for Apache is pretty good, too, even on Windows platforms. (never thought I'd be one of those guys that sits on lists and plugs open source, but hey -- the times are a-changin'!) -- denonymous www.coldcircuit.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
FW: IS THIS BETTER?
Is there a way to spam control caps? Like if 75% or more of the content is Capitalized, them ditch it rather then having to delete it manually? Sql , query -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 12:19 PM To: [EMAIL PROTECTED] Subject: IS THIS BETTER? - 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 to unsubsribe from the mysql list?
Dear Wheeler, I forgot the authorization code o mysql list. I need it to usubscribe. How can I do? Thank so much! Li Bing - Original Message - From: "Alfred Wheeler" <[EMAIL PROTECTED]> To: "Li Bing" <[EMAIL PROTECTED]> Sent: Sunday, March 17, 2002 9:08 AM Subject: Re: How to unsubsribe from the mysql list? > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Original Message - > From: "Li Bing" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, March 17, 2002 2:51 AM > Subject: How to unsubsribe from the mysql list? > > > Hi all, > > Could you please tell me how to unsubsribe from the mysql list? > > Thanks, > Li Bing > _.--"""--._ > .' '-. `. >__/__(-. `\ \ > /o `o \ \\ \ > _\__.__/ ))|| ; > .--;" || \ >(`) || \ > _|`---' .' _, _||`\ > '`_\ \ '_,.-';_.-`\| \ \_ > .' '--'---;` / / |\ |_..--' \ >\'-'.' .--'.__/__.-; > `"` (___...---''` \ > _/_\ > /ASU\ [EMAIL PROTECTED] > \___/ 480-965-9038(L), 602-743-9767(C) > http://www.public.asu.edu/~libing > > - 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: IS THIS BETTER?
Try turning the CAPs off first... Makes it easier to read... Second... You are using ADOB to connect to mySQL? Is that what you are doing? Using ASP? Try using PHP, easier to learn and is much more compatible with mySQL. ASP/mySQL can be used, but its a pain, plus ASP has its limitation that is more limiting than PHP. I use to use ASP, but it sucks and a pain in the ass to configure and just to connect the database. Yes, Access has its limitations. You can use it, but your load would need to be light. Mysql is a very lightweight DB and barely uses any ram to run it. It is very, very fast (with PHP), and I prefer it over MS SQL server and Oracle, both which I have experience in. Does that help at all? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 1:19 PM To: [EMAIL PROTECTED] Subject: IS THIS BETTER? ORIGINAL SUBJECT:HELLO (PLEASE READ THE ENTIRE EMAIL BEFORE DECIDING TO CHUCK IT, I DO GET TO MY QUESTION) GOOD AFTERNOON I THOUGHT I'D TRY MY LUCK AND ASK YOU A QUESTION, IF YOU CAN'T (OR WON'T) HELP MY I UNDERSTAND. I HAVE BEEN VISITING YOU SITE A LOT LATELY BECAUSE I HAD A PROBLEM THAT I THOUGHT I WAS ON THE VERGE OF SOLVING. (BACK STORY)---> I AM BUILDING A WEBSITE, AND I WANTED TO SPEND THE LEAST AMOUNT OF MONEY ON GETTING IT ON THE GOOD OL' WWW. SO SINCE I HAVE A FEW COMPUTERS I'D THOUGHT I COULD RUN IT MYSELF WITHOUT THE HELP OF ONE OF THOSE "WEB HOSTING" SERVICES. SO I STARTED WITH IIS WHICH HAS GOTTEN MY BASIC SITE UP, THEN I GOT TO KNOW A LITTLE ABOUT ASP (NOT REALLY I'VE BEEN USING FRONTPAGE THEY DO ALL THE WORK FOR YOU) AND I AM PRETTY GOOD WITH ACCESS SO I FIGURED IT WAS JUST A MATTER OF PUTTING THEM ALL TOGETHER. WELL.I COULDN'T GET THE FORM TO CONNECT TO ACCESS(THEY WERE BUT THEY COULDN'T HANDLE THE LOAD) SO I WAS LOOKING INTO MS SQL SERVERS(WAY TO EXPENSIVE!!!) SO THEN I FOUND MYSQL(IT'S FREE!!!). GOT THE HANG OF IT A LITTLE AND CONVERTED MY ACCESS TABLES TO MY SQL'S. I FOUND YOUR WEBSITE, AND LEARNED HOW TO LINK BETWEEN ACCESS AND MYSQL SO I COULD USE ACCESS'S INTERFACE TO MAINTAIN THE FORMS AND QUERY'S FROM MY END(INSTEAD OF WITH THAT DOS INTERFACE), AND FRONTPAGE SEEMED TO ACKNOWLEDGE MY MYSQL DATABASE WHICH GAVE ME A MORE STABLE DATA ENGINE SOLUTION(OR SO I THOUGHT) I THOUGHT I WAS THERE UNTIL I TEST SUBMITTED SOME ASP FORMS,BUT THEN I GOT A TOTALLY NEW ERROR MESSAGE: -> "Cannot add new record set to the database Error Description: Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. Error Number: 3251 Error Source: ADODB.Recordset NOW I HAVE HAD NO FORMAL TRAINING IN ANY OF THE FORE MENTIONED PROGRAMS, BUT I PICK THIS STUFF UP PRETTY GOOD (I THINK), AND I WAS WONDERING IF THERE'S JUST SOMETHING I'M LEAVING OUT OR ADDING WHEN I SHOULDN'T?? WHAT I'M I DOING WRONG!!! PLEASE HELP SINCERELY, > Your message cannot be postsed to mysql@ because it > contained an attachment. If you need to make a file publically available > you should upload it to some public URL, and then paste the URL into your > message instead of trying to send it to everyone on the list. > > Disallowing attachments protects our list from being used to > spread a virus. If you do not remember sending a message to the this list, > it is possible that your computer has been infected by a virus which tried > to spread itself using our list. It is also possible that some spammer used > your e-mail address to hide his identity. > > Some mail clients default to sending messages in HTML or multipart format. > In this case, your message will also appear as if it has an attachment. Such > message formats increase the volume of traffic, and cause readability problems > in some mail programs without providing any extra value. Such formats are > also frequently used by spammers. For these reasons we disallow such messages. > You should disable them in your mail program to be able to post. > > Your mail program was identified as 'Microsoft Outlook'. If this is correct, > you should do the following to > configure it to be able to post to our list: > > Tools->Options->Mail Format, set 'Send message in this format' to 'Plain Text' > > Please note that we may have misidentified your e-mail program, in which case > our instructions would not apply. It is also possible that we are not aware > of a version of that has a slighly different set of menus. If > our instructions are not helpful, please consult your e-mail program's manual > on how to send messages in plain text. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.my
IS THIS BETTER?
ORIGINAL SUBJECT:HELLO (PLEASE READ THE ENTIRE EMAIL BEFORE DECIDING TO CHUCK IT, I DO GET TO MY QUESTION) GOOD AFTERNOON I THOUGHT I'D TRY MY LUCK AND ASK YOU A QUESTION, IF YOU CAN'T (OR WON'T) HELP MY I UNDERSTAND. I HAVE BEEN VISITING YOU SITE A LOT LATELY BECAUSE I HAD A PROBLEM THAT I THOUGHT I WAS ON THE VERGE OF SOLVING. (BACK STORY)---> I AM BUILDING A WEBSITE, AND I WANTED TO SPEND THE LEAST AMOUNT OF MONEY ON GETTING IT ON THE GOOD OL' WWW. SO SINCE I HAVE A FEW COMPUTERS I'D THOUGHT I COULD RUN IT MYSELF WITHOUT THE HELP OF ONE OF THOSE "WEB HOSTING" SERVICES. SO I STARTED WITH IIS WHICH HAS GOTTEN MY BASIC SITE UP, THEN I GOT TO KNOW A LITTLE ABOUT ASP (NOT REALLY I'VE BEEN USING FRONTPAGE THEY DO ALL THE WORK FOR YOU) AND I AM PRETTY GOOD WITH ACCESS SO I FIGURED IT WAS JUST A MATTER OF PUTTING THEM ALL TOGETHER. WELL.I COULDN'T GET THE FORM TO CONNECT TO ACCESS(THEY WERE BUT THEY COULDN'T HANDLE THE LOAD) SO I WAS LOOKING INTO MS SQL SERVERS(WAY TO EXPENSIVE!!!) SO THEN I FOUND MYSQL(IT'S FREE!!!). GOT THE HANG OF IT A LITTLE AND CONVERTED MY ACCESS TABLES TO MY SQL'S. I FOUND YOUR WEBSITE, AND LEARNED HOW TO LINK BETWEEN ACCESS AND MYSQL SO I COULD USE ACCESS'S INTERFACE TO MAINTAIN THE FORMS AND QUERY'S FROM MY END(INSTEAD OF WITH THAT DOS INTERFACE), AND FRONTPAGE SEEMED TO ACKNOWLEDGE MY MYSQL DATABASE WHICH GAVE ME A MORE STABLE DATA ENGINE SOLUTION(OR SO I THOUGHT) I THOUGHT I WAS THERE UNTIL I TEST SUBMITTED SOME ASP FORMS,BUT THEN I GOT A TOTALLY NEW ERROR MESSAGE: -> "Cannot add new record set to the database Error Description: Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. Error Number: 3251 Error Source: ADODB.Recordset NOW I HAVE HAD NO FORMAL TRAINING IN ANY OF THE FORE MENTIONED PROGRAMS, BUT I PICK THIS STUFF UP PRETTY GOOD (I THINK), AND I WAS WONDERING IF THERE'S JUST SOMETHING I'M LEAVING OUT OR ADDING WHEN I SHOULDN'T?? WHAT I'M I DOING WRONG!!! PLEASE HELP SINCERELY, > Your message cannot be postsed to mysql@ because it > contained an attachment. If you need to make a file publically available > you should upload it to some public URL, and then paste the URL into your > message instead of trying to send it to everyone on the list. > > Disallowing attachments protects our list from being used to > spread a virus. If you do not remember sending a message to the this list, > it is possible that your computer has been infected by a virus which tried > to spread itself using our list. It is also possible that some spammer used > your e-mail address to hide his identity. > > Some mail clients default to sending messages in HTML or multipart format. > In this case, your message will also appear as if it has an attachment. Such > message formats increase the volume of traffic, and cause readability problems > in some mail programs without providing any extra value. Such formats are > also frequently used by spammers. For these reasons we disallow such messages. > You should disable them in your mail program to be able to post. > > Your mail program was identified as 'Microsoft Outlook'. If this is correct, > you should do the following to > configure it to be able to post to our list: > > Tools->Options->Mail Format, set 'Send message in this format' to 'Plain Text' > > Please note that we may have misidentified your e-mail program, in which case > our instructions would not apply. It is also possible that we are not aware > of a version of that has a slighly different set of menus. If > our instructions are not helpful, please consult your e-mail program's manual > on how to send messages in plain text. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Delete User problem.
You would have a hard time removing the privileges using GRANT, I would suggest using revoke: http://www.mysql.com/doc/G/R/GRANT.html -Original Message- From: Marcin Pyla [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 11:28 AM To: [EMAIL PROTECTED] Subject: Re: Delete User problem. > > > So, you can see that I didn't delete him. Why? > > > What I am doing wrong? How can I delete this user? > > > > Why do you want to delete an user by "delete" command from the users table?! > > For setting or deleteting permissions use GRANT/REVOKE commands > > instead. > > > But How should I use Grant command to delete user from MySQL? -- Pozdrawiam, Marcin Pyla (o_ [ <@ Marcin Pyla - Cubbi <[EMAIL PROTECTED]> | <<+ NetArt ISP +>> @> ] (/)_ [ Nigdy nie ufaj systemowi operacyjnemu, do którego ] [ nie masz kodów źródłowych. ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problem with using INSERT INTO [table] SQL string
Hey Don,
I read the whitepaper and it have come to the conclusion that when MS used
the words mySQL, they were not referring to MySQL, which is the list you are
on. They were referring to mySQL as my SQL just the same as myconnection and
Myemptywallet.
You see, most of us come here to get away from MS Access and MSSQL. The SQL
Server we use, MySQL, is free, and free from every licensing scheme MS uses.
It is also fast, very close to oracle, and often times pushes MSSQL off the
bottom of the chart.
The MySQL database server (a competitor to Access and MSSQL) is used in
environments that demand something more powerful that anything Microsoft,
such as
Yahoo Finance: http://www.mysql.com/articles/us/yahoo_finance.html
Nasa: http://www.mysql.com/articles/us/nasa.html
AIS: http://www.mysql.com/articles/us/ais.html
Read more:
http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp
If you read that article you may get a better understating of what I am
trying to relay.
Thanks
Dan
-Original Message-
From: Donald Guy [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 17, 2002 9:55 AM
To: [EMAIL PROTECTED]
Subject: Problem with using INSERT INTO [table] SQL string
Hi all,
Please excuse any ignorance I may show with this question - as I am not a
programmer and I am trying to do something that is out of my experience. I
feel truly out of my element in this and am hoping that the list expertise
will help me. I have looked at the manual - but still am confused.
Basically, I am trying to set up forms using Microsoft FrontPage 2000 where
the results (form input) will be sent to a database (Microsoft Access 2000)
and to an email address. I am following instructions outlined in a
Microsoft white paper which has specifically been written to address this
topic (found at
http://download.microsoft.com/download/fp2000/whitep/1/NT5XP/EN-US/cdonts200
0.EXE)
My problem is that I can only get one form field value to be inserted into
my table. I think I have followed the instructions that the white paper
gives for building the mySQL string that is used to insert the form
information into the database - but I am having no success in getting all
the form information inserted into the databse.
--
The mySQL syntax given by the white paper is the following:
mySQL = "INSERT INTO [your_table_name] "
mySQL = mySQL & "([database_field_names]) "
mySQL = mySQL & "VALUES ('[form_field_names]')"
--
The example mySQL string in the white paper is:
mySQL= "INSERT INTO Employees "
mySQL= mySQL & "(FirstName,LastName,Address,City,Region,PostalCode) "
mySQL= mySQL & "VALUES ('" & Request.Form("FirstName") & "','"
mySQL= mySQL & Request.Form("LastName") & "'"
mySQL= mySQL & ",'" & Request.Form("Address") & "'"
mySQL= mySQL & ",'" & Request.Form("City") & "','"
mySQL= mySQL & Request.Form("Region") & "','"
mySQL= mySQL & Request.Form("PostalCode") & "')"
---
The white paper gives the following my SQL syntax to help with customizing
the SQL string:
INSERT INTO [table] ([DBfield1],[DBfield2]) VALUES
('[form_field1]','[form_field2]')
mySQL = "INSERT INTO [table] (DBfield) VALUES ('" &
Request.Form("form_field") & "')"
--
Background:
The Microsoft Access 2000 database table I want to insert information into
is named Action
The form field names or VALUES I am trying to insert information from (from
the FrontPage 2000 form) are:
RequestDate
CommerceID
LastName
FirstName
Email
DepartmentNumber
Sector
StreetAddress
City
State
ZipCode
LocationCode
MailDrop
TelephoneNumber
FaxNumber
RequestType
Library
Request
The Microsoft Access 2000 database table field names (to which I want to
insert information into) are:
RequestDate
CommerceID
Client
FirstName
Email
DepartmentNum
Sector
StreetAddress
City
State
ZipCode
LocCode
MailDrop
TelephoneNum
FaxNum
ServiceName
InternalGroup
Request
The form field values correspond to the table colums in the following way:
RequestDate (value from form) insert RequestDate (database field name)
CommerceID (value from form) insert into CommerceID (database field name)
LastName (value from form) insert into Client (database field name)
FirstName (value from form) insert into FirstName (database field name)
Email (value from form) insert into Email (database field name)
DepartmentNumber (value from form) insert into DepartmentNum (database field
name)
Sector (value from form) insert into Sector (database Field name)
StreetAddress (value from form) insert into StreetAddress (database field
name)
City (value from form) insert into City (database field name)
State (value from form) insert into State (database field name)
ZipCode
Two questions (combining UPDATE queries and free up locks)
I am hoping this reaches the right place, I was sure I had sent it but didn't see it come to list... I have two problems I am hoping to solve. 1) Is it possiblt to "combine" two update queries into one. So something like UPDATE table SET field=value WHERE field=value2 which makes up one statement can be combined to also have UPDATE table SET field2=value WHERE field2=value2 Currently I am using to UPDATE queries to do this but would like to cut it down if possible. 2) I have a table that seems to lock up at random. So in phpmyadmin it says "In Use". How can I remove this lock? I program in perl and PHP and would like to be able to free it up through one of these languages but am unsure of how to unlock it in mySQL alone. Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Delete User problem.
> > > So, you can see that I didn't delete him. Why? > > > What I am doing wrong? How can I delete this user? > > > > Why do you want to delete an user by "delete" command from the users table?! > > For setting or deleteting permissions use GRANT/REVOKE commands > > instead. > > > But How should I use Grant command to delete user from MySQL? -- Pozdrawiam, Marcin Pyla (o_ [ <@ Marcin Pyla - Cubbi <[EMAIL PROTECTED]> | <<+ NetArt ISP +>> @> ] (/)_ [ Nigdy nie ufaj systemowi operacyjnemu, do którego ] [ nie masz kodów źródłowych. ] - 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
AW: problem running the mysql server!
Wow some help ;-) Thank you Dan for your long explanatory mail :-) Somethimes it's really good to SHOUT LOUD - so some folks out there DO HEAR you. I installed MySQL yesterday night and all went wrong, so frustation is obvious. Good idea, try to find some solutions by searching google this way Thanks - A:lex >-Ursprüngliche Nachricht- >Von: Dan Vande More [mailto:[EMAIL PROTECTED]] >Gesendet: Sonntag, 17. März 2002 18:20 >An: [EMAIL PROTECTED] >Betreff: RE: problem running the mysql server! > > >A lot of us here use simple techniques for troubleshooting. For errors, I >first look in the log file for mysql. But almost always, I google it. >Google turned up A LOT of results for a 1067, with tons of fixes. >The query I used was "mysqld-nt 1067" >The first results it pulled were from mysql's site, from the manual. If you >dared to look farther down, you would see a medium quantity of people >complaining and wanting somebody to hold their hand. At least 3 or 4 fixes >were VERY well documented, a simple search for 2 words and 3 paragraphs of >reading could have solved your problem. >The 5th google result took me to phpbuilder where the fix was again, well >documented by a very nice guy. >We do try to help, but cannot help you when you're not willing to try >yourself. Ignorance has never helped anyone. >Remember, google indexes mysql, php, phpbuilder.net and TONS of >other sites, >even MS. I never use the MS KB tool to search anymore because it totallty >blows. Instead I use google, because it indexes MS. >Also keep in mind that the third tab of google contains google groups, a 20 >year archive of newsgroup posts, that contain every question you ever plan >on asking, and quite possibly answers. >If you ever get really bored, I suggest taking 5 minutes and skimming here: >http://www.google.com/googlegroups/archive_announce_20.html >It contains many many cool things, such as the first post about MS, Linus >Torvalds post introducing Linux. Some dude beating on Linux and defending >minix, and arguing with Linus Torvalds. >Post showing Jeff Bezos hiring programmers for amazon.com(before >amazon.com) >and lots of other great stuff. >Sorry this went OT, but perhaps we could point out to some people in this >list the tremendous amount of resources available to them. >PS I don't work for google, nor have anything to do with them, but I am >waiting for them to set up a donation thing, because they've saved >me a huge >amount of time and made me a lot of money. >Dan >Aleksander, what does your log file say? Does the mysqld have >permissions to >write to the directory it's creating the DB's in? > > > >-Original Message- >From: Alexander Hampel [mailto:[EMAIL PROTECTED]] >Sent: Sunday, March 17, 2002 9:57 AM >To: [EMAIL PROTECTED] >Subject: Re: problem running the mysql server! > >Hi Aleksander, > >Seems to be a problem to get MySQL started. >=> but no one of the advanced users/admins in this newsgroup > is interested in helping other users out :-( > >Can't help you with your problem but probably will find it out together. > >Did you get error messages like mine too? >Include here my problem here again (Win2000, MySQL 3.23.49): > >> >>Von: Alexander Hampel [mailto:[EMAIL PROTECTED]] >>Gesendet: Sonntag, 17. März 2002 10:11 >>An: [EMAIL PROTECTED] >>Betreff: New to MySQL - can't start server :-( >> >> >>Hi mailing list, >> >>I can't start mysqld-nt as I get the eror message 1067. If I start >>winmysqladmin.exe there is no server visible. >> >>The manual tell me in part 2.4 Post-installation Setup and Testing that I >>should start the script ./scripts/mysql_install_db but this script is not >>availabale (at all) at my Windows distribution. >> >>Any ideas what's wrong? >> > >Do you know if there exists a document where error messages are listed? > >I installed 4.0.1-alpha-win and I could start the server - strange, isn't >it? >Try this version too - probably it helps :-) > >So long A:lex > > > > >>-Ursprüngliche Nachricht- >>Von: Aleksander Gziut [mailto:[EMAIL PROTECTED]] >>Gesendet: Sonntag, 17. März 2002 18:24 >>An: [EMAIL PROTECTED] >>Betreff: problem running the mysql server! >> >> >> >>i installed mysql-3.23.36 (*.rpm) on my redhat linux 7.1 (kernel >2.4.2-2 on >>an >>i686) and ran "mysql_install_db" script. then i tried to start the server: >> >>[root@localhost]# safe_mysqld & <<>> >>[1] 1360 >>[root@localhost]# Starting mysqld daemon with databases from >/var/lib/mysql >> >>020317 hh:mm:ss mysqld ended >> >>one question - what's that? why i can't run the server? can anybody help >>me? >> >>- >>Before posting, please check: >> http://www.mysql.com/manual.php (the manual) >> http://lists.mysql.com/ (the list archive) >> >>To request this thread, e-mail <[EMAIL PROTECTED]> >>To unsubscribe, e-mail >><[EMAIL PROTECTED]> >>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> > > >
FW: problem running the mysql server
-Original Message- From: Dan Vande More Sent: Sunday, March 17, 2002 10:20 AM To: [EMAIL PROTECTED] Subject: RE: problem running the mysql server! A lot of us here use simple techniques for troubleshooting. For errors, I first look in the log file for mysql. But almost always, I google it. Google turned up A LOT of results for a 1067, with tons of fixes. The query I used was "mysqld-nt 1067" The first results it pulled were from mysql's site, from the manual. If you dared to look farther down, you would see a medium quantity of people complaining and wanting somebody to hold their hand. At least 3 or 4 fixes were VERY well documented, a simple search for 2 words and 3 paragraphs of reading could have solved your problem. The 5th google result took me to phpbuilder where the fix was again, well documented by a very nice guy. We do try to help, but cannot help you when you're not willing to try yourself. Ignorance has never helped anyone. Remember, google indexes mysql, php, phpbuilder.net and TONS of other sites, even MS. I never use the MS KB tool to search anymore because it totallty blows. Instead I use google, because it indexes MS. Also keep in mind that the third tab of google contains google groups, a 20 year archive of newsgroup posts, that contain every question you ever plan on asking, and quite possibly answers. If you ever get really bored, I suggest taking 5 minutes and skimming here: http://www.google.com/googlegroups/archive_announce_20.html It contains many many cool things, such as the first post about MS, Linus Torvalds post introducing Linux. Some dude beating on Linux and defending minix, and arguing with Linus Torvalds. Post showing Jeff Bezos hiring programmers for amazon.com(before amazon.com) and lots of other great stuff. Sorry this went OT, but perhaps we could point out to some people in this list the tremendous amount of resources available to them. PS I don't work for google, nor have anything to do with them, but I am waiting for them to set up a donation thing, because they've saved me a huge amount of time and made me a lot of money. Dan Aleksander, what does your log file say? Does the mysqld have permissions to write to the directory it's creating the DB's in? -Original Message- From: Alexander Hampel [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 9:57 AM To: [EMAIL PROTECTED] Subject: Re: problem running the mysql server! Hi Aleksander, Seems to be a problem to get MySQL started. => but no one of the advanced users/admins in this newsgroup is interested in helping other users out :-( Can't help you with your problem but probably will find it out together. Did you get error messages like mine too? Include here my problem here again (Win2000, MySQL 3.23.49): > >Von: Alexander Hampel [mailto:[EMAIL PROTECTED]] >Gesendet: Sonntag, 17. März 2002 10:11 >An: [EMAIL PROTECTED] >Betreff: New to MySQL - can't start server :-( > > >Hi mailing list, > >I can't start mysqld-nt as I get the eror message 1067. If I start >winmysqladmin.exe there is no server visible. > >The manual tell me in part 2.4 Post-installation Setup and Testing that I >should start the script ./scripts/mysql_install_db but this script is not >availabale (at all) at my Windows distribution. > >Any ideas what's wrong? > Do you know if there exists a document where error messages are listed? I installed 4.0.1-alpha-win and I could start the server - strange, isn't it? Try this version too - probably it helps :-) So long A:lex >-Ursprüngliche Nachricht- >Von: Aleksander Gziut [mailto:[EMAIL PROTECTED]] >Gesendet: Sonntag, 17. März 2002 18:24 >An: [EMAIL PROTECTED] >Betreff: problem running the mysql server! > > > >i installed mysql-3.23.36 (*.rpm) on my redhat linux 7.1 (kernel 2.4.2-2 on >an >i686) and ran "mysql_install_db" script. then i tried to start the server: > >[root@localhost]# safe_mysqld & <<>> >[1] 1360 >[root@localhost]# Starting mysqld daemon with databases from /var/lib/mysql > >020317 hh:mm:ss mysqld ended > >one question - what's that? why i can't run the server? can anybody help >me? > >- >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: h
RE: problem running the mysql server!
A lot of us here use simple techniques for troubleshooting. For errors, I first look in the log file for mysql. But almost always, I google it. Google turned up A LOT of results for a 1067, with tons of fixes. The query I used was "mysqld-nt 1067" The first results it pulled were from mysql's site, from the manual. If you dared to look farther down, you would see a medium quantity of people complaining and wanting somebody to hold their hand. At least 3 or 4 fixes were VERY well documented, a simple search for 2 words and 3 paragraphs of reading could have solved your problem. The 5th google result took me to phpbuilder where the fix was again, well documented by a very nice guy. We do try to help, but cannot help you when you're not willing to try yourself. Ignorance has never helped anyone. Remember, google indexes mysql, php, phpbuilder.net and TONS of other sites, even MS. I never use the MS KB tool to search anymore because it totallty blows. Instead I use google, because it indexes MS. Also keep in mind that the third tab of google contains google groups, a 20 year archive of newsgroup posts, that contain every question you ever plan on asking, and quite possibly answers. If you ever get really bored, I suggest taking 5 minutes and skimming here: http://www.google.com/googlegroups/archive_announce_20.html It contains many many cool things, such as the first post about MS, Linus Torvalds post introducing Linux. Some dude beating on Linux and defending minix, and arguing with Linus Torvalds. Post showing Jeff Bezos hiring programmers for amazon.com(before amazon.com) and lots of other great stuff. Sorry this went OT, but perhaps we could point out to some people in this list the tremendous amount of resources available to them. PS I don't work for google, nor have anything to do with them, but I am waiting for them to set up a donation thing, because they've saved me a huge amount of time and made me a lot of money. Dan Aleksander, what does your log file say? Does the mysqld have permissions to write to the directory it's creating the DB's in? -Original Message- From: Alexander Hampel [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 17, 2002 9:57 AM To: [EMAIL PROTECTED] Subject: Re: problem running the mysql server! Hi Aleksander, Seems to be a problem to get MySQL started. => but no one of the advanced users/admins in this newsgroup is interested in helping other users out :-( Can't help you with your problem but probably will find it out together. Did you get error messages like mine too? Include here my problem here again (Win2000, MySQL 3.23.49): > >Von: Alexander Hampel [mailto:[EMAIL PROTECTED]] >Gesendet: Sonntag, 17. März 2002 10:11 >An: [EMAIL PROTECTED] >Betreff: New to MySQL - can't start server :-( > > >Hi mailing list, > >I can't start mysqld-nt as I get the eror message 1067. If I start >winmysqladmin.exe there is no server visible. > >The manual tell me in part 2.4 Post-installation Setup and Testing that I >should start the script ./scripts/mysql_install_db but this script is not >availabale (at all) at my Windows distribution. > >Any ideas what's wrong? > Do you know if there exists a document where error messages are listed? I installed 4.0.1-alpha-win and I could start the server - strange, isn't it? Try this version too - probably it helps :-) So long A:lex >-Ursprüngliche Nachricht- >Von: Aleksander Gziut [mailto:[EMAIL PROTECTED]] >Gesendet: Sonntag, 17. März 2002 18:24 >An: [EMAIL PROTECTED] >Betreff: problem running the mysql server! > > > >i installed mysql-3.23.36 (*.rpm) on my redhat linux 7.1 (kernel 2.4.2-2 on >an >i686) and ran "mysql_install_db" script. then i tried to start the server: > >[root@localhost]# safe_mysqld & <<>> >[1] 1360 >[root@localhost]# Starting mysqld daemon with databases from /var/lib/mysql > >020317 hh:mm:ss mysqld ended > >one question - what's that? why i can't run the server? can anybody help >me? > >- >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 un
ANNOUNCE: moodss-15.10
Note: I am temporarily unsubscribed from this list, so please Cc me at [EMAIL PROTECTED] if you reply to this message. Moodss (a modular monitoring application, graphical and daemon) fully supports the MySQL database and great efforts are made in collaboration with the MySQL AB developer Sinisa Milivojevic, in order to achieve a practical and thorough monitoring of MySQL servers. No less than 8 modules, such as the new myreplication, myerrorlog and myhealth modules, are available. This new version features a new View/Trace menu, in MySQL modules, an error is reported when port is specified when connecting via local socket, plus other user interface improvements and bug fixes. Please refer to the http://jfontain.free.fr/moodss-15.10.CHANGES for a complete list of changes, including better module management, bug fixes, ... More examples and documentation, various screenshots and other modules for MySQL (myhealth, mystatus, myvars, myprocs, myquery, ...) are visible at the moodss and MySQL specific page: http://jfontain.free.fr/mysql/, whereas complete information on moodss itself can be found at http://jfontain.free.fr/moodss/. Development on moodss MySQL modules is very active, and your comments, bug reports, feature requests, ... will be greatly appreciated. Watch this space for new modules... Downloads: http://jfontain.free.fr/moodss-15.10.tar.bz2 http://jfontain.free.fr/moodss-15.10.zip http://jfontain.free.fr/moodss-15.10-1.i386.rpm http://jfontain.free.fr/moomps-1.3-1.i386.rpm http://jfontain.free.fr/moodss-15.10-1.spec Enjoy! -- Jean-Luc Fontaine mailto:[EMAIL PROTECTED] http://jfontain.free.fr/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem running the mysql server!
Hi Aleksander, Seems to be a problem to get MySQL started. => but no one of the advanced users/admins in this newsgroup is interested in helping other users out :-( Can't help you with your problem but probably will find it out together. Did you get error messages like mine too? Include here my problem here again (Win2000, MySQL 3.23.49): > >Von: Alexander Hampel [mailto:[EMAIL PROTECTED]] >Gesendet: Sonntag, 17. März 2002 10:11 >An: [EMAIL PROTECTED] >Betreff: New to MySQL - can't start server :-( > > >Hi mailing list, > >I can't start mysqld-nt as I get the eror message 1067. If I start >winmysqladmin.exe there is no server visible. > >The manual tell me in part 2.4 Post-installation Setup and Testing that I >should start the script ./scripts/mysql_install_db but this script is not >availabale (at all) at my Windows distribution. > >Any ideas what's wrong? > Do you know if there exists a document where error messages are listed? I installed 4.0.1-alpha-win and I could start the server - strange, isn't it? Try this version too - probably it helps :-) So long A:lex >-Ursprüngliche Nachricht- >Von: Aleksander Gziut [mailto:[EMAIL PROTECTED]] >Gesendet: Sonntag, 17. März 2002 18:24 >An: [EMAIL PROTECTED] >Betreff: problem running the mysql server! > > > >i installed mysql-3.23.36 (*.rpm) on my redhat linux 7.1 (kernel 2.4.2-2 on >an >i686) and ran "mysql_install_db" script. then i tried to start the server: > >[root@localhost]# safe_mysqld & <<>> >[1] 1360 >[root@localhost]# Starting mysqld daemon with databases from /var/lib/mysql > >020317 hh:mm:ss mysqld ended > >one question - what's that? why i can't run the server? can anybody help >me? > >- >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
Problem with using INSERT INTO [table] SQL string
Hi all,
Please excuse any ignorance I may show with this question - as I am not a
programmer and I am trying to do something that is out of my experience. I
feel truly out of my element in this and am hoping that the list expertise
will help me. I have looked at the manual - but still am confused.
Basically, I am trying to set up forms using Microsoft FrontPage 2000 where
the results (form input) will be sent to a database (Microsoft Access 2000)
and to an email address. I am following instructions outlined in a
Microsoft white paper which has specifically been written to address this
topic (found at
http://download.microsoft.com/download/fp2000/whitep/1/NT5XP/EN-US/cdonts200
0.EXE)
My problem is that I can only get one form field value to be inserted into
my table. I think I have followed the instructions that the white paper
gives for building the mySQL string that is used to insert the form
information into the database - but I am having no success in getting all
the form information inserted into the databse.
--
The mySQL syntax given by the white paper is the following:
mySQL = "INSERT INTO [your_table_name] "
mySQL = mySQL & "([database_field_names]) "
mySQL = mySQL & "VALUES ('[form_field_names]')"
--
The example mySQL string in the white paper is:
mySQL= "INSERT INTO Employees "
mySQL= mySQL & "(FirstName,LastName,Address,City,Region,PostalCode) "
mySQL= mySQL & "VALUES ('" & Request.Form("FirstName") & "','"
mySQL= mySQL & Request.Form("LastName") & "'"
mySQL= mySQL & ",'" & Request.Form("Address") & "'"
mySQL= mySQL & ",'" & Request.Form("City") & "','"
mySQL= mySQL & Request.Form("Region") & "','"
mySQL= mySQL & Request.Form("PostalCode") & "')"
---
The white paper gives the following my SQL syntax to help with customizing
the SQL string:
INSERT INTO [table] ([DBfield1],[DBfield2]) VALUES
('[form_field1]','[form_field2]')
mySQL = "INSERT INTO [table] (DBfield) VALUES ('" &
Request.Form("form_field") & "')"
--
Background:
The Microsoft Access 2000 database table I want to insert information into
is named Action
The form field names or VALUES I am trying to insert information from (from
the FrontPage 2000 form) are:
RequestDate
CommerceID
LastName
FirstName
Email
DepartmentNumber
Sector
StreetAddress
City
State
ZipCode
LocationCode
MailDrop
TelephoneNumber
FaxNumber
RequestType
Library
Request
The Microsoft Access 2000 database table field names (to which I want to
insert information into) are:
RequestDate
CommerceID
Client
FirstName
Email
DepartmentNum
Sector
StreetAddress
City
State
ZipCode
LocCode
MailDrop
TelephoneNum
FaxNum
ServiceName
InternalGroup
Request
The form field values correspond to the table colums in the following way:
RequestDate (value from form) insert RequestDate (database field name)
CommerceID (value from form) insert into CommerceID (database field name)
LastName (value from form) insert into Client (database field name)
FirstName (value from form) insert into FirstName (database field name)
Email (value from form) insert into Email (database field name)
DepartmentNumber (value from form) insert into DepartmentNum (database field
name)
Sector (value from form) insert into Sector (database Field name)
StreetAddress (value from form) insert into StreetAddress (database field
name)
City (value from form) insert into City (database field name)
State (value from form) insert into State (database field name)
ZipCode (value from form) insert into ZipCode (database field name)
LocationCode (value from form) insert into LocCode (database field name)
MailDrop (value from form) insert into MailDrop (database field name)
TelephoneNumber (value from form) insert into TelephoneNum (database field
name)
FaxNumber (value from form) insert into FaxNumber (database field name)
RequestType (value from form) insert into ServiceName (database field name)
Library (value from form) insert into InternalGroup (database field name)
Request (value from form) insert into Request (database Field name)
-
What I have tried and the results:
I have tried the following mySQL string - based on the example given in thw
white paper (did not include all form fields as I wanted to see if it would
work using the example given as a template). This string gave me error
messages...
mySQL= "INSERT INTO Action "
mySQL= mySQL & "(RequestDate,CommerceID,Client,FirstName,Sector,Request) "
mySQL= mySQL & "VALUES ('" & Request.Form("RequestDate") & "','"
mySQL= mySQL & Request.Form("CommerceID") & "'"
mySQL= mySQL & ",'"
problem running the mysql server!
i installed mysql-3.23.36 (*.rpm) on my redhat linux 7.1 (kernel 2.4.2-2 on an i686) and ran "mysql_install_db" script. then i tried to start the server: [root@localhost]# safe_mysqld & <<>> [1] 1360 [root@localhost]# Starting mysqld daemon with databases from /var/lib/mysql 020317 hh:mm:ss mysqld ended one question - what's that? why i can't run the server? can anybody help me? - 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
Delete User problem.
Hello, I have problem, I can't delete user, this is what I do: shell> mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 25 to server version: 3.22.32 Type 'help' for help. mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> SELECT Host,User,Password FROM user WHERE User = 'admin67'; +--+-+--+ | Host | User| Password | +--+-+--+ | %| admin67 | 31cb8bb344454eb1 | +--+-+--+ 1 row in set (0.00 sec) So user 'admin67' exist. Now I'm trying to delete him: mysql> DELETE FROM user WHERE User = 'admin67' and Host = '%'; Query OK, 0 rows affected (0.00 sec) mysql> SELECT Host,User,Password FROM user WHERE User = 'admin67'; +--+-+--+ | Host | User| Password | +--+-+--+ | %| admin67 | 31cb8bb344454eb1 | +--+-+--+ 1 row in set (0.00 sec) So, you can see that I didn't delete him. Why? What I am doing wrong? How can I delete this user? -- Pozdrawiam, Marcin Pyla (o_ [ <@ Marcin Pyla - Cubbi <[EMAIL PROTECTED]> | <<+ NetArt ISP +>> @> ] (/)_ [ NT == No Thanks ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Extending tablespace for innodb
Alex, -Original Message- From: Varshavchick Alexander <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Date: Friday, March 15, 2002 8:00 PM Subject: Extending tablespace for innodb >Hello, > >How can I increase the size of the tablespace for innodb tables? Can you >say if this is a correct procedure: > >1. Dumping the database; >2. Stopping it; >3. Deleting innodb log files (ib_logfile0, ...) and innodb data file >specified in innodb_data_file_path; >4. Changing size of data file in innodb_data_file_path; >5. Starting mysql; >6. Restoring the databases from the dump file. > >Does it seems to be a correct procedure, or I've messed up something? please look in section 5 of http://www.innodb.com/ibman.html about adding a new data file. >Regards > >Alexander Varshavchick, Metrocom Joint Stock Company >Phone: (812)118-3322, 118-3115(fax) Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - 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: Innodb replication and Database renaming question
Nico, -Original Message- From: Nico Sabbi <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Date: Friday, March 15, 2002 1:42 PM Subject: Innodb replication and Database renaming question >Hi, > > I'm still using Mysql 3.23.46 because, as far as I remember, in .47 was reintroduced the limit of 500 chars max in Innodb primary keys (limit that would break my application). Is it still present ? > Is it present in Mysql 4 ? > > I also need to know if Innodb is reliable in replication mode. I remember that with past versions, if the master broke the slave would lose synchrony, or something of this kind that would make a self-recovery impractical. replication of InnoDB tables is used at several database sites. There are currently no known bugs. > I need to implement a read-only fall-back DB, and I'm planning to use a combination of cron script to dump the live db to the slave after having renamed the good (old) versions, and after having verified that all the data in > the new dump is fine, renaming the new db to the right name. > >The problem is that I can't find in the manual a command to rename a database. There is none. You may write a Unix script which generates the RENAME TABLE commands from the .frm files. >I will appreciate any suggestion, > >Thanks, > Nico Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB - 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 error
Kannan, error 101 used to mean a lock wait timeout. In 4.0.1 and later 3.23 versions that has been replaced by a new clear-English error code. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB -Original Message- From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Date: Sunday, March 17, 2002 3:48 PM Subject: mysql error > > Placed At : > > >Hi ... > >I have a database having 30 tables..i run mysql-4.0.0 with innodb..updates and >delete on one paritcular table fail ..when i run the query the prompt jus t >hangs and i get the following error.. > >ERROR 1030: Got error 101 from table handler > >I'm also not able to create a new table by selecting from this table.. > >would be great if someone cld help me with this.. > >thanx >Kannan > >*** *** > >Quality Policy > >"To be the best-in-class service provider by practising international >standards > in providing world-class services and end-to-end network solutions." >*** *** > > > >- >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 Quits in Replication
We worked around the problem by using safe_mysqld. (We were just running mysqld directly.) What safe_mysqld does is to launch mysqld and then hang around in the background. If mysqld ever dies unexpectedly, it immediately restarts it. If mysqld is explicitly killed, e.g., with "mysqladmin shutdown", safe_mysqld doesn't restart it. We are still seeing the mysqld die a couple of times a day for no apparent reason, but now it gets automatically restarted. This brings up an interesting question. Is MySQL replication so unreliable that it needs a watchdog like safe_mysqld? Is anyone else seeing frequent, unexplained restarts of MySQL in a replication (or even standalone) environment? Is this peculiar to NetBSD? Inquiring minds want to know. Al __ Al Johnson Network Storage Solutions voice 865.675-4070 ext 2 cell 865.604.5869 [EMAIL PROTECTED] -Original Message- From: denonymous [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 3:11 PM To: [EMAIL PROTECTED] Subject: Re: MySQL Quits in Replication From: "Al Johnson" <[EMAIL PROTECTED]> > Nothing in the MySQL error logs. Don't know what you are refering to > as the "replication log". There is no binlog for the slave and there > are no other logs in the data directory or log directory. Is this > something that has to be enabled? I was referring to the slave's replication binlogs, but it appears you don't have them (they'd be on the slave in the MySQL data directory, afaik). I don't know much about replication setup, I'm only going by our setup here. Sorry I can't be of more help! -- denonymous www.coldcircuit.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 - 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: Emulating a subselect
USING NOT IN will exclude reports that nobody has ... which I'm not sure is the outcome he was after - It was my first thought as well but the actual solution (assuming reports someone isn't signed up for includes reports that nobody is signed up for) is quite simple I think - just change the where clause to != -Original Message- CUT > SELECT reports.id,reports.report_name FROM reports LEFT JOIN > reports_signup ON reports.id = reports_signup.report_id WHERE > reports_signup.user_id = '2'; You don't need a LEFT JOIN for this. > I now want to write a query to select the report names of all reports > a particular user is *not* signed up to - I'm having big troubles with > this. > Can anybody assist me? "NOT IN" sounds always like a LEFT JOIN with IS NULL: SELECT reports.id, reports.report_name FROM reports LEFT JOIN reports_signup ON reports_signup.report_id = reports.id AND reports_signup.user_id = 2 WHERE reports_signup.user_id IS NULL - 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: MySQLDump
From: Boaz Yahav <[EMAIL PROTECTED]> > 1. I was wondering if there is any way to backup MySQL information other > than MySQLDump? In some cercomstances, you can simply copy the database file, but this can possese real problems. Are you running your backups durring peak hours, or in the middle of the night when nobody is using the database? > Is there a way to use MySQLDump without overloading? % nice -n 20 mysqldump ... --- Rodney Broom Programmer: Desert.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: Emulating a subselect
Ack .. ignore the part of my last post re the original query not working :)
... it will as the user_id column will be null for reports notbody has and
this will fail the where clause my mistake. the LEFT join is redundant,
however, and the replacement I posted will also work ...
Anyway - have fun
-Original Message-
From: Peter Hicks [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 17 March 2002 9:28 PM
To: [EMAIL PROTECTED]
Subject: Emulating a subselect
Hi everyone
Maybe somebody can help me with what seems like a tricky
subselect-avoidance question?
In a MySQL database, there are two tables - 'reports' and
'reports_signup'. 'reports' has two columns, 'id' and 'report_name'.
'reports_signup' has three columns - 'id', 'report_id' and 'user_id'.
('id' in this table may be superfluous). 'report_id' is a value from
the 'reports_table', and 'user_id' is a value from another table.
I've written a query to select the report names of all reports a
particular user (say, id '2') is signed up to:
SELECT reports.id,reports.report_name FROM reports LEFT JOIN
reports_signup ON reports.id = reports_signup.report_id WHERE
reports_signup.user_id = '2';
I now want to write a query to select the report names of all reports a
particular user is *not* signed up to - I'm having big troubles with this.
Can anybody assist me?
Best wishes,
Peter.
-
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: Emulating a subselect
how about just change the WHERE clause to :
WHERE reports_signup.user_id != '2' (or whatever user_id)
ie: does not equal.
That should grab all reports they are not signed up for and the left join
will include all reports that nobody is signed up for (left-overs).
Another issue is that you're original query will not perform as you say. ie:
It will not get all reports they are signed up for (only). It will also get
the reports that nobody is signed up for. This should change to a basic join
like so:
SELECT reports.id,reports.report_name FROM reports, reports_signup ON
reports.id = reports_signup.report_id WHERE reports_signup.user_id = '2';
AND the query to find reports they are NOT signed up for (assumming this
includes the sibset - reports nobody is signed up for) is :
SELECT reports.id,reports.report_name FROM reports LEFT JOIN reports_signup
ON reports.id = reports_signup.report_id WHERE reports_signup.user_id !=
'2';
Regards ...
-Original Message-
From: Peter Hicks [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 17 March 2002 9:28 PM
To: [EMAIL PROTECTED]
Subject: Emulating a subselect
Hi everyone
Maybe somebody can help me with what seems like a tricky
subselect-avoidance question?
In a MySQL database, there are two tables - 'reports' and
'reports_signup'. 'reports' has two columns, 'id' and 'report_name'.
'reports_signup' has three columns - 'id', 'report_id' and 'user_id'.
('id' in this table may be superfluous). 'report_id' is a value from
the 'reports_table', and 'user_id' is a value from another table.
I've written a query to select the report names of all reports a
particular user (say, id '2') is signed up to:
SELECT reports.id,reports.report_name FROM reports LEFT JOIN
reports_signup ON reports.id = reports_signup.report_id WHERE
reports_signup.user_id = '2';
I now want to write a query to select the report names of all reports a
particular user is *not* signed up to - I'm having big troubles with this.
Can anybody assist me?
Best wishes,
Peter.
-
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
MySQLDump
hi 1. I was wondering if there is any way to backup MySQL information other than MySQLDump? 2. MySQLDump seems to overload the system. Is there a way to use MySQLDump without overloading? thanks Sincerely berber Visit http://www.weberdev.com/ Today!!! To see where PHP might take you tomorrow. - 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 error
Placed At : Hi ... I have a database having 30 tables..i run mysql-4.0.0 with innodb..updates and delete on one paritcular table fail ..when i run the query the prompt jus t hangs and i get the following error.. ERROR 1030: Got error 101 from table handler I'm also not able to create a new table by selecting from this table.. would be great if someone cld help me with this.. thanx Kannan ** Quality Policy "To be the best-in-class service provider by practising international standards in providing world-class services and end-to-end network solutions." ** - 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 tables named 'column' cause problems.
Hello, > He didn't name a column 'column', he named a table 'column'. This may > have seemed reasonable given his application. > In any case, bad idea or not, his point is well-taken. It worked in one > place but not another. While column is a reserved word, the directions at > http://www.mysql.com/doc/L/e/Legal_names.html clearly state you can use it > as a table name anyway, as long as you quote it properly. So, it seems to > me, either Tozz did something wrong when he invoked mysqldump, or there's > a bug which breaks mysqldump on tables named 'column' (or any other > reserved word, I'd guess). I suppose it would be useful to know which > version of mysql he is using and how he's calling mysqldump so we can > figure out which is the case. This is the mysqldump command I use: mysqldump -A -pmysecrethere > sql_backup.sql And it fails :(. So this looks like a bug in mysqldump then. Bye, Tozz - 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
Emulating a subselect
Hi everyone
Maybe somebody can help me with what seems like a tricky
subselect-avoidance question?
In a MySQL database, there are two tables - 'reports' and
'reports_signup'. 'reports' has two columns, 'id' and 'report_name'.
'reports_signup' has three columns - 'id', 'report_id' and 'user_id'.
('id' in this table may be superfluous). 'report_id' is a value from
the 'reports_table', and 'user_id' is a value from another table.
I've written a query to select the report names of all reports a
particular user (say, id '2') is signed up to:
SELECT reports.id,reports.report_name FROM reports LEFT JOIN
reports_signup ON reports.id = reports_signup.report_id WHERE
reports_signup.user_id = '2';
I now want to write a query to select the report names of all reports a
particular user is *not* signed up to - I'm having big troubles with this.
Can anybody assist me?
Best wishes,
Peter.
-
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
How to unsubsribe from the mysql list?
Hi all, Could you please tell me how to unsubsribe from the mysql list? Thanks, Li Bing _.--"""--._ .' '-. `. __/__(-. `\ \ /o `o \ \\ \ _\__.__/ ))|| ; .--;" || \ (`) || \ _|`---' .' _, _||`\ '`_\ \ '_,.-';_.-`\| \ \_ .' '--'---;` / / |\ |_..--' \ \'-'.' .--'.__/__.-; `"` (___...---''` \ _/_\ /ASU\ [EMAIL PROTECTED] \___/ 480-965-9038(L), 602-743-9767(C) http://www.public.asu.edu/~libing
Re: white background
From: "Andreas Dau" <[EMAIL PROTECTED]> > Well, it's not really a mysql topic, but it's a bit connected to it. I > have a website that uses frames. My php script retrieves data from a > mysql database and displays it. My problem now is: each time that > specific page loads it first displays a white background, retrieves the > data and then displays it. It's just a cosmetic issue but I'd like to > avoid that ;-) Honestly, now -- what could possibly make you think that a MySQL list could solve this? This seems, at the most broad level, an HTML problem and, most likely, a browser problem. This has nothing to do with MySQL, chap. > P.S. Oh, and... disallowing html mails? Huh? We're in stoneage? HTML mail is unnecessary and, for many, complete gibberish. It's not even close to an argument that should be approached in this forum but, if you'd really like, you can mail me for some info relating to the issue. -- denonymous www.coldcircuit.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
New to MySQL - can't start server :-(
Hi mailing list, I can't start mysqld-nt as I get the eror message 1067. If I start winmysqladmin.exe there is no server visible. The manual tell me in part 2.4 Post-installation Setup and Testing that I should start the script ./scripts/mysql_install_db but this script is not availabale (at all) at my Windows distribution. Any ideas what's wrong? Thank you, A:lex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Invalid Argument ??? Not sure how to debug this
On Sunday 17 March 2002 16:38, Daniel Negron/KBE wrote: > Hi all and Good Morning. > > I have been struggling with this code: I was wondering if someone could > lend me a hand. > > I am working with this code and can't get the error to disappear. > > After running I get > > |-- > |---| Warning: Supplied argument is not a valid MySQL result > | resource in C:\My Documents\My | Webs\php\TMPibtpit3zq0.php on line 12 > | | > | - > || > > Line 12 happens to be the WHILE statement. I am not sure if it is the > while statement or the results its looking for. Put in some error checking code when you use the mysql functions as per the manual examples and you'll soon find where the error is. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk /* I'm having an emotional outburst!! */ - 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
Invalid Argument ??? Not sure how to debug this
Hi all and Good Morning.
I have been struggling with this code: I was wondering if someone could
lend me a hand.
I am working with this code and can't get the error to disappear.
After running I get
|-|
| Warning: Supplied argument is not a valid MySQL result resource in C:\My
|Documents\My |
| Webs\php\TMPibtpit3zq0.php on line 12
| |
|-|
Line 12 happens to be the WHILE statement. I am not sure if it is the
while statement or the results its looking for.
TIA So far, i havent been able to sleep atleast until I get this.
";
echo "ArtistTitleOptions";
while ($myrow = mysql_fetch_array($result))
{
echo "".$myrow["artist"]."".$myrow["title"];
echo "View";
}
echo "";
}
else
{
?>
Insert Your Search String Here.
Search Type
Artist
Title
Category
**DAN**
-
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
