bsmither

All those prices are of an increase of 0.416, or a 41.6% increase - such as a tax, or a money conversion rate. Did you, perhaps, request new currency exchange rates today? In admin, Currencies, are there more than one currency enabled? Does USD have an exchange rate of 1.00000? If so, maybe the suspect customer chose a currency other than the store's default (admin, Store Settings). Thus, what you see in the email is the customer's price (although why a USD currency symbol?), but in admin, you see the product's true local price.

Compare the contents of /includes/global.inc.php with what the log on credentials are stated to be in the hosting account's control panel, MySQL Database details. Access denied is happening even before getting to the tables. So, there is no need to try to repair the tables. And, true, InnoDB does not get repaired. I think they don't ever have that problem. CubeCart several versions back switched to having most (not all) tables go with InnoDB for performance reasons.

From the storefront code, I find: var gallery_json = { "image_177":{"id":"177","product_id":"51","file_id":"73","main_img":"1","type":"1","disabled":"0","filepath":"","filename":"NUC0025-Demons-grey.jpg","filesize":"76686","mimetype":"image\/jpeg","md5hash":"7f794a12faaa6b620559c0801a16466c","description":"", "source":"\/images\/source\/NUC0025-Demons-grey.jpg","thumbnail":"\/images\/cache\/NUC0025-Demons-grey.100.jpg","category":"\/images\/cache\/NUC0025-Demons-grey.300.jpg","subcategory":"\/images\/cache\/NUC0025-Demons-grey.100.jpg", "gallery":"\/images\/cache\/NUC0025-Demons-grey.50.jpg","normal":"\/images\/cache\/NUC0025-Demons-grey.300.jpg","enlarge":"\/images\/cache\/NUC0025-Demons-grey.600.jpg","tiny":"\/images\/cache\/NUC0025-Demons-grey.30.jpg", "small":"\/images\/cache\/NUC0025-Demons-grey.175.jpg","medium":"\/images\/cache\/NUC0025-Demons-grey.300.jpg","large":"\/images\/cache\/NUC0025-Demons-grey.600.jpg"}, "image_179":{"id":"179","product_id":"51","file_id":"69","main_img":"0","type":"1","disabled":"0","filepath":"","filename":"LostSoulBDgrey.jpg","filesize":"232923","mimetype":"image\/jpeg","md5hash":"722dbc7b5ea244a09498dcd383318150","description":"", "source":"\/images\/source\/LostSoulBDgrey.jpg","thumbnail":"\/images\/cache\/LostSoulBDgrey.100.jpg","category":"\/images\/cache\/LostSoulBDgrey.300.jpg","subcategory":"\/images\/cache\/LostSoulBDgrey.100.jpg", "gallery":"\/images\/cache\/LostSoulBDgrey.50.jpg","normal":"\/images\/cache\/LostSoulBDgrey.300.jpg","enlarge":"\/images\/cache\/LostSoulBDgrey.600.jpg","tiny":"\/images\/cache\/LostSoulBDgrey.30.jpg", "small":"\/images\/cache\/LostSoulBDgrey.175.jpg","medium":"\/images\/cache\/LostSoulBDgrey.300.jpg","large":"\/images\/cache\/LostSoulBDgrey.600.jpg"}, "image_178":{"id":"178","product_id":"51","file_id":"72","main_img":"0","type":"1","disabled":"0","filepath":"","filename":"NUC0025-Demons.jpg","filesize":"76686","mimetype":"image\/jpeg","md5hash":"39c5608ecb69502ea97db4151490d8d4","description":"", "source":"\/images\/source\/NUC0025-Demons.jpg","thumbnail":"\/images\/cache\/NUC0025-Demons.100.jpg","category":"\/images\/cache\/NUC0025-Demons.300.jpg","subcategory":"\/images\/cache\/NUC0025-Demons.100.jpg", "gallery":"\/images\/cache\/NUC0025-Demons.50.jpg","normal":"\/images\/cache\/NUC0025-Demons.300.jpg","enlarge":"\/images\/cache\/NUC0025-Demons.600.jpg","tiny":"\/images\/cache\/NUC0025-Demons.30.jpg", "small":"\/images\/cache\/NUC0025-Demons.175.jpg","medium":"\/images\/cache\/NUC0025-Demons.300.jpg","large":"\/images\/cache\/NUC0025-Demons.600.jpg"} } So, CubeCart is reading the database correctly for the storefront. We need to figure out why the Edit Product, Image Picker isn't showing these three files as selected.

Try this. After getting an account with FirstData/Payeezy: For testing the Authorize.net SIM method, install the Authorize.net module and configure it. Then, using a programmer's text editor, open the file: /modules/gateway/Authorize/gateway.class.php Find: $this->_url = $this->_module['testMode'] ? 'test.authorize.net' : 'secure.authorize.net'; $this->_path = '/gateway/transact.dll'; Change to: $this->_url = $this->_module['testMode'] ? 'demo.globalgatewaye4.firstdata.com' : 'checkout.globalgatewaye4.firstdata.com'; $this->_path = '/payment';

This is a common mistake (caused 100% by the fact there is no documentation on how to set this up). What you have is a USPS Merchant Account. Nothing wrong with having one of those. But what you actually need is an account for the USPS Webtools. Go here: https://www.usps.com/business/web-tools-apis/welcome.htm Step 1 is a sign up. Once you sign up, USPS will email to you your USPS Webtools Username. This username is something USPS creates for you. You do not create it yourself. Once you make a few tests requesting rates, you then email them back asking to put this username onto their "production server". This is explained in the email they send you.

Something else must be going on. In admin, Manage Extensions, scroll to the Languages listing. This will show all language packs seen in CubeCart's /language/ folder. (Editing these files is not the preferred method of changing phrases.) Compare the enabled status of each with what is shown in admin, Languages. These lists should be the same (with the addition of "Master Language File").

We will need to make one more check to verify something. You will need to access the database directly using an external tool, such as phpMyAdmin. (phpMyAdmin is a tool commonly found in your hosting account's control panel.) In CubeCart_inventory, locate the product_id for the suspect item. That item may be one of the last few items added to the table. Using that product_id, and looking in CubeCart_image_index, filter the list for that product_id. It may help to reverse sort on the 'product_id' column. Note any records that may exist having that product_id. If so, note the 'file_id's of those records and which one has 'main_img' with a '1' for the value. Then, in CubeCart_filemanager, the' file_id's will show the path and filename of the images being used. Now, if there are no records in CubeCart_image_index having the product_id of the suspect item, then... well, I don't know. I'll have to think about that case.

The way to remove the assignments of images to the product is via the Image Picker when editing the product. Unckeck and un-star the image associations. There must be some checked checkboxes and a gold star shown in the Edit Product, Images tab. At the top of the Image Picker, there is a button that says to show only assigned images. However, I think that limiting the listing is still only relative to the current showing directory.

The module allows for a "handling cost". This is understood to be what it costs you in your manpower costs for the price of the box and the time it takes to pack the box and get it to the UPS store.

I would think this is not a problem with the skin. To review, you have the Clone settings in admin set to not include copying the image assignments? If so, then when viewing the list of Product Inventory in admin, the new clones (should be at the top of the list) should show an empty space in the Image column. Is this the case?

How UPS decides what to charge for its shipping services are not precisely known. I suppose generally the rate quoted involves weight and distance. You say "it worked", but you didn't say which option you chose: supress estimates until actual delivery address known, or show estimates based on shipping the package back to your store's physical location (which, of course, would be way off compared to shipping across the country). Also, the rates quoted would (presumably) be the same as if you carried the package into a UPS store. This is opposed to having a UPS merchant shipping account, and through that account, enjoy "negotiated rates". Cubecart's UPS module is not coded to communicate for negotiated rates.

I cannot replicate what you are experiencing (with CC6112). In admin, Store Settings, Extra tab, with Clone Images checked, a cloned product carries over the images of the source item and can be changed. Then, with Clone Images unckecked, a cloned product did not carry over the images from the source item. Viewing this cloned item in the storefront showed the skin's "No Image Available" image.

I would think those error messages are being shown as having been received by BrainTree/PayPal. As such, maybe exploring the information available at your merchant account at BrainTree/PayPal would give a clue as to what to do about "vaulting methods". But I see that the selector says "No". So, I don't know.

Certainly, if this all of a sudden started to happen, then we have a strong case to blame the hosting company. It could be the case that they installed and enabled an overly agressive server-level cache utility. One where the login page has been cached and is served containing an obsolete security token. Or, as I have heard about with one other instance, a recent browser update has acquired overly aggressive protocols using its (the browser's) internal cache. Instead of using the cache for a page's resources (images, css, and javascript files), the actual page is brought up from its cache as well.

I have seen weirder things, but I cannot imagine how fixing line endings of a PHP script would affect the script's operation.

Let me try to replicate the steps you take cloning a product, just to verify if images get cloned but otherwise those assignments are not able to be changed later. It just seems very strange this is happening.

The skin is comprised of several template files. You will find them at /skins/name_of_skin/templates. They are regular HTML files but incorporate template rendering commands - Smarty syntax. They have the filename suffix of .php but they are not PHP scripts. The file you are wanting is main.php. There is something you must keep in mind if editing a template. Smarty syntax starts with an open-brace immediately followed by the command or variable name followed immediately by a closing brace. This syntax looks exactly like javascript syntax. The difference is that javascript can have spaces and newlines between the braces and what is contained within them. Smarty has no whitespace allowed. So, the easiest way to add javascript to a template and not have Smarty try to interpret it is to do this: {literal}<script> javascriptcode(){commands} </script>{/literal} Tell Smarty that between its {literal}{/literal} commands, treat everything inside literally. That is the easiest but least versatile way to add javascript to a template. A more versatile way is to create a plugin which allows for custom javascript to appear on the final rendered page depending what that page is showing: viewing a product, searching, registering, checking out, successful purchase, etc.

For those of us who do not know, what is a "Facebook Pixel"? And what does it do?

"The error message is the same whether you try to access the shop front using the URL address, or try to log into the admin dashboard." Both use the same database. Looking at the attached file (using UltraEdit), line 33 is exactly as I posted above. I need to question the programmer's text editor you are using to view the file. What you say is on line 33 (" * MySQLi database controller") is line 17 in the file. Using the file you attached to the post, here is what I see: <?php /** * CubeCart v6 * ======================================== * CubeCart is a registered trade mark of CubeCart Limited * Copyright CubeCart Limited 2015. All rights reserved. * UK Private Limited Company No. 5323904 * ======================================== * Web: http://www.cubecart.com * Email: [email protected] * License: GPL-3.0 https://www.gnu.org/licenses/quick-guide-gplv3.html */ if (!defined('CC_INI_SET')) die('Access Denied'); require CC_ROOT_DIR.'/classes/db/database.class.php'; /** * MySQLi database controller * * @author Technocrat * @author Al Brookbanks * @since 5.0.0 */ class Database extends Database_Contoller { ############################################## final protected function __construct($config) { $this->_db_engine = 'MySQLi'; $dbport = (isset($config['dbport']) && !empty($config['dbport'])) ? $config['dbport'] : ini_get('mysqli.default_port'); $dbsocket = (isset($config['dbsocket']) && !empty($config['dbsocket'])) ? $config['dbsocket'] : ini_get('mysqli.default_socket'); $this->_db_connect_id = new mysqli($config['dbhost'], $config['dbusername'], $config['dbpassword'], $config['dbdatabase'], $dbport, $dbsocket); Now, if for every line there is an extra linefeed, then line 17 would change to line 33. Seeing double-spaced lines is an artifact of the editor you are using. Some editors can correct the display when having corrupted line endings, and show the code single-spaced. Now, as to the file, it seems somewhere along the way, an edit (or FTP upload with automatic line ending correction) has corrupted the line endings: 00000000h: 3C 3F 70 68 70 0D 0D 0A 2F 2A 2A 0D 0D 0A 20 2A ; <?php.../**... * Note that there is 0D which is a line ending used by Macs (pre-OSX), then 0D 0A which is a line ending used by DOS. Unix-type operating systems use just 0A for a line ending. None of this explains the difficulty connecting to the database. If this problem happened "out of the blue", then we need to blame the hosting provider and ask them what has recently changed regarding the hosted environment.

I think the Consignee is the recipient of the delivery. So, what may be happening is that for the customer's order, during checkout, and before entering the delivery address info, CubeCart is contacting UPS for a rate request -- estimated at this point. Now, the latest versions of CubeCart has two options: suppress getting shipping estimates until the delivery address is known, or use the store's physical address as the estimated delivery address. The first is at admin, Store Settings, Features tab, "Disable initial shipping & tax estimates" is checked. The second is at admin, Store Settings, General tab, "Zip Code" (or Postal Code). Make sure there is a postal code in this field. Hopefully choosing either of these options will stop the confusing error message about no shipping methods available.

Maybe in the package you are looking at, but in my package of CC6112, line 33 is: $this->_db_connect_id = new mysqli($config['dbhost'], $config['dbusername'], $config['dbpassword'], $config['dbdatabase'], $dbport, $dbsocket); Access denied means that the database server is expecting connects via 'localhost' for the user named 'scc123_sccAdmi'. The "using password: YES" bit is announcing the fact that the connect did not forget to have included a password. That is, 'yes, a password was sent". That password may be wrong, but it was included in the connection attempt. So, either the username is wrong, the password is wrong, the means to connect is wrong (that is, maybe need to use an actual web address for a database server not on the same server as the web site - as opposed to 'localhost'), or the user has not been given permission to access the named database. Compare the contents of /includes/global.inc.php with what the log on credentials are stated to be in the hosting account's control panel, MySQL Database details.

Ok, let's look in admin, Request Log. Assuming the UPS module is enabled, and you have some of their shipping methods checked, the request and response will be logged in the Request Log.

CubeCart decided to go with a PHP-included extension called ZipArchive, and dump an external library that was used in earlier versions of CubeCart. Again, this is an included extension that comes with the PHP package that gets installed onto your server. As such, one needs to edit the PHP.INI file to include and load that extension when PHP starts up. Or, your hosting account control panel may have a tool to configure PHP. That tool should list all the extensions available and a checkbox for each to have them loaded when PHP starts. You may need to get your hosting account's Customer Support involved.

If you have skills at editing HTML, you can try this hack: https://forums.cubecart.com/topic/52009-all-in-one-shipping-module-can-lose-data-a-hack/

No, not really. The text entry fields and checkboxes are not difficult to figure out what they are asking for. Please ask any specific questions you may have.