# Service Type list missing after update to 2.04/ admin 2.06 **URL:** \ **Category:** REST API\ **Created:** [January 27, 2016, 5:13pm UTC](https://community.dreamfactory.com/t/service-type-list-missing-after-update-to-2-04-admin-2-06/2098 "2016-01-27T17:13:58Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![tony\_gilpin](https://avatars.discourse-cdn.com/v4/letter/t/50afbb/32.png) [@tony\_gilpin](https://community.dreamfactory.com/u/tony_gilpin)\ **Post date:** [January 27, 2016, 5:13pm UTC](https://community.dreamfactory.com/t/service-type-list-missing-after-update-to-2-04-admin-2-06/2098/1 "2016-01-27T17:13:58Z")
Hi I have updated from 2.0.1 to 2.0.4 , the list of my services are ok, but if i go to create new service , the dropdown list of service types does not appear. How do i fix it ? Thanks Tony [Wed Jan 27 17:27:32.255623 2016] [:error] [pid 15144:tid 1104] [client 86.145.234.192:63733] REST Exception #500 \> Failed to retrieve records from ‘UKPlanner.vw\_myobtasksforalerts’.\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘ref\_service\_id’ in ‘where clause’ (SQL: select \* from `db_field_extras` where `ref_service_id` = 9 and `ref_table` = UKPlanner.vw\_myobtasksforalerts), referer: [http://104.217.252.182/delegatecapture/](http://104.217.252.182/delegatecapture/) This i am now getting from the client web app ---
**Author:** ![andersonmuller](https://avatars.discourse-cdn.com/v4/letter/a/7feea3/32.png) [@andersonmuller](https://community.dreamfactory.com/u/andersonmuller)\ **Post date:** [January 27, 2016, 6:12pm UTC](https://community.dreamfactory.com/t/service-type-list-missing-after-update-to-2-04-admin-2-06/2098/2 "2016-01-27T18:12:33Z")
Hi @tony_gilpin, Its seems that the database was not updated correctly. You followed this guide? [https://wiki.dreamfactory.com/DreamFactory/Installation#Upgrade](https://wiki.dreamfactory.com/DreamFactory/Installation#Upgrade) Try again, start at the the line **$ …/…/…/php/bin/php artisan migrate --seed** and continue to the end. ---
**Author:** ![tony\_gilpin](https://avatars.discourse-cdn.com/v4/letter/t/50afbb/32.png) [@tony\_gilpin](https://community.dreamfactory.com/u/tony_gilpin)\ **Post date:** [January 28, 2016, 1:25pm UTC](https://community.dreamfactory.com/t/service-type-list-missing-after-update-to-2-04-admin-2-06/2098/3 "2016-01-28T13:25:18Z")
HI Have fixed the problem , appears that my php was not in the environment variables path. I now have another problem, this was working prior to the upgrade , it’s to do with dates. ![](https://cdck-file-uploads-canada1.s3.dualstack.ca-central-1.amazonaws.com/flex035/uploads/dreamfactory/original/1X/9a11ee7dcf138af6fcbd5395ff0ce6738df6588e.PNG) What has changed on how we filter for dates, and why is it giving this message now ? Thanks Tony ---
**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\ **Post date:** [January 28, 2016, 4:51pm UTC](https://community.dreamfactory.com/t/service-type-list-missing-after-update-to-2-04-admin-2-06/2098/4 "2016-01-28T16:51:08Z")
See querying with filters here: [https://wiki.dreamfactory.com/DreamFactory/Tutorials/Querying\_records\_with\_logical\_filters](https://wiki.dreamfactory.com/DreamFactory/Tutorials/Querying_records_with_logical_filters) The need for parentheses was added in 2.0.4 ---
**Author:** ![tony\_gilpin](https://avatars.discourse-cdn.com/v4/letter/t/50afbb/32.png) [@tony\_gilpin](https://community.dreamfactory.com/u/tony_gilpin)\ **Post date:** [January 28, 2016, 5:09pm UTC](https://community.dreamfactory.com/t/service-type-list-missing-after-update-to-2-04-admin-2-06/2098/5 "2016-01-28T17:09:06Z")
Hi Drew I have this now (startdate \>= 2016-01-23) AND (startdate \<=2016-02-02) Which works fine but if i use this (startdate \>= 2016-01-23) AND (startdate \<=2016-02-02) AND (ClientCode \<\> ‘’) I get an error "message": “Failed to retrieve records from ‘UKPlanner.vw\_myobtasksforalerts’.\nDateTime::\_\_construct(): Failed to parse time string (2016-02-02) AND (ClientCode <> ‘’) at position 10 ()): Unexpected character”, “code”: 500, What needs to be changed ? Thanks Tony ---
**Author:** ![tony\_gilpin](https://avatars.discourse-cdn.com/v4/letter/t/50afbb/32.png) [@tony\_gilpin](https://community.dreamfactory.com/u/tony_gilpin)\ **Post date:** [January 28, 2016, 5:28pm UTC](https://community.dreamfactory.com/t/service-type-list-missing-after-update-to-2-04-admin-2-06/2098/6 "2016-01-28T17:28:57Z")
Hi Drew Seems to be working now must be a typo somewhere, But good to be aware of parenthesises Thanks Tony