Users afrer batch import cannot see own messeges via web

dnbass

HI i have problem with users created via batch import . That users cannot see their own and any messages in ticket.
When i created users by hand every things is ok . Can any body help me where is problem that batch users cannot see messegess in ticket ?

KevinTheJedi

@dnbass

No idea what you mean. Screenshots are always helpful. Also, please read the following post and update this thread with the requested information afterwards:

https://forum.osticket.com/d/89131-please-read-before-requesting-assistance

Cheers.

dnbass

First image with no messege in ticket ( user made by import csv ) , second is correct (user made by hand)

KevinTheJedi

@dnbass

Please check your error logs (general server logs, webserver error logs, PHP error logs, MySQL/MariaDB error logs, osTicket System Logs, Browser Console logs, etc.) for any related errors.

Cheers.

dnbass

there is no error in apache/php/mysql.

dnbass

there is error when i add user from import from csv or text field but user is created successfuly

[INSERT INTO `hdtelemed_user__cdata` SET `notes`='', `user_id`= 90 ON DUPLICATE KEY UPDATE `notes`=''] Unknown column 'notes' in 'field list'

---- Wsteczne śledzenie ----
#0 (główny katalog)/include/mysqli.php(201): osTicket->logDBError('DB Error #1054', '[INSERT INTO `h...')
#1 (główny katalog)/include/class.dynamic_forms.php(381): db_query('INSERT INTO `hd...')
#2 (główny katalog)/include/class.dynamic_forms.php(396): DynamicForm::updateDynamicDataView(Object(DynamicFormEntryAnswer), NULL)
#3 (główny katalog)/include/class.signal.php(98): DynamicForm::updateDynamicFormEntryAnswer(Object(DynamicFormEntryAnswer), NULL)
#4 (główny katalog)/include/class.orm.php(680): Signal::send('model.created', Object(DynamicFormEntryAnswer))
#5 (główny katalog)/include/class.dynamic_forms.php(1536): VerySimpleModel->save(false)
#6 (główny katalog)/include/class.dynamic_forms.php(1378): DynamicFormEntryAnswer->save(false)
#7 (główny katalog)/include/class.dynamic_forms.php(1317): DynamicFormEntry->saveAnswers(NULL, false)
#8 (główny katalog)/include/class.user.php(348): DynamicFormEntry->save()
#9 (główny katalog)/include/class.user.php(421): User->addForm(Object(UserForm), 1, Array)
#10 (główny katalog)/include/class.user.php(249): User->addDynamicData(Array)
#11 (główny katalog)/include/class.user.php(516): User::fromVars(Array, true, true)
#12 (główny katalog)/include/class.user.php(534): User::importCsv('name, email\n te...', Array)
#13 (główny katalog)/include/ajax.users.php(352): User::importFromPost('name, email\n te...')
#14 (główny katalog)/include/class.dispatcher.php(145): UsersAjaxAPI->importUsers()
#15 (główny katalog)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/import', Array)
#16 (główny katalog)/include/class.dispatcher.php(120): Dispatcher->resolve('/import', Array)
#17 (główny katalog)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/users/import', NULL)
#18 (główny katalog)/scp/ajax.php(316): Dispatcher->resolve('/users/import')
#19 {main}

I noticed that when i click pirnt button whole ticket message are printed in pdf file. Thats mean that messages are not showed in ticket in user panel ( not admin)

KevinTheJedi

dnbass

Login to your database, completely drop the ost_ticket__cdata table, and run cron manually via command line. If you can’t run cron then simply drop the aforementioned table, add a dummy field to the Contact Information Form, save changes, delete the dummy field, and save changes again.

Cheers.

dnbass

After drop table ticket__cddata nothing changed , user still cannot see own messages in ticket via web gui

KevinTheJedi

@dnbass

Was the table recreated with the notes column? If so, then you will need to look for new errors.

Cheers.

dnbass

KevinTheJedi

@dnbass

Well that just shows you trying to select data, it does not show that the table exists with proper columns.

Cheers.