Jump to content

ShadowMoses

Members
  • Content count

    11
  • Joined

  • Last visited

Everything posted by ShadowMoses

  1. ShadowMoses

    Newsletter products, HTML email

    Cool, i changed that... and now get another error :) 1054 - Unknown column 'p.products_id' in 'on clause' select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, NULL) as specials_price from products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = p.products_id and p.products_id in(53) and pd.language_id=1
  2. ShadowMoses

    Newsletter products, HTML email

    Almost! i get a new error now: 1054 - Unknown column 'p.products_image2' in 'field list' select p.products_id, pd.products_name, p.products_image2, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, NULL) as specials_price from products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = p.products_id and p.products_id in(53) and pd.language_id=1 Does it take into account some multi image contribution? Did you modify newsletter.php or overwrite with the one in the package? At first i modified it but i got an error (i forget what it was now) so, seeing as i hadn't changed anything in it before, i just overwrote it and it worked.
  3. ShadowMoses

    Newsletter products, HTML email

    I get this error when i save the newsletter: 1054 - Unknown column 'newsletters_id' in 'field list' insert into newsletters_to_products (newsletters_id, products_id) values (1, 53) I thought it would be an error in the sql for creating the table? So i changed it to this: (newsletter_id => newsletters_id) ALTER TABLE newsletters ADD template varchar(64) AFTER locked; CREATE TABLE `newsletters_to_products` ( `newsletters_id` INT( 11 ) DEFAULT '0' NOT NULL , `products_id` INT( 11 ) DEFAULT '0' NOT NULL , PRIMARY KEY ( `newsletter_id` , `products_id` ) ); But then i get an error when previewing a saved newsletter: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and pd.language_id=1' at line 1 select p.products_id, pd.products_name, p.products_image2, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, NULL) as specials_price from products p, products_description pd left join specials s on p.products_id = s.products_id where pd.products_id = p.products_id and p.products_id in() and pd.language_id=1 EDIT: also the readme is missing instructions for editing database_tables.php ADD: //newsletter products define('TABLE_NEWSLETTERS_TO_PRODUCTS', 'newsletters_to_products'); //end newsletter products
  4. ShadowMoses

    [CONTRIBUTION] Nochex APC Payment Module

    Someone very kindly helped me on the nochex forums, i haven't tested it 100% but this at least directs to my custom payment page:
  5. ShadowMoses

    [CONTRIBUTION] Nochex APC Payment Module

    Hi, i'm new to both Nochex and this contribution. It's installed and seems to be working fine but i just have one query: On the Nochex site i can configure a "Payments Page" and make it look just like my site but this contribution seems to take me to a different page, is there a way to make it go to the payment page i set up via Nochex? Thanks.
×