phpBB3 to ModphpBB3 Instructions For 1.0.3/4 Version

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

[Flamer]

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

Yes i have uploaded everything except the config.php (as mentioned in the tutorial.)

[LDM]

If you are converting over and all the fils are there complete on the server, there's a chance your browser/forum is still running as old. Make sure you purge cache in ACP and/or open /cache folder via ftp and delete everything but the htaccess.

[Flamer]

i did but id didnt helped. Im have reuploaded my forum entirely and im going to retry it atm.

[LDM]

ok mate, post up if you get stuck.

[Flamer]

ok mate, post up if you get stuck.

Thanks man, but i still get that error. I really cant figure it out, i keep getting the same error.