| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> http://201.243.40.140/~kakei/pruebas/borrar.php check
<1> kakei, do you see the problem yourself now?
<0> hmm =( im dummie no
<1> $id is not getting set.
<0> oh
<0> hmmm infi any idea of how can i fix that?
<1> that'd be a PHP thing
<0> evil php ;p
<2> globals i suppose
<2> $_GET['id'] instead of $id
<1> but I suspect that it's because you're using a GET request, but trying to read the data as a POST
<1> yeah
<1> fix that, so I can show you what else is wrong ;)
<0> ok
<0> ^^
<0> i did like that
<0> and now is working
<2> $5
<2> ;)
<0> :}
<0> ya
<0> y
<3> hi, i have a question about constraining data to more than just the data type and length (like VARCHAR(3))
<3> can you put formatting constraints on data, like an email attribute must be *@*.* ?
<1> kakei: http://201.243.40.140/~kakei/pruebas/borrar.php?id=1%27%3BDESC%20informacion%3B
<1> kakei, it doesn't output it, but I bet the query is being executed.
<1> kakei, you need to check your input variables.
<0> http://201.243.40.140/~kakei/pruebas/enviar.php send a new one and try to delete
<4> goob: MySQL supports the syntax, but it doesn't validate the data
<4> !m goob constraints
<5> goob: (How MySQL Deals with Constraints) : http://dev.mysql.com/doc/mysql/en/Constraints.html
<4> no that's not it
<4> ffs
<0> infi, actually (now) i'll try to make something like IF form is null print nothing =p
<4> goob: anyway, it can be set, but it's ignored
<3> darien: thanks
<1> kakei, you missed the point, but nevermind, you'll figure it out eventually
<1> good luck
<0> :)
<2> yeah man
<2> we'll figure
<2> mysql owes me like 5 beers
<2> and they better pay by noon tomorrow
<2> or i will evil them
<4> rock on
<2> rock!?
<2> i'll need another beer then
<2> or a neighbour
<4> rock out with your cock out
<2> wheee cockism
<2> i had to give a 2 hour cl*** to some dude aboout mysql today.. like gah need more beer
<4> nic
<4> e.
<2> well.. he had coffee and cookies.. so was ok
<2> :D
<1> did you lengthen your tutorial just so you could have more cookies?
<1> "now that I've answered your immediate questions," *MUNCH* "let me explain each of the command line options in lengthy detail..." *MUNCHMUNCH*
<2> hehehehe
<2> indeed ;)
<2> actually had to teach him icky pma
<6> HI
<6> I am accesing my mysql instalation from java
<6> but I get this error
<6> java.sql.SQLException: null, message from server: "#HY000Host 'localhost.localdomain' is not allowed to connect to this MySQL server"
<6> how can I fix it? why I get this error? can any one please help me?
<7> hello, do you know how tyo setup embarcadero with mysql?
<6> solve it
<6> mysql> grant all on estudio.* to root@localhost.localdomain;
<8> Juanjo-ar-stafe: Right.
<6> thakns
<6> bye
<8> Sonny: They have documentation. You can probably set up an odbc data source. I don't know if they have another mechanism.
<7> yep i did
<9> I'm having a program getting mysql started on my system, so I'm going to uninstall it, and reinstall it, I'm not sure if that will remove my db's, so if I copy the physical table.MYD/MYI/frm files, will I be able to "use" these after I reinstall mysql?
<10> Super-Fly I think: yes
<9> doesn't sound to re***uring =\
<9> I guess its better than having nothing right now
<10> Super-Fly I'm not sure, but I tried to do it and it worked - but I don't remember exactly...
<10> Super-Fly I'm not sure wheter I tried to do it
<9> I really don't think its going to remove my databases when I uninstall mysql, but I really won't know until I do it
<10> Ok, I will test it on my computer - I dont have any critical data on it...
<9> I have about 200,000 rows that have been added since my last backup that I won't want to loose
<10> Ok wait few minutes
<8> Super-Fly: 1) Always backup your data. 2) uninstall does not delete databases.
<9> Xgc: I had a problem with php that I wasn't aware of, and it wasn't backing up my data, and now thats led to a libmysqlclient.so.12 error
<8> Super-Fly: Use mysqldump or some other means.
<9> well, mysql can't start now, I really don't know whats going on
<8> Super-Fly: Then just save the data files in your database-specific directory..
<9> thats where I'm at now
<8> Super-Fly: The problem with that approach is potential compatibility issues if you decide to upgrade.
<9> apparently you can't (easily) move from mysql 4.0.x to the newest version, and against the recommendation of my package manager, I did it anyway, causing all of these problems
<8> Super-Fly: It's important to follow the instructions.
<8> Super-Fly: Upgrading isn't a this or that choice. You can run several different versions of MySQL at the same time.
<9> ah
<8> Super-Fly: So it wasn't necessary to trash your original/working 4.0 install.
<11> yo peeps, when im adding a huge 900mb sql file to database using simple mysql -u [username] --p***word=[p***word] -h localhost [database] < [filename] im getting an error "MySQL server has gone away"
<11> is that mysql timing out on me?
<8> GoatDevil: Probably.
<11> but then how would i tell it not to ?
<8> GoatDevil: Check your max settings (max allowed packet, etc).
<8> GoatDevil: Check to see if the server is really still up.
<8> Reconnect.
<11> im doing it locally thou, does it still counts as packets?
<8> GoatDevil: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
<10> Super-Fly it works
<10> I created back-up of these MySQL files (on Linux /var/lib/mysql), and then removed them
<10> then reinstall mysql-server, copied this directory back, restart server - everything's OK
<9> cool
<12> #1 - Can't create/write to file '/tmp/#sql_1a5a_0.MYI' (Errcode: 28) ??
<4> !perror 28
<5> System error: 28 = No space left on device
<4> your drive is full
<12> hmmm
<12> thats not kool
<9> Xgc: I recompiled it, and its still not starting, the init script says its started, but its not
<8> Super-Fly: Don't recompile. Just install the provided binary distribution.
<9> I use gentoo
<9> there is no binary
<9> in my /var/log/mysql/mysqld.err I get 060212 14:16:40 [ERROR] Can't init databases
<9> oh, I had to change a log file size in my.cnf to get it to start
<13> any ideas why mysqldump would fail to dump the entire database, it seems to dump a small portion of a table then just dies... no error inside .err file or anything
<14> I hope I don't piss anyone here off by saying this, but the documentation on MySQL's site ****s. Is there a place I can find something better?
<15> yes, on the internet !
<14> I've looked =\
<14> It'd be fine - the documentation that's there - if I knew all the right words and what the words meant.
<14> Hmmm.
<14> ALTER TABLE line_items ADD CONSTRAINT fk_items_product FOREIGN KEY ( product_id ) REFERENCES products( id )
<14> see any problems with that?
<14> I'm getting #1005 - Can't create table '.\depot_development\#sql-648_1d.frm' (errno: 150)
<14> Both tables are InnoDB
<16> if a mysql table has a datetime field and you update one of the entries will that change the datetime?
<14> try it
<14> or if you don't want to, hold on a second and I will
<16> i would but i don't have any access to it right now
<14> ok one sec
<14> I'm using 4.1.18 btw
<14> Nope, it doesn't.
<16> okay.. that is what I was hoping :) thanks
<14> So, umm. Nothing on the constraint problem?
<17> hi, i've got a question on joins/subqueries... i've got a query i need to perform but I can't quite get it right - http://pastebin.com/551626
<17> anyone around to help?
<18> do I have to use libmysql[client] to communicate with mysqld? or can I connect to the socket and talk directly to it?
<4> use the client
<18> ok, guess I've gotta figure out ffi
<4> in order to 'talk directly to it' you'd basically have to re-implement the entire client library anyway
<18> heh
<4> providing functions like last_insert_id(), etc.
<18> I like that one :)
<8> r0xoR: Your spelling is the issue. v doesn't exist.
Return to
#mysql
or
Go to some related
logs:
#css
#suse
Starting PostgreSQLcould not start postmaster
writing to kio_svn is not supported
#linux
sudoers asterisk nobody
#mysql
#perl
Perl + Regular Expression + multilines
psl2 wine
|
|