Errore database in remoto

[horus78]

Errore database in remoto

Allora vi espongo il mio grosso problema.
In locale joomla mi va perfetto, funziona tutto. utilizzo Xampp, mySql 5.0.51a, PhpMyAdmin 2.9.2
In remoto (Ho hosting linux con aruba) ho MySQL 4.0.27-standard-log, PhpMyAdmin 2.11.5
Quando vado a caricare il database mi esce questo errore
Vi prego aiutatemi
phpMyAdmin SQL Dump
-- version 2.9.2

--
-- Host: localhost
-- Generato il: 18 Mar, 2008 at 11:55 AM
-- Versione MySQL: 5.0.51
-- Versione PHP: 5.2.5

-- Database: joomla

---

--
-- Struttura della tabella jos_banner

CREATE TABLE jos_banner (
bid int( 11 ) NOT NULL AUTO_INCREMENT ,
cid int( 11 ) NOT NULL default '0',
type varchar( 10 ) COLLATE latin1_general_ci NOT NULL default 'banner',
name varchar( 50 ) COLLATE latin1_general_ci NOT NULL default '',
imptotal int( 11 ) NOT NULL default '0',
impmade int( 11 ) NOT NULL default '0',
clicks int( 11 ) NOT NULL default '0',
imageurl varchar( 100 ) COLLATE latin1_general_ci NOT NULL default '',
clickurl varchar( 200 ) COLLATE latin1_general_ci NOT NULL default '',
date datetime default NULL ,
showBanner tinyint( 1 ) NOT NULL default '0',
checked_out tinyint( 1 ) NOT NULL default '0',
checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',
editor varchar( 50 ) COLLATE latin1_general_ci default NULL ,
custombannercode text COLLATE latin1_general_ci,
PRIMARY KEY ( bid ) ,
KEY viewbanner ( showBanner )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci AUTO_INCREMENT =3;

Messaggio di MySQL:
#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 'collate latin1_general_ci NOT NULL default 'banner',
name v

[surfwork]

Prova a togliere "collate latin1_general_ci ..." dalle querry.

[horus78]

Tutto ok!! O quasi...

Mi mancano solo le tabelle della Zoom Gallery!

Ecco il messaggio di errore:

CREATE TABLE jos_zoom_comments (
cmtid int( 11 ) NOT NULL AUTO_INCREMENT ,
imgid int( 11 ) NOT NULL default '0',
cmtname varchar( 40 ) NOT NULL default '',
cmtcontent text NOT NULL ,
cmtdate timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
PRIMARY KEY ( cmtid ) ,
KEY imgid ( imgid )
) ENGINE = MYISAM ;

**Messaggio di MySQL: **
#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 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY

[surfwork]

Prova a togliere CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP.

ciao