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 s

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: MySQL and NPTL

glibc 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 abou

Fully compliant GIS

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

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?

Maintaining fulltext

s. Thanks, 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

er but aren't 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.

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

yearweek() result back to date format?

ot;2003-11-12") | yearweek("2003-11-12") | +---++ | 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 &

start / end dates for each week of year?

ry day in every week in my table. Therefore 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]

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

Re: reset auto_increment

he table, if possible. Regards 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 1

Mysql on Solaris 8/9 with ultrasparc

>show variables" 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: two tables

Smith Terry 002 Jones Larry 003 Barfbag Harry details_tb det_id fin 001 y 002 n 003 y I'm trying to get Smith and Barfbag to show up instead of all three. Regards Trevor Rhodes ==

Re: two tables

d from details_tb where fin = "y")' at line 3 > which one will execute faster ? The first. Regards Trevor Rhodes === Powered by Linux- Mandrake 9.2 Registered Linux user # 290542 at http://counter.li.org

Cardinality Bug ?

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

two tables

but it is giving me 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 Re

Re: Basic error

): supplied argument is not a valid MySQL result > 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

Basic error

ot;; foreach ( $a_row as $field ) print "\t$field\n"; print "\n"; } print "\n"; mysql_close( $link ); === Regards Trevor Rhodes === Powered by Linux

2 Fulltext index's are better than 1? No

ST table the index is used correctly 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 '&

Ugrade from 4.01.3-max to 4.0.16, now slower

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

E=MyISAM | PERSON KEY `person_id_base_idx` (`ID`), KEY `person_email_idx` (`EMAIL`), KEY `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

ist with correct permissions and is read by the application earlier. The failings all deal with write operations. Many Thanks, Trevor

Replication Error 1053

s this a bug or something about the insert statement or something else. 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

e bin interval for this average, otherwise fluctuations get smoothed out. Many Thanks, Trevor

Mysqk Connections problems

g.php 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

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

Importing Data

nd up with this data "NCHW\IQISW050R ","iNEQ Wireless BB Rou.& USB PrnServer",218 in the same file it has line 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: ADO

quick PHP question

ny useful PHP 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://lis

Double entries

n red: 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 =>

MySql Control Center

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

tomer 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/

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

. There'd be some (reasonable -- 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 Creat

Re: select by weekly SUM

IMAL(5,2), 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 week

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

n give me... Best wishes Trevor Sather

Default Datetime?

fault value 'now()'. 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

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

Help with Date Range Query

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

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

e in NeedleColumn, if that's what you were looking for. I'm jumping in mid-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

Re: maintaining delivery order in a table

thing) but it would be unwieldy 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 bette

maintaining delivery order in a table

s also 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.mys

Insert & Replication issues...

y (even 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] : | I

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

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

solve this problem, preferrably without resorting to custom Escaping routines for different DBs? -- . Trevor Phillips - http://jurai.murdoch.edu.au/ . : Web Technical Administrator - [EMAIL PROTECTED] : | IT Servi

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

here techstatus = 'U'" at line 1. 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-ma

WEEK() returns wrong week number at start of year

sday of that week instead, ie. 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

RE: MySQL RPM Install Problem - Ignorance

re you can 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

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

RE: Table size limitations...

this value. Hope this helps, 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 T

Large data in tables

d take in with doing 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]

Parallel Databases

progress made and how I can help. I tried to subscribe 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é Multime

RE: GRANT annoyance...

BY 'user' WITH GRANT OPTION; HTH ~~ Trevor Harris NuSphere Corp. Instructor/Consultant 14 Oak Park Bedford, MA 01730 USA E-mail: [EMAIL PROTECTED] http://www.nu

Can't Compile mod_auth_mysql

Hi I've been trying to compile mod_auth_mysql for Apache 1.3.19 and MySQL 3.23.33 on AIX 4.1.1. I've given up trying to get it to work as a DSO+APXS using the configure script that comes with mod_auth_mysql. (I seem to end up with a Makefile which calls apxs without any '-c' option anywhere.)

RE: Database Permissions

TO 'myuser'@'%'; This grants specific access to the database1 for this user. This adds an entry to the mysql.db table. Because this user doesn't have privileges beyond database1, if they try to access mysql they will get an 'access denied' error. And don't f