Undefined variable error with mysql-3.23.24-beta-win[1] and php-4.0.4pl1-Win32.zip on W2K with IIS 5.0

I am running a web site which runs perfectly on my Unix web hosted site. I have just moved it over to W2K and have undefined variable errors ... my thought is that mysql 3.23.24 for Windows may not support undefined variables and on unix they are supported. Any thoughts on how to get this fixed?

Mysql Server&Client& Myodbc Silent installation successfully completed

I have created a setup program using Wise Windows Installer Professional 3.0 . I also create a merge module. It can distribute mysql odbc driver and set it installed ot target windows system by using odbcinst.ini and odbc ini and required registry key. My setup uses that merge module and distribu

Working with FIND_IN_SET

I am working on a rather large database project, in which I am making a text column that contains different data, seperated by commas. What I need to do is run a query where I will return only the datasets that contain any of sets that partially, or fully match any data in the set... For exam

create table foo select * from bar does not copy keys??

I'm not sure if this is a bug or not, but I just realized today that some of my create table queries (on mysql 3.23.32 ) were not behaving as I would expect.. Example: ** mysql> create table foo (id int not null primary key, field1 varchar

uninstalling MySQL

how do I uninstall MySQL 3.22 after installing it? worst part is that I installed it so long ago that I can't remember if I did it by .rpm or .tar help please, Dave - Before posting, please check: http://www.mysql.com/manual

mysql@lists.mysql.com

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release:

Re: INSERT DELAYED still keeps CRUSHING (trying everything)

On Thursday 01 March 2001 11:03, Artem Koutchine wrote: > Sinisa, i thought i pointed out that mysql ALWAYS > crashes on any single INSERT DELAY anytime, > any database, under any conditions and during any > weather. NO single INSERT DELAY can be executed > successfully. This looks like a bug in

RE: more info on a re-install nightmare

re: my last email on a failed mySQL database install sorry ! forgot hte os etc... OS : RedHat 7.0 running on a Del CPi laptop with 128MEG ram, 4GIG Hd, pentII 266 CPU. Richard [EMAIL PROTECTED] www.stirlingbrig.com Stirling Brig - Music to Live to "Great spirits have always encounter

a re-Install Nightmare.....

Hi there... I had installed mySQL about two weeks ago, then installed php and apache. All was working fine until I STUPIDLY deleted the mysql data table in 'var' a couple of days ago. I thought I could just re-install mySQL, but it has crapped out ever since. I heard that you must install PhP AFTE

Re: problem with jdbc

On Saturday 07 April 2001 17:59, Kamil Yildirim wrote: > Hi > > I have a problem with SQL UPDATE statement within a > Java programm which establish a connection to a Mysql > Server over JDBC. The SQL UPDATE statement looks like > that: UPDATE tableX set x = x + ? where rowx = ? > where the wal

Testing alerts

I have just installed a special alert when somebody posts a message about a stack trace or segmentation fault to the general list. This is to test my alert system. Please disregard. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTEC

problem with jdbc

Hi I have a problem with SQL UPDATE statement within a Java programm which establish a connection to a Mysql Server over JDBC. The SQL UPDATE statement looks like that: UPDATE tableX set x = x + ? where rowx = ? where the walue of ? on the x = x + ? part my some times be - values and some tim

Best field type for binary data

Hello List, I'm going to be storing a LOT of MP3's in a MySQL db, what's the best field type to use? Blob? Thanks, Tyler - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.

Re: Unaligned address crash on Tru64

On Saturday 07 April 2001 13:19, Nemholt, Jesper Frank wrote: > > -Original Message- > > From: Sasha Pachev [mailto:[EMAIL PROTECTED]] > > Sent: Saturday, April 07, 2001 6:54 PM > > To: Nemholt, Jesper Frank > > Cc: [EMAIL PROTECTED] > > Subject: Unaligned address crash on Tru64 > > > >

Re: Some more about mysql perfomance.

Hi! > "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes: Peter> Hello Michael, Peter> Saturday, April 07, 2001, 3:14:42 AM, you wrote: MW> Hi! >>> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes: Peter> Hello mysql, Peter> I made one more test of mysql perfomance. Peter> PII

Re: Some more about mysql perfomance.

Hi! > "Tim" == Tim Bunce <[EMAIL PROTECTED]> writes: Tim> On Sat, Apr 07, 2001 at 02:14:42AM +0300, Michael Widenius wrote: >> >> The reason singly queries are slower are of course that the >> initialization phase (reading the data from a socket, parsing, >> locking, checking which keys to

Re: Mysql speed :)

At 13:35 Uhr -0400 6.4.2001, Vivek Khera wrote: > > ... LIMIT '3',2 > >and resulting in a parse error. The fix was to call >$sth->execute($start+0,$howmany+0) and then DBI did the right thing. A similar problem may occur if you use a text variable in a == comparison before passing it to execut

Re: Multi-level JOIN query

> Hi! > > I need some suggestions about a special query. The situation is: >There are (for simplicity) 4 tables: A,B,C and D which must be joined >like this: > Between A and B must be an outer-join association and C and D must >be connected to B also with outer-join. >But this ca

RE: Unaligned address crash on Tru64

> -Original Message- > From: Sasha Pachev [mailto:[EMAIL PROTECTED]] > Sent: Saturday, April 07, 2001 6:54 PM > To: Nemholt, Jesper Frank > Cc: [EMAIL PROTECTED] > Subject: Unaligned address crash on Tru64 > > > Jesper: > > The problem is apparently a bug that under some circumstances

Re: date select question (better explained)

>> > I'm trying to figure out how to select records from an events >>> database which (from today) will take place on next weekend. The >>> table has a from_date and a to_date fields, among other. I've found a >>> way mixing PHP with SQL, but I'm curious to know if is there a neat >>> and pur

Re: Foreign Keys

>On Thu, 5 Apr 2001, Dennis Gearon wrote: > > > Date: Thu, 05 Apr 2001 14:24:25 -0700 > > From: Dennis Gearon <[EMAIL PROTECTED]> > > To: [EMAIL PROTECTED] > > Subject: Foreign Keys > > > > Are people using Mysql using foreign keys and how are they using them? > > It seems that the way to u

logging doesnt work with bdb if --with-debug

>Description: After several sig 11 I compliled a --with-debug version and enabled debugging and logging. Mysqld crashed shortly after starting without trace (!) and then immediatly crashed again after restart. /sw/pkg/mysqldebug/3.23.36/libexec/mysqld: ready for co

Re: Advice on where to go next in profiling a query

There is an option long_query_time that you can use to log query that take longer then a preset time, if that's of any help. cheers, roel On Sat, Apr 07, 2001 at 02:05:13PM +0100, Ewan Birney wrote: > > > We are very happy users of MySQL, which we run a nice big genome database > on. We hav

Unaligned address crash on Tru64

Jesper: The problem is apparently a bug that under some circumstances tries to store an integer at an unaligned address with movl instruction. Slave code does a lot of address magic, so there is a lot of room for alignment bugs. Any chance you could run the slave in a debugger and find the lin

Multi-level JOIN query

Hi! I need some suggestions about a special query. The situation is: There are (for simplicity) 4 tables: A,B,C and D which must be joined like this: Between A and B must be an outer-join association and C and D must be connected to B also with outer-join. But this causes a 'Cro

New filter

I have now installed the new spam filter on this list. It is very simple - instead of having bad words, we now have good words. You must mention one of the following: sql, database, query in the body of your message to get past the filter. Substrings are ok, and check is case-insensitive so if

Re: ./configure help

> err mex: > "configure: error: installation or configuration problem: C > compiler cannot create executables" Take a look at config.log, you will usually find the real cause for the error in there. Jens - Before posting, plea

Re: ./configure help

At 17:25 7-4-01 +0200, com2 wrote: >hi everybody we get this err mex when we run: >./configure --prefix=7usr/local/mysql Hrrr, 7usr/local/mysql ? dunno if that's the reason.. but it might not be able to find such path. /usr/local/mysql perhaps?? Bye, B.

Re: huidziekte

Sorry, maar het merendeel van de mailinglist spreekt ten eerste geen nederlands en het onderwerp van de mailinglist ligt wat anders dan de hieronder beschreven problemen... Gaarne dit soort mailtjes prive te houden, ook met het respect op de mensen die het al helemaal niet begrijpen. bvd. --

./configure help

hi everybody we get this err mex when we run: ./configure --prefix=7usr/local/mysql err mex: "configure: error: installation or configuration problem: C compiler cannot create executables" hoping that u can help us, we wish u a good day

date select question (better explained)

> > I'm trying to figure out how to select records from an events >> database which (from today) will take place on next weekend. The >> table has a from_date and a to_date fields, among other. I've found a >> way mixing PHP with SQL, but I'm curious to know if is there a neat >> and pure SQL

3.23.36: created tables still corrupted

Hi, i once reported this together with the "update fails after alter"-bug in 3.23.35; this is how it "works": mysql> DROP TABLE IF EXISTS ttt; Query OK, 0 rows affected (0.01 sec) mysql> CREATE TABLE ttt ( -> i1 varchar(10) default NULL -> ) TYPE=MyISAM; Query OK, 0 rows affected (0.0

Advice on where to go next in profiling a query

We are very happy users of MySQL, which we run a nice big genome database on. We have a web front end to the database (www.ensembl.org if anyone is interested) and we are looking at getting our pages to come back faster. I have been moving things out of Perl into C for the heavier lifting betw

Re: Enquiry

Sounds like you downloaded the Source code ... you need the 'Standard binary (tarball) distribution' for 'Windows 95/98/NT/2000 (Intel)' (at http://www.mysql.com/downloads/mysql-3.23.html) Download the binary version, unzip it, and you will be set to go! - Original Message - From: "Amit"

Transactions in MySql

MySql support transactions? The OLE-DB provider support transactions? Call the method Begintrans on a connection object (ADO) return an error!!!

Re: Can't run MYSQL 3.23.36 on HPUX 10.2

Kory Wheatley writes: > I'm Trying to install the Binary Installation of Mysql 3.23.36 > on HPUX 10.2. I receive the following > error when I run the > "scripts/mysql_install_db" Command. > > Warning: setrlimit couldn't increase number of open files to more > than 60 . > > Warning: Cha

Re: MySQLGUI strange behavior

Peter Adamka writes: > Hi > 1, I got packages from mysql site (3.23.33). > 2, The mysqlGUI is 100% statical. > 3, It crashes after I try to create database and then going to admin > panel. > 4, I've found something that I've not seen. It end crashes with segfoult. > >

Re: Enquiry

amit you will need to install MyODBC (available from www.mysql.com) and install that...you could then access it from VB6 as you would access any other ODBC data source, from MS Access to SQL Server to Oracle. -kg Amit wrote: > Dear Sir, > > This a mail from a new established software com

Re: HELP me!

Could you do a ps -aux |grep mysql This will tell you if mysql is already running. Adrian On Fri, 6 Apr 2001, François Grenapin wrote: > the file error_lod said me that : > 10406 10:59:50 mysqld started > 010406 10:59:51 Can't start server : Bind on unix socket: Permission > non accordée

Re: Using Full-Text Query in the HAVING clause

Hi. On Apr 05, [EMAIL PROTECTED] wrote: > >Description: > Pretty simple, just try to do a "match(column) against ('text') in the > HAVING clause of a SELECT statement. Restarts my database server every > time. I'm replying now just to assure I didn't miss your mail. The bug i

Re: Some more about mysql perfomance.

Hello Michael, Saturday, April 07, 2001, 3:14:42 AM, you wrote: MW> Hi! >> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes: Peter>> Hello mysql, Peter>> I made one more test of mysql perfomance. Peter>> PIII-700/768Mb/Linux 2.4.2 glbc 2.1.3 Peter>> I had the followings tab

Re[2]: Some more about mysql perfomance.

Hello Tim, Saturday, April 07, 2001, 3:21:52 AM, you wrote: >> The reason singly queries are slower are of course that the >> initialization phase (reading the data from a socket, parsing, >> locking, checking which keys to use) is about half of the query time. >> >> Peter> Heikki made tests