Search Helpnote Topics

VP-ASP 7.01 Fixes

VP-ASP 7.01 Fixes

VP-ASPThis page will list all known bugs a fix after applying V7 Update Pac. Please refer back to this page if you have any issues before posting in the helpdesk.

Please make backups of your files before applying any of the following updates.

Many of the following fixes are most likely aleady installed in your package. Please check the date of your version in shop$version.asp and compare against the fixes date below.

Dates earlier than your version will have fixes up to date applied and can be ignored..

Issue # Date Issue Finename Resolved
1. 04/10/2010 Appostrophe character not dispplaying correctly. shop$db.asp Yes
2. 04/10/2010 Default shipping method is not working with xajaxshipping shopajaxshippingzipcodecountry.asp Yes
3. 06/10/2010 Logo / Image not displaying if not enter label via layout manager shoplayoutmgrlogo.asp Yes
4. 06/10/2010 Layout Manager: duplicated welcomeboxsquare / welcomestretch / logo to 1 store if xproductmatch = Yes admin/shopa_layoutmgrlogosub.asp, admin/shopa_layoutmgrwelcomeboxsquaresub.asp, admin/shopa_layoutmgrwelcomestretchsub.asp Yes
5. 06/10/2010 SEO not generate link to sub-products admin/shopa_generateseodynamicsubs.asp Yes
6. 06/10/2010 Latest product return wrong result at homepage if random mode is on shopnewproductsub.asp Yes
7. 06/10/2010 To exlude sub-products from crosse-selling, also bought shopalsobought.asp, shopprocat.asp, shopcrosssellingsubs.asp Yes
8. 08/10/2010 Bug Fix: Bundle product is not displaying if xstocklow is set admin\js\producttype.js, shopaddtocart.asp Yes
9. 08/10/2010 Some products not able to display short description at product description page if using sqlserver shopexd.asp Yes
10. 08/10/2010 Assign more than 2 values to xsortproducts returned errors shopproductcreatesql.asp Yes
11. 11/10/2010 Send wrong orders items information to customer if processed orders directly after the process of "Restore Order" admin\adminfileio.asp Yes
12. 11/10/2010 "Order already been processed" wrongly showed if using FireFox to checkout in SSL mode. shopthanks.asp Yes
13. 11/10/2010 Google Ecommerce is not working properly in IE browser. shopproductsubs.asp Yes
14. 12/10/2010 Ajax UPS is not working if weight is less than 1. shopajaxshippingsubs.asp Yes
15. 12/10/2010 Edit translate page should use text box. admin/shopa_edittranslateproducts.asp Yes
16. 15/10/2010 Error while selecting products with feature to cart while xFeaturesRequired is Yes. shopproductfeaturesprocess.asp Yes

1. shop$db.asp

Locate around line 3523: (within sub routine function CleanChars(strWords) )

Modify

newchars=replace(newchars,"<","&lt;")
newchars=replace(newchars,">","&gt;")
newchars=replace(newchars,"'","&apos;")
newchars=replace(newchars,")","&#x29;")
newchars=replace(newchars,"(","&#x28;")

To

' newchars=replace(newchars,"<","&lt;")
' newchars=replace(newchars,">","&gt;")
' newchars=replace(newchars,"'","&apos;")
' newchars=replace(newchars,")","&#x29;")
' newchars=replace(newchars,"(","&#x28;")

Save and test.

Back to top

2. shopajaxshippingzipcodecountry.asp

Locate around line 117:

Modify

ShipMethodType = getlang("langCommonSelect")

To

'700 - 2010.10.04 - Default shipping method is not working with xajaxshipping
if GetSess("Shipmethodtype")="" and GetConfig("xDefaultShippingMethod")<>"Yes" then
shipmethodtype=GetLang("langCommonSelect")
elseif GetSess("Shipmethodtype")="" then
if trim(request.form("shipmethodType")) <> "" then
shipmethodtype=replace(request.form("shipmethodType"), "'","''")
else
shipmethodtype=GetConfig("xfixedshippingmethod")
end if
end if

Save and test.

Back to top

3. shoplayoutmgrlogo.asp

Locate around line 42: (within sub routine sub logo)

Modify

if trim(logoaltname) <> "" then
dislogostring = dislogostring & "title="""& logoaltname &""" class=""logo"" href=""default.asp""><img "
end if

To

'701 - 2010.10.06 - Bug Fix: Logo / Image not displaying if not enter label
if trim(logoaltname) <> "" then
dislogostring = dislogostring & "title="""& logoaltname &""" class=""logo"" href=""default.asp""><img "
else
dislogostring = dislogostring & "class=""logo"" href=""default.asp""><img "
end if

Save and test.

Back to top

4a. admin/shopa_layoutmgrlogosub.asp

Locate around line 123: (within sub routine sub savelogocontainer)

Below

sql = sql & "where containerdivname = 'logo' "

Add

'7.01 - 2010.10.06 - Bug Fix: Layout Manager welcomeboxsquare / welcomestretch / logo incorrect if xproductmatch = Yes
GenLayoutMgrStorematchSQL "and", sql

Save and go to 4b.

4b. admin/shopa_layoutmgrwelcomeboxsquaresub.asp

Locate around line 337: (within sub routine sub savewelcomeboxsquarecontainer)

Below

sql = sql & "where containerdivname = 'welcomeboxsquare' and (containername = '' or containername is null) "

Add

'7.01 - 2010.10.06 - Bug Fix: Layout Manager welcomeboxsquare / welcomestretch / logo incorrect if xproductmatch = Yes
GenLayoutMgrStorematchSQL "and", sql

Locate around line 359: (within sub routine sub savewelcomeboxsquarecontainer)

Below

sql = sql & "where containerdivname = 'welcomeboxsquare' and containername = 'welcomesection' "

Add

'7.01 - 2010.10.06 - Bug Fix: Layout Manager welcomeboxsquare / welcomestretch / logo incorrect if xproductmatch = Yes
GenLayoutMgrStorematchSQL "and", sql

Locate around line 381: (within sub routine sub savewelcomeboxsquarecontainer)

Below

sql = sql & "where containerdivname = 'welcomeboxsquare' and containername = 'minicartsection' "

Add

'7.01 - 2010.10.06 - Bug Fix: Layout Manager welcomeboxsquare / welcomestretch / logo incorrect if xproductmatch = Yes
GenLayoutMgrStorematchSQL "and", sql

Locate around line 403: (within sub routine sub savewelcomeboxsquarecontainer)

Below

sql = sql & "where containerdivname = 'welcomeboxsquare' and containername = 'formsection' "

Add

'7.01 - 2010.10.06 - Bug Fix: Layout Manager welcomeboxsquare / welcomestretch / logo incorrect if xproductmatch = Yes
GenLayoutMgrStorematchSQL "and", sql

Locate around line 426: (within sub routine sub savewelcomeboxsquarecontainer)

Below

sql = sql & "where containerdivname = 'welcomeboxsquare' and containername = 'currency' "

Add

'7.01 - 2010.10.06 - Bug Fix: Layout Manager welcomeboxsquare / welcomestretch / logo incorrect if xproductmatch = Yes
GenLayoutMgrStorematchSQL "and", sql

Locate around line 449: (within sub routine sub savewelcomeboxsquarecontainer)

Below

sql = sql & "where containerdivname = 'welcomeboxsquare' and containername = 'language' "

Add

'7.01 - 2010.10.06 - Bug Fix: Layout Manager welcomeboxsquare / welcomestretch / logo incorrect if xproductmatch = Yes
GenLayoutMgrStorematchSQL "and", sql

Locate around line 472: (within sub routine sub savewelcomeboxsquarecontainer)

Below

sql = sql & "where containerdivname = 'welcomeboxsquare' and containername = 'search' "

Add

'7.01 - 2010.10.06 - Bug Fix: Layout Manager welcomeboxsquare / welcomestretch / logo incorrect if xproductmatch = Yes
GenLayoutMgrStorematchSQL "and", sql

Save and go to 4c.

4c. admin/shopa_layoutmgrwelcomeboxstretchsub.asp

Locate around line 239: (within sub routine sub savewelcomeboxstretchcontainer)

Below

sql = sql & "where containerdivname = 'welcomeboxstretch' and (containername = '' or containername is null) "

Add

'7.01 - 2010.10.06 - Bug Fix: Layout Manager welcomeboxsquare / welcomestretch / logo incorrect if xproductmatch = Yes
GenLayoutMgrStorematchSQL "and", sql

Locate around line 261: (within sub routine sub savewelcomeboxstretchcontainer)

Below

sql = sql & "where containerdivname = 'welcomeboxstretch' and containername = 'welcomesection' "

Add

'7.01 - 2010.10.06 - Bug Fix: Layout Manager welcomeboxsquare / welcomestretch / logo incorrect if xproductmatch = Yes
GenLayoutMgrStorematchSQL "and", sql

Locate around line 283: (within sub routine sub savewelcomeboxstretchcontainer)

Below

sql = sql & "where containerdivname = 'welcomeboxstretch' and containername = 'minicartsection' "

Add

'7.01 - 2010.10.06 - Bug Fix: Layout Manager welcomeboxsquare / welcomestretch / logo incorrect if xproductmatch = Yes
GenLayoutMgrStorematchSQL "and", sql

Locate around line 305: (within sub routine sub savewelcomeboxstretchcontainer)

Below

sql = sql & "where containerdivname = 'welcomeboxstretch' and containername = 'formsection' "

Add

'7.01 - 2010.10.06 - Bug Fix: Layout Manager welcomeboxsquare / welcomestretch / logo incorrect if xproductmatch = Yes
GenLayoutMgrStorematchSQL "and", sql

Locate around line 328: (within sub routine sub savewelcomeboxstretchcontainer)

Below

sql = sql & "where containerdivname = 'welcomeboxstretch' and containername = 'currency' "

Add

'7.01 - 2010.10.06 - Bug Fix: Layout Manager welcomeboxsquare / welcomestretch / logo incorrect if xproductmatch = Yes
GenLayoutMgrStorematchSQL "and", sql

Locate around line 350: (within sub routine sub savewelcomeboxstretchcontainer)

Below

sql = sql & "where containerdivname = 'welcomeboxstretch' and containername = 'language' "

Add

'7.01 - 2010.10.06 - Bug Fix: Layout Manager welcomeboxsquare / welcomestretch / logo incorrect if xproductmatch = Yes
GenLayoutMgrStorematchSQL "and", sql

Locate around line 374: (within sub routine sub savewelcomeboxstretchcontainer)

Below

sql = sql & "where containerdivname = 'welcomeboxstretch' and containername = 'search' "

Add

'7.01 - 2010.10.06 - Bug Fix: Layout Manager welcomeboxsquare / welcomestretch / logo incorrect if xproductmatch = Yes
GenLayoutMgrStorematchSQL "and", sql

Save and test.

Back to top

5. admin/shopa_generateseodynamicsubs.asp

Locate around line 449: (within sub routine sub generateseodynamiccategoryproducts)

Modify

sqlstr = sqlstr & " AND (p.higherCatalogId is null)"

To

'7.01 - 2010.10.06 - Bug Fix: SEO not generate link to sub-products
'sqlstr = sqlstr & " AND (p.higherCatalogId is null)"

Save and test.

Regenerate SEO directories.

Back to top

6. shopnewproductsub.asp

Locate around line 166: (within sub routine sub FrontpageGetnewrandomproducts)

Below

'do nothing - limit added later in code

Add

'7.01 - 2010.10.06 - Bug Fix: Latest product return wrong result at homepage if random mode is on
sqlstr = sqlstr & " distinct "

Locate around line 173: (within sub routine sub FrontpageGetnewrandomproducts)

Modify

sqlstr = sqlstr & " TOP " & GetConfig("xrandomproductlimit") + maxrecords & " "

to

'7.01 - 2010.10.06 - Bug Fix: Latest product return wrong result at homepage if random mode is on
sqlstr = sqlstr & " distinct TOP " & GetConfig("xrandomproductlimit") + maxrecords & " "

Save and test.

Back to top

7a. shopalsobought.asp

Locate around line 76: (within sub routine sub FormatAlsoBought (productid, mininame))

Below

generateproductstdcriteriasql strsql, "p.", "c.", "generateproductmatchsqlsubs"

Add

'7.01 - 2010.10.06 - Bug Fix: To exlude sub-products from crosse-selling, also bought
strsql = strsql & " AND (higherCatalogId is null) "

Save and go to 7b.

7b. shopprocat.asp

Locate around line 83: (within sub routine sub Handle_procatdisplay (value, parsearray, parseRS))

Below

generateproductstdcriteriasql sql, "p.", "c.", "generateproductmatchsqlsubs"

Add

'7.01 - 2010.10.06 - Bug Fix: To exlude sub-products from crosse-selling, also bought
sql = sql & " AND (higherCatalogId is null) "

Save and go to 7c.

7c. shopcrosssellingsubs.asp

Locate around line 31: (within sub routine sub Handle_CrossSelling (ivalue, parsearray,parseRS))

Below

generateproductstdcriteriasql strsql, "p.", "c.", "generateproductmatchsqlsubs"

Add

'7.01 - 2010.10.06 - Bug Fix: To exlude sub-products from crosse-selling, also bought
strsql = strsql & " AND (higherCatalogId is null) "

Save and test.

Back to top

8a. Open admin\js\producttype.js

Locate line 6:

Modify

document.getElementById('addproductlngCstock').style.display = 'none';

To

//7.01 - 2010.10.08 - Bug Fix: Bundle product is not displaying if xstocklow is set
//document.getElementById('addproductlngCstock').style.display = 'none';

Locate line 17:

Modify

document.getElementById('addproductlngCstock').style.display = 'block';

To

//7.01 - 2010.10.08 - Bug Fix: Bundle product is not displaying if xstocklow is set
//document.getElementById('addproductlngCstock').style.display = 'block';

Save and go to 8b.

8b. Open shopaddtocart.asp

Locate line 439: (within routine sub ReCalculate)

Modify

'700 - product bundles
if trim(ArrCart(cproducttype, i)) <> "bundled" then
if trim(ArrCart(cproductvariants, i)) = "" then
if stocklevel<>"" then
CheckStockLevelReCalculate stocklevel,tquantity, ArrCart, scartitem, i, msg
end if
end if
end if

To

'700 - product bundles
'7.01 - 2010.10.08 - Bug Fix: Bundle product is not displaying if xstocklow is set
'if trim(ArrCart(cproducttype, i)) <> "bundled" then

if trim(ArrCart(cproductvariants, i)) = "" then
if stocklevel<>"" then
CheckStockLevelReCalculate stocklevel,tquantity, ArrCart, scartitem, i, msg
end if
end if

'7.01 - 2010.10.08 - Bug Fix: Bundle product is not displaying if xstocklow is set
'end if

Save and test.

Back to top

9. Open shopexd.asp

Locate line 173: (within routine sub ExdOpenRecordSet (RS))

Modify

rs.open sql, dbc, adOpenForwardOnly, adLockReadOnly

To

rs.open sql, dbc, adOpenKeyset, adLockReadOnly

Save and test.

Back to top

10. Open shopproductcreatesql.asp

Locate line 276: (within routine sub GetProductFields (dbc))

Above

if instr(sortfields,"p.") <= 0 then

Add

'7.01 - 2010.10.08 - Bug Fix: assign more than 2 values to xsortproducts returned errors
sortfields = replace(lcase(sortfields), ", ", ",")

Locate line 281: (within routine sub GetProductFields (dbc))

Modify

sortfields = replace(lcase(sortfields), ",", "p.")

To

sortfields = replace(lcase(sortfields), ",", ",p.")

Locate line 896: (within routine sub generateprefixsortfield (sql))

Below

sortfields = GetConfig("xsortproducts")

Add

'7.01 - 2010.10.08 - Bug Fix: assign more than 2 values to xsortproducts returned errors
sortfields = replace(lcase(sortfields), ", ", ",")

Locate line 904: (within routine sub generateprefixsortfield (sql))

Modify

sortfields = replace(lcase(sortfields), ",", "p.")

To

sortfields = replace(lcase(sortfields), ",", ",p.")

Save and test.

Back to top

11. Open admin\adminfileio.asp

Locate line 867: (within routine sub Handle_OITEMS)

Modify

if GetSess("oid")<>"" then
Orderid=GetSess("oid")
else
Orderid=recordid
end if

To

'7.01 - 2010.10.11 - Bug Fix: Send wrong orders items information if processed orders directly after the process of "Restore Order"
if trim(recordid)<>"" then
Orderid=recordid
else
Orderid=GetSess("oid")
end if

Save and test.

Back to top

12. Open shopthanks.asp

Locate line 81:

Modify

if checkpaymentstatus(ordernumber) then
shoperror getlang("langshopthanks03")
end if

To

'if checkpaymentstatus(ordernumber) then
' shoperror getlang("langshopthanks03")
'end if

Save and test.

Back to top

13. Open shopproductsubs.asp

Locate line 3058: (within routine Sub ShopUrchinECommerce)

Remove

</script>

Save and test.

Back to top

14. Open shopajaxshippingsubs.asp

Locate line 101: (within routine function getTotalweight())

Remove

strProductweight = int(strProductweight)

Save and test.

Back to top

15. Open admin/shopa_edittranslateproducts.asp

Locate line 229: (within routine sub DisplayForm())

Modify

PCreateRowText GetLang("LangProductName"), "cname", strCname, 1, "", "document.all.help_translateproducts_name"

To

'7.01 - 2010.10.12 - Bug Fix: Edit translate page should use text box
formateditrow GetLang("LangProductName"), "cname" , strCname, "document.all.help_translateproducts_name"

Save and test.

Back to top

16. Open shopproductfeaturesprocess.asp

Locate line 285: (within routine sub VerifyFeaturesSelected)

Modify

if strFeatures = "" and strvariants = "" then ' this product has no features

To

'701 - 2010.10.15 - Bug Fix: Error while selecting products with feature to cart while xFeaturesRequired is Yes
if strFeatures = "" then ' this product has no features

Save and test.

Back to top

Times Viewed:
7967
Added By:
Bobby Chua
Date Created:
10/7/2010
Last Updated:
10/15/2010
Back
Search other topics
Submit a Ticket