Modify ↓

Opened 10 years ago

Closed 10 years ago

#647 closed Bug/Fehler (fixed)

Fehler in Produkt-Filter

Reported by: Torsten Riemer Owned by: Gerhard Waldemair
Priority: hoch Milestone: modified-shop-2.0.0.0
Component: Shop Version: 2.0.0.0
Keywords: Cc:
Blocked By: Blocking:

Description

Aus dem Demoshop 2.00 Log erhalte ich folgenden Meldung:

02/09/2015 10:25:17 E_USER_WARNING - 1052 - Column 'manufacturers_id' in where clause is ambiguous<br/><br/>SELECT DISTINCT c.categories_id as id,
               cd.categories_name as name 
                                FROM products p
                                JOIN products_description pd
                                     ON p.products_id = pd.products_id
                                        AND pd.language_id = '2'
                                        AND trim(pd.products_name) != ''
                                JOIN manufacturers m 
                                     ON m.manufacturers_id = p.manufacturers_id
                                      JOIN products_to_categories p2c 
                   ON p2c.products_id = p.products_id
              JOIN categories c 
                   ON c.categories_id = p2c.categories_id 
                      
              JOIN categories_description cd 
                   ON cd.categories_id = p2c.categories_id
                      AND cd.language_id = '2' 
                                     
                               WHERE p.products_status = '1'
                                      AND manufacturers_id = '1' 
                                     
                            ORDER BY name in File: /.../.../.../.../.../web/tags/modified-2.00/inc/db_functions_mysqli.inc.php on Line: 152
02/09/2015 10:25:17 Backtrace #0 - /.../.../.../.../.../web/tags/modified-2.00/inc/db_functions.inc.php called at Line 104
02/09/2015 10:25:17 Backtrace #1 - /.../.../.../.../.../web/tags/modified-2.00/includes/modules/listing_filter.php called at Line 128
02/09/2015 10:25:17 Backtrace #2 - /.../.../.../.../.../web/tags/modified-2.00/includes/modules/product_listing.php called at Line 166
02/09/2015 10:25:17 Backtrace #3 - /.../.../.../.../.../web/tags/modified-2.00/includes/modules/default.php called at Line 304
02/09/2015 10:25:17 Backtrace #4 - /.../.../.../.../.../web/tags/modified-2.00/index.php called at Line 33

Attachments (0)

Change History (1)

comment:1 by Gerhard Waldemair, 10 years ago

Resolution: → fixed
Status: new → closed

In 8754:

fix #647

Modify Ticket

Action
as closed The owner will remain Gerhard Waldemair.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment
E-mail address and name can be saved in the Preferences .
Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.