Pages show up blank when published

I've put in the following dynamic applications to my website:

Data Assist - results, insert, delete, update, details pages
Security Assist - LogIn / LogOut pages
Database, including 3 tables

All of these pages, items, and database were functioning properly when I tested them on my localhost. Before uploading all items to the remote server, I changed the connection to the database to reflect the connection with my remote server. In addition, I successfully imported the SQL database with no issue.

After uploading all pages to the /public_html/ folder on the remote server, most of theses pages come up blank. No error messages or broken links, just blank.

Did I miss something?

For further info, I am using Dreamweaver CS3 and XAMPP.

Thanks,

Joseph

If a page shows up blank, it means there is an error on the page but error reporting is not turned on. Add this to the top of a page that is showing up blank and try accessing it again:

<?php 

error_reporting(E_ALL); 

ini_set('display_errors','on'); 

?>

Ok...i added the language to the one page in particular, sent it to remote, refreshed the page and received the following message:

Fatal error: Call to undefined function: wa_auth_rulepasses() in /hermes/bosweb/web159/b1590/sl.hillsborough25/public_html/webassist/email/mail_php.php on line 3


Ironically, this isn't one of the pages that I instructed Security Assist to restrict access to. In fact, this page was already published and working fine. After uploading all previous items, all PHP pages on the entire site showed up blank.

Please help. Thanks.

Joseph

Ok...i fixed the contact page and two other php pages; however, when I try to get to the admin page (or LogIn page), I get the following error:

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'joseph'@'boscgi1903.eigbox.net' (using password: YES) in /hermes/bosweb/web159/b1590/sl.hillsborough25/public_html/Connections/test_hillsborough25.php on line 9

Fatal error: Access denied for user 'joseph'@'boscgi1903.eigbox.net' (using password: YES) in /hermes/bosweb/web159/b1590/sl.hillsborough25/public_html/Connections/test_hillsborough25.php on line 9

what do you think?

Joseph

This is saying that the credentials to log in to your database are not set up correctly for this server. You should double check with the server admin or hosting provider to make sure that the user has sufficient privileges to log into the database account.

Jimmy,

I checked the credentials, username and password for the database, and they all match, and allow complete access. Honestly, I think this has more to do with Security Assist than anything else, due to the fact that I can't even access the LogIn page! Nevermind getting access, I can't even get the page to come up to check the credentials. Again, all of this was working on my localhost before sending to remote. The database created on my localhost was uploaded to the remote server, so it is exactly the same.

Please help.

Joseph

Joseph,
One of the first things the login page does is to try to connect to the database. That error is telling you that it was unable to, and so the page immediately fails.

If your username and password are correct, then the only other thing it can be is in your database connection your mysql server is not set correctly.
If the mysql server is on the same server as your site, then this will usually be 'localhost', otherwise it is the domain of the mysql server.
Who is your hosting provider?

Tom

The hosting provider is startlogic. I set the database connection as <webaddress>.startlogicmysql.com.

The published site and the mysql database are both on startlogic. I thought maybe this error had to do with the webpage being under https or not. In addition, I assumed localhost was only for connection to a database if I were running a testing server on my own computer.

what should I try next?

Joseph

I just did a quick search through startlogics support pages and found this
read_article.bml?kbid=7137;keywords=mysql

so your mysql host should be
AcctUsername.startlogicmysql.com

You mentioned you are using webaddess.startlogicmysql.com.. Are they the same?

If that is not it, then the next step would be to contact your host and find why the connection is failing.

Thanks
Tom

Tom,

Here are the settings I have in DW MySQL Connection for this site:

MySQL server: hillsborough25.startlogicmysql.com
user name: ......... (there is a value in here that matches)
passwrod: .......... (there is a value in here that matches)
database: hills25_data

In addition, below is the beginning code for the login page:

<?php require_once( "WA_SecurityAssist/Helper_PHP.php" ); ?>
<?php
if (!WA_Auth_RulePasses("Logged in to users")){
WA_Auth_RestrictAccess("access_denied_message.php");
}
?>


Any thoughts?

Joseph