Jump to content
sickaporean

1064 error and worse ...

Recommended Posts

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.

 


 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
Posted (edited)

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. 

Edited by ecartz

Always back up before making changes.

Share this post


Link to post
Share on other sites

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.

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×