| Author |
 Topic Search  Topic Options
|
iSec 
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 13 February 2005 at 2:22pm |
 -boRg- wrote:
The CDate error on the forum_posts.asp page is usually cousred by the edit date, if the post has been edited.
The problem comes when changing servers etc. from a server that uses a period (.) in decimal numbers and those servers that use (,) in decimal numbers eg:-
123456.55
123456,55
If you have access to the server, changing the servers settings to use (.) instead of (,) or vise versa would sortout this issue.
|
I do not have access to the server. Could you tell me where specifically to look in the forum and what to edit? Thanks.
|
 |
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 13 February 2005 at 3:26pm |
i GET THIS ERROR WHEN TRYING TO POST A NEW MESSAGE:
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 13 February 2005 at 3:32pm |
|
what is on that line. it maybe that you need to set the default values for the feilds.
open the database and make sure the default values for fields are correct.
but please post the line then we can get a better idea.
also a version number of WWF and database type would be helpful to.
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 13 February 2005 at 3:39pm |
Ok here's what is on the line 826 of post_message.asp:
lngNumOfPosts = CLng(rsCommon("No_of_posts"))
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 13 February 2005 at 3:45pm |
|
is the account a brand new one (IE the account has not posted before).
this database was upsized right (is now SQL and was access?)
this problem maybe because during the upsizing the
field type wasn't put to int/big int
or the default value is not set to 0
or the field doesn't contain a value at all (if this one look about the one above as that may not be set also)
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 13 February 2005 at 3:50pm |
Dj air, please be patient with me. I'm not very good at this, I used to have my forum as SQL but after I changed hosting provider I no lonegr had MS SQL database so I switched to Access.
I uploaded a brand new access version to my webspace, then I went to the wwForum.mdb and replaced it with my SQl database wwwForum.mdb that i used to have on the old forum. Now any user registers and posts they get these errors and I don't know what to do.
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 13 February 2005 at 4:09pm |
|
have you made sure that the database is correct and 100% in tacked?
did you do a compact and repair on the database?
it sounds like te default values aren't set in the database, have you
tried a blank new database to see if that fixes it , then you know its
because the database is not correct.
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 13 February 2005 at 4:14pm |
|
How do I make sure that the db is correct and 100% in tacked? Do I open it in MS Access and check on that or how? And how do I set the default values? How do I add a blank new database? I am so thankful to you mate. Your help is appreciated. BTW, I did not repair or compact the db.
|
|
