sickaporean Posted May 31, 2020 Share Posted May 31, 2020 Hi, Just newly installed oscommerce phoenix and got this error message shopfront ... 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 select p.*, pd.*, m.*, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_quantity as in_stock, if(s.status, 1, 0) as is_special from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '2' order by pd.products_name LIMIT 0, As i am hosted by surpass hosting and got a check with them and their reply ... Hello, Thank you for your reply. This issue would be due to incorrect syntax in the mysql database which isn't compatible with the servers MariaDB version which is 10.1. You will want to reach out to oscommerce for assistance with this issue. Please let us know if you have any questions or concerns. Regards, How should i solve this ???? Thanks. Link to comment Share on other sites More sharing options...
♥ecartz Posted May 31, 2020 Share Posted May 31, 2020 If you use phpMyAdmin to run select p.*, pd.*, m.*, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_quantity as in_stock, if(s.status, 1, 0) as is_special from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '2' order by pd.products_name what does it say? Always back up before making changes. Link to comment Share on other sites More sharing options...
ArtcoInc Posted May 31, 2020 Share Posted May 31, 2020 @sickaporean Which version of Phoenix are you using? IIRC, this was an error introduced in 1.0.7.0, and was quickly fixed in 1.0.7.1. Malcolm Link to comment Share on other sites More sharing options...
♥ecartz Posted May 31, 2020 Share Posted May 31, 2020 Unfortunately, 1.0.7.0 is the version on the download page. The line to remove to fix that is at https://github.com/gburton/CE-Phoenix/commit/82d528731f600565d113614e0733a831c5a27f8a Alternately, download the entire https://github.com/gburton/CE-Phoenix/archive/master.zip and extract includes/modules/product_listing.php and copy it over. Always back up before making changes. Link to comment Share on other sites More sharing options...
sickaporean Posted June 1, 2020 Author Share Posted June 1, 2020 Hi all, Mine is old version ...lol I will try to upgrade to the newer version and will revert later ... Thanks all. Link to comment Share on other sites More sharing options...
sickaporean Posted June 1, 2020 Author Share Posted June 1, 2020 Hi all, sorry, been searching for how to update to 1.0.7.1 but to no avail. Can anyone help me with a link how to update to latest version? Thanks. Link to comment Share on other sites More sharing options...
♥ecartz Posted June 1, 2020 Share Posted June 1, 2020 The one and only important difference is in includes/modules/product_listing.php , so you can just copy that file from the download (either the second link that I posted or it's on the downloads page now). Or use the first link and delete the single line that it shows to delete. The only other file that has changed is the includes/version.php file. If you want, you can copy that over too. I don't know that update instructions have been posted yet, but they would essentially be to copy those two files. Always back up before making changes. Link to comment Share on other sites More sharing options...
sickaporean Posted June 1, 2020 Author Share Posted June 1, 2020 thanks ecartz, i will try that. Thanks again Link to comment Share on other sites More sharing options...
sickaporean Posted June 1, 2020 Author Share Posted June 1, 2020 Thanks everyone here, It worked. I am grateful for all help. Thanks Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.