Администраторы группы

  • Аватар

Модераторы группы

  • Аватар

Использование Vtiger CRM

Открытая группа активность: 22 ч., 33 мин. назад

Обсуждения функциональности, особенностей установки и настройки системы SalesPlatform Vtiger CRM.

Vtiger CRM 6.5.0-201611 – Web Form – Ошибка базы данных при выполнении операции (записей: 12)

← Форум группы   Все форумы
  • Аватар Валерий Гражданкин - 4 мес. назад:

    После обновления перестали работать вебформы – не добавляются записи. Права установлены правильно.
    Подскажите где можно покопать?

  • Аватар Алексей Зозуля - 4 мес. назад:

    1. После обновления с какой до какой версии?
    2. Какая ошибка БД?

  • Аватар Валерий Гражданкин - 4 мес. назад:

    Vtiger CRM 6.5.0-201611
    С последними 3-мя патчами
    В ответ на вызов обработчика через

    $res=curl_exec($ch);

    возвращает

    {«success»:false,»error»:{«message»:»u041eu0448u0438u0431u043au0430 u0431u0430u0437u044b u0434u0430u043du043du044bu0445 u043fu0440u0438 u0432u044bu043fu043eu043bu043du0435u043du0438u0438 u043eu043fu0435u0440u0430u0446u0438u0438″}}Array ( [success] => [error] => Array ( [message] => Ошибка базы данных при выполнении операции ) ) Error: Ошибка базы данных при выполнении операции

    В лог никаких ошибок не пишет. До этого все работало исправно, возвращало
    {«success»:true,»result»:»ok»}

  • Аватар Кирилл - 4 мес. назад:

    Такая ошибка с вебформами для любых модулей?
    Вы не пробовали перегенерировать вебформы?
    Не могла ли нарушиться структура базы в ходе исправления проблемы из вашей соседней темы?+
    Также можно включить протоколирование всех SQL-запросов на СУБД.

  • Аватар Валерий Гражданкин - 4 мес. назад:

    В дополнение – обработчики перестали редактироваться, как перенести старые обработчики под новую конфигурацию вручную или хотя бы посмотреть как они были настроены чтобы переписать их заново?

  • Аватар Валерий Гражданкин - 4 мес. назад:

    Для любых модулей не проверял – модуль обращений для разных форм – одна ошибка.
    совершенно новая вновь созданная форма дает ту же ошибку.
    Протоколирование php и sql ничего не пишет в лог насчет этой ошибки.

    Где копать? Проблема с правами на файлы и каталоги может быть?

  • Аватар Алексей Зозуля - 4 мес. назад:

    И все же, с какой версии обновлялись? Слишком много проблем что-то..

  • Аватар Валерий Гражданкин - 4 мес. назад:

    Обновлялся с 6.4 со всеми патчами. Ошибки при обновлении базы была пара, но я ручками проверил структуру и оказалось, что она уже обновлена и соответствует тем запросам на которых была ошибка.
    Пробовал начисто выгружать и загружать базу, все таблицы InoDB

  • Аватар Валерий Гражданкин - 3 мес., 3 нед. назад:

    После обновления так и не работают веб формы ни на каких таблицах. Обращение не переводится в контакт… ПО логам в какой-то момент откатывается транзакция и записи удаляются…
    Разработчики – помогите, где ковырять, что смотреть?
    На начисто установленной базе все работает. Из чистой базы скопировал все файлы и просто подключил к старой базе – результат – вебформы не работают…
    Дело в содержимом базы по видимому, какие-то ключи или добавляются дубликаты уникальных ключей или что-то типа того. На целостность табюлиц не грешу так как они созданы с нуля и в них залит дамп рабочей ьбазы.

    Кому прислать лог для помощи?

    ЛОГ при ошибке добавления веб формы заявки

    Mon May 29 16:18:30 2017,198 [31042] INFO VT – PearDatabase ->ADODB disconnect
    Mon May 29 16:18:30 2017,698 [31042] DEBUG VT – Prepared sql query being executed : SELECT * FROM vtiger_webforms WHERE publicid=? AND enabled=?
    Mon May 29 16:18:30 2017,698 [31042] DEBUG VT – Prepared sql query parameters : [57a80dc1b6ce2b54dac78b0ea6f2320c,1]
    Mon May 29 16:18:30 2017,837 [31042] DEBUG VT – Prepared sql query being executed : SELECT * FROM vtiger_webforms_field WHERE webformid=?
    Mon May 29 16:18:30 2017,837 [31042] DEBUG VT – Prepared sql query parameters : [8]
    Mon May 29 16:18:30 2017,938 [31042] DEBUG user – Entering Users() method …
    Mon May 29 16:18:30 2017,938 [31042] DEBUG VT – Entering getColumnFields(Users) method …
    Mon May 29 16:18:30 2017,939 [31042] DEBUG VT – in getColumnFields Users
    Mon May 29 16:18:30 2017,939 [31042] DEBUG VT – Prepared sql query being executed : SELECT tabid, name, ownedby FROM vtiger_tab
    Mon May 29 16:18:31 2017,045 [31042] DEBUG VT – Prepared sql query being executed : SELECT tabid, fieldname, fieldid, fieldlabel, columnname, tablename, uitype, typeofdata, presence
    FROM vtiger_field WHERE tabid in (?)
    Mon May 29 16:18:31 2017,045 [31042] DEBUG VT – Prepared sql query parameters : [29]
    Mon May 29 16:18:31 2017,136 [31042] DEBUG VT – Exiting getColumnFields method …
    Mon May 29 16:18:31 2017,136 [31042] DEBUG user – Exiting Users() method …
    Mon May 29 16:18:31 2017,136 [31042] DEBUG VT – Prepared sql query being executed : SELECT id FROM vtiger_users WHERE is_admin = ‘on’ AND status = ‘Active’ limit 1
    Mon May 29 16:18:31 2017,225 [31042] DEBUG VT – Entering into retrieve_entity_info(1, Users) method.
    Mon May 29 16:18:31 2017,225 [31042] DEBUG VT – Prepared sql query being executed : select * from vtiger_users where id=?
    Mon May 29 16:18:31 2017,225 [31042] DEBUG VT – Prepared sql query parameters : [1]
    Mon May 29 16:18:31 2017,311 [31042] DEBUG VT – Prepared sql query being executed : select * from vtiger_attachments where attachmentsid=?
    Mon May 29 16:18:31 2017,311 [31042] DEBUG VT – Prepared sql query parameters : [1]
    Mon May 29 16:18:31 2017,394 [31042] DEBUG VT – Prepared sql query being executed : select * from vtiger_user2role where userid=?
    Mon May 29 16:18:31 2017,394 [31042] DEBUG VT – Prepared sql query parameters : [1]
    Mon May 29 16:18:31 2017,486 [31042] DEBUG VT – Prepared sql query being executed : select * from vtiger_asteriskextensions where userid=?
    Mon May 29 16:18:31 2017,486 [31042] DEBUG VT – Prepared sql query parameters : [1]
    Mon May 29 16:18:31 2017,577 [31042] DEBUG VT – Prepared sql query being executed : select * from vtiger_field where tabid=? and vtiger_field.presence in (0,2)
    Mon May 29 16:18:31 2017,577 [31042] DEBUG VT – Prepared sql query parameters : [29]
    Mon May 29 16:18:31 2017,676 [31042] DEBUG VT – Prepared sql query being executed : select * from vtiger_currency_info where id=? and currency_status=’Active’ and deleted=0
    Mon May 29 16:18:31 2017,676 [31042] DEBUG VT – Prepared sql query parameters : [1]
    Mon May 29 16:18:31 2017,761 [31042] DEBUG VT – Exit from retrieve_entity_info(1, Users) method.
    Mon May 29 16:18:31 2017,763 [31042] DEBUG VT – Prepared sql query being executed : select groupname from vtiger_groups where groupid = ?
    Mon May 29 16:18:31 2017,763 [31042] DEBUG VT – Prepared sql query parameters : [1]
    Mon May 29 16:18:31 2017,858 [31042] DEBUG VT – Prepared sql query being executed : select first_name from vtiger_users where id = ?
    Mon May 29 16:18:31 2017,858 [31042] DEBUG VT – Prepared sql query parameters : [1]
    Mon May 29 16:18:32 2017,011 [31042] DEBUG VT – Prepared sql query being executed : select * from vtiger_ws_entity where name=?
    Mon May 29 16:18:32 2017,011 [31042] DEBUG VT – Prepared sql query parameters : [Users]
    Mon May 29 16:18:32 2017,095 [31042] DEBUG VT – Entering getPermittedModuleNames() method …
    Mon May 29 16:18:32 2017,096 [31042] DEBUG VT – Prepared sql query being executed : SELECT tabid, name, ownedby FROM vtiger_tab
    Mon May 29 16:18:32 2017,180 [31042] DEBUG VT – Exiting getPermittedModuleNames method …
    Mon May 29 16:18:32 2017,180 [31042] DEBUG VT – Prepared sql query being executed : select name,id,ismodule from vtiger_ws_entity
    Mon May 29 16:18:32 2017,270 [31042] INFO VT – PearDatabase ->ADODB fetchByAssoc return null
    Mon May 29 16:18:32 2017,271 [31042] DEBUG VT – Prepared sql query being executed : select * from vtiger_ws_entity
    Mon May 29 16:18:32 2017,363 [31042] DEBUG VT – Prepared sql query being executed : select table_name, webservice_entity_id from vtiger_ws_entity_tables
    Mon May 29 16:18:32 2017,492 [31042] DEBUG VT – Prepared sql query being executed : SELECT * FROM vtiger_tab
    Mon May 29 16:18:32 2017,597 [31042] DEBUG VT – Prepared sql query being executed : SELECT fieldname,modulename,tablename,entityidfield,entityidcolumn from vtiger_entityname
    Mon May 29 16:18:32 2017,715 [31042] DEBUG helpdesk – Entering HelpDesk() method …
    Mon May 29 16:18:32 2017,715 [31042] DEBUG VT – Entering getColumnFields(HelpDesk) method …
    Mon May 29 16:18:32 2017,715 [31042] DEBUG VT – in getColumnFields HelpDesk
    Mon May 29 16:18:32 2017,716 [31042] DEBUG VT – Prepared sql query being executed : SELECT tabid, fieldname, fieldid, fieldlabel, columnname, tablename, uitype, typeofdata, presence
    FROM vtiger_field WHERE tabid in (?)
    Mon May 29 16:18:32 2017,716 [31042] DEBUG VT – Prepared sql query parameters : [13]
    Mon May 29 16:18:32 2017,855 [31042] DEBUG VT – Exiting getColumnFields method …
    Mon May 29 16:18:32 2017,855 [31042] DEBUG helpdesk – Exiting HelpDesk method …
    Mon May 29 16:18:32 2017,856 [31042] DEBUG VT – Prepared sql query being executed : select distinct block,vtiger_field.tabid,name,blocklabel from vtiger_field inner join vtiger_blocks on vtiger_blocks.blockid=vtiger_field.block inner join vtiger_tab on vtiger_tab.tabid=vtiger_field.tabid where vtiger_tab.name in (?) and vtiger_field.presence in (0,2) order by block
    Mon May 29 16:18:32 2017,856 [31042] DEBUG VT – Prepared sql query parameters : [HelpDesk]
    Mon May 29 16:18:32 2017,936 [31042] DEBUG VT – Prepared sql query being executed : select *, ’0′ as readonly from vtiger_field where tabid =? and block in (?,?,?) and displaytype in (1,2,3,4,5)
    Mon May 29 16:18:32 2017,936 [31042] DEBUG VT – Prepared sql query parameters : [13,25,28,29]
    Mon May 29 16:18:33 2017,040 [31042] DEBUG VT – Prepared sql query being executed : select * from vtiger_ws_fieldtype
    Mon May 29 16:18:33 2017,162 [31042] DEBUG VT – Prepared sql query being executed : select relmodule as type from vtiger_fieldmodulerel where fieldid=?
    Mon May 29 16:18:33 2017,162 [31042] DEBUG VT – Prepared sql query parameters : [154]
    Mon May 29 16:18:33 2017,252 [31042] DEBUG VT – Prepared sql query being executed : select * from vtiger_ws_referencetype where fieldtypeid=?
    Mon May 29 16:18:33 2017,253 [31042] DEBUG VT – Prepared sql query parameters : [30]
    Mon May 29 16:18:33 2017,347 [31042] DEBUG VT – Prepared sql query being executed : select * from vtiger_ws_referencetype where fieldtypeid=?
    Mon May 29 16:18:33 2017,347 [31042] DEBUG VT – Prepared sql query parameters : [28]
    Mon May 29 16:18:33 2017,450 [31042] DEBUG VT – Prepared sql query being executed : select relmodule as type from vtiger_fieldmodulerel where fieldid=?
    Mon May 29 16:18:33 2017,450 [31042] DEBUG VT – Prepared sql query parameters : [896]
    Mon May 29 16:18:33 2017,536 [31042] DEBUG helpdesk – Entering HelpDesk() method …
    Mon May 29 16:18:33 2017,536 [31042] DEBUG VT – Entering getColumnFields(HelpDesk) method …
    Mon May 29 16:18:33 2017,536 [31042] DEBUG VT – in getColumnFields HelpDesk
    Mon May 29 16:18:33 2017,536 [31042] DEBUG VT – Exiting getColumnFields method …
    Mon May 29 16:18:33 2017,536 [31042] DEBUG helpdesk – Exiting HelpDesk method …
    Mon May 29 16:18:33 2017,537 [31042] INFO VT – PearDatabase ->TRANS Started
    Mon May 29 16:18:33 2017,537 [31042] DEBUG VT – module name is HelpDesk
    Mon May 29 16:18:33 2017,537 [31042] DEBUG VT – Prepared sql query being executed : SELECT * FROM vtiger_eventhandlers WHERE is_active=true
    Mon May 29 16:18:33 2017,541 [31042] INFO VT – PearDatabase ->TRANS saveentity starts HelpDesk
    Mon May 29 16:18:33 2017,541 [31042] INFO VT – PearDatabase ->TRANS Started
    Mon May 29 16:18:33 2017,542 [31042] DEBUG VT – Prepared sql query being executed : insert into vtiger_crmentity (crmid,smcreatorid,smownerid,setype,description,modifiedby,createdtime,modifiedtime) values(?,?,?,?,?,?,?,?)
    Mon May 29 16:18:33 2017,542 [31042] DEBUG VT – Prepared sql query parameters : [175573,1,1,HelpDesk,,1,2017-05-29 16:18:33,2017-05-29 16:18:33]
    Mon May 29 16:18:33 2017,543 [31042] INFO VT – function insertIntoEntityTable HelpDesk vtiger_table name vtiger_troubletickets
    Mon May 29 16:18:33 2017,543 [31042] DEBUG VT – Prepared sql query being executed : select * from vtiger_field where tabid=? and tablename=? and displaytype in (1,3,4) and vtiger_field.presence in (0,2)
    Mon May 29 16:18:33 2017,543 [31042] DEBUG VT – Prepared sql query parameters : [13,vtiger_troubletickets]
    Mon May 29 16:18:33 2017,544 [31042] DEBUG VT – Prepared sql query being executed : select cur_id,prefix from vtiger_modentity_num where semodule=? and active = 1 and spcompany=?
    Mon May 29 16:18:33 2017,545 [31042] DEBUG VT – Prepared sql query parameters : [HelpDesk,]
    Mon May 29 16:18:33 2017,546 [31042] DEBUG VT – Prepared sql query being executed : UPDATE vtiger_modentity_num SET cur_id=? where cur_id=? and active=1 AND semodule=? and spcompany=?
    Mon May 29 16:18:33 2017,546 [31042] DEBUG VT – Prepared sql query parameters : [2,1,HelpDesk,]
    Mon May 29 16:18:33 2017,548 [31042] DEBUG VT – Entering function get_column_value (parent_id, , parent_id, 10, I=»)
    Mon May 29 16:18:33 2017,548 [31042] DEBUG VT – Entering function get_column_value (priority, , ticketpriorities, 15, V=»)
    Mon May 29 16:18:33 2017,548 [31042] DEBUG VT – Exiting function get_column_value
    Mon May 29 16:18:33 2017,548 [31042] DEBUG VT – Entering function get_column_value (product_id, , product_id, 59, I=»)
    Mon May 29 16:18:33 2017,548 [31042] DEBUG VT – Entering function get_column_value (severity, , ticketseverities, 15, V=»)
    Mon May 29 16:18:33 2017,549 [31042] DEBUG VT – Exiting function get_column_value
    Mon May 29 16:18:33 2017,549 [31042] DEBUG VT – Entering function get_column_value (category, , ticketcategories, 15, V=»)
    Mon May 29 16:18:33 2017,549 [31042] DEBUG VT – Exiting function get_column_value
    Mon May 29 16:18:33 2017,549 [31042] DEBUG VT – Entering function get_column_value (update_log, , update_log, 19, V=»)
    Mon May 29 16:18:33 2017,549 [31042] DEBUG VT – Exiting function get_column_value
    Mon May 29 16:18:33 2017,550 [31042] DEBUG VT – Entering function get_column_value (hours, , hours, 1, N=»)
    Mon May 29 16:18:33 2017,550 [31042] DEBUG VT – Entering function get_column_value (days, , days, 1, N=»)
    Mon May 29 16:18:33 2017,550 [31042] DEBUG VT – Entering function get_column_value (solution, , solution, 19, V=»)
    Mon May 29 16:18:33 2017,550 [31042] DEBUG VT – Exiting function get_column_value
    Mon May 29 16:18:33 2017,551 [31042] DEBUG VT – Entering function get_column_value (contact_id, , contact_id, 10, V=»)
    Mon May 29 16:18:33 2017,551 [31042] DEBUG VT – Exiting function get_column_value
    Mon May 29 16:18:33 2017,551 [31042] DEBUG VT – Prepared sql query being executed : insert into vtiger_troubletickets(ticketid,ticket_no,parent_id,priority,product_id,severity,status,category,update_log,hours,days,title,solution,from_portal,contact_id) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
    Mon May 29 16:18:33 2017,551 [31042] DEBUG VT – Prepared sql query parameters : [175573,ЗАЯВКА_1,0,,0,,Open,,,0,0,test,,0,]
    Mon May 29 16:18:33 2017,553 [31042] INFO VT – function insertIntoEntityTable HelpDesk vtiger_table name vtiger_ticketcf
    Mon May 29 16:18:33 2017,553 [31042] DEBUG VT – Prepared sql query being executed : select * from vtiger_field where tabid=? and tablename=? and displaytype in (1,3,4) and vtiger_field.presence in (0,2)
    Mon May 29 16:18:33 2017,553 [31042] DEBUG VT – Prepared sql query parameters : [13,vtiger_ticketcf]
    Mon May 29 16:18:33 2017,565 [31042] DEBUG VT – Prepared sql query being executed : insert into vtiger_ticketcf(ticketid) values(?)
    Mon May 29 16:18:33 2017,565 [31042] DEBUG VT – Prepared sql query parameters : [175573]
    Mon May 29 16:18:33 2017,566 [31042] INFO VT – in insertIntoTicketCommentTable vtiger_ticketcomments module is HelpDesk
    Mon May 29 16:18:33 2017,566 [31042] DEBUG VT – Entering into insertIntoAttachment(175573,HelpDesk) method.
    Mon May 29 16:18:33 2017,566 [31042] DEBUG VT – Exiting from insertIntoAttachment(175573,HelpDesk) method.
    Mon May 29 16:18:33 2017,567 [31042] INFO VT – PearDatabase ->TRANS Commited
    Mon May 29 16:18:33 2017,567 [31042] INFO VT – PearDatabase ->TRANS Completed
    Mon May 29 16:18:33 2017,567 [31042] INFO VT – PearDatabase ->TRANS saveentity ends
    Mon May 29 16:18:33 2017,568 [31042] DEBUG VT – Prepared sql query being executed : SELECT id,currency_id FROM vtiger_users
    Mon May 29 16:18:33 2017,570 [31042] DEBUG VT – Prepared sql query being executed : SELECT * FROM vtiger_currency_info
    Mon May 29 16:18:33 2017,571 [31042] DEBUG VT – query being executed : update vtiger_cobropago set benefit=’0′ where cobropagoid=175573
    Mon May 29 16:18:33 2017,573 [31042] INFO VT – PearDatabase ->ADODB error Query Failed:update vtiger_cobropago set benefit=’0′ where cobropagoid=175573::->[0]
    Mon May 29 16:18:33 2017,573 [31042] DEBUG helpdesk – Entering HelpDesk() method …
    Mon May 29 16:18:33 2017,573 [31042] DEBUG VT – Entering getColumnFields(HelpDesk) method …
    Mon May 29 16:18:33 2017,574 [31042] DEBUG VT – in getColumnFields HelpDesk
    Mon May 29 16:18:33 2017,574 [31042] DEBUG VT – Exiting getColumnFields method …
    Mon May 29 16:18:33 2017,574 [31042] DEBUG helpdesk – Exiting HelpDesk method …
    Mon May 29 16:18:33 2017,574 [31042] DEBUG VT – Prepared sql query being executed : SELECT vtiger_troubletickets.ticket_no AS vtiger_troubleticketsticket_no,vtiger_crmentity.smownerid AS vtiger_crmentityassigned_user_id,vtiger_troubletickets.parent_id AS vtiger_troubleticketsparent_id,vtiger_troubletickets.priority AS vtiger_troubleticketsticketpriorities,vtiger_troubletickets.product_id AS vtiger_troubleticketsproduct_id,vtiger_troubletickets.severity AS vtiger_troubleticketsticketseverities,vtiger_troubletickets.status AS vtiger_troubleticketsticketstatus,vtiger_troubletickets.category AS vtiger_troubleticketsticketcategories,vtiger_troubletickets.update_log AS vtiger_troubleticketsupdate_log,vtiger_troubletickets.hours AS vtiger_troubleticketshours,vtiger_troubletickets.days AS vtiger_troubleticketsdays,vtiger_crmentity.createdtime AS vtiger_crmentitycreatedtime,vtiger_crmentity.modifiedtime AS vtiger_crmentitymodifiedtime,vtiger_troubletickets.title AS vtiger_troubleticketsticket_title,vtiger_crmentity.description AS vtiger_crmentitydescription,vtiger_troubletickets.solution AS vtiger_troubleticketssolution,vtiger_crmentity.modifiedby AS vtiger_crmentitymodifiedby,vtiger_troubletickets.from_portal AS vtiger_troubleticketsfrom_portal,vtiger_troubletickets.contact_id AS vtiger_troubleticketscontact_id,vtiger_crmentity.smcreatorid AS vtiger_crmentitycreated_user_id,vtiger_crmentity.deleted FROM vtiger_crmentity LEFT JOIN vtiger_troubletickets ON vtiger_troubletickets.ticketid=vtiger_crmentity.crmid LEFT JOIN vtiger_ticketcf ON vtiger_ticketcf.ticketid=vtiger_crmentity.crmid LEFT JOIN vtiger_ticketcomments ON vtiger_ticketcomments.ticketid=vtiger_crmentity.crmid WHERE vtiger_crmentity.crmid=? LIMIT 1
    Mon May 29 16:18:33 2017,574 [31042] DEBUG VT – Prepared sql query parameters : [175573]
    Mon May 29 16:18:33 2017,577 [31042] DEBUG VT – Prepared sql query being executed : SELECT crmid, setype, label FROM vtiger_crmentity WHERE crmid=?
    Mon May 29 16:18:33 2017,577 [31042] DEBUG VT – Prepared sql query parameters : [175573]
    Mon May 29 16:18:33 2017,578 [31042] DEBUG VT – Prepared sql query being executed : SELECT commentcontent FROM vtiger_modcomments WHERE related_to = ?
    Mon May 29 16:18:33 2017,578 [31042] DEBUG VT – Prepared sql query parameters : [175573]
    Mon May 29 16:18:33 2017,585 [31042] DEBUG VT – Prepared sql query being executed : SELECT title, ticketid AS id FROM vtiger_troubletickets WHERE ticketid IN (?)
    Mon May 29 16:18:33 2017,585 [31042] DEBUG VT – Prepared sql query parameters : [175573]
    Mon May 29 16:18:33 2017,586 [31042] DEBUG VT – Prepared sql query being executed : UPDATE vtiger_crmentity SET label=? WHERE crmid=?
    Mon May 29 16:18:33 2017,586 [31042] DEBUG VT – Prepared sql query parameters : [test,175573]
    Mon May 29 16:18:33 2017,600 [31042] DEBUG VT – Entering Settings_Search_Handlers_Model::computeCRMRecordLabelsForSearch() method …
    Mon May 29 16:18:33 2017,600 [31042] DEBUG helpdesk – Entering HelpDesk() method …
    Mon May 29 16:18:33 2017,600 [31042] DEBUG VT – Entering getColumnFields(HelpDesk) method …
    Mon May 29 16:18:33 2017,600 [31042] DEBUG VT – in getColumnFields HelpDesk
    Mon May 29 16:18:33 2017,600 [31042] DEBUG VT – Exiting getColumnFields method …
    Mon May 29 16:18:33 2017,600 [31042] DEBUG helpdesk – Exiting HelpDesk method …
    Mon May 29 16:18:33 2017,600 [31042] DEBUG VT – Prepared sql query being executed : SELECT searchcolumn FROM berli_globalsearch_settings LEFT JOIN vtiger_entityname ON vtiger_entityname.tabid = berli_globalsearch_settings.gstabid LEFT JOIN vtiger_troubletickets ON vtiger_troubletickets.ticketid=vtiger_troubletickets.ticketid LEFT JOIN vtiger_ticketcf ON vtiger_ticketcf.ticketid=vtiger_troubletickets.ticketid LEFT JOIN vtiger_ticketcomments ON vtiger_ticketcomments.ticketid=vtiger_troubletickets.ticketid WHERE vtiger_entityname.modulename = ‘HelpDesk’
    Mon May 29 16:18:33 2017,603 [31042] DEBUG VT – Prepared sql query being executed : SELECT title, vtiger_troubletickets.ticketid AS id FROM vtiger_troubletickets LEFT JOIN vtiger_ticketcf ON vtiger_ticketcf.ticketid=vtiger_troubletickets.ticketid LEFT JOIN vtiger_ticketcomments ON vtiger_ticketcomments.ticketid=vtiger_troubletickets.ticketid WHERE vtiger_troubletickets.ticketid IN (?)
    Mon May 29 16:18:33 2017,603 [31042] DEBUG VT – Prepared sql query parameters : [175573]
    Mon May 29 16:18:33 2017,605 [31042] DEBUG VT – Prepared sql query being executed : SELECT COUNT(fieldname) FROM vtiger_field WHERE tabid=?
    Mon May 29 16:18:33 2017,605 [31042] DEBUG VT – Prepared sql query parameters : [13]
    Mon May 29 16:18:33 2017,606 [31042] DEBUG VT – Prepared sql query being executed : SELECT * FROM vtiger_field WHERE tabid=?
    Mon May 29 16:18:33 2017,607 [31042] DEBUG VT – Prepared sql query parameters : [13]
    Mon May 29 16:18:33 2017,613 [31042] DEBUG VT – Prepared sql query being executed : SELECT * FROM berli_globalsearch_data where gscrmid =?
    Mon May 29 16:18:33 2017,613 [31042] DEBUG VT – Prepared sql query parameters : [175573]
    Mon May 29 16:18:33 2017,615 [31042] DEBUG VT – Prepared sql query being executed : INSERT INTO `berli_globalsearch_data` (`gscrmid`, `searchlabel`) VALUES (?,?)
    Mon May 29 16:18:33 2017,615 [31042] DEBUG VT – Prepared sql query parameters : [175573,]
    Mon May 29 16:18:33 2017,616 [31042] DEBUG VT – Prepared sql query being executed : UPDATE berli_globalsearch_data INNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid = berli_globalsearch_data.gscrmid SET searchlabel=? WHERE crmid=?
    Mon May 29 16:18:33 2017,617 [31042] DEBUG VT – Prepared sql query parameters : [,175573]
    Mon May 29 16:18:33 2017,618 [31042] DEBUG user – Entering Users() method …
    Mon May 29 16:18:33 2017,618 [31042] DEBUG VT – Entering getColumnFields(Users) method …
    Mon May 29 16:18:33 2017,618 [31042] DEBUG VT – in getColumnFields Users
    Mon May 29 16:18:33 2017,619 [31042] DEBUG VT – Exiting getColumnFields method …
    Mon May 29 16:18:33 2017,619 [31042] DEBUG user – Exiting Users() method …
    Mon May 29 16:18:33 2017,620 [31042] DEBUG VT – Prepared sql query being executed : select * from vtiger_ws_entity where id=?
    Mon May 29 16:18:33 2017,620 [31042] DEBUG VT – Prepared sql query parameters : [9x175573]
    Mon May 29 16:18:33 2017,621 [31042] DEBUG VT – Prepared sql query being executed : select setype from vtiger_crmentity where crmid=? and deleted=0
    Mon May 29 16:18:33 2017,621 [31042] DEBUG VT – Prepared sql query parameters : [175573]
    Mon May 29 16:18:33 2017,623 [31042] DEBUG VT – Entering isPermitted(HelpDesk,DetailView,175573) method …
    Mon May 29 16:18:33 2017,623 [31042] DEBUG VT – Entering getActionid(DetailView) method …
    Mon May 29 16:18:33 2017,624 [31042] INFO VT – get Actionid DetailView
    Mon May 29 16:18:33 2017,624 [31042] INFO VT – action id selected is 4
    Mon May 29 16:18:33 2017,624 [31042] DEBUG VT – Exiting getActionid method …
    Mon May 29 16:18:33 2017,625 [31042] DEBUG VT – Exiting isPermitted method …
    Mon May 29 16:18:33 2017,625 [31042] DEBUG VT – Prepared sql query being executed : select 1 from vtiger_crmentity where crmid=? and deleted=0 and setype=’HelpDesk’
    Mon May 29 16:18:33 2017,625 [31042] DEBUG VT – Prepared sql query parameters : [175573]
    Mon May 29 16:18:33 2017,626 [31042] DEBUG helpdesk – Entering HelpDesk() method …
    Mon May 29 16:18:33 2017,626 [31042] DEBUG VT – Entering getColumnFields(HelpDesk) method …
    Mon May 29 16:18:33 2017,626 [31042] DEBUG VT – in getColumnFields HelpDesk
    Mon May 29 16:18:33 2017,626 [31042] DEBUG VT – Exiting getColumnFields method …
    Mon May 29 16:18:33 2017,626 [31042] DEBUG helpdesk – Exiting HelpDesk method …
    Mon May 29 16:18:33 2017,626 [31042] INFO VT – PearDatabase ->TRANS Started
    Mon May 29 16:18:33 2017,627 [31042] DEBUG VT – Prepared sql query being executed : SELECT vtiger_troubletickets.ticket_no AS vtiger_troubleticketsticket_no,vtiger_crmentity.smownerid AS vtiger_crmentityassigned_user_id,vtiger_troubletickets.parent_id AS vtiger_troubleticketsparent_id,vtiger_troubletickets.priority AS vtiger_troubleticketsticketpriorities,vtiger_troubletickets.product_id AS vtiger_troubleticketsproduct_id,vtiger_troubletickets.severity AS vtiger_troubleticketsticketseverities,vtiger_troubletickets.status AS vtiger_troubleticketsticketstatus,vtiger_troubletickets.category AS vtiger_troubleticketsticketcategories,vtiger_troubletickets.update_log AS vtiger_troubleticketsupdate_log,vtiger_troubletickets.hours AS vtiger_troubleticketshours,vtiger_troubletickets.days AS vtiger_troubleticketsdays,vtiger_crmentity.createdtime AS vtiger_crmentitycreatedtime,vtiger_crmentity.modifiedtime AS vtiger_crmentitymodifiedtime,vtiger_troubletickets.title AS vtiger_troubleticketsticket_title,vtiger_crmentity.description AS vtiger_crmentitydescription,vtiger_troubletickets.solution AS vtiger_troubleticketssolution,vtiger_crmentity.modifiedby AS vtiger_crmentitymodifiedby,vtiger_troubletickets.from_portal AS vtiger_troubleticketsfrom_portal,vtiger_troubletickets.contact_id AS vtiger_troubleticketscontact_id,vtiger_crmentity.smcreatorid AS vtiger_crmentitycreated_user_id,vtiger_crmentity.deleted FROM vtiger_crmentity LEFT JOIN vtiger_troubletickets ON vtiger_troubletickets.ticketid=vtiger_crmentity.crmid LEFT JOIN vtiger_ticketcf ON vtiger_ticketcf.ticketid=vtiger_crmentity.crmid LEFT JOIN vtiger_ticketcomments ON vtiger_ticketcomments.ticketid=vtiger_crmentity.crmid WHERE vtiger_crmentity.crmid=? LIMIT 1
    Mon May 29 16:18:33 2017,627 [31042] DEBUG VT – Prepared sql query parameters : [175573]
    Mon May 29 16:18:33 2017,629 [31042] INFO VT – PearDatabase ->TRANS Rolled Back
    Mon May 29 16:18:33 2017,629 [31042] INFO VT – PearDatabase ->TRANS Completed
    Mon May 29 16:18:33 2017,629 [31042] DEBUG VT – Prepared sql query being executed : select name from vtiger_ws_entity where id=?
    Mon May 29 16:18:33 2017,629 [31042] DEBUG VT – Prepared sql query parameters : []
    Mon May 29 16:18:33 2017,630 [31042] INFO VT – PearDatabase ->ADODB getColumnNames table=com_vtiger_workflows
    Mon May 29 16:18:33 2017,633 [31042] DEBUG VT – Prepared sql query being executed : select workflow_id, module_name, summary, test, execution_condition, defaultworkflow, type, filtersavedinnew
    from com_vtiger_workflows where module_name=?
    Mon May 29 16:18:33 2017,633 [31042] DEBUG VT – Prepared sql query parameters : []
    Mon May 29 16:18:33 2017,640 [31042] DEBUG VT – Prepared sql query being executed : UPDATE vtiger_ticketcf SET from_portal=0 WHERE ticketid=?
    Mon May 29 16:18:33 2017,640 [31042] DEBUG VT – Prepared sql query parameters : [175573]
    Mon May 29 16:18:33 2017,641 [31042] INFO VT – PearDatabase ->ADODB error Query Failed:UPDATE vtiger_ticketcf SET from_portal=0 WHERE ticketid=?::->[0]
    Mon May 29 16:18:33 2017,645 [31042] DEBUG VT – Prepared sql query being executed : SELECT * FROM vtiger_modtracker_tabs WHERE vtiger_modtracker_tabs.visible = 1
    AND vtiger_modtracker_tabs.tabid=?
    Mon May 29 16:18:33 2017,645 [31042] DEBUG VT – Prepared sql query parameters : [13]
    Mon May 29 16:18:33 2017,646 [31042] DEBUG helpdesk – Entering HelpDesk() method …
    Mon May 29 16:18:33 2017,647 [31042] DEBUG VT – Entering getColumnFields(HelpDesk) method …
    Mon May 29 16:18:33 2017,647 [31042] DEBUG VT – in getColumnFields HelpDesk
    Mon May 29 16:18:33 2017,647 [31042] DEBUG VT – Exiting getColumnFields method …
    Mon May 29 16:18:33 2017,647 [31042] DEBUG helpdesk – Exiting HelpDesk method …
    Mon May 29 16:18:33 2017,647 [31042] DEBUG VT – Prepared sql query being executed : SELECT vtiger_troubletickets.ticket_no AS vtiger_troubleticketsticket_no,vtiger_crmentity.smownerid AS vtiger_crmentityassigned_user_id,vtiger_troubletickets.parent_id AS vtiger_troubleticketsparent_id,vtiger_troubletickets.priority AS vtiger_troubleticketsticketpriorities,vtiger_troubletickets.product_id AS vtiger_troubleticketsproduct_id,vtiger_troubletickets.severity AS vtiger_troubleticketsticketseverities,vtiger_troubletickets.status AS vtiger_troubleticketsticketstatus,vtiger_troubletickets.category AS vtiger_troubleticketsticketcategories,vtiger_troubletickets.update_log AS vtiger_troubleticketsupdate_log,vtiger_troubletickets.hours AS vtiger_troubleticketshours,vtiger_troubletickets.days AS vtiger_troubleticketsdays,vtiger_crmentity.createdtime AS vtiger_crmentitycreatedtime,vtiger_crmentity.modifiedtime AS vtiger_crmentitymodifiedtime,vtiger_troubletickets.title AS vtiger_troubleticketsticket_title,vtiger_crmentity.description AS vtiger_crmentitydescription,vtiger_troubletickets.solution AS vtiger_troubleticketssolution,vtiger_crmentity.modifiedby AS vtiger_crmentitymodifiedby,vtiger_troubletickets.from_portal AS vtiger_troubleticketsfrom_portal,vtiger_troubletickets.contact_id AS vtiger_troubleticketscontact_id,vtiger_crmentity.smcreatorid AS vtiger_crmentitycreated_user_id,vtiger_crmentity.deleted FROM vtiger_crmentity LEFT JOIN vtiger_troubletickets ON vtiger_troubletickets.ticketid=vtiger_crmentity.crmid LEFT JOIN vtiger_ticketcf ON vtiger_ticketcf.ticketid=vtiger_crmentity.crmid LEFT JOIN vtiger_ticketcomments ON vtiger_ticketcomments.ticketid=vtiger_crmentity.crmid WHERE vtiger_crmentity.crmid=? LIMIT 1
    Mon May 29 16:18:33 2017,647 [31042] DEBUG VT – Prepared sql query parameters : [175573]
    Mon May 29 16:18:33 2017,649 [31042] DEBUG VT – Prepared sql query being executed : SELECT commentcontent FROM vtiger_modcomments WHERE related_to = ?
    Mon May 29 16:18:33 2017,649 [31042] DEBUG VT – Prepared sql query parameters : [175573]
    Mon May 29 16:18:33 2017,651 [31042] DEBUG VT – Prepared sql query being executed : SELECT * FROM vtiger_modtracker_basic WHERE
    crmid = ?
    Mon May 29 16:18:33 2017,651 [31042] DEBUG VT – Prepared sql query parameters : [175573]
    Mon May 29 16:18:33 2017,653 [31042] DEBUG VT – Prepared sql query being executed : INSERT INTO vtiger_modtracker_basic(id, crmid, module, whodid, changedon, status)
    VALUES(?,?,?,?,?,?)
    Mon May 29 16:18:33 2017,653 [31042] DEBUG VT – Prepared sql query parameters : [252811,175573,HelpDesk,1,2017-05-29 16:18:33,2]
    Mon May 29 16:18:33 2017,655 [31042] DEBUG VT – Prepared sql query being executed : INSERT INTO vtiger_modtracker_detail(id,fieldname,prevalue,postvalue) VALUES(?,?,?,?)
    Mon May 29 16:18:33 2017,655 [31042] DEBUG VT – Prepared sql query parameters : [252811,ticket_no,,ЗАЯВКА_1]
    Mon May 29 16:18:33 2017,656 [31042] DEBUG VT – Prepared sql query being executed : INSERT INTO vtiger_modtracker_detail(id,fieldname,prevalue,postvalue) VALUES(?,?,?,?)
    Mon May 29 16:18:33 2017,656 [31042] DEBUG VT – Prepared sql query parameters : [252811,assigned_user_id,,1]
    Mon May 29 16:18:33 2017,658 [31042] DEBUG VT – Prepared sql query being executed : INSERT INTO vtiger_modtracker_detail(id,fieldname,prevalue,postvalue) VALUES(?,?,?,?)
    Mon May 29 16:18:33 2017,658 [31042] DEBUG VT – Prepared sql query parameters : [252811,ticketstatus,,Open]
    Mon May 29 16:18:33 2017,659 [31042] DEBUG VT – Prepared sql query being executed : INSERT INTO vtiger_modtracker_detail(id,fieldname,prevalue,postvalue) VALUES(?,?,?,?)
    Mon May 29 16:18:33 2017,659 [31042] DEBUG VT – Prepared sql query parameters : [252811,hours,,0.00000000]
    Mon May 29 16:18:33 2017,661 [31042] DEBUG VT – Prepared sql query being executed : INSERT INTO vtiger_modtracker_detail(id,fieldname,prevalue,postvalue) VALUES(?,?,?,?)
    Mon May 29 16:18:33 2017,661 [31042] DEBUG VT – Prepared sql query parameters : [252811,days,,0.00000000]
    Mon May 29 16:18:33 2017,662 [31042] DEBUG VT – Prepared sql query being executed : INSERT INTO vtiger_modtracker_detail(id,fieldname,prevalue,postvalue) VALUES(?,?,?,?)
    Mon May 29 16:18:33 2017,662 [31042] DEBUG VT – Prepared sql query parameters : [252811,createdtime,,2017-05-29 16:18:33]
    Mon May 29 16:18:33 2017,663 [31042] DEBUG VT – Prepared sql query being executed : INSERT INTO vtiger_modtracker_detail(id,fieldname,prevalue,postvalue) VALUES(?,?,?,?)
    Mon May 29 16:18:33 2017,663 [31042] DEBUG VT – Prepared sql query parameters : [252811,ticket_title,,test]
    Mon May 29 16:18:33 2017,664 [31042] DEBUG VT – Prepared sql query being executed : INSERT INTO vtiger_modtracker_detail(id,fieldname,prevalue,postvalue) VALUES(?,?,?,?)
    Mon May 29 16:18:33 2017,664 [31042] DEBUG VT – Prepared sql query parameters : [252811,modifiedby,,1]
    Mon May 29 16:18:33 2017,666 [31042] DEBUG VT – Prepared sql query being executed : INSERT INTO vtiger_modtracker_detail(id,fieldname,prevalue,postvalue) VALUES(?,?,?,?)
    Mon May 29 16:18:33 2017,666 [31042] DEBUG VT – Prepared sql query parameters : [252811,created_user_id,,1]
    Mon May 29 16:18:33 2017,667 [31042] DEBUG VT – Prepared sql query being executed : INSERT INTO vtiger_modtracker_detail(id,fieldname,prevalue,postvalue) VALUES(?,?,?,?)
    Mon May 29 16:18:33 2017,667 [31042] DEBUG VT – Prepared sql query parameters : [252811,record_id,,175573]
    Mon May 29 16:18:33 2017,668 [31042] DEBUG VT – Prepared sql query being executed : INSERT INTO vtiger_modtracker_detail(id,fieldname,prevalue,postvalue) VALUES(?,?,?,?)
    Mon May 29 16:18:33 2017,668 [31042] DEBUG VT – Prepared sql query parameters : [252811,record_module,,HelpDesk]
    Mon May 29 16:18:33 2017,884 [31042] INFO VT – PearDatabase ->TRANS Rolled Back
    Mon May 29 16:18:33 2017,933 [31042] INFO VT – PearDatabase ->TRANS Completed

  • Аватар Кирилл - 3 мес., 3 нед. назад:

    «CHECK TABLE» не пробовали?

  • Аватар Валерий Гражданкин - 3 мес., 3 нед. назад:

    Таблицы все прочеканы и не содержат ошибок. База загружена заново через выгрузку из предыдущей версии.

  • Аватар Алексей Зозуля - 3 мес., 3 нед. назад:

    Надо среди этой простыни запросов понять, какой из них валится с ошибкой.