Support > cpg1.5 miscellaneous
[Closed]: What's mean that
MisteryBrother:
In the logfiles I find these error code:
Bud i don't understand what's mean that
--- Code: ---Apr 12, 2010 at 12:46 AM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id
FROM gallerypictures AS r
INNER JOIN galleryalbums AS a ON a.aid = r.aid
WHERE (category = 10062) AND r.aid NOT IN (15, 14, 20, 315, 81, 82, 192, 408, 528, 585, 610, 769, 821, 1159, 1414, 100, 1861, 1900, 150, 173, 304, 381, 469, 540, 627, 726, 850, 497, 520, 588, 618, 633, 680, 704, 705, 714, 754, 791, 830, 852, 1112, 1539, 1574, 1703, 1739, 1840, 2047)
AND approved = 'YES'
AND hits > 0
ORDER BY hits ASC, pid DESC
LIMIT 0 ,-41' in include/functions.inc.php on line 1583 the following error was encountered:
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 '-41' at line 8
--- End code ---
There stay also:
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 '-41' at line 8
Joachim Müller:
The testing/bugs board is not meant for support. Your posting doesn't qualify as valid test report, so I'm moving it accordingly.
In fact your posting doesn't even qualify as valid support request, as you failed to respect borad rules:
* You haven't posted a link to your gallery
* Your thread's subject certainly doesn't describe the issue discussed in the thread
MisteryBrother:
Coppermine version: cpg1.5.3 (RC)
Server: Linux srv77 2.6.26-2-vserver-amd64 #1 SMP Thu Nov 5 03:47:07 UTC 2009 x86_64
(Virtual hosting server by One.com)
PHP Version: 5.3.2
Image library used: GD Version 2.x
Bridging: none
Themes tested: Rainy day (before in another theme I get the same error)
Client OS: NVT
Client Browser: NVT
Install type: 1 month with the new time
Source: functions.inc.php -- Coppermine version: 1.5.4
Browser language: I use Dutch
Coppermine language: There are a few langue in
What happened (potential bug): I get the error message in the log files, but we don’t see any error on board
--- Code: ---Apr 08, 2010 at 04:00 AM - While executing query 'SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id
FROM gallerypictures AS r
INNER JOIN galleryalbums AS a ON a.aid = r.aid
WHERE (r.aid = 2074) AND r.aid NOT IN (15, 14, 20, 315, 81, 82, 192, 408, 528, 585, 610, 769, 821, 1159, 1414, 100, 1861, 1900, 150, 173, 304, 381, 469, 540, 627, 726, 850, 497, 520, 588, 618, 633, 680, 704, 705, 714, 754, 791, 830, 852, 1112, 1539, 1574, 1703, 1739, 1840, 2047)
AND approved = 'YES'
AND hits > 0
ORDER BY hits ASC, pid DESC
LIMIT 0 ,-225' in include/functions.inc.php on line 1583 the following error was encountered:
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 '-225' at line 8
--- End code ---
How to replicate (what I did when the problem showed up): I'm logged in as admin and click on the read the log files under “database”
Attention:
I have edit the functions.inc.php
Why? Well now I have creation a group “moderators” These group can see all the pictures include private albums.
Find these:
--- Code: ---function get_private_album_set($aid_str="")
{
if (GALLERY_ADMIN_MODE) {
return;
}
global $CONFIG, $USER_DATA, $FORBIDDEN_SET, $FORBIDDEN_SET_DATA;
$superCage = Inspekt::makeSuperCage();
$FORBIDDEN_SET_DATA = array();
if ($USER_DATA['can_see_all_albums']) {
return;
}
--- End code ---
And I have edit it with these one:
--- Code: ---function get_private_album_set($aid_str="")
{
global $USER, $CONFIG, $CURRENT_CAT_NAME, $CURRENT_ALBUM_KEYWORD, $FAVPICS, $FORBIDDEN_SET_DATA, $FORBIDDEN_SET, $USER_DATA;
if (GALLERY_ADMIN_MODE || ($USER_DATA['group_name']== 'Moderators')) {
return;
}
global $CONFIG, $USER_DATA, $FORBIDDEN_SET, $FORBIDDEN_SET_DATA;
$superCage = Inspekt::makeSuperCage();
$FORBIDDEN_SET_DATA = array();
if ($USER_DATA['can_see_all_albums']) {
return;
}
--- End code ---
In the attachement the current functions.inc.php file
In the attachement a screenshot from the error code
Joachim Müller:
--- Quote from: Joachim Müller on April 12, 2010, 07:30:02 am ---
* You haven't posted a link to your gallery
--- End quote ---
Where's the link to your gallery?
--- Quote from: MisteryBrother on April 12, 2010, 03:42:52 pm ---Source: functions.inc.php -- Coppermine version: 1.5.4
--- End quote ---
Such a version doesn't exist yet. You're ahead of your time ;).
--- Quote from: MisteryBrother on April 12, 2010, 03:42:52 pm ---I have edit the functions.inc.php
Why? Well now I have creation a group “moderators” These group can see all the pictures include private albums.
--- End quote ---
Deliberately disabling the security mechanisms is one of the privileges you have when using an open source app. But please don't blame coppermine if this is used against you. At everyone else reading this thread: don't! That modifications doesn't give you an actual moderator group that has moderation privileges.
MisteryBrother:
Yes I’m agree it is not save from me for changes anything in these code.
But these was the only option for make a group that have full access (not the admin access) and can see private albums (creation by new users)
Yes I have edit edit: edit_one_pic.php also, that’s mean the moderator group see below the picture: Edit these file
I know there is a option called: “Album can be moderated by”
But these is not working for members albums.
Anyway these I a open source software but so far I can read here, Coppermine don’t like it if you edit a few stuff.
I just asking what is the error code that stay in the log file? Never mind thanks for the support
Navigation
[0] Message Index
[#] Next page
Go to full version