[Tony DiMera]

Originally posted by PlurPlanet
Ok, here is a zip file with all the queries that you can do in phpMyAdmin. You will want to open each text file included, copy and paste them into phpMyAdmin and run the queries.
Be sure to run the queries in the "create_tables.txt" file FIRST. Then run the queries listed in the other .txt files (it doesn't matter what order) individually. Each of those queries will probably take a few minutes to execute. After those are finished you should upload the weather_template.php to your fourms/admin folder and run that in your browser. That is just a small file that will install all the templates for you. After that you can go into your Admin CP and turn the weather on under your mYvBindex options.

I did that but for what was in this txt file:

PHP Code:

CREATE TABLE weather_country (
  countryid smallint(6) NOT NULL auto_increment,
  regionid smallint(6) NOT NULL default '0',
  country_title varchar(50) NOT NULL default '',
  PRIMARY KEY  (countryid)
) TYPE=MyISAM; 


I got this error:

PHP Code:

Error 
SQL-query :  [Edit] 

CREATE TABLE `weather_country` (`countryid` SMALLINT(6) NOT NULL AUTO_INCREMENT, `regionid` SMALLINT(6) DEFAULT '0' NOT NULL, `country_title` VARCHAR(50) NOT NULL ) TYPE = MYISAM comment = 'PRIMARY KEY  (countryid)'

MySQL said: 


Incorrect table definition; There can only be one auto column and it must be defined as a key

Back