Project Detail

Description

I have a site that wa created using PHP,MYSQL and Smarty Templates. My Host upgraded to MYSQL to 5.0.51a on the server and one of my pages that have been working for over 2 yrs suddenly started getting a syntax error while trying to access the page. This should be a quick fix for an experienced programmer. I need someone that will be able to resolve all of the issues with this page in a timely manner. I am no longer in contact with the programmer that helped me create the site so I would like to start a new relationship with a new programmer for some other addons

***** First I was getting this error ****

[2008-12-01 15:00:44] ERROR (0x10000001) 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 '
user.userid,
datecycle,
date_forma' at line 1:db_get_allloan_by_accountid:SELECT ,
user.userid,
datecycle,
date_format(lastmodifydatetime,'%Y-%m-%d') as lastmodifydate,
CONCAT_WS(' ', firstname, lastname) as username,
CONCAT('$',FORMAT(loanamount,2)) as loanamount,
paytimes,
times,
CONCAT('$',FORMAT(loanamount/times,2)) as average,
reason
FROM loan, user
LEFT JOIN
(SELECT COUNT(*) as paytimes,
loanpayid
FROM saving
WHERE savingtype='loan payment'
and accountid='2'
and status='normal'
GROUP BY loanpayid) paytotal
ON paytotal.loanpayid=loan.loanid
WHERE datecycle>='2008-01-01'
and datecycle<='2008-12-01'
and loan.accountid='2'
and user.accountid='2'
and loan.status='normal'
and loan.userid=user.userid
ORDER by lastmodifydatetime DESC;


********************Now I get this error ************************


[2008-12-01 17:52:48] ERROR (0x10000001) Unknown column 'loan.loanid' in 'on clause':db_get_allloan_by_accountid:SELECT loanid,
user.userid,
datecycle,
date_format(lastmodifydatetime,'%Y-%m-%d') as lastmodifydate,
CONCAT_WS(' ', firstname, lastname) as username,
CONCAT('$',FORMAT(loanamount,2)) as loanamount,
paytimes,
times,
CONCAT('$',FORMAT(loanamount/times,2)) as average,
reason
FROM loan, user
LEFT JOIN
(SELECT COUNT(*) as paytimes,
loanpayid
FROM saving
WHERE savingtype='loan payment'
and accountid='1'
and status='normal'
GROUP BY loanpayid) paytotal
ON paytotal.loanpayid=loan.loanid
WHERE datecycle>='2008-01-01'
and datecycle<='2008-12-01'
and loan.accountid='1'
and user.accountid='1'
and loan.status='normal'
and loan.userid=user.userid
ORDER by lastmodifydatetime DESC;