Platinum Games Posted October 16, 2008 Posted October 16, 2008 1054 - Unknown column 'c.customers_invoice' in 'field list' select c.customers_id, c.customers_gender, c.customers_invoice, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id, c.customers_notes from customers c left join address_book a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '2' [TEP STOP] I HAVE JUST NOTICED A LITTLE BUG IN THE ADMIN, I HAVE INSTALLED A FEW CONTRIBS AND I'M NOT SURE HOW I HAVE MISSED THIS BUT IN THE ADMIN (INDEX.PHP) PAGE I CLICK ON A CUSTOMER LINK AND I GET THE ABOVE ERROR....DOES ANYONE HAVE ANY IDEAS HOW TO CORRECT AN ERROR LIKE THIS? DOES IT MEAN THAT THE CUSTOMER DOESN'T EXIST OR THE DB DOESN'T??? THANKS IN ADVANCE. BEN Thanks in advance! Ben
failsafe Posted October 16, 2008 Posted October 16, 2008 1054 - Unknown column 'c.customers_invoice' in 'field list' I HAVE JUST NOTICED A LITTLE BUG IN THE ADMIN, I HAVE INSTALLED A FEW CONTRIBS AND I'M NOT SURE HOW I HAVE MISSED THIS BUT IN THE ADMIN (INDEX.PHP) PAGE I CLICK ON A CUSTOMER LINK AND I GET THE ABOVE ERROR....DOES ANYONE HAVE ANY IDEAS HOW TO CORRECT AN ERROR LIKE THIS? DOES IT MEAN THAT THE CUSTOMER DOESN'T EXIST OR THE DB DOESN'T??? It means that you've missed something when installing one of your contributions. The 'customers_invoice' and 'customers_notes' fields are not part of the stock osCommerce installation for the 'customer' table, so these are lines you've changed/added in your code to access these fields. It appears that you haven't extended your database to include the extra 'customers_invoice' field though. Check the installation notes for the contribution that uses it. You've either forgotten to add the extra 'customers_invoice' field to TABLE 'customer' or you've added it, but spelt it incorrectly either in the code that accesses it, or in the database definition itself.
Platinum Games Posted October 16, 2008 Author Posted October 16, 2008 thanks i will have a look into, thank you. Thanks in advance! Ben
Recommended Posts
Archived
This topic is now archived and is closed to further replies.