| Author |
 Topic  |
|
|
ltmod
Starting Member
1 Posts |
 Posted - 22 February 2006 : 07:26:55
|
I've been running Snitz for a while on SQL Server 2000. I'm in the process of upgrading to a 2005 server and took the following steps:
Backed up the original database, and restored it within 2005. The database contans the Snitz forum tables, plus a number of other tables for content management.
Oddly enough, Snitz seems to have lost its configuration settings. The data is present, and I can see the colors and various settings within the db, but on the front-end they simply don't show up. Here's an example of code generated on the original server vs the new server:
The OLD:
a:link {color:black;text-decoration:underline}
a:visited {color:blue;text-decoration:underline}
a:hover {color:#669933;text-decoration:underline}
a:active {color:#669933;text-decoration:none}
.spnMessageText a:link {color:darkblue;text-decoration:underline}
.spnMessageText a:visited {color:darkblue;text-decoration:underline}
.spnMessageText a:hover {color:#669933;text-decoration:underline}
.spnMessageText a:active {color:#669933;text-decoration:underline}
.spnSearchHighlight {background-color:#669933}
input.radio {background:lightsteelblue;color:#000000}
The New:
a:link {color:;text-decoration:}
a:visited {color:;text-decoration:}
a:hover {color:;text-decoration:}
a:active {color:;text-decoration:}
.spnMessageText a:link {color:;text-decoration:}
.spnMessageText a:visited {color:;text-decoration:}
.spnMessageText a:hover {color:;text-decoration:}
.spnMessageText a:active {color:;text-decoration:}
.spnSearchHighlight {background-color:}
input.radio {background:;color:#000000}
Again the data is present, but for some reason Snitz can't get at it properly. I've tried changing the connection string to use SQL Native Client, as well as creating a DSN, but the problem persists. Is there a fix for this? Is anyone aware of this issue?
Any help is greatly appreciated.
By the way, I should point out that the only difference right now between the old server and new server is the URL. I've configured a temporary URL for the new server in order to test the site before I change the DNS over. Could that be issue?
Regards,
Alex T.
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 22 February 2006 : 08:08:38
|
| try running setup.asp, or use the check config link in admin options, basically your application variables need to be reloaded |
 |
|
|
grazman
Junior Member
USA
193 Posts |
Posted - 07 March 2006 : 21:36:35
|
I just upgraded SQLTeam.com to SQL Server 2005. It went smoothly and my forums are running just fine.
And while I'm here I'd like to say Thank You to everyone that worked on this software. I've been running these forums for over five years now and they've been great. SQLTeam.com has over 250,000 posts and the site is as fast as it was with 10 posts. |
SQLTeam.com - For SQL Server Developers and Administrators |
|
|
|
campinmom03
Junior Member
USA
190 Posts |
Posted - 02 May 2007 : 16:37:56
|
Hello. Hope this is where to post.  If not my apologies. Just let me know where.
My host allows me many different options that I was not aware of at the time when I put up a snitz current version, on an access db, with only 2 mods. Anyway, turns out my other db options are included with the account I currently have with them. (I really would like to use one of those options as I hear it is a nightmare to do this later on). Those options are My SQL using My SQL Admin free tool or MS SQL using Enterprise Manager (Which they said, I would have to set up a 2005 DB to populate it?) Not sure how to go about that, or even how to set up on of the SQL's from the admin side.
Any help is appreciated. |
Have a great day!
Terry |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 02 May 2007 : 16:49:47
|
| The nightmare is the same, whether you do it now or later. There are posts here and at the MySQL forum documenting the migration process. What kind of help do you need? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
campinmom03
Junior Member
USA
190 Posts |
Posted - 02 May 2007 : 18:00:19
|
Well I don't know how to set this up within the control panel on the server for one. (Which is a shared) Also have no idea how to set up the 2005 DB? Or even which one of the DB's to use for that matter. Can you provide me with a link. I've gone through tons of searches... honest. So many of them though. Not sure where to start. I found this one but wasn't sure if this is what I should do. http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=31144
Thanks in advance. |
Have a great day!
Terry |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 02 May 2007 : 18:33:25
|
Yes, that is the advice given to upgrade to SQL Server from Access. There is not such a reliable advice for upgrading to MySQL, so if you have both options, I suggest that you go with SQL Server.
I don't know your control panel, but you should just create the DB from there, take notice or choose a database name, user name and password and then use that in your config.asp. That's all there is to it... even if the migration process may be a bit tricky if you're not used to Enterprise Manager. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
campinmom03
Junior Member
USA
190 Posts |
Posted - 02 May 2007 : 18:50:34
|
ruirib,
Thank you for your responses. I do appreciate it. I'm glad to know that at least I have the starting point right.
I'm not used to the Enterprise Manager... what is tricky about it? Do you have any tips for me while using it?
Thank you again!
|
Have a great day!
Terry |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
