| Author |
 Topic  |
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
 Posted - 11 November 2001 : 07:44:02
|
Oh and yeah T_INPLACE is INT and T_MSGICON is also.
Halo of Xegony |
 |
|
|
SimonT
Junior Member
United Kingdom
202 Posts |
Posted - 22 November 2001 : 17:28:33
|
I am getting the same errors as well now on my forum last mod to be added was the new version of Pm mods
http://www.flagball.co.uk/forum/topic.asp?ARCHIVE=true&TOPIC_ID=274
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/forum/topic.asp, line 280
else 'end MySql specific code
set rsReplies = Server.CreateObject("ADODB.Recordset")
rsReplies.cachesize = strPageSize
line 80 rsReplies.open strSql, my_Conn, 3
If not (rsReplies.EOF or rsReplies.BOF) then '## No replies found in DB
rsReplies.movefirst
rsReplies.pagesize = strPageSize
rsReplies.absolutepage = mypage '**
maxpages = cint(rsReplies.pagecount)
end if
end if
i = 0
%>
http://www.flagball.co.uk/forum/topic.txt
config string is
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\1234\56789\snitz_forums_2000.mdb;"'## MS Access 2000
after putting
response.write(strSql)
I get this
SELECT FORUM_MEMBERS.M_NAME, FORUM_MEMBERS.M_HIDE_EMAIL, FORUM_MEMBERS.M_ICQ, FORUM_MEMBERS.M_YAHOO, FORUM_MEMBERS.M_AIM, FORUM_MEMBERS.M_TITLE, FORUM_MEMBERS.MEMBER_ID, FORUM_MEMBERS.M_HOMEPAGE, FORUM_MEMBERS.M_LEVEL, FORUM_MEMBERS.M_POSTS, FORUM_MEMBERS.M_COUNTRY, FORUM_MEMBERS.M_PMRECEIVE, FORUM_MEMBERS.M_AVATAR_URL, FORUM_A_REPLY.REPLY_ID, FORUM_A_REPLY.FORUM_ID, FORUM_A_REPLY.R_AUTHOR, FORUM_A_REPLY.TOPIC_ID, FORUM_A_REPLY.R_MESSAGE, FORUM_A_REPLY.R_STATUS, FORUM_A_REPLY.R_DATE FROM FORUM_MEMBERS, FORUM_A_REPLY WHERE FORUM_MEMBERS.MEMBER_ID = FORUM_A_REPLY.R_AUTHOR AND TOPIC_ID = 274 ORDER BY FORUM_A_REPLY.R_DATE ASC
I then got the archived message but after a refesh I got the error again.
version is 3.3
Any help you can give would be great
Any one ..
Edited by - SimonT on 25 November 2001 15:05:12
Any one ...
Edited by - simonT on 26 November 2001 11:21:00 |
|
|
|
SimonT
Junior Member
United Kingdom
202 Posts |
Posted - 06 December 2001 : 07:49:50
|
| Bounce |
|
|
|
SimonT
Junior Member
United Kingdom
202 Posts |
Posted - 08 December 2001 : 18:14:04
|
ping
SimonT
I so wish I could code in ASP.. |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 08 December 2001 : 22:37:39
|
I don't know the source of your error, but often the error code you are getting happens when a field or table specified in the sql string (what you got back from your response.write you added) doesn't exist in the database. You might verify all the fields against the actual database to see if there are any discrepancies.
======
Doug G
====== |
|
|
|
SimonT
Junior Member
United Kingdom
202 Posts |
Posted - 09 December 2001 : 12:04:49
|
I went back 3 backups (2 months) so it looks like this error might have been on my forum for quite a while I might just rebuild this one file again and try and work out where the problem is.
Also is there a querry that I could run agaist my database that would list all the tables ? |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 09 December 2001 : 14:54:36
|
You may want to look at table editor at www.2enetworx.com, an asp database maintenance tool which lets you look at your tables, modify the structure or data, etc. It's a great tool but you'll have to read carefully on how to set it up, there is one file you need to edit with the connection information and it's not as easy to configure as Snitz.
Also make sure the program is well protected so unauthorized users can't run it.
======
Doug G
====== |
|
|
|
SimonT
Junior Member
United Kingdom
202 Posts |
Posted - 10 December 2001 : 08:29:33
|
I use to use table editor all the time (its even used here) but I have had some problems with it. I long time ago I had a realy bad host and some times scripts would just time out as the sever was realy busy, I was editing a table on my forum once when the page timed out I then found that it had half updated the database and it had screwed up the config table.
last week I had the same problems with my new host (of 6 months) 121hosting :-( and it screwed up my database as well I had to restore from a backup. And aother time it changed a few fields from allow blanks values to not allowing blank values mmmm maybe it was user error who knows :-)
here is the link again
http://www.2enetworx.com/dev/projects/tableeditor.asp
your link has a , at the end of it and will cause the server not to be found.
ps teconfig.asp was not that hard to sort out plus there are some good mods as well to help you connect to multiple dadtabases in 1 folder. |
|
|
|
Topic |
|
Topic Locked
