Notification not work and…

Support reply may delay for 3 weeks due to corona virus outbreak, please send us email to support@pickplugins.com
0
serenaboschetti
Apr 03, 2018 04:28 PM 1 Answers General
Member Since Apr 2018
Subscribed Subscribe Not subscribe
Flag(0)

hi.. notification dont work, and widget leadboard and top question dont work..... anymore.. solutions?

2 Subscribers
Submit Answer
Please login to submit answer.
1 Answers
Sort By:
Best Answer
0
PickPlugins
Apr 03, 2018
Flag(0)

Welcome to our forum.

Can you please explain what issue you are facing? we also using the QA plugin to this forum, notification is working fine.

Regards

serenaboschetti
- Apr 12, 2018 06:40 AM
Flag (0)
0

Hi, I solved it through a snippet. With the following code:

global $ wpdb;

$ charset_collate = $ wpdb-> get_charset_collate ();
$ table_notification = $ wpdb-> prefix .'qa_notification ';

$ sql = "CREATE TABLE". $ table_notification. "(
id int (100) NOT NULL AUTO_INCREMENT,
q_id int (100) NOT NULL,
a_id int (100) NOT NULL,
c_id int (100) NOT NULL,
user_id int (100) NOT NULL,
subscriber_id int (100) NOT NULL,
action VARCHAR (50) NOT NULL,
status VARCHAR (50) NOT NULL,
datetime DATETIME NOT NULL,

UNIQUE KEY id (id)
) $ charset_collate; ";
require_once (ABSPATH. 'wp-admin / includes / upgrade.php');
dbDelta ($ sql);

in particular, the line that has solved is:

require_once (ABSPATH. 'wp-admin / includes / upgrade.php');
dbDelta ($ sql);

Without it it did not work. Strangely enough, I had to force the database update for this table, even though it was non-existent.

The problem remains with the email plugin, it works for comments, it works for votes, but it does not work for the answers to the subscribed posts. In this case I can not debug. Any suggestions?

I hope I have been useful in the solution to improve the plugin

serenaboschetti
- Apr 11, 2018 11:39 PM
Flag (0)
0

Not work, the table not exist, and not recreate after reinstall, only this table have this problem. I want to recreate them manually if function exist, or query to make this

PickPlugins
- Apr 11, 2018 11:35 PM
Flag (0)
0

Thanks for your reply,

if you have access to php my admin , please find the table *_qa_notification and delete it if already created, and then re-install the plugin.

Regards

10+ more comments. Sign in to Reply
Replying as Submit

Please use https://imgur.com/upload to upload your screenshot and share url here.
You can't upload any files or attachment to our server directly for security reason, you can use 3rd party website and share file url here. here is the top file sharing website you can use.

Please login to see your tickets