[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