Well, we're still trying to

decibel.places — Fri, 18 Jul 2008 03:01:06 +0000

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.

I have spent about 9 hours

decibel.places — Tue, 08 Jul 2008 00:12:40 +0000

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:

The install script works properly and creates the database tables.
Admin displays the correct database info.
The site is not connecting to the db. It looks the same when I drop all the db tables.
It displays partly in Firefox and throws a 500 Internal Server Error in IE.
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.
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.

We got a response from

decibel.places — Sun, 06 Jul 2008 04:57:41 +0000

We got a response from webhostingpad:

> From: support@webhostingpad.com
>
> 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,
> support@webhostingpad.com

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.

It's the DB, Dummy I thought

decibel.places — Sat, 05 Jul 2008 20:03:44 +0000

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...

the license works fine on

netsperience — Fri, 04 Jul 2008 04:59:21 +0000

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

Well, I use various ones

greg — Fri, 04 Jul 2008 03:59:45 +0000

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"

Greg, What tool do you use

netsperience — Fri, 04 Jul 2008 02:36:37 +0000

Greg,

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

Thanks

netsperience wrote: I tried

greg — Thu, 03 Jul 2008 17:47:02 +0000

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.

If the site didn't display

netsperience — Thu, 03 Jul 2008 16:19:41 +0000

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.

I would doubt DNS, ini files

greg — Thu, 03 Jul 2008 11:42:00 +0000

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