Author Topic: Guestbook broken  (Read 6288 times)

Offline RonR

  • Posts: 43
Guestbook broken
« 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!

Offline dbs

  • Betatester
  • **
  • Posts: 8666
  • Gender: Male
  • tioz4ever
    • WebsiteBaker - jQuery-Plugins - Module - Droplets - Tests
Re: Guestbook broken
« Reply #1 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).

Offline ruebenwurzel

  • Betatester
  • **
  • Posts: 8412
  • Gender: Male
  • Keep on Rockin
    • Familie Gallas Online
Re: Guestbook broken
« Reply #2 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

Offline ruebenwurzel

  • Betatester
  • **
  • Posts: 8412
  • Gender: Male
  • Keep on Rockin
    • Familie Gallas Online
Re: Guestbook broken
« Reply #3 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

Offline dbs

  • Betatester
  • **
  • Posts: 8666
  • Gender: Male
  • tioz4ever
    • WebsiteBaker - jQuery-Plugins - Module - Droplets - Tests
Re: Guestbook broken
« Reply #4 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"

Offline RonR

  • Posts: 43
Re: Guestbook broken
« Reply #5 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...

Offline dbs

  • Betatester
  • **
  • Posts: 8666
  • Gender: Male
  • tioz4ever
    • WebsiteBaker - jQuery-Plugins - Module - Droplets - Tests
Re: Guestbook broken
« Reply #6 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.

Offline RonR

  • Posts: 43
Re: Guestbook broken
« Reply #7 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

Offline dbs

  • Betatester
  • **
  • Posts: 8666
  • Gender: Male
  • tioz4ever
    • WebsiteBaker - jQuery-Plugins - Module - Droplets - Tests
Re: Guestbook broken
« Reply #8 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  :)

Offline RonR

  • Posts: 43
Re: Guestbook broken
« Reply #9 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.

Offline RonR

  • Posts: 43
Re: Guestbook broken
« Reply #10 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):

Online hgs

  • Betatester
  • **
  • Posts: 1436
    • EFG MG
Re: Guestbook broken
« Reply #11 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
« Last Edit: January 06, 2021, 01:36:53 PM by hgs »
LG Harald

"Fange nie an, aufzuhören - höre nie auf, anzufangen." Marcus Tullius Cicero (106-43 v.Chr.)

Offline RonR

  • Posts: 43
Re: Guestbook broken
« Reply #12 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!!!

 

postern-length