Keyword

Modulo RokSprocket Mosaic con K2...non funziona

  • Dafne Giacobbe
  • Dafne Giacobbe's Avatar Topic Author
  • Offline
  • New Member
More
10 years 8 months ago #116572 by Dafne Giacobbe
Modulo RokSprocket Mosaic con K2...non funziona was created by Dafne Giacobbe
Ho cercato di creare un Modulo RokSprocket Mosaic (che con joomla funziona benissimo) con articoli presi da K2, nel momento in cui ho selezionato K2 mi sono apparsi gli errori sottostanti.
Adesso addirittura non mi fa entrare da amministrazione nel modulo per correggerlo.


Messaggio di errore

500 - Si è verificato un errore.

Table 'Sql573083_1.r9fc1_k2_comments' doesn't exist SQL=SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.published, a.access, a.created, a.modified, a.extra_fields, a.extra_fields_search, a.created_by, a.created_by_alias, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.language, a.metakey, a.metadesc, a.metadata,c.name AS category_title, c.image AS category_image, c.alias as category_alias,CONCAT_WS(",", f.id) AS field_ids, CONCAT_WS(",", f.name) AS field_names,CONCAT_WS(",", t.id) AS tag_ids, CONCAT_WS(",", t.name) AS tag_names,COUNT(co.id) AS comment_count,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title FROM r9fc1_k2_items as a LEFT JOIN r9fc1_k2_categories AS c ON c.id = a.catid LEFT JOIN r9fc1_k2_extra_fields_groups AS fg ON fg.id = c.extraFieldsGroup LEFT JOIN r9fc1_k2_extra_fields AS f ON f.group = fg.id LEFT JOIN r9fc1_k2_tags_xref AS tx ON tx.itemID = a.id LEFT JOIN r9fc1_k2_tags AS t ON t.id = tx.tagID LEFT JOIN r9fc1_k2_comments AS co ON co.itemID = a.id LEFT JOIN r9fc1_users AS ua ON ua.id = a.created_by LEFT JOIN r9fc1_users AS um ON um.id = a.modified_by LEFT JOIN r9fc1_k2_rating AS v ON a.id = v.itemID LEFT JOIN r9fc1_viewlevels AS vl ON a.access = vl.id LEFT JOIN r9fc1_languages AS l ON a.language = l.lang_code LEFT OUTER JOIN (select rsi.provider_id, rsi.order from r9fc1_roksprocket_items as rsi where module_id = 232) rsi on a.id = rsi.provider_id WHERE ((a.access IN(1,1,2,3) AND a.trash = 0) AND a.id IN (44,53,54,55,56,45,46,47,43)) GROUP BY a.id ORDER BY IF(ISNULL(rsi.order),1,0),rsi.order

Poi ho controllato e nel pannello di controllo K2 Commenti appare questo:

Warning: Invalid argument supplied for foreach() in /web/htdocs/www.weddingsanddreams.it/home/administrator/components/com_k2/views/comments/view.html.php on line 52

Qualcuno sa cosa posso fare?
grazie

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum