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

Bug photo plugin utf8mb4 | Forum

Valentin
Valentin Apr 17 '19

photos do not appear

in inspect element say:

Uncaught parsererror -  browse_photo.js:414


Recently I changed utf8 to utf8mb4 in /ow_core/database.php


[Wed Apr 17 18:44:52 2019] [ow_core_log] [Exception] Message: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entityId' in group statement is ambiguous File: /home/admin/web/mydomain.com/public_html/ow_core/database.php Line:723 Trace: [#0 /home/admin/web/mydomain.com/public_html/ow_core/database.php(723): PDOStatement->execute() | #1 /home/admin/web/mydomain.com/public_html/ow_core/database.php(414): OW_Database->execute('SELECT `ce`.`en...', Array) | #2 /home/admin/web/mydomain.com/public_html/ow_system_plugins/base/bol/comment_dao.php(236): OW_Database->queryForList('SELECT `ce`.`en...', Array) | #3 /home/admin/web/mydomain.com/public_html/ow_system_plugins/base/bol/comment_service.php(306): BOL_CommentDao->findCommentCountForEntityList('photo_comments', Array) | #4 /home/admin/web/mydomain.com/public_html/ow_plugins/photo/controllers/photo.php(741): BOL_CommentService->findCommentCountForEntityList('photo_comments', Array) | #5 /home/admin/web/mydomain.com/public_html/ow_plugins/photo/controllers/photo.php(689): PHOTO_CTRL_Photo->generatePhotoList(Array) | #6 /home/admin/web/mydomain.com/public_html/ow_plugins/photo/controllers/photo.php(578): PHOTO_CTRL_Photo->getPhotoList(Array) | #7 [internal function]: PHOTO_CTRL_Photo->ajaxResponder(Array) | #8 /home/admin/web/mydomain.com/public_html/ow_core/request_handler.php(250): ReflectionMethod->invokeArgs(Object(PHOTO_CTRL_Photo), Array) | #9 /home/admin/web/mydomain.com/public_html/ow_core/request_handler.php(226): OW_RequestHandler->processControllerAction(Object(ReflectionMethod), Object(PHOTO_CTRL_Photo)) | #10 /home/admin/web/mydomain.com/public_html/ow_core/application.php(346): OW_RequestHandler->dispatch() | #11 /home/admin/web/mydomain.com/public_html/index.php(76): OW_Application->handleRequest() | #12 {main}]


Oxwall Türkiye
Oxwall Türkiye May 8 '19

Please try the methods

Check the 1-PHP version

2-Check PHP permissions

Check the 3-mod_sec status

4- Remove recently installed plugin

5-Get back the last modified



For further assistance, send your new log entry related to the problem as PM.

Christina F. Custer
Christina F. Custer Oct 18 '22
Just change the part or you can also save them to other cloud storage places than no image will cause issues. 
The Forum post is edited by Christina F. Custer Oct 18 '22
David Clark
David Clark Oct 18 '22
Thank you, Oxwall. Your technique is useful. It is effective.

flagle

The Forum post is edited by David Clark Oct 18 '22