Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1] 2 3 4 5 ... 10
 1 
 on: February 29, 2024, 09:39:45 pm 
Started by HVW - Last post by HVW
Fixed it by myself!

My conclusion is that the cause of this problem is in the 'sql_mode'. That setting is managed by the hosting partner, so I had to make a workaround.
In the logging of Coppermine I found errors:

Quote
GROUP BY r.aid
ORDER BY NULL' in index.php on line 362 the following error was encountered:
1055 : 'databasename.c.cid' isn't in GROUP BY

I edited index.php from this:
Quote
    // album stats for regular albums
    $sql = "SELECT r.aid, c.cid, COUNT(pid) AS pic_count, MAX(pid) AS last_pid, MAX(ctime) AS last_upload, depth AS level, lft
        FROM {$CONFIG['TABLE_CATEGORIES']} AS c
        INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS r ON r.category = c.cid
        INNER JOIN {$CONFIG['TABLE_PICTURES']} AS p ON p.aid = r.aid
        WHERE c.depth >= $CURRENT_CAT_DEPTH + 1
        AND approved = 'YES'
        $forbidden_set
        $lft_rgt
        GROUP BY r.aid
        ORDER BY NULL";
To this:
Quote
    // album stats for regular albums
    $sql = "SELECT r.aid, c.cid, COUNT(pid) AS pic_count, MAX(pid) AS last_pid, MAX(ctime) AS last_upload, depth AS level, lft
        FROM {$CONFIG['TABLE_CATEGORIES']} AS c
        INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS r ON r.category = c.cid
        INNER JOIN {$CONFIG['TABLE_PICTURES']} AS p ON p.aid = r.aid
        WHERE c.depth >= $CURRENT_CAT_DEPTH + 1
        AND approved = 'YES'
        $forbidden_set
        $lft_rgt
        GROUP BY r.aid, c.cid, c.depth, c.lft
        ORDER BY NULL";

Then the error dissapeared and Coppermine worked like a charm!

 2 
 on: February 29, 2024, 07:37:50 pm 
Started by HVW - Last post by HVW
I just finished a fresh new install of Coppermine 1.6.26. After a succesfully install I get an error on my Coppermine page.
All settings are still default, nothing changed yet.
I checked update.php, no errors.

These are my site settings:
http://beeldbank.hvwormerveer.nl/
CPG version: 1.6.26
PHP version: 8.2.15

Is there anyone who can help me with this problem?

 3 
 on: February 19, 2024, 03:02:15 pm 
Started by tadeuszd - Last post by tadeuszd
Hi!
I'm not sure if this forum is still alive or not, but I have prepared the full Polish translation for the current version of CPG (1.6.26).
My translation is mostly based on Vurmil's earlier (outdated) translation. I added all new sentences in the new translation. Compared to the old translation, I also changed names of some options to make them more understandable.

In the attachment you will find the polish.php file (zipped).

 4 
 on: February 13, 2024, 11:55:49 am 
Started by tadeuszd - Last post by tadeuszd
Hello!
I'm new on this forum, but I use CPG successfully since 2009. :D

Two weeks ago I started to create completely new theme for my CPG gallery. The main concept is to add more space between tables in the gallery layout. Besause of that I was forced to add additional header bar to the albums section on Category page (red frame in attached screenshot).
I did it by creating new section in $template_album_list template:
Code: [Select]
...
<!-- BEGIN cat_row -->
        <tr>
                <td colspan="{COLUMNS}" class="tableh1" align="leftr">{TITLE}</td>
        </tr>
<!-- END cat_row -->
...

... and modifying theme_display_album_list function in theme.php:
Code: [Select]
...
    $cat_row = template_extract_block($template_album_list, 'cat_row');
...
    $columns = $CONFIG['album_list_cols'];
    $column_width = ceil(100 / $columns);
    $thumb_cell_width = $CONFIG['alb_list_thumb_size'] + 2;

    starttable('100%');
// new header bar
$params = array('{TITLE}' => $lang_cat_list['albums'],
'{COLUMNS}' => $columns,
);
echo template_eval($cat_row, $params);

    if ($STATS_IN_ALB_LIST) {
        $params = array('{STATISTICS}' => $statistics,
            '{COLUMNS}' => $columns,
            );
        echo template_eval($stat_row, $params);
    }
...

It works, but I would like to show more information in this bar, something like "Albums in 'My category'". I tried to use $cat parameter, but $cat is only numerical value (category id)  and it doesn't provide any category data.

And this is my question - How can I achieve category title (or other category data, such as image attached to category) from inside theme_display_album_list function?

My current gallery is located at https://galeria.sttandard.org.pl , but my new theme is still "under construction" and available only on localhost.

 5 
 on: February 13, 2024, 12:33:30 am 
Started by BabeandJamie4Ever - Last post by BabeandJamie4Ever
Was able to solve the issue. For future reference in case anyone runs into a similar issue, for us what the problem was way back we reached the category limit and had to update the limit in include/init.inc.php. When updating the gallery the file would have reverted back to the old limit in the overwrite. By re-adding the new limit everything has gone back to normal and the areas showing Unknown Coward are back to how we had them.

 6 
 on: February 11, 2024, 03:24:36 am 
Started by BabeandJamie4Ever - Last post by BabeandJamie4Ever
Could not find an edit button so further information after browsing the gallery more:

- Unknown coward shows up for batch added files as well
- Unknown coward is applying to files and sections added by multiple administrative users
- Applies to files that are in "User galleries" which popped up after updating to 1.6x
- Not all recent adds are in user galleries, some are going there and some are going where they should be

 7 
 on: February 11, 2024, 03:07:32 am 
Started by BabeandJamie4Ever - Last post by BabeandJamie4Ever
We recently had our main menu disappear on our gallery:

https://star-kidz.net/imagearchive

updated to the latest version so could ask for support on the forum and now having multiple issues. The user galleries appeared to guests, and searching the forum said to delete the album in the user galleries and it won't display. Did that, still displays. Read to change the permissions under groups, still displays (did not touch administrators only members and guests)

Noticed as well that every category with files manually updated by the admin account shows as "Unknown Coward" with all further categories and albums gone. The files are still there as showing up in latest uploads, and clicking them takes to the album with a path as being under "unknown coward". Followed the instructions here: https://forum.coppermine-gallery.net/index.php?topic=78754.0 but it has not resolved the issue.

Also noticing that when clicking back to the user "unknown coward" when viewing images that we can see, it takes to a whole slew of albums labeled differently, and when clicking it says "selected user does not exist" however they were all uploaded under the account "admin" which is still listed as administrator. group, still exists, and still logs in.

I have re-run the update process in case something got mixed up in the update, with no success in fixing the issue.

How do we get rid of Unknown Coward and get our gallery back to being organized the way we had it?

 8 
 on: February 07, 2024, 02:03:33 pm 
Started by PvtPulse - Last post by PvtPulse
They seem to have fixed it. Thank you for the reply.

 9 
 on: February 07, 2024, 01:46:52 pm 
Started by PvtPulse - Last post by ron4mac
Your host has a crippled configuration of PHP 7 that doesn't include the most used modules. Either have them correct that or return to PHP 8 and we'll address the issues that you have with that.

 10 
 on: February 07, 2024, 10:15:30 am 
Started by littbarski - Last post by littbarski
thank you very much. I could choose 8.2 in the hosting options and it worked, and I found information that 8.2 and 8.3 have been released. But I am not an expert as mentioned.

My hope was that perhaps since 1.6.20 the main issues for php 8 have been fixed and now huge and new issues appeared. Well after all I am just shy in updating Coppermine, I have to admit :).

So my last question here would be: when I update my Coppermine on the hosting server, is this always only the files that I can see in FTP or was any of the last Coppermine updates also doing anything in the database (files)? I think I remember that I once only uploaded new files into my FTP folders, not using an automatic update program.

(I understand if this is offtopic and won't get answers)

Pages: [1] 2 3 4 5 ... 10

Page created in 0.026 seconds with 16 queries.