Your phpBB Type: Standard phpBB3
MODs installed: Yes
Your knowledge: Beginner
Boardlink: http://www.onelifeboard.com/phpBB3_NEW
What have you done before the problem was there?
What have you already tryed to solve the problem?
Description and Message
Please can somebody help me? I currently have this portal working correctly off-line on my home computer. But when I upload it to my FTP space and also upload my SQL when I visit my website or should I say message board I get the following message.
General Error
SQL ERROR [ mysql4 ]
Table 'db309698248.phpbb_portal_config' doesn't exist [1146]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
I thought perhaps I needed to install it again? When I tried I got this error message
General Error
SQL ERROR [ mysql4 ]
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 5 [1064]
SQL
CREATE TABLE phpbb_portal_config ( config_name varchar(255) DEFAULT '' NOT NULL, config_value mediumtext NOT NULL, PRIMARY KEY (config_name) ) CHARACTER SET `utf8` COLLATE `utf8_bin`
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()
FILE: install/install_functions.php
LINE: 137
CALL: dbal_mysql->sql_query()
FILE: install/install_install.php
LINE: 115
CALL: b3p_create_table()
FILE: install/install_install.php
LINE: 73
CALL: install_install->load_schema()
FILE: install/index.php
LINE: 279
CALL: install_install->main()
FILE: install/index.php
LINE: 56
CALL: module->load()
