Unknown column 'user_email_hash' in 'field list' [1054]

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
GameSetMatch
Registered User
Posts: 7
Joined: Wed Aug 15, 2018 6:48 am

Unknown column 'user_email_hash' in 'field list' [1054]

Post by GameSetMatch »

Hello,

I have a problem with my forum.
Unknown column 'user_email_hash' in 'field list' [1054]
I read that I need to replace the 3.28 files with the 3.3.0 files.

Please, send me a direct link to a zip of version 3.3.0 (I found the release of 3.3.3) and also clarify which folders I have to replace.

Unfortunately I cannot update my php version of my site. (PHP_VERSION: 5.6.40)



Thank you in advance.
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26516
Joined: Fri Aug 29, 2008 9:49 am

Re: Unknown column 'user_email_hash' in 'field list' [1054]

Post by Mick »

You can’t use 3.3.x with that version of PHP - see: 3.3.x requirements. What are you trying to do? Please fill out the Support Request Template and post it back here to enable us to assist you better.
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
GameSetMatch
Registered User
Posts: 7
Joined: Wed Aug 15, 2018 6:48 am

Re: Unknown column 'user_email_hash' in 'field list' [1054]

Post by GameSetMatch »

Few weeks ago I updated the forum from 3.2.* to 3.3.0 version and yesterday I get a feedback that new users cannot register.

This is the http://acmilan-bg.com/forum
Attachments
Screenshot 2021-04-14 155404.jpg
User avatar
thecoalman
Community Team Member
Community Team Member
Posts: 5876
Joined: Wed Dec 22, 2004 3:52 am
Location: Pennsylvania, U.S.A.
Contact:

Re: Unknown column 'user_email_hash' in 'field list' [1054]

Post by thecoalman »

Archived releases can be found here but updating those files should of been part of any previous update.

You cannot run 3.3.0 or higher without PHP 7.1.3+. You will need to upgrade PHP version on server.
“Results! Why, man, I have gotten a lot of results! I have found several thousand things that won’t work.”

Attributed - Thomas Edison
User avatar
Mike-on-Tour
Registered User
Posts: 462
Joined: Wed Jan 15, 2020 3:51 pm
Location: Germany
Name: Michael
Contact:

Re: Unknown column 'user_email_hash' in 'field list' [1054]

Post by Mike-on-Tour »

This error message is propably caused by an extension which uses this column in the phpbb_users table. Starting with - I believe - phpBB 3.3.0 this column was removed from the table, so any extension using it causes an error message.
Check your extensions one after another by deactivating them and check whether this error is still there. If it no longer pops up, you have found the culprit.
Watz fo lunch?
If you like my extensions or my support please consider a donation: Image
User avatar
thecoalman
Community Team Member
Community Team Member
Posts: 5876
Joined: Wed Dec 22, 2004 3:52 am
Location: Pennsylvania, U.S.A.
Contact:

Re: Unknown column 'user_email_hash' in 'field list' [1054]

Post by thecoalman »

It would also be caused by 3.2.X files with 3.3.X database which based on the OP is what is occurring.

Uploading the right files for his 3.3.0 database will fix current issue but is going to cause other errors.
“Results! Why, man, I have gotten a lot of results! I have found several thousand things that won’t work.”

Attributed - Thomas Edison
GameSetMatch
Registered User
Posts: 7
Joined: Wed Aug 15, 2018 6:48 am

Re: Unknown column 'user_email_hash' in 'field list' [1054]

Post by GameSetMatch »

I updated my php version up to 7.3.27 and updated the forum version to 3.3.3 but still have problems with the registration.
I installed 3.3.3. style but the error is still the same and new registrations are not possible.

I tried to deactivate all extensions and the same. :oops:
Attachments
Screenshot 2021-04-15 155058.jpg
Screenshot 2021-04-15 155216.jpg
11111.jpg
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52768
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Unknown column 'user_email_hash' in 'field list' [1054]

Post by stevemaury »

GameSetMatch wrote: Thu Apr 15, 2021 12:53 pm I updated my php version up to 7.3.27 and updated the forum version to 3.3.3 but still have problems with the registration.
I installed 3.3.3. style but the error is still the same and new registrations are not possible.

I tried to deactivate all extensions and the same. :oops:
Want to share with us what those problems are? Error message?
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
GameSetMatch
Registered User
Posts: 7
Joined: Wed Aug 15, 2018 6:48 am

Re: Unknown column 'user_email_hash' in 'field list' [1054]

Post by GameSetMatch »

stevemaury wrote: Thu Apr 15, 2021 2:13 pm
GameSetMatch wrote: Thu Apr 15, 2021 12:53 pm I updated my php version up to 7.3.27 and updated the forum version to 3.3.3 but still have problems with the registration.
I installed 3.3.3. style but the error is still the same and new registrations are not possible.

I tried to deactivate all extensions and the same. :oops:
Want to share with us what those problems are? Error message?
When I try to REGISTER i got this error message: "Unknown column 'user_email_hash' in 'field list' [1054]"
Attachments
Screenshot 2021-04-15 155216.jpg
User avatar
warmweer
Jr. Extension Validator
Posts: 11242
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium
Contact:

Re: Unknown column 'user_email_hash' in 'field list' [1054]

Post by warmweer »

GameSetMatch wrote: Fri Apr 16, 2021 5:59 am When I try to REGISTER i got this error message: "Unknown column 'user_email_hash' in 'field list' [1054]"
Did you clear cache (phpBB and browser)?
Did you check whether the field is present in the database (users_table?)?
Did you check whether "user_email_hash" is referenced in your files? if yes which file? (also check the extension files)
Did you at one time during your recent attempts to update use the autoupdate?

I see that your Thanks for posts version = 2.0.7-dev.
A quick search here shows me that the current version = 3.2.18

Added: OK, the thanks for posts version 3.2.18 seems to be a different extension, the latest version of the extension you are using = 2.0.7 (no -dev)
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
Post Reply

Return to “[3.3.x] Support Forum”