ShadowMoses Posted May 23, 2007 Share Posted May 23, 2007 (edited) Not to be outdone by milerwan, the official Version 2.0 (that I have promised long ago) is released. B.K. & Kristian (don't know his username) got a sneak peak last week - I'm hoping no news is good news. This release fixes the obvious issues stated here, adds specials, adds multipart-text/html email version to help lower spam scoring. Overall, this release is more in-tune with the osCommerce standard of coding. Enjoy 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 Edited May 23, 2007 by ShadowMoses Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.