| Author |
 Topic  |
|
Croatia
New Member
53 Posts |
 Posted - 03 July 2005 : 16:30:42
|
after compacting my forum doesn't work.
Compacted database is in folder: www/cgi-bin/forum/tools/Snitz_compacted.mdb
my original database was in folder www/fdp
what do to forum works?
forum link: http://www.kohorta.net/cgi-bin/forum/default.asp |
|
|
Croatia
New Member
53 Posts |
Posted - 03 July 2005 : 17:18:11
|
| now I'm upload back old database and forum work, but how compact database, 65MB is to big and forum is very slow (page generated 10-70sec).. |
Edited by - Croatia on 03 July 2005 17:47:09 |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 03 July 2005 : 19:59:46
|
| You should have just renamed Snitz_compacted.mdb to the normal name of your mdb file. The compacting process should have done it automatically, though. Did you get any error message? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Croatia
New Member
53 Posts |
Posted - 04 July 2005 : 09:44:50
|
yes, i moved Snitz_Compacted.mdb to folder where is my DB, and renamed to normal name of mdb and then forum doesn't work, this error is on default.asp :
Microsoft JET Database Engine error '80004005'
Could not delete from specified tables.
/cgi-bin/forum/inc_func_common.asp, line 161
Well i don't remember if there was any error message during the compacting process... :(
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 04 July 2005 : 09:57:37
|
| Keep a backup of the normal database (the compacting process does it as well) and try to compact it again. Pay attention to error messages and post back for help if you need it. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Croatia
New Member
53 Posts |
Posted - 04 July 2005 : 12:06:06
|
do you reccomended me to change something in admin_compacted.asp before comapting?
i read topic http://forum.snitz.com/forum/topic.asp?TOPIC_ID=31540
i ask this because is very slow to downlaod and upload my original database few times. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Croatia
New Member
53 Posts |
Posted - 04 July 2005 : 12:49:44
|
I think that may be problem, but i'm not sure before new compacting.. and I don't unterstadt in what would I change Server.MapPath(tools/Snitz_compacted.mdb") in my case?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Croatia
New Member
53 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Croatia
New Member
53 Posts |
Posted - 04 July 2005 : 14:49:20
|
like this!? and than compact agian?
Server.MapPath(../fpdb/Snitz_compacted.mdb")
sorry if i'm harass you, I don't know much about this. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Croatia
New Member
53 Posts |
Posted - 04 July 2005 : 17:09:53
|
i have this in config.asp
i would first know is it correct before comapacting again, DB is big 65mb and is not pleasant to upload again with 384/64 dsl.
'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Webspace\resadmin\kohorta\kohorta.net\www\fpdb\Kohorta_Online.mdb" '## MS Access 2000
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\Webspace\resadmin\kohorta\kohorta.net\www\cgi-bin\forum\tools\Kohorta_Online.mdb" '## MS Access 97
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL
'strConnString = "DSN_NAME" '## DSN
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Croatia
New Member
53 Posts |
Posted - 05 July 2005 : 01:53:25
|
3.4.02
how then, comapcting create Snitz_compacted.mdb in Tools folder and backup of original database in folder /fpdb, but forum doesn't work, I try to renamed Snitz_compacted.mdb in to original DB name, but forum then doesn't work, I must upload back original DB.
error is like this one:
quote:
Databasen är nu komprimerad. (The database is now compressed)
Microsoft VBScript runtime error '800a0035'
File not found
/forum/admin_compactdb.asp, line 141
|
Edited by - Croatia on 05 July 2005 04:23:30 |
|
|
|
Topic |
|
Topic Locked
