Jump to content

All Activity

This stream auto-updates     

  1. Past hour
  2. 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.
  3. Hmm. When I click on anything it just stays on the main page, whether I click on the product details, return policy, privacy policy, etc. This is what you found earlier but I didn't have a chance to look into it yet and now it seems even the product details page will not load.
  4. Today
  5. Okay it looks like they have fixed the http Error 500. This is the email I received from my hosting company support agent: "I've corrected the rest of the missing autoincrement settings for the primary keys in the remainder of the tables that needed them, then reset the password for the admin user and now the site is working as expected. Regarding the apparent discrepancy between the advertised 896 MB RAM available and the specifics of the error message you recorded: your package does indeed support up to 896 MB RAM, but the CubeCart installation specifically limited it, per the following code: admin_klvcct.php 20 ## Include the ini file (required) 21 require 'ini.inc.php'; ini.inc.php 21 ini_set('memory_limit', '256M'); You are of course free to modify this but it should be more than sufficient for the software. The only reason it was hitting this limit was the result of the minor database corruption. Only fixing the database would have fixed it -- throwing more resources at it would just have prolonged the attempt to load the page by a few more milliseconds." I have no clue what he means by autoincrement settings. I wish he would have explained that better to me so I can check into it if it happens again. I am assuming I messed something up with the tables when I copied the review table to my new database. But now that is corrected it seems to have caused another issue: When I click on my product to go the product details page it does not take me there anymore and just stays on the main page.
  6. Yesterday
  7. 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.
  8. 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.
  9. 2020-07-07 16:05:57 SERVER -> CLIENT: 220 [server].co.uk ESMTP Exim Tue, 07 Jul 2020 17:05:57 +0100 2020-07-07 16:05:57 CLIENT -> SERVER: EHLO www.[domain].uk 2020-07-07 16:05:57 SERVER -> CLIENT: 250-[server].co.uk Hello www.[domain].uk []250-SIZE 52428800250-8BITMIME250-PIPELINING250-CHUNKING250-STARTTLS250 HELP 2020-07-07 16:05:57 CLIENT -> SERVER: STARTTLS 2020-07-07 16:05:57 SERVER -> CLIENT: 220 TLS go ahead 2020-07-07 16:05:57 CLIENT -> SERVER: EHLO www.[domain].uk 2020-07-07 16:05:57 SERVER -> CLIENT: 250-[server].co.uk Hello www.[domain].uk []250-SIZE 52428800250-8BITMIME250-PIPELINING250-AUTH PLAIN LOGIN250-CHUNKING250 HELP 2020-07-07 16:05:57 CLIENT -> SERVER: AUTH LOGIN 2020-07-07 16:05:57 SERVER -> CLIENT: 334 VXNlcm5hbWU6 2020-07-07 16:05:57 CLIENT -> SERVER: <credentials hidden> 2020-07-07 16:05:57 SERVER -> CLIENT: 334 UGFzc3dvcmQ6 2020-07-07 16:05:57 CLIENT -> SERVER: <credentials hidden> 2020-07-07 16:05:59 SERVER -> CLIENT: 535 Incorrect authentication data 2020-07-07 16:05:59 SMTP ERROR: Password command failed: 535 Incorrect authentication data SMTP Error: Could not authenticate. 2020-07-07 16:05:59 CLIENT -> SERVER: QUIT 2020-07-07 16:05:59 SERVER -> CLIENT: 221 [server].co.uk closing connection SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting Is there a way to see the <credentials hidden> that this popup hides?
  10. That is the only known problem and we use SMTP across many hundreds of CubeCart websites with no issues at all Ian
  11. Nope, just letters (UC and LC) and numbers
  12. OK - dont suppose you have any "special" characters in your password ? If so you will need to change the password to remove them and have numbers, uppercase or lowercase letters only - bug that has been around and reported for a long time !
  13. Yes, but the server and port settings are correct. It successfully connects to the correct host through the specified port. The pop-up window shows that. What fails is the user authentication. The user details are correct. I set them using paste and paste, so as to rule out any possible typos.
  14. Username and password are not the only things used for authentication for SMTP - you need the correct server name and correct port. SMTP is far superior to phpMail in terms of security, deliverability (many emails sent via phpMail will go into spam as they are unauthenticated) and traceability so it is a good idea to swap over. That along with the fact that phpMail will be phased out in the near future and some hosting companies already disable it's use on server security grounds Ian
  15. When I tried to set up email sending in the Admn, using the phpmail setting works, but smtp ssl or tls both fail with an error message that says the authentication failed, even though I just pasted the password and username into the server as well as the field in the Admin. The same details definitely work in the webmail, so something odd is happening in phpmailer 6.0.7
  16. 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
  17. How do i ad the ability to pay with bank wire / direct to bank account hwta page do i edit to include this infomation on /index.php?_a=gateway
  18. It was on the login page for the Admin panel. It allowed me to log in a couple times and then just stopped so I assumed it was something my hosting company did because they are still working on it and now want me to fix it. lol. Maybe the rep was putting in the wrong password and got cubecart to block me. I will delete all rows in CubeCart_blocker. Thanks again!
  19. 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.
  20. Well, I finally heard back from my hosting company. Apparently their 24/7 support does not work during the weekends. lol. This is what they had to say: "There unfortunately are no error logs on our shared hosting packages; the only available logs are those that are found in the ./logs directory of your webspace, plus the PHP scripting errors that you've already discovered how to collect. Nevertheless, I was able to determine that the cause of the blank page was a missing autoincrement setting for the primary key of, ironically enough, the table named ilmbb_CubeCart_system_error_log in the database. Now that that's out of the way however it's still giving me an invalid username or password error when I try to log in, so I'll try to solve that one next." I tried to log on also and received the invalid username or password error but after trying it 3 times it did finally log me in but since then I cannot get back in. Do you know what file holds the login information? Is it as simple as my being able to access that file to force a login?
  21. Last week
  22. @Al Brookbanks might want to remove this column from the table and remove from any queries ?
  23. 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/
  24. hi, is there anyway to change the speed in transitions between each slide regards JIm
  25. 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.
  26. Can someone tell me what this field is used for? Thanks!
  27. Okay I modified the code as you requested but when I went to my site www.ilovemybigbooty.com it now gives me the http error 500 instead of showing the site and no debug code. I noticed also in the error-log that the error was on the $trace = debug_backtrace(); statement (I should clarify I did have debug enabled but it did not show anything so I disabled it to see if the error would go away and after that I could not access my admin panel again to turn it back on).
  28. I decided to go a different way on the invoice. The emails work as they should. Thanks Brian.
  1. Load more activity

  • Newsletter

    Want to keep up to date with all our latest news and information?
    Sign Up
  • Create New...