Hallo Zusammen
Ich habe ein Problem mit dem SQL Server:
phpMyadmin gibt folgender Fehler aus:phpmyadmin-1.PNG
In einer im OS Ticketsystem welches ich zum Testen aufgesetzt habe treten diese Fehler zu tage:
[CREATE TABLE IF NOT EXISTS `ost_ticket__cdata` (PRIMARYKEY
(ticket_id)) DEFAULT CHARSET=utf8 AS SELECT entry.`object_id` as`ticket_id`, FROM ost_form_entry entry
JOINost_form_entry_values ans ON ans.entry_id = entry.id
JOINost_form_field field ON field.id=ans.field_id
WHEREentry.object_type='T' GROUP BY entry.object_id]
You have an error in your SQL syntax; check the manualthat corresponds to your MySQL server version for the right syntax to use near'FROM ost_form_entry entry
JOINost_form_entry_values ans ON ans.entr' at line 2<br /> <br />
---- Ablaufverfolgung ----<br />
#0 (root)/include/mysqli.php(204):osTicket->logDBError('DB Error #1064', '[CREATE TABLE I...')<br />
#1 (root)/include/class.dynamic_forms.php(292):db_query('CREATE TABLE IF...')<br />
#2 (root)/include/class.dynamic_forms.php(285):DynamicForm::buildDynamicDataView(Array)<br />
#3 (root)/include/staff/tickets.inc.php(8):DynamicForm::ensureDynamicDataView()<br />
#4 (root)/scp/tickets.php(492):require_once('/var/www/virtua...')<br />
#5 (root)/scp/index.php(17):require('/var/www/virtua...')<br />
#6 {main}
[SELECT A4.`staff_id` AS `lock__staff_id`, A1.`staff_id`AS `staff_id`, A1.`isoverdue` AS `isoverdue`, A1.`team_id` AS `team_id`,A1.`ticket_id` AS `ticket_id`, A1.`number` AS `number`, A2.`subject` AS`cdata__subject`, A6.`address` AS `user__default_email__address`, A1.`source`AS `source`, A3.`priority_color` AS `cdata__:priority__priority_color`,A3.`priority_desc` AS `cdata__:priority__priority_desc`, A1.`status_id` AS`status_id`, A7.`name` AS `status__name`, A7.`state` AS `status__state`,A1.`dept_id` AS `dept_id`, A8.`name` AS `dept__name`, A5.`name` AS`user__name`, A1.`lastupdate` AS `lastupdate`, A1.`isanswered` AS `isanswered`,B0.`firstname` AS `staff__firstname`, B0.`lastname` AS `staff__lastname`,B1.`name` AS `team__name`, (SELECT COUNT(R0.`id`) AS `count` FROM `ost_thread`Q7 JOIN `ost_ticket` Q8 ON (Q7.`object_type` = 'T' AND Q7.`object_id` =Q8.`ticket_id`) LEFT JOIN `ost_thread_collaborator` R0 ON (Q7.`id` =R0.`thread_id`) WHERE Q8.`ticket_id` = A1.`ticket_id`) AS collab_count, (SELECTCOUNT(R1.`id`) AS `count` FROM `ost_thread` Q7 JOIN `ost_ticket` Q8 ON(Q7.`object_type` = 'T' AND Q7.`object_id` = Q8.`ticket_id`) LEFT JOIN`ost_thread_entry` R0 ON (Q7.`id` = R0.`thread_id`) LEFT JOIN `ost_attachment`R1 ON (R1.`type` = 'H' AND R0.`id` = R1.`object_id`) WHERE Q8.`ticket_id` =A1.`ticket_id` AND R1.`inline` = 0) AS attachment_count, (SELECT COUNT(R0.`id`)AS `count` FROM `ost_thread` Q7 JOIN `ost_ticket` Q8 ON (Q7.`object_type` = 'T'AND Q7.`object_id` = Q8.`ticket_id`) LEFT JOIN `ost_thread_entry` R0 ON(Q7.`id` = R0.`thread_id`) WHERE Q8.`ticket_id` = A1.`ticket_id` AND NOTR0.`flags` & 4 != 0) AS thread_count FROM `ost_ticket` A1 LEFT JOIN`ost_ticket__cdata` A2 ON (A1.`ticket_id` = A2.`ticket_id`) LEFT JOIN `ost_ticket_priority`A3 ON (A2.`priority` = A3.`priority_id`) LEFT JOIN `ost_lock` A4 ON(A1.`lock_id` = A4.`lock_id` AND A4.`expire` > NOW()) JOIN `ost_user` A5 ON(A1.`user_id` = A5.`id`) LEFT JOIN `ost_user_email` A6 ON(A5.`default_email_id` = A6.`id`) JOIN `ost_ticket_status` A7 ON(A1.`status_id` = A7.`id`) JOIN `ost_department` A8 ON (A1.`dept_id` = A8.`id`)LEFT JOIN `ost_staff` B0 ON (A1.`staff_id` = B0.`staff_id`) LEFT JOIN`ost_team` B1 ON (A1.`team_id` = B1.`team_id`) WHERE A1.`ticket_id` IN (SELECTA1.`ticket_id` FROM `ost_ticket` A1 JOIN `ost_ticket_status` A2 ON(A1.`status_id` = A2.`id`) WHERE A1.`isanswered` = 0 AND A2.`state` = 'open'AND ((A2.`state` = 'open' AND A1.`staff_id` = 1) OR A1.`dept_id` IN ('1')))GROUP BY A4.`staff_id`, A1.`staff_id`, A1.`isoverdue`, A1.`team_id`,A1.`ticket_id`, A1.`number`, A2.`subject`, A6.`address`, A1.`source`,A3.`priority_color`, A3.`priority_desc`, A1.`status_id`, A7.`name`, A7.`state`,A1.`dept_id`, A8.`name`, A5.`name`, A1.`lastupdate`, A1.`isanswered`, B0.`firstname`,B0.`lastname`, B1.`name` ORDER BY A3.`priority_urgency` ASC, A1.`lastupdate`DESC]
Table 'osticket_27.ost_ticket__cdata' doesn't exist<br/> <br />
---- Ablaufverfolgung ----<br />
#0 (root)/include/mysqli.php(204):osTicket->logDBError('DB Error #1146', '[SELECT A4.`sta...')<br />
#1 (root)/include/class.orm.php(3133): db_query('SELECTA4.`staf...', true, true)<br />
#2 (root)/include/class.orm.php(3180):MySqlExecutor->execute()<br />
#3 (root)/include/class.orm.php(1865):MySqlExecutor->getArray()<br />
#4 (root)/include/class.orm.php(1815):HashArrayIterator->{closure}()<br />
#5 (root)/include/class.orm.php(1794):CallbackSimpleIterator->next()<br />
#6 (root)/include/class.orm.php(1803):CallbackSimpleIterator->rewind()<br />
#7 (root)/include/class.orm.php(1463):CallbackSimpleIterator->valid()<br />
#8 (root)/include/class.orm.php(1480):CachedResultSet->fillTo(9223372036854775807)<br />
#9 (root)/include/class.orm.php(1489): CachedResultSet->asArray()<br/>
#10 (root)/include/staff/tickets.inc.php(506):CachedResultSet->getIterator()<br />
#11 (root)/scp/tickets.php(492):require_once('/var/www/virtua...')<br />
#12 (root)/scp/index.php(17):require('/var/www/virtua...')<br />
#13 {main}
Logs von i-mscp hab ich keine welche das Problem betreffen.
Hat jemand eine Idee was der Fehler sein könnte? Ich selber bin leider nicht gerade versiert in diesem Thema... Falls weitere Infos nötig sind bitte sagen:)
Mein System: Debian Wheezy mit i-MSCP 1.3.16
Vielen Dank!
LG CSF