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

Error After Update - Hot Or Not | Forum

Danger
Danger Jan 9 '14
Hello,


after update to 1.6 and update the plugins photo, that item give error 500.


That is in debug mode:


OW Debug - ExceptionMessage:SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entityType' in on clause is ambiguousFile:/web/htdocs//...se.phpLine:331Trace: /web/htdocs/www.webeasyit.it/home/community/ow_core/database.php(331): PDOStatement->execute() #1 /web/htdocs/www.webeasyit.it/home/community/ow_core/database.php(359): OW_Database->execute('SELECT * FROM `...', NULL) #2 /web/htdocs//...hotphoto_service.php(90): OW_Database->queryForColumn('SELECT * FROM `...') #3 /web/htdocs//...nts/random_photo.php(82): HOTPHOTO_BOL_HotphotoService->getNotRatedPhotoByUserId(1, 0) #4 /web/htdocs//...controllers/rate.php(69): HOTPHOTO_CMP_RandomPhoto->__construct(Array) #5 [internal function]: HOTPHOTO_CTRL_Rate->index(Array) #6 /web/htdocs/www.webeasyit.it/home/community/ow_core/request_handler.php(266): ReflectionMethod->invokeArgs(Object(HOTPHOTO_CTRL_Rate), Array) #7 /web/htdocs/www.webeasyit.it/home/community/ow_core/application.php(330): OW_RequestHandler->dispatch() #8 /web/htdocs/www.webeasyit.it/home/community/index.php(65): OW_Application->handleRequest() #9 {main}Type: PDOException


Any solutions? Thanks





The Forum post is edited by Danger Jan 9 '14
Arifur Rahman
Arifur Rahman Jan 10 '14

OW Debug - Exception

Message:SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entityType' in on clause is ambiguousFile:/home/ofnf/public_html/ow_core/database.phpLine:331Trace:#0 /home/ofnf/public_html/ow_core/database.php(331): PDOStatement->execute() #1 /home/ofnf/public_html/ow_core/database.php(359): OW_Database->execute('SELECT * FROM `...', NULL) #2 /home/ofnf/public_html/ow_plugins/hotphoto/bol/hotphoto_service.php(90): OW_Database->queryForColumn('SELECT * FROM `...') #3 /home/ofnf/public_html/ow_plugins/hotphoto/components/random_photo.php(82): HOTPHOTO_BOL_HotphotoService->getNotRatedPhotoByUserId(1, 0) #4 /home/ofnf/public_html/ow_plugins/hotphoto/controllers/rate.php(69): HOTPHOTO_CMP_RandomPhoto->__construct(Array) #5 [internal function]: HOTPHOTO_CTRL_Rate->index(Array) #6 /home/ofnf/public_html/ow_core/request_handler.php(266): ReflectionMethod->invokeArgs(Object(HOTPHOTO_CTRL_Rate), Array) #7 /home/ofnf/public_html/ow_core/application.php(330): OW_RequestHandler->dispatch() #8 /home/ofnf/public_html/index.php(65): OW_Application->handleRequest() #9 {main}
PDOException

Hello,


after update to 1.6 and update the plugins photo, that item give error 500.


That is in debug mode:

Zaph
Zaph Jan 12 '14
I've uploaded the fix to this error. Thanks for the report


Please wait for update in the admin panel or upload a new package to the site via ftp

The Forum post is edited by Zaph Jan 12 '14
dave Team
dave Jan 30 '14

Hiya ZAPH :)  i only got two warnings, no biggy i can fix them just wanted to let you know cause warnings happen to us all buddy ;)


warning

1.  hot-not

Missing argument 2 for PHOTO_BOL_PhotoService::getPhotoFullsizeUrl(), called in /home/xxxxxx/public_html/ow_plugins/hotphoto/components/random_photo.php on line 108 and defined
File: /home/xxxxx/public_html/ow_plugins/photo/bol/photo_service.php
Line: 326

Message: Undefined variable: hash
File: /home/xxxxxx/public_html/ow_plugins/photo/bol/photo_service.php
Line: 328


not sure what the missing argument is on the first one but i can initialize the hash var to get that take care of on my copy...


UPDATE :


just wanted to update you on this... yes in the photo service php the function calls for id hash and you just passed the id via random photo php of your plugin.   thats prob the reason for the hash var notice as well...


:)  happy coding

The Forum post is edited by dave Jan 30 '14
Ropin
Ropin Mar 13 '14

i still get the 500 error :S

Ropin
Ropin Mar 20 '14
Message:SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ropinhome_oxwa1.ow_base_rate' doesn't existFile:/home/ropinhome/domains/ropinhome.nl/public_html/oxwall/ow_core/database.phpLine:331Trace:#0 /home/ropinhome/domains/ropinhome.nl/public_html/oxwall/ow_core/database.php(331): PDOStatement->execute() #1 /home/ropinhome/domains/ropinhome.nl/public_html/oxwall/ow_core/database.php(359): OW_Database->execute('SELECT * FROM `...', NULL) #2 /home/ropinhome/domains/ropinhome.nl/public_html/oxwall/ow_plugins/hotphoto/bol/hotphoto_service.php(90): OW_Database->queryForColumn('SELECT * FROM `...') #3 /home/ropinhome/domains/ropinhome.nl/public_html/oxwall/ow_plugins/hotphoto/components/random_photo.php(82): HOTPHOTO_BOL_HotphotoService->getNotRatedPhotoByUserId(1, 0) #4 /home/ropinhome/domains/ropinhome.nl/public_html/oxwall/ow_plugins/hotphoto/controllers/rate.php(69): HOTPHOTO_CMP_RandomPhoto->__construct(Array) #5 [internal function]: HOTPHOTO_CTRL_Rate->index(Array) #6 /home/ropinhome/domains/ropinhome.nl/public_html/oxwall/ow_core/request_handler.php(266): ReflectionMethod->invokeArgs(Object(HOTPHOTO_CTRL_Rate), Array) #7 /home/ropinhome/domains/ropinhome.nl/public_html/oxwall/ow_core/application.php(330): OW_RequestHandler->dispatch() #8 /home/ropinhome/domains/ropinhome.nl/public_html/oxwall/index.php(65): OW_Application->handleRequest() #9 {main}Type:PDOException
Zaph
Zaph Mar 21 '14
I've added a fix to this issue. Please update the plugin when it will be available in the Admin area or upload the new plugin folder via ftp manually
You do not have permission to reply this topic