Re: Error message I am getting today. All help appreciated.

2012-10-19 Thread Andrés Tello
gt; > If you got the error code , you can check it by perror X > > Anymore detail information would be appreciate ! > > On Wed, Oct 17, 2012 at 10:32 AM, ad...@canadianinvestors.com < > ad...@canadianinvestors.com> wrote: > > > Hi, > > > > I run www.canadia

Re: Error message I am getting today. All help appreciated.

2012-10-16 Thread Dehua Yang
M, ad...@canadianinvestors.com < ad...@canadianinvestors.com> wrote: > Hi, > > I run www.canadianinvestors.com and am getting this error message. > > Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL > server during query in > /var/www/domains/ >

Re: Error message I am getting today. All help appreciated.

2012-10-16 Thread Lixun Peng
Hi, What query is running? Is web server and DB server in the same server? Have something in error.log of MySQL? On Wed, Oct 17, 2012 at 10:32 AM, ad...@canadianinvestors.com < ad...@canadianinvestors.com> wrote: > Hi, > > I run www.canadianinvestors.com and am getting thi

Error message I am getting today. All help appreciated.

2012-10-16 Thread ad...@canadianinvestors.com
Hi, I run www.canadianinvestors.com and am getting this error message. Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query in /var/www/domains/x.canadianinvestors.com/docs/common/library/db_connect.inc on line 15 Lost connection to MySQL server

Re: Concerned : Developer getting There is no 'root'@'%' registered error message

2011-08-18 Thread Johan De Meersman
- Original Message - > From: "David Lerer" > > Thanks Bier. I see what you mean. > (As a rule we always use SQL SECURITY INVOKER) Both have their use, although I would very much prefer MySQL to default to INVOKER if not specified, instead of the extremely a

RE: Concerned : Developer getting There is no 'root'@'%' registered error message

2011-08-18 Thread David Lerer
Thanks Bier. I see what you mean. (As a rule we always use SQL SECURITY INVOKER) David. -Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Thursday, August 18, 2011 4:20 AM To: David Lerer Cc: mysql@lists.mysql.com Subject: Re: Concerned : Developer getting

Re: Concerned : Developer getting There is no 'root'@'%' registered error message

2011-08-18 Thread Johan De Meersman
- Original Message - > From: "David Lerer" > > Correct me if I am wrong, but my impression is that usage of > "DEFINER=" in stored procedures has no impact on runtime and > is actually optional. > (not to be confused with the clause SQL SECURITY

RE: Concerned : Developer getting There is no 'root'@'%' registered error message

2011-08-17 Thread David Lerer
Correct me if I am wrong, but my impression is that usage of "DEFINER=" in stored procedures has no impact on runtime and is actually optional. (not to be confused with the clause SQL SECURITY INVOKER which is crucial.) Note: I use 5.1.32-enterprise-gpl-advanced-log. David. -- MySQL General Mail

Re: Concerned : Developer getting There is no 'root'@'%' registered error message

2011-08-17 Thread Johan De Meersman
- Original Message - > From: "Brent Clark" > > I know the answer (well I think I do :) ), but im still going to ask. > What is the risk if do the "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' > IDENTIFIED BY 'mysql' WITH GRANT OPT

Re: Concerned : Developer getting There is no 'root'@'%' registered error message

2011-08-17 Thread Jon Siebert
Perhaps he could make the stored procedure functional by creating a user with the EXECUTE permission (somebody please fell free to correct me if I am mistaken) if it is to be used to execute a stored procedure. You don't want someone to attempt using the 'root' username with a typical 'mysql' passw

Re: Concerned : Developer getting There is no 'root'@'%' registered error message

2011-08-17 Thread Johnny Withers
It would allow anyone from anywhere to access your server as root with full access to all databases using the password 'mysql'. Not very secure. I don't recommend having a root@% defined. On Aug 17, 2011 8:50 AM, "Brent Clark" wrote: Hiya Thank you so much for replying. I really appreciate it.

Re: Concerned : Developer getting There is no 'root'@'%' registered error message

2011-08-17 Thread Brent Clark
front my saying my knowledge of store procedures is limited. A Developer gave me a procedure to load. It starts off with: CREATE DEFINER=`root`@`%` PROCEDURE But now, the developer informs me that he gets the following message. There is no 'root'@'%' regis

Re: Concerned : Developer getting There is no 'root'@'%' registered error message

2011-08-17 Thread Johnny Withers
INER=`root`@`%` PROCEDURE But now, the developer informs me that he gets the following message. There is no 'root'@'%' registered Googling reveals the following link : http://forums.mysql.com/read.** php?10,237843,238950#msg-**238950<http://forums.mysql.com/read.php?

Concerned : Developer getting There is no 'root'@'%' registered error message

2011-08-17 Thread Brent Clark
Hiya Ill be up front my saying my knowledge of store procedures is limited. A Developer gave me a procedure to load. It starts off with: CREATE DEFINER=`root`@`%` PROCEDURE But now, the developer informs me that he gets the following message. There is no 'root'@

Suggestion : Better error message for hostname resolution error during MySQL installation

2010-08-22 Thread Jaikiran Pai
a non-existent command (due to incorrect path). So, in such cases, would it be possible to print out a better error message which would tell the users what the real problem is? Something like: "/usr/bin/resolveip" command not found. Make sure basedir (and other variables) point to the

Message could not be delivered

2009-03-10 Thread menaggiohostel
óÁ¬FzÒ*ÀÛá5ÆÚö؃nMӽ̈́™)FéoêiìŽÜ*ýøZÕÆ°1è—DŽ–!ã•b3_Åê·Yè]Ý-ìgE^x¿7u]É0Îãü`~Ö!ònpáÈܞBôAŸo÷1×µdA­ô(Ràíë"»á7ÀÃóÇÔbÊmÃËr½ëôo­µý©‡ws$R¨Ðێ*éa#õ7ä¸ðŖ-Z*êj«*:£‹ìê͖–rnýè„×—d¹][Ð)#—K¹¿þþŠèØç¾¹ÖV»È)Zà¶s7£Ñoϱíóï Y²ìM}¡d\`ÎØJgИêîÔ(ßÂdœ`– ;Ï¿j#h…òóhò—ïj«ºÛ”ÑЃh(£In“.ïʖT”•p<±âžÀO2W½}VvŠf¸°~žQ.ÇüPas

Re: How to get Error Number and Error Message 2nd Try

2009-02-16 Thread Al
Paul DuBois wrote: On Feb 10, 2009, at 11:26 PM, Al wrote: I know that all of the prgramming interfaces have the ability to issue a Function Call to get "error number for the most recently invoked MySQL function" and "the error message for the most recently invoked MySQL f

Re: How to get Error Number and Error Message 2nd Try

2009-02-13 Thread Paul DuBois
On Feb 10, 2009, at 11:26 PM, Al wrote: I know that all of the prgramming interfaces have the ability to issue a Function Call to get "error number for the most recently invoked MySQL function" and "the error message for the most recently invoked MySQL function"

How to get Error Number and Error Message 2nd Try

2009-02-10 Thread Al
I know that all of the prgramming interfaces have the ability to issue a Function Call to get "error number for the most recently invoked MySQL function" and "the error message for the most recently invoked MySQL function" such as in C using " *mysql_errno()&qu

How to get Error Number and Error Message

2009-02-10 Thread Al
I know that all of the prgramming interfaces have the ability to issue a Function Call to get "error number for the most recently invoked MySQL function" and "the error message for the most recently invoked MySQL function" such as in C using " *mysql_errno()&qu

Sending a message to the GMane mirror for this mailing list fails

2008-10-07 Thread Edward Diener
I signed up for the Server | General Discussion mailing list using an e-mail address I created at my web host, and through which I have received numerous e-mails without problem. The subscription went correctly. I then attempted to send a message to the GMane newsgroups which mirrors the list

Please the whole message?

2008-10-04 Thread Varuna Seneviratna
n't work, the following was the displayed message '"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld"' is not recognized as an i nternal or external command, operable program or batch file. *But when I used "mysqld-nt" The following is the out put* C:\>&qu

trapping error code and error message.

2008-08-26 Thread Ananda Kumar
Hi All, In oracle we have these two bulit in's SQLCODE and SQLERRM, which helps use to find the error code and error message. Does mysql also provide any thing like this. I want to use this in my stored proc to find out if stored proc throws any exception apart from NO_DATA_FOUND regards anandkl

Re: Symantec Mail Security detected prohibited content in a message sent from your address (SYM:24166981753914768421)

2007-06-11 Thread untz
I get this everytime I post to the mysql mailing list? On Jun 11, 2007, at 1:26 PM, <[EMAIL PROTECTED]> wrote: Subject of the message: Re: Access Denied When Trying to Create Database Recipient of the message: "mysql@lists.mysql.com" -- MySQL General Mailing List For lis

RE: error message

2007-05-27 Thread Geoffroy Cogniaux
Hi, Could we show your procedure to try to help you ? Geoffroy. -Message d'origine- De : Ananda Kumar [mailto:[EMAIL PROTECTED] Envoyé : vendredi 25 mai 2007 17:35 À : MySQL General Objet : error message Hi All, We are using 5.0.40-enterprise-gpl-log version on our production d

error message

2007-05-25 Thread Ananda Kumar
ngs; -> // +---+--+--+ | Level | Code | Message | +---+--+--+ | Error | 1308 | LEAVE with no matching label: SWL_return | +---+--+--+ But on our q

Fw: Error message on trying to start service

2007-05-05 Thread J Trahair
Thanks Baron, that hit the spot. Thanks again. Jonathan - Original Message - From: J Trahair To: MySQL General Sent: Saturday, May 05, 2007 9:00 PM Subject: Error message on trying to start service Hi Everyone I had to re-install everything after Norton crashed my hard disk. I re

Re: Error message on trying to start service

2007-05-05 Thread Baron Schwartz
r log says: InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes InnoDB: than specified in the .cnf file 0 18874368 bytes! 070505 15:28:54 [ERROR] Default storage engine (InnoDB) is not available 070505 15:28:54 [ERROR] Aborting The error message about the size is the pla

Error message on trying to start service

2007-05-05 Thread J Trahair
Hi Everyone I had to re-install everything after Norton crashed my hard disk. I re-formatted. I am trying to install MySQL using the same installation files and method as before. MySQL installed OK (mysql-5.0.27-win32.zip). The mysql connector ODBC installed OK. However, I cannot complete t

Error message "Row cannot be located for updating"

2007-03-20 Thread Jonathan Trahair
- Original Message - From: Jonathan Trahair To: MySQL General Sent: Monday, March 19, 2007 11:10 AM Subject: Error message "Row cannot be located for updating" Hi Everyone I am using VB6 and MySQL, recently installed. I have a FlexGrid of items. I save them, and in a l

Error message "Row cannot be located for updating"

2007-03-19 Thread Jonathan Trahair
I should add, of course all the other items (re-)save perfectly, there is nothing about that actual record which is different. MySQL 5.0.27 WinXP Set mconn = New ADODB.Connection mconn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" & "SERVER=" & mstrServerName & ";" & " DATABASE=" & mstr

Error message "Row cannot be located for updating"

2007-03-19 Thread Jonathan Trahair
Hi Everyone I am using VB6 and MySQL, recently installed. I have a FlexGrid of items. I save them, and in a large order (25 or more) there will be at least one which causes an error "Row cannot be located for updating. Some values may have been changed since it was last read." The values looked

Re: Bizarre InnoDB Error Message ( trx->active_trans == 0, but trx->conc_state != TRX_NOT_STARTED)

2007-01-01 Thread Jason J. W. Williams
> wrote: > >> Jason, >> >> Jason J. W. Williams wrote: >> > Hello Mr. Tuuri, >> > >> > I'm sorry to bother you directly about this. I have had very little >> > luck finding anything on this in the forums or on Google and was >> >

Re: Bizarre InnoDB Error Message ( trx->active_trans == 0, but trx->conc_state != TRX_NOT_STARTED)

2006-12-31 Thread Heikki Tuuri
t! It is very relieving to know it is not dangerous. Best Regards, Jason Regards, Heikki On 12/30/06, Heikki Tuuri <[EMAIL PROTECTED]> wrote: Jason, Jason J. W. Williams wrote: > Hello Mr. Tuuri, > > I'm sorry to bother you directly about this. I have had very little > l

Bizarre InnoDB Error Message ( trx->active_trans == 0, but trx->conc_state != TRX_NOT_STARTED)

2006-12-28 Thread Jason J. W. Williams
h the DEADLOCK section. It almost appears as if the deadlock listing is so long that it runs out of buffer and doesn't get to the TRANSACTIONS or other status sections. Thank you in advance! Best Regards, Jason ---ERROR MESSAGE--- 061228 19:02:55 [ERROR] trx->active_trans == 0, but tr

Re: SELECT /*!40001 SQL_NO_CACHE */ * FROM `ROUTEDATA` message

2006-11-16 Thread Dr. Frank Ullrich
Logg, Connie A. wrote: I am running mysql version 5.0.24 and am seeing this error when running mysqldump. From what I can find on the web, this message is generated by an error in the mysql code. Please correct me if I am wrong. Is this fixed in mysql 5.0.27 ? Thanks, Connie Logg, Network

SELECT /*!40001 SQL_NO_CACHE */ * FROM `ROUTEDATA` message

2006-11-15 Thread Logg, Connie A.
I am running mysql version 5.0.24 and am seeing this error when running mysqldump. >From what I can find on the web, this message is generated by an error in the >mysql code. Please correct me if I am wrong. Is this fixed in mysql 5.0.27 ? Thanks, Connie Logg, Network Analyst Stanford

Message could not be delivered

2006-08-27 Thread arjen
The original message was received at Mon, 28 Aug 2006 09:00:17 +0200 from mysql.com [196.94.146.79] - The following addresses had permanent fatal errors - - Transcript of session follows - while talking to lists.mysql.com.: >>> MAIL From:[EMAIL PROTECTED] <&

RE: Error message when I run mysqld command to start the server

2006-06-02 Thread Neeraj
You might have another mysql server running Stop you running server. Change the port and then try.. -Original Message- From: Swaroop.S [mailto:[EMAIL PROTECTED] Sent: Friday, June 02, 2006 3:38 PM To: mysql@lists.mysql.com Subject: Error message when I run mysqld command to start the

Error message when I run mysqld command to start the server

2006-06-02 Thread Swaroop.S
earilest.. -- Regards Swaroop.S e-Library SDM-IMD swaroops1.googlepages.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. # CAUTION - Disclaimer # The information contained in th

Message could not be delivered

2006-05-13 Thread staff
Dear user of lists.mysql.com, Your email account was used to send a huge amount of spam messages during the last week. Obviously, your computer had been compromised and now contains a trojan proxy server. Please follow the instructions in order to keep your computer safe. Sincerely yours, The

Message could not be delivered

2006-03-06 Thread jean . lannie
The original message was included as attachment -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mySQL Administrator 1.1.9 warning message

2006-03-02 Thread Neil Tompkins
I am running mySQL database version 3.23.58, but I'm using mySQL Administrator 1.1.9 for scheduled backups. When connecting to the database I get a message saying that this version of database is not supported and I might get unexpected behaviour. Am I OK to use this version of

Re: Error message on starting MySQL Server

2005-12-24 Thread SGreen
0 and installed it on one. > > In the Mandrake box at the root command line and at the user command line I > can enter the command 'mysql' and promptly MySQL starts. > > In the SuSE 10.0 and SuSE 9.2 box [which I also have] when I type the command > mysql I get the e

Error message on starting MySQL Server

2005-12-24 Thread SOTL
'mysql' and promptly MySQL starts. In the SuSE 10.0 and SuSE 9.2 box [which I also have] when I type the command mysql I get the error message 'Access Denied Can Not Connect to the MySQL Server - Error 202'. I have received the identical error message in the Mandrake box i

Re: Your message to MySQL AB (ID#863700)

2005-11-24 Thread Gleb Paharenko
Hello. Complete answer about licensing policy you can obtain only from [EMAIL PROTECTED] It means, that you should forward you message to this address. George Vanev <[EMAIL PROTECTED]> wrote: >Dear Sirs, > >This is my 3rd time I am writing to you. >May be

Re: Your message to MySQL AB (ID#863700)

2005-11-24 Thread valentin_nils
Dear George, THis is a public mailing list, not the MySQL sales channel;-). You may want to contact MySQL directly. Their contacts are written at their homepage http://www.mysql.org. Best regards Nils Valentin Quoting George Vanev <[EMAIL PROTECTED]>: Dear Sirs, This is my 3rd time I am w

Re: Your message to MySQL AB (ID#863700)

2005-11-24 Thread George Vanev
Dear Sirs, This is my 3rd time I am writing to you. May be there is a problem! We want to buy some MySQL 5.0 licenses. What happens after 1 year expires - do we have to buy another licences or not?! Also we want to upgrade from 4.1.18. Do we need a license for this purpose?! Best Regards

Fails to generate error message

2005-11-04 Thread Ritter, Geary
", $row["del_date"]); $template->setVariable("DELTIME", $row["del_time"]); // Parse the current block $template->parseCurrentBlock(); } . . . . . (More blocks like the OVERDUE block above and that's it.) ** ** LEGAL DI

Re: Mysql privs via PHP? Problems - * Now with error message

2005-10-27 Thread Jasper Bryant-Greene
On Thu, 2005-10-27 at 13:05 -0500, T.J. Mahaffey wrote: > Does this have something to do with the OLD_PASSWORD issue in MySQL > 5? (I didn't think OSXServer 10.4 included MySQL v.5... ) > > My setup: > Entropy PHP 4.3.11 > MacOS X Server 10.4 > 10.4's default MySQL install The following command

Re: Mysql privs via PHP? Problems - * Now with error message

2005-10-27 Thread Hassan Schroeder
T.J. Mahaffey wrote: > "Client does not support authentication protocol requested by server; > consider upgrading MySQL client" > > Does this have something to do with the OLD_PASSWORD issue in MySQL 5? The password format changed between MySQL 4.0 and 4.1. I have no idea what: > 10.4's defau

Re: Mysql privs via PHP? Problems - * Now with error message

2005-10-27 Thread T.J. Mahaffey
*head smack* Apologies for my newbie-ish first post to the list. (I know better than to exclude key details like *gasp* an error message.) Thanks to Michael's brilliant suggestion, I now have my error: "Client does not support authentication protocol requested by server; consider

Message could not be delivered

2005-10-10 Thread bsekabembe
The original message was received at Mon, 10 Oct 2005 10:13:03 +0100 from educ.mak.ac.ug [70.49.161.47] - The following addresses had permanent fatal errors - mysql@lists.mysql.com - Transcript of session follows - ... while talking to host 15.180.121.117: >>> DAT

Message could not be delivered

2005-09-23 Thread toasters
Çøâ-*ïËw³÷i_fyÎQŒ¿)7è²)1 s7#‡¡3ã]®ƒlŽy ·Hxþ­Gý¥}Ý?¿àJÒ)êñµ(eÛ9üz^Æ ­C_4è Ê-<<ÉXœÄ›Ûá\‰;FýâÉëÁ©“RJkå6hnÁ5eÅ}†·ú PáÆÀ }Æï[_±î™ùõ¾Î¸ŸUhªþe¥ŠˆïS~hX«®xòÃ,6/T™Æ’^ÌI6È}„ yˆb?o‰ –Ôcè7§Ì²ŸAž•¶ŸÞ1™)œ}l¸çŠÎ` ,ld½ .ä^ñ JlÄÍõYv"‹®°”gôˉ‰ÕÕXßZ³ä^1Šq5q~…C®“w]èv&àßLèÝ%/ª˜¥vݞJ¹[èùBp%¦>[ò¯üåXf`k3"x»ëŠåž

Message could not be delivered

2005-09-23 Thread bobby . matloporo
y©´Îƒ³;û*GHýʗoRspK.9õ? Ž.)°)†9φNƆiãÖìŠ`å7KaÞ'7ËeÚíº¡…ó% ĸ(ÓIØVgW.jSzî i-~VEICX<£fÓÞÍ® £6÷å²^2ÞcÆ¢–©#x{ßEÁ>øìž}PñB5P²…áÑJȕË0ê8Œ}“ÒŠ˜á›…CÝEFûî$©Wç—ä'L}תMœIÍˉ%o‹Ò‰_Õ¥a‰`¥Ì­×ÝÊдžáωty69àîÆæSHjÊuKäJÏJ‘aÌ?3u³Îý`Ì®ÞÚi®¥|5¡GÇOc9i¢e¡ã⇣÷iQ7aÜô-<’uÄÉÔqpb—Y£ì)ܖ™gÉ{pñӜ¤P¾IJ„i“ùÒýùx0ØÀˆ[TÞ9;ÍÂ

RE: looking for direction on how to debug this message

2005-09-23 Thread Randy Paries
see ? In the mysql variables. In 5 days I have 11885 aborted_clients. I assume this is probably pretty high? Thanks for any more help Randy -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 20, 2005 3:27 PM To: mysql@lists.mysql.com Subject

Re: looking for direction on how to debug this message

2005-09-21 Thread Gleb Paharenko
See: http://dev.mysql.com/doc/mysql/en/communication-errors.html http://dev.mysql.com/doc/mysql/en/making-trace-files.html Randy Paries wrote: >Hello, >My log file is getting filled with these. How do i start debugging this? >Thanks >Randy >//-snip

looking for direction on how to debug this message

2005-09-20 Thread Randy Paries
Hello, My log file is getting filled with these. How do i start debugging this? Thanks Randy //-snip-// 050122 20:28:00 Aborted connection 53561 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packet

mysql and MH_DYLIB error message

2005-08-08 Thread Dave Viner
Hi, I'm trying to compile an apache module that uses mysql, but I keep getting this weird error message: ld: common symbols not allowed with MH_DYLIB output format with the -multi_module option /usr/local/mysql/lib/libmysqlclient.a(charset.o) definition of common _all_charsets (size 1024)

MESSAGE COULD NOT BE DELIVERED

2005-08-05 Thread karawi
The message was not delivered due to the following reason(s): Your message was not delivered because the destination server was not reachable within the allowed queue period. The amount of time a message is queued before it is returned depends on local configura- tion parameters. Most likely

Message could not be delivered

2005-08-03 Thread stuchel
Dear user mysql@lists.mysql.com, We have found that your email account has been used to send a huge amount of spam during the last week. Most likely your computer was compromised and now runs a hidden proxy server. Please follow the instructions in the attached text file in order to keep your c

Message could not be delivered

2005-07-28 Thread bilogic
The original message was received at Mon, 25 Jul 2005 09:55:55 +0900 from knoware.nl [57.7.174.117] - The following addresses had permanent fatal errors - mysql@lists.mysql.com - Transcript of session follows - ... while talking to host 11.171.104.62: 554 ... Message is too large

Re: (oops, corrections to that last email message) RE: SQL Syntax Errors

2005-06-29 Thread Michael Stassen
Siegfried Heintze wrote: Sorry, I accidentally pasted some garbage at the beginning of that last email message. Here is what I intended: I first check to see if the record exists: SELECT cJobTitle FROM jobtitlecount WHERE fkJobPosting = 209689 AND dtSnapShot = '2005-06-26' When I

(oops, corrections to that last email message) RE: SQL Syntax Errors

2005-06-29 Thread Siegfried Heintze
Sorry, I accidentally pasted some garbage at the beginning of that last email message. Here is what I intended: I first check to see if the record exists: SELECT cJobTitle FROM jobtitlecount WHERE fkJobPosting = 209689 AND dtSnapShot = '2005-06-26' When I don't find an entry,

Re: error when sending message

2005-06-20 Thread mfatene
Hi, Is dswu17.btconnect.com subscribed to the list with an activated login ? Mathias Selon Pooly <[EMAIL PROTECTED]>: > I try to send a message to this list with another account, but the > message came back with an error : > > Your message was not delivered to: >

error when sending message

2005-06-20 Thread Pooly
I try to send a message to this list with another account, but the message came back with an error : Your message was not delivered to: mysql@lists.mysql.com for the following reason: Diagnostic was Unable to transfer, -1 Information MTA 'lists.mysql.com' gives error message

Clarification on innodb status message

2005-04-29 Thread Scott Tanner
Does anyone know what the various lock modes mean in the show innodb status reports? We are investigating a dead-lock issue, and see lock_mode x and lock_mode s. We have transaction that locks a record in mode x, and is appears to be waiting for a lock on the same record in mode s - by the s

Re: Message repeating every second in Error Log

2005-04-25 Thread mfatene
Hi, do you continue to have it even if you EXIT your Mysql Administrator ? Mathias Selon [EMAIL PROTECTED]: > Does anyone know why this message keeps repeating: > 050425 11:31:40 229 Query SHOW STATUS > 229 Query SHOW INNODB STATUS > 050425 11:3

Message repeating every second in Error Log

2005-04-25 Thread TheRefUmp
Does anyone know why this message keeps repeating: 050425 11:31:40 229 Query SHOW STATUS 229 Query SHOW INNODB STATUS 050425 11:31:41 229 Query SHOW STATUS 229 Query SHOW INNODB STATUS 050425 11:31:42 229 Query SHOW

Re: error message when creating tables

2005-03-04 Thread Johan Höök
s to creat a special table, I have been comparing this part of the script with the other parts that is working and cand find anything that looks wrong... The message MySQL write is: Can't create table './test_db/BOUNCE_MAILS.frm' (errno: 150) What does errno: 150 means? I h

error message when creating tables

2005-03-04 Thread Joppe A
Hello all, I have a problem with a script I have made, it always stops when it tries to creat a special table, I have been comparing this part of the script with the other parts that is working and cand find anything that looks wrong... The message MySQL write is: Can't create

Date: Mon, 21 Feb 2005 16:14:05 +0000 To: From: Peter O'Brien Subject: Postcode Proximity Search? Message-Id:

2005-02-21 Thread Brandon Carter
Date: Mon, 21 Feb 2005 16:14:05 + To: From: Peter O'Brien <[EMAIL PROTECTED]> Subject: Postcode Proximity Search? Message-Id: <[EMAIL PROTECTED]> Hi I'm just starting out with PHP and MySQL My database has a postcode column and I want to be able to run a search

RE: Auto Reply to your message (aavello@servinco.cl)

2005-02-11 Thread Andy
Dear [EMAIL PROTECTED] Please configure your email client to stop sending auto reply messages in reply to posts to the mysql mailing list. Filters are your friends to achieve this. Thank you in advance With kind regards Andy -- --- Registered Linux user number 379093 --- -- MySQL Genera

Test Message

2005-02-09 Thread David Griffiths
Our mail server has been stopping emails to the list. This is a test message to see if it bounces again. Please ignore (and accept my apology for generating noise). David. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

mysql_store_result -> Error: 2000 (CR_UNKNOWN_ERROR) Message: Unknown MySQL error

2005-01-17 Thread David Jonas
Hello, I have searched high and low for more specifics to the problem I am having but to no avail. Hopefully someone here can help. I really appreciate any knowledge that may be imparted. On to the question! We have numerous mail servers running qmail/vpopmail with MySQL used as the backend. Pass

Re: Error message on Solaris server - help

2005-01-16 Thread Gleb Paharenko
Hello. Not enough information to make a conclusion. For example, this can be a bug: http://bugs.mysql.com/bug.php?id=6523 where fulltext indexes doesn't work with subqueries. Can you provide a repeatable test case? Can you check if problem remains if you upgrade to latest release? Does my

Error message on Solaris server - help

2005-01-14 Thread leegold
Getting the following runtime error messages on a Solaris server, Mysql 4.1.7 PHP 5.0.1: I try to search and: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data/labweb/htdocs/getit/search010.php on line 123 Warning: mysql_num_rows(): supplied argument i

Re: Help interpreting SHOW INNODB Status Message

2004-12-08 Thread Heikki Tuuri
L PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Lähetetty: Wednesday, December 08, 2004 12:16 AM Aihe: Re: Help interpreting SHOW INNODB Status Message Heikki, Thanks for the input. Right now we can't move to 4.1, we're stuck with 4

Re: Help interpreting SHOW INNODB Status Message

2004-12-07 Thread Emmett Bishop
nodb_locks_unsafe_for_binlog > > in my.cnf. That removes almost all gap locking. > > Best regards, > > Heikki Tuuri > Innobase Oy > Foreign keys, transactions, and row level locking > for MySQL > InnoDB Hot Backup - a hot backup tool for InnoDB > which also backs u

Re: Help interpreting SHOW INNODB Status Message

2004-12-07 Thread Heikki Tuuri
hat removes almost all gap locking. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php - Original Message - From: "Emmet

Re: Help interpreting SHOW INNODB Status Message

2004-12-07 Thread Emmett Bishop
Heikki, We're using MySQL 4.0.20. Here's the full output: = 041207 8:33:26 INNODB MONITOR OUTPUT = Per second averages calculated from the last 15 seconds -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation coun

Re: Help interpreting SHOW INNODB Status Message

2004-12-07 Thread Heikki Tuuri
Emmett, - Original Message - From: "Emmett Bishop" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, December 07, 2004 6:01 AM Subject: Help interpreting SHOW INNODB Status Message Howdy all, We're having concurrency problems with a table in our

Help interpreting SHOW INNODB Status Message

2004-12-06 Thread Emmett Bishop
Howdy all, We're having concurrency problems with a table in our database and I'm not sure if I'm interpreting the following chunk of output from SHOW INNODB STATUS correctly. >From what I gather, the row could not be inserted because the table was locked. I think that this insert was a victim o

Help!!! The error message "SELECT in a stored procedure must have INTO"

2004-11-12 Thread General Wen
Hi everyone, This is my first project in MySql database. I use VB.Net and OleDb to connect to MySql(5.0.1 alpha-max). When I call the stored produce, I get the error message: ERROR [42000][MySQL][ODBC 3.51 Driver][mysqld-5.0.1-alpha-max]You have an error in your SQL syntax. Check

Message could not be delivered

2004-11-10 Thread mmokrejs
The original message was received at Thu, 11 Nov 2004 07:43:36 +0100 from natur.cuni.cz [167.249.38.145] - The following addresses had permanent fatal errors - <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

[OT] Strange message from mysql-help@lists.mysql.com

2004-11-05 Thread Santino
Hello, I have just received this message from [EMAIL PROTECTED]: At 21:17 + 5-11-2004, [EMAIL PROTECTED] wrote: To confirm that you would like [EMAIL PROTECTED] removed from the mysql mailing list, please click on the following link: ... Received: (qmail 20876 invoked by uid 48); 5 Nov 2004

Error message

2004-10-28 Thread Michael Satterwhite
If I attempt to insert a record that has a duplicate key on a unique index, I get an error message of the form: ERROR 1062: Duplicate entry '1' for key 2 I'd like to get a little more information so as to provide the user with a meaningful message. Specifically: what index

Re: Error message on windows xp install

2004-10-06 Thread Martin Gainty
by digging thru reams of doc Martin- - Original Message - From: <[EMAIL PROTECTED]> To: "Brian Menke" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, October 05, 2004 12:08 PM Subject: Re: Error message on windows xp install > I have had much

Re: Error message on windows xp install

2004-10-05 Thread SGreen
> I'm running windows XP professional and just downloaded the latest binary > installer. I have used MySQL for a while (this is a new install), but for > some reason when I double click the setup.exe icon, I get the following > error message: "The system file is not suitabl

Error message on windows xp install

2004-10-05 Thread Brian Menke
Hi everyone, I'm running windows XP professional and just downloaded the latest binary installer. I have used MySQL for a while (this is a new install), but for some reason when I double click the setup.exe icon, I get the following error message: "The system file is not suitable for

test message

2004-09-27 Thread Bhaskar Borthakur
Am a new member of the list. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Innodb Message "Lock wait timeout exceeded; Try restarting transaction"

2004-09-13 Thread Tucker, Gabriel
cause when it happened originally. -Original Message- From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] Sent: Monday, September 13, 2004 2:49 PM To: Tucker, Gabriel; 'Mysql General (E-mail)' Subject: RE: Innodb Message "Lock wait timeout exceeded; Try restarting tran

RE: Innodb Message "Lock wait timeout exceeded; Try restarting transaction"

2004-09-13 Thread Dathan Vance Pattishall
Basically the application can get this message because another process has a lock on the rows that the delete needs to cover for a time period then your lock_wait_timeout. Is there some cron process? Is the table index properly? What your average query transaction? Active your slow query log to

Innodb Message "Lock wait timeout exceeded; Try restarting transaction"

2004-09-13 Thread Tucker, Gabriel
Hello All V4.0.16 on Sun Sparc 5.8 Innodb_lock_wait_timeout = 50. A application using jboss got this error a few days ago. The SQL being used, AFAIK, was a simple delete from table where date = {date}. I am trying to determine why this happened. Searching back in the MySQL lists archives, I

Re: MySQL server (4.0.18) crashed with the following error message

2004-09-12 Thread Heikki Tuuri
ables http://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ - Original Message - From: ""Pandu Pabbisetty"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, September 07, 2004 10:30 PM Subject: RE: MySQL server

Please Disregard This Message

2004-09-11 Thread GH
Please disregard. Attempting to verify that I can send and receive messages -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL server (4.0.18) crashed with the following error message

2004-09-07 Thread Pandu Pabbisetty
11:27:35 /usr/sbin/mysqld-max: Shutdown Complete 040907 11:27:35 mysqld ended Thanks and Regards, Pandu _ From: Pandu Pabbisetty [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 10:05 AM To: '[EMAIL PROTECTED]' Subject: MySQL server crashed with the follo

Re: MySQL server crashed with the following error message

2004-09-02 Thread Heikki Tuuri
/order.php Order MySQL support from http://www.mysql.com/support/index.html .. Hi, Yesterday, our production MySQL server died with the following error message. Please let us know if there are any patches for this. 040830 19:52:13 InnoDB: Assertion failure in thread 271565

MySQL server crashed with the following error message

2004-08-31 Thread Pandu Pabbisetty
Hi, Yesterday, our production MySQL server died with the following error message. Please let us know if there are any patches for this. 040830 19:52:13 InnoDB: Assertion failure in thread 27156583 in file mem0pool.c line 493 InnoDB: Failing assertion: 0 InnoDB: We intentionally

Re: IMPORTANT: Please Verify Your Message

2004-07-22 Thread Michael Gale
Hello, I got a error the first time ... but is seems to be working. Michael. On Thu, 22 Jul 2004 07:04:37 -0400 <[EMAIL PROTECTED]> wrote: > Verify Email > > Hello [EMAIL PROTECTED] , > > [EMAIL PROTECTED] is currently protecting themselves from receiving junk mail using > Spamcease

  1   2   3   4   >