Visualizzazione risultati 1 fino 5 di 5

Discussione: Errore database artbannerplus

  1. #1
    Guest

    Predefinito Errore database artbannerplus

    Ciao a tutti.
    Dopo aver installato il componente Artbanner plus per Joomla ed essere andato nella sezione Gestione Clienti, Joomla mi ha dato questo errore:


    DB function failed with error number 1146
    Table 'my_aulamagnacafe.jos_artbanners' doesn't exist SQL=SELECT a.*, count(b.id) AS id, count(c.id) as attivi, count(d.id) as terminati, count(e.id) as non_publ, count(f.id) as in_attiv, u.name AS editor FROM my_artbanners_clients AS a LEFT JOIN my_artbanners AS b ON a.cid = b.cid LEFT JOIN jos_artbanners AS c ON a.cid = c.cid and c.state = 1 AND ('2006-08-09' <= c.publish_down_date OR c.publish_down_date = '0000-00-00') AND '2006-08-09' >= c.publish_up_date AND '21:40:51' >= c.publish_up_time AND ('21:40:51' <= c.publish_down_time OR c.publish_down_time = '00:00:00') LEFT JOIN jos_artbanners AS d ON a.cid = d.cid and d.state = 1 AND '2006-08-09' >= d.publish_down_date and d.publish_down_date != '0000-00-00' LEFT JOIN jos_artbanners AS e ON a.cid = e.cid and e.state = 0 LEFT JOIN jos_artbanners AS f ON a.cid = f.cid and f.state = 1 AND '2006-08-09' < f.publish_up_date LEFT JOIN my_users AS u ON u.id = a.checked_out GROUP BY a.cid LIMIT 0,30



    Ho provato a svuotare le tabelle del database create per Artbannerplus ma non cambia niente.
    C'è qualcuno che sà cosa vuol dire?
    Grazie a tutti.

  2. #2
    Guest

    Predefinito

    c'e' per caso un file config???
    se si e' probabile che c'e' un errore nella specifica del prefisso delle tabelle (table prefix)

    magari e' solo jos_artbanners invece che my_aulamagnacafe.jos_artbanners

  3. #3
    Guest

    Predefinito

    No, non esiste un file config.
    Ci sono però i soliti file in php:
    install
    uninstall
    toolbar
    admin
    ec...

    Avevo pensato che forse non sarebbe poi male eliminare le tabelle che artbanner aveva creato nel database e vedere se le ricrea nuove... Ho forse detto una cretinata?

  4. #4
    Guest

    Predefinito

    ti ricordi nell'istallazione (lanciando il file install.php) che configurazione gli hai dato??

    se non ci hai ancora messo mano ti conviene eliminare le tabelle e ricrearle

  5. #5
    Guest

    Predefinito

    Sto cercando di capire quale sia il problema cercando aiuto pure nel forum di Joomla.
    Spero che non dia fastidio a nessuno.
    Sono arrivato al punto di capire che è un problema di tabelle..
    Probabilmente sarebbe da cambiargli il nome usando jos_ invece che my_ ma non so come si comporterebbe il database.
    Posto qui sotto sia la stringa d'errore che mi dà Joomla che il file XML dal quale magari qualcuno può capire il motivo del malfunzionamento.

    Stringa d'errore:
    DB function failed with error number 1146
    Table 'my_aulamagnacafe.jos_artbanners' doesn't exist SQL=SELECT a.*, count(b.id) AS id, count(c.id) as attivi, count(d.id) as terminati, count(e.id) as non_publ, count(f.id) as in_attiv, u.name AS editor FROM my_artbanners_clients AS a LEFT JOIN my_artbanners AS b ON a.cid = b.cid LEFT JOIN jos_artbanners AS c ON a.cid = c.cid and c.state = 1 AND ('2006-08-09' <= c.publish_down_date OR c.publish_down_date = '0000-00-00') AND '2006-08-09' >= c.publish_up_date AND '21:12:32' >= c.publish_up_time AND ('21:12:32' <= c.publish_down_time OR c.publish_down_time = '00:00:00') LEFT JOIN jos_artbanners AS d ON a.cid = d.cid and d.state = 1 AND '2006-08-09' >= d.publish_down_date and d.publish_down_date != '0000-00-00' LEFT JOIN jos_artbanners AS e ON a.cid = e.cid and e.state = 0 LEFT JOIN jos_artbanners AS f ON a.cid = f.cid and f.state = 1 AND '2006-08-09' < f.publish_up_date LEFT JOIN my_users AS u ON u.id = a.checked_out GROUP BY a.cid LIMIT 0,30.

    File XML del componente artbannerplus:
    Codice:
    <?xml version="1.0" ?>
      <mosinstall type="component">
        <name>ArtBannersplus</name>
        <creationDate>13/07/2006</creationDate>
        <author>Dino Porcaro</author>
        <copyright>This component is released under the GNU/GPL License</copyright>
        <authorEmail>bporcaro@gmail.com</authorEmail>
        <authorUrl>www.dinoporcaro.it</authorUrl>
        <version>0.6</version>
        <license>http://www.gnu.org/copyleft/gpl.html GNU/GPL</license>
        <description>ArtBannersPlus, Banner for Joomla</description>
        <files>
          <filename>artbannersplus.php</filename>
          <filename>artbannersplus.class.php</filename>
          <filename>artbannersplus.css</filename>
        </files>
        <images>
            <filename>language/english.php</filename>
            <filename>language/italian.php</filename>
            <filename>language/germanf.php</filename>
            <filename>language/german.php</filename>
            <filename>language/germani.php</filename>
            <filename>language/french.php</filename>
            <filename>language/russian.php</filename>
            <filename>language/brazilian_portuguese.php</filename>
        </images>
        <install>
          <queries>
            <query>DROP TABLE IF EXISTS `#__artbanners_categories`</query>
            <query>DROP TABLE IF EXISTS `#__artbanners_clients`</query>
            <query>DROP TABLE IF EXISTS `#__artbanners`</query>
            <query>
    CREATE TABLE `#__artbanners` (
      `id` int(11) NOT NULL auto_increment,
      `cid` int(11) NOT NULL default '0',
      `tid` int(11) NOT NULL default '0',
      `type` varchar(10) NOT NULL default 'banner',
      `name` varchar(50) NOT NULL default '',
      `imp_total` int(11) NOT NULL default '0',
      `imp_made` int(11) NOT NULL default '0',
      `clicks` int(11) NOT NULL default '0',
      `image_url` varchar(100) NULL default '',
      `click_url` varchar(200) NULL default '',
      `custom_banner_code` text,
      `state` tinyint(1) NOT NULL default '0',
      `last_show` datetime NOT NULL default '0000-00-00 00:00:00',
      `msec` int(11) NOT NULL default '0',
      `publish_up_date` date NOT NULL default '0000-00-00',
      `publish_up_time` time NOT NULL default '00:00:00',
      `publish_down_date` date NOT NULL default '0000-00-00',
      `publish_down_time` time NOT NULL default '00:00:00',
      `reccurtype` tinyint(1) NOT NULL default '0',
      `reccurweekdays` varchar(100) NOT NULL default '',
      `access` int(11) NOT NULL default '0',
      `target` varchar(15) NOT NULL default '',
      `border_value` int(11) NOT NULL default '0',
      `border_style` varchar(11) NOT NULL default '',
      `border_color` varchar(11) NOT NULL default '',
      `click_value` varchar(10) NOT NULL default '',
      `complete_clicks` int(11) NOT NULL default '0',
      `imp_value` varchar(10) NOT NULL default '',
      `dta_mod_clicks` date NULL,
      `password` varchar(40) NOT NULL default '',
      `checked_out` int(11) unsigned NOT NULL default '0',
      `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
      `alt` varchar(200) NULL default '',
      `title` varchar(200) NULL default '',
      PRIMARY KEY  (`id`)
    ) TYPE=MyISAM;
            </query>
            <query>
    CREATE TABLE `#__artbanners_clients` (
      `cid` int(11) NOT NULL auto_increment,
      `name` varchar(60) NOT NULL default '',
      `contact` varchar(60) NOT NULL default '',
      `email` varchar(60) NOT NULL default '',
      `extrainfo` text NOT NULL,
      `published` tinyint(1) NOT NULL default '0',
      `checked_out` int(11) unsigned NOT NULL default '0',
      `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
      PRIMARY KEY  (`cid`)
    ) TYPE=MyISAM;
            </query>
            <query>
    CREATE TABLE `#__artbanners_categories` (
      `id` int(11) NOT NULL auto_increment,
      `name` varchar(255) NOT NULL default '',
      `description` text NOT NULL,
      `published` tinyint(1) NOT NULL default '0',
      `checked_out` int(11) unsigned NOT NULL default '0',
      `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
      PRIMARY KEY  (`id`)
    ) TYPE=MyISAM;
            </query>
          </queries>
        </install>
        <uninstall>
          <queries>
            <query>DROP TABLE IF EXISTS `#__artbanners_categories`</query>
            <query>DROP TABLE IF EXISTS `#__artbanners_clients`</query>
            <query>DROP TABLE IF EXISTS `#__artbanners`</query>
          </queries>
        </uninstall>
        <installfile>install.artbannersplus.php</installfile>
        <uninstallfile>uninstall.artbannersplus.php</uninstallfile>
        <administration>
          <menu>ArtBannersPlus</menu>
            <submenu>
              <menu task="banners">Gestione Banner</menu>
              <menu task="categories">Gestione Categorie</menu>
              <menu task="clients">Gestione Clienti</menu>
              <menu task="information">Informazioni</menu>
            </submenu>
            <files>
              <filename>admin.artbannersplus.php</filename>
              <filename>admin.artbannersplus.html.php</filename>
              <filename>toolbar.artbannersplus.php</filename>
              <filename>toolbar.artbannersplus.html.php</filename>
            </files>
            <images>
              <filename>images/icon.png</filename>
              <filename>images/logo.png</filename>
              <filename>images/preview.png</filename>
              <filename>images/preview_disable.png</filename>
              <filename>images/paypal.gif</filename>
            </images>
         </administration>
      </mosinstall>
    Ultima modifica di seneca : 17-08-2006 alle ore 02.04.04

Regole di scrittura

  • Non puoi creare nuove discussioni
  • Non puoi rispondere ai messaggi
  • Non puoi inserire allegati.
  • Non puoi modificare i tuoi messaggi
  •