Jump to content

2n3055

Member
  • Posts

    25
  • Joined

  • Last visited

Posts posted by 2n3055

  1. My ISP is in the process of changing servers (and IP address), what do I need to know, and what do I need to do, in order to get the store up and running on the new equipment ASAP.

    I figure I'll have access to cPanel (but probably not CubeCart Admin back end right away). I think I may have to reset the SQL user and password on the server.

    What about licensing - do I have to advise Cubecart of this new server, is the license tied to the old server ?

    Last backup was done a few days ago, I have all files here locally, butu this move was totally unexpected.

  2. Had this exact problem this morning and reported it as an urgent bug.

    Problem was quickly solved by the CC staff, it affects stores that are using a table prefix.

    I understand they have repackaged the 510 patch, (build 2250) with this correction.

    My store works well now, all is well, actually much better than 508.

  3. Try copying the attached cptest.php file to your web server and running it - it tests the connection from your web server to Canada Post and reports if successful or not.

    If it is not successful talk to your ISP, they may be blocking ports.

    Also, in your SellOnline control panel at http://sellonline.canadapost.ca/servlet/LogonServlet?Language=0, don't forget to set the module to "Live".

    cptest.php

  4. After upgrading from 439 to 440 the search function from the store's home page returns the following error:

    MySQL Error Occurred

    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 '*) as `count`, MATCH (I.description,I.name,I.productCode) AGAINST('+(count(*) as' at line 1

    SQL:

    SELECT DISTINCT(I.productId), I.count(*) as `count`, MATCH (I.description,I.name,I.productCode) AGAINST('+(count(*) as `count`2006count(*) as `count`)' IN BOOLEAN MODE) AS SearchScore FROM apollo_CubeCart_inventory AS I, apollo_CubeCart_category AS C WHERE (MATCH (I.description,I.name,I.productCode) AGAINST('+(count(*) as `count`2006count(*) as `count`)' IN BOOLEAN MODE)) >= 0.500000 AND C.cat_id > 0 AND C.cat_id = I.cat_id AND C.hide = '0' AND (C.cat_desc != '##HIDDEN##' OR C.cat_desc IS NULL) AND I.disabled = '0' ORDER BY SearchScore DESC

    Anyone else having this problem or knows a cure?

    Thanks,

    Paul

  5. I have a CC store in version 4.3.4

    I have tow language configured

    When I try to search some word in secondary language the system reply:

    (Sorry, no products match the query...)

    Even the words that are in the product name!

    anyone can help me?

    regards.

    We have both English and French language descriptions in our store. The search only finds search strings in the English descriptions. The workaround we found is to include the French description inside the English one, but using 1 pt size and white on white.

×
×
  • Create New...