Archive for the ‘MySQL’ Category

Upgrading old versions of OSCommerce to be MySQL5 compatible

Sunday, August 19th, 2007

Since our last Dublin update we’ve had a few users having issues with their old OSCommerce installs. Below you’ll find the most common problem and fix.
The problem: Error Message - 1054 - Unknown column ‘p.products_id’ in ‘on clause’

The fix: Download the instructions helpfully provided by ozstar.

Posted in Ecommerce & SSL, MySQL | No Comments »

Can I connect to my MySql database using a remote client?

Wednesday, May 23rd, 2007

Yes, you can connect to your database using a client such as MySql Front or Aqua Data Studio. We only enforce standard authentication for remote MySql connections, you just require your database username, password and server address.

Posted in MySQL | No Comments »