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   Go Down

Author Topic: [Solved]: Sort albums with swedish letters  (Read 7065 times)

0 Members and 1 Guest are viewing this topic.

aik_putte

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
[Solved]: Sort albums with swedish letters
« on: September 13, 2008, 07:57:51 pm »

I use swedish letters in my gallery and it works fine writing the letters and I use UTF-8 but I want to sort my albums that has swedish letters in them.
Our alphabet ends Y Z Å Ä Ö but the gallery thinks that Å and Ä comes after A and that Ö comes after O but that isn't the case, is there any way to fix that so albums that have swedish letters in them comes in the right order?
« Last Edit: September 16, 2008, 08:32:38 pm by Nibbler »
Logged

Nibbler

  • Guest
Re: Sort albums with swedish letters
« Reply #1 on: September 13, 2008, 09:01:09 pm »

Set your database to use swedish collation (utf8_swedish_ci).
Logged

aik_putte

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: Sort albums with swedish letters
« Reply #2 on: September 13, 2008, 09:16:07 pm »

Where do I change that? In a .php-file?
Logged

Nibbler

  • Guest
Re: Sort albums with swedish letters
« Reply #3 on: September 13, 2008, 09:27:23 pm »

Using phpmyadmin.
Logged

aik_putte

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: Sort albums with swedish letters
« Reply #4 on: September 13, 2008, 09:41:16 pm »

It didnt make any difference, do I have to do anything else?
Logged

Nibbler

  • Guest
Re: Sort albums with swedish letters
« Reply #5 on: September 13, 2008, 10:24:18 pm »

Try changing the collation of the title field in the albums table.
Logged

aik_putte

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: Sort albums with swedish letters
« Reply #6 on: September 13, 2008, 10:28:28 pm »

That didnt help either, the album which has swedish letters moved to the beginnig instead of the end but in the Album-list where you create new albums the album is at the bottom, which is right.
Logged

Nibbler

  • Guest
Re: Sort albums with swedish letters
« Reply #7 on: September 13, 2008, 10:41:09 pm »

The album manager is not sorted by name anyway. Post a link to your gallery.
Logged

aik_putte

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: Sort albums with swedish letters
« Reply #8 on: September 13, 2008, 10:42:19 pm »

http://www.phbuss.se/bussbilder/album/index.php?cat=3
Here you can see, Bäckströms Trafik should be last.
Logged

aik_putte

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: Sort albums with swedish letters
« Reply #9 on: September 14, 2008, 01:10:54 pm »

No other ideas?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47844
  • aka "GauGau"
    • gaugau.de
Re: Sort albums with swedish letters
« Reply #10 on: September 14, 2008, 02:24:41 pm »

As Nibbler already pointed out, albums are not being sorted alphabetically, but in the order you create them in album manager. You appear to be using a custom hack. Post a reference to the hack you used (the URL of the thread that explains the mod applied)
Logged

aik_putte

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: Sort albums with swedish letters
« Reply #11 on: September 14, 2008, 02:32:21 pm »

I dont remember which threads hack I used but this is the custom things I made in theme.php, this was to make the categorylist to three columns and moving the menu to the bottom.
Code: [Select]
// HTML template for the category list
$template_cat_list = <<<EOT
<!-- BEGIN header -->
        <tr>
        <tr>
                <td class="tableh1" width="25%"><b>{CATEGORY}</b></td>
                <td class="tableh1" width="4%" align="center"><b>{ALBUMS}</b></td>
                <td class="tableh1" width="4%" align="center"><b>{PICTURES}</b></td>
<td class="tableh1" width="26%"><b>{CATEGORY}</b></td>
                <td class="tableh1" width="4%" align="center"><b>{ALBUMS}</b></td>
                <td class="tableh1" width="4%" align="center"><b>{PICTURES}</b></td>
<td class="tableh1" width="25%"><b>{CATEGORY}</b></td>
                <td class="tableh1" width="4%" align="center"><b>{ALBUMS}</b></td>
                <td class="tableh1" width="4%" align="center"><b>{PICTURES}</b></td>
        </tr>
        </tr>
<!-- END header -->
<!-- BEGIN catrow_noalb -->
                <td class="catrow_noalb" colspan="3"><table border="0"><tr><td align="left">{CAT_THUMB}</td><td align="left"><span class="catlink"><b>{CAT_TITLE}</b></span>{CAT_DESC}</td></tr></table></td>
<!-- END catrow_noalb -->
<!-- BEGIN catrow -->
                <td class="catrow" align="left"><table border="0"><tr><td>{CAT_THUMB}</td><td><span class="catlink"><b>{CAT_TITLE}</b></span>{CAT_DESC}</td></tr></table></td>
                <td class="catrow" align="center">{ALB_COUNT}</td>
                <td class="catrow" align="center">{PIC_COUNT}</td>

<!-- END catrow -->
<!-- BEGIN footer -->
        <tr>
                <td colspan="9" class="tableh1" align="center"><span class="statlink"><b>{STATISTICS}</b></span></td>
        </tr>
<!-- END footer -->
<!-- BEGIN spacer -->
        <img src="images/spacer.gif" width="1" height="7" border="" alt="" /><br />
<!-- END spacer -->

EOT;

function theme_display_cat_list($breadcrumb, &$cat_data, $statistics)
{
    global $template_cat_list, $lang_cat_list;
    if (count($cat_data) > 0) {
        starttable('100%');
        $template = template_extract_block($template_cat_list, 'header');
        $params = array('{CATEGORY}' => $lang_cat_list['category'],
            '{ALBUMS}' => $lang_cat_list['albums'],
            '{PICTURES}' => $lang_cat_list['pictures'],
            );
        echo template_eval($template, $params);
    }

    $template_noabl = template_extract_block($template_cat_list, 'catrow_noalb');
    $template = template_extract_block($template_cat_list, 'catrow');


    $count=0;
    $columnCount=3;
    echo "<tr>";

    foreach($cat_data as $category) {
If ($count%$columnCount==0) {
    echo "</tr><tr>";
}
        $count++;
        if (count($category) == 3) {
            $params = array('{CAT_TITLE}' => $category[0],
                    '{CAT_THUMB}' => $category['cat_thumb'],
                '{CAT_DESC}' => $category[1]
                );
            echo template_eval($template_noabl, $params);
        } elseif (isset($category['cat_albums']) && ($category['cat_albums'] != '')) {
            $params = array('{CAT_TITLE}' => $category[0],
                '{CAT_THUMB}' => $category['cat_thumb'],
                '{CAT_DESC}' => $category[1],
                '{CAT_ALBUMS}' => $category['cat_albums'],
                '{ALB_COUNT}' => $category[2],
                '{PIC_COUNT}' => $category[3],
                );
            echo template_eval($template, $params);
        } else {
            $params = array('{CAT_TITLE}' => $category[0],
                '{CAT_THUMB}' => $category['cat_thumb'],
                '{CAT_DESC}' => $category[1],
                '{CAT_ALBUMS}' => '',
                '{ALB_COUNT}' => $category[2],
                '{PIC_COUNT}' => $category[3],
                );
            echo template_eval($template, $params);
        }
    }
echo "</tr>";
    if ($statistics && count($cat_data) > 0) {
        $template = template_extract_block($template_cat_list, 'footer');
        $params = array('{STATISTICS}' => $statistics);
        echo template_eval($template, $params);
    }


    if (count($cat_data) > 0)
          endtable();
        echo template_extract_block($template_cat_list, 'spacer');
}



// Function for writing a pageheader
function pageheader($section, $meta = '')
{
    global $CONFIG, $THEME_DIR;
    global $template_header, $lang_charset, $lang_text_dir;

    $custom_header = cpg_get_custom_include($CONFIG['custom_header_path']);

        $charset = ($CONFIG['charset'] == 'language file') ? $lang_charset : $CONFIG['charset'];

    header('P3P: CP="CAO DSP COR CURa ADMa DEVa OUR IND PHY ONL UNI COM NAV INT DEM PRE"');
        header("Content-Type: text/html; charset=$charset");
    user_save_profile();

    $template_vars = array('{LANG_DIR}' => $lang_text_dir,
        '{TITLE}' => $CONFIG['gallery_name'] . ' - ' . strip_tags(bb_decode($section)),
        '{CHARSET}' => $charset,
        '{META}' => $meta,
        '{GAL_NAME}' => $CONFIG['gallery_name'],
        '{GAL_DESCRIPTION}' => $CONFIG['gallery_description'],
        '{CUSTOM_HEADER}' => $custom_header,
        );

    echo template_eval($template_header, $template_vars);
}

// Function for writing a pagefooter
function pagefooter()
{
    //global $HTTP_GET_VARS, $HTTP_POST_VARS, $HTTP_SERVER_VARS;
    global $USER, $USER_DATA, $ALBUM_SET, $CONFIG, $time_start, $query_stats, $queries;;
    global $template_footer;

    $custom_footer = cpg_get_custom_include($CONFIG['custom_footer_path']);

    if ($CONFIG['debug_mode']==1 || ($CONFIG['debug_mode']==2 && GALLERY_ADMIN_MODE)) {
    cpg_debug_output();
    }

    $template_vars = array(
        '{CUSTOM_FOOTER}' => $custom_footer,
'{SYS_MENU}' => theme_main_menu('sys_menu'),
        '{SUB_MENU}' => theme_main_menu('sub_menu'),
        '{ADMIN_MENU}' => theme_admin_mode_menu(),
        '{VANITY}' => (defined('THEME_IS_XHTML10_TRANSITIONAL') && $CONFIG['vanity_block']) ? theme_vanity() : '',
    );

    echo template_eval($template_footer, $template_vars);
}



?>

If they are not sorted alphabetically, can I sort the albums manually without changing the order of the categories and the images inside the albums?
Logged

aik_putte

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: Sort albums with swedish letters
« Reply #12 on: September 15, 2008, 06:43:06 pm »

Can I sort the albums manually without changing the categories and pictures?
Logged

Nibbler

  • Guest
Re: Sort albums with swedish letters
« Reply #13 on: September 16, 2008, 07:22:02 pm »

Yeah, that's what the arrows are for in the album manager.
Logged

aik_putte

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: Sort albums with swedish letters
« Reply #14 on: September 16, 2008, 07:54:14 pm »

Yeah, that's what the arrows are for in the album manager.

And yet nothing happens when I move them around with the arrows...
The categories was moveable but not the albums, can I change something in Settings so I can move the albums? I only find the options to move categories and thumbnails.
Logged

Nibbler

  • Guest
Re: Sort albums with swedish letters
« Reply #15 on: September 16, 2008, 07:56:45 pm »

Do they move up and down in the interface? Do you get a javascript error message?

Post a link and test account with upload rights.
Logged

aik_putte

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: Sort albums with swedish letters
« Reply #16 on: September 16, 2008, 07:59:54 pm »

Do they move up and down in the interface? Do you get a javascript error message?

Yes, they stay where I put them in the list but in the albumview they stay alphabetically.
I dont get any error message, only this which confirms my change.

Uppdaterar album '113' med titel 'Byberg & Nordins Busstrafik' och index '143'
Uppdaterar album '87' med titel 'Bäckströms Trafik' och index '144'

In english:
Updating album '113' with titel 'Byberg & Nordins Busstrafik' and index '143' etc.
Logged

Nibbler

  • Guest
Re: Sort albums with swedish letters
« Reply #17 on: September 16, 2008, 08:02:10 pm »

Can you enable debug mode in config and paste the debug output you get from http://www.phbuss.se/bussbilder/album/index.php?cat=3
Logged

aik_putte

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: Sort albums with swedish letters
« Reply #18 on: September 16, 2008, 08:04:20 pm »

Do you mean this?
Code: [Select]
USER:
------------------
Array
(
    [ID] => 8f66efcffae5be067b07f85fb92c76eb
    [am] => 1
    [lang] => swedish
    [liv] => Array
        (
            [0] => 2
            [1] => 1
            [2] => 6
            [3] => 4
        )

    [search] => Array
        (
            [search] => 342
            [album] => search
            [title] => on
            [newer_than] =>
            [caption] => on
            [older_than] =>
            [keywords] => on
            [type] => AND
            [params] => Array
                (
                    [title] => on
                    [caption] => on
                    [keywords] => on
                )

        )

    [lap] => 1
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => Patrik
    [groups] => Array
        (
            [0] => 1
        )

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 20
    [num_URI_upload] => 3
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [upload_form_config] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM phbuss_filetypes; (0s)
    [1] => select * from phbuss_plugins order by priority asc; (0s)
    [2] => delete from `phbuss_se`.phbuss_sessions where time<1221584626 and remember=0; (0.004s)
    [3] => delete from `phbuss_se`.phbuss_sessions where time<1220378626; (0s)
    [4] => select user_id from `phbuss_se`.phbuss_sessions where session_id = '1ee034691e504e1f409b65e150399f95' (0.001s)
    [5] => select user_id as id, user_password as password from `phbuss_se`.phbuss_users where user_id=1 (0.001s)
    [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `phbuss_se`.phbuss_users AS u INNER JOIN `phbuss_se`.phbuss_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.001s)
    [7] => SELECT user_group_list FROM `phbuss_se`.phbuss_users AS u WHERE user_id='1' and user_group_list <> ''; (0.011s)
    [8] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM phbuss_usergroups WHERE group_id in (1) (0.001s)
    [9] => SELECT group_name FROM  phbuss_usergroups WHERE group_id= 1 (0s)
    [10] => update `phbuss_se`.phbuss_sessions set time='1221588226' where session_id = '1ee034691e504e1f409b65e150399f95' (0.001s)
    [11] => SELECT user_favpics FROM phbuss_favpics WHERE user_id = 1 (0.002s)
    [12] => DELETE FROM phbuss_banned WHERE expiry < '2008-09-16 20:03:46' (0.001s)
    [13] => SELECT * FROM phbuss_banned WHERE (ip_addr='193.150.208.138' OR ip_addr='193.150.208.138' OR user_id=1) AND brute_force=0 (0s)
    [14] => SELECT aid FROM phbuss_albums WHERE category = 3 (0s)
    [15] => SELECT cid FROM phbuss_categories WHERE parent = '3' (0s)
    [16] => SELECT aid FROM phbuss_albums WHERE category = 34 (0.001s)
    [17] => SELECT cid FROM phbuss_categories WHERE parent = '34' (0s)
    [18] => SELECT aid FROM phbuss_albums WHERE category = 38 (0s)
    [19] => SELECT cid FROM phbuss_categories WHERE parent = '38' (0s)
    [20] => SELECT aid FROM phbuss_albums WHERE category = 39 (0s)
    [21] => SELECT cid FROM phbuss_categories WHERE parent = '39' (0s)
    [22] => SELECT name, parent FROM phbuss_categories WHERE cid = '3' (0s)
    [23] => SELECT cid, name, description, thumb FROM phbuss_categories WHERE parent = '3'  ORDER BY pos (0s)
    [24] => SELECT aid FROM phbuss_albums WHERE category = 38 (0s)
    [25] => SELECT count(*) FROM phbuss_pictures as p, phbuss_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 38 (0.001s)
    [26] => SELECT count(*) FROM phbuss_albums as a WHERE category = '38' (0s)
    [27] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM phbuss_albums as a LEFT JOIN phbuss_pictures as p ON a.thumb=p.pid WHERE category=38 ORDER BY a.pos LIMIT 0,7 (0s)
    [28] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM phbuss_albums AS a  LEFT JOIN phbuss_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (66, 67, 68, 69, 70, 71, 72)GROUP BY a.aid (0s)
    [29] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='385' (0s)
    [30] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='396' (0s)
    [31] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='421' (0.001s)
    [32] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='453' (0s)
    [33] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='463' (0s)
    [34] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='476' (0.001s)
    [35] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='480' (0s)
    [36] => SELECT aid FROM phbuss_albums WHERE category = 39 (0s)
    [37] => SELECT count(*) FROM phbuss_pictures as p, phbuss_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 39 (0s)
    [38] => SELECT count(*) FROM phbuss_albums as a WHERE category = '39' (0.003s)
    [39] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM phbuss_albums as a LEFT JOIN phbuss_pictures as p ON a.thumb=p.pid WHERE category=39 ORDER BY a.pos LIMIT 0,6 (0.005s)
    [40] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM phbuss_albums AS a  LEFT JOIN phbuss_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (91, 92, 93, 94, 95, 96)GROUP BY a.aid (0.003s)
    [41] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='598' (0.001s)
    [42] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='601' (0.001s)
    [43] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='619' (0s)
    [44] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='620' (0.001s)
    [45] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='624' (0s)
    [46] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='625' (0s)
    [47] => SELECT aid FROM phbuss_albums WHERE category = 34 (0.001s)
    [48] => SELECT count(*) FROM phbuss_pictures as p, phbuss_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 34 (0s)
    [49] => SELECT count(*) FROM phbuss_albums as a WHERE category = '34' (0s)
    [50] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM phbuss_albums as a LEFT JOIN phbuss_pictures as p ON a.thumb=p.pid WHERE category=34 ORDER BY a.pos LIMIT 0,28 (0s)
    [51] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM phbuss_albums AS a  LEFT JOIN phbuss_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141)GROUP BY a.aid (0s)
    [52] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='730' (0s)
    [53] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='737' (0s)
    [54] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='751' (0s)
    [55] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='772' (0s)
    [56] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='831' (0.005s)
    [57] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='838' (0.001s)
    [58] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='845' (0s)
    [59] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='850' (0.002s)
    [60] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='869' (0.002s)
    [61] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='883' (0s)
    [62] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='934' (0.001s)
    [63] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='940' (0s)
    [64] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='987' (0.001s)
    [65] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='1030' (0s)
    [66] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='1035' (0.001s)
    [67] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='1045' (0s)
    [68] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='1048' (0s)
    [69] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='1055' (0s)
    [70] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='1073' (0s)
    [71] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='1087' (0s)
    [72] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='1106' (0s)
    [73] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='1145' (0.001s)
    [74] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='1175' (0.001s)
    [75] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='1203' (0s)
    [76] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='1250' (0.001s)
    [77] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='1284' (0s)
    [78] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='1307' (0s)
    [79] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='1322' (0s)
    [80] => SELECT aid FROM phbuss_albums as a WHERE category = '3' (0s)
    [81] => SELECT count(*) FROM phbuss_albums as a WHERE category = '3' (0s)
    [82] => SELECT a.aid, a.title, a.description, category, visibility, filepath, filename, url_prefix, pwidth, pheight FROM phbuss_albums as a LEFT JOIN phbuss_pictures as p ON a.thumb=p.pid WHERE category=3 ORDER BY a.title LIMIT 0,28 (0.001s)
    [83] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM phbuss_albums AS a  LEFT JOIN phbuss_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (62, 83, 55, 57, 58, 59, 60, 87, 61, 63, 64, 65, 73, 74, 75, 76, 77, 79, 78, 80, 81, 82, 84, 85, 86, 88, 89, 90)GROUP BY a.aid (0s)
    [84] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='348' (0s)
    [85] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='548' (0s)
    [86] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='334' (0s)
    [87] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='340' (0s)
    [88] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='341' (0s)
    [89] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='342' (0s)
    [90] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='343' (0s)
    [91] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='564' (0.001s)
    [92] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='344' (0s)
    [93] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='351' (0s)
    [94] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='357' (0s)
    [95] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='368' (0s)
    [96] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='489' (0.001s)
    [97] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='492' (0s)
    [98] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='495' (0s)
    [99] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='496' (0.001s)
    [100] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='497' (0s)
    [101] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='500' (0s)
    [102] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='499' (0.001s)
    [103] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='510' (0s)
    [104] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='538' (0.001s)
    [105] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='544' (0s)
    [106] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='558' (0.001s)
    [107] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='559' (0.001s)
    [108] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='560' (0.001s)
    [109] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='567' (0s)
    [110] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='570' (0s)
    [111] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM phbuss_pictures WHERE pid='571' (0s)
)

==========================
GET :
------------------
Array
(
    [cat] => 3
)

==========================
POST :
------------------
Array
(
)

==========================
VERSION INFO :
------------------
PHP version: 5.2.6 - OK
------------------
mySQL version: 5.0.32-Debian_7etch6-log
------------------
Coppermine version: 1.4.19(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.34 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support: 1
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XPM Support: 1
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 1
Client API version 5.0.32
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | On | On
safe_mode_exec_dir | /surely/you/must/be/joking | /surely/you/must/be/joking
safe_mode_gid | Off | Off
safe_mode_include_dir | /usr/lib/php5 | /usr/lib/php5
safe_mode_exec_dir | /surely/you/must/be/joking | /surely/you/must/be/joking
sql.safe_mode | Off | Off
disable_functions | disk_total_space, diskfreespace | disk_total_space, diskfreespace
file_uploads | On | On
include_path | .: | .:
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | me@localhost.com | me@localhost.com
sendmail_path | /usr/sbin/b1sendmail -t -i | /usr/sbin/b1sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 12M | 12M
post_max_size | 12M | 12M
==========================
Page generated in 0.311 seconds - 112 queries in 0.067 seconds - Album set : AND aid IN (66,67,68,69,70,71,72,91,92,93,94,95,96,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,55,87,57,58,59,60,61,62,63,64,65,73,74,75,76,77,78,79,80,81,82,83,84,85,86,88,89,90,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113) ; Meta set: AND aid IN (55,87,57,58,59,60,61,62,63,64,65,73,74,75,76,77,78,79,80,81,82,83,84,85,86,88,89,90,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,66,67,68,69,70,71,72,91,92,93,94,95,96) ;
Logged

Nibbler

  • Guest
Re: Sort albums with swedish letters
« Reply #19 on: September 16, 2008, 08:11:32 pm »

Did you modify index.php? If so, upload a clean copy.
Logged
Pages: [1] 2   Go Up
 

Page created in 0.309 seconds with 19 queries.