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 set-up problems
 Updating Content Data		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

seph
Starting Member

USA
3 Posts
Posted - April 21 2008 :  05:16:17  Show Profile  Reply with Quote
Fresh installation with all security fixes - v.6.50.3 (Value), Win2003, MySQL 5.0.51a.
Ran database testing sripts (diag_dbtest.asp) successfully. Can copy or create new Content data. Problem- when setting "Use as homepage" to "Yes" it does NOT stick in database. Will not change from "No". Exception- will work the first time when creating the content entry. But if I edit and Update Record it changes to "No" for "Use as homepage" every time after.

carfin
VP-CART Expert

United Kingdom
948 Posts
Posted - April 21 2008 :  06:49:03  Show Profile  Reply with Quote
Hi,

See this topic for the answer.

http://www.vpasp.com/virtprog/vpaspforum/topic.asp?TOPIC_ID=7046


Regards,

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

seph
Starting Member

USA
3 Posts
Posted - April 21 2008 :  11:23:19  Show Profile  Reply with Quote
I'm sorry, my code already read like the solution from that post. This is a fresh download of the package as of last week. We didn't do an upgrade, we just purchased. Also, the problem seems to be a backend-admin issue. I have to manually go into the database and turn the bit to "Yes" for "show on homepage" and if the content is edited, it turns itself to "No" and disregards any changes made to the content when submitting an update. It almost looks like an issue writing to the database, but it passed the database "read" "write" tests. Also, if I leave "set as homepage" to "No" and update the content, any updates are disregarded- kind of like a permissions problem. But, as I mentioned I can create a new content item and it will save into the database the first time with no problems. Just problems updating later.

Maybe it's a problem with the file, shopa_editcontent.asp ?
Edited by - seph on April 21 2008 12:12:51
Go to Top of Page

seph
Starting Member

USA
3 Posts
Posted - April 22 2008 :  02:37:01  Show Profile  Reply with Quote
Here is solution:

fix so that all date will be normalized.

shopmysqlsubs.asp
(line 1063)

fieldvalue = now()

change to :

fieldvalue = "'" & datenormalize(now()) &"'"
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