convict
-
Posts
1,302 -
Joined
-
Last visited
-
Days Won
1
Posts posted by convict
-
-
Cubecartforums.org is the right place to post your request.
-
Try to copy your current database to a new one on the same server current one resides. Do use myPHPadmin. It should help you. Then do upgrade on the DB copy you created DO NOT perform any action on live database!I was to scared..sorry...making a new shop behind the scenes just to be certain that my old shop can continue without errors. I tried to make a backup but because of the big database it stopped very time...so just to be sure I'm taking the 'difficult' way.. -
How do you know this?That's the problem - I'm getting the success variable but CubeCart isn't changing the order status. -
Quick description, client order an item 3.1. and got the order ID 080103-112145-4968 and subsequently on 4.1. ordered another item which again used the same id and generated confirmation emails but now in the database there is only one order and it only shows the second item.
This happens if user's basket is not empty - it keeps the previous content order id included. Version 4 has just another checkout logic to prevent such issue.
If customer's basket is not emptied properly such issue will occurs allways once customer returns 'in time'.
If you would like to unset session as you mentioned it doesn't help you when customer doesn't log off which is the main matter in this case. You should force script to empty customer's basket. May be best when php session is gone OR browser is closed. Right not explicit decision.
-
MySQL server name is incorrect.
You have to use domain name (localhost mostly) or IP address instead of "ACD-Tuning".
-
FYI CubeCart 4 upgrade feature upgrades from ANY CubeCart 3.0.x release!
Upgrade to the latest version 3 release [3.0.17] is NOT REQUIRED.
-
And then doing that receives a message which says, "There are no products in this category."
You should apply the code replacement first I posted above :P
-
Weird, but it's happening again.
here's the link: http://www.everythingpound.com
it's forwarding to the homepage again!
Please correct the link first, current one is to CC3 related.
-
1) Yes it could be
2) Yes it is hh/mm/ss
3) This is a random number
There is a function in a order class which generates order no.:
classes/cart/order.php
function mkOrderNo() { $this->cart_order_id = date("ymd-His-").rand(1000, 9999); return $this->cart_order_id; }
Your requirement:
$this->cart_order_id = date("mdy-His-").rand(1000, 9999);
I dont suggest you to change it to local time if you use DST (Daylight Saving Time)
-
Accidently deleted orphaned thumbnails. Now all my thumbs are gone. Is there a way to retrieve them without deleting and uploading the image again?
Please do use admin Maintenance > Thumbnails to rebuild your thumbnails.
-
Yes, please do use FTP client OR your site control panel File Manager.Is there a way I can delete a folder I created for images? -
You solved it alone becasue you switch SEO to OFF then to ON - you empty the cache the bad link was to SEO related you already upgraded. :w00t:
-
This was in helpdesk solved - products index.inc.php has not been upgraded.Hi,I'm having a very unusual problem I can't seem to figure out. When ever I update the price of any of my products they disappear out of the shopping cart. When I click on the category they belong in on the left hand side they don't show up. But when I type the name of the product in the search field they come up in the search and they are listed under the right category.
The only way I have found to fix this problem is going to the admin screen and changing the current category they are currently listed under and then change it back to the correct one.
please help.
-
Is it possible to reset the Product Sales Statistics?
No way yet sorry.
-
The answer is very simple - you use (old) MySQL version < 4.1. Try to run the compatibilite test (compat-test.php) to see the result.I just imported all of my categories and products and when I run the Rebuild category product count I get the following:MySQL Error Occured
Error Message:
1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT DISTINCT cat_id FROM cubecart_CubeCart_cats_idx WHERE 1)
SQL:
SELECT COUNT(cat_id) as count, cat_id FROM cubecart_CubeCart_cats_idx WHERE cat_id IN(SELECT DISTINCT cat_id FROM cubecart_CubeCart_cats_idx WHERE 1) GROUP BY cat_id
Anyone have any ideas?
Thanx.
-
Products already related by purchase. If you would like to relate it manually custom code is required.Wondering if "Customers who bought also bought…" is something I can adjust.I'm trying to relate one product with another.
Any help is greatly appreciated.
Thanks.
-
That definitely worked, but it did remove the options to view categories individually. I thought I could mess with the code somehow, but I don't know enough PHP to do that.
So, still searching for a solution to have the option to view All Products on one page, yet still be able to view individual categories too.
I'll keep searching, but thanks anyway convict! you really know your stuff!
Well there is next quick hack to leave the option to see appropriate category prods:
$productListQuery = sprintf("SELECT C.cat_id, C.productId, I.productCode, I.quantity, I.description, I.image, I.price, I.name, I.popularity, I.sale_price, I.stock_level, I.useStockLevel FROM %1\$sCubeCart_cats_idx AS C INNER JOIN %1\$sCubeCart_inventory AS I ON C.productId = I.productId WHERE I.disabled = '0' AND C.cat_id = %2\$s GROUP BY I.productId %3\$s", $glob['dbprefix'], $db->mySQLSafe($_GET['catId']), $orderSort);
REPLACE WITH
if (isset($_GET['catId']) && is_numeric($_GET['catId'])) $productListQuery = sprintf("SELECT C.cat_id, C.productId, I.productCode, I.quantity, I.description, I.image, I.price, I.name, I.popularity, I.sale_price, I.stock_level, I.useStockLevel FROM %1\$sCubeCart_cats_idx AS C INNER JOIN %1\$sCubeCart_inventory AS I ON C.productId = I.productId WHERE I.disabled = '0' AND C.cat_id = %2\$s GROUP BY I.productId %3\$s", $glob['dbprefix'], $db->mySQLSafe($_GET['catId']), $orderSort); else $productListQuery = sprintf("SELECT * FROM %1\$sCubeCart_inventory %2\$s", $glob['dbprefix'], $orderSort);
Well if you want to see all prods just use link http://your.store.tld/index.php?_a=viewCat :w00t:
-
In 4.1, is there a way to move the Google Chekout button to the same page PayPal is on?
Google Chekout is an alernate checkout, Website PayPal PRO too thus the same page shown. Website PayPal PRO has two additional 'standard' gateways and the PayPal IPN is the standard gateway too. Standard gateways are on the STEP3 page shown.
-
Temporary tables AND/OR php loop.You can't use nested SQL query because of old MySQL version.
OK ... So what would be the old way of doing it without nesting them?
Anyone?
Thanks
-
You can't use nested SQL query because of old MySQL version.
-
Version 4 has as the same TAX feature as the version 3 in taxes + additional ones. The TAX setting label in general settings is changed to "Add sales tax to customers who qualify?" version 3 has "Include tax in prices?"
Since 4.1RCx you can set on admin product details page "Prices include Tax". This is to checkout page related
and works if "Add sales tax to customers who qualify?" is set to YES.
Feel free to request the feature like on kronium.cz in bug tracker.
-
Yest that is correctThe email with the download link isn't sent out until the order status is 'Complete and Dispatched'.Is there a setting somewhere that controls when the download link is emailed out?Yes but manually:
classes/cart/order.php
move this
// if order is completely digital send digital file and keep status as complete
$this->digitalAccess();
after
$mail->send(array($this->orderSum['email']), $config['mailMethod']);
in case 2 section - this sends the download links once order status changes to Processing. Never tried but should work
Have to tried first may be a optionable things in admin area probably.
-
What is the mySQL version?Can someone out there help adjust the SQL that is being called to accomplish the same thing ...Original:
SELECT COUNT(cat_id) as count, cat_id FROM st1_CubeCart_cats_idx WHERE cat_id IN(SELECT distinct cat_id FROM st1_CubeCart_cats_idx WHERE 1)GROUP BY cat_id
Manually running in phpmyadmin ...
SELECT COUNT(cat_id) as count, cat_id FROM st1_CubeCart_cats_idx GROUP BY cat_id ...works fine.
Manually running in phpmyadmin ...
SELECT distinct cat_id FROM st1_CubeCart_cats_idx WHERE 1 ... works fine .
But manually running them in phpmyadmin with the "IN" causes the error ...
1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT DISTINCT cat_id FROM st1_CubeCart_cats_idx WHERE 1) GROU
Checking the manual does me no good - can a sql person reply with a quick fix.
Thanks!
-
You can add flash to the description area without any modification your request required. That means custom mod is required to replace image code with flash realted one.
Email.inc.php Nightmare
in Technical Help
Posted
For anyone having such issue using 4.1.0, 4.1.1 please do this fix
open YOUR-ADMIN-FOLDER/sources/filemanager/language.inc.php
SEARCH FOR