Jump to content

Archived

This topic is now archived and is closed to further replies.

mrwebbie

Moved to new server and upgraded to PHP5 .... now I have two errors!

Recommended Posts

Okay, a little background.  I didn't write these databases or create the php pages.  So, you'll need to be gentle with me. :)  I know enough to be dangerous, but I'm mainly just a maintainer here...not a designer.

Anyway, I was recently moved to an upgraded server by my host, and in the process, we went ahead and upgraded to PHP 5.0.  I have two databases with 5 applications running off of one and one off of the other.  Everything is working just fine on the database with the multiple applications, but on the other database, I have a problem with two functions.

The first searchs for a record so it can be updated.  You can get to a point where you can choose the record you want, but when you do, this is the error you get:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Here is the code in line 1 -- 

<?php require_once('Connections/julian.php'); ?>

Okay, the second error is from a page that functions similar to the one above but it will actually delete a record.  Again, you can get to a point where you can select the record you want to delete, but then you get this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and clients.advocate_id = advocates.advocate_id and clients.race_id = race.race_' at line 1

Here is the code in line 1 --

<?php require_once('Connections/julian.php'); ?>

Obviously, even a noob like me can see that the line 1 thing may not be the issue.  So, I'm really at a loss.  It is just weird that these are the only two things that are giving me any problems.

So please help! :)

Nick

Share this post


Link to post
Share on other sites
These are sql errors, not php. You need to find (and post) the relevent sql statements.

Share this post


Link to post
Share on other sites
you need to load the source file specified into an editor:
[code]<?php require_once('Connections/julian.php'); ?>[/code]
-the error is within the 'Connections/julian.php' file

Share this post


Link to post
Share on other sites
Okay, that makes sense, however, the julian.php file is identicle to connection file.  So, I am not sure why it would be the problem here.

Here is the copy of the connection file: (I've X'd out the username and password)

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_julian = "localhost";
$database_julian = "juliancenter_org_-_vawa";
$username_julian = "XXXXXXXX";
$password_julian = "XXXXXXXX";
$julian = mysql_pconnect($hostname_julian, $username_julian, $password_julian) or die(mysql_error());
?>


I'm so confused :)

Share this post


Link to post
Share on other sites
If it is complaining about sql syntax, then it would be the sql used in the function:
mysql_query();
you don't show that function or the sql code in it above

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.