Re: Character Set problem
Gleb Paharenko wrote: Thanks for the reply. See: http://dev.mysql.com/doc/mysql/en/problems-with-character-sets.html Yeah Thanks - seen that already. Check that you have the charsets directory in c:\mysql\share. Again, thanks, but that doesn't actually solve the issue. There are entries in the Index file for the appropriate language number. There isn't, however, an xml file for the language (utf8 in this instance). I've tried changing the server default character set to cp1251. I've recreated complete databases from scratch making sure that the character set it uses is cp1251. None of the above have worked. Any other thoughts? This is mySQL 4.1.10-nt on win2003 server giving : File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 22) Character set '#33' is not a compiled character set and is not specified in the 'c:\mysql\share\charsets\Index' file which is classified as Bug number 312 (http://bugs.mysql.com/bug.php?id=312) Regards Stephen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Character Set problem
Hi there, I'm on mysql 4.1.10a on Windows 2003 Server. I'm getting : File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 22) Character set '#33' is not a compiled character set and is not specified in the 'c:\mysql\share\charsets\Index' file when some PHP applications try accessing their database. I know this is classified as Bug number 312 (http://bugs.mysql.com/bug.php?id=312). I've read through all the supposed fixes and other posts all over the place, but, to be honest, I'm confused. I'm not really sure what the fix is. Is there actually a fix? If there is a fix, would someone be kind enough to give me an idiots guide on what to do please? Regards Stephen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQL
Diner Akay wrote: Hi, My Table No | Type | ID [snip] Select random No (i know rand()) Select two row (i know limit 0,2) Select Type v,h or h,v but dont want v,v or h,h How about selecting one random row where Type is v and one where Type is h and then UNIONing the two record sets? Stephen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with an insert query
GH wrote: I am trying to insert data in the ProgressNotes Table using the following query but it does not work. Can someone please assist? Thank You. [snip] 'Understandably, the consumers were upset. The Dean (SR) was kind enough to try and help explain to our members that there was a communications problem that caused the paperwork not to be completely in place before we started the program. LL and I got the members' phone numbers so that we can advise them if we are canceled next week. [snip] You've got a single apostrophe after members in the text above. If you want it to insert the apostrophe, it needs to be escaped or doubled up. ...and I got the members'' phone numbers so There may be others, but that was the only one I could find. You'll probably find that the other error relating to the select count(*)... may well disappear when you fix this. Hope this helps Stephen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: List annoyance
Jochem van Dieten wrote: On Wed, 10 Nov 2004 07:42:29 +, Stephen Moretti (cfmaster) wrote: Why is this list reply to sender and not reply to list? Why don't you read the FAQ? Ah right. I see - a 2 year old article - http://www.unicom.com/pw/reply-to-harmful.html Completely disagree with this in terms of mail list management, especially when you read through the interesting summary, but I'll bow to mysql.com feelings on this. Still it : It is really bl annoying Does mean that the list archive is incomplete and therefore less useful. Does mean that I have to waste time cleaning up after this one list when I have quite enough email to handle as it is. But as I say I'll bow to mysql.com's beliefs and drop it. Stephen -- Registration for MX Europe 2005 is now open. http://www.mxeurope.org/go/registration Early bird discounts available. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error After Upgrading 3.23.58 - 4.1.7
Jason Williard wrote: I recently upgraded MySQL from 3.23.58 to 4.1.7 on a Fedora Core 1 system. After the upgrade, I ran into the following error with a previously installed copy of Bugzilla. I think the core of the error is Client does not support authentication protocol requested by server. [snip] So far, my research shows that the issue may be with the Client. This is where my knowledge is failing me as I am unsure of how to upgrade the Client. The install was done from source, as I have always found this to be the most stable method of upgrading. Any assistance would be appreciated. http://dev.mysql.com/doc/mysql/en/Old_client.html -- Registration for MX Europe 2005 is now open. http://www.mxeurope.org/go/registration Early bird discounts available. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
List annoyance
Why is this list reply to sender and not reply to list? Its annoying getting duplicated responses when someone replies to a message you send to the list. Its annoying getting single responses that are out of context and its annoying if responses go to the questioner personally, when the response may be of interest to other members of the list. Just a suggestion, but please make the list reply to list and not reply to sender. Thanks Stephen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Over enthusiatic installer of 4.1 makes mistake....
Ok - feeling a bit embarrassed and sheepish really In my rush to try out 4.1.7 I did the typical techie thing - I didn't bother RTFM before starting installing, other than the bit that says you have to uninstall earlier versions mySQL. So I've got 4.1.7 all up and running on my dev machine - great - but some moron forgot to make backups of all the databases on his machine before uninstalling! I've got all these folders with my databases in, but none of them available via my shiney new installation. Is there anyway to get the databases into the server? Its no great shakes if I can't recover them, being my dev machine, but would be nice if I can get them into the server. Any suggestions? TIA and regards from a very foolish feeling Stephen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
