[RESOLVED] Update Records in MySQL times out, Please Help

Dev1123

I have a large form with information that is updated regularly and I just recently migrated to a Godaddy Virtual Dedicated Server and apparently something stopped working. I don't know why, and I have spent about 5 hours trying to figure it out.

The code below is a page that is called from a "form action=" command and is supposed to update all of the fields within the database, but it's not...

I have determined that it's not a connection issue, and I have even tried a database with the root user as well as one with a generated account and to no avail. So, I am thinking that maybe it's the code. But then again, it used to work, so hopefully someone might be able to find something that I am missing.

Thanks a million for any help!

<?php session_start();

include("incs/dbconfig.php");
include_once("./incs/functions.php");
require_once('./incs/Image.php');
$propertyid=intval($_SESSION['id']);

$pid=$_SESSION['id'];

$_SESSION['salepanding']=$_POST['salepanding'];

$thumbfolder=realpath("./thumb")."/";

$imagefolder=realpath("./images")."/";
$arr=array();

$arr=array('clientname'=>$_POST['clientname'],
                  'loan'=>$_POST['loan'],
                'status'=>$_POST['status'],
               'paddress'=>$_POST['paddress'],
			    'city'=>$_POST['city'],
                 'zipcode'=>$_POST['zipcode'],
                'property'=>$_POST['property'],
				 'doi'=>$_POST['inspectiondate'],
				'dofs'=>$_POST['foreclosure'],
				'name'=>$_POST['contactname'],
				'phone'=>$_POST['phone'],
				'email'=>$_POST['email'],
				'value'=>$_POST['value'],	
				'trashoutdate'=>$_POST['trashoutdate'],
				'rekeydate'=>$_POST['rekeydate'],
				'lockboxcode'=>$_POST['lockboxcode'],
			     'listprice'=>$_POST['listprice'],			
				'rekeycode'=>$_POST['rekeycode'],
				'damage'=>$_POST['damage'],
				'occupant'=>$_POST['occupant'],
				'salepanding'=>$_POST['salepanding'],
                'cashkeys'=>$_POST['cashkeys'],
                'damageamt'=>$_POST['damageamt'],
				'vacancydate'=>$_POST['vacancydate'],
                'abandonedproperty'=>$_POST['abandoned'],
				'hoainfo'=>$_POST['homeowners'],
				'unabletoinspect'=>$_POST['unabletoinspect'],
				'reason'=>$_POST['reason'],
				'comments'=>$_POST['comments'],
				'name1'=>$_POST['name1'],
				'unit1'=>$_POST['unit1'],
				'phone1'=>$_POST['phone1'],
				'name2'=>$_POST['name2'],
				'unit2'=>$_POST['unit2'],
				'phone2'=>$_POST['phone2'],'
				name3'=>$_POST['name3'],
				'unit3'=>$_POST['unit3'],
				'phone3'=>$_POST['phone3'],
				'hoaname'=>$_POST['hoaname'],
				'hoa'=>$_POST['hoa'],
				'hoacontact'=>$_POST['hoacontact'],
				'hoadues'=>$_POST['hoadues'],
				'hoaaddress'=>$_POST['hoaaddress'],
				'hoacity'=>$_POST['hoacity'],
				 'hoastate'=>$_POST['hoastate'],
				 'hoazip'=>$_POST['hoazip'],
				 'propertypin'=>$_POST['propertypin'],
				 'subdivision'=>$_POST['subdivision'],
				 'yearlytaxes'=>$_POST['yearlytaxes'],
				 'county'=>$_POST['county'],
				 'priormls'=>$_POST['prior'],
				 'lienholder'=>$_POST['lienholder'],
				 'roof'=>$_POST['roof'],
				 'ceiling'=>$_POST['ceiling'],
				 'doors'=>$_POST['doors'],
				 'floors'=>$_POST['floors'],
				 'sidewalks'=>$_POST['sidewalks'],
				 'kitchen'=>$_POST['kitchen'],
				 'structure'=>$_POST['structure'],
				 'bathrooms'=>$_POST['bathrooms'],
				 'chimney'=>$_POST['chimney'],
				 'waterheaters'=>$_POST['waterheater'],
				 'pool'=>$_POST['pool'],
				 'electrical'=>$_POST['electrical'],
				 'garage'=>$_POST['garage'],
				 'basement'=>$_POST['basement'],
				 'room'=>$_POST['nor'],
				 'bath'=>$_POST['bath'],
				 'bed'=>$_POST['bed'],
				 'theft'=>$_POST['theft'],
				 'vandalism'=>$_POST['vandalism'],
				 'fire'=>$_POST['fire'],
				 'brokerage'=>$_POST['brokerage'],
				 'address'=>$_POST['address'],
				 'phonebroker'=>$_POST['phone4'],
				 'signature'=>$_POST['signature'],
				 'date'=>$_POST['date'],			
				 'comp1'=>$_POST['txtcomp1'],
				 'sold1'=>$_POST['txtsold1'],
				  'comp2'=>$_POST['txtcomp2'],
				 'sold2'=>$_POST['txtsold2'],
				  'comp3'=>$_POST['txtcomp3'],
				 'sold3'=>$_POST['txtsold3'],
				  'comp4'=>$_POST['txtcomp4'],
				 'sold4'=>$_POST['txtsold4'],
				 'extconst'=>$_POST['txtexterior'],
				 'extstatus'=>$_POST['extstatus'],
				 'remarks'=>$_POST['txtremarks'],

           );

$conn->perform(tblproperty,$arr,'update','propertyid='.$propertyid);

tomhath

Probably none of this will make any difference, but the inconsistent way you refer to the included files bothers me a little. Also check that nothing changed when you converted 'id' to an integer, then used it as a string at the end; since you have $pid as a string you may as well use it instead of $propertyid.

Does the call to $conn->perform return any result or error message?

<?php session_start();

include("incs/dbconfig.php");
include_once("./incs/functions.php");
require_once('./incs/Image.php');
$propertyid=intval($_SESSION['id']);

$pid=$_SESSION['id'];
...
$conn->perform(tblproperty,$arr,'update','propertyid='.$propertyid);

Dev1123

tomhath;10897710 wrote:
Probably none of this will make any difference, but the inconsistent way you refer to the included files bothers me a little. Also check that nothing changed when you converted 'id' to an integer, then used it as a string at the end; since you have $pid as a string you may as well use it instead of $propertyid.

Does the call to $conn->perform return any result or error message?
<?php session_start();

include("incs/dbconfig.php");
include_once("./incs/functions.php");
require_once('./incs/Image.php');
$propertyid=intval($_SESSION['id']);

$pid=$_SESSION['id'];
...
$conn->perform(tblproperty,$arr,'update','propertyid='.$propertyid);

I have checked the script throughout the page and it runs everything up until it gets to this:

$conn->perform

then nothing happens and the screen just goes white. So apparently it's not updating the db with the posted records. I can get all of my other pages on the site to update the db just fine, but not this one.

Do you know the specifics on what this does and how I could debug it?

$conn->perform(tblproperty,$arr,'update','propertyid='.$propertyid);
[/code]

walterquez

$conn->perform(tblproperty,$arr,'update','propertyid='.$propertyid);

Just curious about "tblproperty". Is it a variable, a constant? It has no "$", so PHP thinks it must be a constant.

Dev1123

walterquez;10897727 wrote:
$conn->perform(tblproperty,$arr,'update','propertyid='.$propertyid);
Just curious about "tblproperty". Is it a variable, a constant? It has no "$", so PHP thinks it must be a constant.

define('tblproperty','broker_property_certificate');

It is defined on one of the pages that is "included" to shorten the name of 'broker_property_certificate'.

I just don't know why this would work and then all of the sudden stop just because I changed servers, it doesn't make much sense at all. Could it have something to do with the settings in the php.ini file?

tomhath

$conn->perform is just a function call ($conn is an object, perform is one of it's methods). If your other pages work okay I doubt there's anything wrong with php.ini. Look in the INCLUDE files to see where $conn came from and what it does.

Dev1123

tomhath;10897779 wrote:
$conn->perform is just a function call ($conn is an object, perform is one of it's methods). If your other pages work okay I doubt there's anything wrong with php.ini. Look in the INCLUDE files to see where $conn came from and what it does.

Alright, so I have finally figured this out, and it all boiled down to a "folder permission" problem. It's always the easiest solutions that give you the most problems. Thanks to all for helping on this and confirming that it couldn't be a code error, which led me to look in other places.