Should I re-post this in the 1.12 forums?
Blank "From" column in search results
I've asked the devs to take a look at this.
Just to toss an idea out there: would a database export / fresh install be of any use to anyone?
- Edited
Does everyone have the name column in the ost_user table??
Cheers.
- Edited
Also did everyone use the code from https://osticket.com/download??
Also, can someone post a screenshot of their table structure for ost_user (including indexes)?
Cheers.
Also, (lol) make sure you have the following records in the db:
ost_form
ost_form_field
Cheers.
- Edited
Someone do me a favor and add the following to include/class.queue.php line 396:
var_dump($fields);Save the changes and go reload the queue in question in the ticket queues. You then should see a huge text output on the screen. You should then use the browser "Find In Page" feature to find user__name. If you find matching text make sure it looks something like the following:
["user__name"]=> array(2) { [0]=> string(16) "User / Full Name" [1]=> object(TextboxField)#464 (9) { ["ht"]=> array(14) { ["label"]=> string(9) "Full Name"If it does not look like that or if you can't find user__name altogether then please post here and let me know.
Cheers.
- Edited
ost_user
My ost_form and ost_form_fields have the Contact Information and Email Address / Full Name columns respectively.
I added the var_dump fields line but couldn't find any trace ofuser__name , onlyuser__cdata__name
"user__cdata__name"]=> array(2) { [0]=> string(16) "User / Full Name" [1]=> object(TextboxField)#683 (9) { ["ht"]=> array(14) { ["label"]=> string(9) "Full Name"Thanks
User Name primary value is set to user__cdata__name
When I changed this value (edited database directly) to user__name, the From column on all queues went blank. (The var_dump still didn't containuser__name)
I then changed the From column primary data source (using osTicket Admin Panel > Manage Queue Column) to User / Full Name, which reset the primary value to user__cdata__name
- Edited
Okay so I updated my column and it was set to user__name in the database which is correct. Yours is acting really funny...could you please go to https://osticket.com/download and download the files again, re-upload the files to your site, restart Apache (and PHP-FPM if you're running it), restart the database, and change your From column from User / Full Name to something else and back to User / Full Name again? Maybe something is cached on your server and it still thinks that User Name is user__cdata__name instead of user__name?
Cheers.
- Edited
Unfortunately that didn't fix the issue. The field still resets back to user__cdata__name
Are you using the LDAP plugin in your test environment?
No, I never use that. Unless I'm testing LDAP stuff specifically. I don't even have an LDAP connection available on this server to test with.
Cheers.
- Edited
@cpr @EVERYONE
I FINALLY FOUND THE ROOT CAUSE OF THE ISSUE!!! IT'S THE MAH F@#%ING FLAGS!
Go to the ost_form_field table in your database, run a search for all records with form_id of 1, and look at the Email Address and Full Name records. The flags are SUPPOSED to be 489379 but I bet your flags are totally different (maybe like 1281). All you have to do is set your flags for both the Email Address and Full Name Fields to 489379 and go re-save your queue column config. After you re-save you should see user__name in the database and you should see data in your From column. ?
I need a drink after this one ? ?
Cheers.
Yeah that works for me too! Thanks mate!
Flags for those fields where also 30465 here.
9 days later
- Edited
@KevinTheJedi Reporting another success. Thank you for the help on this, I was pulling my hair out. Appreciate it!