Unknown column when posting new audio nodes [#763008]

Getting the error below when posting new audio nodes, this site was updated from D5 to D6 and then the itunes module was installed.

user warning: Unknown column 'nid' in 'field list' query: INSERT INTO itunes_item (vid, nid, summary, subtitle, explicit, block) VALUES (787, 493, '', '', 0, 0) in /var/www/xxxx/includes/common.inc on line 3477.

mysql> desc itunes_item;
+----------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
| vid | int(10) unsigned | NO | PRI | 0 | |
| summary | longtext | NO | | NULL | |
| subtitle | varchar(255) | NO | | | |
| explicit | int(1) unsigned | NO | | 0 | |
| block | int(1) unsigned | NO | | 0 | |
+----------+------------------+------+-----+---------+-------+
5 rows in set (0.01 sec)

Please advise the correct table properties.

Thank You

Comments

Comment #1

RXM307 commented 8 April 2010 at 11:26

Not sure if this is correct or not but I'll see how it goes

alter table itunes_item add COLUMN nid int(10) unsigned;

desc itunes_item;
+----------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
| vid | int(10) unsigned | NO | PRI | 0 | |
| summary | longtext | NO | | NULL | |
| subtitle | varchar(255) | NO | | | |
| explicit | int(1) unsigned | NO | | 0 | |
| block | int(1) unsigned | NO | | 0 | |
| nid | int(10) unsigned | YES | | NULL | |
+----------+------------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

This seems to fix the errors but I'm unsure why the table was like this in the first place.....

Comment #2

drewish commented 17 April 2010 at 17:26

Did you have the audio_itunes module installed back on D5? There's code to rename the audio_itunes table so you might have had a really old version of it.