Why is the site always slow?
- Thread starter Stereodude
- Start date
Mercutio
Fatwah on Western Digital
The site has been horrible for the last hour or so. This page took about six minutes to load so that I could post this.
The slowdowns come and go. It was fast and then slowed again a couple of minutes ago. I don't think there is anything wrong with my system because other sites are loading quickly at the same times. Sorry if it sounds like I'm complaining.
BingBangBop
Storage is cool
- Joined
- Nov 15, 2009
- Messages
- 667
Is this simply an indirect way of passing the hat to pay for the site? Is it that you are not interested in the job any longer and want someone else to take over?
It was a complicated statement. I don't have the will/time to track down why this host is having performance issues at odd hours, nor do I have the time to try a bunch of other hosting service to figure out which ones would be better. In part I'm not feeling like the money spent on this current host is worth it any more. I'm not indirectly asking anyone to pay for the site, but I've also recently (in the past few months) been debating not wanting to run/manage this site any more.
ddrueding
Fixture
Well, I'm sure many here would be happy to contribute to keep the place alive (as many have in the past). I would volunteer my services to keep the place running, but I do not have the necessary skills. Perhaps additional steps could be taken to reduce the workload?
timwhit
Hairy Aussie
I am happy to help as well, monetarily and with time.
Oh that is terrible. First the MBF now this.Anything that I can do in the next months?
There is nothing terrible happening. I wouldn't just turn the site off without at least making efforts to offering it to someone else withing the community to continue. That would be a huge dick move. I haven't made up my mind one way or another, I was just speaking out loud. There's nothing to worry about at the moment.
ddrueding
Fixture
We can start discussing ways to make it easier for Doug and faster for all of us.
Require registration to start with an e-mail to a mod?
Colo a dedicated server?
I'm assuming the bulk of the admin duties are dealing with SPAMers?
This place is important to me. I would happily send $10-25/mo to make it better, and could donate a rather beastly machine for the purpose.
Require registration to start with an e-mail to a mod?
Colo a dedicated server?
I'm assuming the bulk of the admin duties are dealing with SPAMers?
This place is important to me. I would happily send $10-25/mo to make it better, and could donate a rather beastly machine for the purpose.
I looked into colocation many times but the cost of the service was the issue, not the hardware, though I do appreciate the offer to donate a beastly machine. If we can find a reasonable colocation area, maybe we can build a dedicated machine through donations or something?
Spammers are an issue and I've been trying to find better ways to reduce them. There are improvements that can be made. I spent a few hours last Saturday troubleshooting some code, but I made no changes or progress yet. I have a list of things I need to change/implement to make it a little better.
This topic should move to its own thread for better visibility.
ddrueding
Fixture
Not sure what to call it? We already have a "changes..." thread as well?
Perhaps "2011 refresh"?
Perhaps "2011 refresh"?
timwhit
Hairy Aussie
If you want help I have a decent amount of PHP development experience (though Java is much preferred for me).
Thanks timwhit, I'll let you know. The problem is more related to figuring out the vbulletin environment more-so than php specifically. I haven't spent enough time with their plugin system yet to call it quits. The forum doesn't run anything which contains java, so there's nothing to work on there.
Which leads me to my next issue. Due to some fiasco with vbulletin changing owners and a change in their licensing structure, I've not upgraded anything in a while. Since they've migrated to version 4.x, they've cut off support and updates to 3.8 owners unless if we buy a license for 4.x. I don't feel the need to spend several hundred dollars to upgrade to the latest version because we don't really need any of the new features and changes.
Which leaves me at a loss on how to update and advance. One alternative would be to move over to an open source forum software that has continued development and support. I would like to change as little as possible because I know people don't like change. I also don't want to change just for the sake of changing, but we should be getting updates to software as they find issues.
Another complication is I really like the plug in I'm using right now for spam management. They even have updates but they require vbulletin 4.x which puts me out of luck unless I take the code and hack it to work with this current version.
timwhit
Hairy Aussie
I've done some admin work with phpBB3. It has a large community of developers and many free plugins. I bet there are even vBulletin to phpBB3 migration scripts out there.
I'm going to setup a demo of phpbb3 and try importing our database. The area where I would need to research and possibly receive help with is the registration system.
Upon registration of new accounts I would want the username, IP address, and email checked against an API to see if they exist in the StopForumSpam database. I understand the code which does this now in vbulletin, but I'd need it to do the same in phpbb3.
Upon registration of new accounts I would want the username, IP address, and email checked against an API to see if they exist in the StopForumSpam database. I understand the code which does this now in vbulletin, but I'd need it to do the same in phpbb3.
Stereodude
Not really a
I just wanted to post and say I appreciate all the work / time / effort / money Doug has put into the forum and will help out in any way I can.
I actually have been running that all morning to test an import.
Sadly it failed with this error that i need to track down.
Code:
General Error
SQL ERROR [ mysqli ]
Out of range value adjusted for column 'poll_option_id' at row 1 [1264]
SQL
insert into phpbb_poll_options (poll_option_id,topic_id,poll_option_text,poll_option_total) values(128,6666,'Yes',9)
BACKTRACE
FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()
FILE: install/convertors/functions_vb30.php
LINE: 56
CALL: dbal_mysqli->sql_query()
FILE: install/install_convert.php(1654) : eval()'d code
LINE: 2
CALL: vb_import_polloption()
FILE: install/install_convert.php
LINE: 1654
CALL: eval()
FILE: install/install_convert.php
LINE: 799
CALL: install_convert->jump()
FILE: install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()
FILE: install/index.php
LINE: 409
CALL: install_convert->main()
FILE: install/index.php
LINE: 286
CALL: module->load()time
Storage? I am Storage!
Doug, vBulletin upgrade pricing is $175 + $80/year for email support.
I'm guessing that you've become increasingly unhappy about the product or the company over time?
I'm guessing that you've become increasingly unhappy about the product or the company over time?
time
Storage? I am Storage!
Casting problem?
I'm actually happy with the forum we're using right now. I didn't like the events that unfolded when they sold the company. The move to vbulletin 4.0 (at that time) wasn't much of an upgrade for what they were charging and then they required the larger upgrade price in order to even get the older forum updates. For me to even get patches and updates to 3.8.x (which is where we are), I'd have to pay the full upgrade. I'm happy to consider the latest version of 4.1.x but I was making a guess people would hate how it looks.
I don't think it was a casting issue. I looked in the DB and that phpbb3 field is set to tinyint(4) and the value the converter tried inserting was '128,6666'. I'll need to see why the value is so high or maybe something was parsed incorrectly.
I tried to manually add the value into the database and I do get an error:
1 row(s) inserted.
Warning: #1264 Out of range value adjusted for column 'poll_option_id' at row 1
it is out of range:
tinyint allows for a value between -128 and 127 when signed.
1 row(s) inserted.
Warning: #1264 Out of range value adjusted for column 'poll_option_id' at row 1
it is out of range:
tinyint allows for a value between -128 and 127 when signed.
Bozo
Storage? I am Storage!
If there is anything we can do to help, please let us know.
What are the hardware requirements for a web site server?
What are the hardware requirements for a web site server?
time
Storage? I am Storage!
i.e. you were inadvertently trying to cast a SmallInt as a TinyInt.
Out of curiosity, is the value 128 because it's part of a sequence for all possible poll options in the data? Cause on the face of it PhpBB is using a compound key of topic_id + poll_option_id instead. I guess it shouldn't matter because the key will still be unique.
Out of curiosity, is the value 128 because it's part of a sequence for all possible poll options in the data? Cause on the face of it PhpBB is using a compound key of topic_id + poll_option_id instead. I guess it shouldn't matter because the key will still be unique.
Thanks Bozo. The requirements are rather minimal. One to two CPUs (2-3GHz), 512MB-1GB memory and 30-100GB of disk space (RAID 1 preferred) and less than 100GB transfer per month.
I haven't looked into what it's actually for, but the number range seems rather small to me. I was able to complete the conversion and things seem to be working. If you want to check it out, it's here.
time
Storage? I am Storage!
It really isn't practical or affordable for us to use our own hardware. Rack space at an ISP ain't cheap and they may not allow anyone onsite to maintain the hardware.