Updated from 1.0.0 to 1.2.0

[DRE]

I can't access my showcase index. I get this error.

Server Error

Mysqli prepare error: Unknown column 'item.review_count' in 'field list'

1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 753
5. Zend_Db_Adapter_Abstract->fetchRow() in NFLJ/Showcase/Model/Item.php at line 568
6. NFLJ_Showcase_Model_Item->getQuickStatsItemTotals() in NFLJ/Showcase/ControllerPublic/Index.php at line 170
7. NFLJ_Showcase_ControllerPublic_Index->actionModular() in XenForo/FrontController.php at line 310
8. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
9. XenForo_FrontController->run() in /home/user/public_html/index.php at line 13

 

[Bob]

review_count is a new field that is added to the items table when upgrading to 1.2.0

 

[Bob]

Did you by chance try to upgrade using Chris Deemings auto installer?

 

[DRE]

review_count is a new field that is added to the items table when upgrading to 1.2.0

I guessed that much but how come I can no longer access my index?

 

[Bob]

because its MISSING, which means that the UPGRADE was fucked up and you will be missing more than just that one field.

There is a reason I ask questions. The reason I asked about the auto installer is that someone else attempted to upgrade with it and it missed doing the install.php file steps (which are vital to the upgraded).

 

[DRE]

aww man.

 

[DRE]

Hey I didn't see your question until just now so I wasn't ignoring you. And I did upgrade with it yeah.

 

[Bob]

I can do for you what I did for that other person, but you are going to have to give me full admin access to your site, ftp access and phpMyAdmin access to the DB. Inbox me with the credentials.

 

[Bob]

No worries, its an easy fix (For Me), but it would take me 6 months to teach someone how to do resolve this.

 

[DRE]

I don't have access to that, chris deeming is hosting me so I'll ask him if he can give it to you thanks

 

[Bob]

I doubt Chris will have a problem with that

 

[Neal]

I removed the auto-installer after this problem