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

Error After Update - Hot Or Not | Forum

« Back to plugin

« Back to forum topic list

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 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 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

Leader

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 Mar 13 '14

i still get the 500 error :S

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 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

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

Error After Update - Hot Or Not | Forum