[Solved] Migration from localhost to other pc

maga

Hello

I'm using version 2.0.17.10 of Vanilla and I'm trying to migrate my site to another computer.

Back up my database and import it into the web server.
copy my application to the site and edit the config.php file information

Configuration ['Database'] ['Name'] = 'vcore';
$ Configuration ['Database'] ['host'] = 'localhost';
$ Configuration ['Database'] ['User'] = 'donotshowyourusernamehere';
$ Configuration ['Database'] ['Password'] = 'donotshowyourpasswordhere';

change the permissions of directories and I get the following error but I check my DB table exists and if permissions do not know what else I have to check.

Fatal Error in Gdn_Database.Query();
Table 'vcore.GDN_Permission' doesn't exist
select * from GDN_Permission Permission limit 1
The error occurred on or near: /var/www/vanillacore/library/database/class.database.php

232: $PDOStatement = $this->Connection()->query($Sql);

233: }

234:

235: if ($PDOStatement === FALSE) {

236: trigger_error(ErrorMessage($this->GetPDOErrorMessage($this->Connection()->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);

237: }

238:

239: $ReturnType = GetValue('ReturnType', $Options);

maga

Ouch! the problem was table's name ... Windows exports in small letter and Linux accept capital letter.

Todd

Well, first off. Is GDN_Permission on your new server?

maga

yes in my server all DB is the same that in other pc

UnderDog

Table 'vcore.GDN_Permission' doesn't exist

This is your problem. Check and doublecheck.
I do remember a problem with exactly gdn_permission, some time ago, but that was a deeper MySQL issue.

maga

@UnderDog, which's issue?... the table GDN_Permission its on the new server...

x00

have you cleared the cache?

maga

Ouch! the problem was table's name ... Windows exports in small letter and Linux accept capital letter.