[[Resolved] Search not working on the web site]

Thanks very much bsmither

 

Took me a while to get there but found where to edit it and all is working now

Tracy

[[Resolved] Search not working on the web site]

I managed to find the command to run this and this it what is shows?  Is there anything else I can do.  I do have meta keywords so have been wondering if I should switch it to use this?

 

[[Resolved] Search not working on the web site]

Hi Bsmither,

Sorry for the delay I have been away.  I have checked the database and I do not have a column called fulltextsearch in the cubecart inventory table at all?

What can I do to get one instated?

As previously mentioned I upgraded from 3 to version 6 and I had previously had a quite a few mods on the v3 version and was using sir williams BPM for a few years to update the inventory.

Thanks

Tracy

[[Resolved] Search not working on the web site]

Thanks Bsmither

No I dont get any warning in cubecart admin however I did upgrade from cubecart 3 to 6.  Is there anything I can run then to get this upto date as quite a few people are trying search can see it in google analytics but we are not serving any products.  It is working on the odd keyword for example A4 brings up results but not a lot is showing any product results just no products found.

Thanks very much

[[Resolved] Search not working on the web site]

Hi Everyone,

Thank you for all your help on this.  I have updated the cubecart now to 6.0.11 so it is all upto date.

I have setup the debug mode and done a search on silver snap.  I am getting this error at the beginning

 

[Notice] /homepages/13/d231984446/htdocs/cheapsnap/classes/cubecart.class.php:772 - Undefined index: search[Warning] /homepages/13/d231984446/htdocs/cheapsnap/classes/catalogue.class.php:204 - Invalid argument supplied for foreach()[Notice] /homepages/13/d231984446/htdocs/cheapsnap/classes/catalogue.class.php:212 - Undefined index: products

 

Also this is showing up on the sql around the search term?

[41] INSERT INTO `CubeCart_system_error_log` (`message`,`time`) VALUES ('File: [catalogue.class.php] Line: [1592] \"SELECT I.*, MATCH () AGAINST(\'silver snap\' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (MATCH () AGAINST(\'silver snap\' IN BOOLEAN MODE)) >= 0.5 ORDER BY Relevance DESC LIMIT 36 OFFSET 0 \" - 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 \') AGAINST(\'silver snap\' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS\' at line 1','1464729704'); -- (0.0010490417480469 sec) [ERROR - NOT CACHED]
[42] INSERT INTO `CubeCart_system_error_log` (`message`,`time`) VALUES ('File: [catalogue.class.php] Line: [1592] \"SELECT I.*, MATCH () AGAINST(\'silver snap\' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (MATCH () AGAINST(\'silver snap\' IN BOOLEAN MODE)) >= 0.5 ORDER BY Relevance DESC LIMIT 36 OFFSET 0 \" - 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 \') AGAINST(\'silver snap\' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS\' at line 1','1464729704'); -- (0.0010490417480469 sec) [ERROR - CACHE WRITE]
[43] INSERT INTO `CubeCart_system_error_log` (`message`,`time`) VALUES ('File: [catalogue.class.php] Line: [1594] \"SELECT COUNT(I.product_id) as count, MATCH () AGAINST(\'silver snap\' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (MATCH () AGAINST(\'silver snap\' IN BOOLEAN MODE)) >= 0.5 GROUP BY I.product_id ORDER BY Relevance DESC \" - 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 \') AGAINST(\'silver snap\' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS\' at line 1','1464729704'); -- (0.00078511238098145 sec) [ERROR - NOT CACHED]
[44] INSERT INTO `CubeCart_system_error_log` (`message`,`time`) VALUES ('File: [catalogue.class.php] Line: [1594] \"SELECT COUNT(I.product_id) as count, MATCH () AGAINST(\'silver snap\' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (MATCH () AGAINST(\'silver snap\' IN BOOLEAN MODE)) >= 0.5 GROUP BY I.product_id ORDER BY Relevance DESC \" - 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 \') AGAINST(\'silver snap\' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS\' at line 1','1464729704'); -- (0.00078511238098145 sec) [ERROR - CACHE WRITE]

Does anyone have any advice on what might be wrong?

Thanks

Tracy

[[Resolved] Search not working on the web site]

I am on version 6.0.8 I have made some small modifications.  I will take a look at firebug this is all new to me.

 

Thanks

Tracy

[[Resolved] Search not working on the web site]

I am not sure if I have removed something in error but if you do any search on the web site www.cheapsnapframes.co.uk it comes up with no products found.  It should show results for snap frames at the very least.

Could I have done something in error?

Thanks in advance

Tracy

[Creating redirects in 6.0.8 from an old upgrade]

I have upgraded my site now to v6.0.8 from cubecart 3.

I had a bought seo plugin on cubecart 3 which used i think ultimate urls for seo.

I now have lost these urls on the upgrade so my urls are different and I need to redirect my old pages indexed in google to my new ones but it is not working.

For example i have this page indexed on google:

Cheap Poster Frames | Black Snap Frames A0 A1 A2 A3 A4

www.cheapsnapframes.co.uk/cheap-poster-frames-black.html

... 25mm and 32mm widths, square corners, (RAL 9005) cheap prices UK Deli

In the .htaccess I have done this

<IfModule mod_rewrite.c>
  RewriteEngine On
  RewriteBase /
 
 RewriteRule ^/cheap-poster-frames-black.html$ http://www.cheapsnapframes.co.uk/black-snap-frames.html[L,R=301]

Now when i click on this link in google I get a 404 error and it shows?

http://www.cheapsnapframes.co.uk/black-snap-frames.html?seo_path=cheap-poster-frames-black

Can anyone advise me what I need to do?

Many thanks

Tracy

[Secondary images not showing after upgrading]

Bsmither

Thanks for your help and advice.

Tracy

[Secondary images not showing after upgrading]

Have just checked this thank you very much for the advice.

This is my cubecart 3 img_idx table for the same product which is showing multiple images:

 

This is the same product on the images_index table on cubecart 6

 

 

So it seems to have created a new id for the main image when it did the upgrade but the other id records have lost their image names/id's

Is there anything I can run again to get this back?  Or can I use the product import to update my inventory with the secondary images?

Thanks

Tracy

[Secondary images not showing after upgrading]

Thank you very much.  I will go and check this out.  One thing I am confused on us can you update existing products on csv import or is it purely for adding new products?

will let you know how I get on.

Thanks again.

Tracy

[Secondary images not showing after upgrading]

This has been a while for me so please be gentle.  I have upgraded a site from cubecart 3 to 6.  I have built the cubecart 6 version here www.cheaplightboxes.co.uk but it will replace the v3 site www.cheapsnapframes.co.uk.

All seems good however we had multiple images assigned to products on the old site but only the main image is showing up on version 6.  We have been using bpm to manage the inventory on version 3 site would this be the reason?

Thanks

Tracy 

 

 

i

 

 

 

 

[VAT Exemption by Customer (Mobility products)]

Steve

Not sure if you worked around this but we had this site that sell mobiity products built in cubecart 4 http://www.brobyliving.co.uk and << Commercial member from CubeCartForums.org >> who do cubecart mods did the vat exemption piece for us.

Tracy

[Can't Access Admin Area]

I have also just done this and have the same problem - any suggestions would be much appreciated. I have configured my shop to paypal express and just added the ssl info provided by my hosting company heart and now I have errors on my shop page and cannot access the admin panel.

thanks

Tracy