AndreD

uploaded a dirty fix to http://addons.oscommerce.com/info/5491 - still hoping for somebody that is competent (with PHP) to fix it properly.

additional info: reviews.php is only giving error messages when user is in /index.php , it works fine when user is displaying a category/product ! so "index.php?cPath=31" displays reviews & works fine, . strange ? whats_new.php is does not display errors like I claimed before ("whats_new" is the small box on side, that displays one item) the problem i related to another contribution that displays 6 new/latest products in "index.php" only (only when at "home" or "top" level). So, where's the problem ?

ok I rechecked everything - the above problem was wrong genaral.php file. Everything works, but I get these errors in "whats_new.php" "reviews.php" boxes: Notice: Undefined variable: text_watermark in /home/helihob/public_html/includes/classes/oscthumb.php on line 230 Notice: Undefined variable: image_watermark in /home/helihob/public_html/includes/classes/oscthumb.php on line 235 Notice: Undefined variable: bevel in /home/helihob/public_html/includes/classes/oscthumb.php on line 238 Notice: Undefined variable: frame in /home/helihob/public_html/includes/classes/oscthumb.php on line 241 Notice: Undefined variable: params in /home/helihob/public_html/includes/classes/oscthumb.php on line 255

Thanks for this great contribution. Whenever I click edit [admin/oscThumb/watermark image file] I get: Fatal error: Call to undefined function tep_cfg_pull_down_installed_watermarks() in /home/aaaaaaa/public_html/admin/configuration.php(125) : eval()'d code on line 1 Why ? - please help.

Anyone knows what causes this? - same browser on another computer can load just fine, but I'd rather not have my customers see this !

Products are still not sorted in alphabetic order .. update 2: "ORDER BY pd.products_name, p2c.categories_id");" fixed that. Thank you *very* much. I'll upload the complete fix to the contribution's page. It's most likely very useful to others should I credit you as "steve_s" - or maybe you prefer to do it yourself ? The complete, nice result is here: $products_query = tep_db_query("SELECT distinct pd.products_name, p.products_id, p.products_quantity, p.products_price_cost, p.products_price FROM " .TABLE_PRODUCTS." p LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN specials sp ON p.products_id = sp.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id WHERE p.products_status = 1 AND pd.language_id = FLOOR($languages_id) AND p2c.categories_id not in (" . implode(",", $exc_cat_id) . ") ORDER BY pd.products_name, p2c.categories_id");

Thanks, you are good at this :) I see that you are solving this in theory only, and that's impressive. I've been fooling with the while.. routines to try to achive this result. now it works, but the product name column is empty, so it's a little hard to verify what's what. - maybe it's just a minor typo somewhere ? (it did work before this change) Update: adding "pd.products_name," to teh SELECT command solved it.. Will re-check everything now, as it does not seem to be all sorted alphabetic ..

actually, I suspected the comma too, and tried to remove it, I got another error, so I did not mention it as I thought it was wrong. So here's the error I get without the comma: Array1054 - Unknown column 'p.products_cost' in 'field list' SELECT distinct p.products_id, p.products_quantity, p.products_cost, p.products_price FROM products p LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN specials sp ON p.products_id = sp.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id WHERE p.products_status = 1 AND pd.language_id = FLOOR(4) AND p2c.categories_id not in (65,66) ORDER BY p2c.categories_id, pd.products_name

Thank you, I got an error: Array1064 - 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 'FROM products p LEFT JOIN products_description pd ON p.products_id = pd.prod' at line 1 SELECT distinct p.products_id, p.products_quantity, p.products_cost, p.products_price, FROM products p LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN specials sp ON p.products_id = sp.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id WHERE p.products_status = 1 AND pd.language_id = FLOOR(4) AND p2c.categories_id not in (65,66) ORDER BY p2c.categories_id, pd.products_name Old query was (complete) $products_query = tep_db_query("SELECT * FROM " .TABLE_PRODUCTS." p LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN specials sp ON p.products_id = sp.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id WHERE p.products_status = 1 AND pd.language_id = FLOOR($languages_id) AND p2c.categories_id not in (" . implode(",", $exc_cat_id) . ") ORDER BY p2c.categories_id, pd.products_name"); The one that resulted in error; $products_query = tep_db_query("SELECT distinct p.products_id, p.products_quantity, p.products_cost, p.products_price, FROM " .TABLE_PRODUCTS." p LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN specials sp ON p.products_id = sp.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id WHERE p.products_status = 1 AND pd.language_id = FLOOR($languages_id) AND p2c.categories_id not in (" . implode(",", $exc_cat_id) . ") ORDER BY p2c.categories_id, pd.products_name"); Thank you

The name was both in the subject and the post. but sure; here's the link http://www.oscommerce.com/community/contributions,3161/page,6 :) For somebody that knows PHP well it's surely a minor fix - to remove the treatment of categories, and just process all products in stock. Thanks for looking at this case.

I have a working staocktaking cost contribution installed. The most important output, is the sum. The problem is, that it sums each category, and one product may be inside 2 or even three categories. - so the value of that product is summed 2 or 3 times. I'd like a fix that ignores categories, and just lists products - or at least does not add a product more than once to the total.

Anyone found a way to add shipping_method to the packaging slip ? I would like to see the selected shipping method there..

please ? (bump)

ok, solved it myself, contribution updated with CURL - the secure way to do it..

All I get is: Warning: file_get_contents() [function.file-get-contents]: URL file-access is disabled in the server configuration in /xxxxxxxxxxxxxx/whos_online.php on line 125 As my host said told me, this uses a well known, well exploited security issue, and CURL should be used instead to fetch data. Is there any plan to upgrade this contribution to use curl instead ?

My host found the problem: they needed to change a limit in suhosin - now it works perfectly.

Thanks for trying to help, the server uses already 60secs timeout. I have my hosting company to look at it.

Strange problem - no items updated. If I update anything in a large category, submitting the update (after clicking "update") takes some time... and then nothing is updated, and I am back to category selection (NOT seeing the category I cose before) Any smaller category works fine, items are updated, and then I still can see the selected category. I guess there is some timeout - but where ?

I guess you did not update filenames -file.

I think you are being annoyed by the fact that PayPal does not automatically send customers back to the shop after paying, if they did not loging to paypal, but just payed with their card. Let me quote myself: In the mean time, you could email PayPal and make them change this stupid policy - they prioritize "new members" before delivering the service you pay for.

I just discovered a major problem. If you have 10 items worth $100 - the total stock value should be $1000 but if you have linked copy of the same item in 5 categories, your stock value will be listed as $5000 ! Could somebody php-competent please add a check that excludes already counted items ? Please ?

BTW: both files have permissions set to 644

I see , what should I set them to ?

>>What are the current permissions on the file? the php file itself got even 777 for testing purposes. >>Do you have permissions sufficient to change the permissions? well, using FTP, sure, but I am not sure how to verify if the PHP engine is allowed to use chmod , may that be the issue ?

same problem - did you find a solution to it ?