Guest Posted February 21, 2005 Share Posted February 21, 2005 Everything is OK except this error. When customers received a confirmation order after placed the order, there is a link for account history ,the error happened. Any one can help me,because this is fatal error,customers will worry about their order. Thanks a million in advance. MY ORDER HISTORY 1064 - You have an error in your SQL syntax near 'select o.orders_id, o.orders_status, o.date_purchased, o.delivery_name, ot.text ' at line 1 select count(select o.orders_id, o.orders_status, o.date_purchased, o.delivery_name, ot.text as order_total, s.orders_status_name from orders o left join orders_total ot on (o.orders_id = ot.orders_id) left join orders_status s on (o.orders_status = s.orders_status_id and s.language_id = \'7\') where o.customers_id = \'13\' and ot.class = \'ot_total\' order by orders_id DESC) as total Link to comment Share on other sites More sharing options...
Guest Posted February 22, 2005 Share Posted February 22, 2005 Hasn't anyone can help me of this? I found many peope ask twice then will has reply. :'( Link to comment Share on other sites More sharing options...
Guest Posted February 22, 2005 Share Posted February 22, 2005 When customers paid their order, the system will send an email include the detailed invoice:"Order Number: 21 Detailed Invoice: http://www.mystore.com/catalog/account_his...php?order_id=21 when customers click this,they need to log in,but they see below: Warning: main(includes/languages/english/FILENAME_ACCOUNT_CUSTOMER_CONFIRM): failed to open stream: No such file or directory in /www/users/rubberbracelet.net/catalog/account_history_info.php on line 27 Warning: main(includes/languages/english/FILENAME_ACCOUNT_CUSTOMER_CONFIRM): failed to open stream: No such file or directory in /www/users/rubberbracelet.net/catalog/account_history_info.php on line 27 Fatal error: main(): Failed opening required 'includes/languages/english/FILENAME_ACCOUNT_CUSTOMER_CONFIRM' (include_path='.:/usr/local/lib/php') in /www/users/rubberbracelet.net/catalog/account_history_info.php on line 27 Who can help me? Link to comment Share on other sites More sharing options...
MysticBlues Posted February 22, 2005 Share Posted February 22, 2005 did you look at line 27??? Link to comment Share on other sites More sharing options...
WiseWombat Posted February 22, 2005 Share Posted February 22, 2005 When customers paid their order, the system will send an email include the detailed invoice:"Order Number: 21Detailed Invoice: http://www.mystore.com/catalog/account_his...php?order_id=21 when customers click this,they need to log in,but they see below: Warning: main(includes/languages/english/FILENAME_ACCOUNT_CUSTOMER_CONFIRM): failed to open stream: No such file or directory in /www/users/rubberbracelet.net/catalog/account_history_info.php on line 27 Warning: main(includes/languages/english/FILENAME_ACCOUNT_CUSTOMER_CONFIRM): failed to open stream: No such file or directory in /www/users/rubberbracelet.net/catalog/account_history_info.php on line 27 Fatal error: main(): Failed opening required 'includes/languages/english/FILENAME_ACCOUNT_CUSTOMER_CONFIRM' (include_path='.:/usr/local/lib/php') in /www/users/rubberbracelet.net/catalog/account_history_info.php on line 27 Who can help me? <{POST_SNAPBACK}> HAVE A LOOK AT THE ERROR catalog/account_history_info.php on line 27 ( WARNING ) I think I know what Im talking about. BACK UP BACK UP BACK UP BACK UP Link to comment Share on other sites More sharing options...
Guest Posted February 27, 2005 Share Posted February 27, 2005 Solved already. I copy the original fils ,that fixed the problem.thanks for your attention. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.