[DBTech] DragonByte Mail

[DBTech] DragonByte Mail [Paid] 5.0.3

No permission to buy (€14.95)
Overview FAQ Updates (48) Reviews (3) History Discussion
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 :)
 
ichpen said:
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 :)
Click to expand...
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.
 
DragonByte Tech said:
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.
Click to expand...

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.
 
snoopy5 said:
Done.

@ others: please upvote it there.
Click to expand...

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:

www.dragonbyte-tech.com

Pending - Enhance throtteling - offer fields for # minutes and # of emails within these minutes

Please add more flexiblity with throtteling the amount of emails sent. Not only by hour (ie. a field to put any kind of number for minutes in it) and the amount of emails which shall be sent within that given timeperiod. I.e. 700 emails every 10 minutes. It is important that the admin can...
www.dragonbyte-tech.com www.dragonbyte-tech.com

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}
 
CoZmicShReddeR said:
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}
Click to expand...
Try running this via SSH in your forum folder: php cmd.php xf-addon:install-step DBTech/Mail 2
 
DragonByte Tech said:
Try running this via SSH in your forum folder: php cmd.php xf-addon:install-step DBTech/Mail 2
Click to expand...
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:
CoZmicShReddeR said:
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
#
Click to expand...
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...
Click to expand...

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?
 
Joe Link said:
@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?
Click to expand...

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.
 
CoZmicShReddeR said:
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.
Click to expand...

Good to know I'm not alone! I must have spent an hour and a half trying to get it to work 🤣
 
Joe Link said:
@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?
Click to expand...
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.
 
DragonByte Tech said:
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.
Click to expand...

It's the latter, and I'll take a look when I get home :)
 
You must log in or register to reply here.

Similar threads

DragonByte Tech
[DBTech] DragonByte Bluesky Poster
2
Replies
29
Views
343
mrdoitnyce
mrdoitnyce
VisEntities
DBTech DragonByte eCommerce vs XFA RM Marketplace?
Replies
0
Views
57
VisEntities
VisEntities
DragonByte Tech
[DBTech] DragonByte WebP
2
Replies
21
Views
1K
Yenxji
Yenxji
DragonByte Tech
[DBTech] DragonByte Stripe Checkout
2
Replies
30
Views
801
DragonByte Tech
DragonByte Tech
DragonByte Tech
[DBTech] DragonByte Social Groups [Paid]
5 6 7
Replies
135
Views
7K
DragonByte Tech
DragonByte Tech
Back
Top Bottom