Jump to content

convict

Member
  • Posts

    1,302
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by convict

  1. I believe this is covered in the bug tracker and has been dealt with for 4.1.2
    Yes it is already covered.

    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

    		#	$saved[$def][$key] = htmlspecialchars(stripslashes($value), ENT_COMPAT, 'UTF-8');
    
    		#	$saved[$def][$key] = stripslashes($value);
    
    			$saved[$def][$key] = nl2br(html_entity_decode(stripslashes($value)));
    
    
    
    
    REPLACE WITH
    
    			$string = html_entity_decode(stripslashes($value));
    
    			if (!strstr($_POST['identifier'], 'email.inc.php')) {
    
    				$string = nl2br($string);
    
    			}
    
    			$saved[$def][$key] = $string;

  2. 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.. :whistle:
    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!
  3. 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.

  4. 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)

  5. 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.

    This was in helpdesk solved - products index.inc.php has not been upgraded.
  6. 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.

    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.
  7. 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!

    :D

    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:

  8. 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.

  9. 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.

  10. The email with the download link isn't sent out until the order status is 'Complete and Dispatched'.
    Yest that is correct :)

    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.

  11. 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!

    What is the mySQL version?
×
×
  • Create New...