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