Montego Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic
Author Message
izone
Newbie
Newbie



Joined: Jan 29, 2006
Posts: 19

PostPosted: Mon Jan 30, 2006 7:00 pm Reply with quote

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.
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1393

PostPosted: Mon Jan 30, 2006 8:13 pm Reply with quote

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

_________________
“To err is human, but when the eraser wears out ahead of the pencil, you’re overdoing it.”
-- Josh Jenkins 
View user's profile Send private message Visit poster's website
izone
Newbie
Newbie



Joined: Jan 29, 2006
Posts: 19

PostPosted: Tue Jan 31, 2006 5:10 am Reply with quote

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.
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1393

PostPosted: Tue Jan 31, 2006 8:24 am Reply with quote

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.

_________________
“To err is human, but when the eraser wears out ahead of the pencil, you’re overdoing it.”
-- Josh Jenkins 
View user's profile Send private message Visit poster's website
izone
Newbie
Newbie



Joined: Jan 29, 2006
Posts: 19

PostPosted: Tue Jan 31, 2006 8:56 am Reply with quote

Thanks.

Info sent by pm.
 
View user's profile Send private message
izone
Newbie
Newbie



Joined: Jan 29, 2006
Posts: 19

PostPosted: Tue Jan 31, 2006 12:01 pm Reply with quote

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
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1393

PostPosted: Tue Jan 31, 2006 12:32 pm Reply with quote

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.

_________________
“To err is human, but when the eraser wears out ahead of the pencil, you’re overdoing it.”
-- Josh Jenkins 
View user's profile Send private message Visit poster's website
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1393

PostPosted: Tue Jan 31, 2006 6:33 pm Reply with quote

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!

_________________
“To err is human, but when the eraser wears out ahead of the pencil, you’re overdoing it.”
-- Josh Jenkins 
View user's profile Send private message Visit poster's website
izone
Newbie
Newbie



Joined: Jan 29, 2006
Posts: 19

PostPosted: Wed Feb 01, 2006 5:03 am Reply with quote

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.
 
View user's profile Send private message
izone
Newbie
Newbie



Joined: Jan 29, 2006
Posts: 19

PostPosted: Wed Feb 01, 2006 7:47 am Reply with quote

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.
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1393

PostPosted: Wed Feb 01, 2006 8:17 am Reply with quote

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.

_________________
“To err is human, but when the eraser wears out ahead of the pencil, you’re overdoing it.”
-- Josh Jenkins 
View user's profile Send private message Visit poster's website
izone
Newbie
Newbie



Joined: Jan 29, 2006
Posts: 19

PostPosted: Wed Feb 01, 2006 3:11 pm Reply with quote

Thank you very much, Montego.
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1393

PostPosted: Sun Mar 12, 2006 4:45 pm Reply with quote

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.

_________________
“To err is human, but when the eraser wears out ahead of the pencil, you’re overdoing it.”
-- Josh Jenkins 
View user's profile Send private message Visit poster's website
egranto
Newbie
Newbie



Joined: Aug 17, 2006
Posts: 2

PostPosted: Fri Aug 18, 2006 10:37 am Reply with quote

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 ;

 
View user's profile Send private message Visit poster's website
egranto
Newbie
Newbie



Joined: Aug 17, 2006
Posts: 2

PostPosted: Fri Aug 18, 2006 1:06 pm Reply with quote

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
 
View user's profile Send private message Visit poster's website
Display posts from previous:       
Post new topic   Reply to topic

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 4 Hours
 
Forums ©
linear-bunchlinear-bunch