phpBB3 to ModphpBB3 Instructions For 1.0.3/4 Version

[Carbarul]

No, just the message "you didnt select a mode" in plain text.

[LDM]

Yep I see, I just tested it myself, looks like Sewell has added the wrong file. Give me 10 mins and will post again something to add the edit needed.

[Carbarul]

Thanks a lot for your help.

[LDM]

Try and add this sql to your database instead.

Code: Select all

CREATE TABLE 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;

and this:

Code: Select all

CREATE TABLE 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;

[Carbarul]

Sorry for bothering you so much but, how do I do that?

[LDM]

Within your hosting cp, there will be the database you set up. In that database, select your phpBB3 tables, then go to SQL and add those two items of text into that, then hit go.

[Carbarul]

Oh man,


I followed all the instructions, but now i get this error:


General Error
SQL ERROR [ mysqli ]

Table 'carbarul_wastelandphpbb3.phpbb_chat' doesn't exist [1146]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.


Help, please!

[LDM]

Have you purged cache?

[Carbarul]

Yes.

[LDM]

Sorry try these instead:

Code: Select all

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;

Code: Select all

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;

[Sewell]

Sorry guys. The above sql query should work okay. LDM could you edit my first post and fix the error?

[LDM]

Yep, will do.

[Carbarul]

It seems like it worked, thank you!

[LDM]

Good job, we got there in the end. Thanks for your help getting this post made again Sewell!

Have updated Sewell's first post correcting small error, so if anyone downloaded before Carbarul's post, download again!

[andyp99]

i have more or less got there cept 4 the arcade.the instructions say:

http://www.Yourforumdomain/(a subdirectory if you have one)/install_arcade/install.php

but got 404 error

should be arcade_install/install.php i think.

i too had select mode on chat install but as i once tried addingthis chat mod onits own once the code seems still there and all is ok.i am just testing everything now.Hopefully no bugs,will get back to you,thanks guys,will sort u out in a couple of days 4 this