| Author |
 Topic  |
|
juliemac
Starting Member
12 Posts |
 Posted - 22 December 2009 : 11:29:41
|
The config.asp script calls to the table.
It does not exist.
Its driving the dual processor to 50% and times out.
Is there a set up doc I missed? |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
juliemac
Starting Member
12 Posts |
Posted - 22 December 2009 : 12:12:19
|
sql server 2008 on a server 2003 box.
"Snitz Forums 2000 Version 3.4.07"
I imported the tables from access to sqlsvr.
No Config or config_new tables |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
juliemac
Starting Member
12 Posts |
Posted - 22 December 2009 : 12:35:35
|
I got the database connection string selected correctly in Config.asp.
Its attaching. So far I have spent 4 hours trying to get it to get past the setup.asp page.
Another hour and I'll find another forum to use for the clients app. |
|
|
|
juliemac
Starting Member
12 Posts |
Posted - 22 December 2009 : 12:40:07
|
| All the tables in snitz_forums_2000.mdb transferred. There is no config table in access either |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 December 2009 : 12:41:43
|
What you do is your choice. Sometimes it helps to ask before starting any procedure, we usually help as fast as we can, and that is usually very fast (in this case, 24 mins after your initial post, wouldn't embarrass a pro support board, I am now in longer wait on support for a paid for product).
Besides the post I linked above, there is a more detailed import procedure described here:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=63884
IMHO, you should drop the existing tables and follow the recommended upgrade procedure. Should take less than an hour.
I'll be here to help, if needed. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
juliemac
Starting Member
12 Posts |
Posted - 22 December 2009 : 13:00:26
|
If I look in the access table in the Dbase folder, the table does not exist. There are 17 tables all starting with forum_*, but no create. Could the DB in the down load folder be shorted?
I also set up an other folder on the server and tried to run it via the access table and it just times out at the same place in the code. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 December 2009 : 13:06:11
|
Julie, this was a running forum, right? You need to use the access table that was being used in the running forum. The table included in the download isn't complete, as there are some stuff that is created during the setup process. Forum_config_new is one such table.
Did you check the connection string, to find out the location for the database that was being used in the live forum? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
juliemac
Starting Member
12 Posts |
Posted - 22 December 2009 : 13:33:42
|
No. I downloaded, unzipped and moved into position.
Set the properties in IIS, and set up the database. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 December 2009 : 13:41:07
|
If it's a new forum, all you need to do is set config.asp to use a SQL Server database, by uncommenting strDBType="sqlserver" and uncommenting one of the connection strings like:
strConnString="Provider=SQLOLEBD;Data Source.."
You need to fill in your details in the connection string and setup will create all the tables for you.
For a new forum, there is no need to upgrade from Access.
HTH |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
juliemac
Starting Member
12 Posts |
Posted - 22 December 2009 : 14:56:17
|
Thats been done. I've used earlier versions for clients before.
It dies trying to connect to the tables that dont exist in the MDB.
Down load the lastest version and check it out in the MDB. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 22 December 2009 : 17:04:39
|
He doesn't seem to be getting it.
Julie, please forget about the Microsoft Access Database. You said you are using Microsoft SQL Server, so you have nothing to do with the Access database.
Download the snitz forums, edit your config.asp file with your SQL server settings and then go to setup.asp and let the forum setup your database. Simple and easy as that!
The readme file also contains the same instructions. http://forum.snitz.com/forum/readme.htm |
Support Snitz Forums
|
|
|
|
juliemac
Starting Member
12 Posts |
Posted - 23 December 2009 : 08:29:21
|
<sigh> Nope.
I deleted the folder in IIS as well as the database in SQLserver.
I then re-downloaded the code, unzipped and moved the folder into place.
I opened the config file and changed the log on data.
Ran setup, the server micro sits at 50%, the setup page sits for 1:30seconds, then times out.
This releases the server processor.
I also tried up creating and up loading the access files to SQLserver.
Re-ran setup and the same thing happens.
1) Is there supposed to be a config or Config_new table?
I dont see it in the MDB at all and I see no create_table sql.
Thanks |
|
|
|
Topic |
|
Topic Locked
