Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by bsmither

  1. In admin, Maintenance, Database tab, all of the tables found in that database will be listed. Any table that does not have expected indexes (KEY or INDEX, UNIQUE, PRIMARY, FULLTEXT) will have a warning banner. You might run into a situation where a table does have a PRIMARY index, but has a redundant KEY index for the same column as the PRIMARY. In this case, CubeCart will complain that there is a missing PRIMARY index. The solution is to delete the redundant KEY index. A column created (when the table is created or altered) can have an optional characteristic: auto-increment. This means that when a database record is inserted, the database engine determines the next higher available integer value and uses it for that column. Thus, when inserting a record, the program using the database does not need to figure this out for itself, as the highest current integer value is discovered, and the database engine automatically adds '1' to it and uses that value for the column. Auto-increment columns are used for 'id' purposes: admin_id, product_id, customer_id, etc. If CubeCart is showing something other than the correct product page, document page, whatever, there still may be an issue with the CubeCart_seo_urls database table. My experience is that, not that the web browser stays on the same page - as if no new request was made, but rather that CubeCart sent back the same main homepage.
  2. In classes/ajax.class.php, near line 286: Find: $test_mailer->SMTPDebug = 2; Change to: $test_mailer->SMTPDebug = 4; A PHPMailer debug level of 4 (DEBUG_LOWLEVEL) will not conceal the credentials of the debug output. Also, this debug level generates much more output.
  3. Well, probably, and I will get to that in a minute or two. Please know that, in our experience, using a mouse swipe (and sometimes even the keyboard) to highlight and then copy/paste text from one location to another will invariably also catch leading or trailing invisible (whitespace) characters, such as a tab character. Please try manually typing in the username and password into the form and retesting.
  4. Welcome JOE D! Glad to see you made it to the forums. The "Print Order Form" extension gives the customer, when choosing this method to pay, a printable web page that includes the necessary information. Your bank transfer information is entered on the module's administration settings form. See: https://www.cubecart.com/extensions/payment-gateways/print-order-form or https://www.cubecart.com/extensions/payment-gateways/bank-transfer
  5. The message is from CubeCart saying it was given an invalid username/password on CubeCart's admin login page? Or an error message from the database server that says the user/pass making the connection is not correct? If CubeCart's admin login page, then, making sure that you are using the correct username, and that CubeCart can send emails, you can use the "Forgot Password" feature. But, if you are not that far along and have not set up email settings, then look in the database table CubeCart_admin_users. The password is "hashed" and cannot be reversed back to the actual password. Having logged you in once, you must have used the correct user/pass for that one time. CubeCart may be blocking you because, within 10 minutes, you failed the login for five times. If so, look in the database table CubeCart_blocker. Delete all the rows found there.
  6. Please examine the Foundation skin template element.js_foot.php. There is a <script> tag as the last line. Find this part of that <script> tag: $('.bxslider').bxSlider({auto:true,captions:true}); Change just that part to: $('.bxslider').bxSlider({auto:true,captions:true,pause:##1,speed:##2}); So, ##1 is the delay in milliseconds (default 4000) between a transition. And ##2 is the time expended in milliseconds (default 500) in performing that slide transition. See more options at: https://bxslider.com/options/
  7. This column exists as far back as CubeCart 3.0.21 (last minor version), but there is also a 'stock_level' column as well. I am not finding any active usage of 'quantity'. Nowhere in admin is there a place to control this value. (I only looked at CC6.2.9, CC5.2.17, and CC3.0.21.) In CC6, there is a query that specifically includes 'quantity' when to fetch an array of products (by number of views) for the "Popular Products" box. But it is not used.
  8. You will run into a number of minor issues -- all because PHP 7 (7.4 is what I run, so not sure about earlier PHP 7 versions) is more strict about several things. (Another site I manage is running PHP 7.3 with it making no complaints at all. The server environment is commercially hosted by a seriously professional crew, so they wouldn't run PHP 7.3 if it caused issues with CubeCart.) Much of the above mentioned issues will be fixed in CC6.2.10. These issues are minor because they (nearly all of them) only cause PHP 7.4 to complain, but do the job anyway. Go for it!
  9. The edit to global.inc.php will force debug mode to be enabled, regardless what you do in admin, Store Settings.
  10. What is listed for ORDER_LIST in the debug popup? If, from the linked conversation above, you also created the snippet that uses this hook: "Description: Adds Customer Group Name(s) to Admin Orders List" then you would use {$order.cust_groups} in the printable admin invoice file orders.print.php.
  11. On the invoice template, at the end, add {debug}. Then bring up the invoice page to the screen (ready to print). There will be a popup of all the stuff Smarty was given to populate a template. Scan for BILLING in the left pane.
  12. This conversation may be of interest. https://forums.cubecart.com/topic/53037-orders-to-show-customer-group/
  13. I would try to convince the hosting provider to relax these type of security rules. Here's why: 1. The supposed vulnerability, according to the security message, is for a version of PHP prior to what you are running. 2. The trigger is happening on a request for something other than a PHP script file. 3. CubeCart uses dashes for the friendly URLs, i.e., /name-of-category/name-of-product.html, which may hit some triggers.
  14. It should be never; for CSS3. See https://www.w3.org/TR/css-speech-1/#speaking-props-speak and https://www.w3docs.com/learn-css/speak.html But, because no (current) web browser will act on it, it's safe to delete it. Or leave it - no harm done.
  15. Ignore what I suggested in my first reply. We have better info now. (I'll edit that post in a few minutes.) Alphabetical order???? Are they serious?
  16. The "better font rendering" rules are valid, but only MacIntosh OSX browsers understand it. So, the CSS validator may be accepting rules for only a specific browser, or (more likely) only rules that all browsers must know about.
  17. Regarding this: src : url("fonts/icomoon.eot?#iefix-hwvopr" the #iefix is to fix an issue in Internet Explorer 8 and below with respect to a CSS font-face rule having more than one source location. So, probably best to keep that. but not the -hwvopr.
  18. Here is what I am coming to understand. The font files have a certain name, that's all well and good, and the browser will cache them internally. But what if the font file changes? It has the same name. Thus, a technique is used called 'cache-busting'. Many browsers will know to fetch a fresh copy when it sees a querystring on the URL. The querystring starts with a question mark - and that's all that is (usually) needed. This querystring, starting with the question mark, ?-hwvopr most likely indicates a version code, or a package number from a collection of packages of sets of icons on someone's ICOMoon premium account. As such, delete as mentioned earlier. It is up to you if you want to keep the cache-busting question mark. Regarding the message posted above, was there an indication of what triggered it? If it was a -t then I would expect the trigger to be hit a lot more times - for everything.
  19. Remove the -hwvopr from the statements wherever you see it..
  20. I would imagine it is this that is triggering: url("fonts/icomoon.eot?-hwvopr"); Note the -h in the string of characters. I do not know what the effect would be one were to simply remove the -hwvopr from the statements.
  21. Better info follows. Ignore this post. ================================= As a work-around, in the style.css file: Delete: @font-face { font-family : 'icomoon'; src : url("fonts/icomoon.eot?-hwvopr"); src : url("fonts/icomoon.eot?#iefix-hwvopr") format('embedded-opentype'), url("fonts/icomoon.woff?-hwvopr") format('woff'), url("fonts/icomoon.ttf?-hwvopr") format('truetype'), url("fonts/icomoon.svg?-hwvopr#icomoon") format('svg'); font-weight : normal; font-style : normal; } .icon { font-family : 'icomoon'; font-style : normal; font-weight : normal; font-variant : normal; text-transform : none; line-height : 1; } The problem then becomes, what icons will be shown?
  22. If you can ever get to an admin page.... When having visited what I guess is your site, I noticed I was getting the cached/squeezed version of your CSS files. This tells me that you have not been able to switch on debug mode. Is this correct? If so, visit www.showmyip.com to get your workstation's IP address. Then, in /includes/global.inc.php, add these lines just before the last line (which is ?> $glob['debug'] = 1; $glob['debug_ip_addresses'] = "AAA.BBB.CCC.DDD"; // YOUR IP ADDRESS Then, in /classes/debug.class.php, near line 221: Find: $this->_sql[$type][] = '<span style="color:#'.$colour.'">'.htmlentities($message.' ['.$tag.']', ENT_COMPAT, 'UTF-8').'</span>'; Change to: $this->_sql[$type][] = $this->_debugMemoryUsage(true).' <span style="color:#'.$colour.'">'.htmlentities($message.' ['.$tag.']', ENT_COMPAT, 'UTF-8').'</span>'; This will add the peak amount of memory used to each SQL statement in the debug list. From this, we can tell just about where the sudden jump in memory consumption happened.
  23. If you believe you need to remove a plugin manually, then: 1. In your hosting control panel, use the File Explorer (File Manager?) to view /modules/plugins/ (might be /modules/gateway/ depending on the actual PayPal module) 2. Delete the PayPal folder 3. Using phpMyAdmin, view the CubeCart_modules table. Find and delete the record where 'folder' is "PayPal". 4. View the CubeCart_config table. Find and delete the record where 'name' = "PayPal" The word "PayPal" is used where the actual module might be named something slightly different. Factually speaking, if your site uses more memory than what PHP is specified to use, then PHP will crash - and report that memory had been exhausted. This is just a fact of PHP and not because of having tripped a hosting service's 'resource monitor' that will shut down your script (like, for example, hogging access to the database).
  24. Setting the memory limit, if it didn't work in the script, then it won't work in the .htaccess file (if changing it would work there anyway - I don't know). Your hosting provider may have that locked down as well.
  • Create New...