Find Jobs
Hire Freelancers

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.
ID del proyecto: 2234812

Información sobre el proyecto

1 propuesta
Proyecto remoto
Activo hace 12 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Oscommerce specialist...
$150 USD en 1 día
5,0 (119 comentarios)
6,5
6,5

Sobre este cliente

Bandera de
5,0
2
Miembro desde mar 30, 2011

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.