| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Comments:
<Darien> foo: ?
<foo> Darien: debian 4.1 is out?
<winmutt> yes
<winmutt> no
<Darien> foo: ?
<winmutt> debian mysql 4.1
<Darien> no
<foo> oh, heh, my bad.
<foreyez> do you guys know if php/mysql programmers generally make more, less, or about the same as c++/java/c# programmers?
<kuki> 4[winmutt4] I have now 4.1 but my innodb next failled
<rioter> foreyez all depends on skill
<foreyez> rioter, on average
<rioter> couldnt say, seen some c++ programmers get 30k while php gets 100k plus, but ive also seen the reverse
<test34> foreyez, probably depends where you live too
<foreyez> test34, big city... say la, san francisco, new york
<olsen> i do it for a living and i can barely pay my rent
<olsen> php
<olsen> so i sell drugs also
<foreyez> olsen, heh
<rioter> olsen haha
<winmutt> kuki
<Darien> !m foo uuid
<SQL> foo: (Miscellaneous Functions) : http://dev.mysql.com/doc/mysql/en/Miscellaneous_functions.html
<winmutt> you need to cut and paste the entire error message
<foo> Darien: ah, I guess I'll just use that. thanks
<winmutt> are you using phpmyadmin by anychance?
<kuki> 4[winmutt4] yes, i am use phpmyadmin
<kuki> do i must change my p***word ?
<foreyez> olsen, do you live in a city?
<olsen> i don't know
<olsen> it's more like a house
<eml> how do I know how big an int has to be? :p
<foreyez> wow... funny.
<winmutt> kuki: dont use phpmyadmin
<eml> I have a maximum of 250 that can be inserted, wouls smallint(1) be enough?
<eml> would*
<OrbX> eml > smallint(3)
<eml> OrbX, okay, how do you know that?
<winmutt> phpmyadmin==crap
<OrbX> eml > because 3 is the number of integers
<OrbX> eml > up to 999
<eydaimon> what's wrong with phpmyadmin now?
<eml> OrbX, OrbX ok
<eml> wops =)
<OrbX> eml > no prob ;)
<eml> further, a maximum value of 12? Some values may be floats/decimals
<eml> am I going for a decimal(3)? :P
<Isaiah> I've need some help with a procedure that I'v created... it gives me error on this line "DECLARE Num_defect INTEGER;"
<Adeel> MySQL server has gone away
<Adeel> what does this error mean
<Isaiah> isn't that how you could decalrge an integer?
<zircu> the connection was lost
<Adeel> im trying to upload a 1.5 mb file in a mysql db
<Adeel> this is the error it gives
<zircu> Adeel: are you allowed to send that much data in one request?
<Adeel> 'max_allowed_packet'
<Adeel> Got a packet bigger than 'max_allowed_packet' bytes
<Adeel> this is the error
<Xgc> Adeel: Change that setting.
<zircu> i thought it was that you were having trouble with a 'Server has gone away' error
<Adeel> is it a php error or mysql?
<phillipmarlowe> i just installed the Centos 4.2 rpm for mysql-server and attempted to start the database. I received the following error message: InnoDB: Error: pthread_create returned 12
<Adeel> earlier that was the error
<Adeel> now this
<phillipmarlowe> i haven't been able to find anything useful on Google, if someone could point me in the right direction, it would be appreciated
<zircu> Adeel: well the first error is from php when the connection isn't valid anymore
<winmutt> phillipmarlowe: sounds like you dont have pthreads
<Adeel> and max packet allowed one ?
<zircu> Adeel: a setting you have to change for the server
<Adeel> mysql server or IIS ?
<zircu> mysql
<phillipmarlowe> thanks, winmutt
<winmutt> phillipmarlowe: you may just want to compile your own copy of mysql
<phillipmarlowe> i may do that winmutt, i am just curious why the rpm would enable pthreads but not require it
<Adeel> buffer pool size is 8 m
<Adeel> and mem pool size 2 m
<zircu> phillipmarlowe: my guess it would be there is a conflict with the version of pthreads
<Adeel> what is the reason for mysql server has gon away error normally?
<zircu> Adeel: you want change the 'max_allowed_packet' var
<thesefirah> can someone help me repair some tables ?
<Adeel> where is it located, its not in php.ini
<zircu> Adeel: a few, the thread you tried to use had timed out and no longer is valid
<Adeel> and not in my.ini aswell :S
<mareks> how to make mac reconnect to a network volume @ login?
<swast> Hekko guys
<swast> i have strange problem
<Julian|Work> mareks, this is #mysql -- we don't know about macs
<zircu> Adeel: it wont be in php.ini. if it isn't specified in your my.cnf then mysql will default to a value, you need to set the value you need in my.cnf and restart mysql
<swast> i have innoDB , where row parent_id REFERS to id field, and ON UPDATE CASCADE, but i get error when i trie to
<swast> UPDATE `menu` SET `id`='1141425085' WHERE `id`='32'
<winmutt> tried to ?
<winmutt> what was the error
<swast> nativecode=1217 ** Cannot delete or update a parent row: a foreign key constraint fails]"
<Adeel> ok
<winmutt> swast: show innodb status;
<winmutt> dont paste it all in here
<winmutt> but that should tell you the problem
<winmutt> more than likely the data type is not the correct size
<swast> this ?
<swast> "InnoDB free: 11264 kB; (`parent_id`) REFER `asterisk/menu`(`id`) ON UPDATE CASCADE"
<Adeel> zircu thanks it worked
<Adeel> :)
<swast> winmutt how to get innodb status ?
<winmutt> swast: show innodb status;
<winmutt> swast: "show innodb status;"
<signature16> whats the difference between mysql ab and other versions?
<swast> winmutt yes, thanx - and to whci row pay attention ?
<swast> whci=which
<winmutt> last error
<winmutt> LATEST FOREIGN KEY ERROR
<swast> Trying an update, possibly causing a cyclic cascaded update\nin the child table, in parent table, in index `PRIMARY` tuple:\
<swast> this?
<albo> update ads set nextreport=adddate(nextreport,INTERVAL 1 MONTH),lastreport=nextreport where adtype='web' and nextreport < now()
<Darien> !m Darien asdfas
<SQL> Darien: Nothing found
<winmutt> swast: yes
<Darien> hooray
<albo> why is lastreport getting set to +1 MONTH instead of the old value of nextreport
<swast> winmutt but i need an cascaded update ... why it is an error?
<winmutt> show create table "tablename" cut and paste the fkc onstrint line
<swast> "ALTER TABLE `menu` ADD FOREIGN KEY(`parent_id`) REFERENCES menu(`id`) ON DELETE CAS
<swast> CADE ON UPDATE CASCADE;";
<swast> this ?
<swast> CREATE TABLE `menu` (\n `parent_id` int(11) NOT NULL default '0',\n `id` int(11) NOT NULL auto_increment,\n `title` text NOT NULL,\n `link` text NOT NULL,\n `parameter` text NOT NULL,\n `menu_id` int(11) NOT NULL default '0',\n PRIMARY KEY (`id`),\n KEY `parent_id` (`parent_id`),\n CONSTRAINT `menu_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `menu` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=latin1
<Darien> !man uuiod
<SQL> Nothing found.
<Darien> !man uuid
<SQL> (Miscellaneous Functions) : http://dev.mysql.com/doc/mysql/en/Miscellaneous_functions.html
<swast> winmutt ?
<foo> Bleh, shouldn't I be able to do something like INSERT INTO tables(id) value(UUID()) ? I'm getting an error with this.
<SanDayGoDom> Hello all
<SanDayGoDom> Anyone know what is wrong with #php everytime I try to /j I get sent to a channel called #overflow
<DjViper> full
<DjViper> or join flood
<SanDayGoDom> damn
<DjViper> just wait a few seconds then try again
<SanDayGoDom> ok anyone here can answer a php/mysql question.
<archivist> register your nick
<SanDayGoDom> opps
<SanDayGoDom> damn
<Shaba1> thanks
<Shaba1> that did it/
<sjrussel> score! left before being kicked
<archivist> hehe
<sjrussel> foo, what error?
<foo> You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '())' at line 1
<sjrussel> 'an error' isn't very descriptive
<Siraris> Anyone familiar with using MySQL with vs.net?
<foo> Siraris: I know I should have values()
<sjrussel> !m sjrussel UUID
<SQL> sjrussel: (Miscellaneous Functions) : http://dev.mysql.com/doc/mysql/en/Miscellaneous_functions.html
Return to
#mysql
or
Go to some related
logs:
yakuake crash xcomposite
trouble wlanassistant
#perl
muine importerror gstreamer
#linux
#suse
picocom emulator
#sendmail
#linux
no screen found xserver failed ubuntu
|
|
