bug report
When starting mysqld, I got the err message (in file) 051005 05:26:47 mysqld started 051005 5:26:47 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43902 InnoDB: Doing recovery: scanned up to log sequence number 0 43902 051005 5:26:47 InnoDB: Error: trying to access a stray pointer 88b8fff8 InnoDB: buf pool start is at 8b8, end at 938 InnoDB: Probable reason is database corruption or memory InnoDB: corruption. If this happens in an InnoDB database recovery, InnoDB: you can look from section 6.1 at http://www.innodb.com/ibman.html InnoDB: how to force recovery. 051005 5:26:47 InnoDB: Assertion failure in thread 137490432 in file ../../innobase/include/buf0buf.ic line 261 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to mysql@lists.mysql.com mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=268435456 read_buffer_size=1044480 Fatal signal 11 while backtracing 051005 05:26:47 mysqld ended -- Pierre-Henry Perret
are concurent queries serialized ?
hi, I run a web server on a linux box from which PHP connect to a mySQL 4 server running on another linux box. tis works well but when the number of concurent connection/queries go high, the DB server runs very slowly. while trying to find a fix to this problem, I've been told that whatever the number of concurent queries the DB server receive, it process them thru a queue, that no more than 1 query may be performed by mySQL at a time. is this true ? true or not, will I gain speed by by preventing the web server to perform too many connections/queries at the same time? I mean, will 1 connection/queries be executed faster if there is at most 25 concurent queries than if there are 100 or more concurent connections/queries? (by queries, I mean a mix of select (lot) and update (few)) TIA, Pierre.
Master Slave Problem.
Hi Bug Team, I have set up a Master Slave System with MySQL 4.0.20. I've done completing every task from 6.4 How to Set Up Replication. But my problem is : 040624 14:44:44 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 040624 14:44:45 While trying to obtain the list of slaves from the master '164.23.43.160:3306', user 'Replikator' got the following error: 'the master returned an invalid number of fields for SHOW SLAVE HOSTS' 040624 14:44:45 Slave I/O thread exiting, read up to log 'FIRST', position 4 I have not found any support for this problem :( Your Faithfully Pierre Rousseau Deutsche Telekom AG T-Com, Technische Infrastruktur Niederlassung Nord Pierre Rousseau E-Mail: mailto:[EMAIL PROTECTED] Internet: http://www.t-com.net Diese E-Mail könnte vertrauliche und/oder rechtlich geschützte Informationen enthalten. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail sind nicht gestattet. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Master Slave Problem.
Re: Master Slave Problem : mysql show slave status\G *** 1. row *** Master_Host: 164.23.43.160 Master_User: Replikator Master_Port: 3306 Connect_retry: 60 Master_Log_File: Read_Master_Log_Pos: 1934 Relay_Log_File: WIH00106-relay-bin.015 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL_Running: Yes Replicate_do_db: Replicate_ignore_db: Last_errno: 0 Last_error: Skip_counter: 0 Exec_master_log_pos: 0 Relay_log_space: 4 1 row in set (0.00 sec) --- and my.ini file : [mysqld] master_host=164.23.43.160 master_user=Replikator master_password=hackmack23 master_port=3306 server_id=10 [WinMySQLAdmin] Server=D:/databank/bin/mysqld-nt.exe note : user/pw correct :( -Pierre Rousseau -x--Ursprüngliche Nachricht- -x-Von: Kieran Kelleher [mailto:[EMAIL PROTECTED] -x-Gesendet: Donnerstag, 24. Juni 2004 22:05 -x-An: Rousseau, Pierre -x-Cc: [EMAIL PROTECTED] -x-Betreff: Re: Master Slave Problem. -x- -x- -x-Log into the slave and do this command -x-mysql mysql show slave status\G -x- -x-. what do you see? -x- -x-Also, what is in your my.cnf file on the slave? -x- -x-FYI, here is instructions on how I set up replication last week -x-http://homepage.mac.com/kelleherk/iblog/C711669388/E35122010 -x-0/index.html -x- -x--Kieran -x- -x- -x- -x-Config = OS X 10.3.4 / Java 1.4.2 / WO 5.2.3 / XCode v1.2 / MySQL -x-4.0.20 / Connector-J 3.0.11 -x-Blog: http://webobjects.webhop.org/ -x- -x- -x-On Jun 24, 2004, at 9:15 AM, Rousseau, Pierre wrote: -x- -x- Hi Bug Team, -x- -x- I have set up a Master Slave System with MySQL 4.0.20. I've done -x- completing every task from 6.4 How to Set Up Replication. -x- -x- But my problem is : -x- 040624 14:44:44 Slave I/O thread: connected to master -x- '[EMAIL PROTECTED]:3306', replication started in -x-log 'FIRST' -x- at position 4 -x- 040624 14:44:45 While trying to obtain the list of -x-slaves from the -x- master '164.23.43.160:3306', user 'Replikator' got the following -x- error: 'the master returned an invalid number of fields -x-for SHOW SLAVE -x- HOSTS' -x- 040624 14:44:45 Slave I/O thread exiting, read up to log -x-'FIRST', -x- position 4 -x- -x- I have not found any support for this problem :( -x- -x- Your Faithfully -x- Pierre Rousseau -x- -x- Deutsche Telekom AG -x- T-Com, Technische Infrastruktur Niederlassung Nord -x- Pierre Rousseau -x- E-Mail: mailto:[EMAIL PROTECTED] -x- Internet: http://www.t-com.net -x- -x- Diese E-Mail könnte vertrauliche und/oder rechtlich geschützte -x- Informationen enthalten. Wenn Sie nicht der richtige -x-Adressat sind oder -x- diese E-Mail irrtümlich erhalten haben, informieren Sie -x-bitte sofort -x- den -x- Absender und vernichten Sie diese Mail. Das unerlaubte -x-Kopieren sowie -x- die -x- unbefugte Weitergabe dieser Mail sind nicht gestattet. -x- -x- This e-mail may contain confidential and/or privileged -x-information. If -x- you -x- are not the intended recipient (or have received this -x-e-mail in error) -x- please notify the sender immediately and destroy this e-mail. Any -x- unauthorised copying, disclosure or distribution of the -x-material in -x- this -x- e-mail is strictly forbidden. -x- -x- -x- -- -x- MySQL General Mailing List -x- For list archives: http://lists.mysql.com/mysql -x- To unsubscribe: -x- http://lists.mysql.com/[EMAIL PROTECTED] -x- -x- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help about a db
Hi all, I have the following data Users : user(varchar), entreprise_1(int), entreprise_2(int) Entreprise: idx(int, prim, auto_incr), code(varchar) some users have one entreprise, and some two. if I decide that 'no entreprise x' is coded with entreprise_x=0, i have obviously a problem with SELECT Users.* FROM Users, Entreprise Entreprise1, Entreprise Entreprise2 WHERE entreprise_1=Entreprise1.idx AND entreprise_2=Entreprise2.idx AND (Entreprise1.code='CODEX' OR Entreprise2.code='CODEX'); since SELECT Users.* FROM Users, Entreprise Entreprise1, Entreprise Entreprise2 WHERE entreprise_1=Entreprise1.idx AND entreprise_2=Entreprise2.idx returns 0 tuples when entreprise_2=0 In fact, i'm looking for the smartest way to code 'nothing'. For the moment, i've created the Enterprise 'dummy' (idx=0, code='VOID'), but i absolutely not satisfied with this solution. Any idea ? Thank you all by advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
TIMESTAMP decimal year format available?
Hi, I am using mysql and I need to store timestamp. In input I got something like yyy-dddThh:mm:ss, ddd beeing the day of the year! I would like to make the minimun transformation before loading data in database, so I would like to enter the timestamp with a format handling decimal year yyy.ddd but AFA I understand the mysql doc, it seems not available? Any advice or information would be welcome, thanks in advance, -- Pierre -- DIDELON :@: pdidelon_at_cea.frPhone : 33 (0)1 69 08 58 89 CEA SACLAY - Service d'Astrophysique 91191 Gif-Sur-Yvette Cedex -- PS : I'm using v 4.0.14 on WinXP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Commercial Licence
I want to run a commercial product based on MySQL. I have one centralized server running MySQL in replication mode (master server). I have five clients running MySQL (each slave is running one MySQL daemon). Do I have to acquire only one commercial licence for my master server or do I have do get commercail licence for master and slave. Thanks in advance. mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication: Setting up a slave with LOAD DATA FROM MASTER
I run MySQL version 4.0.16 on my linux box. My replication is working fine when I drop my database and import it on the master server. It seems to me that configuration files for both master and slave are OK. Privillege too. I define a user with the following right's: * Reload * File * Super * Execute * Replication client * Replication slave Now, if want to set up a new slave following these steps: * Start mysql on the slave * Run the following command to set up my slave LOAD DATA FROM MASTER; Nothing happens ?. What is going wrong ? Thanks in advance. Pierre LUGUERN IBM Business Consulting Services Tour Descartes 2 avenue Gambetta - La Défense 5 92066 Paris La Défense Ext: 01 49 05 55 63 Int: (33) 5563 Fax: 01 49 05 81 18 mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication: Setting up a slave
I run MySQL version 4.0.16 on my linux box. My replication is working fine when I drop my database and import it on the master server. It seems to me that configuration files for both master and slave are OK. Privillege too. I define a user with the following right's: * Reload * File * Super * Execute * Replication client * Replication slave Now, if want to set up a new slave following these steps: * Start mysql on the slave * Run the following command to set up my slave LOAD DATA FROM MASTER; I get error code 1219 (check privillege). I specify, I use InnodB scheme for my databases in my master configuration file. I read that the LOAD MASTER FILE FROM MASTER command support will be available for Innodb. Is this command available in my version of mysql ( 4.0.16) If yes ,what is going wrong ? Thanks in advance. Pierre LUGUERN IBM Business Consulting Services Tour Descartes 2 avenue Gambetta - La Défense 5 92066 Paris La Défense Ext: 01 49 05 55 63 Int: (33) 5563 Fax: 01 49 05 81 18 mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication
Ooops .. I think I have to be more precise about what I mean by replication. In facts the two servers A and B (in slave mode) have to replicate different tables included in the same database and I do not want to manage the replication through my application but only with the standard replication mode of my SQL. Example: Servers A and B managing database my_db and the two tables my_table_1 and my my_table_2. Server B slave of master A and replicating only my_table_1. Server A is in charge of upadating my_table1. The following parameter of my.cnf for server B is = replicate-ignore-table = my_db.my_table_2). Server A slave of master B and replicating only my_table_2. Server B is in charge of upadating my_table2. The following parameter of my.cnf for server A replicate-ignore-table = my_db.my_table_1). How does the configuration file looks like for the two server's ? Anyone has an example ? Thanks in advance. [EMAIL PROTECTED] el.Com To: Pierre Luguern/France/[EMAIL PROTECTED] cc: 03/02/2004 17:35 Subject: Re: Replication Pierre Luguern [EMAIL PROTECTED] wrote on 03/02/2004 15:41:30: Is this configuration possible with MySQL ? Server A is acting as a master server for the A database. Server B is acting as a slave, replicating the A database from server A. Server B is acting as a master server for the B Database. Server A is acting as a slave, replicating the B database from server B. How do the configuration file looks like for the two server's ? What I think you want is circular replication: A replicates B, B replicates A. MySQL can detect when an update has travelled round the full circle, and stops it propagating back to the server which originated it. It is then up to you, at the application level, to route updates for Database A to server A and updates for Database B to server B. If you can ensure this, I think you will get the effect you desire. If, of course, you route updates indiscriminately, things could go wrong. Alec Cawley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication
Is this configuration possible with MySQL ? Server A is acting as a master server for the A database. Server B is acting as a slave, replicating the A database from server A. Server B is acting as a master server for the B Database. Server A is acting as a slave, replicating the B database from server B. How do the configuration file looks like for the two server's ? Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to make a reminder ?
Hello everybody ! Pierre DELGOVE from Rennes, FRANCE. I am studying a model of database adapted to the management of a veterinary clinic (in order to design perhaps a software that I could use on my own on a GPL license). I meet this practical problem : how could I get a reminder (i.e. after having injected a vaccine for example, I need to recall the client for the next time, for example a year after or six months after) ? The solution I thought about is to store in a field a date which is converted in days (using the TO-DAYS function) then 365 days will be added (if I want a one-year reminder). that will give an other value which will be converted in date by the FROM-DAYS function. Does anybody has an other idea to solve this problem ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Exportation
Hi, I have a question concerning the portability of the files of the database. Is there a way to export the content of a database from PC (win or *NIX) to Mac ? Great thanks -- Mélet Pierre-Etienne -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
currency precision with decimal row
Hello! I'm trying to write some kind of small accounting software and I got stuck with the problem that doing a SUM() on values of a DECIMAL(7,2) row did show problems with (relatively) small values (like 173.58). I found a message explaining that mysql uses doubles internly to compute the values and this would explain the behaviour. Now my question is how should one go around the problem for now? I decided to use UNSIGNED INT and do a division by 100 after retrieving a value (or a multiplication by 100 before storing a value) in the language of the application (php). Is there another better way to do it? Regards, Jean-Pierre -- Powered by Linux From Scratch - http://schwicky.net/ PGP Key ID: 0xEE6F49B4 - AIM/Jabber: Schwicky - ICQ: 4690141 Nothing is impossible... Everything is relative! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: does mysql supports russion language or any other language?
Louie Miranda [EMAIL PROTECTED] wrote: Hi, i have this form that goes directly.. to a database. I have some clients who dont use english. If they enter on a form a special russion or chinese character will mysql translate it properly? If you use a Web form, you should try to transform the input with something like htmlentities() in PHP. This will translate all non ASCII characters to encoded full ASCII strings which will then be language independent. On the other side, you might try to use mysql-4.1.x with UTF8 rows Jean-Pierre -- Powered by Linux From Scratch - http://schwicky.net/ PGP Key ID: 0xEE6F49B4 - AIM/Jabber: Schwicky - ICQ: 4690141 Nothing is impossible... Everything is relative! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SELECT Question
Hello Mumba, Hello Barry, How do I select out and filter only rows that match both 16 and 62 in the KEYW_ID col? IE. The query would return only 119 and 108? I'm sure this could be done more effeciently other ways, possibly with a sub select if available, but something like this would probably work: SELECT temp1.* FROM table_name AS temp1 LEFT JOIN table_name AS temp2 ON temp1.tbl_idx=temp2.tbl_idx WHERE (temp1.keyw_id=16 AND temp2.keyw_id=62) OR (temp1.keyw_id=62 AND temp2.keyw_id=16); I'm not sure which one is more efficient but I'd do it this way: SELECT * FROM table WHERE KEYW_ID = 16 OR KEYW_ID = 62 GROUP BY TBL_IDX HAVING COUNT(TBL_IDX) = 2; Jean-Pierre -- Powered by Linux From Scratch - http://schwicky.net/ PGP Key ID: 0xEE6F49B4 - AIM/Jabber: Schwicky - ICQ: 4690141 Nothing is impossible... Everything is relative! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: might be a cilly question to u -execuse me.
Hello, mysql select *from accounting where uid = (select uid from user wher gid=apswan); ERROR 1064: You have an error in your SQL syntax near 'select uid from user wher gid=apswan)' at line 1 mysql Take care, you wrote wher instead of where. And as Leonardo pointed out, the version you're using does probably not support subqueries. You might try to write your query as follows: select accounting.* from accounting left join user on accounting.uid = user.uid where user.gid=apswan; Jean-Pierre -- Powered by Linux From Scratch - http://schwicky.net/ PGP Key ID: 0xEE6F49B4 - AIM/Jabber: Schwicky - ICQ: 4690141 Nothing is impossible... Everything is relative! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems with make test for 4.0.14
Hi again, Does any of you have an idea on this? I get the same error in 4.0.15. I could find that the problematic code was in mysql-test/mysql-test-run.sh: sleep_until_file_created $MASTER_MYPID $wait_for_master wait_for_master=$SLEEP_TIME_FOR_SECOND_MASTER MASTER_RUNNING=1 I guess I could probably disable that code from the test program and compile anyway, but would the resulting MySQL installation work? Also, there are currently RPMs of MySQL installed on the server. Should these be removed before compiling? Any help would be greatly appreciated. Pierre-Luc Soucy Pierre-Luc Soucy wrote: Hi, I'm trying to compile MySQL 4.0.14 on a server which was previously using RPMs, and although the ./configure (with no arguments) and make steps went fine, make test does not want to work. The error I am getting is : /home/programs/mysql/4.0.14/mysql-4.0.14/mysql-test/var/run/master.pid was not created in 30 seconds; Aborting (full make test output at the bottom of this message). What's wrong, and what should I do to correct this? Thanks! Pierre-Luc Soucy Full make test output: [EMAIL PROTECTED] mysql-4.0.14]# make test cd mysql-test ; ./mysql-test-run Installing Test Databases Removing Stale Files Installing Master Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/master-data --skip-innodb --skip-bdb --language=../sql/share/english/ 030905 22:18:12 ../sql/mysqld: Shutdown Complete Installing Slave Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/slave-data --skip-innodb --skip-bdb --language=../sql/share/english/ 030905 22:18:12 ../sql/mysqld: Shutdown Complete Manager disabled, skipping manager start. Loading Standard Test Databases Starting Tests TEST RESULT -- alias [ pass ] alter_table[ pass ] analyse[ pass ] ansi [ pass ] auto_increment [ pass ] backup [ pass ] bdb-alter-table-1 [ skipped ] bdb-alter-table-2 [ skipped ] bdb-crash [ skipped ] bdb-deadlock [ skipped ] bdb[ skipped ] bdb_cache [ skipped ] bench_count_distinct [ pass ] bigint [ pass ] binary [ pass ] bool [ pass ] bulk_replace [ pass ] case [ pass ] cast [ pass ] check [ pass ] comments [ pass ] compare[ pass ] constraints[ pass ] convert[ pass ] count_distinct [ pass ] count_distinct2[ pass ] create [ pass ] ctype_cp1251 [ pass ] ERROR: /home/programs/mysql/4.0.14/mysql-4.0.14/mysql-test/var/run/master.pid was not created in 30 seconds; Aborting make: *** [test] Error 1 [EMAIL PROTECTED] mysql-4.0.14]# -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems with make test for 4.0.14
Hi, I'm trying to compile MySQL 4.0.14 on a server which was previously using RPMs, and although the ./configure (with no arguments) and make steps went fine, make test does not want to work. The error I am getting is : /home/programs/mysql/4.0.14/mysql-4.0.14/mysql-test/var/run/master.pid was not created in 30 seconds; Aborting (full make test output at the bottom of this message). What's wrong, and what should I do to correct this? Thanks! Pierre-Luc Soucy Full make test output: [EMAIL PROTECTED] mysql-4.0.14]# make test cd mysql-test ; ./mysql-test-run Installing Test Databases Removing Stale Files Installing Master Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/master-data --skip-innodb --skip-bdb --language=../sql/share/english/ 030905 22:18:12 ../sql/mysqld: Shutdown Complete Installing Slave Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/slave-data --skip-innodb --skip-bdb --language=../sql/share/english/ 030905 22:18:12 ../sql/mysqld: Shutdown Complete Manager disabled, skipping manager start. Loading Standard Test Databases Starting Tests TEST RESULT -- alias [ pass ] alter_table[ pass ] analyse[ pass ] ansi [ pass ] auto_increment [ pass ] backup [ pass ] bdb-alter-table-1 [ skipped ] bdb-alter-table-2 [ skipped ] bdb-crash [ skipped ] bdb-deadlock [ skipped ] bdb[ skipped ] bdb_cache [ skipped ] bench_count_distinct [ pass ] bigint [ pass ] binary [ pass ] bool [ pass ] bulk_replace [ pass ] case [ pass ] cast [ pass ] check [ pass ] comments [ pass ] compare[ pass ] constraints[ pass ] convert[ pass ] count_distinct [ pass ] count_distinct2[ pass ] create [ pass ] ctype_cp1251 [ pass ] ERROR: /home/programs/mysql/4.0.14/mysql-4.0.14/mysql-test/var/run/master.pid was not created in 30 seconds; Aborting make: *** [test] Error 1 [EMAIL PROTECTED] mysql-4.0.14]# -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Optimization question - enum vs tinyint
Hi, I currently store some boolean values in tinyint(1) unigned fields. When running the procedure analyze on my tables, I am told that the best data type for these fields would be an enum(0,1). Is that true? How is that faster than tinyints? Also, does specifying the length of an integer-type field (say 1 for tinyint) make any difference on speed/storage issues? Thanks, Pierre-Luc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with merge tables in 4.1
Hi Dan, Ooops, this makes a lot of sense - it works now. Thanks for letting me know about the perror utility, it should help greatly to identify problems in the future. Regards, Pierre-Luc Dan Nelson wrote: In the last episode (Aug 06), Pierre-Luc Soucy said: I was working on some merge tables this morning and it worked fine, but after a few unsuccessful table creation requests (I was making some tests), I could not alter or select from a table for the following reason: mysql create table test_table (country CHAR(2) NOT NULL) TYPE=MERGE UNION=(countries); Query OK, 0 rows affected (0.00 sec) mysql select * from test_table; ERROR 1016: Can't open file: 'test_table.MRG'. (errno: 143) $ perror 143 Error code 143: Unknown error: 143 143 = Conflicting table definitions in sub-tables of MERGE table Does your countries table layout match that of test_table? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with merge tables in 4.1
Hi, I was working on some merge tables this morning and it worked fine, but after a few unsuccessful table creation requests (I was making some tests), I could not alter or select from a table for the following reason: mysql create table test_table (country CHAR(2) NOT NULL) TYPE=MERGE UNION=(countries); Query OK, 0 rows affected (0.00 sec) mysql select * from test_table; ERROR 1016: Can't open file: 'test_table.MRG'. (errno: 143) mysql check table test_table; +-+---+--+-+ | Table | Op| Msg_type | Msg_text| +-+---+--+-+ | statscounter.test_table | check | error| Can't open file: 'test_table.MRG'. (errno: 143) | +-+---+--+-+ 1 row in set (0.00 sec) mysql repair table test_table; +-++--+-+ | Table | Op | Msg_type | Msg_text| +-++--+-+ | statscounter.test_table | repair | error| Can't open file: 'test_table.MRG'. (errno: 143) | +-++--+-+ 1 row in set (0.00 sec) I then dropped the table and attempted to create a new one, with no success. Also tried another table name, or putting the table in another database, and that did not work either. Since it worked earlier, I tried restarting the MySQL server, but that didn't correct the problem either. Do you have any idea of what I'm doing wrong, or what needs to be done to get rid of that error? I thought about submitting a bug report but do not know how this error could be reproduced on another machine. I am running 4.1.0 on dual-CPU debian box with SCSI RAID hard drives, if that can help. Thanks! Pierre-Luc Soucy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem compiling mysql 4.1.0
Hi, I try to compile mysql-4.1.0-alpha on my GNU/Linux system with gcc-3.2 there was no problem with the configure, but for the make I got this : [...] Making all in cmd-line-utils gmake[2]: Entering directory `/tmp/mysql-4.1.0-alpha/cmd-line-utils' Making all in libedit gmake[3]: Entering directory `/tmp/mysql-4.1.0-alpha/cmd-line-utils/libedit' sh ./makelist -h ./vi.c vi.h.tmp \ mv vi.h.tmp vi.h ./makelist: /usr/bin/awk: No such file or directory gmake[3]: *** [vi.h] Error 127 gmake[3]: Leaving directory `/tmp/mysql-4.1.0-alpha/cmd-line-utils/libedit' gmake[2]: *** [all-recursive] Error 1 gmake[2]: Leaving directory `/tmp/mysql-4.1.0-alpha/cmd-line-utils' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/tmp/mysql-4.1.0-alpha' gmake: *** [all] Error 2 On my system 'awk' is in /usr/local/bin. I think a check should be added in the configure script for it (there is already one for 'sed'). Regards, Pierre. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem compiling mysql-connector-java 3.1.0-alpha
Mark Matthews wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pierre wrote: Hi, I try to compile mysql-connector-java-3.1.0-alpha on my GNU/Linux system with gcc-3.2, but for the make I got this : # ant Buildfile: build.xml Overriding previous definition of reference to non.test.sources clean: [delete] Deleting directory /tmp/build-mysql-jdbc init: [copy] Copying 78 files to /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha [copy] Copied 2 empty directories to /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha [copy] Copying 3 files to /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha [mkdir] Created dir: /tmp/build-mysql-jdbc/clover [mkdir] Created dir: /tmp/build-mysql-jdbc/clover/db [mkdir] Created dir: /tmp/build-mysql-jdbc/clover/report compile-core: [javac] Compiling 72 source files to /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha [javac] /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha/testsuite/BaseTestCase.java:21: package junit.framework does not exist [javac] import junit.framework.TestCase; [javac]^ [javac] /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha/testsuite/BaseTestCase.java:38: cannot resolve symbol [javac] symbol : class TestCase [javac] location: class testsuite.BaseTestCase [javac] public abstract class BaseTestCase extends TestCase { [javac]^ [javac] /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha/testsuite/BaseTestCase.java:125: cannot resolve symbol [javac] symbol : method fail () [javac] location: class testsuite.BaseTestCase [javac] fail(); [javac] ^ [...] It would be great if you could help me with this ! Best regards, Pierre. We don't distribute the junit jar files. If you want to compile the driver with the testsuite, then you need to get junit from www.junit.org. ok thank you, it was not clear that it was junit that was missing. Is there a reason you're compiling the driver yourself? It does come already compiled :) -Mark I'm on LFS so I prefer to compile everything myself :) Pierre. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem compiling MyODBC 3.51.06
Hi, I try to compile MyODBC-3.51.06 on my GNU/Linux system with gcc-3.2 there was no problem with the configure, but for the make I got this : # gmake Making all in driver gmake[1]: Entering directory `/tmp/MyODBC-3.51.06/driver' gmake all-am gmake[2]: Entering directory `/tmp/MyODBC-3.51.06/driver' source='catalog.c' object='catalog.lo' libtool=yes \ depfile='.deps/catalog.Plo' tmpdepfile='.deps/catalog.TPlo' \ depmode=gcc3 /bin/sh ../depcomp \ /bin/sh ../libtool --mode=compile gcc -s -DHAVE_CONFIG_H -I. -I. -I. -I/usr/local/mysql/include/mysql -I/usr/local/BerkeleyDB.4.1/include -I/usr/local/include -O3 -DDBUG_OFF -O3 -march=i686 -c -o catalog.lo `test -f catalog.c || echo './'`catalog.c gcc -s -DHAVE_CONFIG_H -I. -I. -I. -I/usr/local/mysql/include/mysql -I/usr/local/BerkeleyDB.4.1/include -I/usr/local/include -O3 -DDBUG_OFF -O3 -march=i686 -c catalog.c -MT catalog.lo -MD -MP -MF .deps/catalog.TPlo -fPIC -DPIC -o catalog.lo cc1: warning: changing search order for system directory /usr/local/include cc1: warning: as it has already been specified as a non-system directory In file included from myodbc3.h:106, from catalog.c:46: /usr/local/include/iodbcinst.h:77:20: config.h: No such file or directory gmake[2]: *** [catalog.lo] Error 1 gmake[2]: Leaving directory `/tmp/MyODBC-3.51.06/driver' gmake[1]: *** [all] Error 2 gmake[1]: Leaving directory `/tmp/MyODBC-3.51.06/driver' gmake: *** [all-recursive] Error 1 It would be great if you could help me with this ! Best regards, Pierre. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem compiling mysql-connector-java 3.1.0-alpha
Hi, I try to compile mysql-connector-java-3.1.0-alpha on my GNU/Linux system with gcc-3.2, but for the make I got this : # ant Buildfile: build.xml Overriding previous definition of reference to non.test.sources clean: [delete] Deleting directory /tmp/build-mysql-jdbc init: [copy] Copying 78 files to /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha [copy] Copied 2 empty directories to /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha [copy] Copying 3 files to /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha [mkdir] Created dir: /tmp/build-mysql-jdbc/clover [mkdir] Created dir: /tmp/build-mysql-jdbc/clover/db [mkdir] Created dir: /tmp/build-mysql-jdbc/clover/report compile-core: [javac] Compiling 72 source files to /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha [javac] /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha/testsuite/BaseTestCase.java:21: package junit.framework does not exist [javac] import junit.framework.TestCase; [javac]^ [javac] /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha/testsuite/BaseTestCase.java:38: cannot resolve symbol [javac] symbol : class TestCase [javac] location: class testsuite.BaseTestCase [javac] public abstract class BaseTestCase extends TestCase { [javac]^ [javac] /tmp/build-mysql-jdbc/mysql-connector-java-3.1.0-alpha/testsuite/BaseTestCase.java:125: cannot resolve symbol [javac] symbol : method fail () [javac] location: class testsuite.BaseTestCase [javac] fail(); [javac] ^ [...] It would be great if you could help me with this ! Best regards, Pierre. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Errors configuring mysql 4.1.0
Hi, I tried to configure mysql-4.1.0 and I got these errors : [...] checking for OpenSSL... yes ./configure: test: =: unary operator expected no ./configure: no: command not found ./configure: no: command not found mkdir: cannot create directory `include/readline': File exists checking character sets... default: latin1; compiled in: latin1 [...] I don't know if it's important but I wanted to report it. Regards, Pierre. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Database Market Information
Hi, I'm a belgian student in engineering and I'm now in my last year. I have a course about strategy where we have to analyse an industry and a particular company inside that industry. I think MySQL would be a good choice because I am very interested in free and open source software and it is a great exemple of success in that field. But it seems hard to find enough documentation about the database industry in general. Could you perhaps direct me in my search for information ? I already saw the press section of the MySQL website but I fear it won't be enough. Thank you very much. Pierre-Yves Dyon - 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
Segmentation fault
Hello, I am using Version : 3.23.40 under Linux and 3.23.51-Max under Windows XP I get the following error message while dumping my database. The segmentation fault is caused by the -c option. (It also occurs under Windows XP). Pierre-Yves Saumont Red Hat Linux release 6.2 (Zoot) Kernel 2.2.14-5.0smp on a 2-processor i686 login: volga Password: Last login: Fri Feb 7 06:11:45 from ASte-Genev-Bois-105-1-1-116.abo.wanadoo.fr [volga@s5 volga]$ mysqldump -uvolga -p -c volga_volga volga_volga_20030207_1520.sql Enter password: Segmentation fault (core dumped) - 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
Error compiling mysql 3.23.53
Hi, I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2 there was no problem with the configure, but for the make I got this : [...] Making all in isam gmake[2]: Entering directory `/tmp/mysql-3.23.53/isam' /bin/sh ../libtool --mode=link gcc -s -O3 -DDBUG_OFF -O3 -march=i686 -L/usr/local/BerkeleyDB.4.1/lib -lpthread -lgpm -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread gcc -s -O3 -DDBUG_OFF -O3 -march=i686 -L/usr/local/BerkeleyDB.4.1/lib -lpthread -lgpm -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread ../mysys/libmysys.a(my_tempnam.o): In function `my_tempnam': my_tempnam.o(.text+0x51): the use of `tempnam' is dangerous, better use `mkstemp' ../mysys/libmysys.a(raid.o): In function `my_raid_create': raid.o(.text+0xa5): undefined reference to `operator new(unsigned)' raid.o(.text+0x132): undefined reference to `operator delete(void*)' ../mysys/libmysys.a(raid.o): In function `my_raid_open': raid.o(.text+0x185): undefined reference to `operator new(unsigned)' raid.o(.text+0x20f): undefined reference to `operator delete(void*)' ../mysys/libmysys.a(raid.o): In function `my_raid_close': raid.o(.text+0x7c1): undefined reference to `operator delete(void*)' collect2: ld returned 1 exit status gmake[2]: *** [isamchk] Error 1 gmake[2]: Leaving directory `/tmp/mysql-3.23.53/isam' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/tmp/mysql-3.23.53' gmake: *** [all-recursive-am] Error 2 It would be great if you could help me with this ! Best regards, Pierre. - 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: Error compiling mysql 3.23.53
For information, same error with mysql-4.0.5a-beta Pierre. On 2002.12.09 02:11 Pierre wrote: Hi, I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2 there was no problem with the configure, but for the make I got this : [...] Making all in isam gmake[2]: Entering directory `/tmp/mysql-3.23.53/isam' /bin/sh ../libtool --mode=link gcc -s -O3 -DDBUG_OFF -O3 -march=i686 -L/usr/local/BerkeleyDB.4.1/lib -lpthread -lgpm -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread gcc -s -O3 -DDBUG_OFF -O3 -march=i686 -L/usr/local/BerkeleyDB.4.1/lib -lpthread -lgpm -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread ../mysys/libmysys.a(my_tempnam.o): In function `my_tempnam': my_tempnam.o(.text+0x51): the use of `tempnam' is dangerous, better use `mkstemp' ../mysys/libmysys.a(raid.o): In function `my_raid_create': raid.o(.text+0xa5): undefined reference to `operator new(unsigned)' raid.o(.text+0x132): undefined reference to `operator delete(void*)' ../mysys/libmysys.a(raid.o): In function `my_raid_open': raid.o(.text+0x185): undefined reference to `operator new(unsigned)' raid.o(.text+0x20f): undefined reference to `operator delete(void*)' ../mysys/libmysys.a(raid.o): In function `my_raid_close': raid.o(.text+0x7c1): undefined reference to `operator delete(void*)' collect2: ld returned 1 exit status gmake[2]: *** [isamchk] Error 1 gmake[2]: Leaving directory `/tmp/mysql-3.23.53/isam' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/tmp/mysql-3.23.53' gmake: *** [all-recursive-am] Error 2 It would be great if you could help me with this ! Best regards, Pierre. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem compiling mysql-3.23.53
I tried mysql-4.0.5a-beta, and same error... Pierre. On 2002.12.08 02:36 Pierre wrote: Hi, I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2 there was no problem with the configure, but for the make I got this : [...] gmake[3]: Entering directory `/tmp/mysql-3.23.53/sql' g++ -s -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql\ -DHAVE_CONFIG_H -I../innobase/include -I./../include -I./../regex -I. -I../include -I.. -I. -I/usr/local/BerkeleyDB.4.1/include -O3 -DDBUG_OFF -O3 -march=i686 -fno-implicit-templates -fno-exceptions -fno-rtti -c mysqld.cc /usr/include/tcpd.h: In function `void* handle_connections_sockets(void*)': /usr/include/tcpd.h:131: too many arguments to function `void sock_host()' mysqld.cc:2444: at this point in file /usr/include/tcpd.h:69: too many arguments to function `int hosts_access()' mysqld.cc:2445: at this point in file /usr/include/tcpd.h:124: too many arguments to function `char* eval_client()' mysqld.cc:2453: at this point in file gmake[3]: *** [mysqld.o] Error 1 gmake[3]: Leaving directory `/tmp/mysql-3.23.53/sql' gmake[2]: *** [all-recursive] Error 1 gmake[2]: Leaving directory `/tmp/mysql-3.23.53/sql' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/tmp/mysql-3.23.53' gmake: *** [all-recursive-am] Error 2 It would be great if you could help me with this ! Best regards, Pierre. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem compiling mysql 3.23.53
I finally found the solution : I had bad old include files in /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/ that come from a old gcc installation. I removed them and now it's ok. Pierre. On 2002.11.13 06:50 Pierre wrote: Hi, I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2 there was no problem with the configure, but for the make I got this : [...] Making all in client gmake[2]: Entering directory `/tmp/mysql-3.23.53/client' g++ -s -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I.. -I.. -I/usr/local/BerkeleyDB.4.1/include -O3 -DDBUG_OFF -O3 -march=i686 -fno-implicit-templates -fno-exceptions -fno-rtti -c mysql.cc In file included from /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/curses.h:86, from mysql.cc:48: /usr/include/unctrl.h: In function `int NCURSES_EXPORT(char*)': /usr/include/unctrl.h:57: parse error before `(' token In file included from mysql.cc:48: /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/curses.h:406: non-localfunction `int add_wch(const NCURSES_EXPORT(char*)::cchar_t*)' uses localtype `const NCURSES_EXPORT(char*)::cchar_t' /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/curses.h:407: non-localfunction `int add_wchnstr(const NCURSES_EXPORT(char*)::cchar_t*, int)' useslocal type `const NCURSES_EXPORT(char*)::cchar_t' /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/curses.h:408: non-localfunction `int add_wchstr(const NCURSES_EXPORT(char*)::cchar_t*)' uses localtype `const NCURSES_EXPORT(char*)::cchar_t' /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/curses.h:422: non-localfunction `void bkgrndset(const NCURSES_EXPORT(char*)::cchar_t*)' uses localtype `const NCURSES_EXPORT(char*)::cchar_t' /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/curses.h:423: non-localfunction `int bkgrnd(const NCURSES_EXPORT(char*)::cchar_t*)' uses local type`const NCURSES_EXPORT(char*)::cchar_t' [...] I have ncurses-5.3 installed. It would be great if you could help me with this ! Best regards, Pierre. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem compiling mysql-3.23.53
Hi, I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2 there was no problem with the configure, but for the make I got this : [...] gmake[3]: Entering directory `/tmp/mysql-3.23.53/sql' g++ -s -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql\ -DHAVE_CONFIG_H -I../innobase/include -I./../include -I./../regex -I. -I../include -I.. -I. -I/usr/local/BerkeleyDB.4.1/include -O3 -DDBUG_OFF -O3 -march=i686 -fno-implicit-templates -fno-exceptions -fno-rtti -c mysqld.cc /usr/include/tcpd.h: In function `void* handle_connections_sockets(void*)': /usr/include/tcpd.h:131: too many arguments to function `void sock_host()' mysqld.cc:2444: at this point in file /usr/include/tcpd.h:69: too many arguments to function `int hosts_access()' mysqld.cc:2445: at this point in file /usr/include/tcpd.h:124: too many arguments to function `char* eval_client()' mysqld.cc:2453: at this point in file gmake[3]: *** [mysqld.o] Error 1 gmake[3]: Leaving directory `/tmp/mysql-3.23.53/sql' gmake[2]: *** [all-recursive] Error 1 gmake[2]: Leaving directory `/tmp/mysql-3.23.53/sql' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/tmp/mysql-3.23.53' gmake: *** [all-recursive-am] Error 2 It would be great if you could help me with this ! Best regards, Pierre. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem compiling mysql 3.23.53
Hi, I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2 there was no problem with the configure, but for the make I got this : [...] Making all in client gmake[2]: Entering directory `/tmp/mysql-3.23.53/client' g++ -s -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I.. -I.. -I/usr/local/BerkeleyDB.4.1/include -O3 -DDBUG_OFF -O3 -march=i686 -fno-implicit-templates -fno-exceptions -fno-rtti -c mysql.cc In file included from /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/curses.h:86, from mysql.cc:48: /usr/include/unctrl.h: In function `int NCURSES_EXPORT(char*)': /usr/include/unctrl.h:57: parse error before `(' token In file included from mysql.cc:48: /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/curses.h:406: non-localfunction `int add_wch(const NCURSES_EXPORT(char*)::cchar_t*)' uses localtype `const NCURSES_EXPORT(char*)::cchar_t' /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/curses.h:407: non-localfunction `int add_wchnstr(const NCURSES_EXPORT(char*)::cchar_t*, int)' useslocal type `const NCURSES_EXPORT(char*)::cchar_t' /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/curses.h:408: non-localfunction `int add_wchstr(const NCURSES_EXPORT(char*)::cchar_t*)' uses localtype `const NCURSES_EXPORT(char*)::cchar_t' /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/curses.h:422: non-localfunction `void bkgrndset(const NCURSES_EXPORT(char*)::cchar_t*)' uses localtype `const NCURSES_EXPORT(char*)::cchar_t' /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/curses.h:423: non-localfunction `int bkgrnd(const NCURSES_EXPORT(char*)::cchar_t*)' uses local type`const NCURSES_EXPORT(char*)::cchar_t' [...] I have ncurses-5.3 installed. It would be great if you could help me with this ! Best regards, Pierre. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem compiling mysqlgui 1.7.5
Hi, I try to compile mysqlgui-src-1.7.5 on my GNU/Linux system with gcc-3.2 but with the make I got this : # gmake gmake: *** No rule to make target `edfile.o', needed by `mysqlgui'. Stop. It would be great if you could help me with this ! Best regards, Pierre. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql OSX 10.2
I just switched mysql from OSX 10.1.5 to 10.2.1with Marc Liyanage package but I ran with the following error : [Ordinateur-de-Pierre-Vaudrey:~] pierreva% mysql dyld: mysql Undefined symbols: /sw/lib/libreadline.4.2.dylib undefined reference to _tgetent expected to be defined in /usr/lib/libSystem.B.dylib /sw/lib/libreadline.4.2.dylib undefined reference to _tgetflag expected to be defined in /usr/lib/libSystem.B.dylib /sw/lib/libreadline.4.2.dylib undefined reference to _tgetnum expected to be defined in /usr/lib/libSystem.B.dylib /sw/lib/libreadline.4.2.dylib undefined reference to _tgetstr expected to be defined in /usr/lib/libSystem.B.dylib /sw/lib/libreadline.4.2.dylib undefined reference to _tputs expected to be defined in /usr/lib/libSystem.B.dylib /sw/lib/libreadline.4.2.dylib undefined reference to _tgoto expected to be defined in /usr/lib/libSystem.B.dylib Trace/BPT trap [Ordinateur-de-Pierre-Vaudrey:~] pierreva% Could you help me to fix it ? Pierre Vaudrey email [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem compiling mysql 4.0.4
Hi, I try to compile mysql-4.0.4-beta on my GNU/Linux system with gcc-3.2 There was no problem with the configure but for the make i got this : [...] Making all in isam gmake[2]: Entering directory `/tmp/mysql-4.0.4-beta/isam' /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -O3 -march=i686 -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread gcc -O3 -DDBUG_OFF -O3 -march=i686 -rdynamic -o isamchk isamchk.o sort.o libnisam.a ../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lz -lcrypt -lnsl -lm -lpthread ../mysys/libmysys.a(my_tempnam.o): In function `my_tempnam': my_tempnam.o(.text+0x51): the use of `tempnam' is dangerous, better use `mkstemp' ../mysys/libmysys.a(raid.o): In function `my_raid_create': raid.o(.text+0xa5): undefined reference to `operator new(unsigned)' raid.o(.text+0x132): undefined reference to `operator delete(void*)' ../mysys/libmysys.a(raid.o): In function `my_raid_open': raid.o(.text+0x185): undefined reference to `operator new(unsigned)' raid.o(.text+0x20f): undefined reference to `operator delete(void*)' ../mysys/libmysys.a(raid.o): In function `my_raid_close': raid.o(.text+0x7c1): undefined reference to `operator delete(void*)' collect2: ld returned 1 exit status gmake[2]: *** [isamchk] Error 1 gmake[2]: Leaving directory `/tmp/mysql-4.0.4-beta/isam' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/tmp/mysql-4.0.4-beta' gmake: *** [all-recursive-am] Error 2 It would be great if you could help me with this ! Best regards, Pierre. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Bug: Outer Joins producing incorrect result on a single join referencing multiple tables
Description: I wanted to get the rows from table Health for which no match exists in the table resulting from the inner join of Object and NMID. I ran these queries in MySQL 3.23 and 4.0 with the same incorrect results. They all work fine on MS SQL Server 2000 and on DB2 7.2. With a DBMS supporting subqueries, I would have expressed it like this: 1) SELECT DISTINCT H.Appliance_ID, H.Health_NMID, H.Health_DeviceOrPort FROM Health H WHERE NOT EXISTS (SELECT 0 FROM Object O INNER JOIN NMID N ON O.Object_ID = N.Object_ID WHERE H.Appliance_ID= N.Appliance_ID AND H.Health_NMID = N.NMID_NMID AND H.Health_DeviceOrPOrt = O.Object_Table ) AND H.Appliance_ID = 0; Because MySQL lacks support for subqueries, I tried this SQL-92 compliant form of outer join, but MySQL reject it with a syntax error. 2) SELECT DISTINCT H.Appliance_ID, H.Health_NMID, H.Health_DeviceOrPort FROM Health H LEFT OUTER JOIN Object O INNER JOIN NMID N ON O.Object_ID = N.Object_ID ON H.Appliance_ID = N.Appliance_ID AND H.Health_DeviceOrPOrt = O.Object_Table AND H.Health_NMID = N.NMID_NMID WHERE H.Appliance_ID = 0 AND N.Object_ID IS NULL; With a right outer join, no syntax errors is generated but the result is incorrect. 3) SELECT DISTINCT H.Appliance_ID, H.Health_NMID, H.Health_DeviceOrPort FROM Object O INNER JOIN NMID N ON O.Object_ID = N.Object_ID RIGHT OUTER JOIN Health H ON H.Appliance_ID = N.Appliance_ID AND H.Health_NMID = N.NMID_NMID AND H.Health_DeviceOrPOrt = O.Object_Table WHERE H.Appliance_ID = 0 AND O.Object_ID IS NULL; This incorrectly returns no rows. With MS SQL Server 2000 and DB2 v7.2 it makes no difference to test O.Object_ID IS NULL or N.Object_ID IS NULL, but with MySQL, it does but in both cases the result is wrong. Testing N.Object_ID incorrectly returns 4 rows: +--+-+-+ | Appliance_ID | Health_NMID | Health_DeviceOrPort | +--+-+-+ |0 | 1 | device | |0 | 2 | device | |0 | 3 | device | |0 | 4 | device | +--+-+-+ Adding parenthesis to force the inner join to be done before the outer join didn't fix the problem. 4) SELECT DISTINCT H.Appliance_ID, H.Health_NMID, H.Health_DeviceOrPort FROM -- (Object O Object O INNER JOIN NMID N -- ON O.Object_ID = N.Object_ID) ON O.Object_ID = N.Object_ID RIGHT OUTER JOIN Health H ON H.Appliance_ID = N.Appliance_ID AND H.Health_NMID = N.NMID_NMID AND H.Health_DeviceOrPOrt = O.Object_Table WHERE H.Appliance_ID = 0 AND O.Object_ID IS NULL; How-To-Repeat: CREATE TABLE Object (Object_ID INTEGER NOT NULL, Object_Table VARCHAR(6) NOT NULL); CREATE TABLE NMID (Appliance_ID INTEGER NOT NULL, NMID_NMID INTEGER, Object_ID INTEGER NOT NULL); CREATE TABLE Health (Appliance_ID INTEGER NOT NULL, Health_NMID INTEGER NOT NULL, Health_DeviceOrPort VARCHAR(6) NOT NULL); INSERT INTO Object(Object_ID, Object_Table) VALUES (101,'Device'); INSERT INTO Object(Object_ID, Object_Table) VALUES (201,'Device'); INSERT INTO Object(Object_ID, Object_Table) VALUES (202,'Port'); INSERT INTO Object(Object_ID, Object_Table) VALUES (302,'Port'); INSERT INTO NMID (Appliance_ID, NMID_NMID, Object_ID) VALUES (0, 1, 101); INSERT INTO NMID (Appliance_ID, NMID_NMID, Object_ID) VALUES (0, 2, 201); INSERT INTO NMID (Appliance_ID, NMID_NMID, Object_ID) VALUES (0, 2, 202); INSERT INTO NMID (Appliance_ID, NMID_NMID, Object_ID) VALUES (0, 3, 302); INSERT INTO Health (Appliance_ID, Health_NMID, Health_DeviceOrPort) VALUES (0, 1, 'Device'); INSERT INTO Health (Appliance_ID, Health_NMID, Health_DeviceOrPort) VALUES (0, 2, 'Device'); INSERT INTO Health (Appliance_ID, Health_NMID, Health_DeviceOrPort) VALUES (0, 3, 'Device'); INSERT INTO Health (Appliance_ID, Health_NMID, Health_DeviceOrPort) VALUES (0, 4, 'Device'); The following 2 rows should be returned Appliance_ID Health_NMID Health_DeviceOrPort --- --- 0 3 Device 0 4 Device Fix: Create a temporary table with the result of the inner join and then use the temporary table in an outer join Submitter-Id: Jean-Pierre Pelletier Originator:root Organization: Peregrine Systems, Inc. MySQL support: [none | licence | email support | extended email support ] Synopsis: MySQL Bug: Outer Joins producing incorrect result on a single join referencing multiple
Maximum number of tables
I saw in the MySQL documentation that the myISAM tables maximal size was 8 millions TB. But I couldn't find any information about the maximum number of tables it can support. Can you give me this information ? Thanks a lot ! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql on Mac OSX
I'm new to the list trying to run Php Mysql on the Apache server built-in Mac OSX. I'm running with the following error : [localhost:/usr/local/mysql] pierreva% mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [localhost:/usr/local/mysql] pierreva% Can you help me to find what I'm doing wrong ? Pierre Vaudrey email [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Delphi MySQL Access Components
Daniel, Personally I found ZEOS a pain in proverbial - poorly documented, constant AVs etc.. D6 dbExpress works very well for me, but I think it only comes with D6 Enterprise. The myODBC driver is another way to go, in which case you could probably use the BDE. There is an ADO driver for mySQL somewhere as well. I could never get it work but if it could be made to work then you could use the ADO components distributed with D6 Pro and Enterprise. Pierre http://www.finalfiler.com Daniel Kiss wrote: Hi, Can someone tell me what is the best MySQL native component set for Delphi? It does not matter if it is commercial, but I need one urgently. Thanks, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Pierre du Parte' Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: M$ Acesss Front MySql-Backend field datatype issues using Myodbc
I may be a little OT, but the current myODBC driver does work quite well with Access. So you can use Access to write your queries and app etc and have mySQL as your backend. I've mainly used Access and myODBC to port manipulate Access data to mySQL. For writing mySQL frontends my preferred development tool is Delphi. Hope this helps Pierre http://www.finalfiler.com chuck amadi wrote: Hi again . I have a project whereby the client has a legacy M$ Access ( as far as im concerned ) and i'm to design.build and construct a MySql v4 Back-end and more than likely pursue a front-end with MS Access due to easability and conversant of it's user's nevertheless are there any field datatype issues and if so is there a site or FAQ that suggests prior to development the tried and tested field datatype that will run smoothly between both front back end . If it is clumbberson i more than likely use MySql-Front. Plz can someone confirm that MySql Front has similiar look feel in relation to Forms , buttons and alike. Plz post any good links regarding field datatypes or Sample Projects built with MySql v4 Front. -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication slave repeatedly gets error 1159 from master
i have the same probem since i ugraded my slave from 3.23.50 to 3.23.51 Pierre - Original Message - From: David Harper [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 15, 2002 1:26 PM Subject: Replication slave repeatedly gets error 1159 from master Description: Every 60 seconds, the replication slave gets an error 1159 from the master server. Thirty seconds later, it reconnects to the master. Then the cycle starts all over again. I have master-connect-retry=30 in the config file. Here is an extract of the replication slave's error log: 020715 12:05:33 Error reading packet from server: (server_errno=1159) 020715 12:06:03 Slave: Failed reading log event, reconnecting to retry, log 'mysql.001' position 73 020715 12:06:03 Slave: reconnected to master 'slave@venus:24641',replication resumed in log 'mysql.001' at position 73 020715 12:06:33 Error reading packet from server: (server_errno=1159) 020715 12:07:03 Slave: Failed reading log event, reconnecting to retry, log 'mysql.001' position 73 020715 12:07:03 Slave: reconnected to master 'slave@venus:24641',replication resumed in log 'mysql.001' at position 73 In between disconnections, replication *appears* to be occurring correctly, but it is rather disturbing that there seems to be some kind of communication problem between the master and slave servers. This problem did not occur in version 3.23.49, by the way. It appeared when we upgraded to 3.23.51. How-To-Repeat: Set up a master/slave replication pair of servers. Fix: Not known. Submitter-Id: submitter ID Originator: David Harper Organization: Wellcome Trust Sanger Institute, Hinxton, Cambridge CB10 1SA, England MySQL support: none Synopsis: Replication slave repeatedly gets error 1159 from master Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.51 (Official MySQL binary) Environment: System: OSF1 mars V5.1 732 alpha Machine: alpha Some paths: /bin/perl /bin/make /usr/local/bin/gmake /usr/local/bin/gcc /bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/alpha-dec-osf5.1/3.0.3/specs Configured with: ../configure Thread model: single gcc version 3.0.3 Compilation info: CC='cc -pthread' CFLAGS='-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all' CXX='cxx -pthread' CXXFLAGS='-O4 -ansi_alias -fast -inline speed -speculate all -noexceptions -nortti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root system17 Mar 30 2001 /lib/libc.a - ../ccs/lib/libc.a lrwxrwxrwx 1 root system17 Mar 30 2001 /usr/lib/libc.a - ../ccs/lib/libc.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread- safe-client --enable-local-infile --with-prefix=/usr/local/mysql --with-mysq ld-ldflags=-all-static --disable-shared '--with-named-thread-libs=-lpthread -lmach -lexc -lc' --disable-shared 'CC=cc -pthread' 'CFLAGS=-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all' 'CXXFLAGS=-O4 -ansi_alias -fast -inline speed -speculate all -noexceptions -nortti' 'CXX=cxx -pthread' Perl: This is perl, version 5.005_03 built for alpha-dec_osf - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Implementing commit,transaction in isam table type
why not using innodb tables ? smart chandar wrote: I am using Mysql Db that contains Isam table types,I am developing a project that is using interrelated tables,unfortunatily isam table type doesn't support the commit and transaction,but i should implement that,can anyone give a logic for that thanks in advance with regards chandar __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.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
debian package
is there any debian package of mysql supporting innodb ? thanks, Pierre -- sql,query - 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
slave server in readonly
is it possible to start a server in 'read only' mode ? so that users cannot write in my slave server ? thanks, Pierre --sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
innodb database schema dump
how can i dump innodb tables schema with foreign key references so that the tables are created in the right order ? thanks, Pierre -- sql,query - 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
remove foreign key constraint
how to remove a foreign key constraint without recreating the innodb table ? thanks, Pierre sql,query - 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
Unable to add/ edit records - Help needed!
Hi, We have been using a simple mySQL database successfully for some time. The database has a couple of tables and 1000 records in the primary table. It has been well behaved and performing well. Development record maintenance is taking place locally under Delphi/ dbExpress applications and on a web site using php. All of a sudden we can no longer add/ edit records. One tell tale message is that we constantly get error dialogs Action not possible on a uni-directional database I have repaired the database etc. But we haven't changed anything in the mySQL installations, development environments etc. I have removed all keys (except and autoinc primary key) and restrictions on the records and fields. The problem persists. I'm stumped and I'd be most grateful if someone could point me in the direction of a solution. Thanks -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unable to add/ edit records - Help needed!
Nevermind- I just re-installed mySQL and rebooted. everything works again. Pierre Pierre du Parte wrote: Hi, We have been using a simple mySQL database successfully for some time. The database has a couple of tables and 1000 records in the primary table. It has been well behaved and performing well. Development record maintenance is taking place locally under Delphi/ dbExpress applications and on a web site using php. All of a sudden we can no longer add/ edit records. One tell tale message is that we constantly get error dialogs Action not possible on a uni-directional database I have repaired the database etc. But we haven't changed anything in the mySQL installations, development environments etc. I have removed all keys (except and autoinc primary key) and restrictions on the records and fields. The problem persists. I'm stumped and I'd be most grateful if someone could point me in the direction of a solution. Thanks -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication
hi, i am running mysql-max-log 32.23.50 on Solaris as slave and mysql-max-log 32.23.51 on linux as a master i often happend that slave stop because of a grant query it can't execute. a flush privileges in the slave is enough to make it restart. does anyone have this problem ?? thanks Pierre -- sql, query - 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
replication
i am trying to setup a slave server (3.23.50) on solaris 2.7 i follow the manual to set it up but when i start this slave server, i have the following error message from mysqld : bin/mysqld: option `--master' is ambiguous where does this --master come from thanks, Pierre -- sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql 3.23.50
where can i get the 3.23.50 packages with innodb support ? Pierre -- sql,query - 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
on delete cascade
does mysql-max 3.23.50 support the option on delete cascade for the foreign key, the documentation is not very clear on this point Pierre -- sql,query - 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
Indexing words
We have an application that needs to index every word (token) in a name, separately. Ex: New York must be indexed under New and York. One solution is to create an auxiliary table, extract the tokens one word at a time, and cross-reference to the key of the original table. Ex: CREATE TABLE places ( idp INT(8) NOT NULL, place CHAR(32), /* Ex: New York */ PRIMARY KEY(idp) ) CREATE TABLE tokens ( idt INT(8) NOT NULL AUTO_INCREMENT, token CHAR(32), /* Ex: New OR York */ idp INT(8) /* refers to same key in 'places' */ PRIMARY KEY (idt), INDEX (token) ) Is there a faster/more elegant way to do this? 'FULLTEXT' is not suitable. (Please forgive my naïveté, I am new to MySQL). - 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
HELP - Insight into dates, please
Excuse this old ACCESS/ CLARION hack for asking such a basic question, but the mySQL docs have given me a head-ache :-) I want to move an ACCESS database to mySQL. I am writing the Code in Delphi. My problem is assigning the date values in the SQL INSERT INTO string. In the system I'm using dates are returned as REAL numbers and generally I would format it to suit the occasion, ie formatdatetime('-mm-dd',myDate.value). So, in mySQL sql := 'INSERT INTO myTable SET myDate = ' + formatdatetime(datemask ,myDate.value); Looking at the mySQL docs AFAI can work out datemask should be -mm-dd but this doesn't work. what is the expected 'datemask'? Or have I got wrong? More importantly are there functions in mySQL I can call to convert a standard date, ie mmdd to the expected mySQL value? Any help to get me over this confusing hump is appreciated. -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: HELP - Insight into dates, please
Many thanks for the, Richard... You wrote: I'm not so sure what you are asking here but from this statement, More importantly are there functions in mySQL I can call to convert a standard date, ie mmdd to the expected mySQL value?. Yeah, I was a bit vague :-) But your example provided the clue- I had neglected the string delimiters :-( I had coded SET myDate = mmdd I should have coded SET mydate = 'mmdd' which worked. Again, many thanks Pierre - 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
GUI for mySQL
I am gradually winning the war in promoting opensource to a number of my key customers. Notably a couple have made the move to OpenOffice.org, albeit on Windows. I am currently re-writing a key application to use mySQl (previously Access), so in all I'm pleased. However, the head bean counter in one office tackled me on this - In Access I can quickly create queries and export the results in all manner of ways. What do I do if we let you talk us into mySql? Where indeed? Are there any nice, user friendly GUI available for mySQL ad-hoc query and report design? Thanks -- Pierre du Parté Final Filer Software Worrigee, NSW, Australia 2540 http://www.finalfiler.com If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with query
Depends on how the fee paymnents are defined. At its simplest: SELECT Members..Name FROM Members WHERE NOT(Members.MemberID = FEE_PAYMENTS.MenmbersID) would select members that have no fee payment records. You could build on it from there... For the mySQL gurus, sorry about the syntax guys, I've been with Access to long but I'm coming over quickly :-) Pierre Torkil Johnsen wrote: I am having a small problem with a small mysql query... I want to make a list of: WHO HAS NOT PAID THEIR MEMBERSHIP FEE. I guess I could maybe solve this one myself, its not too hard ... I have one table with members MEMBERS -- | MemberID | Name | etc. One table with fee payments FEE_PAYMENTS -- | MemberID | date | price | etc... Now: How would I make a query that would list all members that have not paid their fee? How would I make a query that would list all members that have paid their fee? I'm just too tired to think it out myself :) Forgive me :) - Med vennlig hilsen, Torkil Johnsen [EMAIL PROTECTED] - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: new windows Tool
I have no objection to you promoting your wares in this group of to your entrepreneurial skills. But to get the message This trial has expired on the first run after installing the 9 meg plus download is a bit rough, isn't it? And definitely not the way to win customers! Pierre amr salah wrote: Hello MYsql lovers; I wanna announce a new tool for windows users . Same interface as SQL server 2000 query analyzer but loaded with Visual Studio capabilities . SQL server users will love it . http://amr.activechannel.net http://amr.activechannel.net/setup.zip _ Get your FREE, Private email today - [EMAIL PROTECTED] http://www.msexpert.com _ Run a small business? Then you need professional email like [EMAIL PROTECTED] from Everyone.net http://www.everyone.net?tag - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Free Quote
I don't know what this (below) is, but gee, it seems good :-) Best wishes -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! J Williamson wrote: Would you not be better of just runing myisamchk from crontab? Simon ../myisamchk Ver 1.52 for unknown-freebsdelf4.1 at i386 By Monty, for your professional use This software comes with NO WARRANTY: see the PUBLIC for details. Description, check and repair of ISAM tables. Used without options all tables on the command will be checked for errors Usage: ./myisamchk [OPTIONS] tables[.MYI] Global options: -#, --debug=... Output debug log. Often this is 'd:t:o,filename` -?, --help Display this help and exit. -O, --set-variable var=option Change the value of a variable. -s, --silentOnly print errors. One can use two -s to make myisamchk very silent -v, --verbose Print more information. This can be used with --describe and --check. Use many -v for more verbosity! -V, --version Print version and exit. -w, --wait Wait if table is locked. Check options (check is the default action for myisamchk): -c, --check Check table for errors -e, --extend-check Check the table VERY throughly. Only use this in extreme cases as myisamchk should normally be able to find out if the table is ok even without this switch -F, --fast Check only tables that hasn't been closed properly -C, --check-only-changed Check only tables that has changed since last check -f, --force Restart with -r if there are any errors in the table. States will be updated as with --update-state -i, --information Print statistics information about table that is checked -m, --medium-check Faster than extended-check, but only finds 99.99% of all errors. Should be good enough for most cases -U --update-state Mark tables as crashed if you find any errors -T, --read-only Don't mark table as checked Repair options (When using -r or -o) -B, --backupMake a backup of the .MYD file as 'filename-time.BAK' --correct-checksum Correct checksum information for table. -D, --data-file-length=# Max length of data file (when recreating data file when it's full) -e, --extend-check Try to recover every possible row from the data file Normally this will also find a lot of garbage rows; Don't use this option if you are not totally desperate. -f, --force Overwrite old temporary files. -k, --keys-used=# Tell MyISAM to update only some specific keys. # is a bit mask of which keys to use. This can be used to get faster inserts! -r, --recover Can fix almost anything except unique keys that aren't unique. -n, --sort-recover Force recovering with sorting even if the temporary file would be very big. -o, --safe-recover Uses old recovery method; Slower than '-r' but can handle a couple of cases where '-r' reports that it can't fix the data file. --character-sets-dir=... Directory where character sets are --set-character-set=name Change the character set used by the index -t, --tmpdir=path Path for temporary files -q, --quick Faster repair by not modifying the data file. One can give a second '-q' to force myisamchk to modify the original datafile in case of duplicate keys -u, --unpackUnpack file packed with myisampack. Other actions: -a, --analyze Analyze distribution of keys. Will make some joins in MySQL faster. You can check the calculated distribution by using '--describe --verbose table_name'. -d, --description Prints some information about table. -A, --set-auto-increment[=value] Force auto_increment to start at this or higher value If no value is given, then sets the next auto_increment value to the highest used value for the auto key + 1. -S, --sort-indexSort index blocks. This speeds up 'read-next' in applications -R, --sort-records=# Sort records according to an index. This makes your data much more localized and may speed up things (It may be VERY slow to do a sort the first time!) Default options are read from the following files in the given order: /etc/my.cnf /usr/local/mysql/var/my.cnf ~/.my.cnf The following groups are read: myisamchk The following options may be given as the first argument: --print-defaultsPrint
: myODBC and WinXP/ Access 2000
[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: sql,query I am flabbergasted! I think the list needs a better spamfilter - below is my message... I had myODBC working reasonably well with mySQL under Win2K. However, under XP I now get a weird unknown error What's the experience? Should myODBC work with WinXP? -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New to MySQL - can't start server :-(
Hi Alexander, I use the PHPDEV compilation for local PHP/mySQL development work (http://www.firepages.com.au/devindex.htm for a no-brainer approach to getting PHP/mySQL/Apache up and running in seconds!) Anyway, for me start c:\phpdev\mysql\bin\mysqld-nt.exe --standalone kicks mySQL off on Win2K, NT and XP very nicely, thank you :) If your mySQL is in c:\ then start c:\mysql\bin\mysqld-nt.exe --standalone should work But I could be wrong, I often am Pierre Alexander Hampel wrote: Hi mailing list, I can't start mysqld-nt as I get the eror message 1067. If I start winmysqladmin.exe there is no server visible. The manual tell me in part 2.4 Post-installation Setup and Testing that I should start the script ./scripts/mysql_install_db but this script is not availabale (at all) at my Windows distribution. Any ideas what's wrong? Thank you, A:lex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: migrate Microsoft Access Data into MySQL
I've had good success with QUOTE ' exportSQL version 2.0 ' www.cynergi.net/prod/exportsql/ ' ' (C) 1997-98 CYNERGI - www.cynergi.net, [EMAIL PROTECTED] ' (C) Pedro Freire - [EMAIL PROTECTED] (do not add to mailing lists without permission) ' ' This code is provided free for anyone's use and is therefore without guarantee or support. ' This does NOT mean CYNERGI delegates its copyright to anyone using it! You may change the ' code in any way, as long as this notice remains on the code and CYNERGI is notified (if you ' publish the changes: if your changes/corrections prove valuable and are added to the code, ' you will be listed in a credit list on this file). END QUOTE ExportSQL writes a 'sql dump' file for the recreation of the database. ALso have a look at mysql.com's download section. There's a range of utilities there that will help, although I found all lacking one thing or another. ExportSQL is probably the pick of them. myODBC works, but AFAIK you'd need to create the tables and structures first. I am currently working on an application in Delphi that will use ADO and pump structure and data to mySQL using a 'wizard' interface. It'll be offered in the spirit of mySQL, ie free. I'm nearly done, but need to work out how to handle Access' dbOLE fields. Pierre Admin wrote: How to migrate Microsoft .mdb Database into MySQL under Unix environment?? Who can tell me?? Any Doc?? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Pierre du Parté Final Filer Software Worrigee, NSW, Australia http://www.finalfiler.com 61 2 44220442 61 413483066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Delphi, ADO and SQL
Don't know if this is the right forum, but you can always flame me if I'm wrong :-) I tried using the mySQL OLEdb (ADO) driver with Delphi. ALthough I can get a data connection and see the table names, the field lists don't appear. Calling a valid field name in a SQL clause causes a 'field not found error' Anyone have any knowledge about this that may help me solve the problem (yeah, I know don't use ADO) :-) TIA -- Pierre du Parté Final Filer Software Worrigee, NSW, Australia http://www.finalfiler.com 61 2 44220442 61 413483066 If it feels good, do it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help doesn't work in mysqlgui
mysql Is there a manual for it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, 14 February 2002 10:46 AM To: Peter Pierre Subject: Re: Help doesn't work in mysqlgui 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: sql,query 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. Just typing the word MySQL once will be sufficient, for example. You have written the following: Is there a manual for it ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Foreign keys
Hi, I am trying two create two innodb tables: 1. CREATE TABLE FIRST (NAME VARCHAR(15), COD VARCHAR(10) NOT NULL, PRIMARY KEY(COD)) TYPE=INNODB; 2. CREATE TABLE SECOND (ID INT NOT NULL, F_COD VARCHAR(10), PRIMARY KEY(ID), INDEX PAR_IND(F_COD), FOREIGN KEY(F_COD) REFERENCES FIRST(COD)) TYPE=INNODB; The second table cannot be created (errno: 150) Thanks in advance for help! Pierre - 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
ERROR 1044: Access denied
Hello, I have a problem with the access : I have created 2 users with no privileges in the user table (privileges are set in the db table, so those users can only access one particular db). the first user has all the privileges set to Y for the db hello, this user works fine. the second user has exactly the same config as the first one, but with less privileges : only the Select_priv, Insert_priv, Update_priv and Delete_priv set to 'Y' for the db hello. I can connect my sql with that user, but I can't use the db hello : mysql use hello ERROR 1044: Access denied for user: '@localhost' to database 'hello' mysql I'm surprised to have this error message... do I have to set a particular privilege to 'Y' in order to allow this user to connect to the db ??? Table db : HostDbUserSelect_privInsert_privUpdate_privDelete_privCreate_privDrop_privGr ant_privReferences_privIndex_privAlter_priv localhosthellouser2NN localhosthellouser1YY Thanks for your help ! - 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: ERROR 1044: Access denied
- Original Message - From: Dana Powers [EMAIL PROTECTED] To: Pierre-Yves [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 1:22 AM Subject: Re: ERROR 1044: Access denied ERROR 1044: Access denied for user: '@localhost' to database 'hello' This says that you are connected as user '' ( blank ) from localhost. Make sure you're logging on correctly and try again. dpk but I use the following command to connect mysql : mysql --user=user2 --host=localhost (there is no password for this user) and when I do this with the user1 it is working... so i don't think that's the problem. - 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: Recursive queries
create table root( create table subcats( create table subsections( And now I need 230 levels, huh :). How about a simple tree structure ? hth pa - 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
write conflict with myodbc
I use C++ Builder version 3 and myodbc to access a mysql database. As I want to update some record, I receive the message record is already in use by another user. I have defined a timestamp and an autoincremant field in the table to access, but the problem still remains. I made the tests with mysql version 3.22.30 on HPUX , 3.22.27 and 3.22.32 on Linux. I use MYODBC version 2.50.29 and 2.50.31. I did'nt find any solution in the manual and in the mailing lists. - 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