phpBB.de

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