Joomla.it Forum

Joomla! 1.5.x (versione con supporto terminato) => Joomla! 1.5 => : MarcoWorld 08 Feb 2008, 11:21:02

: [migrazione]vecchio prefisso tabelle mos_ (mambo)
: MarcoWorld 08 Feb 2008, 11:21:02

perdonatemi, ma non ho capito una cosa.
devo effettuare la migrazione.
quando installo la 1.5 la devo installare su nuovo db o utilizzo quello 1.0.13?

considerate anche che io ho le tabelle "mos_" poiché il sito era prima con mambo.

grazie

: Re: [migrazione]installare 1.5 su database vecchio o nuovo?
: MarcoWorld 08 Feb 2008, 11:31:45

ho risolto. ho trovato la guida ufficiale che dice di fare ex novo.
per quanto riguarda invece il problema del "mos_"? devo fare qualcosa?
grazie

: Re: [migrazione]installare 1.5 su database vecchio o nuovo?
: MarcoWorld 08 Feb 2008, 11:37:21

mi dà continuamente errore. seguo la guida passo passo, ho caricato via ftp il file migrate.sql, ma nulla.
come "vecchio prefisso tabelle" inserisco "mos_", giusto?

: Re: [migrazione]vecchio prefisso tabelle mos_ (mambo)
: MarcoWorld 08 Feb 2008, 12:24:31

mi esce questo errore:

:

Error at the line 2443: INSERT INTO jos_users (`id`,`user_active`,`username`,`password`,`name`,`usertype`,`block`,`sendEmail`,`gid`,`registerDate`,`lastvisitDate`,`activation`,`params`,`user_session_time`,`user_session_page`,`user_lastvisit`,`user_regdate`,`user_level`,`user_posts`,`user_timezone`,`user_style`,`user_lang`,`user_dateformat`,`user_new_privmsg`,`user_unread_privmsg`,`user_last_privmsg`,`user_emailtime`,`user_viewemail`,`user_attachsig`,`user_allowhtml`,`user_allowbbcode`,`user_allowsmile`,`user_allowavatar`,`user_allow_pm`,`user_allow_viewonline`,`user_notify`,`user_notify_pm`,`user_popup_pm`,`user_rank`,`user_avatar`,`user_avatar_type`,`email`,`user_icq`,`user_website`,`user_from`,`user_from_flag`,`user_sig`,`user_sig_bbcode_uid`,`user_aim`,`user_yim`,`user_msnm`,`user_occ`,`user_interests`,`user_actkey`,`user_newpasswd`,`user_login_tries`,`user_last_login_try`) VALUES ( '-1','0','Anonymous','','','Registered','0','0','1','0000-00-00 00:00:00','0000-00-00 00:00:00','','','0','0','0','0','0','0','0.00','','','','0','0','0','','0','0','0','1','1','1','0','1','0','1','0','','','0','','','','','','','','','','','','','','','0','0');

Query:INSERT INTO jos_users (`id`,`user_active`,`username`,`password`,`name`,`usertype`,`block`,`sendEmail`,`gid`,`registerDate`,`lastvisitDate`,`activation`,`params`,`user_session_time`,`user_session_page`,`user_lastvisit`,`user_regdate`,`user_level`,`user_posts`,`user_timezone`,`user_style`,`user_lang`,`user_dateformat`,`user_new_privmsg`,`user_unread_privmsg`,`user_last_privmsg`,`user_emailtime`,`user_viewemail`,`user_attachsig`,`user_allowhtml`,`user_allowbbcode`,`user_allowsmile`,`user_allowavatar`,`user_allow_pm`,`user_allow_viewonline`,`user_notify`,`user_notify_pm`,`user_popup_pm`,`user_rank`,`user_avatar`,`user_avatar_type`,`email`,`user_icq`,`user_website`,`user_from`,`user_from_flag`,`user_sig`,`user_sig_bbcode_uid`,`user_aim`,`user_yim`,`user_msnm`,`user_occ`,`user_interests`,`user_actkey`,`user_newpasswd`,`user_login_tries`,`user_last_login_try`) VALUES ( '-1','0','Anonymous','','','Registered','0','0','1','0000-00-00 00:00:00','0000-00-00 00:00:00','','','0','0','0','0','0','0','0.00','','','','0','0','0','','0','0','0','1','1','1','0','1','0','1','0','','','0','','','','','','','','','','','','','','','0','0');

MySQL: Unknown column 'user_active' in 'field list'