Author |
Topic |
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 21 February 2004 : 09:20:39
|
When trying to do a DBS file admin_mod_dbsetup.asp i keep getting this error: Active Server Pages, ASP 0113 (0x80004005) The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools. /snitz/admin_mod_dbsetup.asp
I'm not sure what to do about this, as i have never got the error when useing Snitz on this box. |
De Priofundus Calmo Ad Te Damine |
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 21 February 2004 : 09:45:30
|
It's a little odder then i first thought.
This part of the file it does at the same speed it used too
[DROP]
ADVERT
[END]
[DROP]
ADVERT_HIT
[END]
[CREATE]
ADVERT
ADVERT_ID
COMPANY#varchar(50)#NULL#
TITLE#varchar(255)#NULL#
URL#varchar(255)#NULL#
IMAGEPATH#varchar(50)#NULL#
FREQ#int#NULL#
[END]
[CREATE]
ADVERT_HIT
ADVERT_HIT_ID
ADVERT_ID#int#NULL#
MEMBER_ID#int#NULL#
HITDATE#varchar(14)#NULL#
[END]
But then it gets stuck, and times out on this part
[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#('strARUploadPath','Adverts')
(C_VARIABLE,C_VALUE)#('strARAdvertHeight','468')
(C_VARIABLE,C_VALUE)#('strARAdvertWidth','60')
[END]
|
De Priofundus Calmo Ad Te Damine |
|
|
ajhvdb
Junior Member
Netherlands
392 Posts |
Posted - 21 February 2004 : 15:43:29
|
Had the same problems with different dbs statements.
I copied all the statements to notepad. Removed all spaces before and after every line. Removed empty lines. Copied all to the alternate setup and pressed submit. |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 21 February 2004 : 19:03:05
|
quote: Copied all to the alternate setup and pressed submit.
And it worked after doing that ? |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
ajhvdb
Junior Member
Netherlands
392 Posts |
Posted - 21 February 2004 : 19:39:41
|
Yes, very strange. I thought it was something on my computer or just a bad day. |
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 22 February 2004 : 14:46:11
|
I got the same problem with the same DBS, did the removal of spaces solve this for you PeeWee? |
/Tribaliztic - www.gotlandrace.se -
|
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 22 February 2004 : 16:21:43
|
Nah, i'm just going to make a new banner mod for the forum.
|
De Priofundus Calmo Ad Te Damine |
|
|
ajhvdb
Junior Member
Netherlands
392 Posts |
Posted - 22 February 2004 : 17:20:45
|
quote: Originally posted by PeeWee.Inc
Nah, i'm just going to make a new banner mod for the forum.
I downloaded the advert_rotator-34-11.zip and started the dbs in a demo database.
Got the same IIS error??!!
Did as discribed above and it did work "Database setup finished"
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 22 February 2004 : 18:29:08
|
Something like what I am using?quote: Originally posted by PeeWee.Inc Nah, i'm just going to make a new banner mod for the forum.
I have created a new banner item as I really wanted something that could go across the site. I have now finished it that allows for updates, adding new adverts and deleteing old ones. I have also added a login function for it. |
Cheers, David Greening |
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 23 February 2004 : 02:54:36
|
Classicmotorcycling: Can we see it? =) |
/Tribaliztic - www.gotlandrace.se -
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 23 February 2004 : 03:58:59
|
I have it working at my site currently, but will create a demo version for the admin side as well if you like, but this can not be done until later this week as I have heaps on.
|
Cheers, David Greening |
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 23 February 2004 : 05:27:49
|
OK, I thought about it and decided to create a demo page quickly. It is at Banner Demo
There is instructions at the page and allows users to log in and play with and add some banners.
|
Cheers, David Greening |
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 23 February 2004 : 05:39:51
|
I had the same problems with the moderate.asp-page, added this to the page and everything work fine, maybe that's possible for the db-setup page also:
This in the top of the page: X = Server.ScriptTimeout Server.ScriptTimeout = 900
This line in the end: Server.ScriptTimeOut = X
900 is 900 seconds. |
/Tribaliztic - www.gotlandrace.se -
|
|
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 23 February 2004 : 05:53:52
|
Classicmotorcycles: Looks nice, although I got an error when trying to submit a banner:
Provider error '80020005'
Type mismatch.
/snitz_demo/classic_banner_admin_add_entry.asp, line 164
(sorry, we're way offtopic here now...) |
/Tribaliztic - www.gotlandrace.se -
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 23 February 2004 : 12:56:09
|
This is caused due to the field is used for a date in the End Date area and if plain letters are used it spits it. The format for the end date is 30/12/2004 which represents 30th December 2004.quote: Originally posted by tribaliztic
Provider error '80020005'
Type mismatch.
/snitz_demo/classic_banner_admin_add_entry.asp, line 164
(sorry, we're way offtopic here now...)
Yes, sorry for the hijack.
|
Cheers, David Greening |
|
|
|
Topic |
|