[RESOLVED] Hanging when activate "Latest Forums Items&q

Newbie Joined: Jan 29, 2006 Posts: 19

Hi.

First of all many thanks for this really great module. Looking forward for new ver. soon.

I've installed this on my test site and when I wanted to send a newsletter and want to show Latest Forums Items on it it dosn't works at all. I'll be sent to next "page" when I choose to preview or send and there I can only see the menu of module and nothing else happen. But when I choose away to show Latest Forums Items everythings works fine.

I have installed a few mods on my forum, if it could be a problem.

Best Regards.

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1294

Based on the behaviour you are describing, it sounds to me like there is a SQL error occurring. We need to see what that error is. Try turning the debug switch to ON in the Main Config menu and then you should be able to see which SQL statement it is err'ing out on.

Please post the SQL statement that is causing the error as well as any error message if you get one.

Unfortunately, version 1.2 may not provide enough debug information, but we can at least isolate to the exact SQL causing the issue.

Once you get the error, be sure to turn debug back off.

Regards, montego

Newbie Joined: Jan 29, 2006 Posts: 19

Thanks for reply, montego.

I did as you told me here and I get no error message at all Shocked

If you want I can send you login info for admin and Cpanel to my test site so you can see it by yourself.

Best Regards.

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1294

Yes, we had better do that. I will need to potentially change two files in order to see the error messages. I will then change them back.

Newbie Joined: Jan 29, 2006 Posts: 19

Thanks.

Info sent by pm.

Newbie Joined: Jan 29, 2006 Posts: 19

montego,

I was reading the forums about other people's problem with this module and try to find out what could I've done wrong during installation of this module and I find this topic:

http://montegoscripts.com/ftopict-34.html

The picture is showing in this topic (loading ...) I think it is a preloader for Nuke that I used to use on one of my site before too. It turns on in the header.php and turnes off when footer.php is loaded.

It seems that footer.php is not loaded and because of that preloader is still showing. If you look at my test site and my problem above you see when it "hangs up" you can see the header and module's menu but not footer.php!

I know that you are going to look at my site when you have time for it and I appreciate your help very much. But I just saw this topic and thought maybee I could help you a little. Confused

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1294

Your site is not hanging like in that topic you posted. It is getting SQL error and die'ing before it can get to the call to footer.php. If it was a PHP parse error, you would be getting a blank screen. When I get time today, I'll try to isolate the error... I am sure it is related to your forum mods...

By the way, I am going to PM you real quick on something I just noticed.

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1294

I have commented out the following code within modules/HTML_Newsletter/admin/admin_make_nls.php:

Code:

$msnl_sPostTime = msnl_fFormatDate( $msnl_asPHPBBCfg['default_dateformat'],
$row['post_time'], $msnl_asPHPBBCfg['board_timezone'] );

Something in the function msnl_fFormatDate is error'ing out. Unfortunately, I am unable to see the error message even with display errors turned on! Sad

I have left this commented out on your site for now until I can figure out just what is going on. Being your site is in Persian, it is incredibly difficult for me to debug. I know HNL 1.2 is working on sites in English, Spanish, Danish, German and Italian (as I have found them using Google), but I am wondering if it has anything to do with the more graphical based (multi-byte?) character set. However, I did switch your site over the English temporarily and it still would not work.

By the way, what you have now is a Release Candidate version of 1.3 on your site. I still need to clean up the credits/copyright to include another "helpful soul", so I would appreciate it if you would not distribute this version until I have made it an official release!

Newbie Joined: Jan 29, 2006 Posts: 19

Thanks again for having such a good support for your users.

Yes, you'r right (as always Very Happy

). The date is in Persian format i.e Shamsi date for whole the forums and most of the modules there. You maybee know that Iranian date is diffrent and we must make some changes to turn the date to this format and year.

I don't know much about how to do it because my friends did that part of programming. But I know that it is in mainfile.php and som other files.

It would be much easier for me to explain if you could possibly learn Persian Laughing

. But I think it is out of support deal you have here! Very Happy

Quote:

By the way, what you have now is a Release Candidate version of 1.3 on your site. I still need to clean up the credits/copyright to include another "helpful soul", so I would appreciate it if you would not distribute this version until I have made it an official release!

I promiss to not giving it to anybody untill you release the official one.

You are great, montego.

cheers.

Newbie Joined: Jan 29, 2006 Posts: 19

montego wrote:

I have commented out the following code within modules/HTML_Newsletter/admin/admin_make_nls.php:

Code:

$msnl_sPostTime = msnl_fFormatDate( $msnl_asPHPBBCfg['default_dateformat'],
$row['post_time'], $msnl_asPHPBBCfg['board_timezone'] );

Something in the function msnl_fFormatDate is error'ing out. Unfortunately, I am unable to see the error message even with display errors turned on! Sad

I have left this commented out on your site for now until I can figure out just what is going on. Being your site is in Persian, it is incredibly difficult for me to debug. I know HNL 1.2 is working on sites in English, Spanish, Danish, German and Italian (as I have found them using Google), but I am wondering if it has anything to do with the more graphical based (multi-byte?) character set. However, I did switch your site over the English temporarily and it still would not work.

Montego,

Sorry to bothering you and bumping you with my problems. I'de like to ask you about one more thing. When I activate "Latest Review Items" I get same problem as before with forums and base on your solution I think it is because of our strange Date format.

Could you please tell me in which file and what code should I comment out to get rid of this one too? to not showing Date on Reviews.

Best Regards.

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1294

izone wrote:

Could you please tell me in which file and what code should I comment out to get rid of this one too? to not showing Date on Reviews.

In same file above comment out the following code:

Code:

      $msnl_sReviewDtFormat = trim( eregi_replace( "[g\:iabhsu]", "", $msnl_asPHPBBCfg['default_dateformat'] ) );

      $msnl_sReviewDt = msnl_fFormatDate( $msnl_sReviewDtFormat,
                                 strtotime( $msnl_sReviewDt ), $msnl_asPHPBBCfg['board_timezone'] );

Yes, this is the same problem as with Forums because I am trying to format the date per the site default date settings (from Forums). My appologies that I did not think about that one yesterday as well.

Newbie Joined: Jan 29, 2006 Posts: 19

Thank you very much, Montego.

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1294

This has been resolved by Izone and he has created a version of HTML Newsletter for Persian Nuke. Should be added to the downloads very soon.

Newbie Joined: Aug 17, 2006 Posts: 2

hi i'm having this issue to

everything works well until i use lastest forums

it get stuck i think is somenthing with the query

Code:

Create Newsletter - Validate and Preview

SQL = UPDATE `nuke_hnl_cfg` SET `cfg_val` = '0' WHERE `cfg_nm` = 'latest_news'

SQL = UPDATE `nuke_hnl_cfg` SET `cfg_val` = '0' WHERE `cfg_nm` = 'latest_downloads'

SQL = UPDATE `nuke_hnl_cfg` SET `cfg_val` = '0' WHERE `cfg_nm` = 'latest_links'

SQL = UPDATE `nuke_hnl_cfg` SET `cfg_val` = '5' WHERE `cfg_nm` = 'latest_forums'

SQL = SELECT `user_id` FROM `nuke_users` WHERE `username` <> 'Anonymous'

SQL = SELECT `count` FROM `nuke_counter` WHERE `type` = 'total' AND `var` = 'hits' LIMIT 1

SQL = SELECT * FROM `nuke_stories`

SQL = SELECT * FROM `nuke_stories_cat`

SQL = SELECT * FROM `nuke_downloads_downloads`

SQL = SELECT * FROM `nuke_downloads_categories`

SQL = SELECT * FROM `nuke_links_links`

SQL = SELECT * FROM `nuke_links_categories`

SQL = SELECT * FROM `nuke_bbtopics`

SQL = SELECT * FROM `nuke_bbposts`

SQL = SELECT * FROM `nuke_reviews`

SQL = SELECT t.`topic_id` AS topic_id, t.`forum_id` AS forum_id, `topic_last_post_id`, `topic_title`, `topic_views`, `topic_replies`, `post_time`, ut.`username` AS ut_username, ut.`user_id` AS ut_user_id, up.`username` AS up_username, up.`user_id` AS up_user_id FROM `nuke_bbtopics` t, `nuke_bbforums` f, `nuke_bbposts` p, `nuke_users` ut, `nuke_users` up WHERE f.`forum_id` = t.`forum_id` AND `post_id` = `topic_last_post_id` AND ut.`user_id` = `topic_poster` AND up.`user_id` = `poster_id` AND `topic_moved_id` = '0' ORDER BY `topic_last_post_id` DESC LIMIT 0, 5

it dosen't show the button of go back like normally will do

with you debug dosen't show anything

Code:

--
-- Table structure for table `nuke_bbforums`
--

CREATE TABLE `nuke_bbforums` (
`forum_id` smallint(5) unsigned NOT NULL default '0',
`cat_id` mediumint(8) unsigned NOT NULL default '0',
`forum_name` varchar(150) default NULL,
`forum_desc` text,
`forum_status` tinyint(4) NOT NULL default '0',
`forum_order` mediumint(8) unsigned NOT NULL default '1',
`forum_posts` mediumint(8) unsigned NOT NULL default '0',
`forum_topics` mediumint(8) unsigned NOT NULL default '0',
`forum_last_post_id` mediumint(8) unsigned NOT NULL default '0',
`prune_next` int(11) default NULL,
`prune_enable` tinyint(1) NOT NULL default '1',
`points_disabled` tinyint(1) NOT NULL default '0',
`auth_view` tinyint(2) NOT NULL default '0',
`auth_read` tinyint(2) NOT NULL default '0',
`auth_post` tinyint(2) NOT NULL default '0',
`auth_reply` tinyint(2) NOT NULL default '0',
`auth_edit` tinyint(2) NOT NULL default '0',
`auth_delete` tinyint(2) NOT NULL default '0',
`auth_sticky` tinyint(2) NOT NULL default '0',
`auth_announce` tinyint(2) NOT NULL default '0',
`auth_vote` tinyint(2) NOT NULL default '0',
`auth_pollcreate` tinyint(2) NOT NULL default '0',
`auth_attachments` tinyint(2) NOT NULL default '0',
`resynced` smallint(1) NOT NULL default '0',
`forum_link` varchar(255) default NULL,
`forum_link_internal` tinyint(1) NOT NULL default '0',
`forum_link_hit_count` tinyint(1) NOT NULL default '0',
`forum_link_hit` bigint(20) unsigned NOT NULL default '0',
`main_type` char(1) default NULL,
PRIMARY KEY (`forum_id`),
KEY `forums_order` (`forum_order`),
KEY `cat_id` (`cat_id`),
KEY `forum_last_post_id` (`forum_last_post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `nuke_bbposts`
--

CREATE TABLE `nuke_bbposts` (
`post_id` mediumint(8) unsigned NOT NULL auto_increment,
`topic_id` mediumint(8) unsigned NOT NULL default '0',
`forum_id` smallint(5) unsigned NOT NULL default '0',
`poster_id` mediumint(8) NOT NULL default '0',
`post_time` int(11) NOT NULL default '0',
`poster_ip` varchar(8) NOT NULL default '',
`post_username` varchar(25) default NULL,
`enable_bbcode` tinyint(1) NOT NULL default '1',
`enable_html` tinyint(1) NOT NULL default '1',
`enable_smilies` tinyint(1) NOT NULL default '1',
`enable_sig` tinyint(1) NOT NULL default '1',
`post_edit_time` int(11) default NULL,
`post_edit_count` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`post_id`),
KEY `forum_id` (`forum_id`),
KEY `topic_id` (`topic_id`),
KEY `poster_id` (`poster_id`),
KEY `post_time` (`post_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=49717 ;

-- --------------------------------------------------------

--
-- Table structure for table `nuke_bbtopics`
--

CREATE TABLE `nuke_bbtopics` (
`topic_id` mediumint(8) unsigned NOT NULL auto_increment,
`forum_id` smallint(8) unsigned NOT NULL default '0',
`topic_title` char(60) NOT NULL default '',
`topic_poster` mediumint(8) NOT NULL default '0',
`topic_time` int(11) NOT NULL default '0',
`topic_views` mediumint(8) unsigned NOT NULL default '0',
`topic_replies` mediumint(8) unsigned NOT NULL default '0',
`topic_status` tinyint(3) NOT NULL default '0',
`topic_vote` tinyint(1) NOT NULL default '0',
`topic_type` tinyint(3) NOT NULL default '0',
`topic_last_post_id` mediumint(8) unsigned NOT NULL default '0',
`topic_first_post_id` mediumint(8) unsigned NOT NULL default '0',
`topic_moved_id` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`topic_id`),
KEY `forum_id` (`forum_id`),
KEY `topic_moved_id` (`topic_moved_id`),
KEY `topic_status` (`topic_status`),
KEY `topic_type` (`topic_type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4892 ;

-- --------------------------------------------------------

--
-- Table structure for table `nuke_users`
--

CREATE TABLE `nuke_users` (
`user_id` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`username` varchar(25) NOT NULL default '',
`user_email` varchar(255) NOT NULL default '',
`femail` varchar(255) NOT NULL default '',
`user_website` varchar(255) NOT NULL default '',
`user_avatar` varchar(255) NOT NULL default '',
`user_regdate` varchar(20) NOT NULL default '',
`user_icq` varchar(15) default NULL,
`user_occ` varchar(100) default NULL,
`user_from` varchar(100) default NULL,
`user_interests` varchar(150) NOT NULL default '',
`user_sig` varchar(255) default NULL,
`user_viewemail` tinyint(2) default NULL,
`user_theme` int(3) default NULL,
`user_aim` varchar(18) default NULL,
`user_yim` varchar(25) default NULL,
`user_msnm` varchar(25) default NULL,
`user_password` varchar(40) NOT NULL default '',
`storynum` tinyint(4) NOT NULL default '10',
`umode` varchar(10) NOT NULL default '',
`uorder` tinyint(1) NOT NULL default '0',
`thold` tinyint(1) NOT NULL default '0',
`noscore` tinyint(1) NOT NULL default '0',
`bio` tinytext NOT NULL,
`ublockon` tinyint(1) NOT NULL default '0',
`ublock` tinytext NOT NULL,
`theme` varchar(255) NOT NULL default '',
`commentmax` int(11) NOT NULL default '4096',
`counter` int(11) NOT NULL default '0',
`newsletter` int(1) NOT NULL default '1',
`user_posts` int(10) NOT NULL default '0',
`user_attachsig` int(2) NOT NULL default '0',
`user_rank` int(10) NOT NULL default '0',
`user_level` int(10) NOT NULL default '1',
`broadcast` tinyint(1) NOT NULL default '1',
`popmeson` tinyint(1) NOT NULL default '0',
`user_active` tinyint(1) default '1',
`user_session_time` int(11) NOT NULL default '0',
`user_session_page` smallint(5) NOT NULL default '0',
`user_lastvisit` int(11) NOT NULL default '0',
`user_timezone` tinyint(4) NOT NULL default '10',
`user_style` tinyint(4) default NULL,
`user_lang` varchar(255) NOT NULL default 'spanish',
`user_dateformat` varchar(14) NOT NULL default 'D M d, Y g:i a',
`user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_last_privmsg` int(11) NOT NULL default '0',
`user_emailtime` int(11) default NULL,
`user_allowhtml` tinyint(1) default '1',
`user_allowbbcode` tinyint(1) default '1',
`user_allowsmile` tinyint(1) default '1',
`user_allowavatar` tinyint(1) NOT NULL default '1',
`user_allow_pm` tinyint(1) NOT NULL default '1',
`user_allow_viewonline` tinyint(1) NOT NULL default '1',
`user_notify` tinyint(4) NOT NULL default '0',
`user_notify_pm` tinyint(4) NOT NULL default '0',
`user_notify_donation` tinyint(1) NOT NULL default '1',
`user_popup_pm` tinyint(1) NOT NULL default '1',
`user_avatar_type` tinyint(4) NOT NULL default '3',
`user_sig_bbcode_uid` varchar(10) default NULL,
`user_actkey` varchar(32) default NULL,
`user_newpasswd` varchar(32) default NULL,
`points` int(10) default '0',
`last_ip` varchar(15) NOT NULL default '0',
`karma` tinyint(1) default '0',
`agreedtos` tinyint(1) NOT NULL default '0',
`user_group_cp` int(11) NOT NULL default '2',
`user_group_list_cp` varchar(100) NOT NULL default '2',
`user_active_cp` enum('YES','NO') NOT NULL default 'YES',
`admin_allow_points` tinyint(1) NOT NULL default '1',
`user_gtalk` varchar(255) default NULL,
`user_gender` tinyint(4) NOT NULL default '0',
`user_birthday` int(11) NOT NULL default '999999',
`user_next_birthday_greeting` int(11) NOT NULL default '0',
`user_chatting` int(11) NOT NULL default '0',
`php121_smilies` tinyint(1) NOT NULL default '1',
`php121_showrequest` tinyint(1) NOT NULL default '1',
`user_inactive_emls` tinyint(1) NOT NULL default '0',
`user_inactive_last_eml` int(11) NOT NULL default '0',
`user_view_log` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`user_id`),
KEY `uname` (`username`),
KEY `user_session_time` (`user_session_time`),
KEY `karma` (`karma`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1468 ;

Newbie Joined: Aug 17, 2006 Posts: 2

also i have this error when i send a mail

Create Newsletter - Send Mail

Total Emails Sent: 1137

More than 500 users will receive the newsletter, this can take 10 minutes or more and PHP may time-out.

ERROR IN MODULE: HTML_Newsletter

ERROR MSG: PHP mail function failed - was unable to send newsletter to: d41d8cd98f00b204e9800998ecf8427e