[DBTech] DragonByte Mail

[DBTech] DragonByte Mail [Paid] 4.7.0

No permission to buy ($14.95)
I'm seeing the same:

Code:
Server error log

    TypeError: Return value of DBTech\Mail\DigestContent\Thread::getEmailContent() must be of the type array, object returned src/addons/DBTech/Mail/DigestContent/Thread.php:393 

    Generated by: Unknown account Dec 30, 2020 at 9:02 AM 

Stack trace

#0 src/addons/DBTech/Mail/DigestContent/AbstractHandler.php(147): DBTech\Mail\DigestContent\Thread->getEmailContent(Object(DBTech\Mail\Entity\Digest), Object(SV\ReportImprovements\XF\Entity\User))
#1 src/addons/DBTech/Mail/Job/DigestEmail.php(138): DBTech\Mail\DigestContent\AbstractHandler->getEmailTemplateParams(Object(DBTech\Mail\Entity\Digest), Object(SV\ReportImprovements\XF\Entity\User))
#2 src/XF/Job/AbstractUserCriteriaJob.php(59): DBTech\Mail\Job\DigestEmail->executeAction(Object(SV\ReportImprovements\XF\Entity\User))
#3 src/addons/DBTech/Mail/Job/DigestEmail.php(76): XF\Job\AbstractUserCriteriaJob->run(8)
#4 src/XF/Job/Manager.php(258): DBTech\Mail\Job\DigestEmail->run(8)
#5 src/XF/Job/Manager.php(200): XF\Job\Manager->runJobInternal(Array, 8)
#6 src/XF/Job/Manager.php(84): XF\Job\Manager->runJobEntry(Array, 8)
#7 job.php(43): XF\Job\Manager->runQueue(false, 8)
#8 {main}

Request state

array(4) {
  ["url"] => string(13) "/job.php"
  ["referrer"] => string(43) "https://www.domain.com/admin.php"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}
 
I am intermittently but consistently starting to see this msg:
"There are scheduled jobs outstanding which have not run. Jobs may not be getting triggered when expected. "

It's flagged as an error but disappears shortly after a few refreshes.

@DragonByte Tech

I see the digest log populated so something is definitely running :)
 
I am intermittently but consistently starting to see this msg:
"There are scheduled jobs outstanding which have not run. Jobs may not be getting triggered when expected. "

It's flagged as an error but disappears shortly after a few refreshes.

@DragonByte Tech

I see the digest log populated so something is definitely running :)
That has nothing to do with this addon. This is because you use “activity based” cron jobs, but you do not have enough active users on your site.
 
That has nothing to do with this addon. This is because you use “activity based” cron jobs, but you do not have enough active users on your site.

Fair enough. In the 6 years I've been on xf this is the very first time I've seen this message moments after your addon started dispatching thousands of digest emails.:whistle: It was merely a curiosity as to what it signifies. Doesn't appear to be an issue. Great to see the digest working again.
 
Done.

@ others: please upvote it there.

Hey folks,

we have now the chance to get real individual throtteling implemented into this mail addon. So please upvote for this suggestion in the support forum of dragonbyte:


Do not complain afterwards, if you do not upvote for it now :mad:

So pleeeeaaaase get out of your comfort zone and do it!
 
Getting Errors

DragonByte Mail 4.6.0 Beta 1
XenForo v2.2.2
Apache/2.4.46
10.4.17-MariaDB
PHP 8


Code:
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'dbtech_mail_newsletter_frequency' in 'field list' src\XF\Db\AbstractStatement.php:228
Generated by: Unknown account Jan 13, 2021 at 9:52 AM
Stack trace
INSERT  INTO `xf_user` (`visible`, `activity_visible`, `user_group_id`, `timezone`, `language_id`, `last_summary_email_date`, `username`, `email`, `user_state`, `privacy_policy_accepted`, `terms_accepted`, `dbtech_shop_purchase`, `display_style_group_id`, `secondary_group_ids`, `secret_key`, `user_id`, `username_date`, `username_date_visible`, `style_id`, `permission_combination_id`, `message_count`, `question_solution_count`, `alerts_unviewed`, `alerts_unread`, `conversations_unread`, `register_date`, `last_activity`, `trophy_points`, `avatar_date`, `avatar_width`, `avatar_height`, `avatar_highdpi`, `gravatar`, `security_lock`, `is_moderator`, `is_admin`, `is_staff`, `is_banned`, `reaction_score`, `vote_score`, `custom_title`, `warning_points`, `dbtech_mail_defaultkeyword`, `dbtech_mail_inactivereminder`, `dbtech_mail_numreminders`, `dbtech_mail_newsletter_frequency`, `dbtech_mail_newsletter_receive`, `dbtech_mail_newsletter_lastreceive`, `dbtech_mail_validation_date`, `dbtech_shop_points`, `dbtech_shop_purchases`, `dbtech_shop_immunity`, `dbtech_shop_pendingtrades`, `dbtech_shop_item_count`, `siropu_chat_room_id`, `siropu_chat_conv_id`, `siropu_chat_rooms`, `siropu_chat_conversations`, `siropu_chat_settings`, `siropu_chat_room_join_time`, `siropu_chat_status`, `siropu_chat_is_sanctioned`, `siropu_chat_message_count`, `siropu_chat_last_activity`, `snog_flag`, `thdonate_total_donation`, `thdonate_total_public_donation`, `thdonate_total_anonymous_donation`, `thdonate_num_donation`, `thdonate_num_public_donation`, `thdonate_num_anonymous_donation`, `xfmg_album_count`, `xfmg_media_count`, `xfmg_media_quota`, `xfrm_resource_count`, `xp_nt_see_newstickers`, `andy_most_reactions_count`, `grgi_user_group_icons`, `snog_forms`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src\XF\Db\Mysqli\Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src\XF\Db\Mysqli\Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src\XF\Db\Mysqli\Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src\XF\Db\AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src\XF\Db\AbstractAdapter.php(218): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#5 src\XF\Mvc\Entity\Entity.php(1510): XF\Db\AbstractAdapter->insert('xf_user', Array, false)
#6 src\XF\Mvc\Entity\Entity.php(1242): XF\Mvc\Entity\Entity->_saveToSource()
#7 src\XF\Service\User\Registration.php(298): XF\Mvc\Entity\Entity->save()
#8 src\XF\Service\ValidateAndSavableTrait.php(40): XF\Service\User\Registration->_save()
#9 src\XF\Pub\Controller\Register.php(422): XF\Service\User\Registration->save()
#10 src\addons\BlackTea\SteamAuth\XF\Pub\Controller\Register.php(50): XF\Pub\Controller\Register->actionRegister()
#11 src\XF\Mvc\Dispatcher.php(350): BlackTea\SteamAuth\XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#12 src\XF\Mvc\Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(Snog\CountryBan\XF\Pub\Controller\Register), NULL)
#13 src\XF\Mvc\Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Snog\CountryBan\XF\Pub\Controller\Register), NULL)
#14 src\XF\Mvc\Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#15 src\XF\App.php(2300): XF\Mvc\Dispatcher->run()
#16 src\XF.php(488): XF\App->run()
#17 index.php(20): XF::runApp('XF\\Pub\\App')
#18 {main}
 
Getting Errors

DragonByte Mail 4.6.0 Beta 1
XenForo v2.2.2
Apache/2.4.46
10.4.17-MariaDB
PHP 8


Code:
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'dbtech_mail_newsletter_frequency' in 'field list' src\XF\Db\AbstractStatement.php:228
Generated by: Unknown account Jan 13, 2021 at 9:52 AM
Stack trace
INSERT  INTO `xf_user` (`visible`, `activity_visible`, `user_group_id`, `timezone`, `language_id`, `last_summary_email_date`, `username`, `email`, `user_state`, `privacy_policy_accepted`, `terms_accepted`, `dbtech_shop_purchase`, `display_style_group_id`, `secondary_group_ids`, `secret_key`, `user_id`, `username_date`, `username_date_visible`, `style_id`, `permission_combination_id`, `message_count`, `question_solution_count`, `alerts_unviewed`, `alerts_unread`, `conversations_unread`, `register_date`, `last_activity`, `trophy_points`, `avatar_date`, `avatar_width`, `avatar_height`, `avatar_highdpi`, `gravatar`, `security_lock`, `is_moderator`, `is_admin`, `is_staff`, `is_banned`, `reaction_score`, `vote_score`, `custom_title`, `warning_points`, `dbtech_mail_defaultkeyword`, `dbtech_mail_inactivereminder`, `dbtech_mail_numreminders`, `dbtech_mail_newsletter_frequency`, `dbtech_mail_newsletter_receive`, `dbtech_mail_newsletter_lastreceive`, `dbtech_mail_validation_date`, `dbtech_shop_points`, `dbtech_shop_purchases`, `dbtech_shop_immunity`, `dbtech_shop_pendingtrades`, `dbtech_shop_item_count`, `siropu_chat_room_id`, `siropu_chat_conv_id`, `siropu_chat_rooms`, `siropu_chat_conversations`, `siropu_chat_settings`, `siropu_chat_room_join_time`, `siropu_chat_status`, `siropu_chat_is_sanctioned`, `siropu_chat_message_count`, `siropu_chat_last_activity`, `snog_flag`, `thdonate_total_donation`, `thdonate_total_public_donation`, `thdonate_total_anonymous_donation`, `thdonate_num_donation`, `thdonate_num_public_donation`, `thdonate_num_anonymous_donation`, `xfmg_album_count`, `xfmg_media_count`, `xfmg_media_quota`, `xfrm_resource_count`, `xp_nt_see_newstickers`, `andy_most_reactions_count`, `grgi_user_group_icons`, `snog_forms`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src\XF\Db\Mysqli\Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src\XF\Db\Mysqli\Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src\XF\Db\Mysqli\Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src\XF\Db\AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src\XF\Db\AbstractAdapter.php(218): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#5 src\XF\Mvc\Entity\Entity.php(1510): XF\Db\AbstractAdapter->insert('xf_user', Array, false)
#6 src\XF\Mvc\Entity\Entity.php(1242): XF\Mvc\Entity\Entity->_saveToSource()
#7 src\XF\Service\User\Registration.php(298): XF\Mvc\Entity\Entity->save()
#8 src\XF\Service\ValidateAndSavableTrait.php(40): XF\Service\User\Registration->_save()
#9 src\XF\Pub\Controller\Register.php(422): XF\Service\User\Registration->save()
#10 src\addons\BlackTea\SteamAuth\XF\Pub\Controller\Register.php(50): XF\Pub\Controller\Register->actionRegister()
#11 src\XF\Mvc\Dispatcher.php(350): BlackTea\SteamAuth\XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#12 src\XF\Mvc\Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(Snog\CountryBan\XF\Pub\Controller\Register), NULL)
#13 src\XF\Mvc\Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Snog\CountryBan\XF\Pub\Controller\Register), NULL)
#14 src\XF\Mvc\Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#15 src\XF\App.php(2300): XF\Mvc\Dispatcher->run()
#16 src\XF.php(488): XF\App->run()
#17 index.php(20): XF::runApp('XF\\Pub\\App')
#18 {main}
Try running this via SSH in your forum folder: php cmd.php xf-addon:install-step DBTech/Mail 2
 
Try running this via SSH in your forum folder: php cmd.php xf-addon:install-step DBTech/Mail 2
I completely forgot how to do this! I am on a Windows Machine... I thought I did it with CMD or SHELL but it's not working when I set it to the root directory of my forums but its not working keeps saying OpenSSL is already installed! ;(

Code:
xeon1812@WIN-9SQRCA2QBAF C:\htdocs\cozworld
# php cmd.php xf-addon:install-step DBTech/Mail 2
PHP Warning:  Module "openssl" is already loaded in Unknown on line 0

Warning: Module "openssl" is already loaded in Unknown on line 0
Running Setup class method installStep2()... done.

xeon1812@WIN-9SQRCA2QBAF C:\htdocs\cozworld
#
 
Last edited:
I completely forgot how to do this! I am on a Windows Machine... I thought I did it with CMD or SHELL but it's not working when I set it to the root directory of my forums but its not working keeps saying OpenSSL is already installed! ;(

Code:
xeon1812@WIN-9SQRCA2QBAF C:\htdocs\cozworld
# php cmd.php xf-addon:install-step DBTech/Mail 2
PHP Warning:  Module "openssl" is already loaded in Unknown on line 0

Warning: Module "openssl" is already loaded in Unknown on line 0
Running Setup class method installStep2()... done.

xeon1812@WIN-9SQRCA2QBAF C:\htdocs\cozworld
#
That means you have a duplicate extension=openssl.dll line in your php.ini.
 
DragonByte Tech updated [DBTech] DragonByte Mail with a new update entry:

4.6.0 Beta 2

Update highlights

As mentioned in the previous update, this change now implements the "Activity Summary" feature into the Digest. If you have any add-ons, official or 3rd party, that adds new activity summary sections, they will now work in DB Mail's digest with no action required on our part.

In order to implement this, you must go to the new "Digest sections" page and add the sections, similar to how you add activity summary sections to XF's default activity summary email...

Read the rest of this update entry...
 
@DragonByte Tech

I can't seem to get a test digest to send (using the button to the right of the digest). I'm using the PHP built-in mail system, and I've verified I can send emails via Communication > Email Users. Not sure if tests are supposed to show up in the Digest log, but they aren't. XF 2.2.3 P1 and DB Mail 4.6.0 B2.

Any ideas?
 
@DragonByte Tech

I can't seem to get a test digest to send (using the button to the right of the digest). I'm using the PHP built-in mail system, and I've verified I can send emails via Communication > Email Users. Not sure if tests are supposed to show up in the Digest log, but they aren't. XF 2.2.3 P1 and DB Mail 4.6.0 B2.

Any ideas?

Same,

I just tested it several times with build 4.6.0 Beta 2 it's not working

My send mail works fine tested through xenforo communicated sent email message to self showed up immediately.
 
Same,

I just tested it several time with build 4.6.0 Beta 2 it's not working

My send mail works fine tested through xenforo communicated sent email message to self showed up immediately.

Good to know I'm not alone! I must have spent an hour and a half trying to get it to work 🤣
 
@DragonByte Tech

I can't seem to get a test digest to send (using the button to the right of the digest). I'm using the PHP built-in mail system, and I've verified I can send emails via Communication > Email Users. Not sure if tests are supposed to show up in the Digest log, but they aren't. XF 2.2.3 P1 and DB Mail 4.6.0 B2.

Any ideas?
When you say it doesn't send, what specifically do you mean? Is the page loading endlessly, or does it say it's sent but nothing shows up in your inbox?

If it's the latter, check your mail queue table in the database.
 
When you say it doesn't send, what specifically do you mean? Is the page loading endlessly, or does it say it's sent but nothing shows up in your inbox?

If it's the latter, check your mail queue table in the database.

It's the latter, and I'll take a look when I get home :)
 
Top Bottom