ravuth

for my store uses 3party mod , you could check out at my store justyouandyou (dot)com

hi, if you got that error when your store is offline, i suggest you should read this , it's already solved http://forums.cubecart.com/topic/46005-resolved-offline-page-not-displaying/page__hl__%2Bsite+%2Boffline__fromsearch__1

thanks Dirty Butter,

Thanks bsmither ,

@DirtyButter, thanks for your assist, probably because of backup/restore database sql at admin/maintenance , before i run your sql statement i back up using admin/maintenance , after run your sql statment, then i accidentally click on the restore of admin/maintenance , then all images of product don't show.. after submit with cubecart support , they only suggest to contact with host provider to website restore .. then, i submit ticket with my host provider, and they said they are unable to restore my site because my site space is larger than 4G which is the limited space which able to restore.. now, i do manually one by one again to upload the images.. like product code: WX516170LN i think probably there is issue with backup/restore at admin/maintenain of cubecart v5.1.1 that cause this issue.. now i can say this solved ,

@DirtyButter , after run that UPDATE prefix_CubeCart_filemanager SET `filepath` = N WHERE `filepath` = ' surly that now the file manager>image is work.. , but all my products images are unfound.. you could go to visit my store.. www.JustYouAndYou.com , is any to call it back ?

hmm... killing me now.. after run that, and error uable to run sql restore.. now my website is with no images.. www.justyouandyou.com , i submit ticket to cubecart right now.., anyway thanks

after run this sql UPDATE CubeCart_filemanager SET `filepath` = N WHERE `filepath` = ''; got the reply 0 rows affected and it sitll offer blank page file manager->image , any idea

my store use v5.1.1 each time try to access file manager->image , got the blank page ?

@Dirtybutter, surly here is the solution from cubecart support Code change required. OPEN classes/catalogue.class.php FIND $order['name'] = 'ASC'; REPLACE WITH $order['product_id'] = 'DESC'; Do it twice as two lines to find there. Thanks

dear bsmither, i submit ticket to cubecart supporter. and now it works. thanks you for your help .

dear Bsmither i try to clear all caches, and it still dont work . please let me know

for me , i think the mobile skin is not yet work better. for my store i already disable that mobile skin .

@bsmither , i try it . unfortunately, it not work.. you have any other idea ? i do appreciate that you so often offer good advice.

if you use cubecart v5.1.0 , there is no disable mobile skin options. my store use cubecart v5.1.1 and i select disable mobile skin . i don't like that mobile skin.. my customer complain much about that mobile skin . so i decide to disable that mobile skin.

my store use cubecart v5.1.1 , and my store products are update daily , is any possible way to show products sort by date added (the newest first ) by default ? is any one know how to customize that ?

@bsmither , Thanks you . that error was happened again yesterday. Then i do as your advice by ask to my host provider . and got the following reply . This was due to the temporary table not getting created correctly in the /tmp partition. /tmp got full and caused the problem. Please try it once more? We have free'd up plenty of space in the partition. It is currently at 4% usage. so, if that happen again, i will email to my host provider to fix that. that sould be solved Thanks All

let me share: *how to create 3 different sizes options ? Login your admin page->click product options 1>Add new group >Group Name: Size >Description: >Group Type: Dropdown list >Required: yes save , then you will have one new group "Size" 2>Step 2 is add option attributes , if that group has 3 size you just add 3 attributes >S >M >L Save , Done , and about 6 different colors , you just do that 2 steps again with group name "Color" , and 6 Attributes: let me know if you understand with my poor explaination

good, i need that options too

my store upgrade automatically (just one click) from v5.1.0 to v5.1.1 is ok.. found no problems.

bsmither @bsmither , thanks you . i have submitted ticket to my host provider and ask the same question of yours. and got reply as below **** I understand that you are receiving an error when you try to install the cubecart script. It appears that the directory, /var/mysqltmp/, which the script was attempting to write to was full. This problem has been corrected on the server and you should be able to write to the directory once more. I apologize about the inconvenience this caused. This directory is no longer full and you should be able to write to it. If you are still having problems installing this script let us know. *** it seems that the problem is solved now.. Thanks all

@bsmither could you advice me the question to ask my hosting provider ?

just update from cubecart v5.1.0 to v5.1.1 , and now got this error , just don't know what happen, File: [filemanager.class.php] Line: [552] "SELECT * FROM `CubeCart_filemanager` WHERE `disabled` = 0 AND `type` = 1 AND `filepath` IS NULL ORDER BY `filename` ASC ;" - Error writing file '/var/mysqltmp/MYKt1bvP' (Errcode: 28) regard,

@ Dirty Butter my store upgrade from v5.0.7 to v.5.1.0 , frankly, i don't know how does it come with that error log ? @ bsmither , thanks your instruction, i have did as your guidance, and still get that eror, please see below ***************** File: [gui.class.php] Line: [869] "SELECT * FROM `CubeCart_inventory` ORDER BY RAND() LIMIT 1;" - Incorrect key file for table '/var/mysqltmp/#sql_4a89_8.MYI'; try to repair it File: [gui.class.php] Line: [869] "SELECT * FROM `CubeCart_inventory` WHERE CubeCart_inventory.status = '1' ORDER BY RAND() LIMIT 1;" - Incorrect key file for table '/var/mysqltmp/#sql_4a89_0.MYI'; try to repair it ************

got this error log : ******** File: [gui.class.php] Line: [869] "SELECT * FROM `CubeCart_inventory` WHERE CubeCart_inventory.status = '1' ORDER BY RAND() LIMIT 1;" - Incorrect key file for table '/var/mysqltmp/#sql_4a89_5.MYI'; try to repair it ****** don't know what does it mean ?