Cotonti / Open Source PHP Content Management FrameworkContent Management Framework

Forums / Cotonti / Extensions / [Release] Notifier for Cotonti

<<<12

Subscribe to a topic by email or PM

foxhound
#16 2012-05-19 21:24

Tried to use this with 0.6.22 and it prevents a user from editing his profile. You recieve the following error: Fatal error : SQL error : Unknown column 'user_autosubscribe' in 'field list'
So, you can not edit your own profile. Disabling the notifier fixes that.

I know you are not going to fix it, I just wanted to leave this info for anybody who recieves the same error.

tensh
#17 2012-05-20 15:08

you most probably forgot to execute some sql in your database...?

 

CREATE TABLE sed_notifier (
  not_id int(11) NOT NULL auto_increment,
  not_userid int(11) default NULL,
  not_state tinyint(1) NOT NULL default '0',
  not_bypm tinyint(1) NOT NULL default '0',
  not_date int(11) NOT NULL default '0',
  not_notified int(11) NOT NULL default '0',
  not_item varchar(16) NOT NULL default '',
  not_desc varchar(128) NOT NULL default '',
  PRIMARY KEY (not_id)
) TYPE=MyISAM;

INSERT INTO sed_stats (stat_name, stat_value) VALUES ('notifier_pm', '0');
INSERT INTO sed_stats (stat_name, stat_value) VALUES ('notifier_em', '0');

ALTER TABLE sed_users ADD user_autosubscribe VARCHAR(5) NOT NULL default '' AFTER user_pmnotify;
foxhound
#18 2012-05-20 21:39

Nope, SQL added and checked.

tensh
#19 2012-05-23 18:56

Especially the last line "ALTER TABLE"? Your error says about last line.

I'm using this plugin and it works fine. Maybe try to disable other plugins hooking to user profile. Like user's wall or something.

Added 1 minute later:

maybe you have a custom table prefix? Dunno.

 

foxhound
#20 2012-05-24 10:49
#34398 tensh:

Especially the last line "ALTER TABLE"? Your error says about last line.

I'm using this plugin and it works fine. Maybe try to disable other plugins hooking to user profile. Like user's wall or something.

Added 1 minute later:

maybe you have a custom table prefix? Dunno.

 

No custom prefix. Its a standard, clean genoa 0.6.22 install. However I did add the userwall, I will disable that and see if that causes the issue with the notifier, didnt think they would conflict cause I use them together on another site (0.6.19).

 

 

aro747
#21 2016-08-01 05:10

Hi all,

Sorry to bring up this really old topic, but I'm using this on a Seditio install and when subscribed by PM, it does not update the PM count.  It always says No Private Messages.  Any ideas.  Thanks!

<<<12