PHP 7.0

[maxhasher]

Further to last :-
As I was on my local machine I followed some advice and added
disable_strict_mode.cnf
containing
[mysqld]
sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

to the /etc/mysql/conf.d/ folder

this allowed the registered user to upload.
I can't work out where the difference is between the admin and the registered user SQL settings in UPLOAD.PHP that would bar the reg user and not the admin by strict mode.
I would have thought it would be both or neither.

[ron4mac]

I've pulled up an error
(Critical error  There was an error while processing a database query)
in upload with 1.6.01 with basic details in the attached txt file.
No issue with the cpg Admin user but failure as a Registered user.

Thank you very much for providing good feedback. I created a fresh system (Linux) with PHP 7.0.15 and mysql 5.7.17.  I was able to see the problem that you described and was able to make coding corrections to prevent the error. The error stemmed from strict usage requirements of the sql DISTINCT keyword.

I have applied the corrections to the Github distribution.

[maxhasher]

Glad to help
Don't think it will be long before 1&1 update php to 5.7 but not sure where they will go with the mysql server. But better to engineer than to repair..

[maxhasher]

tested ok having just overwritten the january code with the march version.
Good going.
Long way down the code that.
I had a similar issue with not adding a field I was querying with.

[maxhasher]

Hi ron4mac Got another
In the new version of the code
On the home page it displays a link to the user galleries
Clicking this pulls up the page index.php?cat=1
and produces
Critical error
There was an error while processing a database query

[ron4mac]

Okay ... thanks.

Fix is:
file bridge/udb_base.inc.php replace line 521

Code Select Expand

. "WHERE ((ISNULL(approved) OR approved='YES') AND category > " . FIRST_USER_CAT . ") $FORBIDDEN_SET GROUP BY user_id "

with

Code Select Expand

. "WHERE ((ISNULL(approved) OR approved='YES') AND category > " . FIRST_USER_CAT . ") $FORBIDDEN_SET GROUP BY category, user_id "


Max, it would be better if you could create 'issues' at the CPG 1.6 Github repository for any additional items that you may run across in your particular system setup.

[maxhasher]

ok thanks.

I'll do that then on git

[maxhasher]

works well..
Sorry, my testing background has kicked in 

[ron4mac]

Sorry, my testing background has kicked in 

No sorry here ... your help is truly appreciated.

[luchtzak]

http://www.luchtzak.be/pictures/

[ron4mac]

http://www.luchtzak.be/pictures/

Use this to update to 1.6.03:
http://forum.coppermine-gallery.net/index.php/topic,79013.0.html

[luchtzak]

Use this to update to 1.6.03:
http://forum.coppermine-gallery.net/index.php/topic,79013.0.html

Doesn't work ...

[phill104]

In what way "doesn't work"? A bit more information telling us exactly the problem might help us help you.

[luchtzak]

In what way "doesn't work"? A bit more information telling us exactly the problem might help us help you.

Works again! The database crashed...