problems with unsubscription

the list. -- Good luck! Vladimir Please, avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: HTML in MySQL?

s not in the executing of a query. After the execution of the script: we will get: 1 and no empty lines. If you want to output the same data, that was written using a textarea field of a form, you should use the "" tag. -- Good Luck! Vladimir Please, avoid sending me Word or PowerPoint

Re: HTML in MySQL?

Hello! > Be careful here Vladimir, the (\n) are not 'null' characters; but newline > characters. Agree, I was wrong. > And i would highly recommend *not* replacing them with > tags as you write them into the database. This is asking for trouble on > so many leve

Re: HTML in MySQL?

into the database. It'll help to avoid output problems. Use preg_replace(); for it. -- Good Luck! Vladimir Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html -- MySQL General Mailing List For list archives: http://lists

Re: LIMIT alternative

Hello! Bastian Balthazar Bux, Pooly, Shawn Green, Peter Brawley, I thank you all! In fact, I don't understand why this command is not standardized (ANSI SQL, etc.). -- Удачи! Владимир Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments

LIMIT alternative

anks! -- Good Luck! Vladimir Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SQLException in tomcat with mysql-connector-java-3.1.7

Hi , I have the following problem. I run tomcat with mysql-connector-java-3.1.7 for connecting to mysql server 4.1.10a-standard.When server just a little loaded I see a lot of exceptions in tomcat log: java.sql.SQLException: ResultSet is from UPDATE. No Data. at org.apache.torque.util.BasePeer.th

optimization needed

NULL Update_time NULL Check_time NULL Create_options Comment InnoDB free: 648192 kB How can we tune this table! Thanks for your help! Vladimir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

INSERT into HEAP table

Hi All! We use MySQL 3.23.54 on ReadHat 8.0. What error code is returned for inserting into heat table over memory(row) limit? Many thanks! Vladimir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re[2]: SHOW DATABASES works in 4.0.14

VR> User has some privileges on the global level (CREATE VR> TEMPORARY TABLES, LOCK TABLES). That is why user can see list of VR> all databases. All right! :) It works, thanks! :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql

Re[2]: SHOW DATABASES works in 4.0.14

VR> What is the output of SHOW GRANTS for the users that can show list of all databases? Here it is: Grants for [EMAIL PROTECTED] GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'guru'@'localhost' IDENTIFIED BY PASSWORD '5b58234a58cd6a22' GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP,

Re[2]: SHOW DATABASES works in 4.0.14

VR> What do you mean "didn't work properly'? What exactly was VR> wrong with mysql_fix_privilege_tables? Sorry, cannot reproduce the error. The result was that some of the tables were corrected, some not. Anyway, even old privilege tables shouldn't IMHO cause the SHOW DATABASES to work. In additio

SHOW DATABASES works in 4.0.14

atabase" in my.cnf and "--skip-show-database" witch mysqld didn't help. All *.frm files in mysql database have the same md5 as those generated by scripts/mysql_install_db. -- Thanks for help, Vladimir Trebicky mailto:[EMAIL PROTECTED] -- MySQL General

RE: Join syntax diff 3.23 to 4.x?

ns OK? > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > > > > > &

MySQL embedded server example bug

: mysql_free_result(res); A simple movement of the declaration line to the beginning of the function solve the problem. Regards Vladimir -- BSc. Vladimir Espinosa Angarica Researcher National Bioinformatics Center Ministry of Science Technology and the Environment Industria y San José, Ha

About Embedded MySQL server

not have included the libmysqld.a library. There is a possible solution to this without having to get the source and compile it. Thanks Vladimir -- BSc. Vladimir Espinosa Angarica Researcher National Bioinformatics Center Ministry of Science Technology and the Environment Industria y San José, Ha

About Embedded MySQL server

having to get the source and compile it. Thanks Vladimir -- BSc. Vladimir Espinosa Angarica Researcher National Bioinformatics Center Ministry of Science Technology and the Environment Industria y San José, Habana Vieja Capitolio Nacional CUBA Fax: (53-7) 8609614 Tel: (53-7) 8604397 E-ma

mysqlhotcopy problem

How can I make hotcopy of my database if it have many tables (more than 1000) ??? mysqlhotcopy failed when it try to lock all tables ... How many tables can I lock at one time ? Can I increase this limit ? Working system: RedHat 7.3 MySQL 3.23.56 (compiled manualy) Perl 5.6.1 DBD

prepared statement vs multiple query

Hello, Is prepared statement compatible with multiple query executilng? Best regards, Vladimir Zheleznyak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

delay on executing mysql_free_result with underfetched query

fetch all data to client. Is it possible to avoid this delay? Synopsis: Delays on breaking fetch Originator: Vladimir Zheleznyak Organization: Core Lab MySQL support: none Severity: non-critical Priority: low Category: mysql client, C Class: sw-bug Release: mysql-3.23.51 Exectutable: mysqld

Re: mysql++ patch for GCC 3

I tried the patch and it still failed. Sorry for long post, but hope it may help. Thank you. Vlad. The details: $ uname -vr 2.4.7-10custom #12 SMP Mon Mar 11 00:54:16 CST 2002 $ gcc -v Reading specs from /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.0.4/specs Configured with: ../gcc-3.0.4/confi

Re: mysql++ patch for GCC 3

Did anybody build mysql++1.7.9 with RedHat Linux 7.2 and gcc 3.0.4? Any known magic to do it? Thank you for any hints. Vlad. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mys

Problems starting mysqld using Slackware 8.0

I installed Slackware 8.0 and used its pkgtool to install MySQL. After running mysql_install_db which seems to be ok, I tried starting safe_mysql which didn't work. No sinifiant error message was shown, so I tried mysql.server start which also didn't work. After all this, I tried starting via #

Re: libmysqlclient[_r].so + pthreads + gdb

It is gdb-5.0, Mandrake 8 version, with patch for threaded application under new glibc/kernel. On Sunday 05 August 2001 12:54, you wrote: > Vladimir Zidar writes: > > >Description: > > > > mysql refuses connection [local/unix-socket] when client is ran under

libmysqlclient[_r].so + pthreads + gdb

>Description: mysql refuses connection [local/unix-socket] when client is ran under GDB, and linked with pthread library. It doesn't need to call any pthread_*() function, it just fails when linked with it. >How-To-Repeat: #include #include main() { MYSQL m;

RE: What's wrong here?

Sorry. It doesn't do anything. Oh and btw, I made it so it DOES call on the function. It would help if we knew what the error or problem was? - Original Message - From: "Vladimir Kravtsov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday,

What's wrong here?

"); echo(" "."$choice_percentage"."\%"); } } } ?> Please help :)

Table won't update

The table sitesats won't update and shows no errors! (even though there are two instances of echo(mysql_error())) Any ideas?

Once again, this doesn't do anything.

The following code doesn't insert and update info in the db for some reason: It gives me the success message but the db remains untouched. What have I done this time? :) Thanks in advance.

PHP Prob contd.

Well I fixed that part so now the file looks like this: Now, when I run it I get this error: Warning: Supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot/php/X-TopSites/admin/admin.php on line 11 You have an error in your SQL syntax near 'from sitesats where valid

Another PHP/MySQL question

When I run this I get: Parse error: parse error in c:\inetpub\wwwroot/php/X-TopSites/admin/admin.php on line 8 I want it to select the id, siteurl, sitename (in a table called sitesats) of any site which is not validated (I made it so validated=1 and not validated=2) What's wrong here? T

PHP + MySQL question

Here is my db hierarchy: Database: xtopsites Table: Categories idName 1Name1 2Name2 3Name3 4Name4 5Name5 6Name6 I would like the user to get to a sign up form and have all the names of the categories displayed.is this possible to do using fetch_array? If it i

MySQL Problem -- Please help

I'm using MySQL with PHP (just learned MySQL so bear with me). Here's a two part program: Test.php: Common.php: 3000) { $hits = 3000; } $score = (($arate * 5) + ($urate * 2) + ($inhits / 100)); echo($score); //$sql = "update sitestats set score=$score where id = $id"; //mysql_query($s

MySQL compile/install problems

ax error before `char' /usr/include/sys/stat.h:169: redefinition of `struct stat * b' /usr/include/sys/stat.h:167: `struct stat * b' previously declared here /usr/include/sys/stat.h:169: parse error before `{' In file included from mysql.cc:34: ..

Re: hang problem with mysql

am. > > mysql: 3.23.37, but the problems are here even with 3.23.32 :( No special > configure options (just --prefix) :) > any suggestions? where should I look? > > Regards, Vladimir Btw, I upgraded glibc to 2.2.2, and gcc to 2.95.1 and now, when I compile mysql with new g

hang problem with mysql

(just --prefix) :) any suggestions? where should I look? Regards, Vladimir -- Phone numbers: home: +38111459023 mobile: +381641161792 - Before posting, please check: http://www.mysql.com/manual.php (the manual)