488901 SQL4 OScommerce Web site moved to an SQL5 server
N/A
Terminado
Publicado hace casi 13 años
N/A
Pagado a la entrega
I am having compatibility issues with oscommerce site and the database server SQL 5 vs. the site being set up for SQL4.
I am looking for a developer who has experience with this issue and quickly add the fixes needed.
I moved my older OScommerce website with a lot of modifications and updates to a new dedicated server at siteground.com.
Support at siteground recommends an outside developer. They have done a few patches but I need a few more fixes and I am still discovering fixes needed so I am working on a list.
The host support provided the following issues link
[login to view URL]
Which lead to this documented patch instruction
[login to view URL],4654
I have some modules that don't recognize the database but also on the site when you click on a category page that does not have any product listed I also get an error message
1054 - Unknown column 'p.products_id' in 'on clause'
select distinct p.products_id, p.products_image, p.products_tax_class_id, [login to view URL] as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '29' and p.products_status = '1' and [login to view URL] = '1' order by rand() DESC limit 0
[TEP STOP] 1054 - Unknown column 'p.products_id' in 'on clause'
Example go to this page and scroll down
[login to view URL]
I am getting error messages when I update order information but the updates are sticking.
When I updated payment check or money order option toggle on or off I get an error message but the update does work.
My froogle – Google product search datafeed module is not pulling up the complete data feed. This is on a much newer server than the one I had before but I do need a fix for it or a newer module installed.
The site is very slow at pulling up deeper pages which I think may also be related to database incompatibilities.