Jump to content
thirty bees forum

SLiCK_303

Trusted Members
  • Posts

    1,202
  • Joined

  • Last visited

  • Days Won

    18

Everything posted by SLiCK_303

  1. replace.. public static function getAttachments($idLang, $idProduct, $include = true) { return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS( (new DbQuery()) ->select('a.*, al.*') ->from('attachment', 'a') ->leftJoin('attachment_lang', 'al', 'a.`id_attachment` = al.`id_attachment`') ->leftJoin('product_attachment', 'pa', 'pa.`id_attachment` = a.`id_attachment`') ->where('al.`id_lang` = '.(int) $idLang) ->where($include ? 'pa.`id_product` = '.(int) $idProduct : '') ->where('pa.`id_product` IS '.($include ? 'NOT ' : '').'NULL') ); } with.. public static function getAttachments($idLang, $idProduct, $include = true) { return Db::getInstance()->executeS(' SELECT * FROM '._DB_PREFIX_.'attachment a LEFT JOIN '._DB_PREFIX_.'attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = '.(int) $idLang.') WHERE a.id_attachment '.($include ? 'IN' : 'NOT IN').' ( SELECT pa.id_attachment FROM '._DB_PREFIX_.'product_attachment pa WHERE id_product = '.(int) $idProduct.' )' ); } If you didn't have those two files handy... edit: I modified the first two variables, just to make it more a little more current. It would be nice if it was re-written with the (new DbQuery()) type... hint hint, nudge nudge... ;)
  2. no,no...you need to re-write that sql statement in tb 1.0.4 format, not leave it in the old school way.... ;)
  3. The problem lies in the /classes/Attachments.php file, in the getAttachments function. If I replace just that function with the one outta PS 1.6.1.17's file, it works.
  4. it happens in 1.0.3 and my latest source site
  5. The issue I see has to do with /classes/Attachment.php. If I take the one outta ps1.6.1.17, it lets me pick the same attachment for any/all products. As I'm not sure the ramifications of swapping out that file, I don't recommend this as a fix, but rather a starting point to troubleshoot the issue.
  6. I see the problem, once the attachment is used for one product, you can't pick it again for another product.
  7. @alwayspaws , I'm afraid I know nothing about csv imports or exports, or any code that controls it. Sorry...
  8. So, since v2.1.0 cron jobs have been working for me. The problem now is the, Last execution, never gets updated. It seems to stay at Never, even though the job has run.
  9. Works fine for me, in both 1.0.3 and in 1.0.4. Except for when you duplicate the product, then the attachment doesn't come along, but then again neither do specific prices so......
  10. Do you have any modules that might be messing with the delivery pdf? I know that was my issue with not seeing images in other pdf files.... I know thats not your issue, but just saying...
  11. They all are just different parts of the delivery slip. I dunno what to do, if the files are the same. Hopefully someone else has ideas....sry
  12. Backup your file, and try mine....
  13. hmm..and does it look like mine? 01514563334050delivery-slip.addresses-tab.tpl
  14. Do you have delivery-slip.addresses-tab.tpl in your theme pdf folder, or just in your root pdf folder?
  15. I don't think it can be done, without some override of the core files or something. Sending out the order_conf mail is a built in sorta thing....
  16. Ya might wanna do a post in bug reports, or on github
  17. goto BO>Orders>Statuses and unclick the, Send email to customer, for the ones you want to not send
  18. The problem is in v2.1.1, as I just tried 2.1.0 and it worked fine.
  19. you could always delete the associated email in mails/en(or whatever language you're using). That may create in error, I'm not sure, but may work for ya. edit: there has to be a better solution than that. As your customers when they do create an order, wont get those emails.
  20. nice job finding the problem...
  21. I could never get v2.1.1, in 1.0.3, working anyways, wait for the version in 1.0.4, it actually works. edit: hmm. same version in both. So I dont know what the problem is. Hopefully someone else can help ya.... edit2: Mine not letting me add anything either, all three of my sites, hmmm
  22. Thanks for the well wishes, I hope you had a good christmas as well.. At the bottom of the configuration for the Custom Payments Methods, when you edit your method, has a checkbox setup for groups, you have that setup, right?
  23. You can try setting it up like mine.. maybe that'll help. https://forum.thirtybees.com/topic/1230/email-error-message-when-updating-order-status-to-delivered/89. Or just use the COD module @alwayspaws posted.
×
×
  • Create New...