Undefined variable: authed

: authed in /var/www/html/lcc/secure/secure.php on line 34 mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386) PHP 4.3.9 (cgi) (built: Oct 20 2004 14:52:04) Thanks for you help Trevor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: how to print warnings from mysqlimport...debug_options ??

Hi Guys, I have been searching for the answer to this question for a while. The answer is so obvious, yet there was no useful source of documentation that showed it. I am using the load data infile syntax rather than the command line utility. To get the warnings the show warnings command is

Fully compliant GIS

. Thanks, Trevor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL and NPTL

2.3. I haven't tried the export line. Trevor Steve Meyers wrote: Has anyone else experienced this bug? http://bugs.mysql.com/bug.php?id=868 We've been seeing this problem on several of our servers (see the last comment to the bug). MySQL just hangs occasionally, it happens about 3-4 times per month

Change ft_min_word_len require fulltext index rebuild

Mysqlians, I just discovered that a server has ft_min_word_len=4 when I want ft_min_word_len=3 . Do I have to rebuild all the fulltext indicies so that searches on three-letter words will work correctly? Trevor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: avoiding Locked threads

priority with updates. I did ask on the list if there were any plans for a delayed update, but I was told there aren't. Trevor Jon Drukman wrote: Dathan Vance Pattishall wrote: log-bin=/var/opt/mysql/db2-binlog skip-innodb log-error=/var/opt/mysql/db2-errlog This is on a separate drive? yes

Maintaining fulltext

, Trevor p.s. See you at the conference. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Low_Priority Updates

Mysqlians, Does a low_priority behave like a DELAYED for insert and return to the caller before the update has actually been executed? If not are their plans for a DELAYED option with update? Regards, Trevor -- MySQL General Mailing List For list archives: http://lists.mysql.com

Read bursts on datadir

those just pulling in record data which should be cached by the file system already? I have included the explain of query A below. Any advice would be most appreciated. Regards, Trevor

yearweek() result back to date format?

) | +---++ | Wednesday | 200346 | +---++ 1 row in set (0.00 sec) to extract the start and end dates for that week (for example, 2003-11-09 and 2003-11-15 above)? I'm using server v3.23. -- Trevor Smith|[EMAIL

how to upgrade / dependencies problem

When I try to upgrade from v4 to v4.1, I get the following dependencies problems: [EMAIL PROTECTED] trevor]# rpm -Uvh MySQL-shared-4.1.1-0.i386.rpm error: Failed dependencies: libcrypto.so.0.9.6 is needed by MySQL-shared-4.1.1-0 libssl.so.0.9.6 is needed by MySQL-shared-4.1.1-0

start / end dates for each week of year?

there might be no data entered until Wednesday of any given week. So the first date with data entered for a given week is variable and adding 7 days to it would not produce a predictable or desirable result. -- Trevor Smith|[EMAIL PROTECTED] -- MySQL General Mailing List For list archives

Slow innodb replication

database my load is 0.5 add all I am doing is replication. Any advice/suggestions/stabs in the dark is much appreciated. Trevor

Loading the .myd into memory

Mysqlians, Greetings. Besides the query cache is their a buffer which holds the data portion of MyISAM tables. All the buffers seem to hold key information or query processing information. Thanks, Trevor

Table lock statistics by TABLE not just server,db

counters only give information on a server level. I want to examine this data per table. Does anyone know how to do this? Many Thanks, Trevor

Mysql on Solaris 8/9 with ultrasparc

or any kernel or filesystem changes they made. In my particular, case single-threaded tests (sql-bench) compare similar for the sunfire against dual proc 2.4 xeon systems (redhat 9) but under site load the sunfire slows to a crawl. Happy Holidays, Trevor

Re: reset auto_increment

Trevor Rhodes === Powered by Linux- Mandrake 9.2 Registered Linux user # 290542 at http://counter.li.org Registered Machine #'s 186951 Mandrake Club Silver Member Source : my 100 % Microsoft-free personal computer

Re: two tables

. The second says ERROR 1064: 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 'select det_id from details_tb where fin = y)' at line 3 which one will execute faster ? The first. Regards Trevor Rhodes

Re: two tables

y I'm trying to get Smith and Barfbag to show up instead of all three. Regards Trevor Rhodes === Powered by Linux- Mandrake 9.2 Registered Linux user # 290542 at http://counter.li.org Registered Machine #'s 186951

two tables

all 103 rows instead of just the ones I need. Any help here would be most appreciated. Regards Trevor Rhodes === Powered by Linux- Mandrake 9.1 Registered Linux user # 290542 at http://counter.li.org Registered Machine #'s

Cardinality Bug ?

| | +-+++--+ +---+-+--++--++- + 8 rows in set (0.00 sec) mysql select count(distinct date_created) from POSTING ; +--+ | count(distinct date_created) | +--+ | 223284 | Thanks, Trevor

Basic error

/tr\n; } print /table\n; mysql_close( $link ); === Regards Trevor Rhodes === Powered by Linux- Mandrake 9.1 Registered Linux user # 290542 at http://counter.li.org Registered Machine #'s 186951

Re: Basic error

resource Regards Trevor Rhodes === Powered by Linux- Mandrake 9.1 Registered Linux user # 290542 at http://counter.li.org Registered Machine #'s 186951 Mandrake Club Silver Member Source : my 100 % Microsoft-free personal

2 Fulltext index's are better than 1? No

and the query is quick. If anyone has any idea why USING a fulltext index is slower please share your knowledge. Below is the show create table output. Thanks, Trevor | INTEREST | CREATE TABLE `INTEREST` ( `ID` varchar(40) NOT NULL default '', `PERSON_ID` varchar(40) NOT NULL default

Ugrade from 4.01.3-max to 4.0.16, now slower

the MAX version. In addition my Redhat 9.0 machine now lists all the mysld threads under top, whereas before top listied a single myslqd process. Any information is appreciated. Thanks, Trevor

Disk io wait during select,

machine eventhough the sparc has superior memory and disks. Thanks, Trevor

MySQL on Solaris 9 sparc with Perl

welcome. Trevor

Fulltext index not being used

`person_zip_idx` (`ZIP`), KEY `person_last_name_idx` (`LAST_NAME`), KEY `person_first_name_idx` (`FIRST_NAME`), KEY `person_generation_idx` (`GENERATION`), KEY `person_birthday_idx` (`BIRTHDAY`), KEY `person_user_created_idx` (`USER_CREATED`) ) TYPE=MyISAM | Many Thanks, Trevor

MyODBC errors

by the application earlier. The failings all deal with write operations. Many Thanks, Trevor

Replication Error 1053

. Thanks, Trevor

RAID Strip size

size is a conservative approach allowing for better scalability. Many Thanks, Trevor

Ignor writes no block them.

Thanks, Trevor

Avg Queries per second...... per second

. Many Thanks, Trevor

Mysql Stoping

Hi All Was wondering if someone could shef a bit of light on whats happening, as i keep loosing the connection to the mysql server, and i get the following error: mysqld dead but subsys locked Thanks in advance Cheers Trevor

Mysqk Connections problems

Database host: localhost Database name: Database user: It seems that the database is loosing connections This has all started happening since going from Redhat 8 to Redhat 9, which also means going from mysql version: 3.23.52 to version: 3.23.56. Cheers Trevor

Importing Data

as follows, they have a common factor zz, these lines need to be deleted ZVPX\ARDX550 ,zz BenQ DX550 1200 Lum. XGA DLP AV-Box Thanks for any help that you can offer Cheers Trevor

Syntax for SQL Query - used to work with Access

Hi This query used to work with an Access database: SELECT *, (SELECT COUNT (*) FROM Links WHERE Links.CAT_ID = Categories.CAT_ID AND LINK_APPROVED = 'Yes') AS LINK_COUNT FROM Categories ORDER BY CAT_NAME ASC Now that we've upgraded to MySQL, the same ASP script returns this error:

quick PHP question

function similar to MySQL's sec_to_time() or time_to_sec(). Nor can I make mktime() do anything useful here. Does anyone know of any PHP function that will solve my above need? -- Trevor Smith|[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Double entries

: TIA Trevor #!/usr/local/bin/perl # # Main script # use strict; use MivaOrder; use Data::Dumper; #Use Perl's Database Interface (DBI) with the NySQL module to connect the Maverick database use DBI; my %attr = (PrintError = 1, RaiseError = 1); my

MySql Control Center

this on a Windows 2000 machine. TIA Trevor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SQL statement

information before each item ordered. What I want is to print just the customer information once, and then print each item ordered by the customer after that. Any help is appreciated. TIA Trevor my $sth =$dbh-prepare(SELECT miva_orders.order_number,DATE_FORMAT(miva_orders.date,'%c/%e/%Y'),miva_order

RE: select using first letter

Hi Using the Square brackets with the characters within it and then a wildcard after the closing square bracket works except for looking for special square brackets. hi all, i have this table filled with names. Does anybody know how I can write a select statement which selects all names

Freelance Help Sought

-- the client is a charity) remuneration. If you're interested, please drop me an e-mail letting me know who you are! Many thanks if you're able to lend a hand! Best wishes (unsubscribing from list now) _ Trevor Sather Creative Director Square Eye Ltd 22-24 Monmouth Rd

Re: select by weekly SUM

), no_of_deliveries TINYINT(1) UNSIGNED, total_tips DECIMAL(5,2), gas_used TINYINT(1) UNSIGNED, notes TEXT There is no week field. So, I have to compute 'week by adding together sum(tips) for 7 consecutive days. Any suggestions how I can extract many consecutive weekly sums? -- Trevor Smith

select by weekly SUM

5: sum of tips for that week I can do them one week per query (obviously) but would like one query that will spit them all out, one after the other. -- Trevor Smith|[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

SQL Query Syntax Error

Trevor Sather

Default Datetime?

()'. But this doesn't seem to work. How can I get the default value to be now()? The only way I've succeeded is by setting the type of field to VARCHAR, but that's not ideal. Thanks in advance for any help you can give me! Best wishes Trevor

Help with Date Range Query

| | 2003051700 | | 2003051000 | | 2003051500 | | 2003062800 | | 2003070600 | | 2003080300 | ++ 17 rows in set (0.01 sec) Thanks very much for any advice! Trevor

RE: Help with Date Range Query

Thanks very much (to all who replied) -- this looks good! Best wishes -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: 06 June 2003 20:46 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Help with Date Range Query At 20:34 +0100 6/6/03, Trevor Sather wrote

Re: Using LIKE to search for occurence of a column value in a string

-stream so excuse me if I'm confused. -- Trevor Smith|[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Database sychronize statistic

Hi all, Do you have any information on the time and CPU resources required during the full sync / incremental sync between the master and slave mysql server? Thank you. Best regards, Trevor Luo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

maintaining delivery order in a table

not what I prefer. I'm looking for a simple, mysql-only solution that can store the delivery order in the table and that can be updated easily. Any suggestions? -- Trevor Smith|[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: maintaining delivery order in a table

if the database changed often so I thought there might be some better idea. Rather than start it off inefficiently, I wanted to do it right. Oh well. On the up side, I'm not as imagination-challenged as I thought--if no one else can think of a better idea either. :-) -- Trevor Smith

Insert Replication issues...

if they may chronologically occur at different times)? (I am currently using MySQL 3.23.49 from Debian packages...) -- . Trevor Phillips - http://jurai.murdoch.edu.au/ . : Web Technical Administrator - [EMAIL PROTECTED] : | IT Services

Re: mysql scrit

Hi there looking for some help to run this in a php file mysql -e drop table job test Cheers Trevor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Command Line

Hi I am very new to mysql, so any help please how to drop tables from a database from the command line i have 6 tables in there, and need to be able to flush all the data out, (of 2 tables only) so there might be another way Thanks Trevor

Problem with Escaping quotes

Escaping routines for different DBs? -- . Trevor Phillips - http://jurai.murdoch.edu.au/ . : Web Technical Administrator - [EMAIL PROTECTED] : | IT Services- Murdoch University

Date Format

to 8 characters but the change did not work I still get mmddhhmmss. Any ideas? regards Trevor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Problem with select statements in Visual Basic

. Thanks :) -Trevor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail

WEEK() returns wrong week number at start of year

. SELECT WEEK(SUBDATE(2002-01-07 03:30:00, INTERVAL 4 DAY), 1); Submitter-Id: [EMAIL PROTECTED] Originator:trevor hemsley Organization: AtosOrigin MySQL support: none Synopsis: WEEK() returns wrong week number when run for some days in first week of year Severity: non-critical Priority

RE: MySQL RPM Install Problem - Ignorance

just mount the drive on a new installation using the /etc/fstab file. Some people mount there individual databases on standalone drives. Not saying this the best way but it is one way if you can afford hardware. That leaves you root drives for programs. Regards Trevor -Original Message- From

compile problems

Does anyone have a solution? The following are the compiler, utils and O/S. I have tried using gun ld and the ld supplied by sun. Thanks. -Trevor [EMAIL PROTECTED] SunOS solo 5.8 Generic_108529-09 i86pc i386 i86pc gcc-3.0.1 gnu fileutils-4.1 gnu autoconf-2.50 gun automake-1.4-p5 export CC

Large data in tables

this? Thanks, Trevor Trevor F. Linton Systems Administrator/Web Developer Vérité Multimedia Inc. http://www.verite.com DVD * CD * Web * Print * Film * Sound Phone: 801.553.1101 x 111 Fax: 801.553.1215 [EMAIL PROTECTED] - Before

RE: Table size limitations...

, here's a pointer to more information on this: http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html# Table_size - Trevor -Original Message- From: Nathanial Hendler [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 10:20 AM To: MySQL Subject: Table size

Parallel Databases

to this mailing list but it seems as if the subscribing system is broken at the moment. Please reply back to my email address, fyi. Thanks, Trevor F. Linton ([EMAIL PROTECTED]) Trevor F. Linton Systems Administrator/Web Developer Vérité Multimedia Inc. http://www.verite.com DVD * CD * Web * Print

RE: Database Permissions

, if they try to access mysql they will get an 'access denied' error. And don't forget to: FLUSH PRIVILEGES; And to SHOW GRANTS FOR myuser; To check everything is as you'd expect it. HTH Trevor ~~ Trevor Harris