End Action [ failure 0x1602]

2003-10-10 Thread Kenneth Illingsworth
I have been using ODBC v3.51 to select from MySQL DB's hosted by a RH v7.2 Linux VM from within an application script. The DB's are normally imported in the early morning. I now have a need to Insert into a table from an application script. The insert works when submitted through phpMyAdmin. How

I have been using ODBC v3.51 to access MySQL DB's hosted by a RH v7.2 Linux VM for select purposes f

2003-10-08 Thread Kenneth Illingsworth
I have been using ODBC v3.51 to access MySQL DB's hosted by a RH v7.2 Linux VM for select purposes from within an application script. They are normally imported in the early morning. I now have a need to Insert into a table from an application script. The insert works when submitted through php

Re: Import databse ?

2003-07-30 Thread Kenneth Illingsworth
Isn't the default field separator in Linux a Tab character? I suspect it is. And, I also suspect that the default field separator in Solaris is not a Tab character. Check these out. If these are in fact true, then it might go a long way in explaining why your import failed. >>> Vidhya CS <[EMAI

Re: Error code 1064 in another application...

2003-07-29 Thread Kenneth Illingsworth
If your query has worked in one account, but not in another, then your 1064 error is probably related to privileges granted to the second account. HTH >>> "Ola Ogunneye" <[EMAIL PROTECTED]> 07/29/03 09:08AM >>> I am running mysql 4.0.13 and using a weblog(Geeklog) to do my web. Using geeklog as

Fwd: MySQL error code 1064:K@N@!:

2003-07-28 Thread Kenneth Illingsworth
I suspect that this is some kind of issue with privileges. However, the account I am using has been given 'ALL' privileges to the database I am trying to insert to. Am I save to assume that ALL includes insert privileges? --- Begin Message --- I cannot seem to find this in the MYSQL Reference. A

Re: MySQL error code 1064:K@N@!:

2003-07-28 Thread Kenneth Illingsworth
any selects I want ok. This is my first attempt to insert. >>> David Precious <[EMAIL PROTECTED]> 07/25/03 11:54 AM >>> On Friday 25 July 2003 1:05 pm, Kenneth Illingsworth wrote: > I cannot seem to find this in the MYSQL Reference. Are there other places I > should

Altering table and field names

2003-07-25 Thread Kenneth Illingsworth
I would like to copy the values from each record in the Program table to another table (tblPrograms). This is the syntax I came up with: select * from Program insert tblPrograms set ProgramCode=Location, ProgramName=Description; However, it fails without telling me why. Perhaps someone could c

Re: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
any selects I want ok. This is my first attempt to insert. >>> David Precious <[EMAIL PROTECTED]> 07/25/03 11:54 AM >>> On Friday 25 July 2003 1:05 pm, Kenneth Illingsworth wrote: > I cannot seem to find this in the MYSQL Reference. Are there other places I > should

Fwd: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
I suspect that this is some kind of issue with privileges. However, the account I am using has been given 'ALL' privileges to the database I am trying to insert to. Am I save to assume that ALL includes insert privileges? --- Begin Message --- I cannot seem to find this in the MYSQL Reference. A

Fwd: Re: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
target the offending object more precisely for testing purposes. And, now the error is 1602 with no text. I am currently still looking for any error references. Once again, thanks in advance for your time. >>> "Kenneth Illingsworth" <[EMAIL PROTECTED]> 07/25/03 08:05AM >>

Re: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
/v1n1tpserrorcodes.html >>> "Kenneth Illingsworth" <[EMAIL PROTECTED]> 07/25/03 08:07 AM >>> I cannot seem to find this in the MYSQL Reference. Are there other places I should check? The message text in my log started out with 'You have...'. But, it was truncated

Re: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
I streamlined the application so as to target the offending object more precisely for testing purposes. And, now the error is 1602 with no text. I am currently still looking for any error references. Once again, thanks in advance for your time. >>> "Kenneth Illingsworth" <

MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
I cannot seem to find this in the MYSQL Reference. Are there other places I should check? The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It occurred on a submitted insert statement originating in an application. The insert statemen

Re: Mysql.Sock problem

2002-12-31 Thread Kenneth Illingsworth
It appears that we both are climbing the same mountain. The best approach is to hire a consultant to come in and get you started in the right direction. If, as is our case, this is unlikely, I will attempt to relay to you some of what I have encountered so far. Typically we prefer downloading R

re: Help struggling newbie, please!!

2002-12-17 Thread Kenneth Illingsworth
You might also wish to consider downloading and installing Webmin. It's one of the easiest installs I have encountered. Simply tar the tarball and proceed into the new subdirectory (IE webmin-1.030) and perform a /setup.sh . Webmin will allow you easy access to your server via a web browser. Sim

Re: Can't find hosts.frm -- permissions now okay?

2002-12-12 Thread Kenneth Illingsworth
I had a similar experience right down to the error message you are getting. Based on that experience, I am inclined to recommend the following: 1) Abandon your current installation which I perceive that your are attempting from a MySQL tarball. 2) Download the webmin-1.030 tarball and execute ./

Install PHP with MySQL

2002-12-05 Thread Kenneth Illingsworth
I recently installed the following RPM's: MySQL-3.23.41-1a.s390.rpm MySQL-devel-3.23.41-1a.s390.rpm MySQLclient9-3.23-22-6a.s390.rpm MySQL-server-3.23.41-1a.s390.rpm Afterwards, I was able to start the mysqld daemon ok and install an application I downloaded for a demonstration of the viability

Bind on unix socket: Permission denied

2002-11-22 Thread Kenneth Illingsworth
Mysqld.log shows this error: 021122 11:29:05 mysqld started 021122 11:29:06 Can't start server : Bind on unix socket: Permission denied 021122 11:29:06 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?

Fatal error: Please read "Security" section of the manual tofind out how to run mysqld as root!

2002-11-22 Thread Kenneth Illingsworth
This happens when I try to start the mysql daemon. I have checked the manual, but cannot fathom what else I am supposed to do. Here is what has been done so far: ./scripts//mysql_install_db seemed to initialize the MySQL db's ok. I also executed the following statements without issue: chown -

Error starting the Mysql Daemon

2002-11-22 Thread Kenneth Illingsworth
After taring mysql-3.23.53-unknown-linux-gnu-s390.tar.gz successfully on our Linux VM and linking the new directory to simply mysql, I ran into the following error trying to start the mysql daemon: [root@cofr3 mysql]# ./bin/mysqld -L /mysql/share/mysql/english Fatal error: Please read "Security"

epayroll

2002-11-14 Thread Kenneth Illingsworth
Anyone have experience with Hotscripts Enterprise Timesheet and Payroll application? It's my first attempt at running a MySQL aplication. Here is the link: http://www.hotscripts.com/Detailed/14498.html The installation seemed to go flawlessly. Apache webserver was running as well as MySQL v3.2