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

Author Topic: Album Name Empty  (Read 6889 times)

0 Members and 1 Guest are viewing this topic.

testomat

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
Album Name Empty
« on: April 21, 2007, 03:25:57 pm »

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 ?

« Last Edit: April 24, 2007, 10:34:21 am by Stramm »
Logged

testomat

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
Re: Album Name Empty
« Reply #1 on: April 21, 2007, 04:29:55 pm »

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 ?
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Album Name Empty
« Reply #2 on: April 21, 2007, 07:14:24 pm »

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
Quote
For now I've added bridge files for PhpBB 2.0.18, 19 and SMF 1.0x

testomat

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
Re: Album Name Empty
« Reply #3 on: April 22, 2007, 06:16:49 pm »

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.

Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Album Name Empty
« Reply #4 on: April 22, 2007, 06:58:14 pm »

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

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
Re: Album Name Empty
« Reply #5 on: April 23, 2007, 09:16:17 pm »

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ß
Logged

testomat

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
Re: Album Name Empty
« Reply #6 on: April 23, 2007, 10:07:37 pm »

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="";


Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Album Name Empty
« Reply #7 on: April 24, 2007, 07:56:54 am »

ich schreibe mal auf Deutsch ;-)
Only English is allowed on the international board. German is only allowed on the German sub board!
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: Album Name Empty
« Reply #8 on: April 24, 2007, 10:33:41 am »

thanks for sharing your fix
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 19 queries.