ModphpBB3 Community Forum

LDM wrote: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!

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

4.0

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 ...

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 ...

add it to this? 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 ...

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 ...