MySQL 4 > 5

JSETCman · Bericht door **JSETCman** » 31 mei 2010, 09:58

Adres van je forum:
http://www.alpha-online.nl/ingodsveiligehanden
Event. modificaties op je forum:
Standaard phpBB forum
Wanneer ontstond het probleem?
Na verloop van tijd na verhuizing naar nieuwe server
phpBB versie: 3.0.4

Heb je onlangs iets veranderd aan je forum?
Na de verhuizing met MySQL 5.0 versie nog een tijd goed gewerkt.
Wat is het probleem?

Kan geen nieuwe posts plaatsen op forum, krijg dan volgende melding:

Algemene fout
SQL ERROR [ mysql4 ]

Field 'topic_last_poster_name' doesn't have a default value [1364]

SQL

INSERT INTO phpbb_topics (topic_poster, topic_time, forum_id, icon_id, topic_approved, topic_title, topic_first_poster_name, topic_first_poster_colour, topic_type, topic_time_limit, topic_attachment) VALUES (53, 1275294686, 67, 0, 1, 'Nieuw koffiepraatje', 'webmaster', '', 0, 0, 0)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/functions_posting.php
LINE: 1850
CALL: dbal_mysql->sql_query()

FILE: posting.php
LINE: 1001
CALL: submit_post()

Heb geprobeerd nu ook nog geprobeerd via upgrades > 3.04 > 05 > 06 > 07 PL uit te voeren. Komt er dan niet door en krijg alleen een scherm met FOUT erop in installatiescherm te zien.

In database zie ik bij users steeds [BLOB - 853 Bytes] staan ipv de genodigde namen zichtbaar.

Hoor graag of er iemand is die dit probleem herkent en een oplossing weet.

Alvast dank voor de te nemen moeite.

Jeroen · Bericht door **Jeroen** » 31 mei 2010, 10:01

Lees even dit Engelstalige artikel op phpBB.com door, daar wordt precies het probleem beschreven wat jij nu waarschijnlijk ook hebt.

JSETCman · Bericht door **JSETCman** » 31 mei 2010, 10:04

Pietje schreef:Lees even dit Engelstalige artikel op phpBB.com door, daar wordt precies het probleem beschreven wat jij nu waarschijnlijk ook hebt.

Ik had deze link al in een andere post opgemerkt en heb het script gedraaid op de site.
Kreeg keurig een heel lange lijst met aanpassingen terug.
Heb het gedraaid voor de versie phpBB 3.04 die momenteel gebruikt wordt.

Echter kan ik nog steeds niet berichten plaatsen. Overigens kan ik wel gewoon in mijn beheer en bestaande artikelen bewerken.

Nog een suggestie?

Bericht door **Paul** » 31 mei 2010, 12:53

Heb je de queries daarna ook uitgevoerd zoals uitgelegd in dat artikel?

JSETCman · Bericht door **JSETCman** » 31 mei 2010, 13:47

paul schreef:Heb je de queries daarna ook uitgevoerd zoals uitgelegd in dat artikel?

Ok, daar zat dus van mij nog een fout, ik dacht als leekgebruiker van MySQL dat het om een script ging die automatisch uitgevoerd werd. Bedankt voor de tip.

Heb alle queries stuk voor stuk in mysql uitgevoerd, waarbij bij 8 stuks een foutmelding terug kwam. Heeft het nut die queries hier te posten met hun foutmeldingen?

Jeroen · Bericht door **Jeroen** » 31 mei 2010, 13:50

JSETCman schreef:Heeft het nut die queries hier te posten met hun foutmeldingen?

Is natuurlijk wel handig

Dan kunnen wij kijken waar het mogelijk mis gaat.

JSETCman · Bericht door **JSETCman** » 31 mei 2010, 13:56

Pietje schreef:
JSETCman schreef:Heeft het nut die queries hier te posten met hun foutmeldingen?
Is natuurlijk wel handig Dan kunnen wij kijken waar het mogelijk mis gaat.

Code: Selecteer alles

USE ingodsveiligehanden;

# Table: 'phpbb_attachments'
# Table: 'phpbb_acl_groups'
# Table: 'phpbb_acl_options'
# Table: 'phpbb_acl_roles'
# Table: 'phpbb_acl_roles_data'
# Table: 'phpbb_acl_users'
# Table: 'phpbb_banlist'
# Table: 'phpbb_bbcodes'
# Table: 'phpbb_bookmarks'
# Table: 'phpbb_bots'
# Table: 'phpbb_config'

# Table: 'phpbb_confirm'
ALTER TABLE phpbb_confirm 
MODIFY confirm_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY confirm_type tinyint(3) DEFAULT '0' NOT NULL,
MODIFY code varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY seed int(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY attempts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Krijg ik foutmelding:


Fout
SQL-query:
ALTER TABLE phpbb_confirm MODIFY confirm_id char( 32 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY session_id char( 32 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY confirm_type tinyint( 3 ) DEFAULT '0' NOT NULL , MODIFY code varchar( 8 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY seed int( 10 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY attempts mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , DEFAULT CHARSET = utf8 COLLATE = utf8_bin; 
MySQL retourneerde: 
#1054 - Unknown column 'attempts' in 'phpbb_confirm'


# Table: 'phpbb_disallow'
# Table: 'phpbb_drafts'
# Table: 'phpbb_extensions'
# Table: 'phpbb_extension_groups'



# Table: 'phpbb_forums'
ALTER TABLE phpbb_forums 
MODIFY forum_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_parents mediumtext NOT NULL COLLATE utf8_bin,
MODIFY forum_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_desc text NOT NULL COLLATE utf8_bin,
MODIFY forum_desc_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
MODIFY forum_desc_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_link varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_password varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_style mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_image varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_rules text NOT NULL COLLATE utf8_bin,
MODIFY forum_rules_link varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_rules_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_rules_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
MODIFY forum_rules_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_topics_per_page tinyint(4) DEFAULT '0' NOT NULL,
MODIFY forum_type tinyint(4) DEFAULT '0' NOT NULL,
MODIFY forum_status tinyint(4) DEFAULT '0' NOT NULL,
MODIFY forum_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_topics mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_topics_real mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_last_poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_last_post_subject varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_last_poster_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_last_poster_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_flags tinyint(4) DEFAULT '32' NOT NULL,
MODIFY forum_options int(20) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY display_subforum_list tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_indexing tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_icons tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_prune tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY prune_next int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY prune_days mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY prune_viewed mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY prune_freq mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



Krijg ik foutmelding mee terug:


Fout
SQL-query:
ALTER TABLE phpbb_forums MODIFY forum_id mediumint( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT , MODIFY parent_id mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY left_id mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY right_id mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY forum_parents mediumtext NOT NULL COLLATE utf8_bin, MODIFY forum_name varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_desc text NOT NULL COLLATE utf8_bin, MODIFY forum_desc_bitfield varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_desc_options int( 11 ) UNSIGNED DEFAULT '7' NOT NULL , MODIFY forum_desc_uid varchar( 8 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_link varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_password varchar( 40 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_style mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY forum_image varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_rules text NOT NULL COLLATE utf8_bin, MODIFY forum_rules_link varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_rules_bitfield varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_rules_options int( 11 ) UNSIGNED DEFAULT '7' NOT NULL , MODIFY forum_rules_uid varchar( 8 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_topics_per_page tinyint( 4 ) DEFAULT '0' NOT NULL , MODIFY forum_type tinyint( 4 ) DEFAULT '0' NOT NULL , MODIFY forum_status tinyint( 4 ) DEFAULT '0' NOT NULL , MODIFY forum_posts mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY forum_topics mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY forum_topics_real mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY forum_last_post_id mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY forum_last_poster_id mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY forum_last_post_subject varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_last_post_time int( 11 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY forum_last_poster_name varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_last_poster_colour varchar( 6 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY forum_flags tinyint( 4 ) DEFAULT '32' NOT NULL , MODIFY forum_options int( 20 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY display_subforum_list tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY display_on_index tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY enable_indexing tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY enable_icons tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY enable_prune tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY prune_next int( 11 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY prune_days mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY prune_viewed mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY prune_freq mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , DEFAULT CHARSET = utf8 COLLATE = utf8_bin; 
MySQL retourneerde: 
#1054 - Unknown column 'forum_options' in 'phpbb_forums'






# Table: 'phpbb_forums_access'
# Table: 'phpbb_forums_track'
# Table: 'phpbb_forums_watch'



# Table: 'phpbb_groups'
ALTER TABLE phpbb_groups 
MODIFY group_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY group_type tinyint(4) DEFAULT '1' NOT NULL,
MODIFY group_founder_manage tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_skip_auth tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY group_desc text NOT NULL COLLATE utf8_bin,
MODIFY group_desc_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY group_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
MODIFY group_desc_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY group_display tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_avatar varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY group_avatar_type tinyint(2) DEFAULT '0' NOT NULL,
MODIFY group_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY group_sig_chars mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_receive_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_message_limit mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_max_recipients mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_legend tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
DROP INDEX group_legend_name,
ADD KEY group_legend_name (group_legend, group_name),
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


Kreeg ik waarschuwingscherm weet u het zeker: Ja/Nee

Daarna deze foutmelding

Fout
SQL-query:
ALTER TABLE phpbb_groups MODIFY group_id mediumint( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT , MODIFY group_type tinyint( 4 ) DEFAULT '1' NOT NULL , MODIFY group_founder_manage tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY group_skip_auth tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY group_name varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY group_desc text NOT NULL COLLATE utf8_bin, MODIFY group_desc_bitfield varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY group_desc_options int( 11 ) UNSIGNED DEFAULT '7' NOT NULL , MODIFY group_desc_uid varchar( 8 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY group_display tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY group_avatar varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY group_avatar_type tinyint( 2 ) DEFAULT '0' NOT NULL , MODIFY group_avatar_width smallint( 4 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY group_avatar_height smallint( 4 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY group_rank mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY group_colour varchar( 6 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY group_sig_chars mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY group_receive_pm tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY group_message_limit mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY group_max_recipients mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY group_legend tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , DROP INDEX group_legend_name, ADD KEY group_legend_name( group_legend, group_name ) , DEFAULT CHARSET = utf8 COLLATE = utf8_bin; 
MySQL retourneerde: 
#1054 - Unknown column 'group_skip_auth' in 'phpbb_groups'





# Table: 'phpbb_icons'
# Table: 'phpbb_lang'
# Table: 'phpbb_log'
# Table: 'phpbb_moderator_cache'
# Table: 'phpbb_modules'
# Table: 'phpbb_poll_options'
# Table: 'phpbb_poll_votes'



# Table: 'phpbb_posts'
ALTER TABLE phpbb_posts 
MODIFY post_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY poster_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_approved tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY post_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY post_username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_subject varchar(255) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci,
MODIFY post_text mediumtext NOT NULL COLLATE utf8_bin,
MODIFY post_checksum varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY bbcode_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY bbcode_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_postcount tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY post_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_edit_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_edit_locked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DROP INDEX post_username,
ADD KEY post_username (post_username),
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


Kreeg ik waarschuwingstekst Ja/Nee

Daarna deze foutmelding

Fout
SQL-query:
ALTER TABLE phpbb_posts MODIFY post_id mediumint( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT , MODIFY topic_id mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY forum_id mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY poster_id mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY icon_id mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY poster_ip varchar( 40 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY post_time int( 11 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY post_approved tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY post_reported tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY enable_bbcode tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY enable_smilies tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY enable_magic_url tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY enable_sig tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY post_username varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY post_subject varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci, MODIFY post_text mediumtext NOT NULL COLLATE utf8_bin, MODIFY post_checksum varchar( 32 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY post_attachment tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY bbcode_bitfield varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY bbcode_uid varchar( 8 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY post_postcount tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY post_edit_time int( 11 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY post_edit_reason varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY post_edit_user mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY post_edit_count smallint( 4 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY post_edit_locked tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , DROP INDEX post_username, ADD KEY post_username( post_username ) , DEFAULT CHARSET = utf8 COLLATE = utf8_bin; 
MySQL retourneerde: 
#1091 - Can't DROP 'post_username'; check that column/key exists






# Table: 'phpbb_privmsgs'
ALTER TABLE phpbb_privmsgs 
MODIFY msg_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY root_level mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY author_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY author_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY message_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY message_subject varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY message_text mediumtext NOT NULL COLLATE utf8_bin,
MODIFY message_edit_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY message_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY bbcode_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY bbcode_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY message_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY message_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY to_address text NOT NULL COLLATE utf8_bin,
MODIFY bcc_address text NOT NULL COLLATE utf8_bin,
MODIFY message_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


Krijg ik deze foutmelding:

Fout
SQL-query:
ALTER TABLE phpbb_privmsgs MODIFY msg_id mediumint( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT , MODIFY root_level mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY author_id mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY icon_id mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY author_ip varchar( 40 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY message_time int( 11 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY enable_bbcode tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY enable_smilies tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY enable_magic_url tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY enable_sig tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY message_subject varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY message_text mediumtext NOT NULL COLLATE utf8_bin, MODIFY message_edit_reason varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY message_edit_user mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY message_attachment tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY bbcode_bitfield varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY bbcode_uid varchar( 8 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY message_edit_time int( 11 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY message_edit_count smallint( 4 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY to_address text NOT NULL COLLATE utf8_bin, MODIFY bcc_address text NOT NULL COLLATE utf8_bin, MODIFY message_reported tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , DEFAULT CHARSET = utf8 COLLATE = utf8_bin; 
MySQL retourneerde: 
#1054 - Unknown column 'message_reported' in 'phpbb_privmsgs'




# Table: 'phpbb_privmsgs_folder'
# Table: 'phpbb_privmsgs_rules'
# Table: 'phpbb_privmsgs_to'



# Table: 'phpbb_profile_fields'
ALTER TABLE phpbb_profile_fields 
MODIFY field_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY field_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY field_type tinyint(4) DEFAULT '0' NOT NULL,
MODIFY field_ident varchar(20) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY field_length varchar(20) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY field_minlen varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY field_maxlen varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY field_novalue varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY field_default_value varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY field_validation varchar(20) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY field_required tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_show_on_vt tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_show_profile tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_hide tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_no_view tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Krijg ik foutmelding:



Fout
SQL-query:
ALTER TABLE phpbb_profile_fields MODIFY field_id mediumint( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT , MODIFY field_name varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_type tinyint( 4 ) DEFAULT '0' NOT NULL , MODIFY field_ident varchar( 20 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_length varchar( 20 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_minlen varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_maxlen varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_novalue varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_default_value varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_validation varchar( 20 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY field_required tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY field_show_on_reg tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY field_show_on_vt tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY field_show_profile tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY field_hide tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY field_no_view tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY field_active tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY field_order mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , DEFAULT CHARSET = utf8 COLLATE = utf8_bin; 
MySQL retourneerde: 
#1054 - Unknown column 'field_show_on_vt' in 'phpbb_profile_fields'







# Table: 'phpbb_profile_fields_data'
# Table: 'phpbb_profile_fields_lang'
# Table: 'phpbb_profile_lang'
# Table: 'phpbb_ranks'



# Table: 'phpbb_reports'
ALTER TABLE phpbb_reports 
MODIFY report_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY reason_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY pm_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY report_closed tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY report_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY report_text mediumtext NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;



Krijg ik de volgende foutmelding

Fout
SQL-query:
ALTER TABLE phpbb_reports MODIFY report_id mediumint( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT , MODIFY reason_id smallint( 4 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY post_id mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY pm_id mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_id mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_notify tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY report_closed tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY report_time int( 11 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY report_text mediumtext NOT NULL COLLATE utf8_bin, DEFAULT CHARSET = utf8 COLLATE = utf8_bin; 
MySQL retourneerde: 
#1054 - Unknown column 'pm_id' in 'phpbb_reports'







# Table: 'phpbb_reports_reasons'
# Table: 'phpbb_search_results'
# Table: 'phpbb_search_wordlist'
# Table: 'phpbb_search_wordmatch'
# Table: 'phpbb_sessions'
# Table: 'phpbb_sessions_keys'
# Table: 'phpbb_sitelist'
# Table: 'phpbb_smilies'
# Table: 'phpbb_styles'
# Table: 'phpbb_styles_template'
# Table: 'phpbb_styles_template_data'
# Table: 'phpbb_styles_theme'
# Table: 'phpbb_styles_imageset'
# Table: 'phpbb_styles_imageset_data'
# Table: 'phpbb_topics'
# Table: 'phpbb_topics_track'
# Table: 'phpbb_topics_posted'
# Table: 'phpbb_topics_watch'
# Table: 'phpbb_user_group'



# Table: 'phpbb_users'
ALTER TABLE phpbb_users 
MODIFY user_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY user_type tinyint(2) DEFAULT '0' NOT NULL,
MODIFY group_id mediumint(8) UNSIGNED DEFAULT '3' NOT NULL,
MODIFY user_permissions mediumtext NOT NULL COLLATE utf8_bin,
MODIFY user_perm_from mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_regdate int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY username_clean varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_password varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_passchg int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_pass_convert tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_email varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_email_hash bigint(20) DEFAULT '0' NOT NULL,
MODIFY user_birthday varchar(10) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_lastvisit int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_lastmark int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_lastpost_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_lastpage varchar(200) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_last_confirm_key varchar(10) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_last_search int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_warnings tinyint(4) DEFAULT '0' NOT NULL,
MODIFY user_last_warning int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_login_attempts tinyint(4) DEFAULT '0' NOT NULL,
MODIFY user_inactive_reason tinyint(2) DEFAULT '0' NOT NULL,
MODIFY user_inactive_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_lang varchar(30) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_timezone decimal(5,2) DEFAULT '0' NOT NULL,
MODIFY user_dst tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_dateformat varchar(30) DEFAULT 'd M Y H:i' NOT NULL COLLATE utf8_bin,
MODIFY user_style mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_new_privmsg int(4) DEFAULT '0' NOT NULL,
MODIFY user_unread_privmsg int(4) DEFAULT '0' NOT NULL,
MODIFY user_last_privmsg int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_message_rules tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_full_folder int(11) DEFAULT '-3' NOT NULL,
MODIFY user_emailtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_topic_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_topic_sortby_type varchar(1) DEFAULT 't' NOT NULL COLLATE utf8_bin,
MODIFY user_topic_sortby_dir varchar(1) DEFAULT 'd' NOT NULL COLLATE utf8_bin,
MODIFY user_post_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_post_sortby_type varchar(1) DEFAULT 't' NOT NULL COLLATE utf8_bin,
MODIFY user_post_sortby_dir varchar(1) DEFAULT 'a' NOT NULL COLLATE utf8_bin,
MODIFY user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_notify_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY user_notify_type tinyint(4) DEFAULT '0' NOT NULL,
MODIFY user_allow_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY user_allow_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY user_allow_viewemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY user_allow_massemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY user_options int(11) UNSIGNED DEFAULT '230271' NOT NULL,
MODIFY user_avatar varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_avatar_type tinyint(2) DEFAULT '0' NOT NULL,
MODIFY user_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_sig mediumtext NOT NULL COLLATE utf8_bin,
MODIFY user_sig_bbcode_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_sig_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_from varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_icq varchar(15) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_aim varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_yim varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_msnm varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_jabber varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_website varchar(200) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_occ text NOT NULL COLLATE utf8_bin,
MODIFY user_interests text NOT NULL COLLATE utf8_bin,
MODIFY user_actkey varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_newpasswd varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_form_salt varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_new tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY user_reminded tinyint(4) DEFAULT '0' NOT NULL,
MODIFY user_reminded_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
DROP INDEX username_clean,
ADD UNIQUE username_clean (username_clean),
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


Kreeg ik waarschuwing weet u zeker Ja / Nee

Daarna foutmelding:

Fout
SQL-query:
ALTER TABLE phpbb_users MODIFY user_id mediumint( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT , MODIFY user_type tinyint( 2 ) DEFAULT '0' NOT NULL , MODIFY group_id mediumint( 8 ) UNSIGNED DEFAULT '3' NOT NULL , MODIFY user_permissions mediumtext NOT NULL COLLATE utf8_bin, MODIFY user_perm_from mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_ip varchar( 40 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_regdate int( 11 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY username varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY username_clean varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_password varchar( 40 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_passchg int( 11 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_pass_convert tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_email varchar( 100 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_email_hash bigint( 20 ) DEFAULT '0' NOT NULL , MODIFY user_birthday varchar( 10 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_lastvisit int( 11 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_lastmark int( 11 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_lastpost_time int( 11 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_lastpage varchar( 200 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_last_confirm_key varchar( 10 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_last_search int( 11 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_warnings tinyint( 4 ) DEFAULT '0' NOT NULL , MODIFY user_last_warning int( 11 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_login_attempts tinyint( 4 ) DEFAULT '0' NOT NULL , MODIFY user_inactive_reason tinyint( 2 ) DEFAULT '0' NOT NULL , MODIFY user_inactive_time int( 11 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_posts mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_lang varchar( 30 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_timezone decimal( 5, 2 ) DEFAULT '0' NOT NULL , MODIFY user_dst tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_dateformat varchar( 30 ) DEFAULT 'd M Y H:i' NOT NULL COLLATE utf8_bin, MODIFY user_style mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_rank mediumint( 8 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_colour varchar( 6 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_new_privmsg int( 4 ) DEFAULT '0' NOT NULL , MODIFY user_unread_privmsg int( 4 ) DEFAULT '0' NOT NULL , MODIFY user_last_privmsg int( 11 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_message_rules tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_full_folder int( 11 ) DEFAULT '-3' NOT NULL , MODIFY user_emailtime int( 11 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_topic_show_days smallint( 4 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_topic_sortby_type varchar( 1 ) DEFAULT 't' NOT NULL COLLATE utf8_bin, MODIFY user_topic_sortby_dir varchar( 1 ) DEFAULT 'd' NOT NULL COLLATE utf8_bin, MODIFY user_post_show_days smallint( 4 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_post_sortby_type varchar( 1 ) DEFAULT 't' NOT NULL COLLATE utf8_bin, MODIFY user_post_sortby_dir varchar( 1 ) DEFAULT 'a' NOT NULL COLLATE utf8_bin, MODIFY user_notify tinyint( 1 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_notify_pm tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY user_notify_type tinyint( 4 ) DEFAULT '0' NOT NULL , MODIFY user_allow_pm tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY user_allow_viewonline tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY user_allow_viewemail tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY user_allow_massemail tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY user_options int( 11 ) UNSIGNED DEFAULT '230271' NOT NULL , MODIFY user_avatar varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_avatar_type tinyint( 2 ) DEFAULT '0' NOT NULL , MODIFY user_avatar_width smallint( 4 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_avatar_height smallint( 4 ) UNSIGNED DEFAULT '0' NOT NULL , MODIFY user_sig mediumtext NOT NULL COLLATE utf8_bin, MODIFY user_sig_bbcode_uid varchar( 8 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_sig_bbcode_bitfield varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_from varchar( 100 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_icq varchar( 15 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_aim varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_yim varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_msnm varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_jabber varchar( 255 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_website varchar( 200 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_occ text NOT NULL COLLATE utf8_bin, MODIFY user_interests text NOT NULL COLLATE utf8_bin, MODIFY user_actkey varchar( 32 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_newpasswd varchar( 40 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_form_salt varchar( 32 ) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY user_new tinyint( 1 ) UNSIGNED DEFAULT '1' NOT NULL , MODIFY user_reminded tinyint( 4 ) DEFAULT '0' NOT NULL , MODIFY user_reminded_time int( 11 ) UNSIGNED DEFAULT '0' NOT NULL , DROP INDEX username_clean, ADD UNIQUE username_clean( username_clean ) , DEFAULT CHARSET = utf8 COLLATE = utf8_bin; 
MySQL retourneerde: 
#1054 - Unknown column 'user_new' in 'phpbb_users'


# Table: 'phpbb_warnings'
# Table: 'phpbb_words'
# Table: 'phpbb_zebra'

JSETCman · Bericht door **JSETCman** » 02 jun 2010, 19:53

JSETCman schreef:
Pietje schreef:
JSETCman schreef:Heeft het nut die queries hier te posten met hun foutmeldingen?
Is natuurlijk wel handig Dan kunnen wij kijken waar het mogelijk mis gaat.

Is er nog iemand die een oplossing weet voor het probleem waar ik tegenaan gelopen ben met mijn forum?

EelkeB · Bericht door **EelkeB** » 03 jun 2010, 07:30

Volgens mij gaan de fouten er stuk voor stuk over dat een bepaalde kolom niet bestaat in je database. Weet je zeker dat je het juiste script hebt genomen voor de phpBB-versie die je draait? Heb je tussentijds updates van phpBB gedaan sinds de database is veranderd?

AlbertPool · Bericht door **AlbertPool** » 03 jun 2010, 13:49

Je zei, dat je een update had geprobeerd. Misschien is deze gedeeltelijk verwerkt, waardoor je een script van 3.0.4/5/6/7 moet draaien. Afhankelijk van bij welke update het mis ging.

EelkeB · Bericht door **EelkeB** » 03 jun 2010, 13:54

Ah, inderdaad. Ik ben dan dus bang dat het daar mis gaat. Zie je kans om nog terug te gaan naar een backup van voordat je uberhaupt updates hebt geprobeerd? Dan zou je vervolgens eerst de aanpassingen moeten doen voor de move van mysql 4 naar 5, en pas daarna de update van phpBB uit moeten voeren.

MySQL 4 > 5

MySQL 4 > 5

Re: MySQL 4 > 5

Re: MySQL 4 > 5

Re: MySQL 4 > 5

Re: MySQL 4 > 5

Re: MySQL 4 > 5

Re: MySQL 4 > 5

Re: MySQL 4 > 5

Re: MySQL 4 > 5

Re: MySQL 4 > 5

Re: MySQL 4 > 5