OsCommerce issues
Aus DD24 Wiki
Inhaltsverzeichnis |
1054 - Unknown column 'p.products_id' in 'on clause'
Effect
When selecting a category from the main screen or when selecting an individual product there is an error message:
1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials_retail_prices s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and p2c.categories_id = '206'
Cause
Older versions of osCommerce are having problems with MySQL5
Fix
Update the osCommerce software to a current version. Description of this bug at oscommerce Website
emails are not sent
Effekt
osCommerce doesn't send emails
Cause
The following files contain a bug:
includes/classes/email.php admin/includes/classes/email.php
The variable $to is not created successfully.
Fix
Change $to to $to_addr in line 522
before:
return mail($to, $subject, $this->output, 'From: '.$from.$this->lf.implode($this->lf, $this->headers).$this->lf.implode($this->lf, $xtra_headers));
after:
return mail($to_addr, $subject, $this->output, 'From: '.$from.$this->lf.implode($this->lf, $this->headers).$this->lf.implode($this->lf, $xtra_headers));
