Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited

Profile Information

  • Real Name
  • Gender
    Not Telling

Recent Profile Visitors

8,219 profile views
  1. Thanks, but as said The original base code from PS catalog class does not include a pd prefix as shown below: $raw_query_from = " from (" . TABLE_PRODUCTS . " p) join (" . TABLE_PRODUCTS_TO_CATEGORIES . " p2c) on (p.products_id = p2c.products_id) left join (" . TABLE_SPECIALS . " s) on (p.products_id = s.products_id) "; The commented part for testing inside /* -- */, see the error message is my little addition. It's not in the original file, but when uncommented it removes the 1054 error message, and still no good. Further, adding around line 340, same file, as said in my previous post all works for the products name filter: if ($products_column_name == 'products_name') { $products_column_name = 'pd.' . $products_column_name; } // if ($products_column_name == 'products_name') To fumble anywhere in this class file is certainly not the intended way as I am sure filtering specs on existing db tables fields other than products table is implemented elsewhere in the contribution as it's a functionality PS since ever has I as far as I can see.
  2. Works when I add : if ($products_column_name == 'products_name') { $products_column_name = 'pd.' . $products_column_name; } // if ($products_column_name == 'products_name') around line 340 in catalog/includes/classes/specifications.php just below this code: // The Manufacturer's column contains an ID and not the name, so we have to change it if ($products_column_name == 'manufacturers_id') { $filter_array = tep_get_manufacturer_id($filter_array, $products_column_name); $products_column_name = 'p.' . $products_column_name; } // if ($products_column_name == 'manufacturers_id') Filter work for the products_name on the products listings, but I am sure it's not how it is supposed to. If someone can tell where the process should actually happen and where a mix in files or mods occured, I would really appreciate. Thanks
  3. Thanks, but the pd prefix is missing in the original query whatever field is used as filter from that table. So my question is what went wrong, and where does it retrieve the needed prefix from as I cant see any reference to the products_description table in this query in the original catalog/includes/classes/specifications.php file for those specific specification filters .As you can see from the code snippet, I added with a little hope a ref. to the table myself and got rid of the error message, but that of course shouldn't be enough. So those filters still do not work ...
  4. Hello, On a 2.3.4 shop with PS 1.1.11 following error displays by filtering on TABLE_PRODUCTS_DESCRIPTION fields: 1054 - Unknown column 'products_name' in 'where clause' select count(p.products_id) as count from (products p) join (products_to_categories p2c) on (p.products_id = p2c.products_id) left join (specials s) on (p.products_id = s.products_id) /* left join (products_description pd) on (p.products_id = pd.products_id) */ INNER JOIN products_specifications ps17 ON p.products_id = ps17.products_id where p.products_status = '1' and p2c.categories_id = '432' and products_name sounds like '%PoE%' AND ps17.specification <=> 'Oui' AND ps17.specifications_id = '17' AND ps17.language_id = '3' [TEP STOP] I changed a little the specification class by adding the above custom join and the error disappears , but PS still wont filter on these table fields. All other filters work perfectly, it seems. Did I miss a new file or needed change in existing files? Could someone please try to explain? Thank you very much. David
  5. Let me clarify my "statements" It seems I d better make it clear now, especially if our charming multimixer is indeed runing a law suit as he claims he is for diffamatory statements: My feedback is exclusively my opinion. How should I know him, the facts or what he is. Never been able to reach or speak to him other than through spare but never ending mails. So those are NO statements. This feed back was in no way intended to destroy his reputation but exclusively for people to know what I experienced and on advice of an other oscommerce developer. It is up to the reader to make his own opinion by hiring him. All I wanted is warn in expressing my experience as subjective as it may sound in my english. When I say he is not part of oscommerce community, I hoped people could read between the lines i.e that he is on his very own in developing MTS. So if you don't want to be left aside choose a team so that when one falls back there remains option 2, which is better than a one man show. This is a principle oscommerce should know. As for the rest and his attitude towards work of others that is also my opinion, the way he writes or NOT about your efforts and those very big of others. Correction in GDPR "statement". I mixed 2 purposes which are: 1. No news on GDPR MTS updates (It came out in july 2018) but he was working on it before 2. A chance that with my few knowledge I was able to cope with monthes/years of no news despite innumerable unanswered requests per mail with still no explanations why. He if has something to say like excuses or add by other means than through his lawyer, I ll be glad for him, and foremost if he brings support and updates for PHP 7 ! Good customers except good support 😉 Best regards.
  6. I am apparently now threatened to be sued by any legal or public way for this public feedback .... Best regards
  7. Avoid Multimixer and MTS (Mini Template System) at any price! It is too bad! Forgive me please my english and very INCOMPLETE recap of my experiences hereunder: Multimixer is a very talented developer but is NOT part of the Oscommerce Community. He will only develop what he deems interesting to him with no regards, no respect for efforts made by the community or your own work. He is even disrespectful in regards to work of very well known and great contributors. MTS is advertised not to touch core files for easy integration of most existing OSC Add-ons. It is a SHAME to give Oscommerce Ambassador and/or Partner Status to a single man, so talented he may be, who is unable to work in a team. This leads to confusions as one may think he is making a good choice. I use Oscommerce now 10 years and like it very much, but be warned: If you want a program (website that can NOT be upgraded) go for MTS. MTS according to Multimixer, I learned 2 months ago, will never work on more that PHP 5.6. I was in a hurry to get from my site 2.2 site to responsive 2.3.4 and choose MTS because Bootstrap did not seem an option yet. I had to wait 6 months before he started working. It took over a year altogether, though I had already tested MTS before and had managed to have the latest MTS structure and all my needed contributions working with an 2.3.4 upgraded DB. You barely need any of MTS (very heavy and slow). All features are great but are as for the design of no interest at all once your design is set and final. It would have been much more useful and coherent to develop separate packages even if not free, meaning separating the design functionalities of MTS from the great features that come with it, like all the management module (links, banners, etc) and so on. I have used MTS for 2 years and what now? He tells me after several monthes' of astonishing and repeated silences, to go to hell and find somebody else. Everybody has fmilies in life and problems for sure, but it is not a reason to treat customers like sh...t. My opinion: He tries to show all kinds of interest for your project at the very beginning, but once it is completed in his own views, you will not get anymore support unless you let him do only what he wants. Anecdotic examples. 1. His GDPR Module. I never heard of it before I accidentely had a look at his blog, though I buyed MTS to be updated regularily about new features. By chance, I have enough knowledge to help myself and as despite several mail, I did not hear anything from him for almost a year, I had managed to get some of the GDPR adjustments myself. 2. Little design or MTS functionality issues. He needs never ending explantions, screenshots and is never happy with what you give him to start working. He did not start yet though he promised 2 month ago to do a last effort. If you change mind it is as though it is forbidden. He tries to make you feel an idiot going in circles. Never any suggestions to solve matters or if he agreed first then he pretends not knowing. Then he needs copies of your site and ftp access. He does not know how to use SFTP. Once you have managed to install a copy of your site on a test server with secured ftp access he refuses to log into it. 3. You need functionalities and Add-ons exists. You install them on his incitements and as you ve done everything to make it work you need little adjustments on MTS side. He says he is not interested in what those Oscommerce Add-ons do or pretends not knowing them. Apparently he only wants to sell his own packages. 4. MTS is time consuming, heavy, not upgradable, slow. I asked he said ĥe could make it faster... You don't need such a package as long as you don't want to sell your own templates, because that is what it is for, saying rapidly setting up design templates: And still you need quiet some knowledge to get working results. Anyways the list is too long, but this little writing may bring the fox out of the hole. Best regards
  8. Eim2

    Multi_Vendor_Shipping new thread

    Hello, I installed the lated MVS for 2.3.4 and have the exact same issue reported few times since 10 years here about: Shipping tax not being added to total tax on the checkout_confirmation page which prevents from using this fantastic ADD-ON when prices are set to show taxes: Has eventually someone succeeded in resolving this issue ?? Here are the messages on checkout confirmation for following example order total: Sous-Total: CHF 39.00 Best Way: CHF 5.00 Total TVA incluse: CHF 44.00 Tva 7.7%: CHF 2.79 Vat is added correctly to Subtotal, shipping and total, BUT not on total vat, that should be 3.15 not 2.75 !! Of course the module has apply tax on shipping true. Shipping Method: Best WayArray ( [2] => Array ( [weight] => 0 [cost] => 36.2117 [qty] => 1 [ship_cost] => 0 [products_id] => Array ( [0] => 3533 ) ) ) Vendor Shipping: true Array Vendor Shipping: Array ( [id] => [title] => Best Way [cost] => 4.6425255 [shipping_tax_total] => 0.3574744635 [vendor] => Array ( [2] => Array ( [id] => item_item [title] => Best Way [ship_tax] => 0.3574744635 [products] => Array ( [0] => 3533 ) [cost] => 4.6425255 ) ) ) Vendor Count: 1 Cart Vendor Count: 1 Orders ID: --------------------------------------------------------------------------------------------------------------------- Further I referr to Posted March 17, 2006 : 818132 tracking on same issue print 'Shipping Method: ' . $order->info['shipping_method']; in ot_shipping The method is there but, I admit I dont know at all how to change the code to check otherwise for the $module string ... Do I have to change $odrer with $module or place the same code somewhere else ?? Thanks so much if someone has found how to resolve the above important matter and is willing to share. Best regards
  9. Thank you Gergely for replying. Pdf invoices are only sent out when needed. checkout_process.php actually shall not be used. (on my osc 2.3.4, standard, I can't find tp_email_checkout_process.php) My question should have been: With the new class in email.php, how to automatically attach pdf invoices in the order notifications mails when orders are processed by myself from the admin side ? Present code in admin/orders.php: Do you mean the tep_mail_pdf_attach function should not be called from general.php but could be modified and set in orders.php to include the attachment code (build message code) ? It would this way put the values of ( $file, $filetype, $filename) into the email class add_attachment function ? I have found an example working with the new email class on how to send attachments to customers from admin/mail.php But how to do the changes in orders.php ... ? I am sorry but I have no knowledge in function building.
  10. Hello, I installed latest phpmailer together with email classes from Gergely's github sumbits. It works really very nicely from all sides of my website even with file attachements defined in language files. I just cant figure out how to dynamically attach the pdf invoices in the order processing mails as before the changes with sendmail. I use a function called from orders.php named 'tep_mail_pdf_attach' in general.php. As I have very few php knowledge I am, it seems, absolutely unable to retrieve the pdf file path and name. When I hard code in email.php like: $my_path = "path_to_file/filename.php" and $phpMail->AddAttachment($my_path); the attachment is sent out seemlessly but of course the invoice changes with each order ... As I understand the build_message function will not work with the new email class but in general.php that function is needed: function tep_mail_pdf_attach($to_name, $to_email_address, $email_subject, $email_text, $from_email_name, $from_email_address, $file, $filename, $filetype) { if (SEND_EMAILS != 'true') return false; $message = new email(array('X-Mailer: osCommerce')); $text = strip_tags($email_text); if (email_USE_HTML == 'true') { $message->add_html($text); } else { $message->add_text($text); } $attachment = fread(fopen($file, "r"), filesize($file)); $message->add_attachment($attachment, $filename, $filetype); $message->build_message(); $message->send($to_name, $to_email_address, $from_email_name, $from_email_address, $email_subject); } Could someone help out even if the problem certainly is in adapting the invoice pdf contrib's function, it would be nice. Thanks a lot in advance. David
  11. Eim2

    View Counter

    @@Jack_mcs Hello Jack, I ll check further and probably un- and reinstall eventually. For the admin color change, I guess it's because admin is now recognized first as bot without any ID ("No Bot ID") and then as admin. Really strange that it happened all of a sudden. One more I noticed. The referrer IPs drop down list is empty meaning no ip to select on the reports page whereas all other options show the full list of ips in the drop downs (Ip count, path tracker etc) Thanks a lot anyways. Regards
  12. Eim2

    Google XML Sitemap SEO

    @@Jack_mcs You say it, a non issue. No problems at all as indeed Google sees the files without errors and with a little tweaking through unix sed the missing special characters are added easily in no time. Thanks a lot
  13. Eim2

    View Counter

    Hello Jack, V.1.6 is the first version of View Counter I installed. The block countries option never worked as far I could test as per your todays instructions to eLara I tried the above suggested change in includes/modules/view_counter_country_block.php but the blocked_countrys_debug.txt is not created. I repaired the session table as suggested in previous posts, that did not help either. Also I noticed all of a sudden since about 3 days that the admin IP color changed to bot's color and did not show anymore as admin but as "NO Bot ID" in the Monitor reports Would you have any idea?
  14. Eim2

    Google XML Sitemap SEO

    @@Jack_mcs Sorry, sure the sitemap files, while I was absent, were chmoded to prevent them from being modified meantime. I can send the creation debug output, but except for the parent categories in sitemapcategories.xml without special caracters, all files are created fine, just they cant be read from a browser. I will try above comment by dsolutions in catalog/googlesitemap/index.php with: $domainArray[] = HTTPS_SERVER . DIR_WS_HTTP_CATALOG; as my shop is all https. Would be fine if that would be the only needed change.
  15. Eim2

    Google XML Sitemap SEO

    Hello Jack, Here it is the same as with IRIN . With the last 2 versions, we have to look at the source of the page to see it filled with either categories or products, i.e CTRL+U otherwise there is follwing message: "Google Sitemap http://aaabbbccc.xy/sitemapcategories.xml Number of sitemaps in this Google sitemap index: 0 Click on the table headers to change sorting." Of course with the source there is no sort options ... .-) I am using this addon since 2009 without any major problems except for special characters. I use a text editor to add them before sumbitting the fields to google, I thought that was now resolved but on problem remains : Special characters are ommited in parent categories urls when in Ultimate SEO URLS the option "Add category parent to begining of URLs?" is set to true.