I run this query:
SELECT CONCAT("ALTER TABLE ",TABLE_SCHEMA,".",TABLE_NAME," CHARACTER SET utf8 COLLATE utf8_general_ci; ",
"ALTER TABLE ",TABLE_SCHEMA,".",TABLE_NAME," CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ")
AS alter_sql
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = caspiana_forum;
But it dont run and apear bellow error:
#1054 - Unknown column 'caspiana_forum' in 'where clause'
What do i do? Do i should replace "TABLE_NAME" with a specific name?
You need to wrap caspiana_forum with ''
So:
SELECT CONCAT("ALTER TABLE ",TABLE_SCHEMA,".",TABLE_NAME," CHARACTER SET utf8 COLLATE utf8_general_ci; ",
"ALTER TABLE ",TABLE_SCHEMA,".",TABLE_NAME," CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ")
AS alter_sql
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'caspiana_forum';
Thank you dear friend
Database succesfully moved to new host
But now forum apear bellow error:
------------------------------------------
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1045 - Access denied for user 'caspiana_forum'@'localhost' (using password: YES)
Query:
[READ] Unable to connect to MySQL server
--------------------------------------------
How i replace new database connect changing in mybb files?
Tips: database name and databes username have been changed on new host and so database server in new host is not on 'localhost' and it is on another sever.
Edit the inc/config.php file, it contains:
$config['database']['type'] = 'mysqli';
$config['database']['database'] = 'develop';
$config['database']['table_prefix'] = 'mybb_';
$config['database']['hostname'] = 'localhost';
$config['database']['username'] = 'username';
$config['database']['password'] = '********';
I changed config.php to new info, but my forum dont open!
$config['database']['type'] = 'mysqli';
$config['database']['database'] = 'caspian1_forum';
$config['database']['table_prefix'] = 'mybb_';
$config['database']['hostname'] = 'mysql1.persianwhois.com';
$config['database']['username'] = 'caspian1_forum';
$config['database']['password'] = 'xxxxxxx';
My admin server says that last day they upgrade database server to Mysql 5.6 and you must do changing in your script for connect to Mysql 5.6.
How can i do it changing?
What is the error you get ?
Nothig error, It is like while a website does not exist in world wide web.
This is my forum:
http://www.caspiana.ir/
please see it
^ if server error log exists at your web host panel then can you check its recent entries to find the cause
if direct help required, you may PM me temporary access to your web host control panel to check
I sent login info for you via pm
Thank you
(2015-06-04, 02:18 AM).m. Wrote: [ -> ]^ if server error log exists at your web host panel then can you check its recent entries to find the cause
if direct help required, you may PM me temporary access to your web host control panel to check
I sent login info for you
^ your forum is working now. plugins should be checked.
if the forum was upgraded from MyBB 1.6.x then may be you forgot about disabling plugins before the upgrade.