remove vanilla from local machine to host

m_maksim

ver. 2.1.5

I take all files (core + plugins) + SQL dump from local machine

at host create SQL base (same user name, same name of SQL) and do import from local SQL

modify config (new pass)

copy all files to host (and delete all ini files in cache)

run!

see error: Something has gone wrong.

what is wrong? I do it many times with Wordpress and it was OK.

m_maksim

local machine - win 7 + xampp, host - unix

see phpMyAdmin - all imported tables have names: gdn_*

and should be GDN_*???

caps is the problem?

m_maksim

example table in SQL at unix-host:

GDN_UserAuthenticationProvider

same table in SQL at Win7 local machine with XAMPP:

gdn_userauthenticationprovider

and after removing site from local to site - nothing works. what can I fix it?

whu606

Why are you bringing over your local DB?

Does it have any 'live' data?

You need to

Set $Configuration['Debug'] = TRUE; in your conf/config.php to reveal full error messages. Remember to remove it when you are done.

as per: http://docs.vanillaforums.com/developers/troubleshooting/

to see what the actual error is.

m_maksim

error text: Table 'vanilla.gdn_User' doesn't exist
bu I have it

whu606

What do you have in your local machine db that you need in your live install?

m_maksim

I have forming full forum tree + have create user groups and roles with fulltext description

m_maksim

@whu606 said:
What do you have in your local machine db that you need in your live install?

I have forming full forum tree + have create user groups and roles with fulltext description

K17

You van use the Vanilla porter:
-Install a new forum on host
-Export the local database with vanilla porter.
-Import the Vanilla Porter Database in the dashboard of the host.

Sorry For english errors, i'm french.

hgtonight

I wouldn't suggest using the porter. The porter is for changing from another forum system to Vanilla. Ancillary information may be lost using the porter to go from Vanilla 2 to Vanilla 2.

Create an export via PHPmyAdmin and edit the table names to match the casing of the tables at your webhost. This will make sure you don't lose any information.

peregrine

@m_maksim said:
error text: Table 'vanilla.gdn_User' doesn't exist
bu I have it

no, you don't your upper and lower case is off. rename the tables to what they need to be.

phpmyadmin shows 'vanilla.gdn_user not vanilla.gdn_User

rename all your tables properly so all the cases match up.