Unknown column 'column_name' in 'field list' MySQLError#1054

[jphrm]

Hi all,

First i added fields licenses_other on table "hs_hr_emp_licenses" for some purpose but if im going to try this query

SELECT EMP_NUMBER, LICENSES_CODE, LICENSES_DATE, LICENSES_RENEWAL_DATE, LICENSES_OTHER FROM hs_hr_emp_licenses WHERE EMP_NUMBER='007' direct with phpmyadmin

the error appears:

Unknown column 'LICENSES_OTHER' in 'field list' MySQL Error # :1054

Please help me to fix this problem or teach me the way on how can i add another txtfields that i can called it Another Licences that where able to had option to put thier another licences if the licenses is not on the dropdown list..

Thank you in Advance.

[madhusanka]

Hi all,

First i added fields licenses_other on table "hs_hr_emp_licenses" for some purpose but if im going to try this query

SELECT EMP_NUMBER, LICENSES_CODE, LICENSES_DATE, LICENSES_RENEWAL_DATE, LICENSES_OTHER FROM hs_hr_emp_licenses WHERE EMP_NUMBER='007' direct with phpmyadmin

the error appears:

Unknown column 'LICENSES_OTHER' in 'field list' MySQL Error # :1054

Please help me to fix this problem or teach me the way on how can i add another txtfields that i can called it Another Licences that where able to had option to put thier another licences if the licenses is not on the dropdown list..

Thank you in Advance.

Hi jphrm,

Could you please mention in which version did this error occur?

[kamatchid]

Me also getting the same error.

Unknown column 'LICENSES_OTHER' in 'field list' MySQL Error # :1054

Orange hrm2.6.

[jorjastandish]

Can i add a column?

[filescanbefun]

Hey, it's nice to know I'm not the only one suffering.

I added fields licenses_other and ultimately got a message saying:

Unknown column 'LICENSES_OTHER' in 'field list' MySQL Error # :1054

If anyone knows how to fix this, please speak up and let us know!