[Dylanblitz]

Originally Posted by BlackJacket

Just got a report from some users that they are getting a Database error when adding a vehicle. I tested this to verify. Here is the error -

Database error in vBulletin 4.0.2:

Invalid SQL:
INSERT INTO garage_user_vehicle (user_id, made_year, engine_type, veh_class, color, mileage, mileage_unit_new, fuel_preference, price, currency, comments, views, money_spent, avg_rating, date_created, date_updated, make_id, model_id, trim_id, main_vehicle, vehicle_url, purchase_month, purchase_day, purchase_year, active) VALUES ('3', '2009', '7', '', 'Black', '20000', '1', '', '', '', 'Test', '0', '0', '0', '1267469241', '1267469241', '57', '1124', '696', '0', '', '03', '01', '2010', '1');

MySQL Error   : Unknown column 'money_spent' in 'field list'
Error Number  : 1054
Request Date  : Monday, March 1st 2010 @ 11:47:18 AM
Error Date    : Monday, March 1st 2010 @ 11:47:21 AM
Script        : http://www.*edited*.com/community/garage_vehicle.php
Referrer      : http://www.*edited*.com/community/garage_vehicle.php?do=add_vehicle
IP Address    : *edited*
Username      : *edited*
Classname     : vB_Database
MySQL Version : 5.0.67.d7-ourdelta-log

Dang, thought I got that cleaned out.
I'll fix it in the next update. For a manual fix for now

Open includes/garage_func_var.php
At line 1392 Find

PHP Code:

$adding = $db->query_write("INSERT INTO " . TABLE_PREFIX . "garage_user_vehicle (user_id, made_year, engine_type, veh_class, color, mileage, mileage_unit_new, fuel_preference, price, currency, comments, views, money_spent, avg_rating, date_created, date_updated, make_id, model_id, trim_id, main_vehicle, vehicle_url, purchase_month, purchase_day, purchase_year, active) VALUES ('$data[userid]', '$data[made_year]', '$data[engine_type]', '$data[veh_class]', '$data[color]', '$data[mileage]', '$data[mileage_unit]', '$data[fuel_preference]', '$data[price]', '$data[currency]', '$data[comments]', '$data[views]', '$data[money_spent]', '$data[avg_rating]', '$data[date_created]', '$data[date_updated]', '$data[make_id]', '$data[model_id]', '$data[trim_id]', '$data[main_vehicle]', '$data[vehicle_url]', '$data[purchase_month]', '$data[purchase_day]', '$data[purchase_year]', '$active')"); 


Replace with

PHP Code:

$adding = $db->query_write("INSERT INTO " . TABLE_PREFIX . "garage_user_vehicle (user_id, made_year, engine_type, veh_class, color, mileage, mileage_unit_new, fuel_preference, price, currency, comments, views, avg_rating, date_created, date_updated, make_id, model_id, trim_id, main_vehicle, vehicle_url, purchase_month, purchase_day, purchase_year, active) VALUES ('$data[userid]', '$data[made_year]', '$data[engine_type]', '$data[veh_class]', '$data[color]', '$data[mileage]', '$data[mileage_unit]', '$data[fuel_preference]', '$data[price]', '$data[currency]', '$data[comments]', '$data[views]', '$data[avg_rating]', '$data[date_created]', '$data[date_updated]', '$data[make_id]', '$data[model_id]', '$data[trim_id]', '$data[main_vehicle]', '$data[vehicle_url]', '$data[purchase_month]', '$data[purchase_day]', '$data[purchase_year]', '$active')");