Re: sql error

2004-04-28 Thread Michael Stassen
Rhino wrote: From: "Ravi Malghan" <[EMAIL PROTECTED]> Hi: I am building perl scripts which can insert data into a database independent of the type of database. The following query works in postgresql, but I am getting the following error when I run sql query in mysql mysql> SELECT ipaddress FRO

Re: sql error

2004-04-28 Thread Rhino
- Original Message - From: "Ravi Malghan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 28, 2004 6:34 PM Subject: sql error Hi: I am building perl scripts which can insert data into a database independent of the type of database. The following query works in postgre

Re: sql error : 1036

2003-07-09 Thread Victoria Reznichenko
"HA. Mooduto" <[EMAIL PROTECTED]> wrote: > dear all, > what is the problem sql error : 1036 ...table is read only. > please help me.. This table is compressed with myisampack or MySQL server doesn't have permissions on the table files. -- For technical support contracts, goto https://order.mys

Re: sql error : 1036

2003-07-08 Thread gerald_clark
Does the mysql user have write permissions on the files? HA. Mooduto wrote: dear all, what is the problem sql error : 1036 ...table is read only. please help me.. thank's... -- This mail sent through PSP: http://www.polinpdg.ac.id/ -- MySQ

Re: SQL Error?

2001-08-09 Thread Michael T. Babcock
> As far as I know, there'll be no other solution than recovering from backup. For the old data, that is quite alright -- what I'm trying to figure out now is how to selectively restore information out of my (very large) binary database transaction log file. (Anyone have tools to this effect???)

RE: SQL Error?

2001-08-08 Thread Sebastiaan J.A. Kamp
---> Reply is under the quoted text <--- =>From: Michael T. Babcock [mailto:[EMAIL PROTECTED]] =>Subject: SQL Error? => =>I have a table that contains hourly work done on projects. It has =>a basic structure of (extraneous fields left out): => =>++--+--+ =>| Field

Re: SQL Error?

2001-08-08 Thread Stefan Hinz
Dear Michael, > put a WHERE clause in, so I ran the same query in reverse (-2592000). > 1) Is there any way (besides a restore from a 24hr old > backup tape) to get the old values back? I don't think so. Maybe someone has a trick for this. I'd be interested. > 2) Why did these queries fail to d

Re: sql error

2001-07-23 Thread Paul DuBois
At 4:20 PM -0700 7/23/01, Dan Huston wrote: >Hello All, > >I am getting this error: > >DBD::mysql::st execute failed: You have an error in your SQL syntax >near ''user_id', 'sem1_acad_id', 'sem1_course_id', 'sem1_ver', >'Sem_1_Final') VALUES (' at line 1 at flatten_er5.pl line 132, > line 13634