bsmither
Member-
Posts
18,132 -
Joined
-
Last visited
-
Days Won
607
Everything posted by bsmither
-
Please let us know the exact version of CubeCart you are using. The table posted above does not match what I see in the code. Essentially, the admin source script (categories.index.inc.php, for example) makes a call to ACP->successMessage($message). ACP->successMessage() passes to ACP->setACPNotify() In there, a call is made to $this->adminLog() In ACP->adminLog(), details of the action are sent to the database To show the log activity, the script settings.log.inc.php prepares each record and sends the list to the template. The template settings.index.php displays the prepared list. The prepared records uses the admin_id from the log entry to find the username and name of the admin. The admin_id is still available in the record. Also, the item_id and item_type is used to get the item's name and a link to the edit page for that item. The item_id and item_type is still available in the record. The most recent versions of CubeCart has added the columns in the database to capture the item affected.
-
Good to know where it is probably coming from. Better to know what page requests are being made just prior to when the web addresses go sideways.
-
I am curious to know-- What other indication was shown to you that the sending operation had failed. I believe the red-colored message posted above was from the Error Log, System Error Log tab. But what, if anything, prompted you to look there to learn if/why sending had a problem? I understand you received emails of non-delivery reports (NDR). But did CubeCart indicate something? Like, maybe the progress bar never reached 100%?
-
Realize that reCaptcha is not even close to being 100% effective against proficient spammers. I have seen, on occasion, the small "tab" peeking out at the bottom right of the page on Firefox for the 'invisible' reCaptcha. I don't use Chrome, so I can't discern why there is a difference. If the skin being used is Foundation (or based on Foundation), look at the skin's 'config.xml' file. There should be the following: <!-- Use this to add custom variables into the skin which can be found in the smarty SKIN_CUSTOM array --> <custom> <recaptcha_badge_position>bottomright</recaptcha_badge_position><!-- Invisible Recaptcha Badge Position: bottomright, bottomleft or inline --> </custom> Of course, we can't force a visitor's browser to accept javascript files, nor force what browser to use. So, YMMV. CubeCart does make sure that, if a Captcha response is required but missing or wrong, the data on the submitted page will be ignored.
-
I am going to ignore the lines that appear to come from an SSL Cert manager. I just wanted to make sure there is an appropriate RewriteBase directive. It will be interesting as to what would be found in the web access logs.
-
Recent versions allow for the product's manufacturer to be one of the terms to search on. A code snippet could include the category table looking for keywords. As for the resulting display, is the actual category going to appear in the list looking like a product panel, or simply that category's products will be listed?
-
There is this: https://www.cubecart.com/extensions/plugins/throttled-/-batch-sending-of-newsletters However, I would petition HavenSwift to add a filter to segregate a list of domains. The segregated list would be the only addresses to be throttled, all others would bypass the throttle and be sent immediately. (This would not detract from the main intent of this plugin, which is to work with hosting provider's limits.)
-
Does your host keep logs of page requests (web access)? If so, scanning through them looking for these weird URI's might provide a clue, such as there might be only one IP address doing this. Please also check the contents of the ,htaccess file. There should be these directives: ### Rewrite rules for SEO functionality ### <IfModule mod_rewrite.c> RewriteEngine On RewriteBase / The RewriteBase is the important directive.
-
I do not know this for sure. If the destination has anything to do with Yahoo/AOL, then bulk sending might trigger a limit on that end. Without more info, I have no other advice. Especially, I have no idea what "[015]" means. Could this be the page number of RFC-5322? If so, that is in the middle of a Date/Time format discussion. (In a distant past life, I did send in bulk. I had to throttle AOL and a few other domains to a slow trickle. I am confident that PHPMailer (a well-respected mailer) sends very accurate RFC compliant emails. It could be that, because the recipient's service became "unavailable", that right there is what might be non-compliant.
-
Could you better describe "RFC Compliance" issue?
-
That error response "reason" could be from the recipient's email provider. Here is a link to an issue I found: https://github.com/roundcube/roundcubemail/issues/8737 Let us know if you are sending out emails using an external SMTP server (maybe GMail's?).
-
"Where can I see the list of hits?" The page that shows a grid of product panels for search results is the 'hits'. "The product list appear should contain title Name and/or Product Code." The list will always contain the name. To inhibit looking in the 'description' column for search terms, make these edits: In /classes/elasticsearchhandler.class.php, near line 255, from: $should = array_merge($should, [['match' => ['description' => $q]]]); To: // $should = array_merge($should, [['match' => ['description' => $q]]]); In /classes/catalogue.class.php, near line 1990, from: $indexes = $GLOBALS['db']->getFulltextIndex('CubeCart_inventory', 'I'); To: $indexes = $GLOBALS['db']->getFulltextIndex('CubeCart_inventory', 'I'); unset($indexes['description']); Near line 2087, from: $like = " AND (I.name ".$like_keyword." '".$regexp."' OR I.description ".$like_keyword." '".$regexp_desc."' OR I.product_code ".$like_keyword." '".$regexp."')"; To: $like = " AND (I.name ".$like_keyword." '".$regexp."' OR I.product_code ".$like_keyword." '".$regexp."')";
-
Ok, then how is it you want the results? If 'keyw' appears in the Name and/or Product Code, regardless if it appears in the Description, it will be in the list of hits. You said if nothing was found in the Name or Product Code, then look in the Description. So, what is the difference? Would there be a difference in how the hits are listed?
-
Unfortunately, sometimes, the spooled debug data gets lost (at least for me). That means, sometimes, we cannot know, absolutely, what search phase was last used to get results. (I am tracing the execution to find out how and where the debug data gets lost.) The search phases are, in order: Elasticsearch, Fulltext, RLike, Like. However, an Elasticsearch query is coded to look in the 'name' ('title') and 'product_code', and if not using "Search as you type", the 'description' columns for the search term. Please verify that the search term might actually appear in the description. Also, Elasticsearch should have the capability, and might be configured to do so, to take a search term, then find its stem and lemma. (See Wikipedia.) As such, a 'hit' could contain words that have been expanded from the lemma. An example: search broken to get hits with break (this is the lemma), breaking, and broke. And then, if the search phase actually gets to Like, verify that the search term might actually be just a part of a bigger word.
-
Do you use PayPal? PayPal has this "mode" that will update the customer's address in CubeCart, with what (I presume is) PayPal has on record for the customer's 'verified' delivery address. (Note: I am not familiar with PayPal at all - this is just something I see complained about in these forums on occasion.) (Which has me asking the question: would this 'feature' cause shipping charges to be wrong?) Using an external database utility, look at CubeCart_order_summary, the customer_id, state, and state_d columns for a suspect order. Note the numerical values. Then look at CubeCart_addressbook for all the records where the customer_id is as was noted earlier. Compare the state numerical values. You can determine the name of the state by looking at CubeCart_geo_zone and use the id value of the table as the state numerical value.
-
So, when the order was created, the state name was correct, but then at some time later, when viewing that Order Summary in admin, the state name shown on the Overview tab is not correct? In admin, Admin Activity, scan the list for anything that looks suspicious.
-
That's my question: where does the index name come from? Is it auto-generated the first time ElasticSearch builds the index? Does the hosting provider assign it? sack123, where did you get the value for 'es_i'? (Note: The forum will not let me use the '@' notifier -- it refuses to allow a post that was edited to use it get re-saved. I hope you see this.)
-
I would think not. What you refer to is the access credentials to the MySQL database server. The mentioned $glob array elements for ElasticSearch would/should be different. If your site is hosted, and your host gives you a site management tool (such as CPanel), and if ElasticSearch is installed by your host, the access credentials to the MySQL database and ElasticSearch engine should have been emailed to you in your new subscriber "Welcome" notice, or, at least, these connection details would be shown somewhere in the management tool.
-
There is no legitimate way to do this. During setup, CubeCart looks at the language file definitions.xml, 'navigation' group, "seo_path_*" strings, and populates the database table CubeCart_seo_urls with records for the search, certificates, contact, register, recover, and login URLs. Also, certain redirects are created so that, for example, 'register.html' will bounce the browser to 'register'. (This is for a work-around for skins with hard-coded URLs.) However, another redirect can be created. In admin, Redirects & 404's, Redirects tab, the top row of the table allows to add a redirect from, for example: Page: Contact Us Redirect from: get-in-touch.html The web address "example.com/get-in-touch.html" can be used out on the inter-webs, and when CubeCart gets this, will bounce the browser to "example.com/contact-us". Sorry, you are asking for SEO Titles? That might be customizable in the Language Editor. Let me find it. Nope. Not there. The Contact Form allows to set a Meta Title. I thought a mod had been created to add meta data to these pages, but I cannot find it. Would you be interested in testing one?
-
This query comes from using the Quick Search text entry box or the Advanced Search page. Perhaps you were checking to see if the new products would show in a search? But for 700 times? (a pair of queries, one at line 1988 and one at line 1990) The term being searched on is "gQiz/**/ORDER/**/BY/**9977#", which looks to me like some joker is repeatedly feeding junk into the search box. Unless "gQiz" looks familiar? The error log should have the time the error took place. Are all the times really close together? And recent - as when you were adding products?
-
How to show number of products per category? (RESOLVED)
bsmither replied to webbunny's topic in Customising Look & Feel
This data is provided to the skin. It just becomes necessary to figure out how to display it. Try this. Using a programmer's text editor, make the following edits to the template file element.navigation_tree.php: Lines 4,9, and 14, change this: {$BRANCH.name} To this: {$BRANCH.name} ({$BRANCH.product_count}) Have CubeCart clear its internal cache after saving this edit. This simply appends the product count in parentheses to the category name. Anything more than this may require some fancy CSS rule changes. -
Was all of this put in place? https://forums.cubecart.com/topic/58270-photo-enlarge/ Especially the javascript edit? Looking at the GitHub issue #3202, it seems the javascript edit wasn't made.
-
Product options not showing up on Cubecart 6.5.3
bsmither replied to AeroLogistica's topic in Install & Upgrade Support
There is a module that one can add custom 'common' stuff. Send me a PM with your email address.