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

[Manard]

Hello Naguissa,

Thank you for your reply.

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

[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"



Maybe deleting them or replacing gfxsx with naguissa would remove this fatal error?

[Naguissa]

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"



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]

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"



Since these changes, the fatal errors have not come up

Thank for your very much for your help

[Naguissa]

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"



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]

About deleting it from phpbb_notification_types table, have you checked that naguissa.xxxxxx ones exist?

Yes, these two rows exist in the table

[c64persian]

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

[Naguissa]

Seems extension is not correctly installed. Do you have access to database?

yes

This will force execution of installation/migration script:

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

[c64persian]

yes

This will force execution of installation/migration script:

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

[Naguissa]

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".

[ssl]

Nice ext: viewtopic.php?p=15920171#p15920171

[c64persian]

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()

[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?

[Naguissa]

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.

[Janvitus]

Hi, this ext support only mysql db?