Gábor Lénárt writes:
> Hi,
>
> It's me again ;-) Now I have got a very serious problem. I've just downloaded
> 3.23.32 and compile then run it without any major trouble. BUT my headache
> is about this:
>
>
> mysql> insert into cikk values (NULL,'Beta','','','','','N','','',NULL,0,0,0,0);
> mysql> select * from cikk where cim='Beta';
>
>+----+------+--------+--------+--------+---------+--------+--------+-----------+----------------+----------+----------+-------------+-------+
> | id | cim | cimurl | cimkep | szoveg | hszoveg | fontos | forras | forrasurl |
>feldatum | felvitte | moddatum | modositotta | tipus |
>
>+----+------+--------+--------+--------+---------+--------+--------+-----------+----------------+----------+----------+-------------+-------+
> | -1 | Beta | | | | | N | | |
>20010214120417 | 0 | 0 | 0 | 0 |
>
>+----+------+--------+--------+--------+---------+--------+--------+-----------+----------------+----------+----------+-------------+-------+
>
> I've tried use 0 or NULL as value for 'id' when doing the insert query.
>
> The structure of table 'cikk' is:
>
> CREATE TABLE cikk (
> id bigint(20) NOT NULL auto_increment,
> cim varchar(200),
> cimurl varchar(100),
> cimkep mediumblob,
> szoveg text,
> hszoveg text,
> fontos enum('Y','N') DEFAULT 'Y' NOT NULL,
> forras varchar(200),
> forrasurl varchar(100),
> feldatum timestamp(14),
> felvitte bigint(20),
> moddatum bigint(20),
> modositotta bigint(20),
> tipus bigint(20) DEFAULT '0' NOT NULL,
> KEY id_index (id),
> KEY tipus_index (tipus),
> KEY feldatum_index (feldatum),
> KEY fontos_index (fontos)
> );
>
> Any values inserted the table become id -1 ... ;-(
>
> However if I try declare id as unsigned I got an awfull big number as 'id',
> and I can't even delete it with 'delete from cikk where id=.....;', mysql
> monitor simply returns that 0 row is affected, and the data is still exists
> in the table.
>
> It's very serious for me since this is a commercial site.
>
> I had to upgrade to new mysql version, since old one became unusable one
> day (a very long query was blocking mysql forever with all of idle CPU
> time used. if I tried to strace that mysqld process with strace -p ...,
> it created a null length file and the process exists. However at home
> with mysql 3.23.31 it was fine, and with 3.23.32 it's okey too, but now
> I have got this auto_increment problem).
>
> Note, that I USED id -1 in this table for a special purpose, but now I
> deleted ALL ids smaller than 1 then I tried to insert but it does not
> work. It didn't work if I tried to dump the database (only with ids>0)
> drop table, then recreate table and data from the saved dump).
>
> By the way, the query which had got problems with the older mysql version
> on our server was:
>
> SELECT i.id as id,i.fullservice as fullservice,i.www as www,i.ceg as
> ceg,v.varos as varos,i.irszam as irszam,i.tel as tel,i.fax as fax,i.email as
> email,i.tevleir as tevleir,t0.terulet as t0,t1.terulet as t1,t2.terulet as
> t2,t3.terulet as t3,t4.terulet as t4,t5.terulet as t5 FROM ceginfo as
> i,cegvaros as v,cegterulet as t0,cegterulet as t1,cegterulet as
> t2,cegterulet as t3,cegterulet as t4,cegterulet as t5 WHERE i.varos=v.id AND
> i.terulet0=t0.id AND i.terulet1=t1.id AND i.terulet2=t2.id AND
> i.terulet3=t3.id AND i.terulet4=t4.id and i.terulet5=t5.id AND ervenyes='Y'
> AND i.ceg LIKE '%balogh%' ORDER BY ceg LIMIT 0,10;
>
> But now it's not problem. My only question is how can I avoid that auto_increment
> problem.
>
> PLEASE, help me.
>
> And please cc the mail for me too, I'm not on the list.
>
> Thanx a lot in advance, Gabor.
>
>
> --
> --[ Gábor Lénárt ]---[ Vivendi Telecom Hungary ]---------[ [EMAIL PROTECTED] ]--
> U have 8 bit comp or chip of them and it's unused or to be sold? Call me!
> -------[ +36 30 2270823 ]------> LGB <-----[ Linux/UNIX/8bit 4ever ]-----
Hi!
I have just tested your case on my Linux and it worked just fine.
What OS is that and are you using our binaries. If not, please do.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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