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

https://modphpbb3.com/viewtopic.php?t=308

Page 5 of 7

Re: phpBB3 to ModphpBB3 Instructions

Posted: Sun Sep 21, 2008 1:35 am
by Sewell
Have added your modules in admin. You may need to add more of the arcade modules, I wasn't sure if it was a permissions setting the fact that I could only see one arcade module in there.

Re: phpBB3 to ModphpBB3 Instructions

Posted: Sun Sep 21, 2008 4:55 am
by nyunyu
Thank you sewell,
I see that site announcement didn't show in general tab. Soo, I play around and add another announcement module under board configuration category and it works!
Thanks!

Re: phpBB3 to ModphpBB3 Instructions

Posted: Tue Sep 23, 2008 6:44 pm
by Sewell
Glad it's all sorted now nyunyu! Remember to add the arcade modules to the arcade tab if you hadn't already.

Re: phpBB3 to ModphpBB3 Instructions

Posted: Sun Oct 05, 2008 9:27 pm
by Brandon
Im having a mysql problem. When i try to run the mysql file he included i get this :

SQL query:

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

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' at line 13


im willign to pay 5 dollars paypal if you can help me fix it :) need it asap

Re: phpBB3 to ModphpBB3 Instructions

Posted: Sun Oct 05, 2008 9:30 pm
by Brandon
also, go to allblab.com, how do i fix this?

Re: phpBB3 to ModphpBB3 Instructions

Posted: Mon Oct 06, 2008 12:28 am
by Sewell

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Table 'db254922863.phpb_config' doesn't exist [1146]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Add the correct database details to the config.php

Re: phpBB3 to ModphpBB3 Instructions

Posted: Fri Oct 10, 2008 11:24 am
by Brandon
well,i added it, and i must say i love phpbb3modddd :mrgreen: :mrgreen:

wanna see more styles though

Re: phpBB3 to ModphpBB3 Instructions

Posted: Fri Oct 10, 2008 9:24 pm
by LDM
Yep so do I!

Re: phpBB3 to ModphpBB3 Instructions

Posted: Mon Nov 03, 2008 2:34 am
by importrcr13
Brandon wrote:Im having a mysql problem. When i try to run the mysql file he included i get this :

SQL query:

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

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' at line 13


im willign to pay 5 dollars paypal if you can help me fix it :) need it asap
remove the ( ' ) infront and behind the phpbb_announcement_centre so it looks like:
CREATE TABLE phpbb_announcement_centre (

see if that works

Re: phpBB3 to ModphpBB3 Instructions

Posted: Sun Dec 07, 2008 2:01 am
by Sroufe7
importrcr13 wrote:
remove the ( ' ) infront and behind the phpbb_announcement_centre so it looks like:
CREATE TABLE phpbb_announcement_centre (

see if that works
I am having the same problem. I removed the (') and it comes up with this:
SQL query:

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

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' at line 13

Re: phpBB3 to ModphpBB3 Instructions

Posted: Sun Dec 07, 2008 2:36 am
by 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');

Re: phpBB3 to ModphpBB3 Instructions

Posted: Sun Dec 07, 2008 2:42 am
by 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.

Re: phpBB3 to ModphpBB3 Instructions

Posted: Sun Dec 07, 2008 2:46 am
by 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;

Re: phpBB3 to ModphpBB3 Instructions

Posted: Sun Dec 07, 2008 2:52 am
by 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

Re: phpBB3 to ModphpBB3 Instructions

Posted: Sun Dec 07, 2008 2:56 am
by 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 );
All times are UTC
Page 5 of 7

Powered by phpBB® Forum Software © phpBB Limited