SQL database problem
Posted: Wed Apr 24, 2024 12:52 pm
I'm currently being driven around the bend with this problem
Inserting data into the orders table via the sql as follows:
Not just the one line of code but multiple
The Static analysis come up with the following error:
What I want to know is where the extra value name is?
Inserting data into the orders table via the sql as follows:
Code: Select all
INSERT INTO orders (orders_id, customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, last_modified, date_purchased, orders_status, orders_date_finished, currency, currency_value, shipping_module, customer_service_id, discount_codes) VALUES
(485, 422, 'Some Customer', '', '10 Some Street', 'Somewhere', 'Someplace', 'AA1 1AA', 'Devon', 'United Kingdom', '01234567890', 'skippy1983@hotmail.co.uk', 2, 'Some Customer', '', '10 Some Street', 'Somewhere', 'Someplace', 'AA1 1AA', 'Devon', 'United Kingdom', 2, 'Some Customer', '', '10 Some Street', 'Somewhere', 'Someplace', 'AA1 1AA', 'Devon', 'United Kingdom', 2, 'Other', '', '', '', '', '2011-04-20 19:05:18', '2011-04-20 12:52:16', 3, NULL, 'GBP', 1.000000, 'rmstandardparcel_rmstandardparcel', '', '1-CaptuRe', '');
The Static analysis come up with the following error:
No matter how I count them the Value names and the Values equal the same amount of 45#1136 - Column count doesn't match value count at row 1
46 values were expected, but found 45. (near "(" at position 1392)
What I want to know is where the extra value name is?