[TH] Donate 1.1.8 Patch Level 1

[Tasanar]

Same

 

[t0daY]

same

 

[Lukas W.]

In addition I got this error:

• XF\Db\Exception: MySQL statement prepare error [1146]: Table 'theaocdu_xenforo.xf_th_donate_campaign' doesn't exist
• src/XF/Db/AbstractStatement.php:212

Thanks for reporting that issue. We're currently investigating as to why this is happening. To work around it, please open your database manager and rename the following tables:
xf_thdonate_milestone to xf_th_donate_milestone
xf_thdonate_campaign to xf_th_donate_campaign
xf_thdonate_donation to xf_th_donate_donation
xf_thdonate_campaign_user to xf_th_donate_campaign_user

If there are any errors logged in your ACP error log after updating, prior to running into the bug reported above, please send them to us.

 

[Jake B.]

I also have the same as above, it says "th_donate_earnings".

In addition I got this error:

• XF\Db\Exception: MySQL statement prepare error [1146]: Table 'theaocdu_xenforo.xf_th_donate_campaign' doesn't exist
• src/XF/Db/AbstractStatement.php:212

Stack trace
            SELECT `xf_th_donate_campaign`.*
            FROM `xf_th_donate_campaign`
           
            WHERE (`xf_th_donate_campaign`.`progress_reset_date` <= 1540719122) AND (`xf_th_donate_campaign`.`active` = 1)
           
       
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1146, '42S02')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1146, '42S02')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Mvc/Entity/Finder.php(1163): XF\Db\AbstractAdapter->query('\n\t\t\tSELECT `xf_...')
#5 src/addons/ThemeHouse/Donate/Cron/Campaign.php(16): XF\Mvc\Entity\Finder->fetch()
#6 [internal function]: ThemeHouse\Donate\Cron\Campaign::reset(Object(XF\Entity\CronEntry))
#7 src/XF/Job/Cron.php(35): call_user_func(Array, Object(XF\Entity\CronEntry))
#8 src/XF/Job/Manager.php(241): XF\Job\Cron->run(7.9999990463257)
#9 src/XF/Job/Manager.php(187): XF\Job\Manager->runJobInternal(Array, 7.9999990463257)
#10 src/XF/Job/Manager.php(76): XF\Job\Manager->runJobEntry(Array, 7.9999990463257)
#11 job.php(14): XF\Job\Manager->runQueue(false, 8)
#12 {main}

Request state
array(4) {
  ["url"] => string(8) "/job.php"
  ["referrer"] => string(49) "https://www.theaocdungeon.com/online/?type=member"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

Same

same

We think this may have been because a cron ran after you uploaded the files, but before the tables were actually renamed. If you go to your campaign page now does it work?

 

[Frode789]

Thanks for reporting that issue. We're currently investigating as to why this is happening. To work around it, please open your database manager and rename the following tables:
xf_thdonate_milestone to xf_th_donate_milestone
xf_thdonate_campaign to xf_th_donate_campaign
xf_thdonate_donation to xf_th_donate_donation
xf_thdonate_campaign_user to xf_th_donate_campaign_user

I do this before I upgrade to 1.0.4 patch level 1?

 

[Lukas W.]

I do this before I upgrade to 1.0.4 patch level 1?

Yes. If the tables are already renamed, then you can safely ignore the error you received.

 

[Tasanar]

I bad with all the technical stuff

 

[Nirjonadda]

I bad with all the technical stuff

What do you mean? I have installed in my live site and I am not getting any issue or error.

 

[Tasanar]

The issue seems to be those who UPGRADED and had a re-occurring campaign that had been running for a while, going.

 

[Spartan]

Can this be used to automatically move a user to a specific usergroup once they've donated?

 

[Tasanar]

Will you guys be releasing an updated package to those affected by the last bug?

 

[Lukas W.]

Which bug are you experiencing? As Jake explained in his last post, the error posted by Frode was a one-time issue, that happened because a cron related to donate was run after uploading the files and before the update was run.

 

[Tasanar]

All the ones I screen shot above

 

[Tasanar]

It shows my total donations, gives errors, I have an open help ticket too. My issue has not been fixed. I do not know how to edit my data base. A lot of people experienced the same issue.

 

[Tasanar]

https://xenforo.com/community/threads/th-donate-paid.145264/page-16#post-1291888

 

[Lukas W.]

Oh, we published a patch level update yesterday, but it seems we forgot to post the notification here. You can download the latest release from themehouse, that should fix those bugs.

 

[ThemeHouse]

ThemeHouse updated [TH] Donate with a new update entry:

Version 1.0.4 Patch Level 1 released!

Bugs fixed:

• Fixed an issue that would prevent people from interacting with campaigns if they did not have [TH] Reactions installed.
• Fixed an issue that would potentially prevent people from upgrading to 1.0.4 or higher when attempting to upgrade from the XenForo 1 version or previously having upgraded from the XF1 version.
• Fixed an "attempt to convert null to float" error potentially being triggered when rebuilding users donation amounts.

Read the rest of this update entry...

 

[Tasanar]

Thank you Lukas!

 

[Tasanar]

Okay so everything works and appears much better now. Rebuilding user cache also worked fine.



How do we disable TOTAL earnings shown? As brought up by a few people above this may not be something everyone wants public. For the month is fine, total no, as we use a re-occurring monthly one. This makes it seem, at first glance, that we bring in a lot more than we really do.

 

[Lukas W.]

You can edit the template and remove it manually, if you wish to hide it.