Moin Typoianer!
Ich bekomme eine Fehlermeldung angezeigt, wenn ich probiere eine Webbenutzer anzulegen:
"2: SQL error: 'Unknown column 'static_info_country' in 'field list'' (fe_users:NEW4368e44b4fc5c)"
Kann mir jemand mal sagen, was das zu bedeuten hat und wie ich diesen Meldung wieder in den Griff bekommen!
Meinen verbindlichsten Dank!
Steven
Hast Du die Extension 'static_info_tables' schon installiert ??
Wenn nicht, dann hier
http://www.alpha-online.org/typo/index.php?id=472&tx_ttnews[tt_news]=507 klicken und installieren #giggle#
Ja ist installiert! Ich glaube ich muss die Tabelle manuel in der Datenbank eintragen. Weiß jemand wie das von Statten geht?
Oder ist es doch ein anderer Fehler?
Habe ich in meiner Datenbank gefunden:
SQL-Befehl:
EXPLAIN SELECT *
FROM `test`.`sys_log`
WHERE `uid` LIKE '%static_info_country%'
OR `userid` LIKE '%static_info_country%'
OR `action` LIKE '%static_info_country%'
OR `recuid` LIKE '%static_info_country%'
OR `tablename` LIKE CONVERT( _utf8 '%static_info_country%'
USING latin1 )
COLLATE latin1_swedish_ci
OR `recpid` LIKE '%static_info_country%'
OR `error` LIKE '%static_info_country%'
OR `details` LIKE CONVERT( _utf8 '%static_info_country%'
USING latin1 )
COLLATE latin1_swedish_ci
OR `tstamp` LIKE '%static_info_country%'
OR `type` LIKE '%static_info_country%'
OR `details_nr` LIKE '%static_info_country%'
OR `IP` LIKE CONVERT( _utf8 '%static_info_country%'
USING latin1 )
COLLATE latin1_swedish_ci
OR `log_data` LIKE '%static_info_country%'
OR `event_pid` LIKE '%static_info_country%'
OR `NEWid` LIKE CONVERT( _utf8 '%static_info_country%'
USING latin1 )
COLLATE latin1_swedish_ci
Was soll da verkehr sein?
'static_info_country' ist ein Feld Deiner Tabelle 'fe_users';
das Dump der Tabellenstruktur sieht so aus:
CREATE TABLE `fe_users` (
`uid` int(11) unsigned NOT NULL auto_increment,
`pid` int(11) unsigned NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`username` varchar(50) NOT NULL default '',
`password` varchar(40) NOT NULL default '',
`usergroup` tinyblob NOT NULL,
`disable` tinyint(4) unsigned NOT NULL default '0',
`starttime` int(11) unsigned NOT NULL default '0',
`endtime` int(11) unsigned NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`address` tinytext NOT NULL,
`telephone` varchar(25) NOT NULL default '',
`fax` varchar(25) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`crdate` int(11) unsigned NOT NULL default '0',
`cruser_id` int(11) unsigned NOT NULL default '0',
`lockToDomain` varchar(50) NOT NULL default '',
`deleted` tinyint(3) unsigned NOT NULL default '0',
`uc` blob NOT NULL,
`title` varchar(40) NOT NULL default '',
`zip` varchar(20) NOT NULL default '',
`city` varchar(50) NOT NULL default '',
`country` varchar(60) NOT NULL default '',
`www` varchar(80) NOT NULL default '',
`company` varchar(80) NOT NULL default '',
`image` tinyblob NOT NULL,
`TSconfig` blob NOT NULL,
`module_sys_dmail_category` int(10) unsigned NOT NULL default '0',
`module_sys_dmail_html` tinyint(3) unsigned NOT NULL default '0',
`fe_cruser_id` int(10) unsigned NOT NULL default '0',
`lastlogin` int(10) unsigned NOT NULL default '0',
`is_online` int(10) unsigned NOT NULL default '0',
`static_info_country` char(3) NOT NULL default '',
`zone` varchar(45) NOT NULL default '',
`language` char(2) NOT NULL default '',
`first_name` varchar(50) NOT NULL default '',
`last_name` varchar(50) NOT NULL default '',
`date_of_birth` int(11) NOT NULL default '0',
`tt_products_memoItems` tinytext NOT NULL,
`tt_products_discount` int(11) NOT NULL default '0',
`gender` int(11) unsigned NOT NULL default '0',
`status` int(11) unsigned NOT NULL default '0',
`comments` text NOT NULL,
`tx_chcforum_aim` tinytext NOT NULL,
`tx_chcforum_yahoo` tinytext NOT NULL,
`tx_chcforum_msn` tinytext NOT NULL,
`tx_chcforum_customim` tinytext NOT NULL,
PRIMARY KEY (`uid`),
KEY `parent` (`pid`),
KEY `username` (`username`),
KEY `is_online` (`is_online`),
KEY `pid` (`pid`,`username`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;
Eventuell fügst Du das fehlende Feld per phpMyAdmin an der richtigen Stelle (hinter 'is_online') mit den richtigen Einstellungen ein ?