Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


Forgot your Password?
 All Forums
 VPCart Forum
 VP-ASP 6.50 Features and Facilities
 2 websites 1 database		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rmgolf
VP-CART New User

United Kingdom
76 Posts
Posted - November 29 2011 :  10:41:13  Show Profile  Reply with Quote
Help
I am trying to setup a second website using the same database have created a new folder on my localhost wwwroot and copied my original site into it, then I made the changes as described on page 201 of the Ver 6.5 users manual, this seems to be working if I select a product in the main database and change the productmatch to store2 it no longer shows in the main store.
But when I try and access the second store I get the following error.

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/shop/default.asp, line 136

Below is a copy of line 136 in default.asp

Sub WriteImpressions
contentdbc.execute("UPDATE content SET impressions = 0 WHERE impressions IS NULL")
if contentid <> "" then
'increment content impressions
contentdbc.execute("UPDATE content SET impressions = impressions + 1 WHERE contentid = " & contentid)
Else
If messagetype <> "" Then
contentdbc.execute("UPDATE content SET impressions = impressions + 1 WHERE messagetype LIKE '" & messagetype &"'")
End If
End If
End Sub%>


Can anybody help with this or is there a clearer instructions to be found anywhere on how to achieve two websites running from a single Access database.

Bob

carfin
VP-CART Expert

United Kingdom
948 Posts
Posted - November 29 2011 :  11:58:56  Show Profile  Reply with Quote
Hi Bob,

seems likely to be a permissions problem with the database not allowing access from the 2nd site. I would suggest contacting the support guys unless someone else can help out soon.

Regards,

Carrol
www.deanston-electrical.co.uk
Go to Top of Page

diegomilito
VP-CART Expert

Argentina
779 Posts
Posted - January 06 2012 :  03:52:32  Show Profile  Reply with Quote
Bob, are you using Access db ? if yes, can you try asking web host guys to enable read/write permission to the db folder and db file ?

Diego.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00
  • Your Cart Is Empty