Jump to content
Latest News: (loading..)

All Activity

This stream auto-updates     

  1. Today
  2. naschell81

    Main page not loading

    I have been having an issue with my website for almost two weeks now. Over that time I have been going back and forth with the web host thinking the issue was on their end, since they migrated my data to a new server. However they are claiming it is not an issue on their end. Needless to say I am at the end of my proverbial rope as it is the holidays and my site has been down for far to long. Below is what is displayed when people visit the main page to my site, however it only appears to be that page as direct links to products still work. 3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'qrgxkhuc_osc2.p.products_ordered' which is not in SELECT list; this is incompatible with DISTINCT select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10 [TEP STOP]
  3. ich habe hier creare_account.php aber da ist was anderes
  4. Dann versuchs mal hier: https://forums.oscommerce.com/forum/79-commercial-support-inquiries/
  5. alleine kann ich das dann leider nicht machen. Trotzdem danke für die Hilfe! Ein Versuch war es ja Wert.
  6. Hello @artemu78, Yes, it is possible, but it needs to be custom coded. It can be based on this add-on: https://apps.oscommerce.com/0Fuy5&multi-admin-with-levels It is only possible to define different access levels for different files, but not categories. So it must be extended to restrict the access to different categories. If you are overwhelmed with this modifications, post a support enquiry in the commercial support area to find a developper who can do it for you.: https://forums.oscommerce.com/forum/79-commercial-support-inquiries/ Kind regards Rainer
  7. I need my employees can`t see and can`t edit product categories (and products) from other employee. I need to grant one category per employee and they can`t access another categorie. Is it possible in osCommerce?
  8. Damn nice! Btw: what is that header slide module you have on the test site? Keep up the good work!
  9. JcM-categories-navbar-V1.2 CE BS4/3 It has been updated make it works with BS4 and allow styling to be configured in admin. A simple addon to let you place dynamic categories into the Navbar. Again totally stand alone with no core code changes. Simply copy all files into relevant sections and go to admin modules /content and install. Enjoy. As allways can be seen on the test sites. BS4 https://chilleddisplays.co.uk/ BS3 https://www.justfastfood.com/
  10. works Thank you Phil
  11. Before spending any more time investigating this, make sure your browser isn't using a cached page or image. Either clear your browser's cache, or hit F5 or Ctrl+F5 on that page, and see if it doesn't change.
  12. osCommerce Online Merchant v2.3.3 I try in the admin change the image, i put a new .png image named logo_store.png and save the image. I received a message the store logo was updated successfully, but nothing, the image is the same as above.
  13. DAVID3733

    Http/2 vs http/1.1

    Hi Ok so OSC works and by the looks of it from your chart making multiple connections as it should which will speed up delivery Thanks for sending the graphic David
  14. Hello Anne @Dj-Viper, I'm going back to the public forum. Others may have a similar problem and can profit by the information. Most payment modules use the standard checkout processing through checkout_process-php. Orders are created, stored and the order confirmation mails created in that file. But some payment modules bypass this file and do their own order processing including the order confirmation mail creation in the payment module. The coding is therefore included in the payment module. The only payment module included in a standard oscommerce store doing so is PayPal standard. Now in your case the "payment processor ideal" you are using does the same. You have to apply the modifications in this payment module which is located in: includes/modules/payment/. Please use the instructions for the PayPal standard module as a guide how to apply the PWA modifications to your payment module. Instructions may not fit literally the code of your payment module, you have to try to find the equivalent code. Also add your modifications to include the customer mail and phone there. You do not need to apply the modifications to all payment modules, only the ones which bypass the standard checkout_process.php like your "payment processor ideal" and therefore do not use the modifications done in checkout_process.php. Hope this clears up your questions and helps Best regards Rainer
  15. cupidare

    product reviews google indexing

    It seems that that this module has no support for page=XX in some pages (such as products_new.php or similar)... this worked for me (also for my other pages, with "page" such as my testimonials page) : case 'products_new.php': if (isset($_GET['page']) && tep_not_null($_GET['page'])) { $oscTemplate->addBlock('<link rel="canonical" href="' . tep_href_link($PHP_SELF, 'page=' . (int)$_GET['page'], 'NONSSL', false) . '" />' . PHP_EOL, $this->group); } else { $oscTemplate->addBlock('<link rel="canonical" href="' . tep_href_link($PHP_SELF, null, 'NONSSL', false) . '" />' . PHP_EOL, $this->group); } break; and the canonical link shows to the correct page (at least in my understanding)
  16. @JcMagpieHi Zahid, Thanks for reply. I am using Hostpapa the past years, the services quality drop dramatically recent 2 years, this year UNLIMITED problems.... I was told that my account was mark as SPAM because of PHPIDS send the alarm Eamils to ourselves(that is why I did not like to mention my websites anywhere cause I always having lots of PHPIDS even the level setup not high...) I just wonder with newsletter at admin, it always showing the GIF file, don't close it while file sending but then have a red text line said been sent, it is just so confusing.....i have message on header setup that show if email or newsletter been sent or not, it always show sent but if i check my email account even spam or just mail, never receive it. However I did receive email when osCommerce set up confirmation email and when PHPIDS send report, but not from admin at all (to anyone)... so not sure it is Hostpapa server problem or admin problem.... gave the duplicate steps to Hostpapa and waiting for them to try and reply me back, maybe again take long time to respond....I will come back to update when i know what is going on.... Thanks! Lyn
  17. @pirolau Which version of osCommerce are you running? M
  18. This one. I need to replace this image with other picture, but i can´t find where is the place of the image cover in file and the image herself. Can you help me, please ?
  19. Yesterday
  20. This should work also for Guest orders. Another thing maybe that you have telephone input disabled for guests and get therefore an empty entry for telephone. To clarify this more, can you please post sample screenshots of a regular order mail and a guest order mail to see the difference.
  21. Hi, PWA at the moment 2.5r2 In checkout_process i have, this gives me order email with email of customer in it. // lets start with the email confirmation $email_order = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $insert_id . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_href_link('account_history_info.php', 'order_id=' . $insert_id, 'SSL', false) . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n\n"; // PWA guest checkout echo $OSCOM_Hooks->call('pwa', 'PwaCheckoutMailMod'); if ($order->info['comments']) { $email_order .= tep_db_output($order->info['comments']) . "\n\n"; } $email_order .= EMAIL_TEXT_PRODUCTS . "\n" . EMAIL_SEPARATOR . "\n" . $products_ordered . EMAIL_SEPARATOR . "\n"; for ($i=0, $n=sizeof($order_totals); $i<$n; $i++) { $email_order .= strip_tags($order_totals[$i]['title']) . ' ' . strip_tags($order_totals[$i]['text']) . "\n"; } if ($order->content_type != 'virtual') { $email_order .= "\n" . EMAIL_TEXT_DELIVERY_ADDRESS . "\n" . EMAIL_SEPARATOR . "\n" . tep_address_label($customer_id, $sendto, 0, '', "\n") . "\n"; } $email_order .= "\n" . EMAIL_TEXT_BILLING_ADDRESS . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_MAIL . $order->customer['email_address'] . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_PHONE . $order->customer['telephone']. "\n" . EMAIL_SEPARATOR . "\n" . tep_address_label($customer_id, $billto, 0, '', "\n") . "\n\n"; if (is_object($$payment)) { $email_order .= EMAIL_TEXT_PAYMENT_METHOD . "\n" . EMAIL_SEPARATOR . "\n"; $payment_class = $$payment; $email_order .= $order->info['payment_method'] . "\n\n"; if (isset($payment_class->email_footer)) { $email_order .= $payment_class->email_footer . "\n\n"; } } Greetings, Anne
  22. JcMagpie

    Http/2 vs http/1.1

    I would be supprised if you not already using http2, if you on a relativly new server! ask your host, or just use the chrome inspect tool to check. Many of my site are already using it and I've not seen any noticeable speed change.
  23. PWA (at least the last versions which use hooks) does not replace the standard mail neither generates it's own mail. It only appends data to the standard order mail. So in order to help, you should post your changes and tell us which exact PWA version you are using.
  24. Hi, Raiwa Yes. When a customer is registred the email of a order made is send out, have that edited to include the email adres of the customer. When they use the PWA than the standard mail without the edit is send. So i'm guessing is that PWA has his own mail setup. Greetings, Anne
  25. DAVID3733

    Http/2 vs http/1.1

    Thank you for your reply Not asking how to install Http2 but if anybody is running OSC on it ( i have 2.3.4bs) and what issues if any was there Very interested in any speed advantages found regards David
  26. JcMagpie

    Http/2 vs http/1.1

    ? You would need to implament that on your server and that would be dependent on your host ( assuming your not using your own server!). Google helps, First, install Apache version 2.4.17 or higher on your server. The installation of the HTTP/2 module for Apache takes just three steps: 1. Add repository: sudo add-apt-repository ppa:ondrej/apache2 2. Now, update Apache2 from this repository to get the latest modules: sudo apt-get upgrade apache2 3. Enable HTTP/2 protocol as a module for Apache: sudo a2enmod http2 Now we must enable HTTP/2 for your virtual host. Open a .conf file for your virtual host. You’ll see something like this one: <VirtualHost 192.168.1.1:443> SSLEngine on SSLCipherSuite ALL:!ADH:!EXPORT56:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP SSLCertificateFile /etc/ssl/star.example.com.crt SSLCertificateKeyFile /etc/ssl/star.example.com.key ServerName "one.example.com" DocumentRoot "/var/www/html/one" Protocols h2 http/1.1 CustomLog "/var/log/httpd/one-access.log" combined ErrorLog "/var/log/httpd/one-error.log" <Directory /var/www/html> AllowOverride none Order Allow,Deny Allow from all </Directory> </VirtualHost> Add this line somewhere in the VirtualHost section: Protocols h2 http/1.1 Save this, close the file, and don’t forget to restart the Apache2 service: service apache2 restart If you’ve done all of this correctly, the HTTP/2 protocol will start working.
  1. Load more activity
×