Top 5 Things To Say About Any Dedicated Server Provider

Nov 4, 2009

My friend asked me that, "Hey! How are you doing? I am thinking about buying hosting from this new-webhosting-company-to-me.com . What do you think?"

I replied him that,

"Well, I had a server with them.. Let me tell you something about them,"

"Value for money: 4/5 points" (their hardwares are worthy)
"Setup Time: 3/5 points" (they took 2 days to setup. But i read 24 hours setup time on their homepage)

"Friendly Support: 5/5" (those dudes were skill full and friendly when i asked for os reinstall and other support requests)

"Datacenter/Infrastructure: 4/5" ("good network and I got 2 hours downtime only once")

==================================

Well, I said above 4 things to consider, before buying from a host.

What would be your top 5 considerations about any host to recommend your friend?

View 14 Replies

Things To Ask A Vps Provider

Jan 18, 2008

I have been researching the vps market for a month or so now and have started to compile a list of questions to put to vps providers who get short listed. I would love some contributions!

1) What is the cpu and how is cpu capacity distributed, by account number limits, by assigning a certain number of mhz, is the asisgned capcity burstable?

2) ram is usually clearly advertised but who scalable is it? Can you add just extra ram or do you need to upgrade to the next package. Is it burstable and with what constraints.

3) are there any limits for the number of processes (shared hosting providers may limit processes to only a few, 15 for instance before terminating them). This isnt advertsised but need to be answered for dynamic sites with high traffic.

4) Number of simaltanious connections, both from individual Ips to the sites/account or to pop3 accounts. If the pop3 account sim con is low its will be annoying when trying to donwlaod email from several of your sites at the same time....attempts after the X number will fail.

5) Will your account have assigned bandwidth or will you just be sharing whatever connection 10/100mbps with the other uses on the server. This isnt such a big deal as a lot of servers will be streched to output 100mbps of data. If the connection is a 10mbps one then its much more important.

6) if you're used to a certain type of control panel make sure they have it and at what possible extra cost.

7) Check their terms and conditions for liability regards lost data. I chose a hosting company beofre because of their superior back up system, turns out they didnt use it and I lost 5 weeks of data (about $4000 loss for me). Their t & C avioded libility for any losses inspite of the fact that they advertises the b/u facility as a special feature.

8) quiz them on "Monitoring" and "Management". Us hosting novices may see these as the same thing but hosting companies do not. Monitoring is knowing that something is wrong, management is doing something about it. Many vps providers advertise full management but wait to be asked to fix problems that could have been lossing you money for days till one of your kind users lets you know.

9) What is their infrastructure...power, location, connectivity redundency like (ie how many T1,2 or 3 do they have and is that enough).

10) Support. Is it in house or outsourced....the later is bad as they are usually given little power to do anything and you have to wait longer for an inhouse guy to get off his lazy boy.

11) Do they limit the number of emails per period (ie like 500 per hour). This wont affect some but for those of us who have large memberships to send newsletters to this is a non starter.

View 3 Replies View Related

Dedicated Server Provider

Sep 30, 2008

requirement:

512M+ memory
1T+ bandwidth per month
budget: USD $50~60 per month

View 5 Replies View Related

Best Dedicated Server Provider

Oct 22, 2008

Our company are soon to launch and we are in desperate need of a dedicated server so our coder can code all of our sites and upload them. We have a server with thevpsguy.com which has been down since last Monday! I have only received very limited support from Ian the owner and now I am beginning to give up hope on him sorting anything out because he ignores all my emails and makes false promises.

Who are the best dedicated server providers?

I want someone with good support, but I still like the personal touch so not huge companies.

View 6 Replies View Related

Cheapest Dedicated Server Provider

Oct 19, 2009

Who is the cheapest and best Dedicated Server Provider.

View 14 Replies View Related

Hosting/ Dedicated Server Provider With DB Support

Dec 18, 2008

I have several sites with Godaddy, but their lack of any real support leaves something to be desired. Does anybody know of a decent provider that has options for database support (mysql) and the like?

View 11 Replies View Related

Dedicated Server Provider On The East Coast (US)

Mar 25, 2008

Most of our customers are going to be accessing the server from Europe and Asia and North Carolina, so I am looking for a dedicated server provider on the east coast.

I'd like KVM, network storage, remote backup if possible.

View 8 Replies View Related

Fed Up With Hostgator Can Any One Suggest Best Managed Dedicated Server Provider

Aug 5, 2008

This is first time i am writing about hostgator using there service since 4 years.

I have 3 dedicated servers purchased with them within last 6 months and orderd for 4th server on 31st Aug 08. And now as business is growing i will need more and more servers every 2- 3 month. But its seems hostgator is not interested in business as they had already grown now. Even they don't care of their loyal customers who are them with years.

On 3rd day of orderd they told me my server will be deliverd within next 24 hours and on 4th day i contact them serveral times they keep on repiting they will upate and then they said server is out of stock and will be available soon and today is 5th day still there is no reply from them and when i contact them they clearly have no idea about it. Some says will get it soon and when i show my ticket. they say its still out of stock . When i contact with theplant.com datacenter they told me the server is available to order and are never out of stock.

I dont know whats actual reason.

Please help me guys to find good manage dedicated server host so i can cancel my order with them and go to another good company.

View 14 Replies View Related

Co-Location & Dedicated Server Service Provider Game

Jun 3, 2007

This is serious, please do not find the thread as SPAM, waste of time, or useless. I'm doing my research while at it.

Current Provider: ThePlanet
CPU: Dual Core 3.2GHz (seeking 2.8GHz Dual Core or better)
Memory: 1GB (seeking 1GB or more or better; unknown technical specs)
Harddrives: 400GB Harddrive (seeking 400GB or more or better)
Cost: ~$320/month (seeking at this price or cheaper)
Bandwidth: 1500GB @ 100Mbps (seeking more than 1500GB, but @ 100Mbps)

So help me find providers other than ThePlanet (good hosting, but not good enough to help advance the webhosting business through over-selling). I am seeking for specs at, around, or close to the ones I gave above (monthly fee also). Reliability is a very important factor!

View 8 Replies View Related

How Can I Know My Hosting Provider Give Me A Real Dedicated Server, Not A Vertual One

Dec 5, 2007

Not a virtual machine, sorry for typo. The OS is Fedora,

View 8 Replies View Related

European Dedicated Provider Like TMS

May 12, 2009

We use Tailormadeservers.com in the US and are looking for a similar flexible provider in the UK / Europe. Basically looking for a reliable provider who allows you to pay down the price of the server and also allows you to pay for RAM / RAID upgrade with one setup fee.

View 6 Replies View Related

Is There Any Other Dedicated Provider Like Netrackserver

May 26, 2008

to get Dedicated server like netrackservers? Is there any other host who provides same server configuration or somewhat like netrackserver?

give your review about netrackservers?

View 5 Replies View Related

UK Provider Dedicated Servers

Nov 15, 2008

Search provider located in UK specialized in rent mark of Supermicro of dedicated servers.

To be possible more next (al lado) of Espagne.

View 4 Replies View Related

New Netherlands Dedicated Hosting Provider

May 14, 2009

We've been reading this site for awhile a colleague, who is a member, suggested we post a request here. We are looking for a NETHERLANDS-based dedicated server hosting company (which, obviously means a Netherlands datacenter) for our single dedicated server. We're not interested in hosting companies based in other countries but offering NL servers; just those that are NL based.

Our business is perfectly legal (as explained below) and we have neither the time nor inclination to debate the merits of our needs and would appreciate respect for that position (as we have read some of the reactions to such requests by US members for non-US servers and many have been less than respectful).

That said, here are three NL providers we're NOT interested in:

Leaseweb. That is based largely on a recent post in which they indicated they shut down servers with little notice if they get even one, even unsubstantiated, complaint about a TOS violation but also because we've read nightmare stories about how they treat small businesses and individual customers. Apparently, they've become too big for small accounts and our business server is as mission-critical to us as their big business clients. We need a provider that respects small business.

Server Boost. We have a VPS with them (we won't say under which domain name or IP address) but are still trying to work out the kinks in that rather new relationship so won't use them for our dedi at this time. That VPS will be the slave to our dedi.

i3D.net. They are our current dedi provider with whom we have a Rackserver but it isn't working out for a variety of reasons, the most important being we have no remote access control panel or power management. Right now, we are required to pay for OS reinstalls and just about anything else we need that's not a simple reboot. We don't necessarily believe they are a bad provider and don't want to malign them but our experience with them makes us disinclined to upgrade to a Dell server (and we are "anti-Dell" because of our personal experiences with Dell, anyway). We don't believe most customers feel this way about since their offerings are certainly suitable for most needs.

Therefore, we're looking for different alternatives from Leaseweb, i3D and Server Boost that are reputable, provide high-quality servers and solid, English-speaking, tech support at a reasonable monthly price. (We liked, for example, what OVH was offering but their NL site is in Dutch, only, and we don't want a UK server.)

What we now have:

* Intel Quadcore 2.4 Ghz CPU
* 2 GB DDR2 RAM
* 500 GB HDD (non-RAID)
* max 1000 mbit connection
* 2000 GB traffic
* 10+ IP addresses
* Full root access
* SSH access
* Netherlands company/NL datacenter
* Unmanaged
* No hosting control panel
* Upgradeable RAM, B/W, IP addresses, etc.
* Full hardware SLA

What we MUST have:

* Intel Core 2 Duo, 2.4+ Ghz CPU
* 4 GB DDR2 RAM (upgradeable to 8 GB, if nec.)
* 160+ GB HDD (RAID isn't necessary if single HD)
* max 1000 mbit connection
* 250-500 GB traffic p/m
* 15 IP addresses
* Full root/ SSH access
* IMPERATIVE: Remote access control panel with power control and ability to complete repair and maintenance tasks and OS reinstalls remotely WITHOUT having to contact Tech Support or pay for such services**
* Netherlands company/NL datacenter ONLY
* CentOS 5.3 x86_64 Linux (minimal) installed
* Full virtualization capability
* Unmanaged
* NO hosting control panel
* Upgradeable RAM, B/W, IP addresses, etc. as well as to a newer/larger dedi in first 30-days of contract without paying setup fees
* Full hardware SLA
* Responsive, English-speaking tech support, preferably 24/7** by email or phone and response within several hours
* TOS/Privacy Policies/Legal Policies available in English without the "Dutch only" terms valid caveat
* Server/order details available in English
* Fully itemized invoices available upon request
* Server provisioned and ready-to-use within 24-48 hours after payment clears (must be guaranteed in writing)
* MONTHLY contract (with NO 30-day advanced notice cancellation clause**) and PayPal as payment option

(**Lack of these important features is why we're switching providers.)

Prospective providers should be clear that this server is for our completely legal, US-based businesses that represent high-profile individuals engaged in legal business activities themselves. We will host several websites and blogs that are business-oriented and targeted to them, C-suite decision-makers who contract for our services and their audiences.

Our sites will contain NO adult content (legal or otherwise, whether it's called porn, erotica, or whatever), warez, torrents, copyrighted material for which we don't have permission to post/use, or overtly controversial materials like anti-government, hate speech, etc. We won't be spamming, phishing or doing IRC. We will not market to or represent clients who engage in such activities, even if legal in their jurisdiction.

We are not going to be hosting others' websites and our sites/blogs aren't expected to generate excessively high traffic. We use IP addresses for NS purposes and other purposes for which separate IP addresses are needed. So, we won't need DDoS or similar protection.

Our budget is �125.

Please give us your hosting-provider (only) suggestions. We'd prefer only recommendations of NL-based providers you've used. SERIOUS responses only; due to time constraints, we're forced to ignore any responses that don't adhere to our request for provider recommendations or attempt to debate the merits or our needs.

View 13 Replies View Related

Who Are The Most Reliable Dedicated/Node Provider

Oct 9, 2009

Who are the most reliable Dedicated/Node Providers? I mean there are the cheap ones like Wholesale Internet and Joe's DC but have they proven to be reliable as well?

View 10 Replies View Related

Chosing Dedicated Hosting Provider

Jan 14, 2009

What are the top providers (the best reviews) you know or use?, im looking for.

cPanel

Dual Core Processor

1 TB minimum tranfer

2 GB minimum Ram

80 GB minimum Hard Disk

Raid 1 hardware

Great uptime and good support

UnManaged

Payments via paypal

My budget is 100-160USD

at this moment i have a vps at geekstorage but i dont know what is happening with them now the node is too slow.

i was looking for limestone but i dont know.

View 12 Replies View Related

Credentials For Choosing A Dedicated Provider

Oct 30, 2009

How much more would you pay a month for dedicated server with a Cisco Master Certified Managed Services Provider?

In addition, would having the entire company's support staff CCNA certified influence your decision for choosing a dedicated provider?

Would certifications influence your decision to buy a server?

View 10 Replies View Related

Dedicated Provider With Solid FreeBSD Support

May 27, 2008

Can you reccomend - based on your experience - some dedicated hosting provider with a solid freebsd experience ? By "solid" I mean they will be able to provide a decent freebsd installation (especially if a control panel is requested) on tested hardware, rather than setup their standard server, put on it a freebsd7 iso, do a very poor setup then discover something like the raid card does not work as expekted, scratch their head, embarass themselves proposing centos as an alternative, and similar ridiculous behaviour ...

[I am in the market for a middle range core duo with 4gigs ram. Budget around 180$, 210$ including DirectAdmin. 2000GB bw on a 100mbit port. NY, DC, VA datacenters highly favourite, but also a well-networked chicago one would do, I guess].

View 6 Replies View Related

Good Secure Managed Dedicated Hosting Provider?

Jun 20, 2006

I work for a small web design firm with about 100 clients/domains and we are starting the search for a new hosting provider. We need a managed dedicated server with an offsite backup. We are also looking for a company that knows what they are talking about. If we have a Linux or server question they need to be able to give us a quick straight answer. Also, if they could help us transfer all our hosting accounts from our current server over to the new one that would be a BIG plus.

We have been thinking about Rackspace or 1and1.com but were wondering what the community thought. Any recommendations?

View 5 Replies View Related

302 Pages And Such Things

Oct 26, 2009

I'm not sure if this is correct place to post this, but I had a look round and couldn't see anything particularly appropriate.

Can someone point me in the right direction... give me a link or some advice... I want to learn about 302 pages, 301 pages and other types of pages.

I read that 302 pages may mean a website's traffic is being redirected by someone else...?

Obviously, I want to know if someone is sneakily redirecting my traffic... and I need to protect myself against it.

View 4 Replies View Related

Things Not To Install On Win Virtuozzo

Jul 28, 2007

I think it sad on one hand..many hosts complain about users crashing/causing problems for other users on the node they are on..yet..this topic has never been covered to my knowledge.

I can fix that.

OK..the most important thing is to *NOT* try and install windows updates from Microsoft. I have heard of it crashing the entire node. Do not run Windows update either. These updates come from sw-soft and will be installed by your host. nothing for you to do here.

OK...here's the list so far of what else not to install:

1) Hard drive encryption software
2) True RRAS VPN access software
3) Antivirus software
4) Virtual NIC software
5) Virtual Drive software

By all means..if you have any additions to this list..

View 8 Replies View Related

What To Look For And Things To Ask When Searching For A Colo

Aug 15, 2007

I'm currently a customer of The Planet and have been now for about 3-4 years, I've been very pleased with their service and their hardware. However I'm getting to the point where I'd like to upgrade my server and their upgrade prices as like most any other datacenter are 100-200% more then retail. While I'm not against people making money, this to me seems a bit to much.

So I'm considering paying a bunch of money up front to buy a new Dell 1950 PowerEdge server, and in doing so I need to find a company that can colo the new server. However I know a little about dedicated servers but nothing about colo or where to even start. I've found a few companies here in Lexington, KY as well as Louisville, KY and a few other companies in surrounding areas but I don't know the slightest thing I should be asking about. When searching for a dedicated machine it was easy - bandwidth and system specs.

What are a good list of questions I should be asking these companies when I call them for prices and availability?

View 14 Replies View Related

Using Squid To Speed Things Up

Mar 18, 2007

I've been hearing other admins talk about using squid to speed thins up on web servers. Yes, not as a network proxy, but as simple cache engine for dinamic sites.

Any experience with this?

View 12 Replies View Related

What Things Should I Look For When Choosing A Colocation Company

Jul 30, 2009

We are too small needswise for even a half rack. Even a 1/4 rack would be overkill but nontheless, options in the area are limited to even *owned-enclosed* 1/4 racks from the colo facility itself.

The local facilities that would fit our needs spacewise are probably going to fit this in a full rack with space that we purchase against.

My concern is the security of *our* -- the customer equipment. Read alot of horror stories and would hate to end up one day finding out that whatever provider we choose was behind on bills, etc and we have X days to grab equipment from the facility, etc.

I am looking to colo SAN equipment, which is almost a triple digit box.

View 10 Replies View Related

Things To Consider When Choosing A Datacenter [revised]

Jul 28, 2009

As per the last thread, I cleaned this up a little more, I welcome more comments as we make this the best it can be!

-------------------
Top Ten Things to Consider when choosing a Datacenter

Redundant Power
A minimum of N+1 power on critical systems (UPS and Generators) should be an absolute requirement for your business; however this doesn�t mean there aren�t points of failure. Not all power distribution is the same so demand a copy of your provider�s power map. 2N or greater systems is the only practical way to prevent failure. Definitions of redundant power can vary so demand to see a map that shows what it is truly redundant to. True B power should be redundant to the street.

Redundant Cooling
Redundant means more than just N+1 CRAH or CRAC units. If the facility has chilled water demand either a loop feed bi-directional system or a completely redundant pipe. This allows for maintenance on the pipe without taking the system down. Other considerations include redundant chillers, pumps, valves, controls, and electrical.

Network Carriers
At a minimum you should require a facility with multiple on site carriers. Competition drives pricing, therefore; by being in a carrier neutral facility with access to multiple providers, you increase your bottom line and decrease risk. Fiber should have diverse entrance paths to the building as well.

Location
The risk of system outage is significantly reduced by placing your servers in a datacenter that is located in a disaster free area. The threat of natural disaster such as tornadoes, hurricanes, earthquakes, and wildfires can be easily thwarted by choosing a datacenter that does not reside in a coastal or storm centered region. Also consider the cost and availability of power when selecting your location.

Security
It is important to demand accountability from your Datacenter Operator. While two-factor authentication is good, the most secure datacenters enforce three-factor authentication: something you have, something you are, and something you know. Man traps to avoid pass-back and tailgating at all points of ingress and egress should also be high on your list of requirements.

Support
Do not risk your business to an unmanned facility. Require a minimum of 2 remote hands engineers and ensure the datacenter has certified professionals on site at all times. Don�t be fooled by datacenters who hire �button pushers.� Remember that your infrastructure lies in their hands during critical moments.

Flexibility to meet your business needs
Don�t pay for a datacenter that is everything to everyone; in other words, avoid paying for services you don�t require. And do plan for growth, as your business grows, you want a datacenter that grows with you.

Vendors and Partners of the Datacenter
Often times the datacenter operator has relationships established with vendors. Leveraging these relationships can save you time and money compared to working with solution providers.

Service
Be sure to consider any other services the datacenter may offer you with regard to office space, engineering services, consulting services, customer accessibility, remote hands, etc.

Standards
The datacenter you choose should be SAS 70 Type II compliant. If your business deals with online payment transactions ensure that the datacenter meets the physical and environmental controls necessary for Payment Card Industry (PCI) Data Security Standards.

View 0 Replies View Related

CPanel's EasyApache 3 - Are You Using It? (Or Still Doing Things Manually?)

Feb 17, 2008

How many of you cpanel folks are using the new cpanel 11 "EasyApache 3" to manage apache/php on your servers? (Instead of doing things manually?)

We have always managed our apache and php configs manually, because cpanel was "under-powered" for the task.

However, with this new EasyApache 3 that is included with cpanel 11, it seems cpanel might finally have figured things out.

How many of you have switched over from doing things yourself manually to using EasyApache to manage your PHP config?

View 5 Replies View Related

Installing PHP, Ffmpeg And Things On Debian GNU/Linux 4.0

May 14, 2009

I have a shared hosting account on dreamhost
It has php and others installed but it allows custom installations for a number of reasons (control of the php.ini file, ...).

I have shell and ftp access to /home/username/ where my websites are
(/home/username/domain.ltd)

I installed php 5.2.9 under /home/username/php5,
I also installed ffmpeg but I ran into troubles installing ffmpeg-php.

Now I would like to start over, I'm not very advanced in this and I probably messed some stuff up. It seemed like a good idea to ask for some general advice before going at it again.

First, I was wondering about the filesystem I needed to set up, like the bin, tmp, lib, ... directories. Which ones do I need and what should go in them.
And how exactly do I let the system know these folders are there and it should look there for some commands. When I used phpize, it used the default one instead of the one in my custom php folder. Is the export command all there is to it?

When I install PHP, where should I install it and do I need to point it to my directories (bin, lib, etc...) instead of the ones in the host's root.
I noticed when installing ffmpeg-php it still looked for the default ones at some points:

HTML Code:
"checking for PHP includes... -I/usr/local/include/php -I/usr/local/include/php/main -I/usr/local/include/php/TSRM -I/usr/local/include/php/Zend..."
I don't know if this is normal behaviour or not, I'm just basically writing everything I am unsure about.

I got my website to use the custom PHP by editting the htaccess file

Also,
what would be the best approach to remove the things I currently installed, I suppose remove the php5 directory is not enough.

View 0 Replies View Related

Top 10 Things To Ensure Faster/Friendlier Support

Mar 27, 2009

I've been working in this industry for 5 years now. Over the years, I've come to realize the little things that customers do that REALLY piss tech support off. This is a guide for customers for 10 things NOT do when contacting their host's technical support team.

This is a repost of what I already posted before the big catastrophe.

Please forgive the brutal honesty. It's for your own good.

1. One ticket per issue.
Emailing your issue to Support, Sales, Billing, Abuse, the owner, each individual tech, and the mayor of your town is not going to get your ticket answered any quicker. Additionally, opening 2, 3, 4, or 10 tickets isn't going to get things done any faster. Seriously - all it will do is irritate the support guy

2. Contact the proper department
If your account is suspended due to non-payment, or your account hasn't yet been setup, or you want to upgrade your account - please don't bother contacting support hoping it'll get done faster. All it will do is slow down their response time to customers that have actual support issues. Billing issues goto Billing. Sales issues goto Sales. Abuse issues goto abuse. Get the picture?

3. Contact support via ONE medium
If you put in a support ticket, don't get on live chat and call too. Trust me - you'll get the same answer on live chat and the phone as you will in the ticket . Same goes for requesting "updates" on your ticket - if your ticket is in queue, wait patiently for a response. If you don't get a timely response, contact the management to complain.

4. Everyone thinks their ticket is CRITICAL
Tech support reps realize that you think your issue is CRITICAL and must be dealt with IMMEDIATELY. But, guess what, so does everyone else that submitted their ticket before you. Your CRITICAL ticket will be answered in the order received after everyone else's CRITICAL ticket has been answered.

5. Do not try to "bump" your ticket
Making continuous replies to your ticket in an event to get a faster response won't work. In fact, in most common helpdesk applications, each reply made rotates the ticket to the bottom of the queue. So really, by bumping your ticket, you're just making yourself wait longer. Not getting service fast enough? Contact the manager of the company!

6. Include all relevant information, but only relevant information
Seriously - we don't care to hear your life story. Submit your ticket with your client ID, domain name, username, password, error messages, steps to reproduce, and other information directly pertinent to your issue. If your website is inaccessible, check http://www.downforeveryoneorjustme.com/ and include your local IP address (from www.whatismyip.com) and a traceroute. That will save you a reply.

7. Just because YOU can't see the website does NOT mean the server is down
So please - don't come shouting at us claiming we're fraudsters and have horrible uptime and demand a credit. Most of the time you will find there is either a firewall issue or a routing issue - or scheduled maintenance. Check http://www.downforeveryoneorjustme.com/ and your host's forums before screaming at them.

8. Avoid live chat & phone support
Unless you have a quick question, live chat and phone support are probably not going to be good avenues. Chances are, if your issue requires someone to login to the server to investigate, you're just going to be escalated to a support ticket. Instead of whining about how long the support ticket will take to get answered - just get it in queue. Figure if you spend 5-10 minutes on the phone only for them to tell you that you need to submit a ticket - that's 5-10 minutes that your ticket could have been looked into. Think about it. If you do call or chat - be brief - and keep in mind we have other customers to help.

9. We don't make the rules
If you don't like a company's policies or procedures, don't complain to your support tech about it. They don't make the rules, they just follow them. If you want a change, contact the management of the company.

10. Do NOT disrespect or mistreat support people
If you curse at us, disrespect us, or mistreat us in any way - you can almost be guaranteed that we won't be going out of our way to help you beyond the minimum. By polite, cordial, and courteous to your support tech and it will get you a LOT farther. We don't get paid enough to deal with people's abuse.

11 (Free bonus ). The amount of money you pay does not matter to us
Seriously - the fact that you pay us $9.95/month does not matter to us. We're going to provide you with the same support that we provide somebody that's paying $3.95/month or $99.95/month. Don't expect better treatment based on the amount of money you pay.

View 14 Replies View Related

Top 10 Things To Ensure Faster/Friendlier Support

Dec 22, 2008

View 10 Replies View Related

MySQL Query Doing Odd Things - Removing Negative Sign For No Apparant Reason

Jan 10, 2007

I've got a problem with an SQL query that is behaving badly. Its probably really obvious, but I can't see the problem!

I have a table with 3 fields:

Code:

money bigint(20)
income int(12)
userID mediumint(7)

I have a row that has a negative money and a value of 0 for income. When I update the money value to add "0" to it, nothing happens (as expected). When I update the money field to add the income field (which is equal to 0) to it, MySQL flips the sign to make the money field positive.

The following queries show the problem:

Code:

mysql> SELECT money, income from users where userID=327961;
+----------------------+--------+
| money | income |
+----------------------+--------+
| -9223372036854775807 | 0 |
+----------------------+--------+
1 row in set (0.00 sec)

mysql> UPDATE `users` SET money = money + 0 WHERE userID =327961;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

mysql> SELECT money, income from users where userID=327961;
+----------------------+--------+
| money | income |
+----------------------+--------+
| -9223372036854775807 | 0 |
+----------------------+--------+
1 row in set (0.00 sec)

mysql> UPDATE `users` SET money = money + income WHERE userID =327961;
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1

mysql> SELECT money, income from users where userID=327961;
+---------------------+--------+
| money | income |
+---------------------+--------+
| 9223372036854775807 | 0 |
+---------------------+--------+
1 row in set (0.00 sec)

mysql>
Notice that there is no negative sign after the third select!!

So, we are saying that executing an update where 0 is specified in the query results in the correct action but if you take the 0 from another field it takes the negative sign away...

This for various reasons is a rather urgent problem. This problem has only appeared after upgrading from MySQL 4.0 to MySQl 5.1. This problem does not occur in MySQL 4.1.

View 1 Replies View Related

California Server Provider

Nov 12, 2008

We're currently in need of a reliable provider in California. We're currently using ServerBeach and their LA data center but we're having major issues with their service and support (highly recommend staying away from them at all costs).

Normally we go through referrals from other data centers but we're having a hard time locating a solid provider in the California area.

View 14 Replies View Related