Welcome, Guest ( Customer Panel | Login )

 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  

VP-CART New User

United Kingdom
76 Posts

Posted - November 29 2011 :  10:41:13  Show Profile  Reply with Quote
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)
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.


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.


Go to Top of Page

VP-CART Expert

762 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 ?

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)