Resolved Bug


This bug has been marked as resolved.

Upgrade from 5.7.5.13 to. 8.1 error

Permalink 17 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: Resolved
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
gavthompson replied on at Permalink Reply
gavthompson
I don't know if you guys have sorted this yourselves but I was talking to Ramonlendeers on Slack regarding this and he suggested "just create the column in the Users table" so I manually created the "ulsPasswordReset" in the admin users table and it worked! I was able to upgrade a local copy and everything seems to work fine.

I had actually upgraded a local copy of our site when v8 was released for testing without issue. I'm not sure what version it was before I updated it, but I know it was before v7.5.13 got released.
This makes me think the problem is in 7.5.13.
gavthompson replied on at Permalink Reply
gavthompson
I don't know if you guys have sorted this yourselves but I was talking to Ramonlendeers on Slack regarding this and he suggested "just create the column in the Users table" so I manually created the "ulsPasswordReset" in the admin users table and it worked! I was able to upgrade a local copy and everything seems to work fine.

I had actually upgraded a local copy of our site when v8 was released for testing without issue. I'm not sure what version it was before I updated it, but I know it was before v7.5.13 got released.
This makes me think the problem is in 7.5.13.
Schnak replied on at Permalink Reply
OK, thanks for the workaround.
Maybe the next release can fix that with creation of column in db if it's not exist already.
mlocati replied on at Permalink Reply
mlocati
https://github.com/concrete5/concrete5/pull/5682 should fix this issue
ob7dev replied on at Permalink Reply
ob7dev
To manually fix this error on some systems you can invoke a package upgrade which resets schema. Using the conrete5 bin tool, you can run something such as `./concrete5 c5:package-upgrade name_of_package --force` and this will reload schema for that package. If you on shared hosting and can only fix from c5 admin, then you must change the package version number via ftp and then click on upgrade for that add-on inside the "Extend concrete5" panel.

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