Hallo!
Nach Update von Version 2.1.10 auf Version 5.1.3 bekomme ich folgende Meldung im Backend nach Klick auf "Buchungen":
Table 'd01.response_matukio_recurring' doesn't exist SQL=SELECT r.id AS value, CONCAT(a.title, ' ', r.begin) AS text FROM response_matukio_recurring AS r LEFT JOIN response_matukio AS a ON r.event_id = a.id ORDER BY r.begin DESC
Ebenso kommt folgende Meldung im Frontend wenn man die Veranstaltungsliste aufrufen möchte:
1146 Table 'd01.response_matukio_recurring' doesn't exist SQL=SELECT count(*) FROM response_matukio_recurring AS r LEFT JOIN response_matukio AS a ON r.event_id = a.id LEFT JOIN response_categories AS cat ON cat.id = a.catid WHERE r.published = 1 AND cat.access in (1,1,5) AND r.begin > '2015-02-18 16:52:59' ORDER BY r.begin ASC
Diese Table ist tatsächlich nicht vorhanden - was kann ich tun? Hätte ich einen Zwischenschritt gebraucht?
Danke!
Christian
PS: Entschuldigung, in der Eile habe ich das selbe ursprünglich in General Talk gepostet.
Edit: Habe die Installation auf die vom Backup zurückgerollte Seite nochmal versucht. Das Update hat wieder abgebrochen mit folgender Meldung:
Duplicate entry '8' for key 'PRIMARY' SQL=INSERT INTO `response_matukio_templates` (`id`, `tmpl_name`, `category`, `subject`, `value`, `value_text`, `default`, `modified_by`, `published`) VALUES (8, 'invoice', 3, 'E', '<table style="width: 100%;" border="0" cellspacing="0" cellpadding="2">\r\n<tbody>\r\n<tr>\r\n<td align="left" width="100%">\r\n<table style="width: 100%;" border="0" cellspacing="0" cellpadding="2">\r\n<tbody>\r\n<tr>\r\n<td width="100%">\r\n<table style="width: 100%;" border="0" cellspacing="0" cellpadding="2">\r\n<tbody>\r\n<tr>\r\n<td align="left" valign="top" width="50%">\r\n<table style="width: 100%;" border="0" cellspacing="0" cellpadding="2">\r\n<tbody>\r\n<tr>\r\n<td align="left">Your Company</td>\r\n</tr>\r\n<tr>\r\n<td align="left">Your Company Address</td>\r\n</tr>\r\n<tr>\r\n<td align="left">Your Tax Number</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n<td align="center" valign="middle" width="50%">Your Logo</td>\r\n</tr>\r\n<tr>\r\n<td colspan="2" align="left" width="100%"><br /><br />\r\n<table style="width: 100%;" border="0" cellspacing="0" cellpadding="2">\r\n<tbody>\r\n<tr>\r\n<td align="left" valign="top" width="50%">\r\n<table style="width: 100%;" border="0" cellspacing="0" cellpadding="2">\r\n<tbody>\r\n<tr>\r\n<td style="background-color: #d6d6d6;" align="left">\r\n<h4 style="margin: 0px;">Customer Information</h4>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td align="left">MAT_BOOKING_NAME</td>\r\n</tr>\r\n<tr>\r\n<td align="left">MAT_BOOKING_STREET</td>\r\n</tr>\r\n<tr>\r\n<td align="left">MAT_BOOKING_ZIP MAT_BOOKING_CITY</td>\r\n</tr>\r\n<tr>\r\n<td align="left">MAT_BOOKING_COUNTRY</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n<td align="left" valign="top" width="50%">\r\n<table style="width: 100%;" border="0" cellspacing="0" cellpadding="2">\r\n<tbody>\r\n<tr>\r\n<td style="background-color: #d6d6d6;" colspan="2" align="left">\r\n<h4 style="margin: 0px;">Invoice Information</h4>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td align="left" width="50%">Invoice Number:</td>\r\n<td align="left">MAT_INVOICE_NUMBER</td>\r\n</tr>\r\n<tr>\r\n<td align="left" width="50%">Invoice Date:</td>\r\n<td align="left">MAT_INVOICE_DATE</td>\r\n</tr>\r\n<tr>\r\n<td align="left" width="50%">Booking Number:</td>\r\n<td align="left">MAT_BOOKING_NUMBER</td>\r\n</tr>\r\n<tr>\r\n<td align="left" width="50%">Payment method:</td>\r\n<td align="left">MAT_BOOKING_PAYMENT_METHOD</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<br /><br /></td>\r\n</tr>\r\n<tr>\r\n<td style="background-color: #d6d6d6;" colspan="2" align="left">\r\n<h4 style="margin: 0px;">Order Items</h4>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td colspan="2" align="left" width="100%">\r\n<table style="width: 100%;" border="0" cellspacing="0" cellpadding="2">\r\n<tbody>\r\n<tr>\r\n<td align="left" valign="top" width="10%">#</td>\r\n<td align="left" valign="top" width="50%">Event</td>\r\n<td align="left" valign="top" width="10%"> </td>\r\n<td align="left" valign="top" width="10%"> </td>\r\n<td align="left" valign="top" width="10%"> </td>\r\n<td align="left" valign="top" width="10%"> </td>\r\n</tr>\r\n<tr>\r\n<td align="left" valign="top" width="10%">MAT_BOOKING_NRBOOKED</td>\r\n<td align="left" valign="top" width="50%">MAT_EVENT_TITLE </td>\r\n<td align="left" valign="top" width="10%"> </td>\r\n<td align="left" valign="top" width="10%"> </td>\r\n<td align="left" valign="top" width="10%"> </td>\r\n<td align="left" valign="top" width="10%">MAT_BOOKING_PAYMENT_NETTO</td>\r\n</tr>\r\n<tr>\r\n<td colspan="5" align="right" valign="top" width="90%"> </td>\r\n<td align="left" valign="top" width="10%"> </td>\r\n</tr>\r\n<tr>\r\n<td colspan="5" align="right" valign="top" width="90%">Net total:</td>\r\n<td align="left" valign="top" width="10%">MAT_BOOKING_PAYMENT_NETTO</td>\r\n</tr>\r\n<tr>\r\n<td colspan="5" align="right" valign="top" width="90%">Tax total:</td>\r\n<td align="left" valign="top" width="10%">MAT_BOOKING_PAYMENT_TAX</td>\r\n</tr>\r\n<tr>\r\n<td colspan="5" align="right" valign="top" width="90%">Total:</td>\r\n<td align="left" valign="top" width="10%">MAT_BOOKING_PAYMENT_BRUTTO</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td style="background-color: #d6d6d6;" colspan="2" align="left">\r\n<h4 style="margin: 0px;">Invoice Note</h4>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td colspan="2" align="left" width="100%">\r\n<table style="width: 100%;" border="0" cellspacing="0" cellpadding="2">\r\n<tbody>\r\n<tr>\r\n<td> Your notes</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<p> </p>', '', '', 0, 1), (9, 'invoice_email', 3, '##COM_MATUKIO_INVOICE_SUBJECT## MAT_BOOKING_NUMBER', '<div id="mat-invoice-mail">\r\n<p><span style="line-height: 1.3em;">##COM_MATUKIO_EMAIL_GREETING## MAT_BOOKING_NAME,<br /><br /></span>##COM_MATUKIO_EMAIL_INVOICE_ATTACHED##</p>\r\n<p>MAT_SIGNATURE</p>\r\n</div>', '', '', 0, 1), (10, 'ticket', 4, 'E', '<table style="width: 100%;">\r\n<tbody>\r\n<tr>\r\n<td>MAT_EVENT_TITLE - MAT_EVENT_BEGIN</td>\r\n</tr>\r\n<tr>\r\n<td>MAT_BOOKING_NRBOOKED - MAT_BOOKING_TICKETS </td>\r\n</tr>\r\n<tr>\r\n<td>MAT_BOOKING_NUMBER</td>\r\n</tr>\r\n<tr>\r\n<td><span style="font-family: Tahoma, Helvetica, Arial, sans-serif; font-size: 12px;">MAT_BOOKING_QRCODE</span></td>\r\n</tr>\r\n<tr>\r\n<td>MAT_BOOKING_PAYMENT_BRUTTO</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n<p><br /><br /><br /><br /></p>', '', '', 0, 1);
Am einfachsten vorher den Inhalt der Templates Tabelle ganz löschen (TRUNCATE #__matukio_templates) und dann updaten. Wenn du willst kann ich auch mal schauen ob ich ein Update hinbekomme (Super-Admin Daten an This email address is being protected from spambots. You need JavaScript enabled to view it.)
