philbertphotos / osticket-multildap-auth-plugin

Plugin for OS Ticket that allows for authentication with multiple domains.
GNU General Public License v3.0
28 stars 16 forks source link

DB Error #1054 #11

Closed jianfzhu closed 5 years ago

jianfzhu commented 6 years ago

When i install and run, error log in system. [Select susername,email,phone_ext as ext,mobile from ost_staff where username is not null] unknow column 'susername' in 'field list'

philbertphotos commented 6 years ago

What is susername?

Sent from my iPhone

On Jan 17, 2018, at 10:39 PM, jianfzhu notifications@github.com wrote:

When i install and run, error log in system. [Select susername,email,phone_ext as ext,mobile from ost_staff where username is not null] unknow column 'susername' in 'field list'

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

jianfzhu commented 6 years ago

i don't know. in sync_mldap.php file line 359, i removed 's', it doesn't report #1054 error. but report DB Error #1146 Table ost_ldap_sync doesn't exist. Does the plugin not auto create table? my osticket version: 1.10.1. the latest one download from osTicket homepage.

philbertphotos commented 5 years ago

This has been fixed in version 1.2.2