Album Name Empty

[testomat]

Hi,
i have the stramm_mod1_4_10_brigde_1 pack installed.
When i create an album in a category and name it, it says after apply modifications 'Creating Album " ' without the name i typed in.
But the album is created without a name. When i go to the properties and gives a name to album title, it works(the album is named).
Anybody an idea ?

[testomat]

Now i got an another Problem.
When i click on a picture to view i got following error.


here was an error while processing a database query.

While executing query "SELECT c.msg_id, c.msg_author, c.msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, c.author_id, c.author_md5_id, c.msg_raw_ip, c.msg_hdr_ip, c.pid, u. AS avatar_url FROM cpg149_comments AS c LEFT JOIN `db39411x440806`.e107_user AS u ON c.author_id=u.user_id WHERE pid='5' ORDER BY c.msg_id ASC" 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 'AS avatar_url FROM cpg149_comments AS c LEFT JOIN `db39411x44080

..../functions.inc.php - Line: 248


Maybe this problem relies to the problem before ?

[Stramm]

The modpack doesn't support all bridge files the orig coppermine comes with. For supported bridges are phpbb, smf and punbb. I've posted somewhere a howto modify bridge files to work together with the modpack.

From the modpack announcement thread
http://forum.coppermine-gallery.net/index.php?topic=28367.0

For now I've added bridge files for PhpBB 2.0.18, 19 and SMF 1.0x

[testomat]

Hi Stramm, will be in the future a mod that supports E107 ?
Is it now possible to downgrade the mod pack ? I know, i used a mod pack from you,i think 1.49, that works with E107.

[Stramm]

To fully support all bridge files I'd need to have all these programs installed and I'd need to test all with every modpack feature. For that I do not have enough time. Make the bridge files compatible eith the modpack isn't that hard. Maintaining the bridges is more effort. That's the reason why I hesitate to add more.

E107 never was supported. Of course it may have worked, but not all features, especially not the buddy list and avatars. Relating pages (buddy manage, avatar manage etc.) will spit out errors. If you do not add avatar support you usually will get an error already on the index

PS: that's for the SQL error message you posted.

[testomat]

Hi Stramm,
ich schreibe mal auf Deutsch ;-) Verstehe das es ein Riesen Aufwand für dich/euch bedeutet alle CMS Systeme zu supporten.
Da ich keine Avatars und Buddy Liste nutze, gibt es nicht eine Möglichkeit diese komplett abzuschalten ?
Das blöde ist, der hängt immer bei dem SQL Statement. In welcher Datei müsste ich schauen und so modifizieren, das Avatar und Buddylist nicht benutzt werden.

Gruß

[testomat]

Ok, i fixed it by my own.
Hope that is correct, but it worked.

In themes.inc.php i replaced
$result = $cpg_udb->get_comments($pid, $comment_sort_order);

to
$result = cpg_db_query("SELECT msg_id, msg_author, msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, author_id, author_md5_id, msg_raw_ip, msg_hdr_ip, pid FROM {$CONFIG['TABLE_COMMENTS']} WHERE pid='$pid' ORDER BY msg_id $comment_sort_order");

then....

if ($CONFIG['enable_avatar']){
           ($row['avatar_url'] != "") ? $avatar_url= "<img src='".AVATAR_PATH.$row["avatar_url"]."' class='image' style='float: left; margin-right: 5px;' alt='' />" : $avatar_url = '';
      }
      else $avatar_url="";

in that
if ($CONFIG['enable_avatar']){
         $result2 = $cpg_udb->get_avatar($row['author_id']);
         $avatar_url= preg_replace('/\/\//','/',AVATAR_PATH.$result2["avatar_url"]);
           ($result2['avatar_url'] != "") ? $avatar_url= "<img src='".$avatar_url."' class='image' style='float: left; margin-right: 5px;' alt='' />" : $avatar_url = '';
      }
      else $avatar_url="";

[Joachim Müller]

ich schreibe mal auf Deutsch ;-)

Only English is allowed on the international board. German is only allowed on the German sub board!

[Stramm]

thanks for sharing your fix