Re: Important: Got error 127 from table handler (1030)?
By coincidence, we had this yesterday for the first time in our experience. It is a corrupt table, and we fixed is with isamchk. We are running an older version, you might have to use myisamchk. _justin = Daniel Brockhaus wrote: > > Hi, > > well, the subject says it all. I'm using version 3.23.41-log, and I got the > following error message when trying to update a row: > > Got error 127 from table handler (1030) > > It's a normal query which has succeeded several thousand times already. > > Any ideas what might be wrong? > > Thanks, > > Daniel Brockhaus > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Need Help bad!.. today.. of all days!
I think you need to post the code. The description of the problem is a bit ambiguous. _justin Webmaster wrote: > > Hello.. of all days i have a project thats to be shown tomorrow. > > i cannot get the dam thing to work > it should be simple i'd think > > i would post code and all and if asked will > > but it comes down to this.. i am using php 4 and mysql.. and doing math > i have say 40 entries in the database, 20 for two differant surveys.. anytime anew >person fills out the survey they get a unique id > i have it set to grabe the results from each unigue id for each question through >mysql.. but it seems to stop shot about 4 questions.. > i even tried dropped the while loop 4 questions shorter "-4" and it still stop the >same place.. of all days for this to occure.. i know > but if anyone has a clue please offer suggestions.. also plase cc [EMAIL PROTECTED] >with your reply.. thanks > > -- > Your Guardian Angel... find out here http://www.angelhaven.com/aodmail/ > Come Cruisin with the Angels http://www.AngelCruise.com > Sign up for your free AngelHaven E-mail Today http://www.angelhaven.com/mail/ > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hippies hijack cetecean...
[ sql, database, mysql ] SEE: http://www.theregister.co.uk/content/28/20750.html _jef -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Just one more thing...
Van wrote: [== snip, snip ==] > Anyone else see the irony? Small wonder Open Source hasn't been lucrative. > We're solving all the problems of the money makers at our own expense. Time we > should look at how open we want our own model to be to clients who choose models > of lesser openness. I'd consider slamming the door shut on those who are truly > infected. -- You are not alone here. I find it terribly interesting in a historical sense that the recent storms of virii/wormae caused by and propagated by Microsoft products have caused the appearance in several of the news sites as well as in the paper rags, to call for the consideration of banning all Microsoft products from the Internet. Many of these articles have been written by journalists of reputed impartiality. Running this idea up the flagpole has a significance that each of us may judge differently. Wild idea? Yes, and certainly illegal. But in any considered judgement, the situation is only going to get worse, and the perception of the total cost of ownership of Windows is chaging. Businesses are starting to "try" to factor in the cost of, say, the Love Bug virus, estimated to have cost just American Business billions. At some point, Microsoft will have to clean up its act, or slowly sink into obscurity. Although this is/may be off topic, this list is certainly suffering because of Redmond and its indifference to security and arrogance toward the idea that this even represents a "problem". Things are still cool in Redmond... _jef [ database, sql] -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Winlose Lusers Clean Your Machines {Was: Re: DISSERTATION2 [VIRUSES STRIPPED]}
I am going to violate a principle and burn up some bandwith here to say samething that most people probably feel about this post. BRAVO VAN, for summarizing this situation cogently, and fairly. With this kind of measured observation, the statement that Microsoft software sucks does not embody a flame, but probably a fact... Outlook users (you use Lusers, heh) have a responsibility to not cause harm to others because of its deficiencies, just as a driver of a car with poorly designed brakes has a social responsibility to drive very carefully and slowly. Better metaphors probably exist for this "situation". _jef = Van wrote: > > tj marlin wrote: > > > > This virus is becoming wide spread. It appears to use a machine's address > > book and mail itself to the members of the address book. i've received mail > > with the virus from a number of people, in addition to receiving it from > > this list. > > > > And, I have a bunch of stranger's confidential files in my inbox. And, a bunch > of haxed IIS servers bludgeoned my Apache server's bandwidth last week. See the > light, or go pay for and play with M$AccessXP. > > These clueless are not contributing in a useful way, if they're allowing their > machines to do this to the MySQL mailing list. There're 2MM users in this > community. These users have grown to expect/have contributed useful information > that flows through here, which is part of the legacy that's made MySQL AB the > success it is. In 5 years, I've never had to deal with this level of crap from > Outlook Lusers on this list. > > Please, people; if you're going to use a mailer that allows this kind of stuff > to propagate, keep your anti-virus software up-to-date. You have to if you've > committed to using an OS that requires you to pay rent. Pay your rent to the > anti-virus mafiosos and BG, or get off the list and remove [EMAIL PROTECTED] > from your address book. > > No, I'm not saying your input isn't useful, but weighing the posts Winlose > Lusers send against USEFUL posts they send, it's a clear lose to us in the *n*x > community when this type of crap comes from your mailers and obfuscates > discussions with your viral drivel. We help you more than you help us; and > viruses are sent into our discussion forum to reward us so other talented > innovators have to use their time to deal with it. > > Get lost, or behave and pick up where your OS Vendor has dropped the ball on > security. Pay your anti-virus vendors their rent and hold them accountable to > the services they "promise to provide" with the exchange for that rent. It's > the model you've chosen. Write your check to them, send it and take the > ownership of your machine's problems back into your own problem sphere and get > it out of ours while we really "INNOVATE." > > Or, do the right thing, and tell your OS vendor they're not doing enough to > secure your OS with the $$$ you sent them for it's restrictive licensing > arrangement to begin with. > > This is ludicrous. Where does it end? When do we find the time to "innovate" > when we're spending all our time solving your vendor's problems on our dime? > > Anyone else see the irony? Small wonder Open Source hasn't been lucrative. > We're solving all the problems of the money makers at our own expense. Time we > should look at how open we want our own model to be to clients who choose models > of lesser openness. I'd consider slamming the door shut on those who are truly > infected. > > Sheesh! > > And, no I don't hate Micro$oft for religious reasons. I'm not a religious guy. > They're software sucks. Plain and simple. If it didn't I would use it. > Instead, I use something far superior. MySQL, rocks, as well. > > Van > -- > = > Linux rocks!!! http://www.dedserius.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 -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.org
[ database table sql ] Van wrote: > > Michael Meltzer wrote: > > > > thought the list might want to know, this has been picked up by a trade > > magazine, I got a copy of "interactive week" in sail mail today. (In my best > I'd have never caught that but for the list. Thanks. Wonder what the audience > for that site is. Also, was particularly intrigued by the "Portal out of the --- Just a few facts for the list drawn from my dusty memory... 1. Ziff-Davis is the largest technical publishing house 2. I think Iter@ctive Week started around 1994, and was the first rag to really cover the Net explosion 3. In the first days of Unix on a PC, Progress was one of the big four DB's, which were: - Informix - Empress - Unify - Progress 4. These RDB's were all ported from mini's, their bread and butter were DEC/DG/Prime/Harris etc Oracle was just getting started. 5. Informix won that niche quickly, as it had a very good port to Xenix/286. 6. The only good Unix that ran well on the 286 was Xenix. Some of you may be unaware that Microsoft developed that Unix port, and Microsoft's ads at the time read "Xenix is Unix, only better". 7. The only other DB's available at the time for PC's were INGRES and Postgres (which was a different animal then, research oriented) and these were bears to get working. The poor man's Unix at the time was from Microport, $99 on about 20 floppies 8. Progress "withdrew" to selling their engine to third party developers, typically large industrial programs, such as SiteLine, that would control an entire industrial manufacturing process. 9. Progress is a very good database, and I think it is like UniVerse, non-first normal, with multiple entry fields per record (ARRAY things). It is rank speculation upon my part, so do not take as gospel, but it would seem to me that Progress needs to have some kind of lighter-weight product. I have a bit of experience with trying to use some data from Progress across Net for web work along with MySQL, but Progress is not "designed for the Web" where things like connection build-up and tear-down are critical. It is my belief that the Progress web interface tools have not been too successful. Given the above, I can see the needs and thinking of Progress management wishing to have a relationship with MySQL. Customers need industrial-strength features such as row-locking before it can even be considered for mission critical requirements. I think this is what they wish to ultimately do, bring these extra facilities to MySQL to make a robust product. As much as I love MySQL, I would not step into an X-ray scanner that had MySQL underneath. It just isn't designed for that kind of thing. MySQL's excellence is, for the moment, in other domains. Making dynamic web sites is "easy" with MySQL, but the nature of the Web itself is forgiving, completely non-critical. I would speculate that 98 percent of the code written with MySQL does not even check error returns and do something sensible with it. It is just not necessary. for the web, and sloppy coding is the "norm". I certainly do it... _jef -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.org
Van wrote: > > Michael Meltzer wrote: > > > > thought the list might want to know, this has been picked up by a trade > > magazine, I got a copy of "interactive week" in sail mail today. (In my best > I'd have never caught that but for the list. Thanks. Wonder what the audience > for that site is. Also, was particularly intrigued by the "Portal out of the --- Just a few facts for the list drawn from my dusty memory... 1. Ziff-Davis is the largest technical publishing house 2. I think Iter@ctive Week started around 1994, and was the first rag to really cover the Net explosion 3. In the first days of Unix on a PC, Progress was one of the big four DB's, which were: - Informix - Empress - Unify - Progress 4. These RDB's were all ported from mini's, their bread and butter were DEC/DG/Prime/Harris etc Oracle was just getting started. 5. Informix won that niche quickly, as it had a very good port to Xenix/286. 6. The only good Unix that ran well on the 286 was Xenix. Some of you may be unaware that Microsoft developed that Unix port, and Microsoft's ads at the time read "Xenix is Unix, only better". 7. The only other DB's available at the time for PC's were INGRES and Postgres (which was a different animal then, research oriented) and these were bears to get working. The poor man's Unix at the time was from Microport, $99 on about 20 floppies 8. Progress "withdrew" to selling their engine to third party developers, typically large industrial programs, such as SiteLine, that would control an entire industrial manufacturing process. 9. Progress is a very good database, and I think it is like UniVerse, non-first normal, with multiple entry fields per record (ARRAY things). It is rank speculation upon my part, so do not take as gospel, but it would seem to me that Progress needs to have some kind of lighter-weight product. I have a bit of experience with trying to use some data from Progress across Net for web work along with MySQL, but Progress is not "designed for the Web" where things like connection build-up and tear-down are critical. It is my belief that the Progress web interface tools have not been too successful. Given the above, I can see the needs and thinking of Progress management wishing to have a relationship with MySQL. Customers need industrial-strength features such as row-locking before it can even be considered for mission critical requirements. I think this is what they wish to ultimately do, bring these extra facilities to MySQL to make a robust product. As much as I love MySQL, I would not step into an X-ray scanner that had MySQL underneath. It just isn't designed for that kind of thing. MySQL's excellence is, for the moment, in other domains. Making dynamic web sites is "easy" with MySQL, but the nature of the Web itself is forgiving, completely non-critical. I would speculate that 98 percent of the code written with MySQL does not even check error returns and do something sensible with it. It is just not necessary. for the web, and sloppy coding is the "norm". I certainly do it... _jef -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.org
Werner is correct in encouraging all to make up your own mind. And, it is always possible that Orwellian "DoubleSpeak" is an ingredient of these public statements and posturing. But, a great distinction must be made here, and not tie the idea of "DoubleSpeak" to a fear of manipulation, unless you, the reader, allow it. DoubleSpeak is only truly dangerous in the Orwellian context, when there is a central authority, and where it can truly cause a veering away from the noble instincts of man. We are free here, the Net cannot be captured by a central authority (I hope), and Mr. Johnston has no power over me by virtue of this situation. My DoubleSpeak is just as weak as Mr. Johnstons DoubleSpeak, is just as weak as Werner's DoubleSpeak, because of the Net, because of things like Open Source and its principles. We are lucky to have this great mesh of communication, this Samizat right under our fingertips... We pay a price in certain ways, like having to eat spam three meals a day. I still consider it well worth it. Helas, I am an optimist. _jef _ Werner Stuerenburg wrote: > > table > > > This statement/release was very ordinary, very normal, very to-the-point > > for any situation such as this. Condescending, no. Condescension, > > like beauty, is in the eye of the beholder. > > Well, I didn't plan to give my opinion on this subject publicly. > But, I was alerted by the last post of Mr. Johnston and am > concerned about this interpretation I refer to. > > I have to admit that English is not my native language and I may > miss a lot of meaning. But this is the situation of the MySQL > people as well, and I know English good enough (and the art of > negotiation and politics) to feel strongly what happens here. > > Incidentally, this morning I received a long elaboration about > spam, written by a long-standing spam fighter. We all know that > this subject is equally unpleasant. He closes his remarks with > the following, which I think applies to the recent dialogue as > well: > > I remember when I first read Orwell's "1984." The > concept that really got my attention was > DoubleSpeak. I thought he was really out there. > > Orwell was an optimist. > > Paul Myers, talkbiz.com > > Reread both of the posts of MySQL and nusphere in question and > make up your mind. > > -- > Herzlich > Werner Stuerenburg > > _________ > ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen > Tel 0(049) 5224-997 407 ยท Fax 0(049) 5224-997 409 > http://pferdezeitung.de -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.org
[permission to come aboard, sql database query table] "Gerald R. Jensen" wrote: > > I wouldn't be concerned about this being discussed here on the list. After > all, we are talking about Open Source. > > Gerald Jensen - Right, Mr. Jensen. My historical bent takes me further. I consider this entire matter socially "historical". This is something like Open Source Legal Settlement. For some reason, probably relating to the deep appreciation of the principle of Open Source, both parties are airing their dispute before us, unwittingly a jury of sorts... The only mechanism currently available for remedy in our civilization is the Law, but it is facinating to observe that both parties are striving to their utmost to retain the respect of this entire community. That says something. _jef -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.org
to further promote MySQL on both a technical and business > > level at the conference. NuSphere continues to support the formation > > of a noncommercial organization. All of these demonstrate the > > strength > > and depth of our commitment to the MySQL community. Your willingness > > to return to resolving our issues in a business-like fashion would be > > welcome. > > > > Sincerely, > > > > Britt Johnston > > CTO, NuSphere Corporation > > > > -- > > > > D. Britton Johnston 603-578-6707 Nashua > > Chief Technology Officer 781-280-4954 Bedford > > NuSphere Corporation 781-280-4600 Main > > 14 Oak Park 781-280-4646 Fax > > Bedford, MA 01730 www.nusphere.com > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.org
hassan el forkani wrote: > > "First: take it to court. Potentially expensive, and probably not good for > public relations for either party" probably the only sentence that makes > sense in this "affaire" > > from a mysql user point of view, nusphere's move is completely amateur > > i can't see any intelligent motivation for it, the existence of such a site > will only spread confusion, bad press and discredit Mysql as well as open > source in general , and oh, isn't nusphere's main stream business Open > Source??? > can someone from Nusphere explain it here [== snip, snip ==] Hassan: I respectfully disagree with your suggestion that such a site would spread confusion and give discredit to MySQL. I think it is a fine distinction to say the (slight?) difference between mysql.com and mysql.org would lead to confusion. Are you confused by the extant "mysql.net"? What about xmysql.com? There have been arguments by both parties that these so-called "support sites" are in everyone's interest. This practice is common, just think of linux-help.com/linux-support.com/linux-this-or-that.com ad infinitum, and all these play in certain niches without necessarily confusing the linux user, or to-be linux user. Anyway, I cannot see this but a pure-and-simple trademark issue, as far as the mysql.org site name is concerned. _jef -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: .org
Paul DuBois wrote: > > In the interests of stemming some of the flood of invective being > directed against NuSphere... [== snip, snip ==] Paul: I have a certain sympathy for your personal discomfort. I feel that you/NuSphere are the "victims" of a kind of natural aspect of the human condition... This kind of discussion is difficult to keep flames out of. It is similar to trying to have a rational discussion about the virtue of Maria of Jersey City, with the older brother Salvatore... You have: 1. The great reservoir of goodwill that has been accumulated by MySQL AB over the years 2. The "natural" tendency to impugn sinister motives to anyone that "disturbs" this goodwill 3. The ease and anonomity provided by email to react What is usually never considered: 1. Heros _can_ make mistakes, and/or there are always two sides to every question 2. To extend good faith to both parties However, there are always two sides to every question, and disputes can easily arise out of any business relationship that range from innocent misunderstandings to covert manipulations. And, the third parties observing cannot know, apriori, what is true. For whatever worth it may have, I do not consider that you/NuSphere have left the human race, are scumbags, or members of the Evil Empire, as many on this list have knee-jerked to. That is probably small comfort. You are just stuck with your lot, for the moment. What I find so terribly interesting about this whole affair is how it is being, to some extent, settled, or at least converging on a settlement/understanding, right here in front of the eyes of the entire Community. To me this is a kind of historic phenomena. Cheer up. _jef -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.org
David Axmark wrote: > > >>>>> "Britt" == Britt Johnston <[EMAIL PROTECTED]> writes: > > Since Monty is travelling for 30 hours or so (from Australia) I will > answer this. [== snip, snip ==] WOW! Does everyone realize what is going on here? I don't know, I consider this stuff historic. Perhaps, at least to this quasi-agnostic observer, "Open Source Legal Resolution" has been invented by accident. I find it interesting that facts are coming out, two parties are at least tending to converge on a legal remedy in a gentlemanly manner in the forum of great pressure as exerted by the highly-interested MySQL community. One has seen already the removal of the download registration requirement on the NuSphere site, something that was technically meaningless in a strict legal sense, but perceived as onerous by the Community as representing some kind of insult to "Open Source" or designed for imagined sinister motives. One has seen the modification of the NuSphere site to gain clarity as to the identity of the MySQL developer(s), heretofor apparantly obscure. One has seen already the clarification by MySQL AB that the existence of ex-officio support sites for MySQL are encouraged, not confusing, and good for all, but that the mysql.org site is, technically, only a trademark issue, in their eyes. One has seen a convergence to the real nub, visible to all of us interested observers, that the remedy for GPL violations is not satisfied by "late compliance" or other possibly-obscure methods of compliance. One has seen a revelation of a lot of things behind the scenes that are perceived as a violation of the GPL and, usually, to the general member of the Open Source Community, may be complex, such as static linking, the idea of shared copyright, the mutual interpretation of the "agreement process" between the two parties, et cetera. Both parties are now letting everything hang out... One has seen a complete stake-out of all necessary legal positions of both parties out-in-the-open that would be necessary in any discovery process, and, as a humorous aside comment, almost pre-empts the necessity of having legal councel prior to going before the judge. By some quirk, we have become the court and jury of judgement that both parties feel the need to convince, and cannot ignore. This is very interesting, this "Open Source Legal Resolution" ;-) _jef -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.org
Jeremy Zawodny wrote: > [== snip, snip ==] Jeremy: You should be complimented for giving us a measured and rational posting on this potentially emotional issue. And also, it is good that Britt has clearly stated his understanding, though perhaps a bit too late to have prevented one of those common socialogical phenomena, the perception that sombody or a Company is somehow exploiting Open Source with its train of reactions: - NuSphere is a dirty bunch of guys - Monty is being screwed - et cetera ad infinitum Personally, I could care less about the mysql.org domain issue. I, more or less, see it just as another kind of ex-officio site supporting some Open Source effort. I cannot see why it would lead to confusion as to who is "leading" the MySQL development, as the information presented on the site makes everything very clear. But, somehow, possession of this domain is important to both of the "disputing" parties for reasons only known best to them. I think in the long run, to the community, the more sites/domains dedicated to the promotion of MySQL, the better. As for NuSphere being perceived as violating the GPL, it appears that they have just not handled it very well in their, er, "PR", as, if the NuSphere exposed position is taken on face value, namely they have submitted their changes, but the community has not been really made "aware" of this because of the complex relationship between NuSphere/MySQL which, also, was not made clear by either party until recently. For me, this is a tempest in a teapot, mostly due to the "silence" of NuSphere on the mechanism of complying with the GPL and the details of NuSphere's position on the domain issue. In summary, with 20-20 hindsight, NuSphere has probably handled its PR badly, and now they are suffering for it. _jef -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RECURSIVE->sql/database Re: Bounces from rtmglobal.com
[EMAIL PROTECTED] wrote: > > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > database,sql,query,table > > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. You have written the following: > > I have received six this morning > > - > > Chris Bolt wrote: > > > > Am I the only one getting these? Someone really needs to fix their mail > > server... > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Friday, July 13, 2001 4:10 AM > > To: [EMAIL PROTECTED] > > Subject: No valid command found > > > > Your message does not contain a valid command for this mail server > > to process. No action has been taken. > > > > Message-Id: <[EMAIL PROTECTED]> > > From: [EMAIL PROTECTED] > > Time-Stamp: Fri, 15 Jun 2001 13:31:46 -0600 > > > > : Message contains [1] file attachments > > -- > Justin Farnsworth > Eye Integrated Communications > 321 South Evans - Suite 203 > Greenville, NC 27858 | Tel: (252) 353-0722 -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.org
"Gerald R. Jensen" wrote: > > Monty: > > I was on the verge of authorizing the purchase of 3 copies of NuSphere's > PHPEd package (US$300 each) for our developers when I became aware of the > controversy surrounding 'Enhanced MySQL' and mysql.org. > > The purchase order went into the round file, and Hell will freeze over > before I buy anything from NuSphere. > > A small gesture, perhaps, but an appropriate one. At least our company won't > be contributing to their largess. Even people with such deplorable business > ethics understand a loss of income from sales. [ snip, snip ===] Do not jump to the conclusion that I am starting out to be an apologist for NuSphere/Progress. It is wise to honor the old dictum "Never ascribe malice to that which can be attributed to ignorance". I am not sure if this type of emotional leap is proper until a bit more information comes out and some of the heat dies down. There are always two sides to every situation. There are two issues, the domain mysql.org, and the other, more difficult to understand, the aspect of "GPL violation". The domain/trademark issue will get settled by legal means and there is enough of a corpus of law precedent that a settlement and/or judgement will occur. I personally do not see such a great importance of mysql.org in this matter. Obviously, many of you on this list do not share this opinion. Now most of us in/using Open Source probably do not _really_ understand the meaning and ramifications of the GPL. We _think_ we know, and we certainly have a "feeling" about what the GPL "means". Ironically, Richard Stallman's take is, in a legal sense, crystal clear compared with the GPL. NuSphere indicated that is was going to put their products under the GPL. They have indicated that Gemini will be GPL's. Are they to be punished for "being late" in doing so? NuSphere supports Open Source and is public on this position. The irony of this situation is that it _may_ be to the advantage of the Open Source community if NuSphere is not knee-jerked pilloried, and tarred and feathered out of the minds of the Open Source community. It is complete speculation upon my part that ultimately, MySQL will be replaced in all those embedded applications where Progress now sits. Though it may change in the near future, commercial developers needing an embedded database usually prefer a solution like Progress because of the Company-behind-it, rather than have MySQL. MySQL may/would gain credibility if Progress is replaced. Now, I hope this is all settled to everybody's benefit. It may not be possible because of emotion. But I know that I would personally like to see MySQL start to creep into large manufacturing management systems and other systems where Progress now has a significant hold. Then, and only then, will the community be able to easily "tap into" MySQL and offer better intranets, tools, and other solutions. So, I am suggesting to everyone to just "wait and see". It might not be as bad as it seems... -- Justin Farnsworth - Technical Director Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: probably a stupid question but...
Use an index. -- Jonah Klimack wrote: > > Hi > > I want to enforce unique records in one of my > tables. > > The table goes like this: > > ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, > customerID INT UNSIGNED, > categoryname VARCHAR(20) > > With customer ID pointing to a customers table. > > I suddenly realized that one customer could input > the same "categoryname" twice, which would create > a duplicate entry in the database. (if you ignore the > primary key). > > Is there something in > MySQL, or in my table design, that can force unique records? > Or will I have to check this with my code everytime I > update the database? > > Thanks very much for any help! Much appreciated. > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: re-sorting auto_increment fields
Thank goodness this is the position. If the capability of reordering the auto_increment existed, we could potentially have all of our databases broken by some inadvertant finger trouble. As you mentioned, there are better ways to handle this perceived "problem", which appears that the auto_increment is being used for a purpose it was not intended for... --- Tonu Samuel wrote: > > Kif wrote: > > > Hi > > ANy idea how i can get my auto_increment fields to renumber themselves after >deletion of records so that they all get re-ordered and run consecutively from 1 to >whatever without any numbers missing ? > > Please help if you know how to do this > > I think we never will implement such stuff. auto_increment responsibility is to be >unique and it should never > appear back again when issued once. Idea is to identify record in database. If >someone have right to reorder > one table then relationships to other tables will be broken. auto_increment is >totally technical field and if you > do not like holes in it, programmer should use separate column for user-readable >values additionally to auto_increment. -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Proposition: Attach a comment to each connection
BAUMEISTER Alexandre wrote: > > Bonjour Justin, > > JF> I don't know why I got interested in this thread... > > More important (or less), why are you so negative ? > Je ne suis pas contre. I just haven't felt the need for this, but after reading your scenario, I can't understand why. Email obscures a lot of preconceptions of the writer. > Hope this is more clear to you now. And, it is. I can see the utility of this functionality if I was tracing a suspect that was trying to get, as an example, credit card numbers out of our database BY NOT GOING THROUGH OUR CLIENTS. However, it would not help at all if the attacker was sophisticated, because he ain't gonna write in any comments. Without thinking too much, I can see the utility of knowing which of YOUR ten servers was going bonkers, from which of, say, YOUR 250 web sites using the ten MySQL servers. If I had felt this need, I probably would have just added another field to the schema of a "sensitive" table, and had my apps write in a comment, like, for a shopping cart, "The guy using this credit card has IP so-and-so, and his user agent is so-and-so and the DNS resolves to 12345.nasty.net." I just would not have thought about your idea. Et alors, bonne chance with this request _jef -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Proposition: Attach a comment to each connection
I don't know why I got interested in this thread... I suppose you don't need a change to the wire protocol if you have, logically, something like below. The API has to be changed, however. id = do_a_connedtion(arg) set_comment_on_connection(id, "this_is_my_comment") // later some_array = get_connection_comments() // parse the array comments // do something or other as function of comment Question: Why, again, do you want this? You must see some utility in this other than academic interest, or taking statistics, or mischief, such as munging some field returning data to a Windows client with "Screw Bill Gates" prepended to his blob requests, or kicking off connections to, say, any client in Tana Tuva. For readers like me, sitting on the sidelines, the "need" for this facility is obscure. Please make your case more evident. _jef -- Ansgar Becker wrote: > > > The only thing I would like is to be able to attach a comment to a > > connection id which could be returned by the "mysqladmin process" > > command. And something that would not add more load to Mysql nor > > more coding in the client. > > Yes!! Great idea. This would be helpful for hosters with many > client-connectors to identify them. It could contain for example the name of > the client-application ("useragent"), client-OS and some version-info. i > think 100 chars will do. > > Greetings, Ansgar > http://www.mysqlfront.de/ > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Proposition: Attach a comment to each connection
This thread has been "interesting" to follow. But I considered it completely "blue sky". Are you guys supporting a change to the MySQL wire protocol? Are you guys supporting a change to _all_ API's that currently use MySQL that would then have to stick somewhere all these "nice" things in the exchange connection handshake? What is the "idea" of the "user agent" in this case? I suppose what is meant is that the thinking is that this "comment" field in the wire protocol would be loaded up with whatever the API wanted. On a typical web site running Apache/PHP/MySQL, the sequence would have to be, I think: 1. PHP gets the "user agent" 2. PHP passes the arg to the connection request 3. This "user agent" sticks in the data in the wire protocol. 4. MySQL sticks this "user agent" into a (new) datastructure somewhere associated with the connection. 5. A (new) API call to MySQL can fetch this information What am I missing here? It seems to me that "all" you are asking for is 1. Change in the wire protocol 2. Design change in the MySQL API 3. Upgrade of all applications using the API in the world 4. Depending on all programs to stick data in this requested "comment" field in the same consistent manner, unless you are asking for more riders/piggybacks and more fields in the wire protocol such as "user agent". Again, what am I missing here? I don't see this as a so-called "trivial" thingy. It maybe could be done in one local place (as first requested), but this isn't trivial, and has no trivial impact, if it is to be used generally. _jef Ansgar Becker wrote: > > > The only thing I would like is to be able to attach a comment to a > > connection id which could be returned by the "mysqladmin process" > > command. And something that would not add more load to Mysql nor > > more coding in the client. > > Yes!! Great idea. This would be helpful for hosters with many > client-connectors to identify them. It could contain for example the name of > the client-application ("useragent"), client-OS and some version-info. i > think 100 chars will do. > > Greetings, Ansgar > http://www.mysqlfront.de/ > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php