488901 SQL4 OScommerce Web site moved to an SQL5 server

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

[url removed, login to view]

Which lead to this documented patch instruction

[url removed, login to view],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, [url removed, login to view] 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 [url removed, login to view] = '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

[url removed, login to view]

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.

Beceriler: Her şey Kabul, e-Ticaret, MySQL, OSCommerce, PHP, SEO, SQL, Web Sitesi Yönetimi

Daha fazlasını gör: sql4 sql5 oscommerce, www google com web developer, where is community set, web site error, web developer update, web developer community forums, web developer community, s.a.p. experience, php web modules, php web developer forums, message scroll, go web server, google developer web, google com search web, fix website compatibility issues, error on web page fix, p sql, go data feed, google site developer, google search web site, where does my money, web site an seo, web money s, web developer list, php seo web

İşveren Hakkında:
( 2 değerlendirme )

Proje NO: #2234812



Oscommerce specialist...

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(119 Değerlendirme)