forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: Touge.ca on July 04, 2012, 03:27:37 am

Title: "Users" section issue, unable to click into the users section as an admin
Post by: Touge.ca on July 04, 2012, 03:27:37 am
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
Title: Re: "Users" section issue, unable to click into the users section as an admin
Post by: Touge.ca on July 04, 2012, 03:45:50 am
I can still batch upload files, no problem, and quite of the other features has no problems too.

only the "Users" button has problem.
Title: Re: "Users" section issue, unable to click into the users section as an admin
Post by: Αndré on July 04, 2012, 08:44:23 am
should I upgrade it from 1.5.16 to 1.5.20?
Yes, please.
Title: Re: Re: "Users" section issue, unable to click into the users section as an admin
Post by: Touge.ca on July 05, 2012, 09:13:33 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

Title: Re: "Users" section issue, unable to click into the users section as an admin
Post by: Αndré on July 05, 2012, 09:23:09 am
Unfortunately this is a quite meaningless HTTP error code, so please do as suggested:
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.
Title: Re: Re: "Users" section issue, unable to click into the users section as an admin
Post by: Touge.ca on July 05, 2012, 10:29:24 pm
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

Title: Re: Re: "Users" section issue, unable to click into the users section as an admin
Post by: Αndré on July 06, 2012, 10:09:20 am
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.


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.
Title: Re: Re: Re: "Users" section issue, unable to click into the users section as an admin
Post by: Touge.ca on July 07, 2012, 04:57:30 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.
Title: Re: "Users" section issue, unable to click into the users section as an admin
Post by: Αndré on July 09, 2012, 02:04:12 pm
In bridge/udb_base.inc.php you'll find that query:
Code: [Select]
        $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
Code: [Select]
. "COUNT(pid) AS pic_count, ROUND(SUM(total_filesize)/1024) AS disk_usage, group_name, group_quota "with
Code: [Select]
. "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.
Title: Re: "Users" section issue, unable to click into the users section as an admin
Post by: Touge.ca on July 14, 2012, 03:01:06 am
Thanks a bunch Andre,

how can I determine if my database is powerful enough? or How can I upgrade it?
Title: Re: "Users" section issue, unable to click into the users section as an admin
Post by: Αndré on July 14, 2012, 09:47:45 am
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):
Quote
SELECT 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):
Quote
SELECT 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;


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.