Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 DB configuration
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

pollux57
Starting Member

France
9 Posts

Posted - 07 February 2005 :  03:54:10  Show Profile  Visit pollux57's Homepage
Hello!
I've just upgraded from access to sql and I got some errors I didn't have before (ie, when a member register and I look the member's details, there is "error" in the "title" and "nb posts" fields. When I look direct in the table, there is Null instead 0. I got the same pb in the new posts : the read counter is set to null too).
Is there any special configuration to the database? Do the user defined in the database have special rigths?
Any help about the db config welcome !
Sorry for my poor english...
Eric

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 07 February 2005 :  07:20:03  Show Profile  Send ruirib a Yahoo! Message
You should have followed our instructions on upgrading an Access to an SQL Db. I would suggest that you convert again, using this procedure:

http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=31144


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

pollux57
Starting Member

France
9 Posts

Posted - 08 February 2005 :  09:32:49  Show Profile  Visit pollux57's Homepage
I've made it, following the instruction in the post you linked.
The upgrade himself is good, i have no pb on my local test server, only on the prod server. I don't find any difference between the original database and the copy on the prod server. I used the copy wizard from the enterprise manager.
Anyway, i'll try again !
Thanks
Eric
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 08 February 2005 :  09:38:03  Show Profile  Send ruirib a Yahoo! Message
If you have problems like those, that means the table structure was not properly created. Make sure it is, by running setup.asp?RC=5 now.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.33 seconds. Powered By: Snitz Forums 2000 Version 3.4.07