The Guestbook plugin has been released

[Simon Gooffin]

Greetings all,

I'm happy to announce our new plugin release - Guestbook is ready. So now your site can have a good AJAX based guestbook..

You can download it from our downloads area.

Let us know if you have any questions.

[Simon Gooffin]

I have just found a strange thing. Right after installation I was unable to post in guestbook. I went to admin panel and checked Miscellaneous configuration. There is a separate section for Guestbook. I just clicked Save button and then this plugin started to work fine.

just FYI.. this should be checked by a tech department

[Greg]

Will this be updated to work on the other templates besides the "Default" template?

[Simon Gooffin]

Yes. It will be updated. But this is not a problem. You can simply copy files from Default directory to your template and it should work :)

[Greg]

I did do that Simon but it didn't work. I got an error message.
I'll try it again tomorrow (fresh brain) and see what happens.

Thanks :)

[Simon Gooffin]

Could you please inform what template you use? Dave told me it should work under all templates

[Greg]

This is the error I'm getting. (doesn't seem to matter what template)

Error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation 'if'

SELECT t1.*, IF (t1.`account_id` > 0, t2.`username`, t1.`author`) author FROM `v2202_guestbook` t1 LEFT JOIN `v2202_accounts` t2 ON t1.`account_id` = t2.`id` WHERE t1.`status` = 'active' ORDER BY t1.`date` DESC LIMIT 0, 20

Did I install it incorrectly?
This really isn't that important right now, but it's driving me %)

[Dave Baker]

Hi Greg,
Most likely you install it correctly :) . There's a problem with character encoding of the tables.
Please try the following solution:
Open Admin Panel » Manage Database » SQL Management and execute this query:

ALTER TABLE `v2202_guestbook` CHARACTER SET utf8

Please let me know results.

[Greg]

Hi Greg,
Most likely you install it correctly :) . There's a problem with character encoding of the tables.
Please try the following solution:
Open Admin Panel » Manage Database » SQL Management and execute this query:

ALTER TABLE `v2202_guestbook` CHARACTER SET utf8

Please let me know results.
No change Dave. The error is still there.
It would be nice if another member would install it and report if they get this error. :)

[majnoon]

i have just installed and tested this plugin. As in Same as Simon First time once installed was not able to post but once went to to config and saved worked fine. so the plugin works

[Greg]

Thanks majnoon

I did do the config. part but the thing is I can't even get to the guest book page itself. When I click on the link in the menu, that's when I get that error message.

[Dave Baker]

Greg, do you get the same error in your Admin Panel » Manage Guestbook section and front end » guestbook.php?

Try now to execute these queries:

ALTER TABLE v2202_guestbook MODIFY `author` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE v2202_accounts MODIFY `username` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci;

if you get an error (it depends on version of MySQL), please try to execute these queries:

ALTER TABLE v2202_guestbook MODIFY `author` VARCHAR(100) CHARACTER SET utf8;
ALTER TABLE v2202_accounts MODIFY `username` VARCHAR(30) CHARACTER SET utf8;

[Greg]

Thanks Dave

I ran all those queries but still had the error.
After I ran those I got this:
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 '; ALTER TABLE v2202_accounts MODIFY `username` VARCHAR(30) CHAR

I had the problem in both Admin Panel and front end.
So I did a fresh install on another more recent local server I have and there weren't any problems.

The one I had problems with was:
ApacheFriends XAMPP (basic package) version 1.4.13

+ Apache 2.0.53
+ MySQL 4.1.11
+ PHP 5.0.4 + PHP 4.3.11 + PEAR

And the one it works on:
ApacheFriends XAMPP (basic package) version 1.5.5

+ Apache 2.2.3
+ MySQL 5.0.27
+ PHP 5.2.0 + PHP 4.4.4 + PEAR

I don't know if that is of any help.

But there is one thing. After you install the plugin it tells you what files to upload and where.

When you do that I think this one line is in error.
includes/classes/admin/esynGuestbook.php

Shouldn't it be:
includes/classes/esynGuestbook.php


Thanks :)

[Dave Baker]

Greg,
You are right, it should be "includes/classes/esynGuestbook.php" instead of includes/classes/admin/esynGuestbook.php ;)
After I ran those I got this:
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 '; ALTER TABLE v2202_accounts MODIFY `username` VARCHAR(30) CHAR
It's a bug of manage database section.(does not allow to execute several queries at once). Try to execute them separately.