bizarre PHP MySQL web hosting problem

decibel.places's picture

He has: 1,494 posts

Joined: Jun 2008

Datenyla http://datenyla.com

Using the Webscribble WebDate package

pretty standard php/mysql kind of like Joomla with many templates

Did a fresh install in April, made some mods mainly embedding stuff like chat, phpBB etc. it was stable it was fine

Coupla weeks ago I noticed it was displaying a blank screen

nobody touched any of the files

a complaint to webhostingpad restored half of the front page

we decided to make another fresh install - backed up and cleaned out entire directory, all addons etc. wiped db dropped all tables

clean install displayed with the same errors

so put original files and db back (luckily it is cPanel so I can unpack archives in filemanager)

Attaching a screenshot of how it is supposed to look - notice there is a sub-header 3 panel area with a photo on left, some text in middle, I think there was a register form on the right but not in the screenshot

This entire band is missing

It is a single template file index_top.html which is not only present but displays properly in the Webdate admin wysiwyg editor (I did not use the admin editor but viewed the file to see if it was there and it is)

also missing are the "male/female" selections for the drop down lists in search (and in the new fresh install they were missing just the same, from files unpacked from the fresh archive)

the only .htaccess file in public_html says "allow all" and I tried deleting it anyway no difference.

since nobody touched anything and webhostingpad restored part of the site, I think it's a hosting screw up but not sure where to begin.

oy - and it happened during web hosts from hell week, too!

AttachmentSize
datenyla_home_screenshot.png216.33 KB
greg's picture

He has: 1,581 posts

Joined: Nov 2005

If you did a clean install then you know all your files *should be* ok.
Bandwidth or overused port can sometimes cause this.
I notice on a few hosts (rubbish ones) I have worked on for clients sometimes some of the code wont load properly, a refresh and it does.

You problem of course might be something completely different, as it could be numerous things.

A note though, there are 707 other websites listed with the IP address of datenyla.com.

decibel.places's picture

He has: 1,494 posts

Joined: Jun 2008

Greg,

What tool do you use to count shared host sites on the IP?

Thanks Smiling

greg's picture

He has: 1,581 posts

Joined: Nov 2005

Well, I use various ones depending on what info I want from the lookup.

But the best one for the above sort of stats is this:
http://www.myipneighbors.com/

If you want to search for others, search for things like "reverse IP" or "reverse IP lookup"

decibel.places's picture

He has: 1,494 posts

Joined: Jun 2008

yes this is a ridiculously cheap host I did not pick it

for example I discovered the ftp server limits to 2 connections (my Filezilla is set for 5)

it worked fine until a couple of weeks ago

it doesn't look like a fluctuating bandwidth problem because it is always the same - missing parts

it is very suspicious that a complaint to webhostingpad restored the site partially from a blank white screen of death

I reinstalled pristine files just extracted from the installer archive in case some of the files were corrupted. Same problem

could a bad conf file, strange php.ini or just weird DNS cause a problem like this?

I am sure it is something the server admin changed on the account - and my experience with hosting companies - probably with the sole exception of RackSpace which has excellent support - my experience is it's easier to pull shark's teeth than tracking server changes, particularly if they cause errors.

StartLogic once changed a pw on one of my databases - I could not access it even with phpmyadmin (and they did not permit remote access such as Navicat) and that was the last straw. Fortunately I had a copy of the db elsewhere so it was not an issue.

So I moved to BlueHost where they informed me they could only point my DNS to the public_html dir (at least at SL they pointed it to a subdir as I wanted and subdomains parallel worked too)

And in the middle of web hosting from hell week the dating web site went blank

greg's picture

He has: 1,581 posts

Joined: Nov 2005

I would doubt DNS, ini files or conf files would cause "some" parts of a page to be missing.

If the bits missing are the same as other bits that are loading fine (like text/buttons/links etc) then I would say it wont be any sort of configuration error.
Problems with those, especially DNS, are usually are 0/1, working or not.

If it was a timeout error or even a misconfigured PHP timeout or one of the various apache timeout settings then I would guess that it would load everything fine up to the point it timedout.
Whereas with that site it was not loading certain things in the middle of the page, then loading the rest of the page.

Are there other things around the site missing as well? If yes then it's not a file or folder issue, and is something more site-wide.
If it's just that one page then you might want to upload that working file from the server to another server (another host) and see if it works fine.

If the file works fine on another host you might just want to consider moving to another host.
Sounds like it could be a headache trying to resolve this one.

EDIT: I just tried the site, and
Firefox can't find the server at www.datenyla.com
That was from clicking the link in your first post, it worked fine yesterday

decibel.places's picture

He has: 1,494 posts

Joined: Jun 2008

If the site didn't display maybe I was messing with the files it is there now

I tried moving the site to my server but the license is specific to the domain, don't think I can trick that

I tried to view the template directly in the browser but the site is set up to deny access to direct view

I did, howver view the missing template file in the admin section WYSIWYG template manager and it displayed fine theree

However the admin is not showing any members or member profiles and I checked the db table is there

Also the site only displays the same landing page no matter what links are clicked, and as you noted seems to finish loading with parts missing, does not look like a bandwidth or timeout problem

When I mosved my personal site to BlueHost I tried to set it up in a directory in the public_html home dir as I had it before on another host. They couldn't manage it, they would only point the DNS to the home dir, I tried some .htaccess but didn't really do what I wanted either. In that situation, only parts of the site were showing, others not, no css was loading, but it was less subtle than the datenyla problems.

greg's picture

He has: 1,581 posts

Joined: Nov 2005

netsperience wrote:
I tried moving the site to my server but the license is specific to the domain, don't think I can trick that

I tried to view the template directly in the browser but the site is set up to deny access to direct view

Might there be an issue with either of those two^^ ?

Misconfigured license/or the access deny thing. I'm clutching at straws for you really, as without accessing the site and testing various things myself it's hard to give suggestion. It could be a lot of things really, or a combination of more than one issue.

decibel.places's picture

He has: 1,494 posts

Joined: Jun 2008

the license works fine on the domain it is registered for datenyla.com

other files in the templates folder display fine on the site

I think the access denied is just some local protection

the full error message is

Forbidden

You don't have permission to access /templates/index_top.html on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache/2.2.8 (Unix) mod_ssl/2.2.8 OpenSSL/0.9.8b DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at datenyla.com Port 80

I remain convinced it is a server conf problem and not a code problem

I need to either fix it myself or tell webhostingpad what to do

decibel.places's picture

He has: 1,494 posts

Joined: Jun 2008

It's the DB, Dummy

I thought if the db were dscon the site wouldn't work at all - wrong!

But some dbs work, some don't all with same username (maybe that's the problem, but should't be for 4 dbs with almost no traffic)

Here's a ticket I submitted:

(copy of ticket I just submitted)

Approximately 3-4 weeks ago the website at domain http://datenyla.com went totally blank white.

Neither the owner, nor I, the developer (Randall), made any changes to code or anything else.

Clive Crooks, the owner, notified you, and you managed to replace part of it.

It appears that it is not connecting to the database anymore. I reinstalled a fresh copy from archived installation files directly from the licensor Webscribble but the fresh site appeared to have the same problems so I replaced the current site, which has some small modifications.

Today I deleted the datenyla_webdate database and the site appeared exactly as it is now.

I rebuilt the database and double checked the username and password and it is still not functioning properly.

Another app Guestbook using a separate database is also not working I got this sql error at http://datenyla.com/guestbook/ :

--------------------------------------------------------------------------

Connection Error

MySQL Error : Connection Error
Error Number: 2005 Unknown MySQL server host 'mysql.dig-creation.com' (1)
Date : Sat, July 5, 2008 11:47:08
IP : 67.83.143.95
Browser : Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.15) Gecko/20080623 Firefox/2.0.0.15 FlyPaper/RC1
Referer :
PHP Version : 5.2.5
OS : Linux
Server : Apache/2.2.8 (Unix) mod_ssl/2.2.8 OpenSSL/0.9.8b DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
Server Name : datenyla.com

---------------------------------------------------------------------------

however the forum at http://datenyla.com/phpBB3/ which also uses its own db appears to be working.

all these dbs have the same user - is that a problem?

THIS SITE AND THESE SEPARATE APPS WERE WORKING FINE UNTIL A FEW WEEKS AGO NO CHANGES WERE MADE TO THEIR CODE OR DATABASE SETTINGS.

(more web hosts from hell - meet webhostingpad)

Oh yeah, it is Cpanel with phpmyadmin - but it looks weird - in the menu there is no Browse on the left and no Empty and Drop on the right (see attached)

and when I was rebuilding the db, importing files over a few hundred kb timed out - and even logn insert queries had to be broken down for digestion...

AttachmentSize
datenyla.com-phpMyAdmin.png 126.36 KB
decibel.places's picture

He has: 1,494 posts

Joined: Jun 2008

We got a response from webhostingpad:

> From: [email protected]
>
> Hello,
>
> I checked your site and I am not getting any mysql-error on the site. Can you please let me know the exact URL where you are getting error, it will help me to assist you in a better way.
>
> Thanks,
> David.
> Tech Support,
> [email protected]

and they closed the ticket, of course

maybe I should offer English lessons

I responded with a very detailed explanation, even more than the ticket above, and repeated the ticket

We'll see

If it gets ridiculous, has anybody used the plan at rsdarkness.com ? - Mike says he will upgrade the basic $4/month plan to the business plan for a year, he seems like a pleasant guy, but I don't want to make a poor recommendation. His domain has over 700 sites on the IP, today datenyla.com has about 300 sites on its IP, no longer 770 like yesterday.

decibel.places's picture

He has: 1,494 posts

Joined: Jun 2008

I have spent about 9 hours the last two days analyzing the "problem"

Due to the fact that the owner has been my client about 6 1/2 years and couldn't afford to pay me anyway, it's a "favor" and I really don't resent it.

But I am getting awfully frustrated.

It turns out that the other db apps were old apps we had installed on a different server and I was just confused which ones we are using now - those are fine - but the main site isn't.

I have emptied the public_html and reinstalled the fresh files that worked fine a few months ago, reinstalled the modified files that worked until about a month ago. I have deleted the entire database, recreated it, dropped the tables, imported them from SQL, used the install script; I have mixed the old files and the new files, tried to run the old files on the new database, tried to run the fresh files on the old database.

This is what I have found:

  1. The install script works properly and creates the database tables.
  2. Admin displays the correct database info.
  3. The site is not connecting to the db. It looks the same when I drop all the db tables.
  4. It displays partly in Firefox and throws a 500 Internal Server Error in IE.
  5. The error log after the IE error says a function "qnl()" is not found. I located the function, it's in the codebase (I did not try to trace all the includes and stuff, but I guess that's next) I copied the function right into the file that threw the error. No more error on the function, no errors in log, but still a 500 Internal Server error.
  6. I checked phpinfo() and it's running PHP 5.2.5 safe_mode is off and the Zend engine is running (the basic requirements of the WebDate platform)

You can see phpinfo() here http://datenyla.com/phpinfo.php

Could PHP 5.2.5 be causing errors? I really don't know what they were running a few months ago, but it worked, same code and same installation procedure...

Although he purchased a lifetime license including free updates, support is on a subscription basis and he does not subscribe. I checked searches for error messages it does not look like anybody else is writing about these errors. The package I'm using appears to be the latest package, as a last ditch effort I will download the archive again.

The URL is http://datenyla.com

I am attaching a screenshot of the default install and one of how it looks now. I have seen the missing band of 3 images in the admin in the WYSIWYG editor and the template file is in the correct place.

AttachmentSize
webdate_default.jpg 36.61 KB
decibel.places's picture

He has: 1,494 posts

Joined: Jun 2008

Well, we're still trying to get the *&%^% website to work again

I checked phpinfo() against the app requirements http://datenyla.com/phpinfo.php

I'm kind of grasping at straws but my gut tells me it is either a MySQL or PHP problem - maybe someone else can spot a problem.

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.