I'm to Dolphin, so I ask for your help. About 5-7 days ago I installed Dolphin 6.1 and after that I wasn't working on it. During this time (till today) I didn't receive any errors, the installation process went smoothly. But today I got 2 emails: 1 with subject "Database error in MY SITE" and another one - from cron in which it is said, that some errors occured.
I copied the whole texts of each emails.
1-st
====================================================
Database error in MY SITE
Mysql error:
Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/MY_ACCOUNT/public_html/MY_SITE/periodic/cupid.php
[line] => 22
[args] => Array
(
[0] => /home/MY_ACCOUNT/public_html/MY_SITE/inc/db.inc.php
)
[function] => require_once
)
)
Called script: /home/MY_ACCOUNT/public_html/MY_SITE/periodic/cupid.php
Request parameters:
Array
(
)
--
Auto-report system
========================================================
And the 2-nd one:
========================================================
<div style="border:2px solid red;padding:4px;width:600px;margin:0px auto;">
<div style="text-align:center;background-color:red;color:white;font-weight:bold;">Error</div>
<div style="text-align:center;">Database connect failed</div>
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/MY_ACCOUNT/public_html/MY_SITE/inc/db.inc.php on line 228 <div><b>Mysql error:</b><br /></div><div style="overflow:scroll;height:300px;border:1px solid gray;"><b>Debug backtrace:</b><br /><pre>Array (
[1] => Array
(
[file] => /home/MY_ACCOUNT/public_html/MY_SITE/periodic/cupid.php
[line] => 22
[args] => Array
(
[0] => /home/MY_ACCOUNT/public_html/MY_SITE/inc/db.inc.php
)
[function] => require_once
)
)
</pre>
<b>Called script:</b> /home/MY_ACCOUNT/public_html/MY_SITE/periodic/cupid.php<br /><b>Request parameters:</b><br /><pre>Array (
)
</pre>
</div> </div>
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/MY_ACCOUNT/public_html/MY_SITE/inc/db.inc.php on line 251
==============================================================
I tried to search for something, but couldn't find anything because I don't know what does it mean and what search.
Hope, your answers will help me to solve this errors.
Thank,
ED
|
it's very strange, because it's a fresh installation and as I understood, that errors were caused by the cron jobs. so I wonder, why did this errors appear only once though cron jobs were done every day previuosly?
Can it be connected with hosting problems? because I got a statistics that says that there was a time that my site was off
|
Hello ED5,
I'm not an expert on PHP or Cron Jobs and SQL queries etc but I was just reading through your error and I believe this might be your problem.
/home/MY_ACCOUNT/public_html/MY_SITE/inc/db.inc.php
/home/MY_ACCOUNT/public_html/MY_SITE/periodic/cupid.php
^ Check your file permissions for the two files above.
Cupid.php is the script I assume is the Cron job? However I believe the server/script cannot read the file as you can prob can tell there's an 'include' for the db.inc.php file however if this cron job cannot fetch the file regardless, it will attempt to perform the cron job. And the reason for the errors is because those variables/tables etc don't exsist because it was never able to include the database file.
Sorry, if I confused you there. :P
Overall, check those 2 files permissions. :)
Check the manual! and make sure the server/power user can execute them.
|
thanks, I'll try ad post a result here. but how can I check is it working or not? becuase I got this error only once, though the scrypt must be working everyday
|
Yes, you were right. I do remember that set them all as it was recommended in the installation instruction. but now when I checked them I saw that all the files that must have 644 permissions, have 444 permissions. so, I apologize for distracting you from smth. by the way, what do you now about Arvixe hosting? thanks, if anything occure, I'll tell you and we reopen this topic about errors if you don't mind :) |
Yes, you were right. I do remember that set them all as it was recommended in the installation instruction. but now when I checked them I saw that all the files that must have 644 permissions, have 444 permissions. so, I apologize for distracting you from smth. by the way, what do you now about Arvixe hosting? thanks, if anything occure, I'll tell you and we reopen this topic about errors if you don't mind :)
Well I'm happy I was able to assist you. :)
As for your question about Arvixe hosting, personally I have never used them before but I did a quick google and I checked out their plans.
Too be honest I'm a bit skeptic when it comes to webhosting a lot of hosts do something reffered to as overselling a classic example and the most common form of overselling is when the host clasify their plans as "Unlimited" these hosts always assume that majority of their customers wouldn't use more then a few gigs of bandwith a month. However I've heard stories of hosts cancelled customers plans because they had over used.
My advice is to be careful, I recommend checking out a few sites that have feedback ratings of common web hosts.
My personal advice is to get a VPS. Yes they may be a tad more expensive but you can pretty much do anything you want with them, and you can run pretty much anything including a Ray media server. Often VPS plans will have a cap on bandwith for example 200gig a month.
I do web hosting off my VPS so there's multiple sites along with IRC + Ray + IRC bots etc and we use less then 10 gig a month. My cap is 500 gig a month and I know that whole 500 gig is allocated to me with no questions about it and my host (not like they would) can't say i've over used the resources.
Get the picture? :P
Take care mate.
|
Well, you know, I don't have a lot of experience with hosting and software. So I chose Arvixe because there was a necessety to have RMS server and hostgator at that time didn't offer that to me. ( on a day I transfered all data to Arvixe, Gator emailed me telling 'now all our customers can install RMS on their shared servers :) That time I didn't think that I can get a VPS and have everything I want. :) so, now I know it. it would be cool if I knew how can I do everything I want to be done in advance :) so, now I'm planning to use Arvixe 'shared' services till the time I create the whole site and then I'll get business or VPS.
by the way, have you ever seen a web site guilt on Dolphin and that had a lot of people using A/V chat? how much people can use A/V simultaneously (that is in different rooms of course)?
|
Well, you know, I don't have a lot of experience with hosting and software. So I chose Arvixe because there was a necessety to have RMS server and hostgator at that time didn't offer that to me. ( on a day I transfered all data to Arvixe, Gator emailed me telling 'now all our customers can install RMS on their shared servers :) That time I didn't think that I can get a VPS and have everything I want. :) so, now I know it. it would be cool if I knew how can I do everything I want to be done in advance :) so, now I'm planning to use Arvixe 'shared' services till the time I create the whole site and then I'll get business or VPS.
by the way, have you ever seen a web site guilt on Dolphin and that had a lot of people using A/V chat? how much people can use A/V simultaneously (that is in different rooms of course)?
To be honest mate, I don't have a clue as I haven't seen any busy dolphin sites.
But while we're on the subject I'll say this. :P
Dolphin sites are very slow in general, chat, video, boards - they all load pretty slow compared to other applications out there. But they may run slow due to 'loops' etc in coding or it could be the type of server and limitations in place. If you're hosting dolphin on a shared host or any host as a matter of fact your gonna be limited to either:
- Bandwith
- Memory (if you're even allowed to run background process's eg: RAY)
- Hardrive space
- Hardware
- Software
And I'll be honest, you wouldn't have much say over the memory/bandwith etc you've been allocated with.
I'll cut to the chase,
You get what you pay for!
If you pay $4 for web hosting then you can't expect yourself to be hold up like MySpace or FaceBook.
But since I pay $40~ a month for my hosting, you can expect that I'll be able to do more and be more stable and faster.
This goes back to my last post about getting a VPS - I have control. No one can tell me I'm hogging too much of one thing. If I want a ray server to use up a gig of ram, so be it!
If you want to host 100's of users, be prepared to pay a fair bit of cash otherwise your site will be SSSSLLLOOOOWWWW! :P
|
Opie, I'm with Prince on this one to a point. All my sites run on a Cluster of Dedicated servers, I maintain 2 VPS servers for the sole purpose (most of you didn't know that trick I have) of running incubator sites that are purely in the build phase, nothing else. I do this so that I can maintain control over what's in build phase and run it quite easily and nicely without the hassle of being limited by bandwidth, processor loads, memory and so on. However, there are limits to a VPS as there are with shared hosting:
1. You must purchase more memory as your site grows or it will run like it's on a shared host.
2. Lower bandwidth limits than Dedicated Servers get, however s till much higher than Shared Hosting.
3. They are still a type of Shared environment, thus susceptible to hacking, just not as easily as Shared Hosting.
Now, if you want your site to run well and stand a chance, then you do need to get away from the $4.00 a month plans and move up to the VPS as Prince is explaining to you. Once your site is built and production ready, you can leave it for a little while to help it grow on the VPS without concern, keep in mind though that one day you will have to move it to a Dedicated and then a cluster of Dedicateds to make sure it runs perfectly. And no, I don't have to have this Cluster right now, I just do because it's fun to have.
|
Opie, I'm with Prince on this one to a point. All my sites run on a Cluster of Dedicated servers, I maintain 2 VPS servers for the sole purpose (most of you didn't know that trick I have) of running incubator sites that are purely in the build phase, nothing else. I do this so that I can maintain control over what's in build phase and run it quite easily and nicely without the hassle of being limited by bandwidth, processor loads, memory and so on. However, there are limits to a VPS as there are with shared hosting:
1. You must purchase more memory as your site grows or it will run like it's on a shared host.
2. Lower bandwidth limits than Dedicated Servers get, however s till much higher than Shared Hosting.
3. They are still a type of Shared environment, thus susceptible to hacking, just not as easily as Shared Hosting.
Now, if you want your site to run well and stand a chance, then you do need to get away from the $4.00 a month plans and move up to the VPS as Prince is explaining to you. Once your site is built and production ready, you can leave it for a little while to help it grow on the VPS without concern, keep in mind though that one day you will have to move it to a Dedicated and then a cluster of Dedicateds to make sure it runs perfectly. And no, I don't have to have this Cluster right now, I just do because it's fun to have.
Hehe, I agree clusters would be the best solution for high traffic dolphin sites or any other site frankly.
Here's an overview of 'clustering' : http://www.boonex.com/trac/dolphin/wiki/DolphinCluster for you ED5 in case you were interested.
|
Well, you know, I don't have a lot of experience with hosting and software. So I chose Arvixe because there was a necessety to have RMS server and hostgator at that time didn't offer that to me. ( on a day I transfered all data to Arvixe, Gator emailed me telling 'now all our customers can install RMS on their shared servers :) That time I didn't think that I can get a VPS and have everything I want. :) so, now I know it. it would be cool if I knew how can I do everything I want to be done in advance :) so, now I'm planning to use Arvixe 'shared' services till the time I create the whole site and then I'll get business or VPS.
by the way, have you ever seen a web site guilt on Dolphin and that had a lot of people using A/V chat? how much people can use A/V simultaneously (that is in different rooms of course)?
To be honest mate, I don't have a clue as I haven't seen any busy dolphin sites.
But while we're on the subject I'll say this. :P
Dolphin sites are very slow in general, chat, video, boards - they all load pretty slow compared to other applications out there. But they may run slow due to 'loops' etc in coding or it could be the type of server and limitations in place. If you're hosting dolphin on a shared host or any host as a matter of fact your gonna be limited to either:
- Bandwith
- Memory (if you're even allowed to run background process's eg: RAY)
- Hardrive space
- Hardware
- Software
And I'll be honest, you wouldn't have much say over the memory/bandwith etc you've been allocated with.
I'll cut to the chase,
You get what you pay for!
If you pay $4 for web hosting then you can't expect yourself to be hold up like MySpace or FaceBook.
But since I pay $40~ a month for my hosting, you can expect that I'll be able to do more and be more stable and faster.
This goes back to my last post about getting a VPS - I have control. No one can tell me I'm hogging too much of one thing. If I want a ray server to use up a gig of ram, so be it!
If you want to host 100's of users, be prepared to pay a fair bit of cash otherwise your site will be SSSSLLLOOOOWWWW! :P
Yes, I agree with you. I chose this shared plan onlyfor beginning, while I'll create everything I need and then move it to more professional plan.
|
Oh, thanks, Prince! I checked and found very useful. By the way, I really understand that the more powerful servers I have, the more quality I have. I asked this questions because didn't knew anything about Dolphin. Day after day I receive more and more info and understand all thing layers of programming and web site hosting.
Thanks a lot!!!
|
Oh, thanks, Prince! I checked and found very useful. By the way, I really understand that the more powerful servers I have, the more quality I have. I asked this questions because didn't knew anything about Dolphin. Day after day I receive more and more info and understand all thing layers of programming and web site hosting.
Thanks a lot!!!
Your close to understanding, but not quite there. Server power is only part of it. You can have a Xenon Quad Core liquid Cooled processor in there with 1Terabyte of memory on the machine, but if your on a shared machine with 10,000 other sites then your going to be in a world of horse excrement as they will also be sucking up resources faster than a tornado can relocate a trailer park.
What we are saying here is to move out of that Trailer Park and get yourself a nice little place over in VPS Gardens, that will serve you quite well. You might still be sharing your water & sewer services, but at least you'll have your own electric & gas, even if it's a 386 server with 10GB of memory, at least you know there are only 9 other units sharing your utils versus 10,000.
Hope you get out of the park before the tornado relocates it.
|
Oh, thanks, Prince! I checked and found very useful. By the way, I really understand that the more powerful servers I have, the more quality I have. I asked this questions because didn't knew anything about Dolphin. Day after day I receive more and more info and understand all thing layers of programming and web site hosting.
Thanks a lot!!!
Your close to understanding, but not quite there. Server power is only part of it. You can have a Xenon Quad Core liquid Cooled processor in there with 1Terabyte of memory on the machine, but if your on a shared machine with 10,000 other sites then your going to be in a world of horse excrement as they will also be sucking up resources faster than a tornado can relocate a trailer park.
What we are saying here is to move out of that Trailer Park and get yourself a nice little place over in VPS Gardens, that will serve you quite well. You might still be sharing your water & sewer services, but at least you'll have your own electric & gas, even if it's a 386 server with 10GB of memory, at least you know there are only 9 other units sharing your utils versus 10,000.
Hope you get out of the park before the tornado relocates it.
Great picture! You are really like Pablo Picasso in a hosting consulting :) Yes, I understand your trick to move out a technic language and level to more amateur. And thanks for that. I think, that this explanation is worth of good some of money and some hosting providers can use it in their advertisements.
Moving back to our discussion, I understand this as following, 'Move to VPS as fast as you can to save time and nerves'. And I'll take your advice.
|
