| Author |
 Topic  |
|
|
imperialdata
Starting Member
United Kingdom
15 Posts |
 Posted - 29 April 2008 : 11:50:56
|
Hi. Tried to run the Cripto9t unarchive mod on my forum running Snitz on an Access DB. The mod can be found here:
http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=55145&whichpage=1
I get this error after clicking the unarchive icon:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/pop_flag.asp, line 61
Line 61 is:
rsChK.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
I'm pretty sure I inserted the code correctly. Any ideas? I'm desperately trying to undo an over-zealous archive session.
Thanks in advance< |
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 29 April 2008 : 13:50:57
|
Some versions of snitz don't have the field T_ARCHIVE_FLAG in the A_TOPICS (archives) table.
Can you comfirm the field exists. If its not there you will need to add it.< |
_-/Cripto9t\-_ |
 |
|
|
imperialdata
Starting Member
United Kingdom
15 Posts |
Posted - 29 April 2008 : 14:02:06
|
Thanks for the reply, no it's not in there. I can add a new column to the table and name it correctly but:
1. What do I need to set the cells to (and is there an easy way)
2. Does the column position matter, eg in the middle of the other colums or at the end?
I have Access 2007.< |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 29 April 2008 : 15:25:38
|
| ok, I'm not familiar with access. I'll write a little code that you can run through mod setup in admin options to add the column. Give me a few moments to look at the files to make sure I get it right.< |
_-/Cripto9t\-_ |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 29 April 2008 : 16:02:12
|
Its always a good idea to backup your database before you make any changes.
In admin options find "mod setup" and there is a link right beside it "(Alternative MOD Setup)". Open that and copy and paste this code in the textbox.[ALTER]
A_TOPICS
ADD#T_ARCHIVE_FLAG#smallint#NULL#0
[END] That should add the column.
I might add that the unarchive part of this mod never really got out of beta. All I know is that it works just fine with mySql. So its a use at your own risk mod. I don't believe it would hurt to try it though.< |
_-/Cripto9t\-_ |
|
|
|
imperialdata
Starting Member
United Kingdom
15 Posts |
Posted - 29 April 2008 : 17:26:53
|
| Thanks, will try asap.< |
|
|
|
imperialdata
Starting Member
United Kingdom
15 Posts |
Posted - 30 April 2008 : 06:35:34
|
Great Cripto, it worked fine thanks.
Now then, the problem I can see is that I have 40,000 posts archived. Each move back to the main forum requires a confirmation password. I want to move all archived topics back so that I can convert to a MySql database. Is there a way?
It may help that I have the pre-archive database, done some 4 months ago. I could possibly append the last 4 months of posts to that some way?< |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 30 April 2008 : 06:40:04
|
| Why do you need to un-archive all your topics? I've yet to see a conversion that's needed that...< |
|
|
|
imperialdata
Starting Member
United Kingdom
15 Posts |
Posted - 30 April 2008 : 12:02:51
|
| Because I then want to import some of the data to a PHPBB/MySql system and apparently this doesn't like archived topics.< |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 30 April 2008 : 13:56:09
|
| Ah. That would explain it.< |
|
|
|
imperialdata
Starting Member
United Kingdom
15 Posts |
Posted - 06 May 2008 : 16:20:02
|
| So anyone got an idea how I achieve this unarchiving of so many topics?< |
|
|
| |
Topic |
|
Topic Locked
