Then I click to http://*********.com/index.php?cat=1 i get an error There was an error while processing a database query
I made some modifications before 2-3 weeks and now a user told me for this problem. I no other place there is no such an error.
Where to look for the problem :)
Enable debug mode in config, navigate to the problem page and post the mysql error message that you get, not the entire debug output.
While executing query "AND category >= 10000 GROUP BY user_id ORDER BY user_name" on 0
mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND category >= 10000 GROUP BY user_id ORDER BY user_name' at line 1
See if temporarily switching to an unmodified version of index.php fixes it. Make sure you didn't use an = instead of a .= somewhere when you made the modifications.
I replaced my Index.php with a original one and there is no effect :o
in index.php find the function list_users
replace the var $sql with
$sql = "SELECT owner_id as user_id, " .
"owner_name as user_name, " .
"COUNT(DISTINCT a.aid) as alb_count, " .
"COUNT(DISTINCT pid) as pic_count, " .
"MAX(pid) as thumb_pid " .
"FROM {$CONFIG['TABLE_ALBUMS']} AS a " .
"INNER JOIN {$CONFIG['TABLE_PICTURES']} AS p ON (p.aid = a.aid AND approved = 'YES') ";
if ($FORBIDDEN_SET != "") $sql .= "WHERE $FORBIDDEN_SET ";
$sql .= "AND category >= " . FIRST_USER_CAT . " GROUP BY user_id " .
"ORDER BY thumb_pid DESC"; // order by last uploaded
//"ORDER BY user_name"; // order by user name
and please tell me if it works
NO effect :(
I attached a copy of my current index.php , with tihs correction above
upgrade at least to cpg1.3.5
It is 1.35 from months :)
index.php says 1.3.3
uncomment this line
// $sql = "SELECT owner_id as user_id, " .
Worked!
You are the best support for free script!