General support (English)
 A-shop support » General support (English)
Subject Topic: Cant open homepage Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
kelvingo935
Newbie
Newbie
Avatar

Joined: 13 November 2009
Online Status: Offline
Posts: 1

Warning level: (0%)
Minus 1 warningCurrent warnlevel: 0%Add 1 warning
Posted: 15 November 2009 at 14:53 | IP Logged Quote kelvingo935
I have setup my store edi but when i try open, it show me this...

http://free.7host05.com/happyshopon9/

ADODB.Field error '80020009'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/happyshopon9/common.asp, line 174

Edited by kelvingo935 on 15 November 2009 at 14:55
Back to Top View kelvingo935's Profile Search for other posts by kelvingo935
 
Jibon
Admin Group
Admin Group
Avatar
Developer

Joined: 01 October 2003
Location: Bangladesh
Online Status: Offline
Posts: 72

Warning level: (0%)
Minus 1 warningCurrent warnlevel: 0%Add 1 warning
Posted: 15 November 2009 at 18:20 | IP Logged Quote Jibon

1) Make sure your server supports access database file

2) make sure that database file has read-write permission

3) A-shop will not work properly in sub domain. It will work in alone domain or sub-folder (like http://yourdomain.com or http://yourdomain.com/a-shop )
Back to Top View Jibon's Profile Search for other posts by Jibon Visit Jibon's Homepage
 
peterlimttk
Newbie
Newbie
Avatar

Joined: 17 December 2009
Location: Singapore
Online Status: Offline
Posts: 4

Warning level: (0%)
Minus 1 warningCurrent warnlevel: 0%Add 1 warning
Posted: 22 January 2010 at 06:35 | IP Logged Quote peterlimttk
I have the same problem. I'm using IIS 5 in Windows XP Pro.
I have no problem updating the Admin settings but when I
get the error described when I try to go the shop home.
I've set the database file permissions and a-shop is in
c:\shop and set as a virtual directory "shop" in IIS. Could
you help? Thanks.

Peter
Back to Top View peterlimttk's Profile Search for other posts by peterlimttk
 
Jibon
Admin Group
Admin Group
Avatar
Developer

Joined: 01 October 2003
Location: Bangladesh
Online Status: Offline
Posts: 72

Warning level: (0%)
Minus 1 warningCurrent warnlevel: 0%Add 1 warning
Posted: 22 January 2010 at 09:24 | IP Logged Quote Jibon

If your virtual directory in IIS then I hope your URL will be http://localhost/shop

Goto Store Setup of admin section. Mention /shop/ in your virtual path
Back to Top View Jibon's Profile Search for other posts by Jibon Visit Jibon's Homepage
 
peterlimttk
Newbie
Newbie
Avatar

Joined: 17 December 2009
Location: Singapore
Online Status: Offline
Posts: 4

Warning level: (0%)
Minus 1 warningCurrent warnlevel: 0%Add 1 warning
Posted: 22 January 2010 at 19:37 | IP Logged Quote peterlimttk
Thanks for the quick reply. The URL is correct and the virtual path has been set to /shop/. Still same problem. Have tried updating MDAC but problem still remains.
Back to Top View peterlimttk's Profile Search for other posts by peterlimttk
 
Jibon
Admin Group
Admin Group
Avatar
Developer

Joined: 01 October 2003
Location: Bangladesh
Online Status: Offline
Posts: 72

Warning level: (0%)
Minus 1 warningCurrent warnlevel: 0%Add 1 warning
Posted: 23 January 2010 at 06:22 | IP Logged Quote Jibon
Please describe your problem with error code which is localhost showing. However I'm also using Windows XP Pro with IIS6. It doesnt show any wrong. I suggest you to mention full error which is localhost showing
Back to Top View Jibon's Profile Search for other posts by Jibon Visit Jibon's Homepage
 
peterlimttk
Newbie
Newbie
Avatar

Joined: 17 December 2009
Location: Singapore
Online Status: Offline
Posts: 4

Warning level: (0%)
Minus 1 warningCurrent warnlevel: 0%Add 1 warning
Posted: 25 January 2010 at 09:33 | IP Logged Quote peterlimttk
The complete error response from the browser window is at below:

The page cannot be displayed

There is a problem with the page you are trying to reach and it cannot be displayed.

Please try the following:

  • Click the Refresh button, or try again later.
  • Open the <> localhost home page, and then look for links to the information you want.

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Technical Information (for support personnel)

  • Error Type:
    ADODB.Field (0x80020009)
    Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
    /shop/common.asp, line 174
  • Browser Type:
    Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
  • Page:
    GET /shop/Default.asp
  • Time:
    Monday, January 25, 2010, 5:32:34 PM
  • More information:
    Microsoft Support

Back to Top View peterlimttk's Profile Search for other posts by peterlimttk
 
Jibon
Admin Group
Admin Group
Avatar
Developer

Joined: 01 October 2003
Location: Bangladesh
Online Status: Offline
Posts: 72

Warning level: (0%)
Minus 1 warningCurrent warnlevel: 0%Add 1 warning
Posted: 26 January 2010 at 18:09 | IP Logged Quote Jibon

Did you change any code? Did you input any product from Administration panel? Make sure to input any product with weight. If any product doesn't have any weight then dont leave it blank - make 0 (I mean zero)
Back to Top View Jibon's Profile Search for other posts by Jibon Visit Jibon's Homepage
 
peterlimttk
Newbie
Newbie
Avatar

Joined: 17 December 2009
Location: Singapore
Online Status: Offline
Posts: 4

Warning level: (0%)
Minus 1 warningCurrent warnlevel: 0%Add 1 warning
Posted: 01 February 2010 at 03:10 | IP Logged Quote peterlimttk
No, I haven't changed any code. Just unzipped the package into the directory. Haven't input any products yet either. I've tried it on 2 different machines and they show the same error. Need your advice...

Thanks.
Back to Top View peterlimttk's Profile Search for other posts by peterlimttk
 
Jibon
Admin Group
Admin Group
Avatar
Developer

Joined: 01 October 2003
Location: Bangladesh
Online Status: Offline
Posts: 72

Warning level: (0%)
Minus 1 warningCurrent warnlevel: 0%Add 1 warning
Posted: 01 February 2010 at 15:11 | IP Logged Quote Jibon
try in any widows hosting server
Back to Top View Jibon's Profile Search for other posts by Jibon Visit Jibon's Homepage
 
GAmandola
Newbie
Newbie
Avatar

Joined: 25 February 2010
Location: Italy
Online Status: Offline
Posts: 5

Warning level: (0%)
Minus 1 warningCurrent warnlevel: 0%Add 1 warning
Posted: 25 February 2010 at 20:02 | IP Logged Quote GAmandola

Change the following line

from strSQL = "SELECT language_id, language_folder FROM lang WHERE language_default = 1"

to  strSQL = "SELECT language_id, language_folder FROM lang WHERE language_default = -1"

On my server work fine.
Back to Top View GAmandola's Profile Search for other posts by GAmandola Visit GAmandola's Homepage
 
viki
Newbie
Newbie
Avatar

Joined: 20 June 2009
Location: Vietnam
Online Status: Offline
Posts: 5

Warning level: (0%)
Minus 1 warningCurrent warnlevel: 0%Add 1 warning
Posted: 24 April 2010 at 12:42 | IP Logged Quote viki

open file common.asp and rewrite line 171 as below:

  Replace strSQL = "SELECT language_id, language_folder FROM lang WHERE language_default = 1"

with   strSQL = "SELECT language_id, language_folder FROM lang WHERE language_default = -1"
Back to Top View viki's Profile Search for other posts by viki
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum