ayz1
-
Posts
452 -
Joined
-
Last visited
-
Days Won
12
Posts posted by ayz1
-
-
if it was working before you updated and wasnt after then logic would say it îs the update that caused it. Have you tried it on a different browser? Have you tried clearing the cache in cubecart admin?
-
When you upgraded it may have overwritten the changes you made on the previous vrsion. Take a look at you main.php file and see if the mailchimp code you added earlier is there if not add it again.
-
Not 100% sure but that looks like a database issue where the database or user doesn't exist.
If you use cPanel and you have installed Cubecart using Installatron you can create a backup of your store on the same server using it's back up feature if you just want a backup. If you wish to move or copy your store to another server then the following should work
There is probably a much easier way to do this but this is how I do it.
- Install a fresh version of Cubecart (same version as you are backing up) onto the new server.
- Copy database from old Cubecart to new Cubecart
- Upload images from old Cubecart to new Cubecart
- Copy over your skin if modified
Hope this helps.
-
V6 I would assume is or will be made compatible with any changes required. As far as V3 is concerned then I would contact PayPay and they will be able to confirm what changes need to be made but if not using SSL then would guess all will be fine.
-
Maybe look at a forced update in admin.
-
If you have made any changes to the original .htaccess file you could try renamimg it before you do the update then restore it once update is done if that solves the problem. If it doesn't help then try the manual update. Had same problem myself with some working and some not.
-
There is already an extension that may do what you require https://www.cubecart.com/extensions/plugins/pre-order-goods-plugin
-
To remove the category images in file skins/foundation/templates/content.category.php add comments <!-- and --> to the following
<!-- {if isset($category.image)}
<div class="row">
<div class="small-12 columns"><img src="{$category.image}" alt="{$category.cat_name}" class="marg-bottom"></div>
</div>
{/if} -->To remove sub category images
<!-- {if isset($SUBCATS) && $SUBCATS}
<ul class="medium-block-grid-6 text-center{if $CONFIG.catalogue_expand_tree ==1} show-for-medium-up{else} small-block-grid-3{/if}" data-equalizer>
{foreach from=$SUBCATS item=subcat}
<li data-equalizer-watch>
<a href="{$subcat.url}" title="{$subcat.cat_name}">
<img class="th" src="{$subcat.cat_image}" alt="{$subcat.cat_name}">
</a>
<a href="{$subcat.url}" title="{$subcat.cat_name}"><small>{$subcat.cat_name}</small></a>
</li>
{/foreach}
</ul>
{/if} --> -
Checked it out on a mobile phone in portrait view and the menu and basket links don't appear to be working (you just get a blank space). The links at the top of the page are not aligned very well so difficult to use and there is a black bar in there (some sort of menu divider) which is positioned over the basket link. Also the search box is not showing fully, seems to be offset to the left so positioned off the screen slightly. The search on the standard foundation skins seems to work better. Similar issues in landscape view. As it is I don’t think anyone would be able to register or make a purchase.
-
Really not looking forward to manually editing the CSV/Excel file based on orders to remove dupes with sort by customer name column.
In Excel on the Data tab there is a remove duplicates feature. I use it a lot. Would that help?
-
I've tried it on on V6 and just looked at your store and you are on V5 so maybe that's why. Or are you on V6 with an old skin? I can email you the file if you wish.
-
Change the function argument list from $search_mode = 'fulltext' to $search_mode = 'like'.
Where bsmither said to make the main code change you should have this (replace what is already there)
$rlike = ' AND ( ';
for ($i=0; $i<$noKeys; ++$i) {
$ucSearchTerm = strtoupper($searchArray[$i]);
if ( ($ucSearchTerm != 'AND') && ($ucSearchTerm != 'OR') && (strlen($ucSearchTerm) > 0) ) {
$searchArray[$i] = str_replace(array('%','_'), array('%','_'), $searchArray[$i]);
$regexp = '%'.$searchArray[$i].'%';
} else { $rlike .= " ".$ucSearchTerm." "; continue; }
$rlike .= "(I.name LIKE '".$regexp."' OR I.description LIKE '".$regexp."' OR I.product_code LIKE '".$regexp."') AND ";
}
$rlike = substr($rlike, 0, strlen($rlike)-5); $rlike .= " )";}
between the lines
$noKeys = count($searchArray);
$regexp = '';AND
$q2 = "SELECT I.* FROM ".$GLOBALS['config']->get('config', 'dbprefix')."CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price
-
I like this one:
$rlike = ' AND ( '; for ($i=0; $i<$noKeys; ++$i) { $ucSearchTerm = strtoupper($searchArray[$i]); if ( ($ucSearchTerm != 'AND') && ($ucSearchTerm != 'OR') && (strlen($ucSearchTerm) > 0) ) { $searchArray[$i] = str_replace(array('%','_'), array('%','_'), $searchArray[$i]); $regexp = '%'.$searchArray[$i].'%'; $rlike .= "(I.name LIKE '".$regexp."' OR I.description LIKE '".$regexp."' OR I.product_code LIKE '".$regexp."')"; } else { if(strlen($ucSearchTerm) > 0){ $rlike .= " ".$ucSearchTerm." "; } else { $rlike .= " AND "; } continue; } } $rlike .= " )";Tried this again and it worked. Seems to do exactly what is required. Thanks bsmither.
-
It's beyond me unfortunatley. However if it's possible in V3 then I assume it's possible on V6. Tought the link might give someone a clue how to do it. Tried the code from bsmither above but couldn't get it to work. Probably something I am doing wrong rather than a problem with the code. Will have another go at it.
-
Yes it is possible because I have it working on one of my websites. Unfortunately I can't remember how I did it but I will try and work it out and let you know.
Did this on a v3 store and it works for part word and multiple word.
http://cubecart.expandingbrain.com/free-cubecart-3-mods/simple-search-improvement-cc3/prod_160.html
Haven't tried it on a v6 store but assume it is possible.
-
You could upload your video to youtube and use their embed feature to include it in your webpage or you could hard code it yourself. An example of the code needed can be found at http://www.webmonkey.com/2010/05/embed-videos-in-your-web-pages-using-html5/
If you need to convert your video to the correct format you can do that at http://www.online-convert.com/
-
If only one extra status is required e.g. "Part Shipped" maybe an extra field in the order_summary table might be useful along with a tick box in admin to indicate if part shipped?
-
You can send 12,000 emails a month to a list of up to 2,000 subscribers with MailChimp's Forever Free plan then there is a monthy fee for anything over that. Beauty of Mailchimp is they handle all the sending of the emails and they are sent very quickly and you are not using your own server resources. If you have a lot of emails to send using a throttled system it can take a long time to send the whole batch because the server will have a limit on the number of emails you can send per hour. So if your email is time sensetive then it might not be the best solution.
I've tried both methods and in my opinion Mailchimp is by far the best system. It also handles subscribing and unsubscribing automatically to keep your list up to date and has many other useful features as well.
-
It is possible to integrate mailchimp with cubecart. Instructions are at http://kb.mailchimp.com/lists/signup-forms/add-a-signup-form-to-your-website
-
-
If you ftp the images into a fresh install of v3 then do the v6 upgrade as I mentioned above then the images will show up. If you ftp them after they don't show. Some info here https://support.cubecart.com/Knowledgebase/Article/View/218/43/notes-about-upgrading-cubecart-and-resource-limits
-
Im in the process of looking at doing the same thing. From what I understand the V3 and V6 databases are different so it's maybe not advisable to copy your V3 tables to the V6 database.
This is what I have done to test what happens. I installed the version of V3 I am using onto another server 3.17 im my case. I then copied the tables from my original V3 store into the new V3 copy and uploaded the images folder.
I then followed the upgrade instructions here https://support.cubecart.com/Knowledgebase/Article/View/231/43/how-do-i-upgrade-from-cubecart-v3-to-v6
All seems to have worked OK but there are issues that need addressing such as installing Payment Gateways, Shipping Module, new skin etc. Then there are issues with URL's changing, Categories etc. So although the V3 to V6 upgrade works there are a lot of other things to consider.
Hope this helps.
-
If you use cPanel and installatron you should be able to clone your store then follow the instructions at https://support.cubecart.com/Knowledgebase/Article/View/231/43/how-do-i-upgrade-from-cubecart-v3-to-v6 to update it to V6
Thought that is what I said in more detail in my last post !
If the original copy of Cubecart was installed with Installatron then using the Clone feature in my opinion is much simpler than the detailed method you described especially if someone is not familiar with using databases as it sets everything up automatically. http://installatron.com/docs/websiteowner#clone
-
If you use cPanel and installatron you should be able to clone your store then follow the instructions at https://support.cubecart.com/Knowledgebase/Article/View/231/43/how-do-i-upgrade-from-cubecart-v3-to-v6 to update it to V6
Sale Item Product Sorting not working
in General Discussion
Posted
When the page is first loaded the sort doesn't work? If you go to view all then the sort does work. Is this what you mean?