Annunci

#1 2007-07-19 16:18:39

Lucky
Membro
2007-02-24
37

footer_counter

Ho un problema installando il plugin footer counter di Vincent installando l'ultima versione o le precedenti e attivandolami escono questi messaggi nella parte header della home:

Codice:

   SELECT count( * ) AS visit_ctr, 
          count( `image_id` IS NOT NULL ) AS image_ctr FROM phpwebgallery_history  
      WHERE TIMESTAMP(date, time) >= ( NOW()  -  INTERVAL 60 MINUTE )  
     UNION  ALL  SELECT count( * ), count( `image_id` IS NOT NULL )
      FROM  phpwebgallery_history  
      WHERE TIMESTAMP(date, time) >= ( NOW()  -  INTERVAL 1  DAY  ) ;
[mysql error 1064] You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '(date, time) >= ( NOW()  -  INTERVAL 60 MINUTE )  
     UNION  

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /web/htdocs/www.andjclub.it/home/gallery/plugins/footer_count/main.inc.php on line 41

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /web/htdocs/www.andjclub.it/home/gallery/plugins/footer_count/main.inc.php on line 44
     SELECT count( DISTINCT IP ) AS guest_ctr FROM  phpwebgallery_history  
      WHERE TIMESTAMP(date, time) >= ( NOW()  -  INTERVAL 60 MINUTE )  
        AND user_id = 2 ;
[mysql error 1064] You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '(date, time) >= ( NOW()  -  INTERVAL 60 MINUTE )  
        AND 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /web/htdocs/www.andjclub.it/home/gallery/plugins/footer_count/main.inc.php on line 70
     SELECT DISTINCT(user_id) AS member, u.username 
      FROM  phpwebgallery_history AS h
      LEFT JOIN `phpwebgallery_users` AS u 
             ON h.user_id = u.id  
      WHERE TIMESTAMP(date, time) >= ( NOW()  -  INTERVAL 60 MINUTE ) 
      AND user_id <> 2 ;
[mysql error 1064] You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '(date, time) >= ( NOW()  -  INTERVAL 60 MINUTE ) 
      AND use

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /web/htdocs/www.andjclub.it/home/gallery/plugins/footer_count/main.inc.php on line 87

premetto che ho un database mysql hostato su aruba, versioe 4.

qualche aiuto?

Non in linea

#2 2007-07-19 23:03:03

rio
Piwigo Team
Parigi
2006-07-24
1713

Re: footer_counter

Lucky ha scritto:

... il plugin footer counter di Vincent installando l'ultima versione o le precedenti ...

Cioé?!!


-> /<Ä®¿M <-
http://riohome.free.fr
Il WIKI e un buon' aiuto per incominciare. Le dritte e personalizzazioni sono nel wiki, tutto e nel wiki!

Non in linea

Footer forum

Sito realizzato grazie a FluxBB

github twitter newsletter Donazioni Piwigo.org © 2002-2024 · Contattaci