VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-Cart StoreFront Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 Problems and bugs
 Split Database corrupts Admin menu access
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

VP-ASP Super User

304 Posts

Posted - May 29 2006 :  16:33:33  Show Profile  Reply with Quote
VP-ASP versions affected: 5.5

Description: Version 5.5 introduced the split database feature. If the "User Control" features of the administrator control panel is used to change passwords or make other minor changes to for an administrator account, that administrator will lose access to certain menus.

shopa_user_control.asp or other related asp file does not have full knowledge of the slit database feature. The result is corruption of the tblusr table in the database. Specifically, the tablesallowed field loses some of the values that it should have in it.

One workaround to avoid this problem is to only use the "Edit Tables" feature of the cart to modify the user. Unfortunately, this is painful.

If the problem has already caused corruption of your administrator controls, you'll need to add some or all of following entries back into the tablesallowed field using Microsoft Access or "Edit Tables"
Of course, only add tables that you actually want access to and there may be others needed for your situation that aren't in this list.

Sometime in the past, I received the ASP code correction for this from support, but am unable to find it now. Does someone else have this fix?

Edited by - greatphoto on May 29 2006 16:54:42

VP-ASP Super User

260 Posts

Posted - June 09 2006 :  16:22:36  Show Profile  Visit ironhawker's Homepage  Reply with Quote
I just did a search in the VPAsp search thing above and got 2 plus pages of stuff all the way back to Jan 2003? or 2005
"split database". You might see something there you like.

Actually if you had a post on it there is a record of all your posts, just click on your own name to access a history.

Randy "RC" Corn
[email protected]
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000