No Alert Settings. Can't register (mysql error)

[TessiXakaT6]

Hey i have lot of issues with the MyAlerts plugins and i don't know why.

The first one is that when I go into the notification settings there's absolutely nothing ;

then when I go into my PCA and I go into "Alert Types" there's nothing :

and my third problem is that when I want to create a new user via ACP I get a MySQL error :

Thank you for those who would like to help me ^^

[euantorano]

It looks like the plugin installation didn't create the alert types, or add the required column to the users table for some reason. I would try uninstalling MyAlerts and try installing it again. If that doesn't work, you can try running the queries manually, just let me know and I'll get them for you.

[TessiXakaT6]

It looks like the plugin installation didn't create the alert types, or add the required column to the users table for some reason. I would try uninstalling MyAlerts and try installing it again. If that doesn't work, you can try running the queries manually, just let me know and I'll get them for you.

I uninstalled the plugin 3 times to reinstall it because I thought I was the one who was bad, but it always does the same thing to me.

I just modified some little things like HTML to apply the design on my forum but otherwise I didn't touch anything.

I did add the 2 tables in my DB.

[TessiXakaT6]

I don't have anything in my SQL tables

[euantorano]

Hi,

I'm afraid I have no idea why the install wouldn't work, but you can try running these queries in phpMyAdmin:

INSERT INTO mybb_alert_types (code, enabled, can_be_user_disabled) VALUES
('rep', 1, 1),
('pm', 1, 1),
('buddylist', 1, 1),
('quoted', 1, 1),
('post_threadauthor', 1, 1),
('subscribed_thread', 1, 1),
('rated_threadauthor', 1, 1),
('voted_threadauthor', 1, 1);

ALTER TABLE mybb_users ADD myalerts_disabled_alert_types TEXT;

[TessiXakaT6]

Hi,

I'm afraid I have no idea why the install wouldn't work, but you can try running these queries in phpMyAdmin:

INSERT INTO mybb_alert_types (code, enabled, can_be_user_disabled) VALUES
('rep', 1, 1),
('pm', 1, 1),
('buddylist', 1, 1),
('quoted', 1, 1),
('post_threadauthor', 1, 1),
('subscribed_thread', 1, 1),
('rated_threadauthor', 1, 1),
('voted_threadauthor', 1, 1);

ALTER TABLE mybb_users ADD myalerts_disabled_alert_types TEXT;

Thanks you sir, with sql requests worked.
I don't know why the requests are not executed I had to do it by hand and then rebuild my database with phpmyadmin and then refresh my browser and it's ok.
Thanks for your help and your plugins which is incredible and very useful ;)