[cpg1.4.x]: Advanced Guestbook integrated with Coppermine

[bajabum]

I installed the mod and the admin area works perrfect, but when I try to access the guestbook, I get this:

MySQL Error : Connection Error
Error Number: 2002 Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

[Ludo]

What's your CPG root, and where did you extract guestbook files?
What page do you access guestbook from?
Did you edit /guestbook/admin/config.inc.php?

[bajabum]

Got it to work.
I was trying to access the index file in the /guestbook instead of the root/guestbook.php
I will think before posting next time.
Sorry for the wast of time.
It works great.....

Gracias

[Forty2]

Hi,
thanks for that great guestbook.
It works like a charme.
But I have 2 smaller issues with it.

1. German language:
The special characters of the German language are totally corretly shown within the guestbook (like ä,ö...)
But when I receive the notification email, the HTML translation is shown, not the transformed once. So ä is Ä
Any idea?
2. Added pictures:
I am able to add pictures and I am able to see them in the guestbook.
But clicking on them, the preview popup comes up, showing no picture at all.
Any idea?

And last one remaining questions.
The two computers in each guestbook post are blinking. Does that mean, that the guy is online?

Thx in advance.
Forty2

[Ludo]

Hi,
thanks for that great guestbook.
It works like a charme.

Thanks a lot

The special characters of the German language are totally corretly shown within the guestbook (like ä,ö...)
But when I receive the notification email, the HTML translation is shown, not the transformed once. So ä is Ä
Any idea?

Change encoding to UTF-8 in your email client.

I am able to add pictures and I am able to see them in the guestbook.
But clicking on them, the preview popup comes up, showing no picture at all.
Any idea?

Now it should be fixed, please download the updated archive attached to the first post and give me feedback. The only file changed is /guestbook/picture.php, you have only to replace this file in your installation with the updated one.

The two computers in each guestbook post are blinking. Does that mean, that the guy is online?

No, it doesn't

[Forty2]

Hi,
thank you for that fix within the picture.php.
Now it works perfect.
Forty2

Thanks a lot.
Change encoding to UTF-8 in your email client.
Now it should be fixed, please download the updated archive attached to the first post and give me feedback. The only file changed is /guestbook/picture.php, you have only to replace this file in your installation with the updated one.
No, it doesn't

[Ludo]

Released version 1.0.4, which includes fix discussed above and a minor fix to admin panel footer

[Forty2]

Released version 1.0.4, which includes fix discussed above and a minor fix to admin panel footer

Hi,
once more I have a question.
Directly after the installation of the guestbook everything worked fine.
But now, the email notification does not work any more.

I have the following settings:
send e-mail to webmaster (private messages)
send e-mail to webmaster
send e-mail to guest

All of them are marked.
Did I miss something?
Thx.
Forty2

[Ludo]

Do you mean that this email issue happened after upgrading to 1.0.4?
Anyway, I've just tried leaving a message in my guestbook and I regularly received notification via email

[Forty2]

Do you mean that this email issue happened after upgrading to 1.0.4?
Anyway, I've just tried leaving a message in my guestbook and I regularly received notification via email

Hi,
no I did not upgrade to 1.0.4 until now.
The email notification worked for some times, but now it does not anymore.

[Ludo]

The special characters of the German language are totally corretly shown within the guestbook (like ä,ö...)
But when I receive the notification email, the HTML translation is shown, not the transformed once. So ä is Ä
Any idea?

Change encoding to UTF-8 in your email client.

I reconsidered this issue as a bug, as it's possible to set email content-type and charset via PHP code, instead of yielding to client server setting.
Please try this mod:

OPEN
guestbook/lib/add.class.php

FIND (2 times)

Code Select Expand

From: $from_email\nX-Mailer: Advanced Guestbook 2");

BEFORE, ADD:

Code Select Expand

Content-Type: text/html; charset=utf-8\n

FIND

Code Select Expand

From: ".$this->db->VARS['admin_mail']."\nX-Mailer: Advanced Guestbook 2");

BEFORE, ADD:

Code Select Expand

Content-Type: text/html; charset=utf-8\n

SAVE AND CLOSE

If it works, I will release it in 1.0.5 version.

[hlabout]

Ludo,

I have a simular problem, as mentioned by Forty 2, on my coppermine gallery with the advanced gustebook.

Using coppermine 1.4.26 with advanced guestbook 1.0.3 on my gallery: www.haraldlabout.nl
When someone uses a 's like in foto's it shows up as 's so foto's transforms in foto's.
I know it has to do with the character set encoding.
My coppermine gallery is set to UTF-8.

I tried the above mentioned code, same result still 's when a 's is used.

I posted a question about this before, see http://forum.coppermine-gallery.net/index.php/topic,64646.msg321080.html#msg321080
I was told my whole database should be converted using the charset manager.
Never don this because I don't know how to do this.

Perhaps you have another tip for my correcting this problem.

Dispite this small problem I just love the guestbook and i have a perfect match with my gellery.
When the 's shows up I can always correct it using the administrator function.
 
Harald

[hlabout]

p.s. ref above post.

When I run the charsetmgr.php the first message is: Your site is already configured to use utf-8. You don't need this script and should leave this page.

[Ludo]

I notice that your guestbook page charset is set to iso-8859-1, almost surely this is the issue.
Check charset in your gallery lang file, please.

[hlabout]

Ludo,

Thanks for the reply.
How do I check this?
My settings in coppermine are UTF-8.

Harald

[Ludo]

Look for the variable $lang_charset in lang/dutch.php or whatever language you are using: it must be set to utf-8 too.

[hlabout]

Found this im my dutch lang file:

$lang_charset = 'utf-8';

Should I set this to iso-8859-1?

Again thanks for the reply.

Harald

[Ludo]

No, it's right, but then there must be something wrong with your template.html file, if charset in <head> section of your pages is set to iso-8859-1!
Please post it.

[hlabout]

Ludo,

Found: <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
Changed it in: <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
No result, still same behavior.

Harald

[Ludo]

Your pages' charset is still set to iso-8859-1, please post your actual template.html