I cleared local caches though when testing. Redis and CF.I found the problem. It looks like the issue occurs when you use xenforo cache since psr is already present but it's an older version than the one in mobile detect.
Fixed an error with mobile detect 4.x when XF cache is enabled.
Siropu updated Ads Manager 2 by Siropu with a new update entry:
Bug Fix
Read the rest of this update entry...
Are you signed in as an admin?I just noticed a bug when using stat access:
/ads-manager/statistics/116d34f80c46820af0fad115123abc/daily?ad_id=5
if this is my link,
I can change the ad_id and have access to the statistics of any ad I want.
From the usage of the access key I understand the intention was to allow access to only the ads in the key.
Using version 2.4.17.
Was this fixed in a later version?
no. I was not logged in at all.Are you signed in as an admin?
Just as your screenshot..
<xf:if is="$post.user_id == $ad.user_id">
Show this content if the author of the post is the owner of the ad.
<xf:macro id="siropu_ads_manager_ad_macros::ad_unit" arg-position="tx_partner_signatur" />
</xf:if>
XF\Db\Exception: MySQL query error [1264]: Out of range value for column 'invoice_amount' at row 1 src/XF/Db/AbstractStatement.php:230
Tarafından: hakyangler 10.03.2025 09:09'de
Yığın izleme
INSERT INTO `xf_siropu_ads_manager_promo_code` (`promo_code`, `value`, `type`, `package`, `invoice_amount`, `active_date`, `expire_date`, `user_usage_limit`, `total_usage_limit`, `user_criteria`, `enabled`, `create_date`, `usage_count`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------
#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1264, '22003')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1264, '22003')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(219): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1572): XF\Db\AbstractAdapter->insert('xf_siropu_ads_m...', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1300): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/XF/Mvc/FormAction.php(72): XF\Mvc\Entity\Entity->save(true, false)
#7 src/XF/Mvc/FormAction.php(190): XF\Mvc\FormAction->XF\Mvc\{closure}(Object(XF\Mvc\FormAction))
#8 src/addons/Siropu/AdsManager/Admin/Controller/PromoCode.php(44): XF\Mvc\FormAction->run()
#9 src/XF/Mvc/Dispatcher.php(362): Siropu\AdsManager\Admin\Controller\PromoCode->actionSave(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('Siropu\\AdsManag...', 'Save', Object(XF\Mvc\RouteMatch), Object(Siropu\AdsManager\Admin\Controller\PromoCode), NULL)
#11 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Siropu\AdsManager\Admin\Controller\PromoCode), NULL)
#12 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(2826): XF\Mvc\Dispatcher->run()
#14 src/XF.php(806): XF\App->run()
#15 admin.php(15): XF::runApp('XF\\Admin\\App')
#16 {main}
Durum isteği
array(4) {
["url"] => string(39) "/admin.php?ads-manager/promo-codes/save"
["referrer"] => string(60) "https://oltamisina.com/admin.php?ads-manager/promo-codes/add"
["_GET"] => array(1) {
["ads-manager/promo-codes/save"] => string(0) ""
}
["_POST"] => array(14) {
["_xfToken"] => string(8) "********"
["promo_code"] => string(4) "OM50"
["value"] => string(2) "50"
["type"] => string(7) "percent"
["package"] => array(1) {
[0] => string(1) "6"
}
["invoice_amount"] => string(4) "1500"
["active_date"] => string(0) ""
["expire_date"] => string(0) ""
["user_usage_limit"] => string(1) "1"
["total_usage_limit"] => string(1) "1"
["enabled"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
["_xfWithData"] => string(1) "1"
["_xfRequestUri"] => string(38) "/admin.php?ads-manager/promo-codes/add"
}
}
Hello @Siropu
error when trying to create a promo code
View attachment 320002 View attachment 320003
This error occurs when an amount is entered here. Example : 1500
View attachment 320004
Code:XF\Db\Exception: MySQL query error [1264]: Out of range value for column 'invoice_amount' at row 1 src/XF/Db/AbstractStatement.php:230 Tarafından: hakyangler 10.03.2025 09:09'de Yığın izleme INSERT INTO `xf_siropu_ads_manager_promo_code` (`promo_code`, `value`, `type`, `package`, `invoice_amount`, `active_date`, `expire_date`, `user_usage_limit`, `total_usage_limit`, `user_criteria`, `enabled`, `create_date`, `usage_count`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ------------ #0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1264, '22003') #1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1264, '22003') #2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute() #3 src/XF/Db/AbstractAdapter.php(219): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array) #4 src/XF/Mvc/Entity/Entity.php(1572): XF\Db\AbstractAdapter->insert('xf_siropu_ads_m...', Array, false) #5 src/XF/Mvc/Entity/Entity.php(1300): XF\Mvc\Entity\Entity->_saveToSource() #6 src/XF/Mvc/FormAction.php(72): XF\Mvc\Entity\Entity->save(true, false) #7 src/XF/Mvc/FormAction.php(190): XF\Mvc\FormAction->XF\Mvc\{closure}(Object(XF\Mvc\FormAction)) #8 src/addons/Siropu/AdsManager/Admin/Controller/PromoCode.php(44): XF\Mvc\FormAction->run() #9 src/XF/Mvc/Dispatcher.php(362): Siropu\AdsManager\Admin\Controller\PromoCode->actionSave(Object(XF\Mvc\ParameterBag)) #10 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('Siropu\\AdsManag...', 'Save', Object(XF\Mvc\RouteMatch), Object(Siropu\AdsManager\Admin\Controller\PromoCode), NULL) #11 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Siropu\AdsManager\Admin\Controller\PromoCode), NULL) #12 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch)) #13 src/XF/App.php(2826): XF\Mvc\Dispatcher->run() #14 src/XF.php(806): XF\App->run() #15 admin.php(15): XF::runApp('XF\\Admin\\App') #16 {main} Durum isteği array(4) { ["url"] => string(39) "/admin.php?ads-manager/promo-codes/save" ["referrer"] => string(60) "https://oltamisina.com/admin.php?ads-manager/promo-codes/add" ["_GET"] => array(1) { ["ads-manager/promo-codes/save"] => string(0) "" } ["_POST"] => array(14) { ["_xfToken"] => string(8) "********" ["promo_code"] => string(4) "OM50" ["value"] => string(2) "50" ["type"] => string(7) "percent" ["package"] => array(1) { [0] => string(1) "6" } ["invoice_amount"] => string(4) "1500" ["active_date"] => string(0) "" ["expire_date"] => string(0) "" ["user_usage_limit"] => string(1) "1" ["total_usage_limit"] => string(1) "1" ["enabled"] => string(1) "1" ["_xfResponseType"] => string(4) "json" ["_xfWithData"] => string(1) "1" ["_xfRequestUri"] => string(38) "/admin.php?ads-manager/promo-codes/add" } }
Can anyone help me with this?View attachment 319959I am having issues displaying packages. Only sticky thread are shown whereas I have other packages also listed and available to every user group.
We use essential cookies to make this site work, and optional cookies to enhance your experience.