migrating vanilla from local machine to live host

vanejilla

when migrating to my web hosting live site from my localhost dev machine im getting error thus:

select * 
from GDN_Permission Permission 
limit 1

The error occurred on or near: /home/accname/public_html/forumthub/library/database/class.database.php

283:          $PDOStatement = $this->Connection()->query($Sql);
284:       }
285: 
286:       if ($PDOStatement === FALSE) {
287:          trigger_error(ErrorMessage($this->GetPDOErrorMessage($this->Connection()->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);
288:       }
289:       
290:       // Did this query modify data in any way?
291:       if ($ReturnType == 'ID') {

I notice that all ini files in the cache folder are obviously using the path from my local machine - will changing these paths to the correct path on my server fix this?? or can i delete these cache files? will vanilla create them again if they are not found upon initialisation?

Tama

Yes cache files will be recreated on deletion

http://vanillawiki.homebrewforums.net/index.php/Clearing_The_Cache

vanejilla

@tama

step 3. 'Delete all files in that directory except all the .ini files '

surely the ini files are the files that need removing? other than them there's only the smarty php file?

hgtonight

You can delete the .ini files. It is important to note that Smarty generates php cache files.

vanejilla

thanks hgtonight,
i think its actually a permissions problem - the error message:

**Table 'helpsys_vanilladb.GDN_Permission' doesn't exist**

is the clue i blatantly missed