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

Get started

after update Internal server Error | Forum

Topic location: Forum home » Support » Bug reports and troubleshooting

dudi Jul 27 '16

Hello, I have taken measures during update . all plugins were active . now I have this message ( see below ) I did it again with an update attempts ( ross has it written in the forum )

OW Debug - Exception

Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'key' in 'where clause' File: /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/database.php Line: 723 Trace: #0 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/database.php(723): PDOStatement->execute() #1 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/database.php(308): OW_Database->execute('SELECT * FROM o...', Array) #2 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/base_dao.php(114): OW_Database->queryForObject('SELECT * FROM o...', 'BOL_Theme', Array, 86400, Array) #3 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_system_plugins/base/bol/theme_dao.php(111): OW_BaseDao->findObjectByExample(Object(OW_Example), 86400, Array) #4 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_system_plugins/base/bol/theme_service.php(485): BOL_ThemeDao->findByKey('simplicity') #5 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/theme_manager.php(66): BOL_ThemeService->getThemeObjectByKey('simplicity', false) #6 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/application.php(154): OW_ThemeManager->initDefaultTheme(false) #7 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/index.php(54): OW_Application->init() #8 {main} Type: PDOException

Team

Aliya Jul 27 '16

Common cause: core platform's source code has been updated but database data was not.
Known to happen when: platform update crashes half way.
Solution: update core platform's source code and database manually.

Overall error is referring to _base_theme DB table.

Unpack update pack manually on server + try running http://sitename.com/ow_updates URL. This updates DB.

Leader

dave Jul 27 '16

OH MY!!!! look who it is... HI Alia :) wow i have missed you i wish you were on more often.. :)

Yes i told him in another post that it may be his update did not finish properly. I was just hoping that someone could confirm that on his new post here.

Thanks Alia good to see you always

dudi Jul 27 '16

where can I find the database in the package?

Leader

dave Jul 27 '16

dudi i think she means go to the download page and download the update pack

The Forum post is edited by dave Jul 27 '16

dudi Jul 27 '16

I have the update manually upload and open the url ow_update

dudi Jul 27 '16

Quote from dave dudi i think she means go to the download page and download the update pack

Yes i have.....

Team

ross Jul 27 '16

Unpack the update package your downloaded and run www.site.com/ow_updates

See if the issue persists.

dudi Jul 28 '16

Quote from ross Unpack the update package your downloaded and run www.site.com/ow_updates
See if the issue persists.

that's what I 've done.

Team

ross Jul 28 '16

Ok, in this case

go to phpmyadmin -> ow_base_config table

in this table find two configs soft_build and soft_version

Now it should be 10656 and 1.8.4

Change soft_build from 10656 to, let's say, 10200 and soft_version from 1.8.4 to 1.8.3 and then run the update again. WWW.YOURDOMAIN.COM/OW_UPDATES

See if the issue persists.

The Forum post is edited by ross Jul 28 '16

#10

dudi Jul 28 '16

Quote from ross Ok, in this case

go to phpmyadmin -> ow_base_config table
in this table find two configs soft_build and soft_version

Now it should be 10656 and 1.8.4

Change soft_build from 10656 to, let's say, 10200 and soft_version from 1.8.4 to 1.8.3 and then run the update again. WWW.YOURDOMAIN.COM/OW_UPDATES

See if the issue persists.

Ok :)

#11

dudi Jul 29 '16

my page is now known but I can not update my purchased plugins
manually and automatically does not go

Error 500
Internal Server Error.

If you are the site admin, click here for details (+)

Something went wrong!
To get the error details follow these steps:
- Open ow_includes/config.php file and set DEBUG_MODE to true
- Reproduce your last action.

Error details: Type: Exception Message: Can't find config `is_api_key_exists` in section `googlelocation`! File: /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_system_plugins/base/bol/config_service.php Line: 167 Trace: #0 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/config.php(153): BOL_ConfigService->saveConfig('googlelocation', 'is_api_key_exis...', true) #1 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_plugins/google_map_location/bol/location_service.php(601): OW_Config->saveConfig('googlelocation', 'is_api_key_exis...', true) #2 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_plugins/google_map_location/classes/event_handler.php(713): GOOGLELOCATION_BOL_LocationService->checkApiKey() #3 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_plugins/google_map_location/init.php(25): GOOGLELOCATION_CLASS_EventHandler->genericInit() #4 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_system_plugins/base/bol/plugin_service.php(684): include_once('/is/htdocs/wp11...') #5 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/plugin_manager.php(133): BOL_PluginService->includeScript('/is/htdocs/wp11...') #6 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/plugin_manager.php(104): OW_PluginManager->initPlugin(Object(OW_Plugin)) #7 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/ow_core/application.php(128): OW_PluginManager->initPlugins() #8 /is/htdocs/wp11008901_PPVF66W7PP/www/ox/index.php(54): OW_Application->init() #9 {main}

#12

Team

Aliya Aug 1 '16

dudi, it is better to contact plugin owner with this issue.

Overall error is telling that required "is_api_key_exists" configuration was not added into _base_config table.

As a way around ( not recommended) you can add config manually.
Open ow_base_config DB table and add a new row there.

ID - give your config a numerical ID ( look what is the latest ID you have there and add new one. Ex: if latest one is 885, your new one will be 886.

Key - googlelocation
Name- is_api_key_exists
Value - 0
Description - NULL

Attaching screen shot for your reference,

THIS WILL RESOLVE PARTICULAR ERROR message related to Google Maps Location plugin. But we still recommend contacting plugin developer for assistance.

Note: if this resolves the issue, you will need to re-enter your key within Google Maps Location plugin after that.

The Forum post is edited by Aliya Aug 1 '16

Attachments:

Screenshot-311.png (34Kb)

#13

Leader

dave Aug 1 '16

If you leave the ID field blank, it will create the next incremental id by itself.. :) Thats my first config error i have seen, now i know what they look like... :)

The Forum post is edited by dave Aug 1 '16

#14

Team

Aliya Aug 1 '16

+1 Dave... =)

#15

dudi Aug 1 '16

The maps working :)

#16

Team

Aliya Aug 2 '16

glad that all is well now.
Do you mind sharing how you resolved the issue for people who might face the same error in future?

#17

Oxwall Software

Please sign in

We build. You grow.

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

after update Internal server Error | Forum