Australia Post 3.011c - SQL error

[johnnyp]

Hi guys,

 

Trying to install the Auspost Shipping module Ver 3.0.11, but I am having an error coming up when running the auspost.sql file, included in the package.

 

I have included screen grab of the error.

 

 

 

I have even tried going back a release here and there with same prob.

 

Cheers,

John

[Guest]

Hi

 

I think it may be the language setting - try one of these changes:

 

DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

 

to

 

AUTO_INCREMENT=4 ; (takes the entire DEFAULT CHARSET bit out - the table should be created using the database default)

 

or

 

 

DEFAULT CHARSET latin1 AUTO_INCREMENT=4 ; (remove the equals sign)

 

or

 

DEFAULT CHARSET SET latin1 AUTO_INCREMENT=4 ; (change equals to SET)

 

Graeme