phpBB Gallery

phpBB Gallery 1.2.1 - phpBB Gallery

Re: phpBB Gallery 1.2.1

by uaellaen » Sat Apr 06, 2019 4:53 pm

downgrade to 7.2.17 fixed the error ... thanks alot! =D
uaellaen
Registered User
Posts: 18
Joined: Mon Sep 18, 2006 4:21 pm
Contact:

Re: phpBB Gallery 1.2.1

by ghswen » Sun Apr 21, 2019 9:22 pm

Need some help on a new install. php7.2, phpBB3.2.5,

I've installed Gallery 1.2.1 and everything appears on the pages and ACP however I cannot set up permissions. When checking the gallery log I get the following:

General Error
SQL ERROR [ mysqli ]

Expression #11 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'phpBB.i.image_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]

SQL

SELECT * FROM (phpbb_gallery_log l CROSS JOIN phpbb_gallery_images i) WHERE l.deleted = 0 GROUP BY l.log_time, l.log_id ORDER BY l.log_time DESC LIMIT 25

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 997
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/mysql_base.php
LINE: 45
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 270
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 321
CALL: phpbb\db\driver\driver->sql_query_limit()

FILE: [ROOT]/ext/phpbbgallery/core/log.php
LINE: 181
CALL: phpbb\db\driver\factory->sql_query_limit()

FILE: [ROOT]/ext/phpbbgallery/core/acp/gallery_logs_module.php
LINE: 124
CALL: phpbbgallery\core\log->build_list()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: phpbbgallery\core\acp\gallery_logs_module->main()

FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()
ghswen
Registered User
Posts: 40
Joined: Sun Apr 21, 2019 9:04 pm
Contact:

Re: phpBB Gallery 1.2.1

by Satanasov » Mon Apr 22, 2019 6:06 am

You have activated only_full_group_by option in SQL ... it requires different groupings. Please disable it.

https://stackoverflow.com/questions/239 ... l-group-by
For list of all my extensions go to https://github.com/satanasov
If you want custom functions in some of my products - PM me and we will discuss it.
Satanasov
Registered User
Posts: 1231
Joined: Sun Jul 29, 2012 5:48 am
Name: Stanislav Atanasov
Contact:

Re: phpBB Gallery 1.2.1

by Tarantino » Mon Apr 22, 2019 8:34 am

No need to disable it. Plus in most hosts you can't even disable it...

But I use phpBB Gallery and its working good with php 7.2 and phpbb 3.2.5 and I've only_full_group_by enabled.

I beleive you dont have the last version. Because last version have this (this was added in 2017... but you still dont have it):
https://github.com/satanasov/phpbbgalle ... 504feaabf9
Tarantino
Registered User
Posts: 797
Joined: Sat Feb 18, 2012 1:51 pm
Contact:

Re: phpBB Gallery 1.2.1

by Satanasov » Mon Apr 22, 2019 10:20 am

AH! Please use master branch from github ...
For list of all my extensions go to https://github.com/satanasov
If you want custom functions in some of my products - PM me and we will discuss it.
Satanasov
Registered User
Posts: 1231
Joined: Sun Jul 29, 2012 5:48 am
Name: Stanislav Atanasov
Contact:

Re: phpBB Gallery 1.2.1

by ghswen » Mon Apr 22, 2019 4:30 pm

Thanks so much for the help! I will try master branch and let you know if it's fixed the problem!
ghswen
Registered User
Posts: 40
Joined: Sun Apr 21, 2019 9:04 pm
Contact:

Re: phpBB Gallery 1.2.1

by ghswen » Tue Apr 23, 2019 3:10 am

Thanks again for your suggestion! You were correct. I assumed I was using version 1.2.1 but actually it was 1.2.0.11. I uploaded the current version from github and it fixed the SQL error and I was able to set permissions etc etc. However none of the images I'm uploading will display. I get a URL and BB code but the URL won't display on it's own nor can I view the images on the forum pages.

Suggestions as to where I should fix this problem?

Thanks again for your help!
ghswen
Registered User
Posts: 40
Joined: Sun Apr 21, 2019 9:04 pm
Contact:

Re: phpBB Gallery 1.2.1

by Tarantino » Tue Apr 23, 2019 9:02 am

I would need to see your forum and the problem in first hand. I'm not remember of such problem.
Tarantino
Registered User
Posts: 797
Joined: Sat Feb 18, 2012 1:51 pm
Contact:

Re: phpBB Gallery 1.2.1

by ghswen » Tue Apr 23, 2019 11:14 pm

Perhaps I just goofed up...

I decided to try a reinstall hoping it would correct the problem. Now I'm getting the following error when attempting to enable the core extension.

*********************************************

Something went wrong during the request and an exception was thrown. The changes made before the error occurred were reversed to the best of our abilities, but you should check the board for errors.

A required module does not exist: UCP_GALLERY


UPDATE: I found this https://www.phpbb.com/customise/db/exte ... pic/170551 Let me give that a try and see if I can get it working. I will reply back.
ghswen
Registered User
Posts: 40
Joined: Sun Apr 21, 2019 9:04 pm
Contact:

Re: phpBB Gallery 1.2.1

by uaellaen » Thu Apr 25, 2019 4:35 am

nm
Last edited by uaellaen on Thu Apr 25, 2019 4:42 am
uaellaen
Registered User
Posts: 18
Joined: Mon Sep 18, 2006 4:21 pm
Contact:

Re: phpBB Gallery 1.2.1

by Satanasov » Thu Apr 25, 2019 4:39 am

uaellaen wrote:hey again!

so, there is a problem with pictures not loading in the upload preview, and a couple other links not working like "go back to album" etc. on nginx ... the fix is relatively simple

line 18 in core/url.php needs to be changed from

Code: Select all

  private $phpbb_root_path = '../';
to

Code: Select all

  private $phpbb_root_path = '../app.php/';
and all links and preview pictures work great again ;) probably could also do it with nginx location rewrites ... but this seems easier :p
IMHO - fix the nginx - you will probably face more issues with other extensions ;)
For list of all my extensions go to https://github.com/satanasov
If you want custom functions in some of my products - PM me and we will discuss it.
Satanasov
Registered User
Posts: 1231
Joined: Sun Jul 29, 2012 5:48 am
Name: Stanislav Atanasov
Contact:

Re: phpBB Gallery 1.2.1

by uaellaen » Thu Apr 25, 2019 4:57 am

it actualy requires to change 2 things in the URL file, so yeah doing the nginx location rewrite to fix it may be the better option ...

i have no issues with any other plugins thou, only gallery misses the "app.php"
uaellaen
Registered User
Posts: 18
Joined: Mon Sep 18, 2006 4:21 pm
Contact:

Re: phpBB Gallery 1.2.1

by Leinad4Mind » Thu Apr 25, 2019 9:51 am

This extension doesn't work with URL Rewriting Enabled. We need to disable so it would add the app.php, but then there is some issues as you're reporting.
And my guess is that its phpbb Gallery fault. Probably is not making the routes as it should.
Want to access all my portuguese MOD and Extension translations?
Become my Patreon!
phpBB Portugal Translator and Moderator
User avatar
Leinad4Mind
Translator
Posts: 855
Joined: Sun Jun 01, 2008 11:08 pm
Contact:

Re: phpBB Gallery 1.2.1

by uaellaen » Thu Apr 25, 2019 11:45 am

eh of course apache rewrites dont work with nginx ... i have the nginx phpbb config also ... every other plugin works, but for the gallery i just modified 2 lines and added the app.php, now everything works and im too lazy to change anything on nginx currently :p
uaellaen
Registered User
Posts: 18
Joined: Mon Sep 18, 2006 4:21 pm
Contact:

Re: phpBB Gallery 1.2.1

by ghswen » Thu Apr 25, 2019 8:51 pm

Tarantino wrote:I would need to see your forum and the problem in first hand. I'm not remember of such problem.
Just a bit of an update. I have re-installed MySQL plus phpBB3.3.2 running MySQL(i) 5.7.25-0ubuntu0.18.04.2
PHP Version 7.2.17

Everything is back up and running so I attempted to install the latest version of phpBB Gallery. (1.2.1) from Github.

I have installed just the core and everything is working except I cannot see the images. I looked for the 'gallery/images' folder and cannot find one.

Here's a link to the forum: http://astronomy.hopto.org Any help would be appreciated!
ghswen
Registered User
Posts: 40
Joined: Sun Apr 21, 2019 9:04 pm
Contact: