Unable to delete logging entries

Phoca Guestbook - creating guestbooks in Joomla! CMS
gregazar
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 09 Apr 2018, 16:17

Unable to delete logging entries

Post by gregazar » 09 Apr 2018, 16:23

Phoca Guestbook has been working properly until 2 days ago. Starting 2 days ago I cannot delete logging entries and I cannot change the number of logging entries that are displayed. Clicking the delete button does nothing. I am running Phoca Guestbook version 3.0.7 and Joomla 3.8.6 with PHP 7.1

Any help would be appreciated.


gregazar
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 09 Apr 2018, 16:17

Re: Unable to delete logging entries

Post by gregazar » 11 Apr 2018, 17:08

The photo at the link below shows the issue.

https://www.dropbox.com/s/5rskn5ibs6o0f ... 2.jpg?dl=0

gregazar
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 09 Apr 2018, 16:17

Re: Unable to delete logging entries

Post by gregazar » 11 Apr 2018, 21:59

More on this issue. I found the following error.
https://www.dropbox.com/s/fnh53jnx0xxu0 ... 2.jpg?dl=0

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 40534
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Unable to delete logging entries

Post by Jan » 16 Apr 2018, 11:29

Hi, hmm, really hard to say, the items does not have any ID so in fact it should not exist in database. When you see your database directly (e.g. per phpMyAdmin) are you able to see this row?

Jan
If you find Phoca extensions useful, please support the project

gregazar
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 09 Apr 2018, 16:17

Re: Unable to delete logging entries

Post by gregazar » 16 Apr 2018, 19:23

Jan, Thank you for your assistance. I will make a donation to support your work.
Yes, the entry is visible in the database - Photo -> https://www.dropbox.com/s/dsrzk3mmm7o5w ... 4.jpg?dl=0
Also, here is an export from the database in CSV format on line 29 (476) -> https://www.dropbox.com/s/qh5y4bivo53iv ... g.csv?dl=0

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 40534
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Unable to delete logging entries

Post by Jan » 19 Apr 2018, 16:52

Hmm, the question is, why it does not display the ID in the list, because the ID is the key for successful deleting of the file, without ID cannot be deleted anything :idea:

I am testing now different settings but I cannot find any way to get listed a row without ID :idea:

Jan
If you find Phoca extensions useful, please support the project

gregazar
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 09 Apr 2018, 16:17

Re: Unable to delete logging entries

Post by gregazar » 19 Apr 2018, 19:25

Would you like access to my Joomla Admin center and PhpMyAdmin?

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 40534
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Unable to delete logging entries

Post by Jan » 22 Apr 2018, 14:43

Hi, I can take a look at it but not sure if I will be able to see something there :idea: See PM.

Jan
If you find Phoca extensions useful, please support the project

Post Reply