Hi,
On Feb 6, 2008 4:47 PM, Olaf Stein <[EMAIL PROTECTED]> wrote:
> Hi All
>
> I am trying to run this query:
>
> update minpheno set TMP_ados_version='0' where ident=898;
> On below table:
>
> And get error 1136
> ERROR 1136 (21S01): Column count doesn't match value count at row 1
>
> How can that be (obviously ident=898 exists)?
It sounds like the table is corrupt. Run CHECK TABLE.
The other possibility is that there is a trigger that is doing a blind
insert (one that doesn't specify column names) into another table.
>
> I am going nuts
>
> Thanks
> Olaf
>
> +-----------------------+---------------------------------------+------+----
> -+---------+----------------+
> | Field | Type | Null | Key
> | Default | Extra |
> +-----------------------+---------------------------------------+------+----
> -+---------+----------------+
> | minpheno_id | mediumint(8) unsigned | NO | PRI
> | NULL | auto_increment |
> | ident | mediumint(8) unsigned | NO | MUL
> | | |
> | irb | tinyint(3) unsigned | YES |
> | NULL | |
> | ethnicity | enum('0','1','2') | NO |
> | 0 | |
> | race | enum('0','1','2','3','4','5') | NO |
> | 0 | |
> | dob | date | YES |
> | NULL | |
> | current_age | smallint(4) unsigned | YES |
> | NULL | |
> | epilepsy_hx | enum('0','1','2','7','9') | YES |
> | NULL | |
> | parental_lang_delay | enum('0','1','2','9') | YES |
> | NULL | |
> | best_est_dx | enum('1','2','3','4','5','6') | YES |
> | NULL | |
> | best_est_iq | enum('0','1','2','3','4','5') | YES |
> | NULL | |
> | adi_age | smallint(4) unsigned | YES |
> | NULL | |
> | adi_version | enum('1','2') | YES |
> | NULL | |
> | adi_social | tinyint(3) unsigned | YES |
> | NULL | |
> | adi_comm | tinyint(3) unsigned | YES |
> | NULL | |
> | adi_stereo | tinyint(3) unsigned | YES |
> | NULL | |
> | adi_onset | enum('0','1') | YES |
> | NULL | |
> | adi_age_first_words | smallint(4) unsigned | YES |
> | NULL | |
> | adi_age_first_phrases | smallint(4) unsigned | YES |
> | NULL | |
> | adi_verbal | enum('0','1','2') | YES |
> | NULL | |
> | adi_dx | enum('0','1') | YES |
> | NULL | |
> | TMP_adi_dx | enum('0','1') | YES |
> | NULL | |
> | ados_age | smallint(4) unsigned | YES |
> | NULL | |
> | ados_version | enum('1','2') | YES |
> | NULL | |
> | TMP_ados_version | enum('0','1','2','3','4','5','6','7') | YES |
> | NULL | |
> | ados_module | enum('0','1','2','3','4') | YES |
> | NULL | |
> | ados_social | tinyint(3) unsigned | YES |
> | NULL | |
> | ados_comm | tinyint(3) unsigned | YES |
> | NULL | |
> | ados_stereo | tinyint(3) unsigned | YES |
> | NULL | |
> | ados_total | tinyint(3) unsigned | YES |
> | NULL | |
> | ados_dx | enum('0','1','2') | YES |
> | NULL | |
> | TMP_ados_dx | enum('0','1','2') | YES |
> | NULL | |
> | vine_age | smallint(4) unsigned | YES |
> | NULL | |
> | vine_comm | smallint(3) unsigned | YES |
> | NULL | |
> | vine_living | smallint(3) unsigned | YES |
> | NULL | |
> | vine_social | smallint(3) unsigned | YES |
> | NULL | |
> | vine_comp | smallint(3) unsigned | YES |
> | NULL | |
> | comment | text | YES |
> | NULL | |
> +-----------------------+---------------------------------------+------+----
> -+---------+----------------+
>
> ----------------------------------------- Confidentiality Notice:
> The following mail message, including any attachments, is for the
> sole use of the intended recipient(s) and may contain confidential
> and privileged information. The recipient is responsible to
> maintain the confidentiality of this information and to use the
> information only for authorized purposes. If you are not the
> intended recipient (or authorized to receive information for the
> intended recipient), you are hereby notified that any review, use,
> disclosure, distribution, copying, printing, or action taken in
> reliance on the contents of this e-mail is strictly prohibited. If
> you have received this communication in error, please notify us
> immediately by reply e-mail and destroy all copies of the original
> message. Thank you.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
