Blank "From" column in search results
Wow, thanks for sharing! I had the same problem with it.
It looks similar to me, only that the fields are blank when I use a custom criteria in the the custom queue @ntozier @KevinTheJedi
Did you solve it?
Hi guys, is there anything else I can try or information I can send?
- Edited
Same issue here too:
Server 2012R2
osTicket: v1.12
PHP 7.3.1
Error logs look clean too. In browser / network tab in chrome don't show any errors.
I'm stumped ?
Should I re-post this in the 1.12 forums?
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.