Icy Phoenix

     
 


Post new topic  This topic is locked: you cannot edit posts or make replies. 
Page 1 of 1
 
 
Reply with quote Download Post 
Post 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.
Code: [Download] [Hide] [Select]
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  
 



 
MajickDevSend private message  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post 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
 
JHOSMANSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Digest Error When Logging Out 
 
check the table
kokforos_db.ip_digest_subscribed_forums
if exist in your bd
 



 
robin crackerSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Digest Error When Logging Out 
 
robin cracker wrote: [View Post]
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
 
JHOSMANSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Digest Error When Logging Out 
 
JHOSMAN, your upgrade was wrong, try to run it again carefully
 




____________
? Zuker - EDDB - LPM - Sharefields
 
ZukerSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Digest Error When Logging Out 
 
Zuker wrote: [View Post]
JHOSMAN, your upgrade was wrong, try to run it again carefully


  Im of new the Icy Upgrade and last coment
 




____________
? JHOSMAN - Webmaster
 
JHOSMANSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Digest Error When Logging Out 
 
In the update are this problems

Code: [Download] [Hide]
  1. # INSERT INTO ip_config (config_name, config_value) VALUES ('mg_log_actions', '0')  
  2. +++ Error: Duplicate entry 'mg_log_actions' for key 1  
  3.  
  4. # INSERT INTO ip_config (config_name, config_value) VALUES ('cash_disable', 0)  
  5. +++ Error: Duplicate entry 'cash_disable' for key 1  
  6.  
  7. # INSERT INTO ip_config (config_name, config_value) VALUES ('cash_display_after_posts', 1)  
  8. +++ Error: Duplicate entry 'cash_display_after_posts' for key 1  
  9.  
  10. # INSERT INTO ip_config (config_name, config_value) VALUES ('cash_post_message', 'You earned %s for that post')  
  11. +++ Error: Duplicate entry 'cash_post_message' for key 1  
  12.  
  13. # INSERT INTO ip_config (config_name, config_value) VALUES ('cash_disable_spam_num', 10)  
  14. +++ Error: Duplicate entry 'cash_disable_spam_num' for key 1  
  15.  
  16. # INSERT INTO ip_config (config_name, config_value) VALUES ('cash_disable_spam_time', 24)  
  17. +++ Error: Duplicate entry 'cash_disable_spam_time' for key 1  
  18.  
  19. # 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')  
  20. +++ Error: Duplicate entry 'cash_disable_spam_message' for key 1  
  21.  
  22. # INSERT INTO ip_config (config_name, config_value) VALUES ('cash_installed', 'yes')  
  23. +++ Error: Duplicate entry 'cash_installed' for key 1  
  24.  
  25. # INSERT INTO ip_config (config_name, config_value) VALUES ('cash_version', '2.2.3')  
  26. +++ Error: Duplicate entry 'cash_version' for key 1  
  27.  
  28. # INSERT INTO ip_config (config_name, config_value) VALUES ('cash_adminbig', '0')  
  29. +++ Error: Duplicate entry 'cash_adminbig' for key 1  
  30.  
  31. # INSERT INTO ip_config (config_name, config_value) VALUES ('cash_adminnavbar', '1')  
  32. +++ Error: Duplicate entry 'cash_adminnavbar' for key 1  
  33.  
  34. # INSERT INTO ip_config (config_name, config_value) VALUES ('points_name', 'Points')  
  35. +++ Error: Duplicate entry 'points_name' for key 1  
  36.  
  37. # 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) )  
  38. +++ Error: Table 'ip_cash' already exists  
  39.  
  40. # CREATE TABLE `ip_cash_events` ( event_name varchar(32) NOT NULL default '', event_data varchar(255) NOT NULL default '', PRIMARY KEY (event_name) )  
  41. +++ Error: Table 'ip_cash_events' already exists  
  42.  
  43. # 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) )  
  44. +++ Error: Table 'ip_cash_exchange' already exists  
  45.  
  46. # 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) )  
  47. +++ Error: Table 'ip_cash_groups' already exists  
  48.  
  49. # 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) )  
  50. +++ Error: Table 'ip_cash_log' already exists  
  51.  
  52. # 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) )  
  53. +++ Error: Table 'ip_album_comment_watch' already exists  
  54.  
  55. # UPDATE `ip_users` SET user_color_group = '0'  
  56. +++ Successfull  
  57.  
  58. # ALTER TABLE ip_groups ADD COLUMN group_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL AFTER group_single_user  
  59. +++ Error: Duplicate column name 'group_rank'  
  60.  
  61. # ALTER TABLE ip_groups ADD COLUMN group_color varchar(50) DEFAULT '' NOT NULL AFTER group_rank  
  62. +++ Error: Duplicate column name 'group_color'  
  63.  
  64. # ALTER TABLE ip_groups ADD COLUMN group_legend tinyint(1) UNSIGNED DEFAULT '0' NOT NULL AFTER group_color  
  65. +++ Error: Duplicate column name 'group_legend'  
  66.  
  67. # INSERT INTO ip_config (config_name, config_value) VALUES ('active_users_color', '#224455')  
  68. +++ Error: Duplicate entry 'active_users_color' for key 1  
  69.  
  70. # INSERT INTO ip_config (config_name, config_value) VALUES ('active_users_legend', '1')  
  71. +++ Error: Duplicate entry 'active_users_legend' for key 1  
  72.  
  73. # INSERT INTO ip_config (config_name, config_value) VALUES ('bots_legend', '1')  
  74. +++ Error: Duplicate entry 'bots_legend' for key 1  
  75.  
  76. # DROP TABLE `ip_color_groups`  
  77. +++ Error: Unknown table 'ip_color_groups'  
  78.  
  79. # ALTER TABLE `ip_groups` DROP `group_color_group`  
  80. +++ Error: Can't DROP 'group_color_group'; check that column/key exists  
  81.  
  82. # INSERT INTO `ip_config` (config_name, config_value) VALUES ('show_social_bookmarks', '0')  
  83. +++ Error: Duplicate entry 'show_social_bookmarks' for key 1  
  84.  
  85. # UPDATE `ip_themes` SET td_class3 = 'row3'  
  86. +++ Successfull  
  87.  
  88. # ALTER TABLE `ip_album_cat` ADD `cat_pics` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL AFTER `cat_wm`;  
  89. +++ Error: Duplicate column name 'cat_pics'  
  90.  
  91. # ALTER TABLE `ip_users` DROP `user_session_topic`  
  92. +++ Error: Can't DROP 'user_session_topic'; check that column/key exists  
  93.  
  94. # ALTER TABLE `ip_sessions` DROP `session_topic`  
  95. +++ Error: Can't DROP 'session_topic'; check that column/key exists  
  96.  
  97. # ALTER TABLE `ip_users` CHANGE `user_session_page` `user_session_page` varchar(255) NOT NULL default ''  
  98. +++ Successfull  
  99.  
  100. # ALTER TABLE `ip_sessions` CHANGE `session_page` `session_page` varchar(255) NOT NULL default ''  
  101. +++ Successfull  
  102.  
  103. # 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  
  104. +++ Error: Table 'ip_cms_layout_special' already exists  
  105.  
  106. # ALTER TABLE `ip_cms_layout` CHANGE `forum_wide` `forum_wide` tinyint(1) NOT NULL default '0'  
  107. +++ Successfull  
  108.  
  109. # ALTER TABLE `ip_cms_blocks` CHANGE `layout` `layout` int(10) NOT NULL default '0'  
  110. +++ Successfull  
  111.  
  112. # ALTER TABLE `ip_cms_blocks` ADD `layout_special` int(10) NOT NULL default '0' AFTER `layout`  
  113. +++ Error: Duplicate column name 'layout_special'  
  114.  
  115. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('1', 'forum', 'forum', 0, 0, '')  
  116. +++ Error: Duplicate entry '1' for key 1  
  117.  
  118. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('2', 'viewf', 'viewforum', 0, 0, '')  
  119. +++ Error: Duplicate entry '2' for key 1  
  120.  
  121. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('3', 'viewt', 'viewtopic', 0, 0, '')  
  122. +++ Error: Duplicate entry '3' for key 1  
  123.  
  124. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('4', 'viewonline', 'viewonline', 0, 0, '')  
  125. +++ Error: Duplicate entry '4' for key 1  
  126.  
  127. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('5', 'search', 'search', 0, 0, '')  
  128. +++ Error: Duplicate entry '5' for key 1  
  129.  
  130. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('6', 'profile', 'profile', 0, 0, '')  
  131. +++ Error: Duplicate entry '6' for key 1  
  132.  
  133. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('7', 'memberlist', 'memberlist', 0, 0, '')  
  134. +++ Error: Duplicate entry '7' for key 1  
  135.  
  136. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('8', 'group_cp', 'groupcp', 0, 0, '')  
  137. +++ Error: Duplicate entry '8' for key 1  
  138.  
  139. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('9', 'faq', 'faq', 0, 0, '')  
  140. +++ Error: Duplicate entry '9' for key 1  
  141.  
  142. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('10', 'rules', 'rules', 0, 0, '')  
  143. +++ Error: Duplicate entry '10' for key 1  
  144.  
  145. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('11', 'download', 'dload', 0, 0, '')  
  146. +++ Error: Duplicate entry '11' for key 1  
  147.  
  148. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('12', 'album', 'album', 0, 0, '')  
  149. +++ Error: Duplicate entry '12' for key 1  
  150.  
  151. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('13', 'links', 'links', 0, 0, '')  
  152. +++ Error: Duplicate entry '13' for key 1  
  153.  
  154. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('14', 'statistics', 'statistics', 0, 0, '')  
  155. +++ Error: Duplicate entry '14' for key 1  
  156.  
  157. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('15', 'site_hist', 'site_hist', 0, 0, '')  
  158. +++ Error: Duplicate entry '15' for key 1  
  159.  
  160. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('16', 'calendar', 'calendar', 0, 0, '')  
  161. +++ Error: Duplicate entry '16' for key 1  
  162.  
  163. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('17', 'recent', 'recent', 0, 0, '')  
  164. +++ Error: Duplicate entry '17' for key 1  
  165.  
  166. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('18', 'referrers', 'referrers', 0, 0, '')  
  167. +++ Error: Duplicate entry '18' for key 1  
  168.  
  169. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('19', 'shoutbox', 'shoutbox_max', 0, 0, '')  
  170. +++ Error: Duplicate entry '19' for key 1  
  171.  
  172. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('20', 'kb', 'kb', 0, 0, '')  
  173. +++ Error: Duplicate entry '20' for key 1  
  174.  
  175. # INSERT INTO `ip_cms_layout_special` (`lsid`, `name`, `filename`, `forum_wide`, `view`, `groups`) VALUES ('21', 'contact_us', 'contact_us', 0, 0, '')  
  176. +++ Error: Duplicate entry '21' for key 1  
  177.  
  178. # UPDATE `ip_users` SET `user_session_page` = 'index.php'  
  179. +++ Successfull  
  180.  
  181. # UPDATE `ip_sessions` SET `session_page` = 'index.php'  
  182. +++ Successfull  
  183.  
  184. # INSERT INTO `ip_config` (config_name, config_value) VALUES ('show_forums_online_users', '0')  
  185. +++ Error: Duplicate entry 'show_forums_online_users' for key 1  
  186.  
  187. # INSERT INTO `ip_config` (config_name, config_value) VALUES ('cms_dock', '0')  
  188. +++ Error: Duplicate entry 'cms_dock' for key 1  
  189.  
  190. # INSERT INTO `ip_config` (config_name, config_value) VALUES ('allow_drafts', '1')  
  191. +++ Error: Duplicate entry 'allow_drafts' for key 1  
  192.  
  193. # 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  
  194. +++ Error: Table 'ip_drafts' already exists  
  195.  
  196. # INSERT INTO ip_config VALUES ('ip_version', '1.1.5.20')  
  197. +++ Error: Duplicate entry 'ip_version' for key 1  
  198.  
  199. # UPDATE ip_config SET config_value = '1.1.5.20' WHERE config_name = 'ip_version'  
  200. +++ Successfull  
  201.  
  202. # UPDATE ip_config SET config_value = '.0.22' WHERE `config_name` = 'version'  
  203. +++ Successfull  
  204.  
  205. # UPDATE ip_album_config SET config_value = '1.4.2' WHERE config_name = 'fap_version'  
  206. +++ Successfull  
  207.  
  208. # UPDATE ip_config SET `config_value` = '3.0.7' WHERE `config_name` = 'upi2db_version'  
  209. +++ Successfull 

 




____________
? JHOSMAN - Webmaster
 
JHOSMANSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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
 
ZukerSend private messageVisit poster's website  
Back to topPage bottom
Post new topic  This topic is locked: you cannot edit posts or make replies.  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
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


  

 

  cron