DMSGuestbook FAQ for DMSGuestbook until version 1.5 (deprecated)
1.) Why i don't see my guestbook on my page?
Have you download the Exec-PHP? Exec-PHP (http://bluesome.net/post/2005/08/18/50/)
Have you set <?php DMSGuestBook(); ?> on your page?
Have you set the right page id?
Is wp_dmsguestbook on your wordpress database exist?
Are DMSGuestbook_xxxxx entries in the table wp_options on your wordpress database exist?
2.) When i save my page with this code <?php DMSGuestBook(); ?>, a blank char is set inside <? and the code doesn't run.
Disable "WordPress should correct invalidly nested XHTML automatically" under "Options -> Writing"
3.) When i select the DMSGuestbook in the plugins section of Wordpress, there is not create a DMSGuestbook database. Whats happen?
If you have a mySQL version lower than 4.1 you must reinstall the DMSGuestbook. Go to DMSGuestbook option and reinstall the guestbook table with the option "if you use mySQL 4.0.xx or lower"
4.) When i select the DMSGuestbook in the plugins section of Wordpress, there is not create DMSGuestbook options in the wp_options table. What can i do?
Try to reinstall this in the DMSGuestbook option page
5.) I want to create DMSGuestbook options manually, what is the correct sql statement?
Be sure the option name have the correct prefix.
Wordpress 2.3.1 and above
INSERT INTO `wp_options` (`option_id`, `blog_id`, `option_name`, `option_value`, `autoload`) VALUES
('', 0, 'DMSGuestbook_step', '10', 'yes'),
('', 0, 'DMSGuestbook_page_id', '', 'yes'),
('', 0, 'DMSGuestbook_width', '100', 'yes'),
('', 0, 'DMSGuestbook_width2', '35', 'yes'),
('', 0, 'DMSGuestbook_position', '0', 'yes'),
('', 0, 'DMSGuestbook_hairlinecolor', 'EEEEEE', 'yes'),
('', 0, 'DMSGuestbook_bordercolor1', 'AAAAAA', 'yes'),
('', 0, 'DMSGuestbook_bordercolor2', 'DEDEDE', 'yes'),
('', 0, 'DMSGuestbook_bordercolor3', '000000', 'yes'),
('', 0, 'DMSGuestbook_fontcolor1', '000000', 'yes'),
('', 0, 'DMSGuestbook_forwardarrowchar', '>', 'yes'),
('', 0, 'DMSGuestbook_backwardarrowchar', '<', 'yes'),
('', 0, 'DMSGuestbook_arrowsize', '20', 'yes'),
('', 0, 'DMSGuestbook_require_email', '0', 'yes'),
('', 0, 'DMSGuestbook_require_url', '0', 'yes'),
('', 0, 'DMSGuestbook_require_antispam', '1', 'yes'),
('', 0, 'DMSGuestbook_show_ip', '0', 'yes'),
('', 0, 'DMSGuestbook_show_url', '1', 'yes'),
('', 0, 'DMSGuestbook_show_email', '1', 'yes'),
('', 0, 'DMSGuestbook_captcha_color', '000000', 'yes'),
('', 0, 'DMSGuestbook_formpos', 'top', 'yes'),
('', 0, 'DMSGuestbook_formposlink', '', 'yes'),
('', 0, 'DMSGuestbook_dateformat', '%a, %e %B %Y %H:%M:%S %z', 'yes'),
('', 0, 'DMSGuestbook_setlocale', 'en_EN', 'yes'),
('', 0, 'DMSGuestbook_offset', '0', 'yes'),
('', 0, 'DMSGuestbook_name', 'Name', 'yes'),
('', 0, 'DMSGuestbook_email', 'Email', 'yes'),
('', 0, 'DMSGuestbook_url', 'Website', 'yes'),
('', 0, 'DMSGuestbook_message', 'Text', 'yes'),
('', 0, 'DMSGuestbook_antispam', '<b>Antispam measures</b><br />Please insert the letter and number combination into the text field before submitting the guestbook entry.', 'yes'),
('', 0, 'DMSGuestbook_require', 'mandatory', 'yes'),
('', 0, 'DMSGuestbook_submit', 'Inscribe', 'yes'),
('', 0, 'DMSGuestbook_name_error', 'Name is too short!', 'yes'),
('', 0, 'DMSGuestbook_email_error', 'Invalid email adress!', 'yes'),
('', 0, 'DMSGuestbook_url_error', 'Invalid url adress!', 'yes'),
('', 0, 'DMSGuestbook_message_error', 'Text is too short!', 'yes'),
('', 0, 'DMSGuestbook_antispam_error', 'Wrong letter-figure combination!', 'yes'),
('', 0, 'DMSGuestbook_success', 'Thank you for this guestbook entry!', 'yes'),
('', 0, 'DMSGuestbook_send_mail', '0', 'yes'),
('', 0, 'DMSGuestbook_mail_adress', 'name@example.com', 'yes')
Wordpress 2.3.0 an lower
INSERT INTO `wp_options` (`option_id`, `blog_id`, `option_name`, `option_can_override`, `option_type`, `option_value`, `option_width`, `option_height`, `option_description`, `option_admin_level`, `autoload`) VALUES
('', 0, 'DMSGuestbook_step', 'Y', 1, '10', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_page_id', 'Y', 1, '', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_width', 'Y', 1, '100', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_width2', 'Y', 1, '35', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_position', 'Y', 1, '0', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_hairlinecolor', 'Y', 1, 'EEEEEE', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_bordercolor1', 'Y', 1, 'AAAAAA', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_bordercolor2', 'Y', 1, 'DEDEDE', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_bordercolor3', 'Y', 1, '000000', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_fontcolor1', 'Y', 1, '000000', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_forwardarrowchar', 'Y', 1, '>', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_backwardarrowchar', 'Y', 1, '<', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_arrowsize', 'Y', 1, '20', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_require_email', 'Y', 1, '0', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_require_url', 'Y', 1, '0', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_require_antispam', 'Y', 1, '1', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_show_ip', 'Y', 1, '0', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_show_url', 'Y', 1, '1', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_show_email', 'Y', 1, '1', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_captcha_color', 'Y', 1, '000000', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_formpos', 'Y', 1, 'top', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_formposlink', 'Y', 1, '', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_dateformat', 'Y', 1, '%a, %e %B %Y %H:%M:%S %z', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_setlocale', 'Y', 1, 'en_EN', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_offset', 'Y', 1, '0', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_name', 'Y', 1, 'Name', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_email', 'Y', 1, 'Email', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_url', 'Y', 1, 'Website', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_message', 'Y', 1, 'Text', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_antispam', 'Y', 1, '<b>Antispam measures</b><br />Please insert the letter and number combination into the text field before submitting the guestbook entry.', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_require', 'Y', 1, 'mandatory', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_submit', 'Y', 1, 'Inscribe', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_name_error', 'Y', 1, 'Name is too short!', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_email_error', 'Y', 1, 'Invalid email adress!', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_url_error', 'Y', 1, 'Invalid url adress!', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_message_error', 'Y', 1, 'Text is too short!', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_antispam_error', 'Y', 1, 'Wrong letter-figure combination!', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_success', 'Y', 1, 'Thank you for this guestbook entry!', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_send_mail', 'Y', 1, '0', 20, 8, '', 1, 'yes'),
('', 0, 'DMSGuestbook_mail_adress', 'Y', 1, 'name@example.com', 20, 8, '', 1, 'yes')
6.) I want to create wp_dmsguestbook manually, what is the correct sql statement?
Be sure the dmsguestbook name have the correct prefix.
mySQL 4.1 and above:
CREATE TABLE wp_dmsguestbook (id mediumint(9) NOT NULL AUTO_INCREMENT,
name varchar(50) DEFAULT '' NOT NULL,
email varchar(50) DEFAULT '' NOT NULL,
url varchar(50) DEFAULT '' NOT NULL,
date int(10) NOT NULL,
ip varchar(15) DEFAULT '' NOT NULL,
message longtext NOT NULL,
UNIQUE KEY id (id)
)DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
mySQL 4.0 and lower:
CREATE TABLE wp_dmsguestbook (id mediumint(9) NOT NULL AUTO_INCREMENT,
name varchar(50) DEFAULT '' NOT NULL,
email varchar(50) DEFAULT '' NOT NULL,
url varchar(50) DEFAULT '' NOT NULL,
date int(10) NOT NULL,
ip varchar(15) DEFAULT '' NOT NULL,
message longtext NOT NULL,
UNIQUE KEY id (id))
7.) It's doesn't save correct chars like ü, ä, ö ... on my DMSGuestbook option page, why?
The database collation should be display a language like utf8_unicode_ci, latin1, ISO-8859-1 or other were support special chars.
UTF-8 is the best way if the mySQL version is higher than 4.1, otherwise use latin1, ISO-8859-1 or other were support special chars.
8.) I've checked the permission of xfiles.ttf and captcha.png. Further i don't see the antispam captcha image.
You must have to installed GD libary 2.0.1 or above and FreeType support must be enabled.
Otherwise you can use the mathematic figures antispam captcha system.
9.) My language setting is set to en_EN and the date is flipping every page reload between english and french. What can i do?
Leave blank the setlocate input field.
Where can i reach you if i advice need about DMSGuestbook?
I'm attainable under: dmsguestbook (at) danielschurter (dot) net
Daniel Schurter, switzerland
DanielSchurter.net