| Author |
 Topic  |
|
|
Nathan
Big Sky Guy
USA
15782 Posts |
 Posted - 04/27/2010 : 09:21:08
|
we have outgrown snitz. i could continue to mod the existing software but even the small requests you guys make can mean 4 hours of coding for me on a dozen different pages and even more if i make a small mistake and have to track it down. instead of trying to keep adding features to snitz, i am looking toward changing software all together.
im currently looking at PHPBB but there are others as well. other recommendations are welcomed, but the package must be compatible with windows based servers and MS SQL express.
in addition, anyone able to help me learn PHP and MS SQL as well as implimenting it into a windows based server, please step forward. |
 
"In the foolishness of my heart, I thought that the truth would be a defense." - Harold Fish |
|
|
lincoln
Junior Member
USA
126 Posts |
Posted - 04/27/2010 : 10:22:17
|
Maybe you've looked here already, but http://www.forummatrix.org/ is a good tool to compare different packages. The only hang-up is that is doesn't seem to show MS SQL Express compatibility. Either way, it's a really good place to start.
SMF is supposedly a good package, but only shows support for MySql. I like The High Road's forum, which is vBulletin, but it doesn't show support for anything other than mysql too. |
"Things may come to those who wait, but only the things left by those who hustle."- Abraham Lincoln |
 |
|
|
sidroski
Advanced Member
USA
2260 Posts |
Posted - 04/27/2010 : 21:11:19
|
| Can't help you with the coding but http://www.tek-tips.com/ is a user group that covers a lot of that when you run across a question. I use it get troubleshooting questions I run across on telecom equipment. Helped me with a couple C++ classes I took also. I notice they have a lot of software forums on there also. The voice guys are usually pretty good and get an answer for you from a fellow member if it is not in the FAQ's or you can't find it on a search of other user's questions. Good luck |
|
|
|
Chris_T
Senior Member
1901 Posts |
Posted - 04/27/2010 : 21:28:20
|
| Nate, as always you know i'll help you anyway I can. SQL is not my strongest suite but I may I may be able to help a little here. |
"A government strong enough to give you everything you want, is strong enough to take everything you have"
---Thomas Jefferson
"An armed society is a polite society. Manners are good when one may have to back up his acts with his life."
--Robert A. Heinlein
"Remember democracy never lasts long. It soon wastes, exhausts, and murders itself. There never was a democracy yet that did not commit suicide."
-- John Adams |
|
|
|
scrike83
Puts the cool in Coolhand
USA
2474 Posts |
Posted - 04/28/2010 : 01:11:24
|
| NO!!! I finally learned how to use this one and now we are changing? |
Molôn Labe!!!
“All that is necessary for the triumph of evil is for good men to do nothing.”
~Edmund Burke~
Support Our Troops, Until They All Come Home... http://www.youtube.com/watch?v=-L2vpiwvPYI
01/20/2013 "The end of an Error"
   |
|
|
|
LKline
Jew-Jitsu Master
USA
3342 Posts |
|
|
CodeJockey
Senior Member
USA
1067 Posts |
Posted - 04/28/2010 : 08:10:51
|
Nate, I like phpbb alot. Not from an administrative viewpoint, but from a users viewpoint, as many forums I participate in use it. As for MS-SQL. Please feel free to contact me any time for help with that. I'm a Microsoft developer on .Net and SQL Server. I've used MS-SQL exclusively for the last 10 years from a development perspective. I can easily help you with that. You can contact me at peter@armedtexan.com.
I sent you an email with my phone number too. Helping out with the forum is the least I can do to repay you for providing such a great asset to the concealed carry community. |
Always watch your six!
NRA Life Member
|
|
|
|
atinsley
New Member
USA
89 Posts |
Posted - 04/28/2010 : 10:06:05
|
quote:
Originally posted by lincoln
SMF is supposedly a good package, but only shows support for MySql. I like The High Road's forum, which is vBulletin, but it doesn't show support for anything other than mysql too.
I've created forums using both SMF and vBulletin and they are both very good software packages, but unfortunately they don't meet your requirements Nate. So, my next recommendation would be phpBB.
One of the other forums that I frequent is running phpBB, and they are currently supporting a community of over 19K members and over 1 million posts. It would serve the community here very well now and well into the future.
I don't think you would go wrong with that choice and I am willing to help you where I can. |
|
|
|
RexInTheCity
Starting Member
USA
36 Posts |
Posted - 04/28/2010 : 17:40:47
|
| phpBB should work well. I'm a php/MySQL developer so if you need any help just let me know; you can PM me or find me in the irc channel. |
- Springfield XDM 9mm Stainless/OD
- Remington 870 12-guage
- Nikko Model 7000 Golden Eagle .30-06
|
|
|
|
Nathan
Big Sky Guy
USA
15782 Posts |
Posted - 04/28/2010 : 20:02:53
|
thanks one and all for the support. rex, i know nothing of mysql and would prefer to use that with the new board. the problem is that ive tried to get it to play nice with windows and cannot. the documentation is thousands of pages that i dont have time to dedicate to. a mysql with windows for dummies tutorial would be great. i run win 2000 advanced server software.
peter, i was looking to go with ms sql hoping it would be a little easier to learn than mysql. assistance in this area would also be helpful. is there a way to get discount licensing on older versions of ms sql? as i understand it, ms sql express will only utilize 1 gig of server memory and im currently running 8 gigs in the server.
thanks, |
"In the foolishness of my heart, I thought that the truth would be a defense." - Harold Fish |
|
|
|
RexInTheCity
Starting Member
USA
36 Posts |
Posted - 04/28/2010 : 20:11:16
|
quote:
Originally posted by Nathan
thanks one and all for the support. rex, i know nothing of mysql and would prefer to use that with the new board. the problem is that ive tried to get it to play nice with windows and cannot. the documentation is thousands of pages that i dont have time to dedicate to. a mysql with windows for dummies tutorial would be great. i run win 2000 advanced server software.
I've never installed MySQL on windows before but from what I've read it is a pretty straightforward process. Send me a PM with the problems you've had and I'll look into it more. |
- Springfield XDM 9mm Stainless/OD
- Remington 870 12-guage
- Nikko Model 7000 Golden Eagle .30-06
|
|
|
|
CodeJockey
Senior Member
USA
1067 Posts |
Posted - 04/29/2010 : 08:24:37
|
quote:
Originally posted by Nathan
peter, i was looking to go with ms sql hoping it would be a little easier to learn than mysql. assistance in this area would also be helpful. is there a way to get discount licensing on older versions of ms sql? as i understand it, ms sql express will only utilize 1 gig of server memory and im currently running 8 gigs in the server.
thanks,
Unfortunately, there's no way to do it without buying it off ebay or similar for a cheaper rate. I would probably not go earlier than sql 2000. For what you're needing, you really would need to use SQL Server 2008 Web edition for 1 CPU, and the cheapest I've seen it is about 1800.00. |
Always watch your six!
NRA Life Member
|
|
|
|
Nathan
Big Sky Guy
USA
15782 Posts |
Posted - 04/29/2010 : 08:29:52
|
| so...ultimately i would be better off learning MySQL (free). back to square 1. argh. |
"In the foolishness of my heart, I thought that the truth would be a defense." - Harold Fish |
|
|
|
CodeJockey
Senior Member
USA
1067 Posts |
Posted - 04/29/2010 : 11:39:03
|
| Cost wise you would definitely be better with MySql. What are you currently running for this forum's database? If you don't know MS-SQL, and you don't know MySql, then there is probably very little difference in the learning curve for each product. Now, that said, I'm not sure that RAM consumption of what you described with your current process (which would be a limiting factor on SQL express) would be that big a deal. I'd have to review some specs on it. The actual db size might be though. |
Always watch your six!
NRA Life Member
|
|
|
|
Nathan
Big Sky Guy
USA
15782 Posts |
Posted - 04/29/2010 : 12:09:07
|
are you sitting down? we're running this forum on MS Access.
...no, im not bull ting you. this is another reason why we have outgrown this package. thus far ive overcome the limitations of access by using really good hardware (dual core processor on 8 gigs of ram) but we're reaching the limitations of that as well. |
"In the foolishness of my heart, I thought that the truth would be a defense." - Harold Fish |
|
|
|
RexInTheCity
Starting Member
USA
36 Posts |
Posted - 04/29/2010 : 13:11:19
|
Dual core and 8gigs should be plenty for this forum and the others you have. Access is probably eating up a lot of resources.
Switching to MySQL seems like your best option. MS SQL and MySQL are both based on SQL so there isn't much of a difference when actually using them. Setting up MS SQL might be easier than MySQL but databases in general are a bitch to install because they are complex pieces of software with a million settings. If you need help getting MySQL running I would be happy to take a turn at installing it, assuming you don't mind giving me remote access. |
- Springfield XDM 9mm Stainless/OD
- Remington 870 12-guage
- Nikko Model 7000 Golden Eagle .30-06
|
|
|
|
CodeJockey
Senior Member
USA
1067 Posts |
Posted - 04/29/2010 : 14:00:46
|
| Wow, MS-Access is also limiting in DB Size, so based on that, i really think you might be able to do what you want w/ SQL Express, but honestly, since the learning curve is essentially the same, why go with one that is limiting when MySql isn't. I would definitely agree that Access is consuming extra resources that you won't incur with either version of SQL. Another option would be a hosted solution. There are any number of providers out there that charge a monthly fee to host PHPBB (and multiple other products). I have no idea how much you spend in internet usage for this forum, so that may or may not be worthwhile. But it's something to look at. |
Always watch your six!
NRA Life Member
|
|
|
|
Nathan
Big Sky Guy
USA
15782 Posts |
Posted - 04/29/2010 : 15:40:16
|
im currently running on an asynchronous 10/3mbps commercial cable connection that is costing me around $300 a month. the price has since been lowered to $200 a month but when i switched over i signed a contract for 3 years so im locked in there for 2 more years. with the services we offer (forums, pages, chat, and especially hosting full length videos ripped at 1 mbps) we consume a lot of bandwidth so the 3 mpbs upstream is a minimum requirement.
i would love to be able to use MySQL but know nothing about it and certainly dont know how to make it play nice with windows operating systems. i need a tutorial that will walk me through it literally from step one.
although our hardware can currently handle our load, there are times when it just cant (ill be more specific on that after we are on a more robust DB).
im not interested in leasing server space on somebody elses server. i would prefer to learn it and do it all myself. |
"In the foolishness of my heart, I thought that the truth would be a defense." - Harold Fish |
|
|
|
RexInTheCity
Starting Member
USA
36 Posts |
Posted - 04/29/2010 : 17:55:29
|
| I just sent you an email with nice tutorial for installing MySQL on Windows. |
- Springfield XDM 9mm Stainless/OD
- Remington 870 12-guage
- Nikko Model 7000 Golden Eagle .30-06
|
|
|
|
jmj217
New Member
USA
60 Posts |
Posted - 05/01/2010 : 12:49:53
|
PHPBB has really good support and works like a champ. I use it for my forum and it has worked out well. I wish I could help you with SQL but I leased server space and was able to automatically install the forum without having to learn SQL. The phpbb website has very good instructions for modifying the forum after it is installed.
I leased server space since I don't really have any interest in databases/servers. It is only about $3/month but I'm sure it doesn't have near the performance that your server has.
Good luck with the transition. I think you will be happy with phpbb. |
The Stupid Shall be Punished. |
|
|
|
Pecos Bill
Starting Member
USA
32 Posts |
Posted - 08/11/2010 : 12:47:18
|
http://www.simplemachines.org/
SMF is written in the popular language PHP and uses a MySQL database. It is designed to provide you with all the features you need from a bulletin board while having an absolute minimal impact on the resources of the server. SMF is the next generation of forum software - and best of all it is and will always remain completely free!
Here is a forum using the product.. http://www.taurusarmed.net/forums/index.php |
IN GOD WE TRUST
"Live well, love deeply and laugh often" |
|
|
| |
Topic |
|
forum software
