"Users" section issue, unable to click into the users section as an admin "Users" section issue, unable to click into the users section as an admin
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

"Users" section issue, unable to click into the users section as an admin

Started by Touge.ca, July 04, 2012, 03:27:37 AM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

Touge.ca

I m having issue with my coppermine photos album,

when I logged in as an admin, and click into "users", it shows the
below message instead of the users account and info.

It was not like this before..just happened recently.

is there anyway I can get it fixed?  should I upgrade it from 1.5.16 to 1.5.20?

------------------------------------------------------------
Internal Server Error

The server encountered an internal error or misconfiguration and was
unable to complete your request.

Please contact the server administrator, webmaster@touge.ca and
inform them of the time the error occurred, and anything you might
have done that may have caused the error.

More information about this error may be available in the server
error log.

Additionally, a 404 Not Found error was encountered while trying to
use an ErrorDocument to handle the request.
------------------------------------------------------------

thanks

Touge.ca

I can still batch upload files, no problem, and quite of the other features has no problems too.

only the "Users" button has problem.

Αndré


Touge.ca

Quote from: Αndré on July 04, 2012, 08:44:23 AM
Yes, please.

hi Andre,

just uploaded to 1.5.20...

but the Users section still not working... other sections working ok..

any hints would be greatly appreciated.

thanks

Kevin


Αndré

Unfortunately this is a quite meaningless HTTP error code, so please do as suggested:
Quote from: Touge.ca on July 04, 2012, 03:27:37 AM
Internal Server Error

The server encountered an internal error or misconfiguration and was
unable to complete your request.

Please contact the server administrator, webmaster@touge.ca and
inform them of the time the error occurred, and anything you might
have done that may have caused the error.

More information about this error may be available in the server
error log.


Additionally, a 404 Not Found error was encountered while trying to
use an ErrorDocument to handle the request.


A link to your gallery and some information about configuration / bridging might also help.

Touge.ca

Quote from: Αndré on July 05, 2012, 09:23:09 AM
Unfortunately this is a quite meaningless HTTP error code, so please do as suggested:

A link to your gallery and some information about configuration / bridging might also help.

hi Andre,

my gallery is http://www.touge.ca/photos

what kind of configuration/bridging info do you want?

Under "Bridge Wizard: choose application to bridge Coppermine with "
I haven't choose any application to bridge Coppermine with.

For config info, which settings do you need?

can I pm/email you a login to see the problem?


thanks


Αndré

Quote from: Touge.ca on July 05, 2012, 10:29:24 PM
Under "Bridge Wizard: choose application to bridge Coppermine with "
I haven't choose any application to bridge Coppermine with.
So your gallery is not bridged, well.


Quote from: Touge.ca on July 05, 2012, 10:29:24 PM
can I pm/email you a login to see the problem?
Just sent you a PM. To perform some tests with the user manager, FTP access would be very helpful.

Touge.ca

Quote from: Αndré on July 06, 2012, 10:09:20 AM
So your gallery is not bridged, well.

Just sent you a PM. To perform some tests with the user manager, FTP access would be very helpful.

emailed you. 

thanks a lot.

Αndré

In bridge/udb_base.inc.php you'll find that query:
        $sql = "SELECT {$f['user_id']} AS user_id, {$f['username']} AS user_name, {$f['email']} AS user_email, {$f['regdate']} AS user_regdate, {$f['lastvisit']} AS user_lastvisit, {$f['active']} AS user_active, "
               . "COUNT(pid) AS pic_count, ROUND(SUM(total_filesize)/1024) AS disk_usage, group_name, group_quota, user_group_list "
               . "FROM {$this->usertable} AS u "
               . "INNER JOIN `{$C['dbname']}`.{$C['TABLE_USERGROUPS']} AS g ON u.{$f['usertbl_group_id']} = g.group_id "
               . "LEFT JOIN `{$C['dbname']}`.{$C['TABLE_PICTURES']} AS p ON p.owner_id = u.{$f['user_id']} "
               . $options['search']
               . "GROUP BY user_id " . "ORDER BY " . $sort_codes[$options['sort']] . " "
               . "LIMIT {$options['lower_limit']}, {$options['users_per_page']};";


I replaced
. "COUNT(pid) AS pic_count, ROUND(SUM(total_filesize)/1024) AS disk_usage, group_name, group_quota "
with
. "group_name, group_quota "
and the user manager loads. Obviously, that code change breaks the file count and disk usage. But it seems that your database isn't powerful enough to run the stock query.

Touge.ca

Thanks a bunch Andre,

how can I determine if my database is powerful enough? or How can I upgrade it?

Αndré

I already wrote that via email, but here again.

Execute the following queries with a tool like phpMyAdmin. Maybe you get a more detailed error message (or non at all).

1. (probably won't work):
QuoteSELECT user_id AS user_id, user_name AS user_name, user_email AS user_email, UNIX_TIMESTAMP(user_regdate) AS user_regdate, UNIX_TIMESTAMP(user_lastvisit) AS user_lastvisit, user_active AS user_active, COUNT(pid) AS pic_count, ROUND(SUM(total_filesize)/1024) AS disk_usage, group_name, group_quota FROM `phantomb_copp1`.cpg_users AS u INNER JOIN `phantomb_copp1`.cpg_usergroups AS g ON u.user_group = g.group_id LEFT JOIN `phantomb_copp1`.cpg_pictures AS p ON p.owner_id = u.user_id GROUP BY user_id ORDER BY user_regdate DESC LIMIT 0, 25;


2. (should work):
QuoteSELECT user_id AS user_id, user_name AS user_name, user_email AS user_email, UNIX_TIMESTAMP(user_regdate) AS user_regdate, UNIX_TIMESTAMP(user_lastvisit) AS user_lastvisit, user_active AS user_active, group_name, group_quota FROM `phantomb_copp1`.cpg_users AS u INNER JOIN `phantomb_copp1`.cpg_usergroups AS g ON u.user_group = g.group_id LEFT JOIN `phantomb_copp1`.cpg_pictures AS p ON p.owner_id = u.user_id GROUP BY user_id ORDER BY user_regdate DESC LIMIT 0, 25;


Quote from: Touge.ca on July 14, 2012, 03:01:06 AM
How can I upgrade it?
Ask your hosting provider. Maybe you can increase some limits yourself, or they'll do. Maybe you have to search for another hosting provider.