mySQL se puso DURO

Thread View: chile.comp.programacion

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Zarko Thu, 20 Dec 2007 21:35

#584

Author: Zarko
Date: Thu, 20 Dec 2007 21:35

39 lines
2972 bytes

Tengo una funcion (del addon "star products" en oscommerce con mysql)
que huevea con este mensaje:

1054 - Unknown column 'p.products_id' in 'on clause'

select substring(pd.products_description, 1, 598) as
products_description, p.products_id, p.products_image,
p.manufacturers_id, p.products_price, IF(s.status,
s.specials_new_products_price, NULL) as specials_new_products_price,
IF(s.status, s.specials_new_products_price, p.products_price) as
final_price, p.products_tax_class_id, sp.product_id from products p,
products_description pd, star_product sp left join specials s on
p.products_id = s.products_id where p.products_id = pd.products_id and
p.products_status = '1' and pd.products_description != '' and
p.products_id=sp.product_id and pd.language_id = '3'


*******************************

La funcion causante del problema es esta:


tep_db_query("select substring(pd.products_description, 1, 598) as
products_description, p.products_id, p.products_image,
p.manufacturers_id, p.products_price, IF(s.status,
s.specials_new_products_price, NULL) as specials_new_products_price,
IF(s.status, s.specials_new_products_price, p.products_price) as
final_price, p.products_tax_class_id, sp.product_id from " .
TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " .
TABLE_STAR_PRODUCT . " sp left join " . TABLE_SPECIALS . " s on
p.products_id = s.products_id where p.products_id = pd.products_id and
p.products_status = '1' and pd.products_description != '' and
p.products_id=sp.product_id and pd.language_id = '" . $languages_id .
"'");


Ademas entiendo que se debe a la nueva version de php 5 se puso mas
estricta con la sintaxis. Pero no cacho como dejar el codigo para que
siga funcionando.

Re: mySQL se puso DURO

#588

Author: mauricio sthandier r.
Date: Fri, 21 Dec 2007 00:24

45 lines
3073 bytes

por qu� no limpias el FROM ? o dejar las tablas enlazadas con los JOIN o hacer el enlace en el WHERE, pero no mezclarlos.
A primera vista est�s haciendo un join entre sp y s con *p*.products_id = s.products_id

saludos,

"Zarko" <zarko32@gmail.com> escribi� en el mensaje news:83bc226c-c57b-41b3-a64d-18cc85bcba8c@s8g2000prg.googlegroups.com...
> Tengo una funcion (del addon "star products" en oscommerce con mysql)
> que huevea con este mensaje:
>
> 1054 - Unknown column 'p.products_id' in 'on clause'
>
> select substring(pd.products_description, 1, 598) as
> products_description, p.products_id, p.products_image,
> p.manufacturers_id, p.products_price, IF(s.status,
> s.specials_new_products_price, NULL) as specials_new_products_price,
> IF(s.status, s.specials_new_products_price, p.products_price) as
> final_price, p.products_tax_class_id, sp.product_id from products p,
> products_description pd, star_product sp left join specials s on
> p.products_id = s.products_id where p.products_id = pd.products_id and
> p.products_status = '1' and pd.products_description != '' and
> p.products_id=sp.product_id and pd.language_id = '3'
>
>
> *******************************
>
> La funcion causante del problema es esta:
>
>
> tep_db_query("select substring(pd.products_description, 1, 598) as
> products_description, p.products_id, p.products_image,
> p.manufacturers_id, p.products_price, IF(s.status,
> s.specials_new_products_price, NULL) as specials_new_products_price,
> IF(s.status, s.specials_new_products_price, p.products_price) as
> final_price, p.products_tax_class_id, sp.product_id from " .
> TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " .
> TABLE_STAR_PRODUCT . " sp left join " . TABLE_SPECIALS . " s on
> p.products_id = s.products_id where p.products_id = pd.products_id and
> p.products_status = '1' and pd.products_description != '' and
> p.products_id=sp.product_id and pd.language_id = '" . $languages_id .
> "'");
>
>
> Ademas entiendo que se debe a la nueva version de php 5 se puso mas
> estricta con la sintaxis. Pero no cacho como dejar el codigo para que
> siga funcionando.

Re: mySQL se puso DURO

#658

Author: Zarko
Date: Mon, 14 Jan 2008 03:45

15 lines
2103 bytes

Se arregla con esta estructura :-)


tep_db_query("select substring(pd.products_description, 1, 598) as
products_description, p.products_id, p.products_image,
p.manufacturers_id, p.products_price, IF(s.status,
s.specials_new_products_price, NULL) as specials_new_products_price,
IF(s.status, s.specials_new_products_price, p.products_price) as
final_price, p.products_tax_class_id, sp.product_id from ( " .
TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " .
TABLE_STAR_PRODUCT . " sp ) left join " . TABLE_SPECIALS . " s on
p.products_id = s.products_id where p.products_id = pd.products_id and
p.products_status = '1' and pd.products_description != '' and
p.products_id=sp.product_id and pd.language_id = '" . $languages_id .
"'");

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads