[TYPO3] Static Info Tables (static_info_tables) DB update Problem !!!
Aji Johannes
aji.yahya at gmail.com
Thu Jan 25 11:03:26 CET 2007
Hallo List,
after i started with installing Fe User Registration, i notice that this
extension requires the (static_info_tables) version 2.0.1 or higher. i
update the (static_info_tables) to version 2.0.2 and i get this Warning
:Table error!Probably one or more required fields/tables are missing in
the database!
Update needed, i updated it but every time i go to the ext. information
i get the same.
Changing fields
ALTER TABLE static_countries CHANGE cn_iso_2 cn_iso_2 char(2) NOT NULL
default '';
Current value: varchar(2) default ''
ALTER TABLE static_countries CHANGE cn_iso_3 cn_iso_3 char(3) NOT NULL
default '';
Current value: varchar(3) default ''
ALTER TABLE static_countries CHANGE cn_tldomain cn_tldomain char(2) NOT
NULL default '';
Current value: varchar(2) default ''
ALTER TABLE static_countries CHANGE cn_currency_iso_3 cn_currency_iso_3
char(3) NOT NULL default '';
Current value: varchar(3) default ''
ALTER TABLE static_country_zones CHANGE zn_country_iso_2
zn_country_iso_2 char(2) NOT NULL default '';
Current value: varchar(2) default ''
ALTER TABLE static_country_zones CHANGE zn_country_iso_3
zn_country_iso_3 char(3) NOT NULL default '';
Current value: varchar(3) default ''
ALTER TABLE static_currencies CHANGE cu_iso_3 cu_iso_3 char(3) NOT NULL
default '';
Current value: varchar(3) default ''
ALTER TABLE static_languages CHANGE lg_iso_2 lg_iso_2 char(2) NOT NULL
default '';
Current value: varchar(2) default ''
ALTER TABLE static_languages CHANGE lg_typo3 lg_typo3 char(2) NOT NULL
default '';
Current value: varchar(2) default ''
ALTER TABLE static_languages CHANGE lg_country_iso_2 lg_country_iso_2
char(2) NOT NULL default '';
Current value: varchar(2) default ''
ALTER TABLE static_taxes CHANGE tx_country_iso_2 tx_country_iso_2
char(2) NOT NULL default '';
Current value: varchar(2) default ''
ALTER TABLE static_taxes CHANGE tx_country_iso_3 tx_country_iso_3
char(3) NOT NULL default '';
Current value: varchar(3) default ''
Import static data
static_territories Rows: 27 Table exists!
static_countries Rows: 240 Table exists!
static_country_zones Rows: 469 Table exists!
static_currencies Rows: 163 Table exists!
static_languages Rows: 187 Table exists!
static_taxes Rows: 35 Table exists!
the FE User Reg. is not working to, i think because of this Error or
Warnings.
please i neet your help, do you have any idea please?????
regards
Johannes
More information about the TYPO3-english
mailing list