| Author |
 Topic  |
|
|
Garth
Starting Member
Belgium
22 Posts |
 Posted - 27 June 2006 : 14:00:54
|
Hi
I'm currently trying to update my forum to a serverhacker v9 with dbs files, first few were accepted no problem, but when I ran one of the dbs_ipgate files, I now get this error.
##########
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/forum/inc_ipgate.asp, line 120
Page:
GET /forum/default.asp
###############
Line 120 reads: rs1.Open StrSql, strConnString
I know I am not updating a standard Snitz database, just wondered if anyone knew what the error meant.
Any ideas?
Cheers
Garth
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 27 June 2006 : 14:21:03
|
| Off hand there is probably some sort of problem with the SQL String itself. Since I don't know off hand if there were any modifications that ServerHacker made himself, its going to be hard to troubleshoot. You're probably better off asking there. |
 |
|
|
Garth
Starting Member
Belgium
22 Posts |
Posted - 27 June 2006 : 14:30:10
|
Yeah, I've posted on shnforum but nothing as yet.
Thanks anyway |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Garth
Starting Member
Belgium
22 Posts |
Posted - 27 June 2006 : 18:11:11
|
| Sorry not too clued up on asp, how would I get the value of strSql? |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 27 June 2006 : 18:29:02
|
add a couple of lines of code just above your line 120 which say
response.write strSQL
response.end
the code will now print the sql statement rather than executing it.
Copy the string it displays and post it here, don't forget to remove the two lines of code when you have copied down the string
|
|
|
|
Garth
Starting Member
Belgium
22 Posts |
Posted - 28 June 2006 : 02:58:07
|
Code returns this:
SELECT * FROM FORUM_IPLIST WHERE ('127.0.0.1' = IPLIST_STARTIP OR '127.0.0.1' = IPLIST_STARTIP OR '' = IPLIST_MEMBERID OR (('127.0.0.1' >= IPLIST_STARTIP) AND ('127.0.0.1' <= IPLIST_ENDIP))) AND (('20060628080349' >= IPLIST_STARTDATE) AND ('20060628080349' <= IPLIST_ENDDATE)) |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Garth
Starting Member
Belgium
22 Posts |
Posted - 28 June 2006 : 16:49:40
|
Just realised what I did, ran the ipgate new install rather than the upgrade to my already installed 8.7.
Apologies for wasting people's time.
Cheers
Garth
P.S. ruirib, not sure if you're a football fan but you'll understand if I don't wish you good luck for saturday! |
quote:
why did you not post this at Snitz?
The main reasons why this was not posted at Snitz and why I might not post the bugs I find
directly at Snitz anymore are the ways "ruirib and HuwR" take pleasure to criticize just about
anything I post and seem to resent the fact that I want to improve and correct Snitz which, I agree,
serve as the original base for my own Forum.
These are some of the actions I find unacceptable:
ruirib and HuwR take fun to Delete some of my topics, of my replies, locked or move my topic.
A topic posted last week from me to Davio in "Help: MOD Implementation" Forum as been deleted.
Two replies in my topic as been deleted about a bug on snitz topic page:
http://forum.snitz.com/forum/topic.asp?whichpage=5.96&TOPIC_ID=44136#372029
A Fix to texanman as been deleted (first reply to texanman subject):
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=66162
One of my Multi-Language Topic on Snitz has disappeared last night
Multi-Language and Multi-Language Skin3D
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=40765
etc...
3 times I changed my password and the day after the same game start.
Since I send to HuwR a donation of $200 on December 22, 2006
this guy HuwR has never stop to pick on every thing I post on the Snitz Forum. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
gpctexas
Junior Member
320 Posts |
Posted - 28 June 2006 : 20:18:11
|
There is a fix posted about this a long time ago. A variable doesnt get populated into the config_new table. If I remember right, the variable for the paginated logs is not entered. Saving this setting on the config page should insert it. Also the autoclean variable isnt entered, code below to for it's variable.
[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#('STRIPGATEAUTOCLEAN','0')
[END]
|
ipgate 2.4.4 RC3
http://www.gpctexas.net/ipgate_v244.zip |
|
|
| |
Topic |
|
Topic Locked
.