select from table hangs?

[Kristina Clair]

Hello,

I am having a problem with a mysql (myisam) table that I've never had
before, and I'm completely stumped!

I am using mysql version 4.0.13.

myisamchk -e table.MYI returns no errors.

Yet, when I try to do any kind of select from the mysql prompt, it
just hangs and never returns an error code.

Does anyone have any thoughts on what might be wrong or other ways to
debug this?

Thanks!
-- 
Kristina Clair
Datarealm Internet Services
www.serve.com

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

Crystal Decisions Report Application Server Problem

[kristina]

I'm writing to get some help on the following problem:

We're running MySql (1.4.1 version) with MyODBC (version 3.51.06) and the
Report Application Server 9 (RAS) from Crystal Decisions.  We're having a
problem getting the Report Application Server to connect to the MySql
database via MyODBC.  We have two databases going - an Oracle database and
a MySQL database.  We wrote a simple report for each and we're trying to
run the report via the RAS sample web page (e-portfolio lite).  The oracle
report works fine - RAS manages to display it and access the database.  The
MySql report fails to connect to the database - it asks for a user name and
password, but always fails to connect to the database (it prompts for
another user name and password).  However, Crystal Reports itself run the
report fine.  There seems to be a disconnect between how RAS connects to
the database versus Crystal Reports.  Anyone able to get RAS to work?

Kristina


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

[Newbie Q] csv file upload via php to mysql tutorial request

[kristina]

Hello listers

  My reason for emailing is this - I want
to know how to
  upload a csv file via php to a mysql
database.  I have
  found a few examples but they are all
much to advanced for
  my needs.  I just want the bear basics
so I can understand
  it.

  I can see that phpMyAdmin does this,
which is great but I
  need it for joe public to be able to
use.  so I don't
  want them using phpMyAdmin.

  Just a few links to some tutorials would
be marvellous.

  ;o)

--
tia as always

bfn
.kristina

[EMAIL PROTECTED]
kfxdesign.net


-
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 [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Is DATE NOT NULL DEFAULT NOW() legal??

[Pete, Rose Kristina]

Hi there.

I'm getting stuck on what seems only too simple to me:


CREATE TABLE Waverley.MemberPrice
  (
  PriceID TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
  Price FLOAT(5,2) NOT NULL,
  ActivePrice TINYINT UNSIGNED NOT NULL DEFAULT 1,
  CreatedDate DATE NOT NULL DEFAULT NOW(),
  DeActivatedDate DATE,
  DeActivatedBy TINYINT UNSIGNED NOT NULL DEFAULT 0
  );

I get an Error 1064 on the NOW().  If I take the DEFAULT NOW() out, then it
works perfect.

I'm using 3.22.32, if that helps.

Thanks if you can help.

Peter.





-
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 [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php