Thread

Was having some config issues with entries using importer.

Decided to update to 2.8.0.

All my timezone issues we’re fixed when importing, but now I can access my localization settings via the my account, I get the following error.

A Database Error Occurred
Error Number: 1054

Unknown column ‘date_format’ in ‘field list’

SELECT `timezone`, `language`, `date_format`, `time_format`, `include_seconds` FROM (`exp_members`) WHERE `member_id` = 1

Filename: models/member_model.php

Line Number: 263

So obviously the DB table isn’t being updated with this new column. Fix?

Hi,

go to CP Home > Tools > Data > SQL Manger Click on Mange Database Tables

and check if:
1- date_formai & include_seconds columns are added to ur exp_members table.
2- template_routes table Created.
3- security_hashes table : must be 4 columns(hash_id,date,session_id,hash) .

if these changes are not applied then as I think your upgrade process is not completed successfully.

I prefer to rerun the upgrade wizard .

Regard’s.

date_formai & include_seconds columns are because I went and added them manually… The others are not there even after running the Installer after following the instructions to a T.

Hi,

first what is ur past version??

second did u update using addons , or by EE native??

I just try to update from 2.7.3 to 2.8.0 and the update process apply all the changes, so I think the problem in ur side.

try to reinstall 2.8.0 with EE native, then tell me

Regard’s.

I upgraded from 2.7.2

I can’t just reinstall with a fresh 2.8.0… this is a client website.

I did a fresh install of 2.8.0 just to check some server timezones, I just checked the localization settings / template route pages for that testing install and it worked fine.

Hi,

I don’t mean reinstall a fresh one,

what I mean , u must have a backup for 2.7.2 and its database.

what I suggest here is to restore this backup (e.g in your localhost/subfolder on client server) and try to reupdate it to 2.8.0

and see if it works.

I hope this will help you.

Regard’s.