We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Column not found: 1054 Unknown column 'entityType' in 'field list' after 1.72 upgrade | Forum

Harry
Harry Nov 26 '14
No errors were thrown when doing the update from 1.71 to 1.72, but then when selecting 'Moderation Tools' from the top menu, received this error: (note that the language value for 'moderation tools' was missing and I had to manually add it myself.

Error details:
Type:     Exception
Message:     SQLSTATE[42S22]: Column not found: 1054 Unknown column 'entityType' in 'field list'
File:     /dd/ow_core/database.php
Line:     707
Trace:     #0 /var/www/vhosts/httpdocs/dd/madgab/ow_core/database.php(707): PDOStatement->execute() #1 /var/www/vhosts/httpdocs/dd/madgab/ow_core/database.php(398): OW_Database->execute('SELECT count(DI...', NULL) #2 /var/www/vhosts/httpdocs/dd/madgab/ow_system_plugins/base/bol/flag_dao.php(133): OW_Database->queryForList('SELECT count(DI...') #3 /var/www/vhosts/httpdocs/dd/madgab/ow_system_plugins/base/bol/flag_service.php(115): BOL_FlagDao->findCountForEntityTypeList(Array) #4 /var/www/vhosts/httpdocs/dd/madgab/ow_system_plugins/base/bol/flag_service.php(143): BOL_FlagService->findCountForEntityTypeList(Array) #5 /var/www/vhosts/httpdocs/dd/madgab/ow_system_plugins/base/bol/flag_service.php(120): BOL_FlagService->getContentTypeListWithCount() #6 /var/www/vhosts/httpdocs/dd/madgab/ow_system_plugins/base/classes/event_handler.php(179): BOL_FlagService->getContentGroupsWithCount() #7 [internal function]: BASE_CLASS_EventHandler->onCollectModerationToolsMenu(Object(BASE_CLASS_EventCollector)) #8 /var/www/vhosts/httpdocs/dd/madgab/ow_core/event_manager.php(222): call_user_func(Array, Object(BASE_CLASS_EventCollector)) #9 /var/www/vhosts/httpdocs/dd/madgab/ow_system_plugins/base/controllers/moderation.php(35): OW_EventManager->trigger(Object(BASE_CLASS_EventCollector)) #10 /var/www/vhosts/httpdocs/dd/madgab/ow_system_plugins/base/controllers/moderation.php(65): BASE_CTRL_Moderation->getMenu() #11 [internal function]: BASE_CTRL_Moderation->index(Array) #12 /var/www/vhosts/httpdocs/dd/madgab/ow_core/request_handler.php(266): call_user_func_array(Array, Array) #13 /var/www/vhosts/httpdocs/dd/madgab/ow_core/application.php(329): OW_RequestHandler->dispatch() #14 /var/www/vhosts/httpdocs/dd/madgab/index.php(73): OW_Application->handleRequest() #15 {main}

ross Team
ross Nov 27 '14
Harold, your update has not been successfully completed, you need to restore your backup if you have one, disable all 3rd party plugins, switch to the default theme and run the update again. Please follow this tutorial: http://docs.oxwall.org/install:update
Harry
Harry Nov 27 '14
I was able to sort it out through a number of cache cleanings and so forth.  I am now at the moderation tools page, and it says that there are no items, fair enough.  My question now is - when/how would there be items?
ross Team
ross Nov 27 '14
When a new user adds video, photo, forum/blog post, it will be there for you to approve. 

Can you please tell us what exactly you did to fix this error?

Harry
Harry Nov 27 '14
I really wish I knew exactly what it was that fixed it.  Really, I was messing around with everything since I was having issues with the notifications update ( couldn't get to any page without an apache 500 error), then I just reverted to a previous db version to fix that one, and then came back to this screen and aha!  It was there after spinning for a while.  It's the craziest thing really, lol,  oftentimes I have these types of errors, pull more of my precious hair thats left out, and it then springs to life on it's own.  But, if I figure out exactly what it was, I will forward the details your way, for sure.


Thanks as always Ross.

ross Team
ross Nov 27 '14
Alright, keep us updated.