|
Page 1 of 1
|
MajickDev 
Joined: August 2006
Posts: 7
Location:  Maine, U.S.A.
|
 Digest Error When Logging Out
Hello everyone!
I haven't been able to receive digests from my test icy. I have enabled digests in admin. I've created a couple of test users and setup their profiles to receive daily digests... Subscribed to forums, set digest options, etc. -- After making several posts over a week, I've only received 1 digest email and it displayed as html code. (Viewed it in Firefox, it was a blank digest - no topics or posts.)
Although I could live without digests, I find them very useful, especially for this site and I'd like to use them for daily employee emails of my company's internal communications. But my big problem is when I click Logout (admin) of my test icy, sometimes I get the following error and can't log back in without starting a new Firefox (or IE7) session.
Critical Error!
message_die() was called multiple times.
Error #1
You are not authorized to view this page.
Error #2
Unable to retrieve list of users wanting a digest
Line : 108
File : /MY_WEBSITE/mail_digests.php
SQL : SELECT s.user_id, u.username, u.user_email, u.user_lastvisit, u.user_lang, s.digest_type, s.format, s.show_text, s.show_mine, s.new_only, s.send_on_no_messages, s.send_hour, s.text_length FROM digest_subscriptions s, ip_users u WHERE s.user_id = u.user_id AND ((digest_type = 'DAY' AND send_hour = 2))
Please, contact the webmaster. Thank you.
Everything else appears to work perfectly
|
#1 Sat 14 Jul, 2007 09:18 |
|
Sponsors

|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
|
JHOSMAN 
Joined: March 2007
Posts: 205
Location:  Bogot
|
 Re: Digest Error When Logging Out
i'm update to IcyPhoenix Icy Phoenix 1.1.5.20 Beta 1 and there the problem!
Error general
Unable to retrieve list of subscribed forums
DEBUG MODE
SQL Error : 1146 Table 'kokforos_db.ip_digest_subscribed_forums' doesn't exist
SELECT s.user_id, u.username, u.user_email, u.user_lastvisit, u.user_lang, s.digest_type, s.format, s.show_text, s.show_mine, s.new_only, s.send_on_no_messages, s.send_hour, s.text_length FROM ip_digest_subscriptions s, ip_users u WHERE s.user_id = u.user_id AND ((digest_type = 'DAY' AND send_hour = 0))
Line : 225
File : mail_digests.php
____________ ? JHOSMAN - Webmaster
|
#2 Mon 24 Sep, 2007 06:45 |
|
robin cracker 
Joined: June 2007
Posts: 39
Location:
|
 Re: Digest Error When Logging Out
check the table
kokforos_db.ip_digest_subscribed_forums
if exist in your bd
|
#3 Mon 24 Sep, 2007 07:35 |
|
JHOSMAN 
Joined: March 2007
Posts: 205
Location:  Bogot
|
 Re: Digest Error When Logging Out
check the table
kokforos_db.ip_digest_subscribed_forums
if exist in your bd
The table kokforos_db.ip_digest_subscribed_forums are not exist....
To be able to give the structure me in SQL of this table?
____________ ? JHOSMAN - Webmaster
|
#4 Mon 24 Sep, 2007 13:03 |
|
Zuker 
Joined: August 2006
Posts: 2134
Location:  BA
|
 Re: Digest Error When Logging Out
JHOSMAN, your upgrade was wrong, try to run it again carefully
____________ ? Zuker - EDDB - LPM - Sharefields
|
#5 Mon 24 Sep, 2007 13:18 |
|
JHOSMAN 
Joined: March 2007
Posts: 205
Location:  Bogot
|
 Re: Digest Error When Logging Out
JHOSMAN, your upgrade was wrong, try to run it again carefully
 Im of new the Icy Upgrade and last coment
____________ ? JHOSMAN - Webmaster
|
#6 Mon 24 Sep, 2007 13:20 |
|
JHOSMAN 
Joined: March 2007
Posts: 205
Location:  Bogot
|
 Re: Digest Error When Logging Out
In the update are this problems
- # INSERT INTO ip_config (config_name, config_value) VALUES ('mg_log_actions', '0')
- +++ Error: Duplicate entry 'mg_log_actions' for key 1
-
- # INSERT INTO ip_config (config_name, config_value) VALUES ('cash_disable', 0)
- +++ Error: Duplicate entry 'cash_disable' for key 1
-
- # INSERT INTO ip_config (config_name, config_value) VALUES ('cash_display_after_posts', 1)
- +++ Error: Duplicate entry 'cash_display_after_posts' for key 1
-
- # INSERT INTO ip_config (config_name, config_value) VALUES ('cash_post_message', 'You earned %s for that post')
- +++ Error: Duplicate entry 'cash_post_message' for key 1
-
- # INSERT INTO ip_config (config_name, config_value) VALUES ('cash_disable_spam_num', 10)
- +++ Error: Duplicate entry 'cash_disable_spam_num' for key 1
-
- # INSERT INTO ip_config (config_name, config_value) VALUES ('cash_disable_spam_time', 24)
- +++ Error: Duplicate entry 'cash_disable_spam_time' for key 1
-
- # INSERT INTO ip_config (config_name, config_value) VALUES ('cash_disable_spam_message', 'You have exceeded the alloted amount of posts and will not earn anything for your post')
- +++ Error: Duplicate entry 'cash_disable_spam_message' for key 1
-
- # INSERT INTO ip_config (config_name, config_value) VALUES ('cash_installed', 'yes')
- +++ Error: Duplicate entry 'cash_installed' for key 1
-
- # INSERT INTO ip_config (config_name, config_value) VALUES ('cash_version', '2.2.3')
- +++ Error: Duplicate entry 'cash_version' for key 1
-
- # INSERT INTO ip_config (config_name, config_value) VALUES ('cash_adminbig', '0')
- +++ Error: Duplicate entry 'cash_adminbig' for key 1
-
- # INSERT INTO ip_config (config_name, config_value) VALUES ('cash_adminnavbar', '1')
- +++ Error: Duplicate entry 'cash_adminnavbar' for key 1
-
- # INSERT INTO ip_config (config_name, config_value) VALUES ('points_name', 'Points')
- +++ Error: Duplicate entry 'points_name' for key 1
-
- # CREATE TABLE `ip_cash` ( cash_id smallint(6) NOT NULL auto_increment, cash_order smallint(6) NOT NULL default '0', cash_settings smallint(4) NOT NULL default '3313', cash_dbfield varchar(64) NOT NULL default '', cash_name varchar(64) NOT NULL default 'GP', cash_default int(11) NOT NULL default '0', cash_decimals tinyint(2) NOT NULL default '0', cash_imageurl varchar(255) NOT NULL default '', cash_exchange int(11) NOT NULL default '1', cash_perpost int(11) NOT NULL default '25', cash_postbonus int(11) NOT NULL default '2', cash_perreply int(11) NOT NULL default '25', cash_maxearn int(11) NOT NULL default '75', cash_perpm int(11) NOT NULL default '0', cash_perchar int(11) NOT NULL default '20', cash_allowance tinyint(1) NOT NULL default '0', cash_allowanceamount int(11) NOT NULL default '0', cash_allowancetime tinyint(2) NOT NULL default '2', cash_allowancenext int(11) NOT NULL default '0', cash_forumlist varchar(255) NOT NULL default '', PRIMARY KEY (cash_id) )
- +++ Error: Table 'ip_cash' already exists
-
- # CREATE TABLE `ip_cash_events` ( event_name varchar(32) NOT NULL default '', event_data varchar(255) NOT NULL default '', PRIMARY KEY (event_name) )
- +++ Error: Table 'ip_cash_events' already exists
-
- # CREATE TABLE `ip_cash_exchange` ( ex_cash_id1 int(11) NOT NULL default '0', ex_cash_id2 int(11) NOT NULL default '0', ex_cash_enabled int(1) NOT NULL default '0', PRIMARY KEY (ex_cash_id1,ex_cash_id2) )
- +++ Error: Table 'ip_cash_exchange' already exists
-
- # CREATE TABLE `ip_cash_groups` ( group_id mediumint(6) NOT NULL default '0', group_type tinyint(2) NOT NULL default '0', cash_id smallint(6) NOT NULL default '0', cash_perpost int(11) NOT NULL default '0', cash_postbonus int(11) NOT NULL default '0', cash_perreply int(11) NOT NULL default '0', cash_perchar int(11) NOT NULL default '0', cash_maxearn int(11) NOT NULL default '0', cash_perpm int(11) NOT NULL default '0', cash_allowance tinyint(1) NOT NULL default '0', cash_allowanceamount int(11) NOT NULL default '0', cash_allowancetime tinyint(2) NOT NULL default '2', cash_allowancenext int(11) NOT NULL default '0', PRIMARY KEY (group_id,group_type,cash_id) )
- +++ Error: Table 'ip_cash_groups' already exists
-
- # CREATE TABLE `ip_cash_log` ( log_id int(11) NOT NULL auto_increment, log_time int(11) NOT NULL default '0', log_type smallint(6) NOT NULL default '0', log_action varchar(255) NOT NULL default '', log_text varchar(255) NOT NULL default '', PRIMARY KEY (log_id) )
- +++ Error: Table 'ip_cash_log' already exists
-
- # CREATE TABLE `ip_album_comment_watch` ( pic_id mediumint(8) UNSIGNED NOT NULL default '0', user_id mediumint(8) NOT NULL default '0', notify_status tinyint(1) NOT NULL default '0', KEY pic_id (pic_id), KEY user_id (user_id), KEY notify_status (notify_status) )
- +++ Error: Table 'ip_album_comment_watch' already exists
-
- # UPDATE `ip_users` SET user_color_group = '0'
- +++ Successfull
-
- # ALTER TABLE ip_groups ADD COLUMN group_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL AFTER group_single_user
- +++ Error: Duplicate column name 'group_rank'
-
- # ALTER TABLE ip_groups ADD COLUMN group_color varchar(50) DEFAULT '' NOT NULL AFTER group_rank
- +++ Error: Duplicate column name 'group_color'
-
- # ALTER TABLE ip_groups ADD COLUMN group_legend tinyint(1) UNSIGNED DEFAULT '0' NOT NULL AFTER group_color
- +++ Error: Duplicate column name 'group_legend'
-
- # INSERT INTO ip_config (config_name, config_value) VALUES ('active_users_color', '#224455')
- +++ Error: Duplicate entry 'active_users_color' for key 1
-
- # INSERT INTO ip_config (config_name, config_value) VALUES ('active_users_legend', '1')
- +++ Error: Duplicate entry 'active_users_legend' for key 1
-
- # INSERT INTO ip_config (config_name, config_value) VALUES ('bots_legend', '1')
- +++ Error: Duplicate entry 'bots_legend' for key 1
-
- # DROP TABLE `ip_color_groups`
- +++ Error: Unknown table 'ip_color_groups'
-
- # ALTER TABLE `ip_groups` DROP `group_color_group`
- +++ Error: Can't DROP 'group_color_group'; check that column/key exists
-
- # INSERT INTO `ip_config` (config_name, config_value) VALUES ('show_social_bookmarks', '0')
- +++ Error: Duplicate entry 'show_social_bookmarks' for key 1
-
- # UPDATE `ip_themes` SET td_class3 = 'row3'
- +++ Successfull
-
- # ALTER TABLE `ip_album_cat` ADD `cat_pics` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL AFTER `cat_wm`;
- +++ Error: Duplicate column name 'cat_pics'
-
- # ALTER TABLE `ip_users` DROP `user_session_topic`
- +++ Error: Can't DROP 'user_session_topic'; check that column/key exists
-
- # ALTER TABLE `ip_sessions` DROP `session_topic`
- +++ Error: Can't DROP 'session_topic'; check that column/key exists
-
- # ALTER TABLE `ip_users` CHANGE `user_session_page` `user_session_page` varchar(255) NOT NULL default ''
- +++ Successfull
-
- # ALTER TABLE `ip_sessions` CHANGE `session_page` `session_page` varchar(255) NOT NULL default ''
- +++ Successfull
-
- # CREATE TABLE `ip_cms_layout_special` ( `lsid` int(10) unsigned NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `filename` varchar(100) NOT NULL default '', `template` varchar(100) NOT NULL default '', `forum_wide` tinyint(1) NOT NULL default '0', `view` tinyint(1) NOT NULL default '0', `edit_auth` tinyint(1) NOT NULL default '5', `groups` tinytext NOT NULL, PRIMARY KEY (`lsid`) ) TYPE=MyISAM AUTO_INCREMENT=1
- +++ Error: Table 'ip_cms_layout_special' already exists
-
- # ALTER TABLE `ip_cms_layout` CHANGE `forum_wide` `forum_wide` tinyint(1) NOT NULL default '0'
- +++ Successfull
-
- # ALTER TABLE `ip_cms_blocks` CHANGE `layout` `layout` int(10) NOT NULL default '0'
- +++ Successfull
-
- # ALTER TABLE `ip_cms_blocks` ADD `layout_special` int(10) NOT NULL default '0' AFTER `layout`
- +++ Error: Duplicate column name 'layout_special'
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('1', 'forum', 'forum', 0, 0, '')
- +++ Error: Duplicate entry '1' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('2', 'viewf', 'viewforum', 0, 0, '')
- +++ Error: Duplicate entry '2' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('3', 'viewt', 'viewtopic', 0, 0, '')
- +++ Error: Duplicate entry '3' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('4', 'viewonline', 'viewonline', 0, 0, '')
- +++ Error: Duplicate entry '4' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('5', 'search', 'search', 0, 0, '')
- +++ Error: Duplicate entry '5' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('6', 'profile', 'profile', 0, 0, '')
- +++ Error: Duplicate entry '6' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('7', 'memberlist', 'memberlist', 0, 0, '')
- +++ Error: Duplicate entry '7' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('8', 'group_cp', 'groupcp', 0, 0, '')
- +++ Error: Duplicate entry '8' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('9', 'faq', 'faq', 0, 0, '')
- +++ Error: Duplicate entry '9' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('10', 'rules', 'rules', 0, 0, '')
- +++ Error: Duplicate entry '10' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('11', 'download', 'dload', 0, 0, '')
- +++ Error: Duplicate entry '11' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('12', 'album', 'album', 0, 0, '')
- +++ Error: Duplicate entry '12' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('13', 'links', 'links', 0, 0, '')
- +++ Error: Duplicate entry '13' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('14', 'statistics', 'statistics', 0, 0, '')
- +++ Error: Duplicate entry '14' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('15', 'site_hist', 'site_hist', 0, 0, '')
- +++ Error: Duplicate entry '15' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('16', 'calendar', 'calendar', 0, 0, '')
- +++ Error: Duplicate entry '16' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('17', 'recent', 'recent', 0, 0, '')
- +++ Error: Duplicate entry '17' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('18', 'referrers', 'referrers', 0, 0, '')
- +++ Error: Duplicate entry '18' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('19', 'shoutbox', 'shoutbox_max', 0, 0, '')
- +++ Error: Duplicate entry '19' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('20', 'kb', 'kb', 0, 0, '')
- +++ Error: Duplicate entry '20' for key 1
-
- # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('21', 'contact_us', 'contact_us', 0, 0, '')
- +++ Error: Duplicate entry '21' for key 1
-
- # UPDATE `ip_users` SET `user_session_page` = 'index.php'
- +++ Successfull
-
- # UPDATE `ip_sessions` SET `session_page` = 'index.php'
- +++ Successfull
-
- # INSERT INTO `ip_config` (config_name, config_value) VALUES ('show_forums_online_users', '0')
- +++ Error: Duplicate entry 'show_forums_online_users' for key 1
-
- # INSERT INTO `ip_config` (config_name, config_value) VALUES ('cms_dock', '0')
- +++ Error: Duplicate entry 'cms_dock' for key 1
-
- # INSERT INTO `ip_config` (config_name, config_value) VALUES ('allow_drafts', '1')
- +++ Error: Duplicate entry 'allow_drafts' for key 1
-
- # CREATE TABLE `ip_drafts` ( `draft_id` mediumint(8) UNSIGNED NOT NULL auto_increment, `user_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `topic_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `forum_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `save_time` int(11) UNSIGNED DEFAULT '0' NOT NULL, `draft_subject` varchar(100) DEFAULT '' NOT NULL, `draft_message` text, PRIMARY KEY (`draft_id`), KEY `save_time` (`save_time`) ) TYPE=MyISAM AUTO_INCREMENT=1
- +++ Error: Table 'ip_drafts' already exists
-
- # INSERT INTO ip_config VALUES ('ip_version', '1.1.5.20')
- +++ Error: Duplicate entry 'ip_version' for key 1
-
- # UPDATE ip_config SET config_value = '1.1.5.20' WHERE config_name = 'ip_version'
- +++ Successfull
-
- # UPDATE ip_config SET config_value = '.0.22' WHERE `config_name` = 'version'
- +++ Successfull
-
- # UPDATE ip_album_config SET config_value = '1.4.2' WHERE config_name = 'fap_version'
- +++ Successfull
-
- # UPDATE ip_config SET `config_value` = '3.0.7' WHERE `config_name` = 'upi2db_version'
- +++ Successfull
____________ ? JHOSMAN - Webmaster
|
#7 Mon 24 Sep, 2007 13:27 |
|
Zuker 
Joined: August 2006
Posts: 2134
Location:  BA
|
 Re: Digest Error When Logging Out
Do not pay attention of duplicate entrys, they means that in your db, that fields are already there
____________ ? Zuker - EDDB - LPM - Sharefields
|
#8 Mon 24 Sep, 2007 17:09 |
|
|
Page 1 of 1
|
Was this topic useful?
Was this topic useful?
Link this topic |
URL |
|
BBCode |
|
HTML |
|
You cannot post new topics You cannot reply to topics You cannot edit your posts You cannot delete your posts You cannot vote in polls You cannot attach files You can download files You cannot post calendar events
|
|
|
|