500 internal server error

software development

#1

I recently just switched to vps for server and sql. with vps of 2300 mb and vps sql server of 300 mb. I am trying to run this query via a php script. I keep on getting 500 internal server error. Do I need more memory? Pleases help.
mysql_select_db($database_rpmsn, $rpmsn);
**TABLE TRANSACT CONSISTS OF 302,597 ROWS
**TABLE TENANTS CONSISTS OF 1,555 ROWS

<?php $query_TRANSACT = "SELECT TRANSACT.eid,TRANSACT.bid,TRANSACT.uid,TRANSACT.tid,TENANTS.tenantName ,TRANSACT.ccn,TRANSACT.description,TRANSACT.billDate,TRANSACT.amount FROM TRANSACT,TENANTS WHERE TRANSACT.pb='B' AND TRANSACT.bid=TENANTS.bid AND TRANSACT.uid=TENANTS.uid AND TRANSACT.tid=TENANTS.tid ORDER BY bid,ccn,billDate,uid,tid LIMIT 0,10000"; $TRANSACT = mysql_query($query_TRANSACT, $rpmsn) or die(mysql_error()); $row_TRANSACT = mysql_fetch_assoc($TRANSACT); ?>

Please Help


#2

check your error logs and report back with the details.


#3

If for some reason you are still using IE, turn off the “friendly HTTP error messages” setting.