phpBB3 to ModphpBB3 Instructions For 1.0.3/4 Version

[LDM]

Add this:

Code: Select all

CREATE TABLE phpbb_announcement_centre (
  announcement_show tinyint (1) NOT NULL,
  announcement_enable_guests tinyint (1) NOT NULL,
  announcement_show_birthdays tinyint (1) NOT NULL,
  announcement_birthday_avatar tinyint (1) NOT NULL,
  announcement_draft text NOT NULL,
  announcement_draft_bbcode_uid varchar(8) DEFAULT '' NOT NULL,
  announcement_draft_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
  announcement_draft_bbcode_options mediumint(4) DEFAULT 0 NOT NULL,
  announcement_text text NOT NULL,
  announcement_text_bbcode_uid varchar(8) DEFAULT '' NOT NULL,
  announcement_text_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
  announcement_text_bbcode_options mediumint(4) DEFAULT 0 NOT NULL,
  announcement_text_guests text NOT NULL,
  announcement_text_guests_bbcode_uid varchar(8) DEFAULT 0 NOT NULL,
  announcement_text_guests_bbcode_bitfield varchar(255) DEFAULT 0 NOT NULL,
  announcement_text_guests_bbcode_options mediumint(4) DEFAULT 0 NOT NULL,
  announcement_title varchar(255) NOT NULL default '',
  announcement_title_guests varchar(255) NOT NULL default '',
  announcement_show_group varchar(255) NOT NULL default '');
  

INSERT INTO phpbb_announcement_centre (announcement_show, announcement_enable_guests, announcement_show_birthdays, announcement_birthday_avatar, announcement_title, announcement_text, announcement_draft, announcement_title_guests, announcement_text_guests, announcement_show_group) VALUES ('0', '1', '0', '0', 'Site Announcements', '[color=red][b]Site Announcements[/b][/color] can be seen here!! :mrgreen:', '[color=red][b]Draft Announcements[/b][/color] can be seen here!! :mrgreen:', 'Guest Announcements', '[color=green][b]Guest Announcements[/b][/color] can be seen here!! :wink:', '2');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('announcement_show_index', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('announcement_enable', '1');

[Sroufe7]

add it to this?

Code: Select all

CREATE TABLE `phpbb_announcement_centre` (
  `announcement_show` tinyint (1) NOT NULL,
  `announcement_enable` tinyint (1) NOT NULL,
  `announcement_enable_guests` tinyint (1) NOT NULL,
  `announcement_show_birthdays` tinyint (1) NOT NULL,
  `announcement_birthday_avatar` tinyint (1) NOT NULL,
  `announcement_draft` text NOT NULL,
  `announcement_text` text NOT NULL,
  `announcement_text_guests` text NOT NULL,
  `announcement_title` varchar(255) NOT NULL default '',
  `announcement_title_guests` varchar(255) NOT NULL default '',
  `announcement_show_group` varchar(255) NOT NULL default '')
  CHARACTER SET utf8 COLLATE utf8_bin;
  

INSERT INTO phpbb_announcement_centre (announcement_show, announcement_enable, announcement_enable_guests, announcement_show_birthdays, announcement_birthday_avatar, announcement_title, announcement_text, announcement_draft, announcement_title_guests, announcement_text_guests, announcement_show_group) VALUES ('0', '1', '1', '0', '0', 'Site Announcements', '[color=red][b]Site Announcements[/b][/color] can be seen here!! :mrgreen:', '[color=red][b]Draft Announcements[/b][/color] can be seen here!! :mrgreen:', 'Guest Announcements', '[color=green][b]Guest Announcements[/b][/color] can be seen here!! :wink:', '2');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_birthdays_ahead', '7');

CREATE TABLE phpbb_shoutbox (
	shout_id int(11) unsigned NOT NULL auto_increment,
	shout_user_id mediumint(8) NOT NULL,
	shout_time int(11) NOT NULL,
	shout_ip varchar(32) character set latin1 NOT NULL,
	shout_text text collate utf8_bin NOT NULL,
	shout_bbcode_bitfield varchar(255) character set latin1 NOT NULL,
	shout_bbcode_uid varchar(8) character set latin1 NOT NULL,
	shout_bbcode_flags int(11) unsigned NOT NULL default '7',
	PRIMARY KEY	(shout_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

ALTER TABLE phpbb_users ADD user_gender TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;

INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_last_auto_run', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_ignore_no_email', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_delete_choice', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_zero_poster_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_zero_poster_days', '15');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_days', '60');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_still_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_still_days', '30');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_not_logged_in_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_not_logged_in_days', '20');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_enable', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_protected_users', '');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_still_opt_zero', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_still_opt_inactive', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_still_opt_not_logged_in', '1');

ALTER TABLE phpbb_users ADD user_reminder_inactive INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE phpbb_users ADD user_reminder_zero_poster INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE phpbb_users ADD user_reminder_inactive_still INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE phpbb_users ADD user_reminder_not_logged_in INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';

INSERT INTO phpbb_config (config_name, config_value) VALUES ('amount_top_posters', '10');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('top_posters_hours', '24');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('top_posters_excl_adm', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('top_posters_excl_mod', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('top_posters_excl_ids', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('top_posters_excl_hours', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('birthday_emails', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('birthday_run', '');

INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('log_new_user', '1', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('description_word_count', 150);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('use_dynamic_description', 1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('append_keywords_first', 0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('global_keywords', 'replace, these, keywords, with your own, keywords');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('append_global_keywords', 1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('keyword_word_count', 50);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('use_dynamic_keywords', 1);

CREATE TABLE phpbb_chat (
        message_id int(11) unsigned NOT NULL auto_increment,
        chat_id int(11) unsigned NOT NULL default '0',
        user_id int(11) unsigned NOT NULL default '0',
        username varchar(255) NOT NULL default '',
        user_colour varchar(6) NOT NULL default '',
        message text NOT NULL,
        bbcode_bitfield varchar(255) NOT NULL default '',
        bbcode_uid varchar(5) NOT NULL default '',
        bbcode_options tinyint(1) unsigned NOT NULL default '7',
        time int(11) unsigned NOT NULL default '0',
        PRIMARY KEY  (message_id)
      ) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE phpbb_chat_sessions (
        user_id mediumint(8) unsigned NOT NULL default '0',
        username varchar(255) NOT NULL default '',
        user_colour varchar(6) NOT NULL default '',
        user_login int(11) unsigned NOT NULL default '0',
        user_firstpost int(11) unsigned NOT NULL default '0',
        user_lastpost int(11) unsigned NOT NULL default '0',
        user_lastupdate int(11) unsigned NOT NULL default '0',
        PRIMARY KEY  (user_id)
      ) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Sorry, i'm not the best at this stuff.

[LDM]

No thats just the announcement tables, if you are adding it to that one, you will need to run this:

Code: Select all

CREATE TABLE phpbb_announcement_centre (
  announcement_show tinyint (1) NOT NULL,
  announcement_enable_guests tinyint (1) NOT NULL,
  announcement_show_birthdays tinyint (1) NOT NULL,
  announcement_birthday_avatar tinyint (1) NOT NULL,
  announcement_draft text NOT NULL,
  announcement_draft_bbcode_uid varchar(8) DEFAULT '' NOT NULL,
  announcement_draft_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
  announcement_draft_bbcode_options mediumint(4) DEFAULT 0 NOT NULL,
  announcement_text text NOT NULL,
  announcement_text_bbcode_uid varchar(8) DEFAULT '' NOT NULL,
  announcement_text_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
  announcement_text_bbcode_options mediumint(4) DEFAULT 0 NOT NULL,
  announcement_text_guests text NOT NULL,
  announcement_text_guests_bbcode_uid varchar(8) DEFAULT 0 NOT NULL,
  announcement_text_guests_bbcode_bitfield varchar(255) DEFAULT 0 NOT NULL,
  announcement_text_guests_bbcode_options mediumint(4) DEFAULT 0 NOT NULL,
  announcement_title varchar(255) NOT NULL default '',
  announcement_title_guests varchar(255) NOT NULL default '',
  announcement_show_group varchar(255) NOT NULL default '');
 

INSERT INTO phpbb_announcement_centre (announcement_show, announcement_enable_guests, announcement_show_birthdays, announcement_birthday_avatar, announcement_title, announcement_text, announcement_draft, announcement_title_guests, announcement_text_guests, announcement_show_group) VALUES ('0', '1', '0', '0', 'Site Announcements', '[color=red][b]Site Announcements[/b][/color] can be seen here!! :mrgreen:', '[color=red][b]Draft Announcements[/b][/color] can be seen here!! :mrgreen:', 'Guest Announcements', '[color=green][b]Guest Announcements[/b][/color] can be seen here!! :wink:', '2');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('announcement_show_index', '0');


INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_birthdays_ahead', '7');

CREATE TABLE phpbb_shoutbox (
   shout_id int(11) unsigned NOT NULL auto_increment,
   shout_user_id mediumint(8) NOT NULL,
   shout_time int(11) NOT NULL,
   shout_ip varchar(32) character set latin1 NOT NULL,
   shout_text text collate utf8_bin NOT NULL,
   shout_bbcode_bitfield varchar(255) character set latin1 NOT NULL,
   shout_bbcode_uid varchar(8) character set latin1 NOT NULL,
   shout_bbcode_flags int(11) unsigned NOT NULL default '7',
   PRIMARY KEY   (shout_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

ALTER TABLE phpbb_users ADD user_gender TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;

INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_last_auto_run', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_ignore_no_email', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_delete_choice', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_zero_poster_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_zero_poster_days', '15');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_days', '60');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_still_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_still_days', '30');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_not_logged_in_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_not_logged_in_days', '20');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_enable', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_protected_users', '');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_still_opt_zero', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_still_opt_inactive', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('user_reminder_inactive_still_opt_not_logged_in', '1');

ALTER TABLE phpbb_users ADD user_reminder_inactive INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE phpbb_users ADD user_reminder_zero_poster INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE phpbb_users ADD user_reminder_inactive_still INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE phpbb_users ADD user_reminder_not_logged_in INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';

INSERT INTO phpbb_config (config_name, config_value) VALUES ('amount_top_posters', '10');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('top_posters_hours', '24');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('top_posters_excl_adm', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('top_posters_excl_mod', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('top_posters_excl_ids', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('top_posters_excl_hours', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('birthday_emails', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('birthday_run', '');

INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('log_new_user', '1', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('description_word_count', 150);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('use_dynamic_description', 1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('append_keywords_first', 0);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('global_keywords', 'replace, these, keywords, with your own, keywords');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('append_global_keywords', 1);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('keyword_word_count', 50);
INSERT INTO phpbb_config (config_name, config_value) VALUES ('use_dynamic_keywords', 1);

CREATE TABLE phpbb_chat (
        message_id int(11) unsigned NOT NULL auto_increment,
        chat_id int(11) unsigned NOT NULL default '0',
        user_id int(11) unsigned NOT NULL default '0',
        username varchar(255) NOT NULL default '',
        user_colour varchar(6) NOT NULL default '',
        message text NOT NULL,
        bbcode_bitfield varchar(255) NOT NULL default '',
        bbcode_uid varchar(5) NOT NULL default '',
        bbcode_options tinyint(1) unsigned NOT NULL default '7',
        time int(11) unsigned NOT NULL default '0',
        PRIMARY KEY  (message_id)
      ) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE phpbb_chat_sessions (
        user_id mediumint(8) unsigned NOT NULL default '0',
        username varchar(255) NOT NULL default '',
        user_colour varchar(6) NOT NULL default '',
        user_login int(11) unsigned NOT NULL default '0',
        user_firstpost int(11) unsigned NOT NULL default '0',
        user_lastpost int(11) unsigned NOT NULL default '0',
        user_lastupdate int(11) unsigned NOT NULL default '0',
        PRIMARY KEY  (user_id)
      ) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

[Sroufe7]

Now I got this error:

SQL query:

CREATE TABLE phpbb_shoutbox(
shout_id int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
shout_user_id mediumint( 8 ) NOT NULL ,
shout_time int( 11 ) NOT NULL ,
shout_ip varchar( 32 ) CHARACTER SET latin1 NOT NULL ,
shout_text text COLLATE utf8_bin NOT NULL ,
shout_bbcode_bitfield varchar( 255 ) CHARACTER SET latin1 NOT NULL ,
shout_bbcode_uid varchar( 8 ) CHARACTER SET latin1 NOT NULL ,
shout_bbcode_flags int( 11 ) unsigned NOT NULL default '7',
PRIMARY KEY ( shout_id )
) DEFAULT CHARSET = utf8 COLLATE = utf8_bin

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate utf8_bin NOT NULL,
shout_bbcode_bitfield varchar(25

[LDM]

It is the default Charset you are having the errors with, try this:

Code: Select all

CREATE TABLE phpbb_shoutbox(
shout_id int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
shout_user_id mediumint( 8 ) NOT NULL ,
shout_time int( 11 ) NOT NULL ,
shout_ip varchar( 32 ) CHARACTER SET latin1 NOT NULL ,
shout_text text COLLATE utf8_bin NOT NULL ,
shout_bbcode_bitfield varchar( 255 ) CHARACTER SET latin1 NOT NULL ,
shout_bbcode_uid varchar( 8 ) CHARACTER SET latin1 NOT NULL ,
shout_bbcode_flags int( 11 ) unsigned NOT NULL default '7',
PRIMARY KEY ( shout_id );

[Sroufe7]

Tried that and I got this:

SQL query:

CREATE TABLE phpbb_shoutbox(
shout_id int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
shout_user_id mediumint( 8 ) NOT NULL ,
shout_time int( 11 ) NOT NULL ,
shout_ip varchar( 32 ) CHARACTER SET latin1 NOT NULL ,
shout_text text COLLATE utf8_bin NOT NULL ,
shout_bbcode_bitfield varchar( 255 ) CHARACTER SET latin1 NOT NULL ,
shout_bbcode_uid varchar( 8 ) CHARACTER SET latin1 NOT NULL ,
shout_bbcode_flags int( 11 ) unsigned NOT NULL default '7',
PRIMARY KEY ( shout_id )

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE utf8_bin NOT NULL ,
shout_bbcode_bitfield varchar( 255

[LDM]

It sounds like your host is using an old MYSQL version, any ideas what it's running?

[Sroufe7]

It sounds like your host is using an old MYSQL version, any ideas what it's running?

4.0

[LDM]

I'm not 100% but I'm sure I saw on phpbb.com that many problems like that are because running MYSQL prior to 4.1, might be worth having a look on that.

[Sroufe7]

I'm not 100% but I'm sure I saw on phpbb.com that many problems like that are because running MYSQL prior to 4.1, might be worth having a look on that.

Will do, thank you for your help!

[Flamer]

Hi there! Wonderfull stuff this, only i cant get it to work. I tried it 2 times but still no succes. Maybe you know what im doing wrong over here.

I succesfully installed the Arcade but when i try to install the Gallery i get the following error:

Language file gallery_install.php couldn't be opened.

I CHMODDED it to 755 and 777 but both without any succes.
Then i reuploaded my backup and did another try, same error.

I hope you now how to help me out with it.

Thanks in regard!

[Flamer]

Hi there! Wonderfull stuff this, only i cant get it to work. I tried it 2 times but still no succes. Maybe you know what im doing wrong over here.

I succesfully installed the Arcade but when i try to install the Gallery i get the following error:

Language file gallery_install.php couldn't be opened.

I CHMODDED it to 755 and 777 but both without any succes.
Then i reuploaded my backup and did another try, same error.

I hope you now how to help me out with it.

Thanks in regard!

Would be thanks in advance srry for typo/.

[LDM]

Have you uploaded the whole gallery install folder. The whole install needs uploading not just the file.

[Flamer]

I uploaded the whole directory. When i mentioned that i chommed the file i ment the file givin in the error. I found that the file is located in the language/en/mods folder.

[LDM]

So you have fully transferred all the files and folders in the modphpbb3 zip.