LITTLE BUG IN ADMIN

[Platinum Games]

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

[failsafe]

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]

thanks i will have a look into, thank you.