WebsiteBaker Community Forum

WebsiteBaker Support (2.13.x) => Modules => Topic started by: RonR on January 05, 2021, 04:54:22 PM

Title: Guestbook broken
Post by: RonR on January 05, 2021, 04:54:22 PM

WB-Version2.13.0 r13
PHP7.3
Guestbook 2.8.71

When a visitor wants to add a reaction to the guestbook, there is a http500 error when clicking the submit button.
No entry is recorded, and no e-mail is being sent.

From the error-log, it looks like the page wants to open /pages/ directory,

Cannot serve directory ~/pages/ :no matching DirectoryIndex (index.html,index.htm,index.shtml,index.php,index.php5,index.php4,index.php3,index.phtml,index.cgi) found, and server-generated directory index forbidden by Options directive,

I noticed there is no guestbook module in the modules gallery anymore. Will there be a updated version? Or how to fix this one?

Happy new year!

Title: Re: Guestbook broken
Post by: dbs on January 05, 2021, 05:18:08 PM

Hi, can confirm.
Maybe the devs can have a look in next time.

Alternative:
Try a guestbook with module "feedback".
Works in upgraded 2.13.x (but don't know if it is installable).

Title: Re: Guestbook broken
Post by: ruebenwurzel on January 05, 2021, 05:55:51 PM

Hello,

I have running Guestbook 2.8.9 on WB 2.13.0 r25 without problems.

Changelog:

Code: [Select]

v2.8.9. Nov 01, 2018 (ruebenwurzel)
 - adapted Captcha Call to work with WB 2.12.x (thanks to luisehahne)

v2.8.8 Mar 18, 2017 (ruebenwurzel)
 - fix missing TABLE_PREFIX in upgrade.php (thanks to msfrog)
 - small fix in search.php
 
v2.8.7.2 Feb 18, 2016 (Jacobi22)
 - fix: repair version number to 2.8.7.2
 - fix: INSERT doesnt support MYSQL Strict Mode
 - remove empty inserts from install.php
 
v2.8.71 March 4, 2014 (Marian Zeyen)
 - adapted guestbook for working with IPv6 Adresses
   (changed Database 'ip_addr' to 'ip_addr_old'
        insert into Database 'ip_addr' as VARCHAR
        convert 'ip_addr_old' to plain format and store as VARCHAR in 'ip_addr'
        removed all INET_NTOA and INET_ATON from code => all IP adresses (IPv4 and IPv6) are stored plain)Have fun

Matthias

Title: Re: Guestbook broken
Post by: ruebenwurzel on January 05, 2021, 06:07:32 PM

Hello,

just tested, when i try to add a entry and hit the submit button i get a blank page and now entry is added. So there seems to exist a similar issue in version 2.8.9 too.

Matthias

Title: Re: Guestbook broken
Post by: dbs on January 05, 2021, 06:18:09 PM

A upgrade from v2.8.8 shows above the success button:
Error: Duplicate column name 'ip_addr_old'Error: Duplicate column name 'ip_addr'

In errorlog is:
PHP Fatal error:  Cannot declare class bin\wb, because the name is already in use in .../framework/class.wb.php on line 0"

Title: Re: Guestbook broken
Post by: RonR on January 05, 2021, 06:29:24 PM

confirmed: 2.89 is also giving an http500 error.

I hope for a fix: I have over 1800 entries by customers, and wish to continue the guestbook...

Title: Re: Guestbook broken
Post by: dbs on January 06, 2021, 11:02:42 AM

If guestbook is not fixable, try the feeback module.
You can overtaken the entries by a command like this in your phpmyadmin

Code: [Select]

INSERT INTO wb_mod_feedback (section_id, page_id,name,email,feedback,timestamp,comment)
SELECT section_id, page_id,name,email,message,posted_when,comment  FROM wb_mod_guestbook;
The prefix wb_ is also your prefix? Ok, otherwise change it in the command twice.
Now the section_id should be changed before execute the command.
- install feedback module
- add a section feedback to the same page (remember the section_id e.g. SecId: [330]  )
- change command:

Code: [Select]

INSERT INTO wb_mod_feedback (section_id, page_id,name,email,feedback,timestamp,comment)
SELECT 330, page_id,name,email,message,posted_when,comment  FROM wb_mod_guestbook;- execute command

Had tested this and it works for me. Without warranty.
It is only a try.

Title: Re: Guestbook broken
Post by: RonR on January 06, 2021, 11:31:03 AM

Thank you for your help, Frank!
I will save this option for when there will be no new version of Guestbook.

Will test it first on a testsite before putting it on the livesite.

Greetz,

Ronald

Title: Re: Guestbook broken
Post by: dbs on January 06, 2021, 11:42:02 AM

So, Dietmar has worked. It works, but without ASP (spam protection).
Maybe later with more time he can fix more.
Try the attached version 2.9.
 

Quote

Will test it first on a testsite before putting it on the livesite.

This should you do with all updates/upgrades  :)

Title: Re: Guestbook broken
Post by: RonR on January 06, 2021, 12:41:44 PM

Great, but...

Sorry to say that I still get a http500 on page:
~~/modules/guestbook/gstbk_save.php?sid=22&pid=22
(with and without disabled spam control)

I will try on a clean install later.

Title: Re: Guestbook broken
Post by: RonR on January 06, 2021, 01:13:34 PM

Clean install:

There was an uncatched exception
Call to undefined method frontend::getPageLink()
in line (55) of (/modules/guestbook/gstbk_save.php):

Title: Re: Guestbook broken
Post by: hgs on January 06, 2021, 01:31:43 PM

Is the current version r26 installed?
You can find it here
https://wiki.WebsiteBaker.org/doku.php/en/downloads

Addendum
Just here
https://aktuell.umojasingers.de/de/gaestebuch/
tested, It works

Title: Re: Guestbook broken
Post by: RonR on January 06, 2021, 01:43:10 PM

Oh boy,
Still had R13,
downloaded R26 and upgraded
and

 :-D :-D :-D :-D :-D it works!

Thanks everybody!!!