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

SQLSTATE[42000] | Forum

inside83
inside83 Dec 18 '14

I get error SQLSTATE[42000] after install photo verification plug in when clicking on "my profile"

when I disable the plugin, everything works


Here is the entire message:


Message:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 1' at line 1

File:/home/user/public_html/domain/ow_core/database.php

Line:707

Trace:

#0 /home/user/public_html/domain/ow_core/database.php(707): PDOStatement->execute()

#1 /home/user/public_html/domain/ow_core/database.php(305): OW_Database->execute('SELECT * FROM o...', Array)

#2 /home/user/public_html/domain/ow_core/base_dao.php(114): OW_Database->queryForObject('SELECT * FROM o...', 'BOL_User', Array, 0, Array)

#3 /home/user/public_html/domain/ow_system_plugins/base/bol/user_dao.php(156): OW_BaseDao->findObjectByExample(Object(OW_Example))

#4 /home/user/public_html/domain/ow_system_plugins/base/bol/user_service.php(319): BOL_UserDao->findByUserName(NULL)

#5 /home/user/public_html/domain/ow_plugins/photoverifi/init.php(36): BOL_UserService->findByUsername(NULL)

#6 [internal function]: photoverifi_class_get_instance_UserAvatarWidget(Object(OW_Event))

#7 /home/user/public_html/domain/ow_core/event_manager.php(222): call_user_func('photoverifi_cla...', Object(OW_Event))

#8 /home/user/public_html/domain/ow_core/ow.php(461): OW_EventManager->trigger(Object(OW_Event))

#9 /home/user/public_html/domain/ow_core/ow.php(447): OW::getClassInstanceArray('BASE_CMP_UserAv...', Array)

#10 /home/user/public_html/domain/ow_system_plugins/base/components/drag_and_drop_item.php(306): OW::getClassInstance('BASE_CMP_UserAv...', Object(BASE_CLASS_WidgetParameter))

#11 /home/user/public_html/domain/ow_system_plugins/base/components/drag_and_drop_entity_panel.php(204): BASE_CMP_DragAndDropItem->renderView()

#12 /home/user/public_html/domain/ow_smarty/template_c/9b6508da93de0325cfb1a35caecd4d1180cb18ab.file.drag_and_drop_entity_panel.html.php(100): BASE_CMP_DragAndDropEntityPanel->tplComponent(Array, Object(Smarty_Internal_Template))

#13 /home/user/public_html/domain/ow_libraries/smarty3/sysplugins/smarty_internal_templatebase.php(180): content_54935d2f183079_15157432(Object(Smarty_Internal_Template))

#14 /home/user/public_html/domain/ow_core/view_renderer.php(101): Smarty_Internal_TemplateBase->fetch('/home/user...')

#15 /home/user/public_html/domain/ow_core/renderable.php(271): OW_ViewRenderer->renderTemplate('/home/user...')

#16 /home/user/public_html/domain/ow_core/component.php(80): OW_Renderable->render()

#17 /home/user/public_html/domain/ow_system_plugins/base/controllers/component_panel.php(156): OW_Component->render()

#18 /home/user/public_html/domain/ow_system_plugins/base/controllers/component_panel.php(245): BASE_CTRL_ComponentPanel->action('profile', 2, false, Array, 'drag_and_drop_e...')

#19 [internal function]: BASE_CTRL_ComponentPanel->myProfile(Array)

#20 /home/user/public_html/domain/ow_core/request_handler.php(266): call_user_func_array(Array, Array)

#21 /home/user/public_html/domain/ow_core/application.php(329): OW_RequestHandler->dispatch()

#22 /home/user/public_html/domain/index.php(73): OW_Application->handleRequest()

#23 {main}

Type:PDOException

The Forum post is edited by inside83 Dec 18 '14
ross Team
ross Dec 18 '14
inside83, I believe this is a 3rd party plugin and we do not provide assistance with 3rd party plugins, please send this error to the plugin developer directly for him to resolve it. Thanks. 
inside83
inside83 Dec 19 '14
@ross,

I did

http://www.oxwall.org/forum/topic/30358

but I saw a lot of posts on this error on Bug reports and troubleshooting regarding FBConnect and thought to post here as well