Re: phpBB3 to ModphpBB3 Instructions
Posted: Mon Sep 08, 2008 2:53 pm
No, just the message "you didnt select a mode" in plain text.
ModphpBB3 Community Forum
Support Forum for ModphpBB3 and phpBB Community - Fully Modded phpBB3 Forum
https://modphpbb3.com/
phpBB3 to ModphpBB3 Instructions For 1.0.3/4 Version
Page 2 of 7
Re: phpBB3 to ModphpBB3 Instructions
Posted: Mon Sep 08, 2008 2:57 pm
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.
Re: phpBB3 to ModphpBB3 Instructions
Posted: Mon Sep 08, 2008 3:02 pm
Thanks a lot for your help.
Re: phpBB3 to ModphpBB3 Instructions
Posted: Mon Sep 08, 2008 3:03 pm
Try and add this sql to your database instead.
and this:
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;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;Re: phpBB3 to ModphpBB3 Instructions
Posted: Mon Sep 08, 2008 3:10 pm
Sorry for bothering you so much but, how do I do that?
Re: phpBB3 to ModphpBB3 Instructions
Posted: Mon Sep 08, 2008 3:12 pm
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.
Re: phpBB3 to ModphpBB3 Instructions
Posted: Mon Sep 08, 2008 4:12 pm
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!
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!
Re: phpBB3 to ModphpBB3 Instructions
Posted: Mon Sep 08, 2008 4:13 pm
Have you purged cache?
Re: phpBB3 to ModphpBB3 Instructions
Posted: Mon Sep 08, 2008 4:14 pm
Yes.
Re: phpBB3 to ModphpBB3 Instructions
Posted: Mon Sep 08, 2008 4:17 pm
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;Re: phpBB3 to ModphpBB3 Instructions
Posted: Mon Sep 08, 2008 4:19 pm
Sorry guys. The above sql query should work okay. LDM could you edit my first post and fix the error?
Re: phpBB3 to ModphpBB3 Instructions
Posted: Mon Sep 08, 2008 4:25 pm
Yep, will do.
Re: phpBB3 to ModphpBB3 Instructions
Posted: Mon Sep 08, 2008 4:28 pm
It seems like it worked, thank you!
Re: phpBB3 to ModphpBB3 Instructions
Posted: Mon Sep 08, 2008 4:31 pm
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!
Have updated Sewell's first post correcting small error, so if anyone downloaded before Carbarul's post, download again!
Re: phpBB3 to ModphpBB3 Instructions
Posted: Mon Sep 08, 2008 9:08 pm
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
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