Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SMS Me Please Help


Guest

Recommended Posts

When I try to instrall the .sql files I get these errors :

 

1st :

 

Server: xxxxxxxxx Database: xxxxxxxxxx Table: countries

Error

SQL-query:

 

# Enable Sample countries file

# Paste these statements into your favourite

# Mysql admin tool or run it from the command line with:

#

# mysql -u username -ppassword dbname < /path/to/enable_sample_countries.sql

UPDATE `countries` SET `dialling_prefix` = '+1' WHERE `countries_iso_code_3` = 'CAN'

MySQL said:

 

#1054 - Unknown column 'dialling_prefix' in 'field list'

 

--------------------------------------------------------------------------------------------------------------

Second One :

 

Server: xxxxxxxxx Database: xxxxxxxxxxx

Error

SQL-query:

 

CREATE TABLE `sms_defaults` (

 

`sms_default_message_id` int( 32 ) NOT NULL AUTO_INCREMENT ,

`sms_default_message_name` varchar( 50 ) NOT NULL default '',

`sms_language_id` int( 5 ) NOT NULL default '0',

`sms_default_message_text` varchar( 160 ) default NULL ,

PRIMARY KEY ( `sms_default_message_id` )

) ENGINE = MYISAM DEFAULT CHARSET = latin1

MySQL said:

 

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 7

------------------------------------------------------------------------------------------------------

 

Can anyone offer any help at all.

 

Thanks

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...