MyBB Community Forums

1. Has been implemented for the next version already.
2. Is planned.
3. I've not used that plugin, not sure how it works.

(2015-07-08, 03:32 PM)Euan T Wrote: [ -> ]1. Has been implemented for the next version already.
2. Is planned.
3. I've not used that plugin, not sure how it works.

Awesome, thanks! And thanks for your plugin, keep up the good work, .

i wanna make a suggestion

a. when u read an alert- it should dispensary from the wall or tagged as read
b. on the alert bar on the wall , you can delete per alert !!

So I haven't really had time to look into why I still can't get this plugin to work on my forum after the last time I tried getting help, but now I get this error:

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'mybb923.mybb_alert_types' doesn't exist
Query:
SELECT * FROM mybb_alert_types;

Any reason why? I'm just really tired of this plugin not working... I wish I could just get it fixed and up and running again. Lol.

^ it is clear that MyAlerts database table was not created. which type of database you are using ?

Yeah, is this a fresh install? The alert_types table doesn't exist for some reason, but it's created on install (or upgrade).

Well I can't really uninstall it from the Plugins page in the ACP since it's giving me that error. Is there a way to uninstall it so that I can re-install it so that it can re-create the database tables?

The easiest thing to do would be to create the tables via phpMyAdmin. Use the following SQL:

CREATE TABLE IF NOT EXISTS `mybb_alert_types` (
  `id`                   INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `code`                 VARCHAR(100)     NOT NULL DEFAULT '',
  `enabled`              TINYINT(4)       NOT NULL DEFAULT '1',
  `can_be_user_disabled` TINYINT(4)       NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_code` (`code`)
)
  ENGINE = InnoDB
  DEFAULT CHARSET = utf8;

CREATE TABLE IF NOT EXISTS `mybb_alerts` (
  `id`            INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uid`           INT(10) UNSIGNED NOT NULL,
  `unread`        TINYINT(4)       NOT NULL DEFAULT '1',
  `dateline`      DATETIME         NOT NULL,
  `alert_type_id` INT(10) UNSIGNED NOT NULL,
  `object_id`     INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `from_user_id`  INT(10) UNSIGNED          DEFAULT NULL,
  `forced`        INT(1)           NOT NULL DEFAULT '0',
  `extra_details` TEXT,
  PRIMARY KEY (`id`)
)
  ENGINE = MyISAM
  DEFAULT CHARSET = utf8;

Hey Euan… you do great work bro. One of my favorite authors for mods… I'm trying to figure out how to download the pluginlibrary… I can't seem to find the download and github confuses me. Can you help me please?

^ https://github.com/frostschutz/MyBB-PluginLibrary/
you can click on download zip link available at right side of the page (image) [plugin library direct link]