[3.2][3.3][RC] Thanks for posts (and optional Tapatalk integration)

A place for Extension Authors to post and receive feedback on Extensions still in development. No Extensions within this forum should be used within a live environment!
Anti-Spam Guide
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: Extensions Development rules

IMPORTANT FOR NEEDED EVENTS!!!
If you need an event for your extension please read this for the steps to follow to request the event(s)
Manard
Registered User
Posts: 19
Joined: Thu Jun 16, 2011 10:03 am

Re: [3.2][3.3][RC] Thanks for posts (and optional Tapatalk integration)

Post by Manard »

Hello Naguissa,

Thank you for your reply.

The following extensions are enabled in the administration panel and in the database
Image

Image
Manard
Registered User
Posts: 19
Joined: Thu Jun 16, 2011 10:03 am

Re: [3.2][3.3][RC] Thanks for posts (and optional Tapatalk integration)

Post by Manard »

I just disabled the extension, the fatal error keeps appearing

In the table "phpbb_user_notifications" there are 45 rows that refer to "gfksx.thanksforposts.notification.type.thanks"

Image

Maybe deleting them or replacing gfxsx with naguissa would remove this fatal error?
User avatar
Naguissa
Registered User
Posts: 502
Joined: Thu Mar 02, 2017 6:55 am
Location: Barcelona
Name: Naguissa

Re: [3.2][3.3][RC] Thanks for posts (and optional Tapatalk integration)

Post by Naguissa »

Manard wrote: Tue Jan 17, 2023 9:44 am I just disabled the extension, the fatal error keeps appearing

In the table "phpbb_user_notifications" there are 45 rows that refer to "gfksx.thanksforposts.notification.type.thanks"

Image

Maybe deleting them or replacing gfxsx with naguissa would remove this fatal error?
Seems something went wrong in migration. Try this:


Code: Select all

UPDATE phpbb_user_notifications SET notification_type_name = 'naguissa.thanksforposts.notification.type.thanks' WHERE  notification_type_name LIKE 'gfksx.thanksforposts.notification.type.thanks'
Manard
Registered User
Posts: 19
Joined: Thu Jun 16, 2011 10:03 am

Re: [3.2][3.3][RC] Thanks for posts (and optional Tapatalk integration)

Post by Manard »

I changed the name of the field which is different and just ran these two SQL queries in the table

Code: Select all

UPDATE phpbb_user_notifications SET item_type = 'naguissa.thanksforposts.notification.type.thanks' WHERE  item_type LIKE 'gfksx.thanksforposts.notification.type.thanks'
and

Code: Select all

UPDATE phpbb_user_notifications SET item_type = 'naguissa.thanksforposts.notification.type.thanks_remove' WHERE  item_type LIKE 'gfksx.thanksforposts.notification.type.thanks_remove'
I have also deleted these two rows in the table "phpbb_notification_types"

Image

Since these changes, the fatal errors have not come up

Thank for your very much for your help
User avatar
Naguissa
Registered User
Posts: 502
Joined: Thu Mar 02, 2017 6:55 am
Location: Barcelona
Name: Naguissa

Re: [3.2][3.3][RC] Thanks for posts (and optional Tapatalk integration)

Post by Naguissa »

Manard wrote: Tue Jan 17, 2023 10:56 am I changed the name of the field which is different and just ran these two SQL queries in the table

Code: Select all

UPDATE phpbb_user_notifications SET item_type = 'naguissa.thanksforposts.notification.type.thanks' WHERE  item_type LIKE 'gfksx.thanksforposts.notification.type.thanks'
and

Code: Select all

UPDATE phpbb_user_notifications SET item_type = 'naguissa.thanksforposts.notification.type.thanks_remove' WHERE  item_type LIKE 'gfksx.thanksforposts.notification.type.thanks_remove'
I have also deleted these two rows in the table "phpbb_notification_types"

Image

Since these changes, the fatal errors have not come up

Thank for your very much for your help


Oh, yes, I forgot the other one, nice catch!

About deleting it from phpbb_notification_types table, have you checked that naguissa.xxxxxx ones exist?
Manard
Registered User
Posts: 19
Joined: Thu Jun 16, 2011 10:03 am

Re: [3.2][3.3][RC] Thanks for posts (and optional Tapatalk integration)

Post by Manard »

About deleting it from phpbb_notification_types table, have you checked that naguissa.xxxxxx ones exist?
Yes, these two rows exist in the table

Image
User avatar
c64persian
Registered User
Posts: 87
Joined: Tue Sep 18, 2012 11:58 pm
Location: instagram:c64persian

Re: [3.2][3.3][RC] Thanks for posts (and optional Tapatalk integration)

Post by c64persian »

Naguissa wrote: Tue Jan 17, 2023 9:07 am
peyman974 wrote: Fri Jan 13, 2023 9:33 am like previous message created table and dont show this error message but in acp dont show setting of this extension! and extension dont work

SQL ERROR [ mysqli ]

Table 'forum_thanks' doesn't exist [1146]

SQL

SELECT MAX(tally) AS max_post_thanks FROM (SELECT post_id, COUNT(*) AS tally FROM forum_thanks GROUP BY post_id) t

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

Seems extension is not correctly installed. Do you have access to database?
yes
User avatar
Naguissa
Registered User
Posts: 502
Joined: Thu Mar 02, 2017 6:55 am
Location: Barcelona
Name: Naguissa

Re: [3.2][3.3][RC] Thanks for posts (and optional Tapatalk integration)

Post by Naguissa »

peyman974 wrote: Tue Jan 17, 2023 10:33 pm
Naguissa wrote: Tue Jan 17, 2023 9:07 am


Seems extension is not correctly installed. Do you have access to database?
yes
This will force execution of installation/migration script:
Naguissa wrote: Wed Feb 16, 2022 2:25 pm Seems any kind of weirdness with migration, not carrying old notifications.

Try, with latest version:

1) Disable extension
2) Execute this in database (SQL command):

Code: Select all

DELETE FROM phpbb_migrations where migration_name like '%naguissa%';
3) Re-enable extension
User avatar
c64persian
Registered User
Posts: 87
Joined: Tue Sep 18, 2012 11:58 pm
Location: instagram:c64persian

Re: [3.2][3.3][RC] Thanks for posts (and optional Tapatalk integration)

Post by c64persian »

Naguissa wrote: Wed Jan 18, 2023 6:37 am
peyman974 wrote: Tue Jan 17, 2023 10:33 pm

yes
This will force execution of installation/migration script:
Naguissa wrote: Wed Feb 16, 2022 2:25 pm Seems any kind of weirdness with migration, not carrying old notifications.

Try, with latest version:

1) Disable extension
2) Execute this in database (SQL command):

Code: Select all

DELETE FROM phpbb_migrations where migration_name like '%naguissa%';
3) Re-enable extension
Error

SQL query:

DELETE FROM phpbb_migrations where migration_name like '%naguissa%'

MySQL said: Documentation
#1146 - Table 'phpbb_migrations' doesn't exist
User avatar
Naguissa
Registered User
Posts: 502
Joined: Thu Mar 02, 2017 6:55 am
Location: Barcelona
Name: Naguissa

Re: [3.2][3.3][RC] Thanks for posts (and optional Tapatalk integration)

Post by Naguissa »

peyman974 wrote: Wed Jan 18, 2023 6:30 pm
Error

SQL query:

DELETE FROM phpbb_migrations where migration_name like '%naguissa%'

MySQL said: Documentation
#1146 - Table 'phpbb_migrations' doesn't exist
Your installations has a different prefix, correct SQL is:

Code: Select all

DELETE FROM forum_migrations where migration_name like '%naguissa%';

"forum" instead "phpbb".
User avatar
ssl
Registered User
Posts: 2019
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert

Re: [3.2][3.3][RC] Thanks for posts (and optional Tapatalk integration)

Post by ssl »

Sorry for my English ... I do my best! :anger_right:

:point_right_tone3: phpBB: 3.3.14 | PHP: 8.3.12
:point_right_tone4: [Kill spam on phpBB] - [Some French translation of extensions]
"Mistress, Mistress someone is bothering me in pm"
User avatar
c64persian
Registered User
Posts: 87
Joined: Tue Sep 18, 2012 11:58 pm
Location: instagram:c64persian

Re: [3.2][3.3][RC] Thanks for posts (and optional Tapatalk integration)

Post by c64persian »

Naguissa wrote: Wed Jan 18, 2023 6:58 pm
peyman974 wrote: Wed Jan 18, 2023 6:30 pm
Error

SQL query:

DELETE FROM phpbb_migrations where migration_name like '%naguissa%'

MySQL said: Documentation
#1146 - Table 'phpbb_migrations' doesn't exist
Your installations has a different prefix, correct SQL is:

Code: Select all

DELETE FROM forum_migrations where migration_name like '%naguissa%';

"forum" instead "phpbb".
sql query worked but after disable extension then enable extension forum show this message again:


SQL ERROR [ mysqli ]

Table 'forum_thanks' doesn't exist [1146]

SQL

SELECT MAX(tally) AS max_post_thanks FROM (SELECT post_id, COUNT(*) AS tally FROM forum_thanks GROUP BY post_id) t

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
User avatar
halil16
Registered User
Posts: 1445
Joined: Fri Jul 24, 2020 11:30 pm
Location: Turkiye
Name: Halil

Re: [3.2][3.3][RC] Thanks for posts (and optional Tapatalk integration)

Post by halil16 »

How about that request over there:
https://www.phpbb.com/customise/db/exte ... pic/241946

Frankly, I'm not interested in Tapatalk or average score indicators right now. I'm trying to make the likes simpler this way. can you help me?
Buy me a coffee ☕
Hire me for your phpBB board. 🚩
Introducing Mobile Upgrade! *Make your phpBB board like an app! 📱
O BeldeThatTowns*for sale*$1250 🛒
"The day we'll need ideas more than possessions, we'll find the secret to true wealth." - Peyami Safa /peˈjɑːmi saˈfɑː/
User avatar
Naguissa
Registered User
Posts: 502
Joined: Thu Mar 02, 2017 6:55 am
Location: Barcelona
Name: Naguissa

Re: [3.2][3.3][RC] Thanks for posts (and optional Tapatalk integration)

Post by Naguissa »

halil16 wrote: Sat Feb 18, 2023 3:59 pm How about that request over there:
https://www.phpbb.com/customise/db/exte ... pic/241946

Frankly, I'm not interested in Tapatalk or average score indicators right now. I'm trying to make the likes simpler this way. can you help me?
It's possible to add it, but it's a new feature. Just as code is now it's not possible to do so just changing config options.
User avatar
Janvitus
Registered User
Posts: 20
Joined: Mon Sep 30, 2019 12:04 pm

Re: [3.2][3.3][RC] Thanks for posts (and optional Tapatalk integration)

Post by Janvitus »

Hi, this ext support only mysql db?

Return to “Extensions in Development”