1. Erich Silli
  2. Installation
  3. Thursday, 19 February 2015
  4.  Subscribe via email
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);
Responses (1)


There are %s replies to this question. If you want to see them you need a valid subscription.
If you have a valid subscription, please login now.
Visit store now

Last questions

CMigrator: Path from Drupal 6 to J5?
(Category s/b CMigrator, but didn't see it on the list) I'm interested in usi...
0 Replies
Posted on Monday, 28 April 2025
  • New
  • Dowload all Hotspots entries
    Hi there, I'm looking for a way to dowload all the Hotspots entries. I've got t...
    0 Replies
    Posted on Sunday, 06 April 2025
    • #kml
    • #download
    Set number of hotspots / user groups
    Hi, I'm working with Hotspots for my new website and I love it! After trying ...
    0 Replies
    Posted on Monday, 31 March 2025
    J5 compatibility for Hotspots
    Hi guys, Just started to update my old J3x website. Is there J5 compatibility p...
    1 Replies
    Posted on Monday, 24 February 2025
    • #Hotspots
    • #hotspots Joomla 5
    Text size in the comment input form
    Hello. How can I increase the font size in the comment input field? For examp...
    0 Replies
    Posted on Wednesday, 26 February 2025
    • #CComment 6