Upgrade from 5.7.5.13 to. 8.1 error

Permalink 16 14 Browser Info Environment
I had an error when I try to upgrade my site from 5.7.5.13 to 8.1 (or 8.0)

un column are missing in DB I suppose ?

An exception occurred while executing 'select uID, uIsActive, uLastPasswordChange, uIsPasswordReset from Users where uID = ? and uName = ?' with params ["1", "admin"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'uIsPasswordReset' in 'field list'


Status: New
gavthompson replied on at Permalink Reply
gavthompson
Hi Schnak,

Did you ever over come this issue? as I have the same problem.
Schnak replied on at Permalink Reply
Nop.. :-/
gavthompson replied on at Permalink Reply
gavthompson
Here is some debug info.

K:\7.13 - 8.1\UwAmp\www\updates\concrete5-8.1.0\concrete\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php
            case '1062':
            case '1557':
            case '1569':
            case '1586':
                return new Exception\UniqueConstraintViolationException($message, $exception);
            case '1054':
            case '1166':
            case '1611':
                return new Exception\InvalidFieldNameException($message, $exception);
            case '1052':
            case '1060':
            case '1110':
                return new Exception\NonUniqueFieldNameException($message, $exception);
            case '1064':
TheRealSean replied on at Permalink Reply
TheRealSean
Also receiving this

concrete5 Environment Information

# concrete5 Version
Core Version - 5.7.5.13
Version Installed - 5.7.5.13
Database Version - 20160615000000

# concrete5 Packages
None

# concrete5 Overrides
blocks/autonav/templates/nav-header/view.php, blocks/autonav/templates/nav-header, blocks/autonav/templates, blocks/autonav, blocks/external_form/form/contact_form.php, blocks/external_form/form/controller/contact_form.php, blocks/external_form/form/controller, blocks/external_form/form, blocks/external_form, blocks/page_list/templates/portfolio/view.php, blocks/page_list/templates/portfolio, blocks/page_list/templates/portfolio-homepage/view.php, blocks/page_list/templates/portfolio-homepage, blocks/page_list/templates, blocks/page_list, languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/de_DE/LC_MESSAGES/messages.mo, languages/de_DE/LC_MESSAGES, languages/de_DE, languages/el_GR/LC_MESSAGES/messages.mo, languages/el_GR/LC_MESSAGES, languages/el_GR, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI, languages/fr_FR/LC_MESSAGES/messages.mo, languages/fr_FR/LC_MESSAGES, languages/fr_FR, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, languages/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/sl_SI/LC_MESSAGES/messages.mo, languages/sl_SI/LC_MESSAGES, languages/sl_SI, languages/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/tr_TR/LC_MESSAGES/messages.mo, languages/tr_TR/LC_MESSAGES, languages/tr_TR, themes/studiosc/blocks/autonav/templates/nav-header/view.php, themes/studiosc/blocks/autonav/templates/nav-header, themes/studiosc/blocks/autonav/templates, themes/studiosc/blocks/autonav, themes/studiosc/blocks/external_form/form/contact_form.php, themes/studiosc/blocks/external_form/form/controller/contact_form.php, themes/studiosc/blocks/external_form/form/controller, themes/studiosc/blocks/external_form/form, themes/studiosc/blocks/external_form, themes/studiosc/blocks/page_list/templates/portfolio/view.php, themes/studiosc/blocks/page_list/templates/portfolio, themes/studiosc/blocks/page_list/templates/portfolio-homepage/view.php, themes/studiosc/blocks/page_list/templates/portfolio-homepage, themes/studiosc/blocks/page_list/templates, themes/studiosc/blocks/page_list, themes/studiosc/blocks, themes/studiosc/contact.html, themes/studiosc/contact.php, themes/studiosc/css/animate.css, themes/studiosc/css/bootstrap.min.css, themes/studiosc/css/fontello.css, themes/studiosc/css/main.less, themes/studiosc/css/main.min.css, themes/studiosc/css, themes/studiosc/default.php, themes/studiosc/description.txt, themes/studiosc/elements/footer.php, themes/studiosc/elements/footer_bottom.php, themes/studiosc/elements/header.php, themes/studiosc/elements/header_top.php, themes/studiosc/elements, themes/studiosc/fonts/glyphicons-halflings-regular.eot, themes/studiosc/fonts/glyphicons-halflings-regular.svg, themes/studiosc/fonts/glyphicons-halflings-regular.ttf, themes/studiosc/fonts/glyphicons-halflings-regular.woff, themes/studiosc/fonts/icons/fontello.eot, themes/studiosc/fonts/icons/fontello.svg, themes/studiosc/fonts/icons/fontello.ttf, themes/studiosc/fonts/icons/fontello.woff, themes/studiosc/fonts/icons, themes/studiosc/fonts/Lato-Bold.eot, themes/studiosc/fonts/Lato-Bold.svg, themes/studiosc/fonts/Lato-Bold.ttf, themes/studiosc/fonts/Lato-Bold.woff, themes/studiosc/fonts/Lato-Light.eot, themes/studiosc/fonts/Lato-Light.svg, themes/studiosc/fonts/Lato-Light.ttf, themes/studiosc/fonts/Lato-Light.woff, themes/studiosc/fonts/Lato-LightItalic.eot, themes/studiosc/fonts/Lato-LightItalic.svg, themes/studiosc/fonts/Lato-LightItalic.ttf, themes/studiosc/fonts/Lato-LightItalic.woff, themes/studiosc/fonts/Lato-Regular.eot, themes/studiosc/fonts/Lato-Regular.svg, themes/studiosc/fonts/Lato-Regular.ttf, themes/studiosc/fonts/Lato-Regular.woff, themes/studiosc/fonts/stylesheet.css, themes/studiosc/fonts, themes/studiosc/home.php, themes/studiosc/img/apple-touch-icon.png, themes/studiosc/img/arrow-top.svg, themes/studiosc/img/bg-contact.jpg, themes/studiosc/img/bg-footer.jpg, themes/studiosc/img/bg1.jpg, themes/studiosc/img/bullet.svg, themes/studiosc/img/clients/b28.svg, themes/studiosc/img/clients/emile-weber.svg, themes/studiosc/img/clients/ep-vehicules.svg, themes/studiosc/img/clients/il-cosmetics.svg, themes/studiosc/img/clients/netway.svg, themes/studiosc/img/clients/PT.svg, themes/studiosc/img/clients/remax.svg, themes/studiosc/img/clients/sword.svg, themes/studiosc/img/clients/ubiq.svg, themes/studiosc/img/clients, themes/studiosc/img/developpement.png, themes/studiosc/img/favicon.ico, themes/studiosc/img/grid.svg, themes/studiosc/img/icon-frontend.png, themes/studiosc/img/icon-print.png, themes/studiosc/img/icon-web.png, themes/studiosc/img/img-projet.jpg, themes/studiosc/img/img-projet2.jpg, themes/studiosc/img/img-projet3.jpg, themes/studiosc/img/loading.gif, themes/studiosc/img/loading2.gif, themes/studiosc/img/logo.png, themes/studiosc/img/logo.svg, themes/studiosc/img/logo2.png, themes/studiosc/img/logo2.svg, themes/studiosc/img/logo3.svg, themes/studiosc/img/magnifying-glass.svg, themes/studiosc/img/mail.svg, themes/studiosc/img/mail2.svg, themes/studiosc/img/marketing.png, themes/studiosc/img/old/logo.png, themes/studiosc/img/old/logo2.png, themes/studiosc/img/old, themes/studiosc/img/photo.jpg, themes/studiosc/img/print.png, themes/studiosc/img/reseaux.png, themes/studiosc/img/shadow.png, themes/studiosc/img/tel.svg, themes/studiosc/img/testimonial/evolution-continue.png, themes/studiosc/img/testimonial/rizom.png, themes/studiosc/img/testimonial, themes/studiosc/img/web.png, themes/studiosc/img, themes/studiosc/index.html, themes/studiosc/infos.rtf, themes/studiosc/js/bootstrap.min.js, themes/studiosc/js/imagesloaded.min.js, themes/studiosc/js/jquery.isotope.min.js, themes/studiosc/js/jquery.min.js, themes/studiosc/js/main.js, themes/studiosc/js/placeholders.jquery.min.js, themes/studiosc/js/waypoints.min.js, themes/studiosc/js, themes/studiosc/page_forbidden.php, themes/studiosc/page_not_found.php, themes/studiosc/page_theme.php, themes/studiosc/portfolio.php, themes/studiosc/projet.php, themes/studiosc/projets.html, themes/studiosc/services.html, themes/studiosc/services.php, themes/studiosc/thumbnail.png, themes/studiosc, blocks/autonav/templates/nav-header/view.php, blocks/autonav/templates/nav-header, blocks/autonav/templates, blocks/autonav, blocks/external_form/form/contact_form.php, blocks/external_form/form/controller/contact_form.php, blocks/external_form/form/controller, blocks/external_form/form, blocks/external_form, blocks/page_list/templates/portfolio/view.php, blocks/page_list/templates/portfolio, blocks/page_list/templates/portfolio-homepage/view.php, blocks/page_list/templates/portfolio-homepage, blocks/page_list/templates, blocks/page_list, languages/da_DK/LC_MESSAGES/messages.mo, languages/da_DK/LC_MESSAGES, languages/da_DK, languages/de_DE/LC_MESSAGES/messages.mo, languages/de_DE/LC_MESSAGES, languages/de_DE, languages/el_GR/LC_MESSAGES/messages.mo, languages/el_GR/LC_MESSAGES, languages/el_GR, languages/fi_FI/LC_MESSAGES/messages.mo, languages/fi_FI/LC_MESSAGES, languages/fi_FI, languages/fr_FR/LC_MESSAGES/messages.mo, languages/fr_FR/LC_MESSAGES, languages/fr_FR, languages/it_IT/LC_MESSAGES/messages.mo, languages/it_IT/LC_MESSAGES, languages/it_IT, languages/ja_JP/LC_MESSAGES/messages.mo, languages/ja_JP/LC_MESSAGES, languages/ja_JP, languages/nl_NL/LC_MESSAGES/messages.mo, languages/nl_NL/LC_MESSAGES, languages/nl_NL, languages/ru_RU/LC_MESSAGES/messages.mo, languages/ru_RU/LC_MESSAGES, languages/ru_RU, languages/sl_SI/LC_MESSAGES/messages.mo, languages/sl_SI/LC_MESSAGES, languages/sl_SI, languages/sv_SE/LC_MESSAGES/messages.mo, languages/sv_SE/LC_MESSAGES, languages/sv_SE, languages/tr_TR/LC_MESSAGES/messages.mo, languages/tr_TR/LC_MESSAGES, languages/tr_TR, themes/studiosc/blocks/autonav/templates/nav-header/view.php, themes/studiosc/blocks/autonav/templates/nav-header, themes/studiosc/blocks/autonav/templates, themes/studiosc/blocks/autonav, themes/studiosc/blocks/external_form/form/contact_form.php, themes/studiosc/blocks/external_form/form/controller/contact_form.php, themes/studiosc/blocks/external_form/form/controller, themes/studiosc/blocks/external_form/form, themes/studiosc/blocks/external_form, themes/studiosc/blocks/page_list/templates/portfolio/view.php, themes/studiosc/blocks/page_list/templates/portfolio, themes/studiosc/blocks/page_list/templates/portfolio-homepage/view.php, themes/studiosc/blocks/page_list/templates/portfolio-homepage, themes/studiosc/blocks/page_list/templates, themes/studiosc/blocks/page_list, themes/studiosc/blocks, themes/studiosc/contact.html, themes/studiosc/contact.php, themes/studiosc/css/animate.css, themes/studiosc/css/bootstrap.min.css, themes/studiosc/css/fontello.css, themes/studiosc/css/main.less, themes/studiosc/css/main.min.css, themes/studiosc/css, themes/studiosc/default.php, themes/studiosc/description.txt, themes/studiosc/elements/footer.php, themes/studiosc/elements/footer_bottom.php, themes/studiosc/elements/header.php, themes/studiosc/elements/header_top.php, themes/studiosc/elements, themes/studiosc/fonts/glyphicons-halflings-regular.eot, themes/studiosc/fonts/glyphicons-halflings-regular.svg, themes/studiosc/fonts/glyphicons-halflings-regular.ttf, themes/studiosc/fonts/glyphicons-halflings-regular.woff, themes/studiosc/fonts/icons/fontello.eot, themes/studiosc/fonts/icons/fontello.svg, themes/studiosc/fonts/icons/fontello.ttf, themes/studiosc/fonts/icons/fontello.woff, themes/studiosc/fonts/icons, themes/studiosc/fonts/Lato-Bold.eot, themes/studiosc/fonts/Lato-Bold.svg, themes/studiosc/fonts/Lato-Bold.ttf, themes/studiosc/fonts/Lato-Bold.woff, themes/studiosc/fonts/Lato-Light.eot, themes/studiosc/fonts/Lato-Light.svg, themes/studiosc/fonts/Lato-Light.ttf, themes/studiosc/fonts/Lato-Light.woff, themes/studiosc/fonts/Lato-LightItalic.eot, themes/studiosc/fonts/Lato-LightItalic.svg, themes/studiosc/fonts/Lato-LightItalic.ttf, themes/studiosc/fonts/Lato-LightItalic.woff, themes/studiosc/fonts/Lato-Regular.eot, themes/studiosc/fonts/Lato-Regular.svg, themes/studiosc/fonts/Lato-Regular.ttf, themes/studiosc/fonts/Lato-Regular.woff, themes/studiosc/fonts/stylesheet.css, themes/studiosc/fonts, themes/studiosc/home.php, themes/studiosc/img/apple-touch-icon.png, themes/studiosc/img/arrow-top.svg, themes/studiosc/img/bg-contact.jpg, themes/studiosc/img/bg-footer.jpg, themes/studiosc/img/bg1.jpg, themes/studiosc/img/bullet.svg, themes/studiosc/img/clients/b28.svg, themes/studiosc/img/clients/emile-weber.svg, themes/studiosc/img/clients/ep-vehicules.svg, themes/studiosc/img/clients/il-cosmetics.svg, themes/studiosc/img/clients/netway.svg, themes/studiosc/img/clients/PT.svg, themes/studiosc/img/clients/remax.svg, themes/studiosc/img/clients/sword.svg, themes/studiosc/img/clients/ubiq.svg, themes/studiosc/img/clients, themes/studiosc/img/developpement.png, themes/studiosc/img/favicon.ico, themes/studiosc/img/grid.svg, themes/studiosc/img/icon-frontend.png, themes/studiosc/img/icon-print.png, themes/studiosc/img/icon-web.png, themes/studiosc/img/img-projet.jpg, themes/studiosc/img/img-projet2.jpg, themes/studiosc/img/img-projet3.jpg, themes/studiosc/img/loading.gif, themes/studiosc/img/loading2.gif, themes/studiosc/img/logo.png, themes/studiosc/img/logo.svg, themes/studiosc/img/logo2.png, themes/studiosc/img/logo2.svg, themes/studiosc/img/logo3.svg, themes/studiosc/img/magnifying-glass.svg, themes/studiosc/img/mail.svg, themes/studiosc/img/mail2.svg, themes/studiosc/img/marketing.png, themes/studiosc/img/old/logo.png, themes/studiosc/img/old/logo2.png, themes/studiosc/img/old, themes/studiosc/img/photo.jpg, themes/studiosc/img/print.png, themes/studiosc/img/reseaux.png, themes/studiosc/img/shadow.png, themes/studiosc/img/tel.svg, themes/studiosc/img/testimonial/evolution-continue.png, themes/studiosc/img/testimonial/rizom.png, themes/studiosc/img/testimonial, themes/studiosc/img/web.png, themes/studiosc/img, themes/studiosc/index.html, themes/studiosc/infos.rtf, themes/studiosc/js/bootstrap.min.js, themes/studiosc/js/imagesloaded.min.js, themes/studiosc/js/jquery.isotope.min.js, themes/studiosc/js/jquery.min.js, themes/studiosc/js/main.js, themes/studiosc/js/placeholders.jquery.min.js, themes/studiosc/js/waypoints.min.js, themes/studiosc/js, themes/studiosc/page_forbidden.php, themes/studiosc/page_not_found.php, themes/studiosc/page_theme.php, themes/studiosc/portfolio.php, themes/studiosc/projet.php, themes/studiosc/projets.html, themes/studiosc/services.html, themes/studiosc/services.php, themes/studiosc/thumbnail.png, themes/studiosc

# concrete5 Cache Settings
Block Cache - On
Overrides Cache - On
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache/2.2.31 (Unix) mod_wsgi/3.5 Python/2.7.12 PHP/7.1.0 mod_ssl/2.2.31 OpenSSL/1.0.2j DAV/2 mod_fastcgi/2.4.6 mod_perl/2.0.9 Perl/v5.24.0

# Server API
apache2handler

# PHP Version
7.1.0

# PHP Extensions
apache2handler, bcmath, bz2, calendar, Core, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, hash, iconv, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, posix, Reflection, session, SimpleXML, soap, sockets, SPL, sqlite3, standard, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, zip, zlib

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 128M
post_max_size - 32M
sql.safe_mode - Off
upload_max_filesize - 32M
ldap.max_links - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 1440
soap.wsdl_cache_limit - 5

Browser User-Agent String

Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/602.4.8 (KHTML, like Gecko) Version/10.0.3 Safari/602.4.8