Jump to content

 

elsieallen

Member Since 21 May 2006
Offline Last Active May 02 2011 07:09 AM
-----

Posts I've Made

In Topic: What happens if I change host??

19 July 2006 - 12:57 AM

be sure your versions of MySQL match between hosts...

I moved my cart recently, and the versions were different. When I saved my database from Host A, the SQL syntax was different. Before I uploaded to Host B, I had to do a find and replace in the sql file... don't remember the exact change, but it was something about the TYPE=MyISAM statement.

Once I figured out what was going on, it was easy to fix... Also, both hosts A & B were useless for support... once they hear it's a SQL database or script issue, they don't want to help. So I was on my own to resolve the problem.

You may be luckier than I was.

Lorne

In Topic: Can you help? Default fields in a table?

02 June 2006 - 04:02 PM

thanks gentlemen...

(I assume :P )


Lorne

In Topic: Can you help? Default fields in a table?

02 June 2006 - 12:56 AM

You can actually find it yourself in CS package.

its under
/var/database/install/scheme.sql

Every create table script with all their fields.



thanks...

sorry.. I'm pretty new to SQL... do you have a recommendation for an offline SQLeditor that is either free or inexpensive?

thanks,

Lorne

In Topic: Canadian Taxes... Tax on tax?

25 May 2006 - 12:32 AM

FYI

I have an answer from Ilya...

The cart is not currently designed to allow multiple sales taxes to be applied "side by side", only "piggybacked" on each other.



regards,

Lorne