ich kämpfe schon seit längeren mit folgendem Problem.
Unknown column 'user_new' in 'where clause' [1054]
Wenn ich die aktuelle Version des Board aufspiele und dann das Datenbankupdate aus führe erhalte ich folgende Fehlermeldungen.
Was bedeutet Unknown "column 'user_new' in 'where clause' [1054]"?Updating database to latest stable release
Database type :: mysql4
Previous version :: 3.0.5
Updated version :: 3.0.6
Updating database schema
Progress :: . . . . . . . . . . . . . Done
Result :: Some queries failed, the statements and errors are listing below.
* Error :: ALTER command denied to user 'magic'@'localhost' for table 'phpbb3_confirm'
SQL :: ALTER TABLE `phpbb3_confirm` ADD COLUMN `attempts` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL
* Error :: ALTER command denied to user 'magic'@'localhost' for table 'phpbb3_users'
SQL :: ALTER TABLE `phpbb3_users` ADD COLUMN `user_new` tinyint(1) UNSIGNED DEFAULT '1' NOT NULL
* Error :: ALTER command denied to user 'magic'@'localhost' for table 'phpbb3_users'
SQL :: ALTER TABLE `phpbb3_users` ADD COLUMN `user_reminded` tinyint(4) DEFAULT '0' NOT NULL
* Error :: ALTER command denied to user 'magic'@'localhost' for table 'phpbb3_users'
SQL :: ALTER TABLE `phpbb3_users` ADD COLUMN `user_reminded_time` int(11) UNSIGNED DEFAULT '0' NOT NULL
* Error :: ALTER command denied to user 'magic'@'localhost' for table 'phpbb3_groups'
SQL :: ALTER TABLE `phpbb3_groups` ADD COLUMN `group_skip_auth` tinyint(1) UNSIGNED DEFAULT '0' NOT NULL
* Error :: ALTER command denied to user 'magic'@'localhost' for table 'phpbb3_privmsgs'
SQL :: ALTER TABLE `phpbb3_privmsgs` ADD COLUMN `message_reported` tinyint(1) UNSIGNED DEFAULT '0' NOT NULL
* Error :: ALTER command denied to user 'magic'@'localhost' for table 'phpbb3_reports'
SQL :: ALTER TABLE `phpbb3_reports` ADD COLUMN `pm_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL
* Error :: ALTER command denied to user 'magic'@'localhost' for table 'phpbb3_profile_fields'
SQL :: ALTER TABLE `phpbb3_profile_fields` ADD COLUMN `field_show_on_vt` tinyint(1) UNSIGNED DEFAULT '0' NOT NULL
* Error :: ALTER command denied to user 'magic'@'localhost' for table 'phpbb3_forums'
SQL :: ALTER TABLE `phpbb3_forums` ADD COLUMN `forum_options` int(20) UNSIGNED DEFAULT '0' NOT NULL
* Error :: ALTER command denied to user 'magic'@'localhost' for table 'phpbb3_users'
SQL :: ALTER TABLE `phpbb3_users` CHANGE `user_options` `user_options` int(11) UNSIGNED DEFAULT '230271' NOT NULL
* Error :: INDEX command denied to user 'magic'@'localhost' for table 'phpbb3_reports'
SQL :: CREATE INDEX post_id ON phpbb3_reports(post_id)
* Error :: INDEX command denied to user 'magic'@'localhost' for table 'phpbb3_reports'
SQL :: CREATE INDEX pm_id ON phpbb3_reports(pm_id)
* Error :: INDEX command denied to user 'magic'@'localhost' for table 'phpbb3_posts'
SQL :: CREATE INDEX post_username ON phpbb3_posts(post_username)
This is probably nothing to worry about, update will continue. Should this fail to complete you may need to seek help at our support forums. See README for details on how to obtain advice.
Updating data
Progress :: .
Fatal error: SQL ERROR [ mysql4 ]
Unknown column 'user_new' in 'where clause' [1054]
SQL
SELECT 1 FROM phpbb3_users WHERE user_new = 0 LIMIT 1
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()
FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()
FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()
FILE: install/database_update.php
LINE: 1432
CALL: dbal->sql_query_limit()
FILE: install/database_update.php
LINE: 393
CALL: change_database_data()
in /usr/virtualweb/kdl/phpBB3/includes/db/dbal.php on line 679
Hinzufügen sollte ich vieleicht, dass ich eine konvertierte Version benutze.
Besteht die Möglichkeit ein frisches System zu installieren und nur Benutzer und Einträge zu übernehmen? Welche Tabellen müsste ich dann gezielt importieren?
Danke im Vorraus
Sollte ich wichtige Informationen vergessen haben, dann folgen diese natürlich auf Anfrage ...
