search

partkeepr / PartKeepr

Open Source Inventory Management
http://www.partkeepr.org
GNU General Public License v3.0
1.38k stars 400 forks source link

search option is giving error #798

Closed mctomaszek closed 4 years ago

mctomaszek commented 7 years ago

hi

when i have tried to find the parts on demo I get error

An error occurred

Details

Unknown operator

Request

GET https://demo.partkeepr.org/api/parts?_dc=1485415214003

Response Status Code

500

Response

{"@context":"\/api\/contexts\/Error","@type":"Error","hydra:title":"An error occurred","hydra:description":"Unknown operator "}

Server Configuration

doctrine_orm_version: 2.5.4 doctrine_dbal_version: 2.5.2 doctrine_common_version: 2.6.0-DEV php_version: 5.6.29-1~dotdeb+7.1 auto_start_session: true maxUploadSize: 12582912 isOctoPartAvailable: true availableImageFormats: JPG,GIF,PNG autoLoginUsername: admin autoLoginPassword: admin motd:

Welcome to the PartKeepr demo site

Notes:

max_users: unlimited authentication_provider: PartKeepr.Auth.HTTPBasicAuthenticationProvider tip_of_the_day_uri: https://partkeepr.org/tips/%s password_change: true

mctomaszek commented 7 years ago

how to reproduce:

  1. go to fulltext search (system preference)
  2. mark option : (for example)store location-name
  3. save

and when I try to find the parts I'm getting error:

An error occurred

Details

[Syntax Error] line 0, col 88: Error: Expected =, <, <=, <>, >, >=, !=, got ':param0'

Request

GET https://demo.partkeepr.org/api/parts?_dc=1485418630376

Response Status Code

500

Response

{"@context":"\/api\/contexts\/Error","@type":"Error","hydra:title":"An error occurred","hydra:description":"[Syntax Error] line 0, col 88: Error: Expected =, \u003C, \u003C=, \u003C\u003E, \u003E, \u003E=, !=, got \u0027:param0\u0027"}

Server Configuration

doctrine_orm_version: 2.5.4 doctrine_dbal_version: 2.5.2 doctrine_common_version: 2.6.0-DEV php_version: 5.6.29-1~dotdeb+7.1 auto_start_session: true maxUploadSize: 12582912 isOctoPartAvailable: true availableImageFormats: JPG,GIF,PNG autoLoginUsername: admin autoLoginPassword: admin motd:

Welcome to the PartKeepr demo site

Notes:

max_users: unlimited authentication_provider: PartKeepr.Auth.HTTPBasicAuthenticationProvider tip_of_the_day_uri: https://partkeepr.org/tips/%s password_change: true

mctomaszek commented 7 years ago

I have noticed also that fulltext search option (some of the fields for example "id ") in version 1.1.0 creating similar issues

mctomaszek commented 7 years ago

hello Felicitus Could you check if you can reproduce this fault as well please on demo version?

regards

JohnEffland commented 7 years ago

I just confirmed it appears on demo version. For example, with "-A071" entered into the search box, the error described above occurs. Chrome's debugger shows the query string to the server has the correct quotes around the search string: "%-A071%".

mctomaszek commented 7 years ago

if l mark something in system preferences --fulltext search in "search fields" ( does mater what) ...it will give later one search box error. You can not use search box in demo version till system will be reload at full hour. I have noticed same problem with version 1.1.0. During simulation this issue in version 1.1.0 I have marked some options in system preferences---fulltext search and I got error

{"@context":"\/api\/contexts\/Error","@type":"Error","hydra:title":"An error occurred","hydra:description":"Unknown operator "}

Server Configuration

doctrine_orm_version: 2.5.4 doctrine_dbal_version: 2.5.2 doctrine_common_version: 2.6.0-DEV php_version: 7.0.15-1+deb.sury.org~xenial+1 auto_start_session: true maxUploadSize: 15728640 availableImageFormats: JPG,GIF,PNG max_users: unlimited authentication_provider: PartKeepr.Auth.HTTPBasicAuthenticationProvider tip_of_the_day_uri: https://partkeepr.org/tips/%s password_change: true

later I have tried unmark all options but search box in partkeepr does not work any more. Probably I have to do re-setup again :(

part

mctomaszek commented 7 years ago

I did re-setup.......but search box still is giving error and my system is useless . I don't know how to sort out problem. :(. Please help....

I restored mysql base from backup and system start to work again .........

Drachenkaetzchen commented 7 years ago

You can try to delete all user preferences in the database table UserPreferences. The issue will be fixed with the next release

Drachenkaetzchen commented 7 years ago

Sorry, I meant the table SystemPreference.

Drachenkaetzchen commented 7 years ago

The issue should now be fixed - can you double check?

mctomaszek commented 7 years ago

hi

fulltext search via "id" still is giving error at demo version :

An error occurred

Details

[Syntax Error] line 0, col 83: Error: Expected =, <, <=, <>, >, >=, !=, got 'id'

Request

GET https://demo.partkeepr.org/api/parts?_dc=1486970423136

Response Status Code

500

Response

{"@context":"\/api\/contexts\/Error","@type":"Error","hydra:title":"An error occurred","hydra:description":"[Syntax Error] line 0, col 83: Error: Expected =, \u003C, \u003C=, \u003C\u003E, \u003E, \u003E=, !=, got \u0027id\u0027"}

Server Configuration

doctrine_orm_version: 2.5.4 doctrine_dbal_version: 2.5.2 doctrine_common_version: 2.6.0-DEV php_version: 7.0.14-2 auto_start_session: true maxUploadSize: 2097152 isOctoPartAvailable: true availableImageFormats: JPG,GIF,PNG autoLoginUsername: admin autoLoginPassword: admin motd:

Welcome to the PartKeepr demo site

Notes:

max_users: unlimited authentication_provider: PartKeepr.Auth.HTTPBasicAuthenticationProvider tip_of_the_day_uri: https://partkeepr.org/tips/%s password_change: true

christianlupus commented 4 years ago

The search itself is working except for the id field.

Regarding the ID fiels see #924 and #992.