- XF\Db\Exception: Job LiamW\AccountDeleteeleteAccounts: MySQL query error [1265]: Daten abgeschnitten für Feld 'status' in Zeile 1
- src/XF/Db/AbstractStatement.php:217
- Generiert von: Unbekanntes Konto
- 17 Juni 2019 um 19:44
Stack-Trace
UPDATExf_liamw_accountdelete_account_deletions
SETstatus
= ?,completion_date
= ? WHEREdeletion_id
= 1
------------
#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1265, '01000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1265, '01000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(322): XF\Db\AbstractAdapter->query('UPDATE `xf_lia...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1457): XF\Db\AbstractAdapter->update('xf_liamw_accoun...', Array, 'deletion_id
=...')
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/addons/LiamW/AccountDelete/Listener.php(68): XF\Mvc\Entity\Entity->save()
#7 [internal function]: LiamW\AccountDelete\Listener::userEntityPostDelete(Object(SV\ReportImprovements\XF\Entity\User))
#8 src/XF/Extension.php(50): call_user_func_array(Array, Array)
#9 src/XF.php(721): XF\Extension->fire('entity_post_del...', Array, 'XF\\Entity\\User')
#10 src/XF/Mvc/Entity/Entity.php(1587): XF::fire('entity_post_del...', Array, 'XF\\Entity\\User')
#11 src/XF/Service/User/Delete.php(71): XF\Mvc\Entity\Entity->delete(true, false)
#12 src/addons/LiamW/AccountDelete/Service/AccountDelete.php(177): XF\Service\User\Delete->delete()
#13 src/addons/LiamW/AccountDelete/Job/DeleteAccounts.php(38): LiamW\AccountDelete\Service\AccountDelete->executeDeletion()
#14 src/XF/Job/Manager.php(253): LiamW\AccountDelete\Job\DeleteAccounts->run(G)
#15 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#16 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry(Array, G)
#17 job.php(42): XF\Job\Manager->runQueue(false, 8)
#18 {main}
------------------
Status der Anfrage
array(4) {
["url"] => string(8) "/job.php"
["referrer"] => string(40) "https://www.my.org/account/delete"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
Daten abgeschnitten für Feld 'status' in Zeile 1
Yes, and i have edited my last Posting with some AdminsettingsDoes this mean truncated?
Server error log
ErrorException: [E_NOTICE] Undefined index: mode src/addons/LiamW/AccountDelete/Service/AccountDelete.php:117
Generated by: Unknown account Jun 19, 2019 at 9:23 AM
Stack trace
#0 src/addons/LiamW/AccountDelete/Service/AccountDelete.php(117): XF::handlePhpError(8, '[E_NOTICE] Unde...', '/home/nginx/dom...', 117, Array)
#1 src/addons/LiamW/AccountDelete/Job/DeleteAccounts.php(38): LiamW\AccountDelete\Service\AccountDelete->executeDeletion()
#2 src/XF/Job/Manager.php(253): LiamW\AccountDelete\Job\DeleteAccounts->run(G)
#3 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#4 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry(Array, G)
#5 job.php(42): XF\Job\Manager->runQueue(false, 8)
#6 {main}
Request state
array(4) {
["url"] => string(8) "/job.php"
["referrer"] => string(41) "https://squattheplanet.com/account/delete"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
Server error log
UnexpectedValueException: Job LiamW\AccountDelete:DeleteAccounts: Unknown option value encountered during member deletion src/addons/LiamW/AccountDelete/Service/AccountDelete.php:190
Generated by: Unknown account Jun 19, 2019 at 9:23 AM
Stack trace
#0 src/addons/LiamW/AccountDelete/Job/DeleteAccounts.php(38): LiamW\AccountDelete\Service\AccountDelete->executeDeletion()
#1 src/XF/Job/Manager.php(253): LiamW\AccountDelete\Job\DeleteAccounts->run(G)
#2 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#3 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry(Array, G)
#4 job.php(42): XF\Job\Manager->runQueue(false, 8)
#5 {main}
Request state
array(4) {
["url"] => string(8) "/job.php"
["referrer"] => string(41) "https://squattheplanet.com/account/delete"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
That’s strange. Could you go to your user options page and hit the save button? It would seem the options for this add on aren’t in the correct format.
i'm having a really hard time finding where the options page is for this addon?
This account is scheduled for deletion and will be deleted on Jun 17, 2019 at 5:29 PM(User deletion log)
/admin.php?logs/account-deletion/ for this User == Pending
XF\Db\Exception: Job LiamW\AccountDelete:DeleteAccounts: MySQL query error [1265]: Data truncated for column 'status' at row 1 src/XF/Db/AbstractStatement.php:217
Generated by: Unknown account Jun 25, 2019 at 4:15 PM
Stack trace
UPDATE `xf_liamw_accountdelete_account_deletions` SET `status` = ?, `completion_date` = ? WHERE `deletion_id` = 2
------------
#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1265, '01000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1265, '01000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(322): XF\Db\AbstractAdapter->query('UPDATE `xf_lia...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1457): XF\Db\AbstractAdapter->update('xf_liamw_accoun...', Array, '`deletion_id` =...')
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/addons/LiamW/AccountDelete/Listener.php(68): XF\Mvc\Entity\Entity->save()
#7 [internal function]: LiamW\AccountDelete\Listener::userEntityPostDelete(Object(SV\DailyStatistics\XF\Entity\User))
#8 src/XF/Extension.php(50): call_user_func_array(Array, Array)
#9 src/XF.php(721): XF\Extension->fire('entity_post_del...', Array, 'XF\\Entity\\User')
#10 src/XF/Mvc/Entity/Entity.php(1587): XF::fire('entity_post_del...', Array, 'XF\\Entity\\User')
#11 src/XF/Service/User/Delete.php(71): XF\Mvc\Entity\Entity->delete(true, false)
#12 src/addons/LiamW/AccountDelete/Service/AccountDelete.php(177): XF\Service\User\Delete->delete()
#13 src/addons/LiamW/AccountDelete/Job/DeleteAccounts.php(38): LiamW\AccountDelete\Service\AccountDelete->executeDeletion()
#14 src/XF/Job/Manager.php(253): LiamW\AccountDelete\Job\DeleteAccounts->run(G)
#15 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#16 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry(Array, G)
#17 job.php(42): XF\Job\Manager->runQueue(false, 8)
#18 {main}
- Fix bugs related to incorrect database field definitions
- Attempt to make the scheduled jobs more resilient to errors
We use essential cookies to make this site work, and optional cookies to enhance your experience.