Re: Incorrect key file for table
On Sat, Jan 15, 2011 at 8:07 AM, Jørn Dahl-Stamnes sq...@dahl-stamnes.netwrote: On Saturday 15 January 2011 00:28, Johnny Withers wrote: The result of your query without the join probably exceeded your tmp_table_size variable. When this occurs, MySQL quit writing the temp table to disk thus producing an incorrect table file. (I think). Yes, part of this was my fault (the missing join) but I still wonder why the server processed the query. Would it not be more appropriate with an error message saying that this query contain an error? Most likely (too lazy to actually check :-p ) your SQL was syntacticlaly correct, so it tried to answer the question you asked. Which, unfortunately, was not the question you wanted to ask :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
Re: Install Error - How to Fix
in windows command,run sc delete SERVICENAME. Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2011/1/15 AndrewMcHorney andrewmchor...@cox.net: Hello At one time I had (or at least partially) installed mysql on my laptop. I went to install a new version and I am getting the following error: A windows service with the name MySql already exists. Please uninstall this service correctly or choose a different name for the new service. How do I uninstall this service? Thanks, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=amoiz.sh...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: linking to mysql in C
You are missing the libmysqlclient. I guess the problem is your makefile. make != shell You CFLAGS should have something like this: -L/usr/lib/mysql -lmysqlclient (Actualy it should be LDFLAGS and LOADLIBES) something like $(shell pkg-config --cflags $(packages) ) should work further reading: http://www.gnu.org/software/make/manual/make.html#Shell-Function hope that helps, re, wh Am 08.01.2011 06:06, schrieb Delan Azabani: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, This is a novice problem I'm having with compiling a C CGI program with MySQL on my Gentoo box. I have a simple source so far: * cbook-main.c: http://pastebin.com/vnT6j1z2 * cbook-main.h: http://pastebin.com/4BnyWs27 * Makefile: http://pastebin.com/m973gbjG When compiling I receive undefined reference errors: delan@delan2 ~/cbook $ make make cbook-main make[1]: Entering directory `/home/delan/cbook' cc -g `pkg-config --cflags libconfuse glib-2.0` `mysql_config --cflags` - -c cbook-main.c make[1]: Leaving directory `/home/delan/cbook' cc `pkg-config --libs libconfuse glib-2.0` `mysql_config --libs` -o cbook.cgi cbook-main.o cbook-main.o: In function `myerror': /home/delan/cbook/cbook-main.c:61: undefined reference to `mysql_error' /home/delan/cbook/cbook-main.c:61: undefined reference to `mysql_errno' cbook-main.o: In function `myescape': /home/delan/cbook/cbook-main.c:67: undefined reference to `mysql_real_escape_string' cbook-main.o: In function `myquery': /home/delan/cbook/cbook-main.c:85: undefined reference to `mysql_query' cbook-main.o: In function `createDatabase': /home/delan/cbook/cbook-main.c:90: undefined reference to `mysql_select_db' cbook-main.o: In function `pageHome': /home/delan/cbook/cbook-main.c:144: undefined reference to `mysql_store_result' /home/delan/cbook/cbook-main.c:146: undefined reference to `mysql_fetch_row' /h -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Install Error - How to Fix
I tried that - I am getting an access denied erorr of 5. At 06:34 AM 1/15/2011, Sharl.Jimh.Tsin wrote: in windows command,run sc delete SERVICENAME. Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2011/1/15 AndrewMcHorney andrewmchor...@cox.net: Hello At one time I had (or at least partially) installed mysql on my laptop. I went to install a new version and I am getting  the following error: A windows service with the name MySql already exists. Please uninstall this service correctly or choose a different name for the new service. How do I uninstall this service? Thanks, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:   http://lists.mysql.com/mysql?unsub=amoiz.sh...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Install Error - How to Fix
Sounds like you have not the permissions Which way was the old version installed? Why not remove the old version with the control panel - software? Am 15.01.2011 18:41, schrieb AndrewMcHorney: I tried that - I am getting an access denied erorr of 5. At 06:34 AM 1/15/2011, Sharl.Jimh.Tsin wrote: in windows command,run sc delete SERVICENAME. Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2011/1/15 AndrewMcHorney andrewmchor...@cox.net: Hello At one time I had (or at least partially) installed mysql on my laptop. I went to install a new version and I am getting  the following error: A windows service with the name MySql already exists. Please uninstall this service correctly or choose a different name for the new service. How do I uninstall this service? Thanks, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:   http://lists.mysql.com/mysql?unsub=amoiz.sh...@gmail.com signature.asc Description: OpenPGP digital signature
Re: Install Error - How to Fix
I installed everything using the standard gui install. I tried to uninstall Mysql and it says I am not an administrator even though I am logged in as one. At 10:16 AM 1/15/2011, Reindl Harald wrote: Sounds like you have not the permissions Which way was the old version installed? Why not remove the old version with the control panel - software? Am 15.01.2011 18:41, schrieb AndrewMcHorney: I tried that - I am getting an access denied erorr of 5. At 06:34 AM 1/15/2011, Sharl.Jimh.Tsin wrote: in windows command,run sc delete SERVICENAME. Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2011/1/15 AndrewMcHorney andrewmchor...@cox.net: Hello At one time I had (or at least partially) installed mysql on my laptop. I went to install a new version and I am getting  the following error: A windows service with the name MySql already exists. Please uninstall this service correctly or choose a different name for the new service. How do I uninstall this service? Thanks, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:   http://lists.mysql.com/mysql?unsub=amoiz.sh...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Install Error - How to Fix
sounds like vista/win7 and UAC what has nothing to do with mysql http://technet.microsoft.com/en-us/library/cc709691%28WS.10%29.aspx no idea, not using windows-crap since 2006 with the exception of Server 2008 R2 for our VMware-vCenter-Server, and yes on this machine you can not open many folders as administrator get a real operating system :-) Am 15.01.2011 20:10, schrieb AndrewMcHorney: I installed everything using the standard gui install. I tried to uninstall Mysql and it says I am not an administrator even though I am logged in as one. At 10:16 AM 1/15/2011, Reindl Harald wrote: Sounds like you have not the permissions Which way was the old version installed? Why not remove the old version with the control panel - software? Am 15.01.2011 18:41, schrieb AndrewMcHorney: I tried that - I am getting an access denied erorr of 5. At 06:34 AM 1/15/2011, Sharl.Jimh.Tsin wrote: in windows command,run sc delete SERVICENAME. Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2011/1/15 AndrewMcHorney andrewmchor...@cox.net: Hello At one time I had (or at least partially) installed mysql on my laptop. I went to install a new version and I am getting  the following error: A windows service with the name MySql already exists. Please uninstall this service correctly or choose a different name for the new service. How do I uninstall this service? Thanks, Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:   http://lists.mysql.com/mysql?unsub=amoiz.sh...@gmail.com -- Mit besten Grüßen, Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / software-development / cms-solutions p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ signature.asc Description: OpenPGP digital signature
Re: Incorrect key file for table
On 1/15/2011 02:07, Jørn Dahl-Stamnes wrote: On Saturday 15 January 2011 00:28, Johnny Withers wrote: The result of your query without the join probably exceeded your tmp_table_size variable. When this occurs, MySQL quit writing the temp table to disk thus producing an incorrect table file. (I think). Yes, part of this was my fault (the missing join) but I still wonder why the server processed the query. Would it not be more appropriate with an error message saying that this query contain an error? The error was only logical. The SQL syntax was fine. The MySQL server has no other way to gauge the accuracy of what you intended the query to be. for example, this is perfectly legal SQL: SELECT * FROM table1, table2; Even if you had used explicit JOIN operators, the use of an ON clause is still optional. Here is my same example rewritten to use the JOIN operator. SELECT * FROM table1 INNER JOIN table2; Again, this is a perfectly legal statement, even if it may not make logical sense in the context of your application or data to leave out the joining criteria. -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org