Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


Posts posted by ecartz

  1. 41 minutes ago, lyonsperf said:

    I don't understand the reasoning in why they do this

    Three things: 

    1.  They may be using this to send spam email.  If the email address is for someone else but the personalized information is for "product/link they want to spam", they can use your email system to send their spam. 

    2.  They may want you to read the messages.  I.e. they are spamming you. 

    3.  They may simply be paid to do this.  Even if ineffective, they still get paid. 

    There are several Captcha mods, including two from Burt for Phoenix. 

    Apache includes the ability to block IP ranges.  I think there may be mods that help you configure Apache. 

  2.     if ( isset($trInfo->s2p_id) && ($s2p['s2p_id'] == $trInfo->s2p_id) ) {
          echo '              <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="document.location.href=\'' . tep_href_link('ship2pay.php', 'page=' . $_GET['page'] . '&s2p_id=' . $trInfo->s2p_id . '&action=edit') . '\'">' . "\n";
          $icon = tep_image('images/icon_arrow_right.gif', '');
        } else {
          echo '              <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="document.location.href=\'' . tep_href_link('ship2pay.php', 'page=' . $_GET['page'] . '&s2p_id=' . $s2p['s2p_id']) . '\'">' . "\n";
          $icon = '<a href="' . tep_href_link('ship2pay.php', 'page=' . $_GET['page'] . '&s2p_id=' . $s2p['s2p_id']) . '">' . tep_image('images/icon_info.gif', IMAGE_ICON_INFO) . '</a>';

    That's replacing 112-116.  Then at 128

                    <td class="dataTableContent" align="right"><?= $icon ?>&nbsp;</td>


  3. The notice is suggesting that there is a problem in the display_input function of cd_wholesale.php such that the $input_id is not getting set.  Perhaps a corrupted copy of that file?  Or it's barely possible that there is one configuration where it does get set and another where it does not. 

  4. 3 hours ago, ArtcoInc said:

    2) Aren't you supposed to have commas after each WHERE/AND line (except the last line)?

    3) I'm not sure if there are supposed to be commas after the JOIN/ON lines ... 

    No.  Only commas in the list between SELECT and FROM. 

    This is not supposed to be a subquery.  It's just supposed to replace the SELECT list, of, things with SELECT COUNT(*)

    It works by looking for ' FROM'.  For some reason, it is not finding ' FROM'.  If it is using the standard split class, go into the calling files and add an extra space before the FROM.  Not a tab or anything else.  A space. 

  5. 1 hour ago, Fredi said:

    SELECT COUNT(p.products_id) AS total SELECT

    Whenever I have encountered this problem, it was because the admin/includes/classes/split_page_results.php file was using case sensitive string functions.  So I went through and changed them to be case insensitive.  So one possibility would be that you aren't using the standard version of that file.  That's reinforced by the appearance of p.products_id in the COUNT clause, although that might suggest that this isn't using split_page_results.php at all.  At line 21, the standard version has

          $pos_from = stripos($sql_query, ' from');

    The next word after total should be FROM, not SELECT. 

    I would check what version of split_page_results.php is being used.  Then check that there isn't an App that uses something else instead. 

  6. 23 minutes ago, Omar_one said:

    Maybe using cURL instead will fix the issue. 

    Although then you have the problem of when curl isn't available. 

    It might be overengineering, but a generic remote file access class that could use whatever was available might be worth it.  

    A beginning:  https://stackoverflow.com/questions/3979802/alternative-to-file-get-contents/21177510#21177510

    Note that that still hard codes some of the curl options, which should probably be configured or parameterized instead.  I'd be willing to write something, but testing it would be a pain.  Because we would have to find people with all the alternatives or recreate all the different setups to verify that the failovers worked correctly. 

  7. In PHP 7.4, the actual problematic line is

          $cat_name = $category['categories_name'];

    which makes more sense with the error (dereferencing of null).  It's saying that there is no global variable named $category.  Perhaps this code predated the category_tree change.  I think it should be

          $cat_name = $GLOBALS['OSCOM_category']->getData($GLOBALS['current_category_id'], 'name');

    in the cm_in_featured_products.php file.  And in cm_i_featured_products.php, I think that line and all references to $cat_name in the template file should be removed.  Because the root category doesn't have a name. 

  8. German forum:  https://forums.oscommerce.com/clubs/6-german-community/

    This is the general English forum.  https://forums.oscommerce.com/topic/496159-installation-oscommerce/

    Perhaps you started from a German forum link (I think it used to be on a separate domain; perhaps it redirects to the English domain).  It looks like you can set the English forum to show the non-post content as German.  But the only German-specific section is the German Club/Community. 

  9. 9 minutes ago, ufty73 said:

    so weit alles ok und wurde alles auf den Server geladen, nur bei der Installation bekomme ich dann diese Meldung hier. 



    I'm sorry; I don't speak German.  Which is why I expect that you might get better help in the German Club, where German-speakers are more likely to reside.  I have to use Google Translate to read your posts.  I suppose I could use Google Translate to post my responses, but overall I think that would make things less clear.  Because then no one would be able to see the original English version.  This way, yes, you have to use Google Translate to convert my English into something you find readable, but at least there are my actual words. 

    That error says that there is a problem with the hosting settings.  You would need to ask your host to get the correct value for Database Server (the top field in your screenshot).  Apparently s274.goserver.host is either not the correct value to put there or your host has to reconfigure something to allow it.  Either way, that's something that your host would have to help you do. 

  10. Note that in the short term, store owners can get rid of the notices by changing the configure.php files to add

    & ~E_NOTICE

    to the error_reporting line.  While I think it is better to run at E_ALL because occasionally notices warn of actual problems, if they are getting in your way, that option is always open to you.  That's why error_reporting is now set in the configure.php file and not in the code.  So you can choose the level that works with the Apps that you have installed.  In fact, the update instructions from to included setting these to the old values for compatibility reasons. 

  11. 1 hour ago, ce7 said:

    if the some addon involve to modify code, let say order.php do i modify one of the file or do i modify all or something else?

    This has nothing to do with Rainer's Wholesale App (so this really isn't the right place to ask), but you should copy the latest version into includes/system/override (which you may have to create) and modify it there. 

  12. 9 minutes ago, René H4 said:

    Hi Matt, your Dutch reading skills are excellent! 🙂

    Thanks for getting into this - if it's a specific problem there's one more possible cause I can think of: After the language installation the language if for Dutch was 2 (English=1), I changed that to 4 since that came with other tables in the database (legacy shop). Could that cause the problem?

    Credit Google. 

    Perhaps check what language_id the customer_data_groups table has?  If that were 2 but it is 4 elsewhere, that could cause the fields to disappear entirely.  I was thinking that you were saying that ENTRY_WHATEVER was appearing.  But if you meant that it just isn't showing fields, an inconsistent language ID is possible. 

    It's also possible that it needs you to go to admin > Localization > Customer Data Groups and enter those values manually, like you would with order statuses.  I don't see anywhere that the language pack provides them.  Of course, it would be harder to Google Translate files than stuff on the web, so I might be missing something in the instructions. 

  13. 10 minutes ago, René H4 said:

    @Fiber Bert, ik wete niet of het aan mijn installatie ligt, maar ik mis met 1079 de invulvelden bij create account. 

    Als je dat kan, wil je dat dan eens bij jouw site nakijken? Dank je! 

    I took a quick look, and the entry fields seem to be properly present in includes/languages/dutch/modules/customer_data/cd_email_address.php

    I could look again if you have a specific field that seems to be missing.  But ENTRY_EMAIL_ADDRESS is there, so it wouldn't seem to be a general failure. 

  14. 45 minutes ago, raiwa said:

    Removing this line will make disappear the erro message but breaks the addon. You have to update the path instead to the correct location which is in includes/system/versioned/.

    I think that removing the line is the correct response.  The class should be autoloaded in any newer version, so it shouldn't break anything.  It should not be necessary to manually require/include anything under includes/system/versioned.  Nor for that matter under includes/classes, includes/system/override, includes/modules, or includes/hooks. 

  15. 29 minutes ago, burt said:

    It maybe an idea to add such a thing into Core.  Thoughts ?

    It might be easier just to remove the requirement that the order status exist. 

    LEFT JOIN orders_status s ON o.orders_status = s.orders_status_id AND s.language_id = " . (int)$languages_id . " WHERE 

    Also consider the case where the missing order status is not 0.