[why-not]

Originally Posted by MooMan65

Hmm. After waiting for about half an hour on my 56k modem to apply the Database changes I get an error with the first damn query when it tried to create the forecast table:

CREATE TABLE forecast(

id int( 4 ) NOT NULL AUTO_INCREMENT ,
rid char( 2 ) default NULL ,
region varchar( 15 ) default NULL ,
cid char( 2 ) default NULL ,
country varchar( 33 ) default NULL ,
sid char( 2 ) NOT NULL default '',
state varchar( 20 ) default NULL ,
pid varchar( 5 ) NOT NULL default '',
place varchar( 120 ) default NULL ,
code varchar( 8 ) default NULL ,
PRIMARY KEY ( id ) ,
KEY forecast_rid_cid_sid_pid( rid, cid, sid, pid ) 
)ENGINE = MYISAM DEFAULT CHARSET = latin1

#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 12

I'm pretty sure it's because my PHP version is too old, which is a shame as this isn't my server so I don't have a choice as to upgrading the version. But this is a great hack though! Thanks!

Hi MooMan 65

Just remove that line.....

As it is the default chr/set anyways! It will cause problems with some mysql managers! Like in MyPHPAdmin, if you use browse and upload having the charset is ok, but if you try to run the create in the query text box you will get the same error you got!

change to.....

DROP TABLE IF EXISTS forecast;
CREATE TABLE forecast (
  id int(4) NOT NULL auto_increment,
  rid char(2) default NULL,
  region varchar(15) default NULL,
  cid char(2) default NULL,
  country varchar(33) default NULL,
  sid char(2) NOT NULL default '',
  state varchar(20) default NULL,
  pid varchar(5) NOT NULL default '',
  place varchar(120) default NULL,
  code varchar(8) default NULL,
  PRIMARY KEY  (id),
  KEY forecast_rid_cid_sid_pid (rid,cid,sid,pid)
);

Sonia