A few days ago I had someone modify OSC code to fix the following problem: "1054 Error - Unknown column 'p.products_id' in 'on clause'".
Unfortunately, I did think carefully enough about this project and failed to ask the previous service provider to adjust OSC code to ensure all fields - including but not limited to text fields - were posting to the "orders_products_attributes" table. Of equal importance is having OSC successfully pass this information to the invoices and order confirmation emails.
Hence, I need someone successfully address these issues, as well as any other known issues related to MySQL 5.x upgrades. Service Provider will articulate what other issues exist prior to performing any work. Important! Service Provider will also comment out old code to allow Service Buyer to clearly interpret/discern what code modifications were required relating to this project.
Strong knowledge of OSCommerce, PHP, MySQL 5.x is a must. No amateurs, please.