Bug #6777

nativecode=1054 ** Unknown column

Details

Submitted	2006-02-14 05:10 UTC
From	rafal at friendlysol dot com
Status	Bogus
Package	DB_DataObject
PHP Version	5.1.2
OS	centos
Roadmaps	(Not assigned)

Comments

[2006-02-14 05:10 UTC] rafal at friendlysol dot com

Description:
------------
vehicle_maintenance: QUERY: INSERT INTO vehicle_maintenance (vehicle_id , maintenance_type_id_1 , price_1 , note_1 , maintenance_type_id_2 , price_2 , note_2 , maintenance_type_id_3 , price_3 , note_3 , maintenance_type_id_4 , price_4 , note_4 , maintenance_type_id_5 , price_5 , note_5 , maintenance_type_id_6 , price_6 , note_6 , maintenance_type_id_7 , price_7 , note_7 , maintenance_date , drop_off_date , drop_off_person_id , vendor_person_id , drop_off_mileage , pickup_date , pickup_person_id , pickup_mileage , price , paid , notes , created_date ) VALUES ( 2 , 0 , 0 , 'asfdf' , 0 , 0 , 'sdfsda' , 0 , 0 , 'fsdfds' , 0 , 0 , 'sdfdfsa' , 0 , 0 , 'dsfadfsa' , 0 , 0 , 'sdfadsfa' , 0 , 0 , 'sdafdsdsfa' , '2006-02-13' , '2006-02-13' , 16349 , 16296 , '666666' , '2006-02-13' , 16349 , '666666' , 22234 , '1' , 'sdsdfafdsafdssfdfds' , '2006-02-13 22:52:33' )
vehicle_maintenance: Query Error: [db_error: message="DB Error: no such field" code=-19 mode=return level=notice prefix="" info="INSERT INTO vehicle_maintenance (vehicle_id , maintenance_type_id_1 , price_1 , note_1 , maintenance_type_id_2 , price_2 , note_2 , maintenance_type_id_3 , price_3 , note_3 , maintenance_type_id_4 , price_4 , note_4 , maintenance_type_id_5 , price_5 , note_5 , maintenance_type_id_6 , price_6 , note_6 , maintenance_type_id_7 , price_7 , note_7 , maintenance_date , drop_off_date , drop_off_person_id , vendor_person_id , drop_off_mileage , pickup_date , pickup_person_id , pickup_mileage , price , paid , notes , created_date ) VALUES ( 2 , 0 , 0 , 'asfdf' , 0 , 0 , 'sdfsda' , 0 , 0 , 'fsdfds' , 0 , 0 , 'sdfdfsa' , 0 , 0 , 'dsfadfsa' , 0 , 0 , 'sdfadsfa' , 0 , 0 , 'sdafdsdsfa' , '2006-02-13' , '2006-02-13' , 16349 , 16296 , '666666' , '2006-02-13' , 16349 , '666666' , 22234 , '1' , 'sdsdfafdsafdssfdfds' , '2006-02-13 22:52:33' ) [nativecode=1054 ** Unknown column 'note_1' in 'field list']"]

Test script:
---------------
Can't paste it.

Expected result:
----------------
That code runs fine earlier versions od DB_DataObject.

Actual result:
--------------
Gives an error that the column doesnt exist. But it does :)

[2006-05-18 21:12 UTC] rafal at friendlysol dot com

Field,Type,Null,Key,Default,Extra
vehicle_maintenance_id,int(11) unsigned,,PRI,NULL,auto_increment
vehicle_id,int(11) unsigned,,,0,
maintenance_type_id_1,int(11) unsigned,YES,,0,
price_1,double(7,2),YES,,0.00,
note_1,varchar(30),,,,
maintenance_type_id_2,int(11) unsigned,YES,,NULL,
price_2,double(7,2),YES,,0.00,
note2,varchar(30),,,,
maintenance_type_id_3,int(11) unsigned,YES,,0,
price_3,double(7,2),YES,,0.00,
note3,varchar(30),YES,,NULL,
maintenance_type_id_4,int(11) unsigned,YES,,0,
price_4,double(7,2),YES,,0.00,
note4,varchar(30),YES,,NULL,
maintenance_type_id_5,int(11) unsigned,YES,,0,
price_5,double(7,2),YES,,0.00,
note5,varchar(30),YES,,NULL,
maintenance_type_id_6,int(11) unsigned,YES,,0,
price_6,double(7,2),YES,,0.00,
note6,varchar(30),YES,,NULL,
maintenance_type_id_7,int(11) unsigned,YES,,0,
price_7,double(7,2),YES,,0.00,
note7,varchar(30),YES,,NULL,
maintenance_date,date,,,0000-00-00,
drop_off_date,date,YES,,NULL,
drop_off_person_id,int(11) unsigned,YES,,NULL,
vendor_person_id,int(11) unsigned,,,0,
drop_off_mileage,varchar(12),YES,,NULL,
pickup_date,date,YES,,NULL,
pickup_person_id,int(11) unsigned,YES,,NULL,
pickup_mileage,varchar(12),YES,,NULL,
price,double(7,2),YES,,0.00,
paid,char(1),YES,,0,
notes,text,YES,,NULL,
created_date,datetime,YES,,0000-00-00 00:00:00,