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
phpBB3 to ModphpBB3 Instructions For 1.0.3/4 Version
Re: phpBB3 to ModphpBB3 Instructions
Tried that and I got this:
Re: phpBB3 to ModphpBB3 Instructions
It sounds like your host is using an old MYSQL version, any ideas what it's running?
Re: phpBB3 to ModphpBB3 Instructions
4.0LDM wrote:It sounds like your host is using an old MYSQL version, any ideas what it's running?
Re: phpBB3 to ModphpBB3 Instructions
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.
Re: phpBB3 to ModphpBB3 Instructions
Will do, thank you for your help!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.
Re: phpBB3 to ModphpBB3 Instructions
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:
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!
I succesfully installed the Arcade but when i try to install the Gallery i get the following error:
I CHMODDED it to 755 and 777 but both without any succes.Language file gallery_install.php couldn't be opened.
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!
Re: phpBB3 to ModphpBB3 Instructions
Would be thanks in advance srry for typo/.Flamer wrote: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:I CHMODDED it to 755 and 777 but both without any succes.Language file gallery_install.php couldn't be opened.
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!
Re: phpBB3 to ModphpBB3 Instructions
Have you uploaded the whole gallery install folder. The whole install needs uploading not just the file.
Re: phpBB3 to ModphpBB3 Instructions
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.
Re: phpBB3 to ModphpBB3 Instructions
So you have fully transferred all the files and folders in the modphpbb3 zip.
Re: phpBB3 to ModphpBB3 Instructions
Yes i have uploaded everything except the config.php (as mentioned in the tutorial.)LDM wrote:So you have fully transferred all the files and folders in the modphpbb3 zip.
Re: phpBB3 to ModphpBB3 Instructions
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.
Re: phpBB3 to ModphpBB3 Instructions
i did but id didnt helped. Im have reuploaded my forum entirely and im going to retry it atm.
Re: phpBB3 to ModphpBB3 Instructions
ok mate, post up if you get stuck.
Re: phpBB3 to ModphpBB3 Instructions
Thanks man, but i still get that error. I really cant figure it out, i keep getting the same error.LDM wrote:ok mate, post up if you get stuck.