Due error I cannot log in admin panel and re-index.
This does appear to be a duplicate of SQLSTATE[42S22]: Column not found: 1054 unknown column 'e.status' after 1.9.2 Upgrade but since neither provide a direct answer as to how to resolve it when you can't login to the Admin Console backend interface, I thought I'd whip up an answer.
To do the following, you'll need to be able to ssh into your hosting provider's terminal console.
- ssh into your webhost provider
navigate to the /shell folder
Run the indexer to regenerate all indices (this may take a while...)
php -f indexer.php reindexall
If you have compilation enabled (and you probably shouldn't be, but if you ARE), then re-compile:
php -f compiler.php compile
Clear out all your Magento caches
php -f cleanCache.php clean all
After the above is all said and done then you should have a working installation. You will be able to login to your Admin Console and the error you mention above should go away.