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: MOD Implementation
 active user mod implementation failed.
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

whitty
Starting Member

22 Posts

Posted - 26 September 2008 :  18:05:19  Show Profile  Visit whitty's Homepage
I just installed active users mod to forum and it seemed to work for a minute then crashed.
I think the dabse has crashed and am unsure how to access it/ restore it or even if I have a recent backup since I only use ftp.

The first few steps which get you to update dbase may have been the issue. I got the following error message after I selected.

There should be a select form object in the center of the file. Select "Active Users 4.0.1 for Snitz 3.4 compatable"
Make sure the checkbox is checked.
Click Update!
Error message


During -2147217900 | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(1) NULL' at line 1



Any idea what went wrong the whole forum is down now and active user mod appeared to work for a short while.
<

Edited by - whitty on 26 September 2008 18:06:36

whitty
Starting Member

22 Posts

Posted - 26 September 2008 :  18:15:07  Show Profile  Visit whitty's Homepage
Forgot to mention the site with the issue post active user mod is:
http://www.sisiphone.com/snitz/default.asp
<
Go to Top of Page

Etymon
Advanced Member

United States
2385 Posts

Posted - 26 September 2008 :  18:28:27  Show Profile  Visit Etymon's Homepage
Undo the file changes you made to get your forum back running again. You need to get a hold of the host since FTP limits you to files and directories.<
Go to Top of Page

whitty
Starting Member

22 Posts

Posted - 26 September 2008 :  19:13:50  Show Profile  Visit whitty's Homepage
what changes do i need to undo?
Would the host have more files than me?
I can manually change the asp files back again i manually edited during mod.
but how to i restore or fix dbase as I beleive this is the problem?<
Go to Top of Page

whitty
Starting Member

22 Posts

Posted - 26 September 2008 :  20:51:24  Show Profile  Visit whitty's Homepage
good news.
I changed all the manually edited file back. And it seems to work again. I did not change the dbase as I not sure how to access it.
Now I am back to dbase error from post 1 when it tried to update.
And how I can safely backup or restore dbase in future. So I can try mods without running into trouble again.

The active user mod seemed good but I am reluctant to try it again with out being able to back up dbase somehow.<
Go to Top of Page

whitty
Starting Member

22 Posts

Posted - 27 September 2008 :  05:48:00  Show Profile  Visit whitty's Homepage
Ok

Change of plans now. WHilst I liked the snitz forum it just was not fully compatiable with companys linux hosting.
Unfortuantely I will now be converting snitz over to a php forum so no longer require the planned active user mod.

Thanks
<
Go to Top of Page

thelodger
Junior Member

United Kingdom
296 Posts

Posted - 20 March 2009 :  11:14:03  Show Profile
OK, after I have installed the new base forum, I am attempting to add active users, I also get this error when doing a database setup, will this be a problem or should I just change the files and see what happens?
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.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07