Jump to content

cb2004

Member
 View Profile  See their activity

  • Posts

    267

  • Joined

  • Last visited

 Content Type 

Posts posted by cb2004

    Another install error

    in Technical Help

    Posted

    Any information you want you can have mate. FTP details or anything.

    I am trying to upload a changed global file and everytime i try and upload I get a critical transfer error (FileZilla). Could this file be messed up in the distribution?

    [edit]I deleted the file and re-uploaded it and its fine with the change to ioncube. I have not uploaded a loader either[/edit]

    Another install error

    in Technical Help

    Posted

    Reported this in the bugs but if anyone misses it:

    Fatal error: Corrupted encoded data detected in /home/sites/majesticit.co.uk/public_html/store/index_enc_zend.php on line 0

    Any ideas?

    Also an install category in the bug tracker would be a good idea.

    Products in columns (dyncamic li)

    in Customising Look & Feel

    Posted

    I didnt know there was a skin forum on here. Excellent.

    I want my products in columns dyncamically but am not sure on the best way to go about it. I am using a list in the example:

    Example

    As you can see things are getting pushed out of place. Is there a better way of doing this? Floating divs maybe?

    It makes it more difficult as cubecart just repeats 1 line of code for the products.

    [edit]Excuse the title. I meant dynamic[/edit]

    Product Options, MySQL Error Occured, 1104:

    in Technical Help

    Posted

    Around line 278 on /admin/products/options.php

    Find this:

    get slave products

$slaveProducts = $db->select("SELECT DISTINCT productId, name FROM ".$glob['dbprefix']."CubeCart_options_bot RIGHT JOIN ".$glob['dbprefix']."CubeCart_inventory ON product = productId ORDER BY name ASC");
    





    Add this line before $slaveProducts:

$bigselects = $db->misc("SET sql_big_selects=1");
    



So it looks like this:





    get slave products

$bigselects = $db->misc("SET sql_big_selects=1");

$slaveProducts = $db->select("SELECT DISTINCT productId, name FROM ".$glob['dbprefix']."CubeCart_options_bot RIGHT JOIN ".$glob['dbprefix']."CubeCart_inventory ON product = productId ORDER BY name ASC");

    Should this be added to the release?

    Product Options, MySQL Error Occured, 1104:

    in Technical Help

    Posted

    One of my customers gets this error when trying to enter product options:

    Product Options

    MySQL Error Occured

    1104: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

    QUERY = SELECT DISTINCT productId, name FROM cartcube_CubeCart_options_bot RIGHT JOIN cartcube_CubeCart_inventory ON product = productId ORDER BY name ASC

    Any ideas?

×
×
  • Create New...