ct all
>
> The QUIT command throws an SQLSTATE = 42000 (invalid syntax)
>
> Is QUIT not supported under MYSQL
>
> can anyone ofer me CLUES as to why it may not be Disconnected successfuly
>
> Im desperate here
>
> Mike
--
- michael dykman
- [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi folks, Im dying here slowly. Can anyone tell me what an =
SqlState 08000 (connection exception) REALLY MEANS Is it as obvious =
as I think it is, Im NOT CONNECTED to MySQL, and if so, why not =
08003 (connection does not exist)...
I have a major problem, Im running Windows 2000
Im desperate here
Mike
Thanks for your answer, this is what I ended up putting in my
/etc/hosts.allow file, just to remove any doubt
ALL : ALL : allow
auth : ALL : allow
mysqld: ALL : allow
At 10:17 AM 9/11/2003 -0700, Jennifer Goodie wrote:
Assuming mysql server is running on a unix box, does the connecting client
h
ct the first time because
> it did not have permission, but the second time it did, and i get this
> lousy error again.
>
> However, I am able to do the same command and connect from my XP
> workstation where mysql client is installed. so I have no clue why it is
> not working fr
i get this
lousy error again.
However, I am able to do the same command and connect from my XP
workstation where mysql client is installed. so I have no clue why it is
not working from the server where I really need it to work.
I am getting really desperate after 3 weeks of this same error. C
* Peter D Bethke
> Ok, in regards to my previous dilemma, I've gotten it to:
>
> SELECT
> golf_pick_periods.id,
> golf_pick_periods.period_name,
> golf_pick_periods.period_start_date,
> golf_pick_periods.period_end_date,
>
> COUNT(DISTINCT golf_events.id) AS num_events
Ok, in regards to my previous dilemma, I've gotten it to:
SELECT
golf_pick_periods.id,
golf_pick_periods.period_name,
golf_pick_periods.period_start_date,
golf_pick_periods.period_end_date,
COUNT(DISTINCT golf_events.id) AS num_events,
COUNT(golf_pla
Hi all,
I've got a mysql application that tracks golf events where players pick
winners. Each event is associated by date with a "pick period" (ie a
month).
I'm trying to get a COUNT() function to count all the picks by pick
period for a given player (in this case id = "1"). The following SQL
Hi all,
I've got a mysql application that tracks golf events where players pick
winners. Each event is associated by date with a "pick period" (ie a
month).
I'm trying to get a COUNT() function to count all the picks by pick
period for a given player (in this case id = "1"). The following SQL
ECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Chris Faust" <[EMAIL PROTECTED]>
To: "John P" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, January 02, 2003 6:54 AM
Subject: RE: Desperate - failed: Lost connection to MySQL serve
ng to
believe its the root of all my problems.
Its been a wild week!!
Thanks
-Chris
>> -Original Message-
>> From: John P [mailto:[EMAIL PROTECTED]]
>> Sent: Saturday, December 28, 2002 1:45 PM
>> To: Chris Faust; [EMAIL PROTECTED]
>> Subject: Re: Desperate
> If you are running close to the same setup with no problems then I feel a
> little better about it not being a issue of pure traffic.
Yes, we operate in a very similar way to you. (BTW, we have had very good
results with a PHP based cache facility that simply stores the db driven
pages over a se
Yes, I do connect to the DB server over IP - in short this is what I do
within MAIN of all my scripts (and $db is what is used anyplace a DB
connection is needed)
##
# Database Setup
# -
#
my $dbpassfile = '/websites/web_f
- Original Message -
From: "Chris Faust" <[EMAIL PROTECTED]>
To: "Mark" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, December 28, 2002 1:18 PM
Subject: RE: Desperate - failed: Lost connection to MySQL server during
query
> I really
If you are running close to the same setup with no problems then I feel a
little better about it not being a issue of pure traffic.
As for the scripts, its a heavy reliance on the database for information -
pretty much the whole site is like a classifieds ads system. Other then the
advance searche
ist fast!!
Thanks
-Chris
>> -Original Message-
>> From: Doug Thompson [mailto:[EMAIL PROTECTED]]
>> Sent: Saturday, December 28, 2002 7:33 AM
>> To: Chris Faust; Mark; [EMAIL PROTECTED]
>> Subject: RE: Desperate - failed: Lost connection to MySQL server during
>> query
Chris:
I bet a dollar to a donut that you have a hardware problem. The
essential proof is in the first quoted paragraph below. Believe
your data, save your hair.
Regards,
Doug
Filter That! SQL MySQL Query
On Sat, 28 Dec 2002 07:18:07 -0500, Chris Faust wrote:
>One other test I did was put
Hello Mark,
Thanks for the reply..
I would need to wait until load gets up there to see the state of apache but
even now with almost no load on the machine I'm seeing at least a dozen
connections in the "TIME_WAIT" state. On the flip site of things I have not
been seeing any other connection rela
- Original Message -
From: "Chris Faust" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 27, 2002 10:22 PM
Subject: Desperate - failed: Lost connection to MySQL server during query
> The problem is this, everytime the web server starts to wo
Hello All,
This mail list is about my last hope as I tried everything I could possibly
find online related to this problem and I've had no luck (it doesn't appear
to be the GLib problem that everyone keeps talking about).
Machine Specifics:
Web Server (dedicated):
P4 2gHz with 2gig memory
RedHat
ql and all worked fine.
Cheers
John
> -Original Message-
> From: John Parsons [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 04, 2002 9:52 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: DESPERATE NEED FOR HELP!
>
>
> I have just been a complete mup
D]
Subject: DESPERATE NEED FOR HELP!
I have just been a complete muppet and trashed the tables in my database and
don't have a recent backup.
The database is used for the phpBB system and still functions when I visit
the site via a web browser since the database is still cached. Is ther
From: Balteo <[EMAIL PROTECTED]>
> Why don't you create a php script that generates SQL instead of HTML; i
> will repopulate your database acting as a dump?
Not a bad idea. John, be carefull not to mess up whatever cache is currently in place
by changing something that will confuse the cache.
Why don't you create a php script that generates SQL instead of HTML; i
will repopulate your database acting as a dump?
I know it will take some time to develop...
Balteo,
John Parsons wrote:
>I have just been a complete muppet and trashed the tables in my database and
>don't have a recent b
I have just been a complete muppet and trashed the tables in my database and
don't have a recent backup.
The database is used for the phpBB system and still functions when I visit
the site via a web browser since the database is still cached. Is there any
way I can recover the database using the
Date |Tue, 28 Aug 2001 12:30:25 -0400
>From |<[EMAIL PROTECTED]>
Hello!
N> I am trying to install the "dbf2mysql" converter and really
N> getting a headache. Someone told me that I need to
N> install the "Include files and libraries for MySQL" and I
N> have been searching frantically all over
I am trying to install the "dbf2mysql" converter and really
getting a headache. Someone told me that I need to
install the "Include files and libraries for MySQL" and I
have been searching frantically all over the web for the
source for this. All I have been able to find is the RPM's.
I am on
Hi there
I desperatly need a binary installation of MYSQL that includes the BDB table
format for Windows. I have tried to compile this myself but the
mysqld-max-nt.exe crashes immediatelly on start.
I am trying to migrate my application for a deadline to MYSQL, and I need to
test it with the BDB
on 3/6/01 9:35 PM, Chris Toth at [EMAIL PROTECTED] wrote:
> Ok, I've been battling this SELECT statement for the better part of the day.
>
> The SELECT statement is this:
>
> SELECT DISTINCT request.id AS requestid, request.date, request.type,
> request.status,
> faculty.f_name, faculty.l_name,
I do not think that this can be solved using only SQL. Your system design my
require you to use one query for the display and another
for edit checking in order to achieve your goal.
Chris Toth wrote:
> Kentj
>
> Ok, I understand. I thought DISTINCT only worked on the field listed
> directly aft
Your query selects eight fields. Your Display shows five fields. The distinct verb
works on all eight fields and
apparently some of the fields not displayed are different. Limit the query for the
display to the five fields displayed
and the distinct verb should eliminate the duplicates from the d
I rearranged the query a little: SELECT DISTINCT request.id AS requestid,
request.date, request.type, request.status,
faculty.f_name, faculty.l_name, action.id AS actionid, faculty.id AS
facultyid FROM faculty, request, action WHERE request.id=action.request_id
AND request.requested_by=facult
It looks like the addition of the distinct verb should do the job if in fact your
query only showed the fields on the display.
>From your Sql however you are selecting more fields than are displayed and some
of those are different which distinct
will still display.
Chris Toth wrote:
> Ok, I've b
Ok, I've been battling this SELECT statement for the better part of the day.
The SELECT statement is this:
SELECT DISTINCT request.id AS requestid, request.date, request.type,
request.status,
faculty.f_name, faculty.l_name, action.id AS actionid, faculty.id AS
facultyid FROM faculty, request
My set-up:
MySQL server 3.23.30 with MSAccess97 via MyODBC 2.50.36 (all latest patches
to everything)
I have no trouble running this set up, BUT...
Even when I am the only person connected (after flush and restart of
server) and I open my Access database and go directly to edit one
particular t
36 matches
Mail list logo
