Jump to content

bsmither

Member
  • Posts

    16,636
  • Joined

  • Last visited

  • Days Won

    547

Posts posted by bsmither

  1. You also posted this:

    https://forums.cubecart.com/topic/56830-us-customer-able-to-order-even-that-zone-is-disabled-for-ususa/

    which a comment near the end asks what I asked here, earlier.

    The PayPal Commerce module description on the Marketplace suggests version 1.4.9 begins to implement a fix for some sort of country dis-allowance problem.

  2. I am not really familiar with many of the PayPal modules. Are you familiar with this module having that mode where the customer can fill in their address at PayPal, and then where PayPal sends that back to CubeCart so that CubeCart updates the customer's Order Summary details (such that the customer initially specified a UK address at checkout)?

    Does this issue seem applicable?

    https://github.com/cubecart/v6/issues/2918

     

  3. There is this:

    https://www.cubecart.com/extensions/shipping-methods/store-collection

    It is a shipping method (sort of).

    You can use this in combination with:

    https://www.cubecart.com/extensions/payment-gateways/print-order-form
    or
    https://www.cubecart.com/extensions/payment-gateways/usa-canada-print-order-form

    with the module's description being something like "Pay at Pickup".

  4. CubeCart uses Google's reCaptcha, which Google has recently upgraded.

    There are several places in CubeCart where the reCaptcha puzzle is displayed: Contact Us, Registration, Check out as a Guest, and Submitting a review.

    If you are using the Foundation skin that shipped with the most recent versions of CubeCart, there should be no problem.

    However, to use Google's recent version of reCaptcha, you will need to acquire your own keys from Google. In admin, Store Settings, Features tab, Bot Protection section, there is the link to aquire your keys from Google.

    Note, you can also switch off the reCaptcha system.

    If you are not using the Foundation skin, then we need to troubleshoot the skin being used.

     

  5. "In the SESSION: section, there will be a '__basket' array. In that array, there will be an element named 'By_Category_Shipping'."

    If there is no '__basket' array in the SESSION: block, then perhaps when viewing this page, there was not as yet a product in the basket?

  6. I do not know anything about Pinterest, but from the arguments of the function call to pintrk(), I assume you want this function call to happen only when the customer adds something to the cart, and only when the customer starts the checkout process.

    Is this assumption correct?

     

  7. Just to make a video file available is very easy: just code a <video> tag in the product's description.

    See:

    https://www.w3schools.com/html/html5_video.asp
    https://www.geeksforgeeks.org/html5-video/

    But to make a reference to a video file, to associate it with a product in the same way as with JPG images, for a thumbnail to use in the product's Image Gallery, that will take some interesting coding.

    I am almost done - if I can just get past all these holidays!

  8. Make sure the folder /setup/ exists. If it doesn't, download CC644 to your local computer, extract the /setup/ folder, then FTP that folder to your site.

    Run www.mysite.com/setup/index.php

    The setup system will determine if the database needs updating. If so, you will be given a choice of a fresh database or to update the existing database.

    Choose to update.

  9. I've never seen this before!

    Things to check:

    1. Load the image /images/source/1PS19HBB102.jpg into an image editor (such as Irfanview, Microsoft Paint, Corel Draw, etc). Examine the image properties. If the EXIF info says for ColorSpace other than sRGB, then the PHP extension "GD" might not know how to handle these JPG images.

    2. Make sure PHP's "GD" extension is installed and enabled. In CubeCart's admin, PHP Info, scroll down the list of tables until you find, or should find, "gd". If the GD table is not in the PHP Info page, find out how to enable it.

    3. Do these images appear on the store front? Check the error log.

    4. Check the error log. In admin, Error Log, System Error Log tab, see if any errors are logged relating to problems with images.

  10. I don't recall 'Logos" being in the File Manager section of the Navigation pane. Still, in this File Manager section, you have Documents, but not Downloads, have Images, but not Email Templates, and not Contact Form? And "Store Settings/General"? That should simply be "Store Settings".

    If you are sharing a database, then this Upgrade History page reflects the store that did have the Setup system executed. For that store (of which you are using it's database for this store), it was upgraded from CC622 (itself installed Feb 2019) directly* to CC628 on Feb 2020. Then to CC629, then to CC641, then to CC642.

    What I am very suspicious about are the entries for CC643 and the very next day CC644. A "fresh" installation, to my mind, also includes a separate database dedicated to that installation. Since this new installation is using a database belonging to a different installation, the new installation logged its date of installation in the other installation's CubeCart_history table.

    * By directly, I mean there was not the sequence of having to install each intervening version. Each version in its download package has all the scripts from all the prior versions going all the way back to CC400 -- and CubeCart will update an existing database as far back from that if necessary, to the current version, in one step.

  11. For every freshly installed package (CC644, for example), there is a folder that contains numerous files that have all the SQL statements necessary to add, delete, whatever necessary to get the database schema from where it is at (CC622 schema, for example) to the very next version (CC623 schema, for example), then to the next version (CC624 schema, for example). One by one, these files are executed to bring the database, through each intermediate version's schema, to the current version's schema.

    The starting point is the highest version logged in the existing database CubeCart_history table. For each intermediate version's file, the Setup system will log that version in the History table.

     

  12. I see there is a change that happened in CC623 that added a 'live_from' column to CubeCart_inventory, and if CubeCart does not know how to handle that missing column, then I can postulate (aka, wild guess) that products won't be found "live" to show.

    So, if that's the case, then if no products, and if CubeCart is set to not show empty categories, then no categories.

    The store's configuration settings are saved in the database.

    So, if sharing a database between two stores, that means also sharing the Store Settings. Logos (and the location of the images) are part of that.

    Are you using a copy of the CC622 database, or actually sharing the database?

     

  13. Even though CubeCart has a new feature where the admin can edit the Invoice using the WYSIWYG editor(admin, Documents, Invoice Editor tab), I recommend not doing so - I find problems with this.

    Instead, using a programmer's text editor, in the admin skin template orders.print.php:

    Find:
    
    		<div class="total"><strong>{$LANG.basket.total_grand} {$order.total}</strong></div>
    	  </div>
    
    Add after:
    
    		<div class="total"><strong>Includes GST of {"%01.2f"|sprintf:$order.total/11}</strong></div>
    	  </div>

    The {"%01.2f"|sprintf:$order.total/11} should show the value to two decimal points. PHP's sprintf() requires the first argument to be the format pattern, which requires Smarty to operate on the string, then use the value as the second argument to sprintf().

    Try that. (I haven't tried it myself.)

  14. Please verify that the database user (as configured in the database server) allows 'aac-Robert' to access it at 'localhost'. A database server user can be limited to 'localhost', '127.0.0.1', coming from a specific IP address, using some other authentication method, any method whatsoever ('*'), any one or more of these methods.

    So, if CubeCart wants to use 'localhost', but the server sees for 'aac-Robert' access only by '127.0.0.1', that user will be denied.

    In a subdomain -- so other CubeCarts in sibling folders can access that same database?

     

  15. I believe the CC65 series does use the CC643 database.

    Please know that CC65X betas are building up the ElasticSearch integration - and only that. I believe any changes made to CubeCart after CC643 in the CC64 series will not be included in CC65 (perhaps, eventually, after the ElasticSearch integration is complete).

  16. I added above:

    "But then, again, all those other URL patterns work. Only when needing to rewrite one."

    I can agree that moving CubeCart need not happen.

    Let's look at the other sites:

    The Aeronca and Bellanca bulletin boards may not need any URL rewriting, if there is an .htaccess file.

    But you may want to compare the user:group ownership (chown) and file (chmod) permission on each of these three .htaccess files.

     

  17. The storefront does come up. So, it can only be the case that the .htaccess file that the error messages were mentioning has the wrong permissions, or that whatever is wanting to look at the .htaccess file is looking at a place where it is not at.

    This works:

    https://ccstore.aeronca.org/index.php?_a=product&product_id=26
    Bounces to:
    https://ccstore.aeronca.org/volume-10-member-price-16.95.html
    which causes an error.

    This also works:

    https://ccstore.aeronca.org/index.php?seo_path=volume-10-member-price-16.95.html
    https://ccstore.aeronca.org/index.php?seo_path=contact-us.html
    https://ccstore.aeronca.org/index.php?seo_path=aeronca.org
    Note the seo_path in the querystring.

    The rewrite directives in the .htaccess file appear to be correct (with the changes specified), but I think that is where the web server is faulting.

    Apache can have a directive entered in its virtual host file to debug the mod-rewrite directives.

    See:
    https://stackoverflow.com/questions/9632852/how-to-debug-apache-mod-rewrite
    https://stackoverflow.com/questions/69525973/getting-error-in-cpanel-regarding-htacess-permission
    But you may need to get your hosting provider involved if you not running your own dedicated virtual server.

    Researching the error message suggests CPanel really expects all web sites (or at least specifically the .htaccess file that needs to be checked) to be in the /home/cpaneluser/public_html/ folder or child folder- which I believe your site is not, being in a sibling folder.

    Think about moving the site to /home/aac/public_html/ccstore/ and point the subdomain ccstore.aeronca.org directly to it.

    But then, again, all those other URL patterns work. Only when needing to rewrite one.

  18. Still looking on how to hack this.

    But from your description in the OP, comparing how you describe what you are after, it seems to me there is some confusion.

    You want the coupon to apply its calculations to the subtotal? Or (I think actually) you want the coupon to apply its calculations to one or more of the line items' "full retail price"?

    The "What he needs" detail above seems to suggest there is to be a discount applied to Product Z (whatever you wish Product Z to mean).

    I am focusing on the AIOS module.

  19. As for the Document Root, is it just to be understood that /home/aac/ is actually part of the root path and so need not be displayed, or might that part of the path actually be missing that should be showing the full path to the site's document root?

    But the admin is still working fine?

     

  20. Please do not confuse a sub-domain with a sub-folder. "ccstore." is a sub-domain (technically, so is www., but that is a universally understood situation).

    Earlier you said that the admin side of your store is working fine. Denied permission would still happen when requesting the admin PHP script if this were really the issue.

    Reviewing earlier statements, an error referenced:

    /home/aac/CCstore.aeronca.org/classes/db/mysqli.class.php

    Ok, so now we assume that CubeCart has been installed in /home/aac/CCstore.aeronca.org/, where the folder /CCstore.aeronca.org/ is considered as the site's "root" or "home" or aka "public_html" folder.

    That means, the web server configuration may have an incorrect designation as to what is stated as to where CubeCart is located.

    But the admin is still working fine???

     

×
×
  • Create New...