• user warning: Can't create/write to file '/tmp/#sql_3e63_0.MYI' (Errcode: 122) query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 292 ORDER BY v.weight, t.weight, t.name in /var/www/federacion/html/web/public_html/modules/taxonomy/taxonomy.module on line 633.
  • user warning: Can't create/write to file '/tmp/#sql_3e63_0.MYI' (Errcode: 122) query: SELECT v.vid, v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE (v.language ='ca' OR v.language ='' OR v.language IS NULL) AND ( n.type = 'page' )ORDER BY v.weight, v.name in /var/www/federacion/html/web/public_html/modules/taxonomy/taxonomy.module on line 472.
  • user warning: Can't create table 'temp_faceted_search_results_1' (errno: 122) query: CREATE TEMPORARY TABLE temp_faceted_search_results_1 (nid int unsigned NOT NULL, PRIMARY KEY (nid)) Engine=HEAP SELECT DISTINCT n.nid AS nid, 5 * POW(2, (GREATEST(MAX(n.created), MAX(n.changed), MAX(c.last_comment_timestamp)) - 1465888897) * 6.43e-8) + 5 * (2.0 - 2.0 / (1.0 + MAX(c.comment_count) * 1)) AS score FROM node AS n LEFT JOIN node_comment_statistics AS c ON n.nid = c.nid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND (n.language ='ca' OR n.language ='' OR n.language IS NULL) AND ( ((n.status = 1) AND (n.type IN ('enlaces'))) )GROUP BY n.nid ASC ORDER BY score DESC in /var/www/federacion/html/web/public_html/sites/all/modules/faceted_search/faceted_search.inc on line 1174.
  • user warning: Table 'donbosco_drupal.temp_faceted_search_results_1' doesn't exist query: SELECT COUNT(*) FROM temp_faceted_search_results_1 in /var/www/federacion/html/web/public_html/sites/all/modules/faceted_search/faceted_search.inc on line 1175.
  • user warning: Can't create/write to file '/tmp/#sql_3e63_0.MYI' (Errcode: 122) query: SELECT COUNT(*) FROM (SELECT DISTINCT node_data_field_autor.field_autor_value AS node_data_field_autor_field_autor_value, node.type AS node_type, node.nid AS nid, node.vid AS node_vid, node_data_field_pie_foto_portada.field_pie_foto_portada_value AS node_data_field_pie_foto_portada_field_pie_foto_portada_valu, node_data_field_resumen.field_resumen_value AS node_data_field_resumen_field_resumen_value, node_data_field_imagenportada.field_imagenportada_fid AS node_data_field_imagenportada_field_imagenportada_fid, node_data_field_imagenportada.field_imagenportada_list AS node_data_field_imagenportada_field_imagenportada_list, node_data_field_imagenportada.field_imagenportada_data AS node_data_field_imagenportada_field_imagenportada_data, node.title AS node_title, node_data_field_fecha.field_fecha_value AS node_data_field_fecha_field_fecha_value FROM node node LEFT JOIN content_field_fecha node_data_field_fecha ON node.vid = node_data_field_fecha.vid LEFT JOIN content_field_autor node_data_field_autor ON node.vid = node_data_field_autor.vid LEFT JOIN content_field_pie_foto_portada node_data_field_pie_foto_portada ON node.vid = node_data_field_pie_foto_portada.vid LEFT JOIN content_field_resumen node_data_field_resumen ON node.vid = node_data_field_resumen.vid LEFT JOIN content_field_imagenportada node_data_field_imagenportada ON node.vid = node_data_field_imagenportada.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( ((node.type in ('noticias')) AND (node.tnid = 0 OR (node.language = 'ca') OR (node.language = 'ca' AND 0 = (SELECT count(lmfh_node.nid) FROM node AS lmfh_node WHERE lmfh_node.tnid = node.tnid AND ((lmfh_node.language = 'ca')))) OR (node.nid = node.tnid AND 0 = (SELECT count(lmfh_node.nid) FROM node AS lmfh_node WHERE lmfh_node.tnid = node.tnid AND ((lmfh_node.language = 'ca') OR (lmfh_node.language = 'ca')))))) AND (DATE_FORMAT(node_data_field_fecha.field_fecha_value, '%Y-%m-%d') <= '2017-08-22') )) count_alias in /var/www/federacion/html/web/public_html/sites/all/modules/views/plugins/views_plugin_pager.inc on line 134.
  • user warning: Can't create/write to file '/tmp/#sql_3e63_0.MYI' (Errcode: 122) query: SELECT DISTINCT node_data_field_autor.field_autor_value AS node_data_field_autor_field_autor_value, node.type AS node_type, node.nid AS nid, node.vid AS node_vid, node_data_field_pie_foto_portada.field_pie_foto_portada_value AS node_data_field_pie_foto_portada_field_pie_foto_portada_valu, node_data_field_resumen.field_resumen_value AS node_data_field_resumen_field_resumen_value, node_data_field_imagenportada.field_imagenportada_fid AS node_data_field_imagenportada_field_imagenportada_fid, node_data_field_imagenportada.field_imagenportada_list AS node_data_field_imagenportada_field_imagenportada_list, node_data_field_imagenportada.field_imagenportada_data AS node_data_field_imagenportada_field_imagenportada_data, node.title AS node_title, node_data_field_fecha.field_fecha_value AS node_data_field_fecha_field_fecha_value FROM node node LEFT JOIN content_field_fecha node_data_field_fecha ON node.vid = node_data_field_fecha.vid LEFT JOIN content_field_autor node_data_field_autor ON node.vid = node_data_field_autor.vid LEFT JOIN content_field_pie_foto_portada node_data_field_pie_foto_portada ON node.vid = node_data_field_pie_foto_portada.vid LEFT JOIN content_field_resumen node_data_field_resumen ON node.vid = node_data_field_resumen.vid LEFT JOIN content_field_imagenportada node_data_field_imagenportada ON node.vid = node_data_field_imagenportada.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( ((node.type in ('noticias')) AND (node.tnid = 0 OR (node.language = 'ca') OR (node.language = 'ca' AND 0 = (SELECT count(lmfh_node.nid) FROM node AS lmfh_node WHERE lmfh_node.tnid = node.tnid AND ((lmfh_node.language = 'ca')))) OR (node.nid = node.tnid AND 0 = (SELECT count(lmfh_node.nid) FROM node AS lmfh_node WHERE lmfh_node.tnid = node.tnid AND ((lmfh_node.language = 'ca') OR (lmfh_node.language = 'ca')))))) AND (DATE_FORMAT(node_data_field_fecha.field_fecha_value, '%Y-%m-%d') <= '2017-08-22') )ORDER BY node_data_field_fecha_field_fecha_value DESC LIMIT 0, 5 in /var/www/federacion/html/web/public_html/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1093.
  • user warning: Can't create/write to file '/tmp/#sql_3e63_0.MYI' (Errcode: 122) query: SELECT COUNT(*) FROM (SELECT DISTINCT node_data_field_autor.field_autor_value AS node_data_field_autor_field_autor_value, node.type AS node_type, node.nid AS nid, node.vid AS node_vid, node_data_field_pie_foto_portada.field_pie_foto_portada_value AS node_data_field_pie_foto_portada_field_pie_foto_portada_valu, node_data_field_resumen.field_resumen_value AS node_data_field_resumen_field_resumen_value, node_data_field_imagenportada.field_imagenportada_fid AS node_data_field_imagenportada_field_imagenportada_fid, node_data_field_imagenportada.field_imagenportada_list AS node_data_field_imagenportada_field_imagenportada_list, node_data_field_imagenportada.field_imagenportada_data AS node_data_field_imagenportada_field_imagenportada_data, node.title AS node_title, node_data_field_fecha.field_fecha_value AS node_data_field_fecha_field_fecha_value FROM node node LEFT JOIN content_field_fecha node_data_field_fecha ON node.vid = node_data_field_fecha.vid LEFT JOIN content_field_autor node_data_field_autor ON node.vid = node_data_field_autor.vid LEFT JOIN content_field_pie_foto_portada node_data_field_pie_foto_portada ON node.vid = node_data_field_pie_foto_portada.vid LEFT JOIN content_field_resumen node_data_field_resumen ON node.vid = node_data_field_resumen.vid LEFT JOIN content_field_imagenportada node_data_field_imagenportada ON node.vid = node_data_field_imagenportada.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( ((node.type in ('noticias_escuela')) AND (node.tnid = 0 OR (node.language = 'ca') OR (node.language = 'ca' AND 0 = (SELECT count(lmfh_node.nid) FROM node AS lmfh_node WHERE lmfh_node.tnid = node.tnid AND ((lmfh_node.language = 'ca')))) OR (node.nid = node.tnid AND 0 = (SELECT count(lmfh_node.nid) FROM node AS lmfh_node WHERE lmfh_node.tnid = node.tnid AND ((lmfh_node.language = 'ca') OR (lmfh_node.language = 'ca')))))) AND (DATE_FORMAT(node_data_field_fecha.field_fecha_value, '%Y-%m-%d') <= '2017-08-22') )) count_alias in /var/www/federacion/html/web/public_html/sites/all/modules/views/plugins/views_plugin_pager.inc on line 134.
  • user warning: Can't create/write to file '/tmp/#sql_3e63_0.MYI' (Errcode: 122) query: SELECT DISTINCT node_data_field_autor.field_autor_value AS node_data_field_autor_field_autor_value, node.type AS node_type, node.nid AS nid, node.vid AS node_vid, node_data_field_pie_foto_portada.field_pie_foto_portada_value AS node_data_field_pie_foto_portada_field_pie_foto_portada_valu, node_data_field_resumen.field_resumen_value AS node_data_field_resumen_field_resumen_value, node_data_field_imagenportada.field_imagenportada_fid AS node_data_field_imagenportada_field_imagenportada_fid, node_data_field_imagenportada.field_imagenportada_list AS node_data_field_imagenportada_field_imagenportada_list, node_data_field_imagenportada.field_imagenportada_data AS node_data_field_imagenportada_field_imagenportada_data, node.title AS node_title, node_data_field_fecha.field_fecha_value AS node_data_field_fecha_field_fecha_value FROM node node LEFT JOIN content_field_fecha node_data_field_fecha ON node.vid = node_data_field_fecha.vid LEFT JOIN content_field_autor node_data_field_autor ON node.vid = node_data_field_autor.vid LEFT JOIN content_field_pie_foto_portada node_data_field_pie_foto_portada ON node.vid = node_data_field_pie_foto_portada.vid LEFT JOIN content_field_resumen node_data_field_resumen ON node.vid = node_data_field_resumen.vid LEFT JOIN content_field_imagenportada node_data_field_imagenportada ON node.vid = node_data_field_imagenportada.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( ((node.type in ('noticias_escuela')) AND (node.tnid = 0 OR (node.language = 'ca') OR (node.language = 'ca' AND 0 = (SELECT count(lmfh_node.nid) FROM node AS lmfh_node WHERE lmfh_node.tnid = node.tnid AND ((lmfh_node.language = 'ca')))) OR (node.nid = node.tnid AND 0 = (SELECT count(lmfh_node.nid) FROM node AS lmfh_node WHERE lmfh_node.tnid = node.tnid AND ((lmfh_node.language = 'ca') OR (lmfh_node.language = 'ca')))))) AND (DATE_FORMAT(node_data_field_fecha.field_fecha_value, '%Y-%m-%d') <= '2017-08-22') )ORDER BY node_data_field_fecha_field_fecha_value DESC LIMIT 0, 5 in /var/www/federacion/html/web/public_html/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1093.

UPC Federació

Aquest projecte va nàixer amb la intenció d'oferir una aplicació que facilitara la labor de tresoreria als Centres i Associacions de la Federació de Centres Juvenils Don Bosco i que unificara els criteris que cadascun aplicava a la seus pròpia comptabilitat.

En la seua primera versió era ja una aplicació que s'apropava bastant al fi amb el que s'havia creat, no obstant açò, amb el pas del temps es va vore la necessitat de que els "comptes" dels membres de la Federació estigueren d'acord amb el Pla General Comptable (PGC), amb el que es va optar per la creació, des de zero, d'un programa que, adaptat a les necessitats i la filosofia dels Centres i Associacions, complira també amb el requisit de que funcionara d'acord amb el PGC. El resultat d'aquest treball és este programa "UPC" que, tot i estar en una fase molt inicial, ja és totalment funcional.

Una vegada implantat l'ús del UPC als Centres i Associacions de la Federació CCJJ Don Bosco de la Comunitat Valenciana, en Assemblea General es va considerar que la millor opció a prendre amb aquesta aplicació fóra alliberar-la baix llicència GPL, i aquesta aplicació és el resultat d'aquesta decisió.

Ara mateix està disponible la versió 2.0 del UPC que podeu descarregar des d'ací.