Skip to main content
T
TjmSmith
Inspiring
August 17, 2011
Question

WEB Host Check

  • August 17, 2011
  • 1 reply
  • 2316 views

A word to the wise; check out your ISP capabilities/support fully before moving on with CMS development.

Just learned the hard way.  I've had a static site on an ISP that provides PHP/MySQL service.  I built the DW5.5 CS 'test web site' (check_php) from the guide by David Powers and it worked fine on my local testing computer (XAMPP...).  I then tried to create the MySQL database on the live system and found they were using what apparently is an older version of 'everything'!!!.  Access to the entire site is provided via cPanel.  The create database function does not allow 'NON-alphanumeric' characters in the DB name (so much for my 'check_php' work!).

I then created a (test) database without the underscore and was able to upload the sample data (index & users) from Mr Powers examples; ok so far.  Then tried to add MySQL users:  Add New User is limited to seven characters (ok I guess but hampering from an end user point of view).  Did all the work to add the new user and on clicking 'create' it responds w/page 'success' but on return to the management screen the newly created user never appears

Sent 'comments/feedback' message yesterday; no response as of now.

I guess a new ISP is in order.

Tom

This topic has been closed for replies.

1 reply

Lon_Winters
Lon_Winters
Inspiring
August 17, 2011

Are you equating ISP with web hosting, or are you using the hosting that some ISPs provide as yo "personal web space". Your ISP is ther mainly just to provide you with Internet access, and any other of these features they may offer are bound to be sub-standard. If that's the case, then you need an account with a real web hosting provider who will have the latest versions of PHP and MySQL installed.

T
TjmSmithAuthor
Inspiring
August 18, 2011

Ooops!  No question about it, I was referring to my web hosting service (not my ISP).  I do know the difference but the frustration just got in the way.  Thanks for pointing it out though.

Anyone else having difficulty with the cPanel interface on their hosting service?

Tom

Lon_Winters
Lon_Winters
Inspiring
August 18, 2011

I don't admin any sites on hosts that use cPanel.  But you shoild be using phpMyAdmin to manage the database, correct? Do you know exactly what versions of PHP and MYSQL the host is running? It mat not be a version issue so much as a settings issue on the server regarding the restrictions for the DB name, not sure. But field length and data type can be managed in the database. if you do have phpMYAdmin, or some other tool to look at your database, view the table in design mode and check the properties for the UserID field. It most likely defaulted to a certain datatypes and field length which you shold be able to change.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices