Confirmation link in the email that a user receive after they reset their passwords is redirecting to a blank page with only this text (Unknown Column ‘Password’ in ‘Field List’)
This is the exact case after the user submit the form of changing password, it redirect them to the same page.
in both cases the password gets reset and changed, but the only problem is the page the user sees after clicking on the confirmation link or submitting the change password form
Hello there.
What version of MODX do you have installed?
Are you using the Login extra, if so what version?
That error means that the ‘Password’ field doesn’t exist in the table the script is trying to access.
Would you please paste the logs from Manage>Reports>Error Log available in the MODX Manager?
Censor any sensitive data in the log before posting.
I am using modx 2.7.1
yeah i am using login extra with version 1.9.9-pl
the error log does not show any related info about this error but here what i get
[2021-03-16 17:48:42] (ERROR @ /var/www/html/core/model/modx/modx.class.php : 1031) `[[+id]]` is not a valid integer and may not be passed to makeUrl()
[2021-03-16 17:48:42] (ERROR in resource 6409 @ /var/www/html/core/model/modx/modparser.class.php : 1373) Bad link tag `[[~[[+id]]]]` encountered
[2021-03-16 17:48:42] (ERROR in resource 6409 @ /var/www/html/core/model/modx/modparser.class.php : 1373) Bad link tag `[[~]]` encountered
[2021-03-16 17:48:45] (ERROR in resource 28165 @ /var/www/html/core/model/modx/modparser.class.php : 1373) Bad link tag `[[~]]` encountered
[2021-03-16 17:48:49] (ERROR @ /var/www/html/core/model/modx/modx.class.php : 1031) `[[+id]]` is not a valid integer and may not be passed to makeUrl()
[2021-03-16 17:48:49] (ERROR in resource 129476 @ /var/www/html/core/model/modx/modparser.class.php : 1373) Bad link tag `[[~[[+id]]]]` encountered
[2021-03-16 17:48:49] (ERROR in resource 129476 @ /var/www/html/core/model/modx/modparser.class.php : 1373) Bad link tag `[[~]]` encountered
[2021-03-16 17:48:51] (ERROR in resource 5939 @ /var/www/html/core/model/modx/modparser.class.php : 1373) Bad link tag `[[~]]` encountered
[2021-03-16 17:48:53] (ERROR in resource 55625 @ /var/www/html/core/model/modx/modparser.class.php : 1373) Bad link tag `[[~]]` encountered
[2021-03-16 17:48:53] (ERROR in resource 55625 @ /var/www/html/core/model/modx/modparser.class.php : 1373) Bad link tag `[[~]]` encountered
[2021-03-16 17:48:55] (ERROR @ /var/www/html/core/cache/includes/elements/modplugin/20.include.cache.php : 300) sendRedirect method parameter $type is deprecated since version 2.0.5. Use type in options array instead.
[2021-03-16 17:48:55] (ERROR @ /var/www/html/core/cache/includes/elements/modplugin/20.include.cache.php : 300) sendRedirect method parameter $responseCode is deprecated since version 2.0.5. Use responseCode in options array instead.
[2021-03-16 17:48:55] (ERROR @ /var/www/html/core/model/modx/modx.class.php : 1031) `Etudier au Chypre du Nord` is not a valid integer and may not be passed to makeUrl()
[2021-03-16 17:48:55] (ERROR in resource 49672 @ /var/www/html/core/model/modx/modparser.class.php : 1373) Bad link tag `[[~Etudier au Chypre du Nord]]` encountered
[2021-03-16 17:48:55] (ERROR @ /var/www/html/core/cache/includes/elements/modsnippet/137.include.cache.php : 19) PHP warning: min(): Array must contain at least one element
[2021-03-16 17:48:55] (ERROR @ /var/www/html/core/cache/includes/elements/modsnippet/138.include.cache.php : 19) PHP warning: max(): Array must contain at least one element
[2021-03-16 17:48:56] (ERROR in resource 20086 @ /var/www/html/core/model/modx/modparser.class.php : 1373) Bad link tag `[[~]]` encountered
the activation link that being sent in the password reset email is actually activating the password but still it redirects to that page with unknown column password in ‘Field list’
do you advice to do anything?
Just a hunch, but do you use mysql or sqlsrv?
using mysql
mysql Ver 14.14 Distrib 5.7.33,
Hi, I’m seeing some errors like this ``Etudier au Chypre du Nord is not a valid integer and may not be passed to makeUrl() related to the parameter send to makeUrl, is there a chance that you have a redirect after processing the request, but such redirect isn’t working due some wrong parameters sent? that’s my best guess without seeing some code.
Also, on the Unknown Column ‘Password’ in ‘Field List’ message, its printed like a unhandled exepcion, or just some plan echo from PHP?