Re: strange behaviour in foreign keys

2004-05-28 Thread Victoria Reznichenko
[EMAIL PROTECTED] wrote: > > I've been running MySQL 4.0.x on a RH9 machine for some months and everything > was fine. I could create tables of type InnoDB and define FOREIGN KEY's all > was well. > > A few days ago it does not let me create tables with foreign keys anymore it > says some

Re: Strange behaviour of mysql 4.0.18 with create table query

2004-05-02 Thread Paul DuBois
At 23:13 +0200 5/2/04, Alessandro Sappia wrote: When I create a table with InnoDB there is a strange behaviour in it: mysql> CREATE TABLE prometeo_indirizzi_cliente ( -> indirizzi_cliente_id int(10) unsigned NOT NULL auto_increment, -> denominazione_indirizzo_id int(10) unsigned default

Re: strange behaviour

2003-01-03 Thread Ken Menzel
Hi Wash, Please see ntoes on this page for explanations. http://jeremy.zawodny.com/blog/archives/000203.html#000203 Next please upgrade to 3.23.54 as this does contain some fixes that should help including a compile option for broken real path. Here are my compile flags, I don't recommend -O3 b

Re: Strange behaviour of mysqld after dropping a column

2002-08-28 Thread Sinisa Milivojevic
Cams Ismael writes: > Description: > A time ago I reported next bug: > > "The ALTER TABLE command behaves very strange when stopping and > restarting the MySQL server afterwards. I noticed this after having > rebooted my PC (which means that the MySql server is st

RE: Strange behaviour of mysqld after adding/dropping a column

2002-07-09 Thread Cams Ismael
[mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 3:02 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Strange behaviour of mysqld after adding/dropping a column Cams Ismael writes: > Hello Sinisa, > > have you already found the origin of the problem ? How

RE: Strange behaviour of mysqld after adding/dropping a column

2002-07-09 Thread Sinisa Milivojevic
Cams Ismael writes: > Hello Sinisa, > > have you already found the origin of the problem ? How does the bugs get > fixed -> are they solved in patch releases or are they solved in a next > release of the MySQL server ? > > Kind regards, > Ismaël > Sorry to have lost your e-mail. If that is a

RE: Strange behaviour of mysqld after adding/dropping a column

2002-07-08 Thread Cams Ismael
ent: Tuesday, July 02, 2002 1:43 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Strange behaviour of mysqld after adding/dropping a column Cams Ismael writes: > Hello Sinisa, > > this has nothing to do with services. I have also tried this without > cre

RE: Strange behaviour of mysqld after adding/dropping a column

2002-07-02 Thread Sinisa Milivojevic
Cams Ismael writes: > Hello Sinisa, > > this has nothing to do with services. I have also tried this without > creating a service and the result is the same. > Normally the services are also stopped automatically when logging of, so I > don't understand why I should stop it manually. Also I have

RE: Strange behaviour of mysqld after adding/dropping a column

2002-07-01 Thread Cams Ismael
after dropping/adding a column messes up your database ! Can you please check this ? Kind regards, Ismaël -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 4:52 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: St

RE: Strange behaviour of mysqld after adding/dropping a column

2002-07-01 Thread Sinisa Milivojevic
Cams Ismael writes: > * I have indeed installed MySQL as a service. That's why I use 'net stop > mysql' and 'net start mysql' to start and stop the MySQL server. > > * I have done nothing special before rebooting my PC. The problem doesn't > seem to lay in rebooting the PC, but in stopping and

Re: Strange behaviour of mysqld after adding/dropping a column

2002-07-01 Thread Sinisa Milivojevic
Two questions : * have you installed MySQL as a service ?? * have you stopeed a service prior to rebooting ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\

Re: Strange behaviour with SQL vars and order by

2002-04-23 Thread Gerald Clark
I see no column named Site.nome showing that it is wrong. ds wrote: >Hi, > >I'm having a strange problem using SQL vars (@variable) and an order by >expression. > >I have a query that returns a record for each day. >Each record has a date (data), a column with the daily total value >(uv_views)

Re: strange behaviour

2001-11-19 Thread Ian Barwick
On Monday 19 November 2001 09:51, you wrote: > Hello, > started a new compiled MysqlDataBase on my local Machine > everything okay sofar. > added a ./bin/mysqladmin -u root password '' (password omitted) > no problem > I tried it several times to log in to create a database but only gettin