Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

[Solved] Migration from localhost to other pc

edited October 2011 in Vanilla 2.0 - 2.8
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);
Tagged:

Best Answer

  • Answer ✓
    Ouch! the problem was table's name :(... Windows exports in small letter and Linux accept capital letter.

Answers

  • ToddTodd Chief Product Officer Vanilla Staff
    Well, first off. Is GDN_Permission on your new server?
  • yes in my server all DB is the same that in other pc
  • 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.

    There was an error rendering this rich post.

  • @UnderDog, which's issue?... the table GDN_Permission its on the new server...
  • have you cleared the cache?

    grep is your friend.

  • Answer ✓
    Ouch! the problem was table's name :(... Windows exports in small letter and Linux accept capital letter.
Sign In or Register to comment.