At 20:34 -0600 12/14/02, Vidiot wrote:
My database layout is as follows:
mysql> show columns from music;
+-----------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------------+------+-----+---------+-------+
| mrecno | int(6) | | PRI | 0 | |
| title | varchar(45) | | | | |
| artist | varchar(30) | | | | |
| source | char(1) | | | | |
| peak | int(3) | YES | | NULL | |
| peakdate | date | YES | | NULL | |
| entrydate | date | YES | | NULL | |
| length | int(3) | YES | | NULL | |
| stereo | char(1) | YES | | NULL | |
| cut | tinyint(1) | | | 0 | |
| album | varchar(45) | YES | | NULL | |
| trackno | int(2) | YES | | NULL | |
| notes | varchar(40) | YES | | NULL | |
| mcreated | date | YES | | NULL | |
| mamended | timestamp(14) | YES | | NULL | |
+-----------+---------------+------+-----+---------+-------+
Yet I get the following error:
Error
The Database Routines returned the following error
The reason given was:
updating music - You have an error in your SQL syntax near 'mamended
= '20021214013349' where mrecno = '1' ' at line 2
The command being executed was:
update music
set cut = '' mamended = '20021214013349' where mrecno = '1'
The problem here is the lack of a comma between cut = '' and
mamended = 20021214013349'. The statement is malformed, it
has to fail. It's not a DBI error *or* a CGI error.
I get it when I do a web page reload. Two things are wrong: 1) cut is defined
as an integer, yet it is trying to store nothing, while the default is set
to zero and nothing should be attempted to the mamended field, as that is an
auto-update field from within MySQL.
The following are the RPMs that I have installed on my Linux 7.1 system:
MySQL-3.23.53a-1.i386.rpm
MySQL-Max-3.23.53a-1.i386.rpm
MySQL-client-3.23.53a-1.i386.rpm
MySQL-devel-3.23.53a-1.i386.rpm
MySQL-shared-3.23.53a-1.i386.rpm
perl-DBD-MySQL-1.2215-1.i386.rpm
perl-DBI-1.14-10.i386.rpm
The Perl CGI package was part of the Perl 5.0.6 installation.
Any pointers/suggestions will be greatly appreciated.
Thanks.
MB
--
e-mail: [EMAIL PROTECTED] /~\ The ASCII
\ / Ribbon Campaign
X Against
Visit - URL: http://vidiot.com/ / \ HTML Email
---------------------------------------------------------------------
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
