×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Table fehlt nach Update von 2.1.10 auf 5.1.3

Table fehlt nach Update von 2.1.10 auf 5.1.3 2 years 9 months ago #30367

  • Erich Silli
  • Erich Silli's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 3
  • Thank you received: 0
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);

Table fehlt nach Update von 2.1.10 auf 5.1.3 2 years 9 months ago #30368

  • Yves Hoppe
  • Yves Hoppe's Avatar
  • Away
  • Administrator
  • Administrator
  • Posts: 3519
  • Karma: 70
  • Thank you received: 556
Sicher das es 2.1.10 war und nicht eine RC / Entwicklungs-Version danach? Die Templates kamen auf jedenfalls erst mit 2.2..

Wird jetzt schwierig das per zu korrigieren :( 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.)

Viele Grüße

Yves
  • Page:
  • 1
Time to create page: 0.088 seconds