bsmither

The SFWS products are not available anymore. Without a copy, the best I can do is create a difference report, specific to what affected the GA code, for Foundation from the version that matches CC625 to the version that matches CC653, then we work on trying to apply those changes to the SFWS skin.

What skin is this?

The error notice posted above might have been from Amzin. There was found to be a syntax error in version 1.05 (that took PHP8 to reveal it). Amzin 1.06 fixed it. I do believe CBurst has been made to work with PHP8. And Basix I haven't tried recently, but I believe it should work as it has the new capability of ElasticSearch.

Many skins have been kept up to date. Obviously, not the skin being tried. Which skin is it?

A new product or an existing product. There is no setting, per se. Once CubeCart is aware that there is a Digital Option assigned, either from the file picker or a manually entered Custom File Path (including a full web address), then that product is considered a "digital product".

If the traffic chart on the dashboard does not have a comparable way to limit the results to Customers Only, then perhaps your solution is to rewrite the custom code to add more to the WHERE clause: AND `session_last` > `session_start`

I would think you would have the same problem. "I would like to weed out any sessions that I don't need to track." Where are you tracking sessions? In admin, Statistics, Users Online tab? If so, is there a link above the table to Display Customers Only? The database table CubeCart_sessions gets trimmed of records that are older than seven days.

I have no idea why 'location' is varbinary. CubeCart uses that column to store the web address used to access the site, including any querystring. Nothing in that textual string would require the table column to handle binary (that is, non-textual) data. Let's review what you actually need to accomplish. What is the nature of the content that is in the 'location' column that contains 2022?

Using CubeCart's Database class, the statement would be: Database::getInstance()->delete('CubeCart_sessions', array('location' => "~2022")); The third parameter (false) is not necessary. It defaults to an empty string. That third parameter limits how many records get deleted.

Please try: https://cubecart.zendesk.com/hc/en-gb/articles/360003831497-How-can-I-create-a-plugin-using-the-code-hooks-system

The phrase "Please enter a value less than or equal to" is from the skin's jquery.validate.js vendor plugin. It's a message related to the quantity input form element that has a max attribute, which appears only if there is in the product's details specify a "Maximum Quantity Purchase" value, and that value is greater than or equal to the min attribute's value. However, in admin, the product details screens, Pricing tab, the "Maximum Quantity Purchase" says to 'Leave blank to disable'. And the database table CubeCart_inventory has a default value of null for the 'maximum_quantity' column. However, for me, at least, my database shows that column has a zero as the value - which is what shows on the Pricing tab. Blanking that field does cause that form element to POST as a zero-length string, but still ends up in the database as a zero, not a null. So, still researching the situation.

Please provide a web address where we can see this.

Looking at the comments in the PHP documentation for imagecreatefromjpeg(), it says: That comment is from 17 years ago, and it may be referring to PHP4. In admin, at the bottom of the Navigation pane, click PHP Info. Scroll to the GD table -- if it exists. Note whether JPEG Support is enabled.

The knowledgebase article that (sparsely) covers this is: https://cubecart.zendesk.com/hc/en-gb/articles/360003794038-How-do-I-create-a-new-front-end-dynamic-section-or-page (Ignore the mention about the encoded index file.) A deeper discussion can be had here on the forums.

My browser shows a picture of the bottle placed on a plain white platform with a light grey textured backdrop.

You mention "select [specific?] orders"? Which might be only those most recent orders for that day or past 2-3 days? At most those orders made after your last data extraction? Modules written for the Sales Report page can extract data on a 'whole day' basis. If you would be interested in testing one already written, please send a PM with your email address. Then again, I see the value in having among the choices in the drop-down selector, on the admin, Orders page, the new choice of "Extract to CSV". I am going to do that -- see what it looks like.

Anything can be done. Just depends how far away one needs to get away from keeping the stock CubeCart code untouched. Then there is Sales Reports. Plugins can be written to get whatever info you need. You phrase the task as 'export the order'. Does that mean you need to provide specific details about one specific order at a time to import into some other data analysis tool?

I have no personal knowledge of this business or principal. Doing a Business Records search shows the business has existed for a number of years, and the principal is involved with several LLCs, in the arena of web development. I recall there being a third-party "store manager" for CubeCart3 (maybe it was for CC4) back in the day, possibly from a company called MagneticOne (a Ukrainian company with an office in Texas). They built an application (and variations thereof) that extracted data from a source (CRM, eCommerce, whatever) and delivered that data to a destination (some other CRM, eCommerce, whatever). MagneticOne started doing a lot of other stuff, and so split off the (desktop) Windows App section to eMagicOne (re: 'Company History of MagneticOne'). (The moderator may want to move this thread to "General Discussion.")

If your site is hosted, you probably have a control panel to manage your site. If so, there will be a file explorer. Find the folder /images/cache/. This is where CubeCart codes the HTML links for the web browser to fetch the images to display on the page. The control panel's File Explorer should allow you to View the images. If so, do the images display properly? The File Explorer should also allow you to download a WEBP image to your computer. Once downloaded, have your computer display the image - but do not use a web browser to view it. Does the image viewer show the WEBP image properly? The above test is to determine if the problem is with your web browser not being capable of displaying WEBP images. May we have a web address to view a malfunctioning image?

Please let us know the exact version of CubeCart and PHP being used.

Ok. CubeCart (as of several versions now) will show the index.php page whenever there is a file not found (404 response). You can see this at the end of the .htaccess file in CubeCart's main folder. What is probably missing is either a directive in .htaccess to load and use the mod_rewrite extension, or there is a misconfigured web server configuration statement that allows .htaccess directives to override directives in the main config file. So, verify that the .htaccess file has the following directives: ### Rewrite rules for SEO functionality ### <IfModule mod_rewrite.c> RewriteEngine On RewriteBase / Then research the Apache documentation to learn about AllowOverride All. The SEO rewrites are necessary because friendly web addresses, such as www.example.com/friendly-name-of-product does not exist and the web server will issue a 404 -- but then the 404 directive in .htaccess tells the web server to send a page anyway -- ErrorDocument 404 /index.php. The rewrite puts the friendly web address into a format that CubeCart actually uses. If there is still a problem, you may have to edit the RewriteBase statement as: RewriteBase /champcoclothingtestnew/ Otherwise, the rewrite may erroneously include the subdirectory as part of the friendly web address.

Good. Getting somewhere. According to the info in /includes/global.inc.php, review where your database is at and the username and password to access it. Let us assume that your username and password is correct. That leaves accessing the database using 'localhost' is being tried, but the database is not aware of any user having the name 'peterp' trying to access it by 'localhost'. In my experience, 'localhost' is different than '127.0.0.1', which is different than using any other IP address. (One can also use '*' to permit 'peterp' to access the database from any manner: localhost, IP address, unix sockets, whatever.) Somehow, you will need to look at the database and access the list of users it knows about for that database. Does the info in global.inc.php suggest that CubeCart is trying to communicate with the database located on the production server? If so, that database is not local to the development environment. If the target database is on the local development environment, then there must be a user created on that database named 'peterp'. What program do you use to access the database on the development environment -- assuming this is the database you are reading the records from CubeCart_system_error_log?

I thought that be the case, but the error log entry posted above says that the error occurred trying to get to ?_g=plugins. Let's see what the error_log has in it.

How is the above different than what was posted earlier? According to that error message, the Manage Extensions is what is being asked to show. This implies to me that you are logging in to admin, then clicking the Manage Extensions link in the Navigation pane. If you are not finding an "Exception" logged in CubeCart_system_error_log, look for PHP's error log. It will help to read this: https://forums.cubecart.com/topic/51550-how-to-create-the-error-log/

If that is the case, that config setting is stored in the database table CubeCart_config, the row named 'config'. You might be able to override this by adding the following to /includes/global.inc.php: $glob['ssl'] = 0;