#1 Andrea75 Giovedì, 06 Ottobre 2011, 11:25
Salve a tutti,
Sono felice di annunciarvi che la Beta 1 di Icy Phoenix 2.0 è disponibile per il download.
Cosa c'è di nuovo rispetto all'ultima versione stabile
- Il CMS è stato completamente rivisto con nuove funzioni in AJax
- Nuovo sistema di Plugins con moduli in ACP e permessi specifici che possono essere controllati dal CMS
- Funzioni di cache importate da phpBB 3
- Classi DB importate da phpBB 3
- Classi utenti importate da phpBB 3
- Auth System importato da phpBB 3 and integrato nel CMS e nei plugin
- Molte Funzioni di Base importate da phpBB 3
- Gran parte delle SQL rivedute e riscritte
- Nuove classi ricodificate per migliorare l'usabilità e semplificare la codifica e il modding
- Templates ottimizzati
- Funzioni SEO migliorate
- Funzione Tags
- BBCodes personalizzati in ACP
- Chat private in AJAX
- Sondaggi con voti multipli
- Molti altri aggiornamenti e nuove funzioni.... che potrete scoprire installando quest'ultima versione!
Vecchi templates: Si prega di notare che il sistema dei template è stato totalmente rinnovato, per cui quelli progettati per Icy Phoenix 1.3.0.53 o inferiori, non funzioneranno con questa versione. Al momento, a parte gli stili che sono inclusi nel pacchetto di installazione, il solo Prosilver è disponibile su GIT: Icy Phoenix Styles @ GIT.
Traduzioni: Si prega di notare che i pacchetti di lingua per Icy Phoenix 1.3.0.53 non funzionano con questa versione. Tutti i pacchetti quindi dovranno essere aggiornati prima di poterli utilizzare nel vostro sito. È possibile trovare le traduzioni più recenti per le versioni di sviluppo qui: Icy Phoenix Languages @ GIT.
Personalizzazioni e Mod: Si prega di notare che questa versione ha molte differenze di codice da quella precedente, quindi è davvero improbabile che le vecchie personalizzazioni e le mod funzioneranno correttamente su questa versione beta. Se disponete di qualche mod installata e non e non siete in grado aggiornarla da soli, dovrete tenere conto che non sarete in grado di utilizzare tali mods fino a quando qualcuno non le aggiornerà.
Requisiti
Prima di installare Icy Phoenix assicuratevi di avere i seguenti e STRETTAMENTE NECESSARI requisiti:
- Almeno 20 MB di spazio libero nella cartella in cui si desidera installare il pacchetto
- Un server web con PHP (5.2 o maggiore) installato e funzionante (la migliore accoppiata è Linux + Apache)
- Un adatabase MySQL (5 o maggiore) con almento 5MB di spazio libero (naturalmente lo spazio necessario dipende da quanto è grande il vostro sito ... 5MB sono sufficienti per una installazione di base)
- Possibilità di impostare i permessi CHMOD
Questi altri requisiti (anche se non strettamente necessari) sono suggeriti per ottimizzare le prestazioni di Icy Phoenix:
- Webserver con la possibilità di gestire gli .htaccess
- Rewrite Mod installato e funzionante
- Librerie GD (almeno 2.0.28) installate e funzionanti
- Register Globals impostato OFF
Nuova installazione
- Decomprimere il pachetto di Icy Phoenix in una cartella del vostro HD.
- Copiare tutti i files inclusi nel pacchetto di Icy Phoenix in una cartella del webserver (esempio: /icyphoenix/)
- Impostare i permessi a CHMOD 777 per i seguenti files e cartelle (potreste non avere alcune di queste voci nella vostra installazione):
- backup/
- cache/
- cache/cms/
- cache/forums/
- cache/posts/
- cache/sql/
- cache/topics/
- cache/users/
- downloads/
- files/
- files/album/
- files/album/cache/
- files/album/med_cache/
- files/album/users/
- files/album/wm_cache/
- files/images/
- files/screenshots/
- files/thumbs/
- images/avatars/
- logs/
- logs/logfile_attempt_counter.txt
- logs/logfile_blocklist.txt
- logs/logfile_debug_mode.txt
- logs/logfile_malformed_logins.txt
- logs/logfile_spammer.txt
- logs/logfile_worms.txt
- Lanciare la procedura di installazione dalla cartella install/install.php (es. http://www.mysite.com/forum/install/install.php)
- Seguire le istruzioni a video, inserendo ogni dato richiesto e terminare l'installazione.
- Eliminare o rinominare la cartella install
- Personalizzate ciò che ritenete opportuno in files e db (alcuni files necessitano di modifiche manuali, mentre la maggior parte delle opzioni possono essere configurate da ACP e CMS).
- Usare il nuovo sito

Aggiornamento da versione precedente di IP
- Bloccate il sito da ACP
- Fare un backup di tutti i files e del database
- Rimuovere tutti i vecchi file di IP, ma assicurarsi che non si stiano eliminando file diversi che potrebbero essere necessari!
- Quando cancellate i file, prestate attenzioni ai file personalizzati e contenenti informazioni di base come ad es:
- config.php
- backup/
- downloads/
- images/
- files/
- logs/
- Caricare tutti i files di Icy Phoenix nella root
- Applicare i permessi CHMOD richiesti anche per una Nuova installazione. Li trovate nella sezione precedente
- Copiare il file install/convert_utf8_nodbal.php nella root e lanciarlo (è necessario per convertire il vostro vecchio DB in formato UTF-8)
- Cancellare il file convert_utf8_nodbal.php dalla root
- Eseguire install/database_update.php per aggiornare il vostro DB
- Cancellare o rinomincare la cartella install
- Personalizzate ciò che ritenete opportuno in files e db (alcuni files necessitano di modifiche manuali, mentre la maggior parte delle opzioni possono essere configurate da ACP e CMS).
- Usare il nuovo sito
Pacchetti disponibili
Supporto
Come per ogni versione beta, anche questa versione non è ancora supportata, e non la si deve usare su siti online (a meno che non siate consapevoli dei rischi nel farlo!).
Sarebbe quindi più corretto provare questa versione beta esclusivamente in locale per poter lasciare feedback e segnalare eventuali bug, in modo da poter migliorarla in vista del rilascio finale.
Si prega di usare il Bugs Tracker per segnalare eventuali Bug riscontrati.
Enjoy Icy Phoenix!
Luca Libralato
Versione di IP: 2.0.0.86
Server: Linux
____________ My Icy forum: www.lineameteo.it
Staff Member @ Icy Phoenix.it & Icy Phoenix.com
-

Andrea75
-
Amministratore
 bel tempo con possibili rovesci
-
- Età: 45
- Registrato: Mag 2007
- Residenza: Perugia
- Messaggi: 3984
-
2 utenti hanno apprezzato questo messaggio • Condividi
#2 system90 Giovedì, 06 Ottobre 2011, 12:07
ottima notizie....
quando sono entrato nel sito mi ha datto questo errore
Fatal error: Call to undefined method sql_db::sql_fectchrowset() in /home/icyphoit/public_html/includes/sessions.php on line 634
lo steso quando ho fatto il login.
Versione di IP: 2.0.0.86
Server: Linux
-

system90
-
Appassionato

-
- Età: 31
- Registrato: Giugno 2008
- Messaggi: 648
-
#3 Andrea75 Giovedì, 06 Ottobre 2011, 14:15
ottima notizie....
quando sono entrato nel sito mi ha datto questo errore
Fatal error: Call to undefined method sql_db::sql_fectchrowset() in /home/icyphoit/public_html/includes/sessions.php on line 634
lo steso quando ho fatto il login.
Problema già risolto. C'era un errore di sintassi in un file. Il pacchetto è stato già aggiornato. Se lo avete scaricato prima delle 12 di questa mattina, riscaricatelo nuovamente. Ci sono già un paio di fix.
Versione di IP: 2.0.0.86
Server: Linux
____________ My Icy forum: www.lineameteo.it
Staff Member @ Icy Phoenix.it & Icy Phoenix.com
-

Andrea75
-
Amministratore
 bel tempo con possibili rovesci
-
- Età: 45
- Registrato: Mag 2007
- Residenza: Perugia
- Messaggi: 3984
-
#4 Mighty Gorgon Giovedì, 06 Ottobre 2011, 19:29
Se qualcuno avesse un po' di tempo da perdere, servirebbe fare un confronto di prestazioni tra IP 1.3 e questa versione beta. Ovviamente sarebbe meglio testarlo online e con un forum che abbia un po' di dati caricati.
Versione di IP: 3.X
Server: Linux
____________ Luca
-

Mighty Gorgon
-
I wanna love you tender
-
- Età: 46
- Registrato: Mag 2007
- Residenza: Borgo San Michele
- Messaggi: 1675
-
#5 system90 Giovedì, 06 Ottobre 2011, 21:14
appena ho tempo aggiorno il mio e vi faccio sapere
prima mi è uscito questo errore aprendo un collegamento in una nuova finestra.
Parse error: syntax error, unexpected $end in /home/icyphoit/public_html/includes/sessions.php on line 1789
Versione di IP: 2.0.0.86
Server: Linux
-

system90
-
Appassionato

-
- Età: 31
- Registrato: Giugno 2008
- Messaggi: 648
-
#6 Andrea75 Giovedì, 06 Ottobre 2011, 21:31
appena ho tempo aggiorno il mio e vi faccio sapere
prima mi è uscito questo errore aprendo un collegamento in una nuova finestra.
Parse error: syntax error, unexpected $end in /home/icyphoit/public_html/includes/sessions.php on line 1789
In che senso un errore in una finestra? Parliamo di una installazione pulita?
Versione di IP: 2.0.0.86
Server: Linux
____________ My Icy forum: www.lineameteo.it
Staff Member @ Icy Phoenix.it & Icy Phoenix.com
-

Andrea75
-
Amministratore
 bel tempo con possibili rovesci
-
- Età: 45
- Registrato: Mag 2007
- Residenza: Perugia
- Messaggi: 3984
-
#7 system90 Venerdì, 07 Ottobre 2011, 21:24
parlo di questo forum,ho provato ad aprire la pagina del profilo in una nuova finestra ed mi è comparso quell'errore,ho provato la seconda volta e non mi ha dato più quel problema
Versione di IP: 2.0.0.86
Server: Linux
-

system90
-
Appassionato

-
- Età: 31
- Registrato: Giugno 2008
- Messaggi: 648
-
1 utente ha apprezzato questo messaggio • Condividi
#8 TopoMotoV3X Venerdì, 07 Ottobre 2011, 22:37
Quando capitano queste cose fate uno screenshot al volo, o copiate tutto il codice... è più facile capire poi di cosa si tratta... Grazie System90 pe la segnalazione.
Versione di IP: 1.3.0.53b
Server: Linux
____________
Guida ad Icy Phoenix
Mobile Modding Community
-

TopoMotoV3X
-
Staff
 AutoGatto è gay
-
- Età: 47
- Registrato: Agosto 2007
- Residenza: Cagliari
- Messaggi: 893
-
#9 Andrea75 Sabato, 08 Ottobre 2011, 09:53
parlo di questo forum,ho provato ad aprire la pagina del profilo in una nuova finestra ed mi è comparso quell'errore,ho provato la seconda volta e non mi ha dato più quel problema
Credo che tu abbia semplicemente beccato il momento in cui aggiornavo quel file.
Versione di IP: 2.0.0.86
Server: Linux
____________ My Icy forum: www.lineameteo.it
Staff Member @ Icy Phoenix.it & Icy Phoenix.com
-

Andrea75
-
Amministratore
 bel tempo con possibili rovesci
-
- Età: 45
- Registrato: Mag 2007
- Residenza: Perugia
- Messaggi: 3984
-
#10 fracs Giovedì, 13 Ottobre 2011, 11:47
Se qualcuno avesse un po' di tempo da perdere, servirebbe fare un confronto di prestazioni tra IP 1.3 e questa versione beta. Ovviamente sarebbe meglio testarlo online e con un forum che abbia un po' di dati caricati. 
Entro sabato è pronto il mio.
Un abbraccio.
edit: aggiornato!
Versione di IP: 2.0.11.97
Server: Linux
____________ My Problem Child
Ultima modifica di fracs il Venerdì, 14 Ottobre 2011, 09:25, modificato 1 volta in totale
-

fracs
-
VIP
 in attesa di ispirazione
-
- Età: 45
- Registrato: Mag 2007
- Residenza: Cosenza
- Messaggi: 368
-
#11 system90 Venerdì, 14 Ottobre 2011, 21:38
si sa quando uscirà più o meno la versione finale? e che dovrei far creare alcune mod
Versione di IP: 2.0.0.86
Server: Linux
-

system90
-
Appassionato

-
- Età: 31
- Registrato: Giugno 2008
- Messaggi: 648
-
#12 fracs Sabato, 15 Ottobre 2011, 00:26
MG, veramente un gran lavoro!
Versione di IP: 2.0.11.97
Server: Linux
____________ My Problem Child
-

fracs
-
VIP
 in attesa di ispirazione
-
- Età: 45
- Registrato: Mag 2007
- Residenza: Cosenza
- Messaggi: 368
-
#13 vilas Martedì, 18 Ottobre 2011, 19:57
Ciao,
Sto provando già da un po' (6 tentativi),ad aggiornare un Sito di prova, e riscontro sempre gli stessi problemi:
- Il primo Step va a buon fine,(Agg. del Db a UTF8,tramite il file convert_utf8_nodbal.php,lanciato dalla root)
- Il secondo step( install/database_update.php),sembra andare bene, ma alla fine non aggiorna tutto il DB,e restituisce una serie di errori)
- CREATE TABLE `ip_tickets_cat` ( ticket_cat_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT, ticket_cat_title VARCHAR(255) NOT NULL DEFAULT '', ticket_cat_des TEXT NOT NULL, ticket_cat_emails TEXT NOT NULL, PRIMARY KEY (ticket_cat_id) )
- +++ Error: Table 'ip_tickets_cat' already exists
-
- ALTER TABLE `ip_users` ADD `username_clean` varchar(255) DEFAULT '' NOT NULL AFTER `username`
- +++ Error: Duplicate column name 'username_clean'
-
- ALTER TABLE `ip_ina_scores` ADD `user_plays` int(6) default '0' AFTER `score`
- +++ Error: Table 'myvilas.ip_ina_scores' doesn't exist
-
- ALTER TABLE `ip_ina_scores` ADD `play_time` int(11) default '0' AFTER `user_plays`
- +++ Error: Table 'myvilas.ip_ina_scores' doesn't exist
-
- UPDATE ip_cms_block_settings` SET `content` = REPLACE(`content`, '\"', '"')
- +++ Error: 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 'content` = REPLACE(`content`, '\"', '"')' at line 1
-
- UPDATE ip_cms_block_settings` SET `content` = REPLACE(`content`, "\'", "'")
- +++ Error: 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 'content` = REPLACE(`content`, "\'", "'")' at line 1
-
- ALTER TABLE `ip_cms_blocks` CHANGE `block_settings_id` `bs_id` INT(10) UNSIGNED NOT NULL
- +++ Error: Unknown column 'block_settings_id' in 'ip_cms_blocks'
-
- INSERT INTO `___sessions___` SELECT s.session_id, s.session_user_id, s.session_start, s.session_time, s.session_ip, s.session_user_agent, s.session_page, s.session_logged_in, 0, 0, '', 1, 0, s.session_admin FROM `ip_sessions` s ORDER BY s.session_id
- +++ Error: Column count doesn't match value count at row 1
-
- ALTER TABLE `ip_blogs_posts` CHANGE `poster_ip` `poster_ip` varchar(40) NOT NULL DEFAULT ''
- +++ Error: Table 'myvilas.ip_blogs_posts' doesn't exist
-
- ALTER TABLE `ip_guestbooks_posts` CHANGE `poster_ip` `poster_ip` varchar(40) NOT NULL DEFAULT ''
- +++ Error: Table 'myvilas.ip_guestbooks_posts' doesn't exist
-
- UPDATE `ip_blogs_posts` ip SET ip.poster_ip = INET_NTOA(CONV(ip.poster_ip, 16, 10))
- +++ Error: Table 'myvilas.ip_blogs_posts' doesn't exist
-
- UPDATE `ip_guestbooks_posts` ip SET ip.poster_ip = INET_NTOA(CONV(ip.poster_ip, 16, 10))
- +++ Error: Table 'myvilas.ip_guestbooks_posts' doesn't exist
-
- ALTER TABLE `ip_cms_block_settings` DROP `edit_auth`
- +++ Error: Can't DROP 'edit_auth'; check that column/key exists
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 1, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'cms_%' AND is_global = 1
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 2, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'cms_%' AND auth_option NOT IN ('cms_admin', 'cms_settings', 'cms_permissions', 'cms_menu', 'cms_ads') AND is_global = 1
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 3, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option = 'cms_blocks' AND is_global = 1
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 4, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'cmsl_%' AND is_local = 1
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 5, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'cmss_%' AND is_local = 1
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 6, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'cmsb_%' AND is_local = 1
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 7, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'a_%'
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 8, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'a_%' AND auth_option NOT IN ('a_modules', 'a_aauth', 'a_roles')
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 9, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'm_%'
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 10, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'm_%' AND auth_option NOT IN ('m_topicdelete')
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 11, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'm_%' AND auth_option IN ('m_', 'm_topicdelete')
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 12, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'u_%'
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 13, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'u_%' AND auth_option NOT IN ('u_html')
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 14, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'u_%' AND auth_option NOT IN ('u_html')
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 15, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'f_%'
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 16, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'f_%' AND auth_option NOT IN ('f_html')
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 17, auth_option_id, 0 FROM phpbb_acl_options WHERE auth_option = 'f_'
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 18, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'pl_%'
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 19, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'pl_%' AND auth_option NOT IN ('pl_admin', 'pl_delete')
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 20, auth_option_id, 0 FROM phpbb_acl_options WHERE auth_option = 'pl_'
- +++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
-
- INSERT INTO ip_acl_users (user_id, forum_id, auth_option_id, auth_role_id, auth_setting) SELECT user_id, 0, 0, 7, 0 FROM phpbb_users WHERE user_level = 1
- +++ Error: Table 'myvilas.phpbb_users' doesn't exist
-
- INSERT INTO ip_config VALUES ('ip_version', '1.3.24.77')
- +++ Error: Duplicate entry 'ip_version' for key 1
Infine, lanciando il Sito, appaiono questi errori
Visto che altri hanno già aggiornato,sicuramente sbaglio io, ma dove ? Ah, quando ho sostituito i vecchi files con i nuovi,ho mantenuto i vecchi config , common ed index.php !
Versione di IP: 2.0.0.86
Server: Linux
____________ Sito
Ultima modifica di TopoMotoV3X il Martedì, 18 Ottobre 2011, 23:15, modificato 1 volta in totale
-

vilas
-
Interessato

-
- Età: 109
- Registrato: Novembre 2008
- Messaggi: 336
-
#14 TopoMotoV3X Martedì, 18 Ottobre 2011, 20:43
Devi tenere solamente le voci indicate nella guida:
- config.php
- backup/
- downloads/
- images/
- files/
- logs/
Il file più importante è config.php, il resto delle cartelle:
1) Backup = da tenere se hai qualche backup, anche se ancora non mi è ben chiaro come venga riconosciuto un backup del database fatto prima d'aver convertito il DB.
2) Downloads = Se hai files nella tua cartella downloads.
3) Images = per mantenere le immagini che hai attualmente sul forum, tipo Avatar e icone dei forums.
4) Files = Se non hai mai cambiato queste immagini e non hai altro oltre queste immagini di default puoi anche sostituirla con la nuova cartella.
5) Logs = per mantenere i vecchi logs.
Versione di IP: 1.3.0.53b
Server: Linux
____________
Guida ad Icy Phoenix
Mobile Modding Community
Ultima modifica di TopoMotoV3X il Martedì, 18 Ottobre 2011, 20:59, modificato 1 volta in totale
-

TopoMotoV3X
-
Staff
 AutoGatto è gay
-
- Età: 47
- Registrato: Agosto 2007
- Residenza: Cagliari
- Messaggi: 893
-
#15 vilas Martedì, 18 Ottobre 2011, 21:02
Grazie, riproverò tenendo solo il config,ed inserendo i nuovi common e index.php.
Per le cartelle di cui parlavi ,le avevo tenute ,avendo dei files,in "avatars", "files", e "download"
per i backup,,in effetti, la cosa mi pare un po' controversa,e comunque li tengo nella cartella"mysqldumper",che si trova in "root"
Edit:
Come prima,dopo aver lanciato database_update.php c'è il solito errore
Icy Phoenix - Update in progress
The following SQL have not been executed:
CREATE TABLE `ip_tickets_cat` ( ticket_cat_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT, ticket_cat_title VARCHAR(255) NOT NULL DEFAULT '', ticket_cat_des TEXT NOT NULL, ticket_cat_emails TEXT NOT NULL, PRIMARY KEY (ticket_cat_id) )
+++ Error: Table 'ip_tickets_cat' already exists
ALTER TABLE `ip_users` ADD `username_clean` varchar(255) DEFAULT '' NOT NULL AFTER `username`
+++ Error: Duplicate column name 'username_clean'
ALTER TABLE `ip_ina_scores` ADD `user_plays` int(6) default '0' AFTER `score`
+++ Error: Table 'myvilas.ip_ina_scores' doesn't exist
ALTER TABLE `ip_ina_scores` ADD `play_time` int(11) default '0' AFTER `user_plays`
+++ Error: Table 'myvilas.ip_ina_scores' doesn't exist
UPDATE ip_cms_block_settings` SET `content` = REPLACE(`content`, '\"', '"')
+++ Error: 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 'content` = REPLACE(`content`, '\"', '"')' at line 1
UPDATE ip_cms_block_settings` SET `content` = REPLACE(`content`, "\'", "'")
+++ Error: 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 'content` = REPLACE(`content`, "\'", "'")' at line 1
ALTER TABLE `ip_cms_blocks` CHANGE `block_settings_id` `bs_id` INT(10) UNSIGNED NOT NULL
+++ Error: Unknown column 'block_settings_id' in 'ip_cms_blocks'
INSERT INTO `___sessions___` SELECT s.session_id, s.session_user_id, s.session_start, s.session_time, s.session_ip, s.session_user_agent, s.session_page, s.session_logged_in, 0, 0, '', 1, 0, s.session_admin FROM `ip_sessions` s ORDER BY s.session_id
+++ Error: Column count doesn't match value count at row 1
ALTER TABLE `ip_blogs_posts` CHANGE `poster_ip` `poster_ip` varchar(40) NOT NULL DEFAULT ''
+++ Error: Table 'myvilas.ip_blogs_posts' doesn't exist
ALTER TABLE `ip_guestbooks_posts` CHANGE `poster_ip` `poster_ip` varchar(40) NOT NULL DEFAULT ''
+++ Error: Table 'myvilas.ip_guestbooks_posts' doesn't exist
UPDATE `ip_blogs_posts` ip SET ip.poster_ip = INET_NTOA(CONV(ip.poster_ip, 16, 10))
+++ Error: Table 'myvilas.ip_blogs_posts' doesn't exist
UPDATE `ip_guestbooks_posts` ip SET ip.poster_ip = INET_NTOA(CONV(ip.poster_ip, 16, 10))
+++ Error: Table 'myvilas.ip_guestbooks_posts' doesn't exist
ALTER TABLE `ip_cms_block_settings` DROP `edit_auth`
+++ Error: Can't DROP 'edit_auth'; check that column/key exists
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 1, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'cms_%' AND is_global = 1
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 2, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'cms_%' AND auth_option NOT IN ('cms_admin', 'cms_settings', 'cms_permissions', 'cms_menu', 'cms_ads') AND is_global = 1
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 3, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option = 'cms_blocks' AND is_global = 1
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 4, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'cmsl_%' AND is_local = 1
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 5, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'cmss_%' AND is_local = 1
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 6, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'cmsb_%' AND is_local = 1
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 7, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'a_%'
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 8, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'a_%' AND auth_option NOT IN ('a_modules', 'a_aauth', 'a_roles')
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 9, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'm_%'
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 10, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'm_%' AND auth_option NOT IN ('m_topicdelete')
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 11, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'm_%' AND auth_option IN ('m_', 'm_topicdelete')
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 12, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'u_%'
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 13, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'u_%' AND auth_option NOT IN ('u_html')
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 14, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'u_%' AND auth_option NOT IN ('u_html')
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 15, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'f_%'
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 16, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'f_%' AND auth_option NOT IN ('f_html')
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 17, auth_option_id, 0 FROM phpbb_acl_options WHERE auth_option = 'f_'
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 18, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'pl_%'
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 19, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'pl_%' AND auth_option NOT IN ('pl_admin', 'pl_delete')
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 20, auth_option_id, 0 FROM phpbb_acl_options WHERE auth_option = 'pl_'
+++ Error: Table 'myvilas.phpbb_acl_options' doesn't exist
INSERT INTO ip_acl_users (user_id, forum_id, auth_option_id, auth_role_id, auth_setting) SELECT user_id, 0, 0, 7, 0 FROM phpbb_users WHERE user_level = 1
+++ Error: Table 'myvilas.phpbb_users' doesn't exist
INSERT INTO ip_config VALUES ('ip_version', '1.3.24.77')
+++ Error: Duplicate entry 'ip_version' for key 1
E poi un avviso che queste SQL sono state aggiornate
The following SQL have been executed successfully:
SET storage_engine=MYISAM
+++ Successful
INSERT INTO `ip_cms_block_position` (`pkey`, `bposition`, `layout`) VALUES ('gheader', 'gh', 0)
+++ Successful
INSERT INTO `ip_cms_block_position` (`pkey`, `bposition`, `layout`) VALUES ('gfooter', 'gf', 0)
+++ Successful
INSERT INTO `ip_tickets_cat` (ticket_cat_title, ticket_cat_des, ticket_cat_emails) VALUES ('General', 'General', '')
+++ Successful
UPDATE `ip_cms_layout_special` SET page_id = 'viewforum' WHERE page_id = 'viewfforum'
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('forum_limit_edit_time_interval', '1440')
+++ Successful
ALTER TABLE `ip_forums` CHANGE `cat_id` `parent_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
+++ Successful
ALTER TABLE `ip_categories` CHANGE `cat_title` `cat_title` varchar(255) DEFAULT NULL
+++ Successful
ALTER TABLE `ip_forums` CHANGE `forum_name` `forum_name` varchar(255) DEFAULT NULL
+++ Successful
ALTER TABLE `ip_groups` CHANGE `group_color` `group_color` VARCHAR(16) NOT NULL
+++ Successful
ALTER TABLE `ip_users` CHANGE `username` `username` varchar(36) DEFAULT '' NOT NULL
+++ Successful
ALTER TABLE `ip_users` CHANGE `user_color` `user_color` VARCHAR(16) NOT NULL
+++ Successful
ALTER TABLE `ip_categories` ADD `cat_title_clean` varchar(255) DEFAULT '' NOT NULL AFTER `cat_title`
+++ Successful
ALTER TABLE `ip_forums` ADD `forum_type` tinyint(4) DEFAULT '0' NOT NULL AFTER `forum_id`
+++ Successful
ALTER TABLE `ip_forums` ADD `forum_parents` MEDIUMTEXT NOT NULL AFTER `main_type`
+++ Successful
ALTER TABLE `ip_forums` ADD `right_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL AFTER `main_type`
+++ Successful
ALTER TABLE `ip_forums` ADD `left_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL AFTER `main_type`
+++ Successful
ALTER TABLE `ip_forums` ADD `forum_name_clean` varchar(255) DEFAULT '' NOT NULL AFTER `forum_name`
+++ Successful
ALTER TABLE `ip_forums` ADD `forum_limit_edit_time` tinyint(1) default '0' NOT NULL AFTER `forum_notify`
+++ Successful
ALTER TABLE `ip_forums` ADD `forum_last_topic_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL AFTER `forum_topics`
+++ Successful
ALTER TABLE `ip_forums` ADD `forum_last_poster_color` varchar(16) DEFAULT '' NOT NULL AFTER `forum_last_post_id`
+++ Successful
ALTER TABLE `ip_forums` ADD `forum_last_poster_name` varchar(255) DEFAULT '' NOT NULL AFTER `forum_last_post_id`
+++ Successful
ALTER TABLE `ip_forums` ADD `forum_last_post_time` int(11) UNSIGNED DEFAULT '0' NOT NULL AFTER `forum_last_post_id`
+++ Successful
ALTER TABLE `ip_forums` ADD `forum_last_post_subject` varchar(255) DEFAULT '' NOT NULL AFTER `forum_last_post_id`
+++ Successful
ALTER TABLE `ip_forums` ADD `forum_last_poster_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL AFTER `forum_last_post_id`
+++ Successful
ALTER TABLE `ip_topics` ADD `topic_tags` varchar(255) DEFAULT '' NOT NULL AFTER `topic_title`
+++ Successful
ALTER TABLE `ip_topics` ADD `topic_similar_topics` varchar(255) DEFAULT '' NOT NULL AFTER `topic_desc`
+++ Successful
ALTER TABLE `ip_topics` ADD `topic_title_clean` varchar(255) DEFAULT '' NOT NULL AFTER `topic_title`
+++ Successful
ALTER TABLE `ip_topics` ADD `topic_ftitle_clean` varchar(255) DEFAULT '' NOT NULL AFTER `topic_title_clean`
+++ Successful
ALTER TABLE `ip_topics` ADD `topic_first_post_time` int(11) UNSIGNED DEFAULT '0' NOT NULL AFTER `topic_first_post_id`
+++ Successful
ALTER TABLE `ip_topics` ADD `topic_first_poster_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL AFTER `topic_first_post_time`
+++ Successful
ALTER TABLE `ip_topics` ADD `topic_first_poster_name` varchar(255) DEFAULT '' NOT NULL AFTER `topic_first_poster_id`
+++ Successful
ALTER TABLE `ip_topics` ADD `topic_first_poster_color` varchar(16) DEFAULT '' NOT NULL AFTER `topic_first_poster_name`
+++ Successful
ALTER TABLE `ip_topics` ADD `topic_last_post_time` int(11) UNSIGNED DEFAULT '0' NOT NULL AFTER `topic_last_post_id`
+++ Successful
ALTER TABLE `ip_topics` ADD `topic_last_poster_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL AFTER `topic_last_post_time`
+++ Successful
ALTER TABLE `ip_topics` ADD `topic_last_poster_name` varchar(255) DEFAULT '' NOT NULL AFTER `topic_last_post_id`
+++ Successful
ALTER TABLE `ip_topics` ADD `topic_last_poster_color` varchar(16) DEFAULT '' NOT NULL AFTER `topic_last_poster_name`
+++ Successful
UPDATE `ip_forums` SET forum_type = 1
+++ Successful
UPDATE `ip_forums` f, `ip_topics` t, `ip_posts` p, `ip_users` u SET f.forum_last_topic_id = p.topic_id, f.forum_last_poster_id = p.poster_id, f.forum_last_post_subject = t.topic_title, f.forum_last_post_time = p.post_time, f.forum_last_poster_name = u.username, f.forum_last_poster_color = u.user_color WHERE f.forum_last_post_id = p.post_id AND t.topic_id = p.topic_id AND p.poster_id = u.user_id
+++ Successful
UPDATE `ip_topics` t, `ip_posts` p, `ip_posts` p2, `ip_users` u, `ip_users` u2 SET t.topic_first_post_id = p.post_id, t.topic_first_post_time = p.post_time, t.topic_first_poster_id = p.poster_id, t.topic_first_poster_name = u.username, t.topic_first_poster_color = u.user_color, t.topic_last_post_id = p2.post_id, t.topic_last_post_time = p2.post_time, t.topic_last_poster_id = p2.poster_id, t.topic_last_poster_name = u2.username, t.topic_last_poster_color = u2.user_color WHERE t.topic_first_post_id = p.post_id AND p.poster_id = u.user_id AND t.topic_last_post_id = p2.post_id AND p2.poster_id = u2.user_id
+++ Successful
CREATE TABLE `ip_topics_tags_list` ( `tag_text` varchar(50) binary NOT NULL DEFAULT '', `tag_id` mediumint(8) unsigned NOT NULL auto_increment, `tag_count` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`tag_text`), KEY `tag_id` (`tag_id`) )
+++ Successful
CREATE TABLE `ip_topics_tags_match` ( `tag_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `topic_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0', KEY `tag_id` (`tag_id`), KEY `topic_id` (`topic_id`) )
+++ Successful
INSERT INTO `ip_config` SELECT x.config_name, x.config_value FROM `ip_xs_news_cfg` x
+++ Successful
RENAME TABLE `ip_xs_news_cfg` TO `_old_ip_xs_news_cfg`
+++ Successful
UPDATE `ip_cms_blocks` SET blockfile = REPLACE(blockfile,'blocks_imp_','')
+++ Successful
DELETE FROM `ip_config` WHERE config_name = 'smart_header'
+++ Successful
DELETE FROM `ip_config` WHERE config_name = 'disable_ftr'
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ftr_topic_number', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ftr_message', 'Before going on... please make sure you have read and understood this post. It contains important informations regarding this site.')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ftr_install_time', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ftr_disable', '1')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ftr_all_users', '0')
+++ Successful
DROP TABLE `ip_force_read`
+++ Successful
ALTER TABLE `ip_force_read_users` DROP `read`
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('allow_html_only_for_admins', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('display_tags_box', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('allow_moderators_edit_tags', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('enable_custom_bbcodes', '0')
+++ Successful
CREATE TABLE `ip_bbcodes` ( bbcode_id mediumint(8) UNSIGNED NOT NULL auto_increment, bbcode_tag varchar(16) DEFAULT '' NOT NULL, bbcode_helpline varchar(255) DEFAULT '' NOT NULL, display_on_posting tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, bbcode_match text NOT NULL, bbcode_tpl mediumtext NOT NULL, first_pass_match mediumtext NOT NULL, first_pass_replace mediumtext NOT NULL, second_pass_match mediumtext NOT NULL, second_pass_replace mediumtext NOT NULL, PRIMARY KEY (bbcode_id), KEY display_on_post (display_on_posting) )
+++ Successful
ALTER TABLE `ip_ajax_shoutbox` ADD `shout_room` VARCHAR(255) NOT NULL DEFAULT ''
+++ Successful
CREATE TABLE `ip_plugins` ( plugin_name VARCHAR(255) NOT NULL DEFAULT '', plugin_dir VARCHAR(255) NOT NULL DEFAULT '', plugin_enabled tinyint(2) NOT NULL DEFAULT 0, PRIMARY KEY (plugin_name) )
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('forum_tags_type', '0')
+++ Successful
ALTER TABLE `ip_users` ADD `user_private_chat_alert` VARCHAR(255) NOT NULL AFTER `user_last_privmsg`
+++ Successful
CREATE TABLE `ip_plugins_config` ( `config_name` varchar(255) NOT NULL DEFAULT '', `config_value` TEXT NOT NULL, PRIMARY KEY (`config_name`) )
+++ Successful
ALTER TABLE `ip_users` CHANGE `user_login_tries` `user_login_attempts` TINYINT(4) DEFAULT '0' NOT NULL
+++ Successful
ALTER TABLE `ip_users` CHANGE `user_last_login_try` `user_last_login_attempt` INT(11) NOT NULL DEFAULT '0'
+++ Successful
ALTER TABLE `ip_users` CHANGE `user_password` `user_password` VARCHAR(40) DEFAULT '' NOT NULL
+++ Successful
ALTER TABLE `ip_users` CHANGE `user_newpasswd` `user_newpasswd` VARCHAR(40) DEFAULT '' NOT NULL
+++ Successful
ALTER TABLE `ip_users` ADD `user_passchg` INT(11) UNSIGNED DEFAULT '0' NOT NULL AFTER `user_password`
+++ Successful
ALTER TABLE `ip_users` ADD `user_pass_convert` TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL AFTER `user_passchg`
+++ Successful
ALTER TABLE `ip_users` ADD `user_form_salt` VARCHAR(32) DEFAULT '' NOT NULL AFTER `user_pass_convert`
+++ Successful
ALTER TABLE `ip_users` ADD `user_email_hash` BIGINT(20) DEFAULT '0' NOT NULL AFTER `user_email`
+++ Successful
ALTER TABLE `ip_users` ADD `user_options` INT(11) UNSIGNED DEFAULT '895' NOT NULL AFTER `user_setbm`
+++ Successful
ALTER TABLE `ip_users` DROP `ct_last_pw_reset`
+++ Successful
ALTER TABLE `ip_users` DROP `ct_last_pw_change`
+++ Successful
ALTER TABLE `ip_users` DROP `ct_login_count`
+++ Successful
ALTER TABLE `ip_users` DROP `ct_login_vconfirm`
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_ipblock_enabled', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'ctracker_ipblock_enabled'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_ipblock_logsize', '100')
+++ Successful
UPDATE ip_config SET config_value = '100' WHERE config_name = 'ctracker_ipblock_logsize'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_auto_recovery', '1')
+++ Successful
UPDATE ip_config SET config_value = '1' WHERE config_name = 'ctracker_auto_recovery'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_vconfirm_guest', '1')
+++ Successful
UPDATE ip_config SET config_value = '1' WHERE config_name = 'ctracker_vconfirm_guest'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_autoban_mails', '1')
+++ Successful
UPDATE ip_config SET config_value = '1' WHERE config_name = 'ctracker_autoban_mails'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_detect_misconfiguration', '1')
+++ Successful
UPDATE ip_config SET config_value = '1' WHERE config_name = 'ctracker_detect_misconfiguration'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_search_time_guest', '30')
+++ Successful
UPDATE ip_config SET config_value = '30' WHERE config_name = 'ctracker_search_time_guest'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_search_time_user', '20')
+++ Successful
UPDATE ip_config SET config_value = '20' WHERE config_name = 'ctracker_search_time_user'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_search_count_guest', '2')
+++ Successful
UPDATE ip_config SET config_value = '2' WHERE config_name = 'ctracker_search_count_guest'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_search_count_user', '4')
+++ Successful
UPDATE ip_config SET config_value = '4' WHERE config_name = 'ctracker_search_count_user'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_massmail_protection', '1')
+++ Successful
UPDATE ip_config SET config_value = '1' WHERE config_name = 'ctracker_massmail_protection'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_reg_protection', '1')
+++ Successful
UPDATE ip_config SET config_value = '1' WHERE config_name = 'ctracker_reg_protection'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_reg_blocktime', '30')
+++ Successful
UPDATE ip_config SET config_value = '30' WHERE config_name = 'ctracker_reg_blocktime'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_reg_lastip', '151.32.136.37')
+++ Successful
UPDATE ip_config SET config_value = '151.32.136.37' WHERE config_name = 'ctracker_reg_lastip'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_pwreset_time', '20')
+++ Successful
UPDATE ip_config SET config_value = '20' WHERE config_name = 'ctracker_pwreset_time'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_massmail_time', '20')
+++ Successful
UPDATE ip_config SET config_value = '20' WHERE config_name = 'ctracker_massmail_time'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_spammer_time', '30')
+++ Successful
UPDATE ip_config SET config_value = '30' WHERE config_name = 'ctracker_spammer_time'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_spammer_postcount', '4')
+++ Successful
UPDATE ip_config SET config_value = '4' WHERE config_name = 'ctracker_spammer_postcount'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_spammer_blockmode', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'ctracker_spammer_blockmode'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_loginfeature', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'ctracker_loginfeature'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_pw_reset_feature', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'ctracker_pw_reset_feature'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_reg_last_reg', '1307630052')
+++ Successful
UPDATE ip_config SET config_value = '1307630052' WHERE config_name = 'ctracker_reg_last_reg'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_login_history', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'ctracker_login_history'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_login_history_count', '10')
+++ Successful
UPDATE ip_config SET config_value = '10' WHERE config_name = 'ctracker_login_history_count'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_login_ip_check', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'ctracker_login_ip_check'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_pw_validity', '30')
+++ Successful
UPDATE ip_config SET config_value = '30' WHERE config_name = 'ctracker_pw_validity'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_pw_complex_min', '4')
+++ Successful
UPDATE ip_config SET config_value = '4' WHERE config_name = 'ctracker_pw_complex_min'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_pw_complex_mode', '1')
+++ Successful
UPDATE ip_config SET config_value = '1' WHERE config_name = 'ctracker_pw_complex_mode'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_pw_control', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'ctracker_pw_control'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_pw_complex', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'ctracker_pw_complex'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_last_file_scan', '1244899837')
+++ Successful
UPDATE ip_config SET config_value = '1244899837' WHERE config_name = 'ctracker_last_file_scan'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_last_checksum_scan', '1244899806')
+++ Successful
UPDATE ip_config SET config_value = '1244899806' WHERE config_name = 'ctracker_last_checksum_scan'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_logsize_logins', '100')
+++ Successful
UPDATE ip_config SET config_value = '100' WHERE config_name = 'ctracker_logsize_logins'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_logsize_spammer', '100')
+++ Successful
UPDATE ip_config SET config_value = '100' WHERE config_name = 'ctracker_logsize_spammer'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_reg_ip_scan', '1')
+++ Successful
UPDATE ip_config SET config_value = '1' WHERE config_name = 'ctracker_reg_ip_scan'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_global_message', 'Avevo pensato di fare un gemellaggio con il Sito di un amico e vorrei sentire le vostre opinioni,in merito. Perchè non esprimete il vostro parere,sul nostro Forum nella Sezone "4 Chiacchere",ne sarei felice! Il Sito è:http//www.max-web.it')
+++ Successful
UPDATE ip_config SET config_value = 'Avevo pensato di fare un gemellaggio con il Sito di un amico e vorrei sentire le vostre opinioni,in merito. Perchè non esprimete il vostro parere,sul nostro Forum nella Sezone "4 Chiacchere",ne sarei felice! Il Sito è:http//www.max-web.it' WHERE config_name = 'ctracker_global_message'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_global_message_type', '1')
+++ Successful
UPDATE ip_config SET config_value = '1' WHERE config_name = 'ctracker_global_message_type'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_logincount', '2')
+++ Successful
UPDATE ip_config SET config_value = '2' WHERE config_name = 'ctracker_logincount'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_search_feature_enabled', '1')
+++ Successful
UPDATE ip_config SET config_value = '1' WHERE config_name = 'ctracker_search_feature_enabled'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_spam_attack_boost', '1')
+++ Successful
UPDATE ip_config SET config_value = '1' WHERE config_name = 'ctracker_spam_attack_boost'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_spam_keyword_det', '1')
+++ Successful
UPDATE ip_config SET config_value = '1' WHERE config_name = 'ctracker_spam_keyword_det'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ctracker_footer_layout', '3')
+++ Successful
UPDATE ip_config SET config_value = '3' WHERE config_name = 'ctracker_footer_layout'
+++ Successful
DROP TABLE `ip_ctracker_config`
+++ Successful
DELETE FROM `ip_config` WHERE config_name = 'ctracker_detect_misconfiguration'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('upload_dir', 'files')
+++ Successful
UPDATE ip_config SET config_value = 'files' WHERE config_name = 'upload_dir'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('upload_img', 'images/attach_post.png')
+++ Successful
UPDATE ip_config SET config_value = 'images/attach_post.png' WHERE config_name = 'upload_img'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('topic_icon', 'images/disk_multiple.png')
+++ Successful
UPDATE ip_config SET config_value = 'images/disk_multiple.png' WHERE config_name = 'topic_icon'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('display_order', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'display_order'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('max_filesize', '262144')
+++ Successful
UPDATE ip_config SET config_value = '262144' WHERE config_name = 'max_filesize'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('attachment_quota', '52428800')
+++ Successful
UPDATE ip_config SET config_value = '52428800' WHERE config_name = 'attachment_quota'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('max_filesize_pm', '262144')
+++ Successful
UPDATE ip_config SET config_value = '262144' WHERE config_name = 'max_filesize_pm'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('max_attachments', '3')
+++ Successful
UPDATE ip_config SET config_value = '3' WHERE config_name = 'max_attachments'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('max_attachments_pm', '1')
+++ Successful
UPDATE ip_config SET config_value = '1' WHERE config_name = 'max_attachments_pm'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('disable_mod', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'disable_mod'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('allow_pm_attach', '1')
+++ Successful
UPDATE ip_config SET config_value = '1' WHERE config_name = 'allow_pm_attach'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('attachment_topic_review', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'attachment_topic_review'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('allow_ftp_upload', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'allow_ftp_upload'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('show_apcp', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'show_apcp'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('attach_version', '2.4.5')
+++ Successful
UPDATE ip_config SET config_value = '2.4.5' WHERE config_name = 'attach_version'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('default_upload_quota', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'default_upload_quota'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('default_pm_quota', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'default_pm_quota'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ftp_server', '')
+++ Successful
UPDATE ip_config SET config_value = '' WHERE config_name = 'ftp_server'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ftp_path', '')
+++ Successful
UPDATE ip_config SET config_value = '' WHERE config_name = 'ftp_path'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('download_path', '')
+++ Successful
UPDATE ip_config SET config_value = '' WHERE config_name = 'download_path'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ftp_user', '')
+++ Successful
UPDATE ip_config SET config_value = '' WHERE config_name = 'ftp_user'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ftp_pass', '')
+++ Successful
UPDATE ip_config SET config_value = '' WHERE config_name = 'ftp_pass'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('ftp_pasv_mode', '1')
+++ Successful
UPDATE ip_config SET config_value = '1' WHERE config_name = 'ftp_pasv_mode'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('img_display_inlined', '1')
+++ Successful
UPDATE ip_config SET config_value = '1' WHERE config_name = 'img_display_inlined'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('img_max_width', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'img_max_width'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('img_max_height', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'img_max_height'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('img_link_width', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'img_link_width'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('img_link_height', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'img_link_height'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('img_create_thumbnail', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'img_create_thumbnail'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('img_min_thumb_filesize', '12000')
+++ Successful
UPDATE ip_config SET config_value = '12000' WHERE config_name = 'img_min_thumb_filesize'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('img_imagick', '')
+++ Successful
UPDATE ip_config SET config_value = '' WHERE config_name = 'img_imagick'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('use_gd2', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'use_gd2'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('wma_autoplay', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'wma_autoplay'
+++ Successful
INSERT INTO ip_config (config_name, config_value) VALUES ('flash_autoplay', '0')
+++ Successful
UPDATE ip_config SET config_value = '0' WHERE config_name = 'flash_autoplay'
+++ Successful
DROP TABLE `ip_attachments_config`
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_site_history_interval', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_site_history_last_run', '0')
+++ Successful
CREATE TABLE `ip_acl_groups` ( `group_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `auth_option_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `auth_role_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `auth_setting` tinyint(2) NOT NULL DEFAULT '0', KEY `group_id` (`group_id`), KEY `auth_opt_id` (`auth_option_id`), KEY `auth_role_id` (`auth_role_id`) )
+++ Successful
CREATE TABLE `ip_acl_options` ( `auth_option_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `auth_option` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '', `is_global` tinyint(1) unsigned NOT NULL DEFAULT '0', `is_local` tinyint(1) unsigned NOT NULL DEFAULT '0', `founder_only` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`auth_option_id`), UNIQUE KEY `auth_option` (`auth_option`) )
+++ Successful
CREATE TABLE `ip_acl_roles` ( `role_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `role_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `role_description` text COLLATE utf8_bin NOT NULL, `role_type` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '', `role_order` smallint(4) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`role_id`), KEY `role_type` (`role_type`), KEY `role_order` (`role_order`) )
+++ Successful
CREATE TABLE `ip_acl_roles_data` ( `role_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `auth_option_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `auth_setting` tinyint(2) NOT NULL DEFAULT '0', PRIMARY KEY (`role_id`,`auth_option_id`), KEY `ath_op_id` (`auth_option_id`) )
+++ Successful
CREATE TABLE `ip_acl_users` ( `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `auth_option_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `auth_role_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `auth_setting` tinyint(2) NOT NULL DEFAULT '0', KEY `user_id` (`user_id`), KEY `auth_option_id` (`auth_option_id`), KEY `auth_role_id` (`auth_role_id`) )
+++ Successful
ALTER TABLE `ip_users` DROP `ct_last_mail`
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('captcha_width', '316')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('captcha_height', '61')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('captcha_background_color', '#E5ECF9')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('captcha_jpeg', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('captcha_jpeg_quality', '50')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('captcha_pre_letters', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('captcha_pre_letters_great', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('captcha_font', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('captcha_chess', '2')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('captcha_ellipses', '2')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('captcha_arcs', '2')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('captcha_lines', '2')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('captcha_image', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('captcha_gammacorrect', '1.4')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('captcha_foreground_lattice_x', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('captcha_foreground_lattice_y', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('captcha_lattice_color', '#FFFFFF')
+++ Successful
DROP TABLE `ip_captcha_config`
+++ Successful
TRUNCATE TABLE `ip_hacks_list`
+++ Successful
UPDATE `ip_users` SET `user_pass_convert` = '1'
+++ Successful
DELETE FROM `ip_config` WHERE config_name = 'thumbnail_lightbox'
+++ Successful
DELETE FROM `ip_album_config` WHERE config_name = 'enable_mooshow'
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('smtp_port', '25')
+++ Successful
ALTER TABLE `ip_plugins` ADD `plugin_version` VARCHAR(255) NOT NULL DEFAULT '' AFTER `plugin_name`
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cms_version', '2.0.0')
+++ Successful
CREATE TABLE `ip_cms_block_settings` ( `bs_id` int(10) NOT NULL AUTO_INCREMENT, `user_id` int(10) NOT NULL, `name` varchar(255) NOT NULL default '', `content` text NOT NULL , `blockfile` varchar(255) NOT NULL default '', `view` tinyint(1) NOT NULL default 0, `type` tinyint(1) NOT NULL default 1, `groups` tinytext NOT NULL, `locked` tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (`bs_id`) )
+++ Successful
INSERT INTO `ip_cms_block_settings` SELECT b.bid, 0, b.title, b.content, b.blockfile, b.view, b.type, b.groups, 1 FROM `ip_cms_blocks` b ORDER BY b.bid
+++ Successful
ALTER TABLE `ip_cms_blocks` DROP `content`
+++ Successful
ALTER TABLE `ip_cms_blocks` DROP `blockfile`
+++ Successful
ALTER TABLE `ip_cms_blocks` DROP `view`
+++ Successful
ALTER TABLE `ip_cms_blocks` DROP `type`
+++ Successful
ALTER TABLE `ip_cms_blocks` DROP `groups`
+++ Successful
ALTER TABLE `ip_cms_blocks` ADD `bs_id` int(10) UNSIGNED NOT NULL AFTER `bid`
+++ Successful
ALTER TABLE `ip_cms_blocks` ADD `block_cms_id` int(10) UNSIGNED NOT NULL AFTER `bs_id`
+++ Successful
UPDATE `ip_cms_blocks` SET `bs_id` = `bid`
+++ Successful
ALTER TABLE `ip_cms_layout` ADD `layout_cms_id` int(10) UNSIGNED NOT NULL AFTER `template`
+++ Successful
ALTER TABLE `ip_topics_watch` ADD `forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `topic_id`
+++ Successful
UPDATE `ip_topics_watch` tw, `ip_topics` t SET tw.forum_id = t.forum_id WHERE tw.topic_id = t.topic_id
+++ Successful
DROP TABLE `ip_confirm`
+++ Successful
CREATE TABLE `ip_confirm` ( confirm_id char(32) DEFAULT '' NOT NULL, session_id char(32) DEFAULT '' NOT NULL, confirm_type tinyint(3) DEFAULT '0' NOT NULL, code varchar(8) DEFAULT '' NOT NULL, seed int(10) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (session_id, confirm_id), KEY confirm_type (confirm_type) )
+++ Successful
CREATE TABLE `ip_poll_options` ( poll_option_id tinyint(4) DEFAULT '0' NOT NULL, topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, poll_option_text text NOT NULL, poll_option_total mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, KEY poll_opt_id (poll_option_id), KEY topic_id (topic_id) )
+++ Successful
CREATE TABLE `ip_poll_votes` ( topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, poll_option_id tinyint(4) DEFAULT '0' NOT NULL, vote_user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, vote_user_ip varchar(40) DEFAULT '' NOT NULL, KEY topic_id (topic_id), KEY vote_user_id (vote_user_id), KEY vote_user_ip (vote_user_ip) )
+++ Successful
ALTER TABLE `ip_topics` ADD `poll_title` varchar(255) DEFAULT '' NOT NULL AFTER `topic_type`
+++ Successful
ALTER TABLE `ip_topics` ADD `poll_start` int(11) UNSIGNED DEFAULT '0' NOT NULL AFTER `poll_title`
+++ Successful
ALTER TABLE `ip_topics` ADD `poll_length` int(11) UNSIGNED DEFAULT '0' NOT NULL AFTER `poll_start`
+++ Successful
ALTER TABLE `ip_topics` ADD `poll_max_options` tinyint(4) DEFAULT '1' NOT NULL AFTER `poll_length`
+++ Successful
ALTER TABLE `ip_topics` ADD `poll_last_vote` int(11) UNSIGNED DEFAULT '0' NOT NULL AFTER `poll_max_options`
+++ Successful
ALTER TABLE `ip_topics` ADD `poll_vote_change` tinyint(1) UNSIGNED DEFAULT '0' NOT NULL AFTER `poll_last_vote`
+++ Successful
UPDATE ip_topics t, ip_vote_desc vd SET t.poll_title = vd.vote_text, t.poll_start = vd.vote_start, t.poll_length = vd.vote_length, t.poll_max_options = 1, t.poll_vote_change = 0 WHERE t.topic_vote = 1 AND vd.topic_id = t.topic_id
+++ Successful
INSERT INTO `ip_poll_options` SELECT vr.vote_option_id, vd.topic_id, vr.vote_option_text, vr.vote_result FROM `ip_vote_desc` vd, `ip_vote_results` vr WHERE vr.vote_id = vd.vote_id ORDER BY vd.topic_id ASC, vd.vote_id ASC, vr.vote_option_id ASC
+++ Successful
INSERT INTO `ip_poll_votes` SELECT vd.topic_id, vv.vote_cast, vv.vote_user_id, vv.vote_user_ip FROM `ip_vote_desc` vd, `ip_vote_voters` vv WHERE vd.vote_id = vv.vote_id ORDER BY vd.topic_id ASC, vv.vote_user_id ASC
+++ Successful
ALTER TABLE `ip_topics` DROP `topic_vote`
+++ Successful
DROP TABLE `ip_vote_desc`
+++ Successful
DROP TABLE `ip_vote_results`
+++ Successful
DROP TABLE `ip_vote_voters`
+++ Successful
ALTER TABLE `ip_users` ADD `user_jabber` varchar(255) DEFAULT '' NOT NULL AFTER `user_icq`
+++ Successful
ALTER TABLE `ip_users` CHANGE `user_aim` `user_aim` varchar(255) DEFAULT '' NOT NULL
+++ Successful
ALTER TABLE `ip_users` CHANGE `user_icq` `user_icq` varchar(15) DEFAULT '' NOT NULL
+++ Successful
ALTER TABLE `ip_users` CHANGE `user_msnm` `user_msnm` varchar(255) DEFAULT '' NOT NULL
+++ Successful
ALTER TABLE `ip_users` CHANGE `user_skype` `user_skype` varchar(255) DEFAULT '' NOT NULL
+++ Successful
ALTER TABLE `ip_users` CHANGE `user_yim` `user_yim` varchar(255) DEFAULT '' NOT NULL
+++ Successful
ALTER TABLE `ip_users` CHANGE `user_interests` `user_interests` varchar(255) DEFAULT '' NOT NULL
+++ Successful
ALTER TABLE `ip_users` CHANGE `user_occ` `user_occ` varchar(255) DEFAULT '' NOT NULL
+++ Successful
CREATE TABLE `ip_posts_likes` ( topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, like_time int(11) UNSIGNED DEFAULT '0' NOT NULL, KEY topic_id (topic_id), KEY post_id (post_id), KEY user_id (user_id) )
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('disable_likes_posts', '1')
+++ Successful
ALTER TABLE `ip_forums` ADD `forum_likes` tinyint(1) NOT NULL DEFAULT '0' AFTER `forum_thanks`
+++ Successful
ALTER TABLE `ip_posts` ADD `post_likes` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `post_bluecard`
+++ Successful
ALTER TABLE `ip_users` ADD `user_first_name` varchar(255) DEFAULT '' NOT NULL AFTER `username_clean`
+++ Successful
ALTER TABLE `ip_users` ADD `user_last_name` varchar(255) DEFAULT '' NOT NULL AFTER `user_first_name`
+++ Successful
ALTER TABLE `ip_users` ADD `user_facebook` varchar(255) DEFAULT '' NOT NULL AFTER `user_yim`
+++ Successful
ALTER TABLE `ip_users` ADD `user_twitter` varchar(255) DEFAULT '' NOT NULL AFTER `user_facebook`
+++ Successful
ALTER TABLE `ip_users` ADD `user_type` tinyint(2) DEFAULT '0' NOT NULL AFTER `user_regdate`
+++ Successful
ALTER TABLE `ip_users` ADD `user_mask` tinyint(1) DEFAULT '0' NOT NULL AFTER `user_active`
+++ Successful
ALTER TABLE `ip_ranks` ADD `rank_show_title` tinyint(1) DEFAULT '1' NOT NULL AFTER `rank_special`
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ip_admins_only', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('attachments_stats', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_lock_hour', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_birthdays_interval', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('cron_birthdays_last_run', '0')
+++ Successful
DELETE FROM `ip_config` WHERE config_name = 'enable_digests'
+++ Successful
DELETE FROM `ip_config` WHERE config_name = 'digests_php_cron'
+++ Successful
DELETE FROM `ip_config` WHERE config_name = 'digests_php_cron_lock'
+++ Successful
DELETE FROM `ip_config` WHERE config_name = 'digests_last_send_time'
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('robots_index_topics_no_replies', '1')
+++ Successful
ALTER TABLE `ip_rate_results` CHANGE `rating_time` `rating_time` int(11) NOT NULL DEFAULT '0'
+++ Successful
ALTER TABLE `ip_users` ADD `user_permissions` mediumtext NOT NULL AFTER `user_mask`
+++ Successful
ALTER TABLE `ip_users` ADD `user_perm_from` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL AFTER `user_permissions`
+++ Successful
ALTER TABLE `ip_users` CHANGE `user_http_agents` `user_browser` varchar(255) DEFAULT '' NOT NULL
+++ Successful
ALTER TABLE `ip_attachments_stats` CHANGE `user_http_agents` `user_browser` varchar(255) DEFAULT '' NOT NULL
+++ Successful
CREATE TABLE `___sessions___` ( `session_id` varchar(32) NOT NULL DEFAULT '', `session_user_id` mediumint(8) NOT NULL DEFAULT '0', `session_start` int(11) NOT NULL DEFAULT '0', `session_time` int(11) NOT NULL DEFAULT '0', `session_ip` varchar(40) NOT NULL DEFAULT '0', `session_browser` varchar(255) DEFAULT '' NOT NULL, `session_page` varchar(255) NOT NULL DEFAULT '', `session_logged_in` tinyint(1) NOT NULL DEFAULT '0', `session_forum_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `session_topic_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `session_last_visit` int(11) UNSIGNED DEFAULT '0' NOT NULL, `session_forwarded_for` varchar(255) DEFAULT '' NOT NULL, `session_viewonline` tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, `session_autologin` tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, `session_admin` tinyint(1) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`session_id`), KEY `session_user_id` (`session_user_id`), KEY `session_fid` (`session_forum_id`) )
+++ Successful
RENAME TABLE `ip_sessions` TO `_old_ip_sessions`
+++ Successful
RENAME TABLE `___sessions___` TO `ip_sessions`
+++ Successful
ALTER TABLE `ip_groups` CHANGE `group_name` `group_name` varchar(255) DEFAULT '' NOT NULL
+++ Successful
ALTER TABLE `ip_groups` CHANGE `group_description` `group_description` text NOT NULL
+++ Successful
ALTER TABLE `ip_groups` ADD `group_founder_manage` tinyint(1) UNSIGNED DEFAULT '0' NOT NULL AFTER `group_type`
+++ Successful
ALTER TABLE `ip_groups` ADD `group_display` tinyint(1) UNSIGNED DEFAULT '0' NOT NULL AFTER `group_description`
+++ Successful
ALTER TABLE `ip_groups` ADD `group_sig_chars` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL AFTER `group_legend_order`
+++ Successful
ALTER TABLE `ip_groups` ADD `group_receive_pm` tinyint(1) UNSIGNED DEFAULT '0' NOT NULL AFTER `group_sig_chars`
+++ Successful
ALTER TABLE `ip_groups` ADD `group_message_limit` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL AFTER `group_receive_pm`
+++ Successful
ALTER TABLE `ip_groups` ADD `group_max_recipients` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL AFTER `group_message_limit`
+++ Successful
ALTER TABLE `ip_groups` ADD `group_skip_auth` tinyint(1) UNSIGNED DEFAULT '0' NOT NULL AFTER `group_max_recipients`
+++ Successful
ALTER TABLE `ip_groups` ADD INDEX `group_legend_name` (`group_legend`, `group_name`)
+++ Successful
ALTER TABLE `ip_user_group` CHANGE `user_pending` `user_pending` tinyint(1) DEFAULT '1' NOT NULL
+++ Successful
ALTER TABLE `ip_user_group` ADD `group_leader` tinyint(1) UNSIGNED DEFAULT '0' NOT NULL AFTER `user_id`
+++ Successful
ALTER TABLE `ip_user_group` ADD INDEX `group_leader` (`group_leader`)
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('limit_load', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('limit_search_load', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('ip_check', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('browser_check', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('referer_validation', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('force_server_vars', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('session_last_gc', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('active_sessions', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('form_token_lifetime', '7200')
+++ Successful
CREATE TABLE `ip_log` ( `log_id` mediumint(8) UNSIGNED NOT NULL auto_increment, `log_type` tinyint(4) DEFAULT '0' NOT NULL, `user_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `forum_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `topic_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `reportee_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `log_ip` varchar(40) DEFAULT '' NOT NULL, `log_time` int(11) UNSIGNED DEFAULT '0' NOT NULL, `log_operation` text NOT NULL, `log_data` mediumtext NOT NULL, PRIMARY KEY (`log_id`), KEY log_type (`log_type`), KEY forum_id (`forum_id`), KEY topic_id (`topic_id`), KEY reportee_id (`reportee_id`), KEY user_id (`user_id`) )
+++ Successful
ALTER TABLE `ip_banlist` CHANGE `ban_time` `ban_start` int(11) DEFAULT NULL
+++ Successful
ALTER TABLE `ip_banlist` CHANGE `ban_expire_time` `ban_end` int(11) DEFAULT NULL
+++ Successful
ALTER TABLE `ip_ajax_shoutbox` CHANGE `shouter_ip` `shouter_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_ajax_shoutbox_sessions` CHANGE `session_ip` `session_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_album_comment` CHANGE `comment_user_ip` `comment_user_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_album_rate` CHANGE `rate_user_ip` `rate_user_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_attachments_stats` CHANGE `user_ip` `user_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_banlist` CHANGE `ban_ip` `ban_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_ctracker_loginhistory` CHANGE `ct_login_ip` `ct_login_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_dl_banlist` CHANGE `user_ip` `user_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_dl_stats` CHANGE `user_ip` `user_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_kb_votes` CHANGE `votes_ip` `votes_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_links` CHANGE `user_ip` `user_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_links` CHANGE `last_user_ip` `last_user_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_logins` CHANGE `login_ip` `login_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_pa_download_info` CHANGE `downloader_ip` `downloader_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_pa_files` CHANGE `poster_ip` `poster_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_pa_votes` CHANGE `votes_ip` `votes_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_poll_votes` CHANGE `vote_user_ip` `vote_user_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_posts` CHANGE `poster_ip` `poster_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_privmsgs` CHANGE `privmsgs_ip` `privmsgs_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_privmsgs_archive` CHANGE `privmsgs_ip` `privmsgs_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_rate_results` CHANGE `user_ip` `user_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_referrers` CHANGE `referrer_ip` `referrer_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_registration` CHANGE `registration_user_ip` `registration_user_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_sessions` CHANGE `session_ip` `session_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_sessions_keys` CHANGE `last_ip` `last_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_shout` CHANGE `shout_ip` `shout_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_users` CHANGE `ct_last_used_ip` `ct_last_used_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_users` CHANGE `ct_last_ip` `ct_last_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
ALTER TABLE `ip_users` CHANGE `user_registered_ip` `user_registered_ip` varchar(40) NOT NULL DEFAULT ''
+++ Successful
UPDATE `ip_ajax_shoutbox` ip SET ip.shouter_ip = INET_NTOA(CONV(ip.shouter_ip, 16, 10))
+++ Successful
UPDATE `ip_ajax_shoutbox_sessions` ip SET ip.session_ip = INET_NTOA(CONV(ip.session_ip, 16, 10))
+++ Successful
UPDATE `ip_album_comment` ip SET ip.comment_user_ip = INET_NTOA(CONV(ip.comment_user_ip, 16, 10))
+++ Successful
UPDATE `ip_album_rate` ip SET ip.rate_user_ip = INET_NTOA(CONV(ip.rate_user_ip, 16, 10))
+++ Successful
UPDATE `ip_attachments_stats` ip SET ip.user_ip = INET_NTOA(CONV(ip.user_ip, 16, 10))
+++ Successful
UPDATE `ip_banlist` ip SET ip.ban_ip = INET_NTOA(CONV(ip.ban_ip, 16, 10))
+++ Successful
UPDATE `ip_dl_banlist` ip SET ip.user_ip = INET_NTOA(CONV(ip.user_ip, 16, 10))
+++ Successful
UPDATE `ip_dl_stats` ip SET ip.user_ip = INET_NTOA(CONV(ip.user_ip, 16, 10))
+++ Successful
UPDATE `ip_kb_votes` ip SET ip.votes_ip = INET_NTOA(CONV(ip.votes_ip, 16, 10))
+++ Successful
UPDATE `ip_links` ip SET ip.user_ip = INET_NTOA(CONV(ip.user_ip, 16, 10))
+++ Successful
UPDATE `ip_links` ip SET ip.last_user_ip = INET_NTOA(CONV(ip.last_user_ip, 16, 10))
+++ Successful
UPDATE `ip_logins` ip SET ip.login_ip = INET_NTOA(CONV(ip.login_ip, 16, 10))
+++ Successful
UPDATE `ip_pa_download_info` ip SET ip.downloader_ip = INET_NTOA(CONV(ip.downloader_ip, 16, 10))
+++ Successful
UPDATE `ip_pa_files` ip SET ip.poster_ip = INET_NTOA(CONV(ip.poster_ip, 16, 10))
+++ Successful
UPDATE `ip_pa_votes` ip SET ip.votes_ip = INET_NTOA(CONV(ip.votes_ip, 16, 10))
+++ Successful
UPDATE `ip_poll_votes` ip SET ip.vote_user_ip = INET_NTOA(CONV(ip.vote_user_ip, 16, 10))
+++ Successful
UPDATE `ip_posts` ip SET ip.poster_ip = INET_NTOA(CONV(ip.poster_ip, 16, 10))
+++ Successful
UPDATE `ip_privmsgs` ip SET ip.privmsgs_ip = INET_NTOA(CONV(ip.privmsgs_ip, 16, 10))
+++ Successful
UPDATE `ip_privmsgs_archive` ip SET ip.privmsgs_ip = INET_NTOA(CONV(ip.privmsgs_ip, 16, 10))
+++ Successful
UPDATE `ip_rate_results` ip SET ip.user_ip = INET_NTOA(CONV(ip.user_ip, 16, 10))
+++ Successful
UPDATE `ip_referrers` ip SET ip.referrer_ip = INET_NTOA(CONV(ip.referrer_ip, 16, 10))
+++ Successful
UPDATE `ip_registration` ip SET ip.registration_user_ip = INET_NTOA(CONV(ip.registration_user_ip, 16, 10))
+++ Successful
UPDATE `ip_sessions` ip SET ip.session_ip = INET_NTOA(CONV(ip.session_ip, 16, 10))
+++ Successful
UPDATE `ip_sessions_keys` ip SET ip.last_ip = INET_NTOA(CONV(ip.last_ip, 16, 10))
+++ Successful
UPDATE `ip_shout` ip SET ip.shout_ip = INET_NTOA(CONV(ip.shout_ip, 16, 10))
+++ Successful
UPDATE `ip_users` ip SET ip.user_registered_ip = INET_NTOA(CONV(ip.user_registered_ip, 16, 10))
+++ Successful
INSERT INTO `ip_bots` (`bot_name`, `bot_color`, `bot_agent`, `bot_ip`) VALUES ('Bing', 'Bing', 'bingbot/', '')
+++ Successful
ALTER TABLE `ip_users` ADD `user_post_sortby_dir` varchar(1) DEFAULT 'a' NOT NULL AFTER `user_posts_per_page`
+++ Successful
ALTER TABLE `ip_users` ADD `user_post_sortby_type` varchar(1) DEFAULT 't' NOT NULL AFTER `user_posts_per_page`
+++ Successful
ALTER TABLE `ip_users` ADD `user_post_show_days` smallint(4) UNSIGNED DEFAULT '0' NOT NULL AFTER `user_posts_per_page`
+++ Successful
ALTER TABLE `ip_users` ADD `user_topic_sortby_dir` varchar(1) DEFAULT 'd' NOT NULL AFTER `user_posts_per_page`
+++ Successful
ALTER TABLE `ip_users` ADD `user_topic_sortby_type` varchar(1) DEFAULT 't' NOT NULL AFTER `user_posts_per_page`
+++ Successful
ALTER TABLE `ip_users` ADD `user_topic_show_days` smallint(4) UNSIGNED DEFAULT '0' NOT NULL AFTER `user_posts_per_page`
+++ Successful
CREATE TABLE `ip_moderator_cache` ( `forum_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `user_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `username` varchar(255) DEFAULT '' NOT NULL, `group_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `group_name` varchar(255) DEFAULT '' NOT NULL, `display_on_index` tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, KEY `disp_idx` (`display_on_index`), KEY `forum_id` (`forum_id`) )
+++ Successful
CREATE TABLE `ip_modules` ( `module_id` mediumint(8) UNSIGNED NOT NULL auto_increment, `module_enabled` tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, `module_display` tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, `module_basename` varchar(255) DEFAULT '' NOT NULL, `module_class` varchar(10) DEFAULT '' NOT NULL, `parent_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `left_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `right_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, `module_langname` varchar(255) DEFAULT '' NOT NULL, `module_mode` varchar(255) DEFAULT '' NOT NULL, `module_auth` varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (`module_id`), KEY `left_right_id` (`left_id`, `right_id`), KEY `module_enabled` (`module_enabled`), KEY `class_left_id` (`module_class`, `left_id`) )
+++ Successful
UPDATE ip_cms_blocks SET active = 0 WHERE bposition IN ('hh', 'hl', 'hc', 'fc', 'fr', 'ff')
+++ Successful
ALTER TABLE `ip_logs` CHANGE `log_desc` `log_desc` mediumtext NOT NULL
+++ Successful
ALTER TABLE `ip_forums` CHANGE `forum_rules` `forum_rules_switch` tinyint(1) unsigned NOT NULL DEFAULT '0'
+++ Successful
ALTER TABLE `ip_forums` ADD `forum_rules_in_posting` tinyint(1) unsigned NOT NULL DEFAULT '0' AFTER `forum_rules_switch`
+++ Successful
ALTER TABLE `ip_forums` ADD `forum_rules_in_viewtopic` tinyint(1) unsigned NOT NULL DEFAULT '0' AFTER `forum_rules_switch`
+++ Successful
ALTER TABLE `ip_forums` ADD `forum_rules_in_viewforum` tinyint(1) unsigned NOT NULL DEFAULT '0' AFTER `forum_rules_switch`
+++ Successful
ALTER TABLE `ip_forums` ADD `forum_rules_custom_title` varchar(80) NOT NULL DEFAULT '' AFTER `forum_rules_switch`
+++ Successful
ALTER TABLE `ip_forums` ADD `forum_rules_display_title` tinyint(1) NOT NULL DEFAULT '1' AFTER `forum_rules_switch`
+++ Successful
ALTER TABLE `ip_forums` ADD `forum_rules` text NOT NULL AFTER `forum_rules_switch`
+++ Successful
UPDATE ip_forums f, ip_forums_rules fr SET f.forum_rules = fr.rules, f.forum_rules_display_title = fr.rules_display_title, f.forum_rules_custom_title = fr.rules_custom_title, f.forum_rules_in_viewforum = fr.rules_in_viewforum, f.forum_rules_in_viewtopic = fr.rules_in_viewtopic, f.forum_rules_in_posting = fr.rules_in_posting WHERE f.forum_id = fr.forum_id
+++ Successful
DROP TABLE `ip_forums_rules`
+++ Successful
DELETE FROM `ip_config` WHERE config_name = 'cms_dock'
+++ Successful
DELETE FROM `ip_config` WHERE config_name = 'cms_style'
+++ Successful
ALTER TABLE `ip_users` ADD `user_flickr` varchar(255) DEFAULT '' NOT NULL AFTER `user_twitter`
+++ Successful
ALTER TABLE `ip_users` ADD `user_googleplus` varchar(255) DEFAULT '' NOT NULL AFTER `user_flickr`
+++ Successful
ALTER TABLE `ip_users` ADD `user_youtube` varchar(255) DEFAULT '' NOT NULL AFTER `user_googleplus`
+++ Successful
ALTER TABLE `ip_users` ADD `user_linkedin` varchar(255) DEFAULT '' NOT NULL AFTER `user_youtube`
+++ Successful
ALTER TABLE `ip_users` CHANGE `user_style` `user_style` MEDIUMINT(8) NULL DEFAULT NULL
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('site_meta_keywords', 'your keywords, comma, separated')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('site_meta_keywords_switch', '1')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('site_meta_description', 'Your Site Description')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('site_meta_description_switch', '1')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('site_meta_author', 'Author')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('site_meta_author_switch', '1')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('site_meta_copyright', 'Copyright')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('site_meta_copyright_switch', '1')
+++ Successful
ALTER TABLE `ip_posts` CHANGE `post_text` `post_text` MEDIUMTEXT NOT NULL
+++ Successful
ALTER TABLE `ip_posts` CHANGE `post_text_compiled` `post_text_compiled` MEDIUMTEXT NOT NULL
+++ Successful
ALTER TABLE `ip_users` DROP `user_cms_level`
+++ Successful
ALTER TABLE `ip_cms_blocks` DROP `edit_auth`
+++ Successful
ALTER TABLE `ip_cms_layout` DROP `edit_auth`
+++ Successful
ALTER TABLE `ip_cms_layout_special` DROP `edit_auth`
+++ Successful
TRUNCATE TABLE `ip_acl_groups`
+++ Successful
TRUNCATE TABLE `ip_acl_options`
+++ Successful
TRUNCATE TABLE `ip_acl_roles`
+++ Successful
TRUNCATE TABLE `ip_acl_roles_data`
+++ Successful
TRUNCATE TABLE `ip_acl_users`
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('cms_', 1, 0, 0)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('cms_admin', 1, 0, 0)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('cms_settings', 1, 0, 0)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('cms_layouts', 1, 0, 0)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('cms_layouts_special', 1, 0, 0)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('cms_blocks', 1, 0, 0)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('cms_blocks_global', 1, 0, 0)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('cms_permissions', 1, 0, 0)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('cms_menu', 1, 0, 0)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('cms_ads', 1, 0, 0)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('cmsl_', 0, 1, 0)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('cmsl_admin', 0, 1, 0)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('cmss_', 0, 1, 0)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('cmss_admin', 0, 1, 0)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('cmsb_', 0, 1, 0)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('cmsb_admin', 0, 1, 0)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global) VALUES ('a_', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global) VALUES ('a_modules', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global) VALUES ('a_roles', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global) VALUES ('a_aauth', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global) VALUES ('a_mauth', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global) VALUES ('a_uauth', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global) VALUES ('a_fauth', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global) VALUES ('a_authgroups', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global) VALUES ('a_authusers', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global) VALUES ('a_viewauth', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global) VALUES ('a_group', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global) VALUES ('a_user', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_local, is_global) VALUES ('m_', 1, 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_local, is_global) VALUES ('m_topicdelete', 1, 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global) VALUES ('u_', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global) VALUES ('u_html', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_local) VALUES ('f_', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_local) VALUES ('f_html', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_local) VALUES ('f_topicdelete', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global) VALUES ('pl_', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global) VALUES ('pl_admin', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global) VALUES ('pl_input', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global) VALUES ('pl_edit', 1)
+++ Successful
INSERT INTO ip_acl_options (auth_option, is_global) VALUES ('pl_delete', 1)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (1, 'ROLE_CMS_CONTENT_MANAGER', 'ROLE_CMS_CONTENT_MANAGER_DESCRIPTION', 'cms_', 1)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (2, 'ROLE_CMS_REVIEWER', 'ROLE_CMS_REVIEWER_DESCRIPTION', 'cms_', 2)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (3, 'ROLE_CMS_PUBLISHER', 'ROLE_CMS_PUBLISHER_DESCRIPTION', 'cms_', 3)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (4, 'ROLE_CMS_CONTENT_MANAGER', 'ROLE_CMS_CONTENT_MANAGER_DESCRIPTION', 'cmsl_', 1)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (5, 'ROLE_CMS_CONTENT_MANAGER', 'ROLE_CMS_CONTENT_MANAGER_DESCRIPTION', 'cmss_', 1)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (6, 'ROLE_CMS_CONTENT_MANAGER', 'ROLE_CMS_CONTENT_MANAGER_DESCRIPTION', 'cmsb_', 1)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (7, 'ROLE_ADMIN_FULL', 'ROLE_ADMIN_FULL_DESCRIPTION', 'a_', 1)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (8, 'ROLE_ADMIN_STANDARD', 'ROLE_ADMIN_STANDARD_DESCRIPTION', 'a_', 2)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (9, 'ROLE_MOD_FULL', 'ROLE_MOD_FULL_DESCRIPTION', 'm_', 1)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (10, 'ROLE_MOD_STANDARD', 'ROLE_MOD_STANDARD_DESCRIPTION', 'm_', 2)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (11, 'ROLE_MOD_SIMPLE', 'ROLE_MOD_SIMPLE_DESCRIPTION', 'm_', 3)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (12, 'ROLE_USER_FULL', 'ROLE_USER_FULL_DESCRIPTION', 'u_', 1)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (13, 'ROLE_USER_STANDARD', 'ROLE_USER_STANDARD_DESCRIPTION', 'u_', 2)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (14, 'ROLE_USER_LIMITED', 'ROLE_USER_LIMITED_DESCRIPTION', 'u_', 3)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (15, 'ROLE_FORUM_FULL', 'ROLE_FORUM_FULL_DESCRIPTION', 'f_', 1)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (16, 'ROLE_FORUM_STANDARD', 'ROLE_FORUM_STANDARD_DESCRIPTION', 'f_', 2)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (17, 'ROLE_FORUM_NOACCESS', 'ROLE_FORUM_NOACCES_DESCRIPTIONS', 'f_', 3)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (18, 'ROLE_PLUGINS_FULL', 'ROLE_PLUGINS_FULL_DESCRIPTION', 'pl_', 1)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (19, 'ROLE_PLUGINS_STANDARD', 'ROLE_PLUGINS_STANDARD_DESCRIPTION', 'pl_', 2)
+++ Successful
INSERT INTO ip_acl_roles (role_id, role_name, role_description, role_type, role_order) VALUES (20, 'ROLE_PLUGINS_NOACCESS', 'ROLE_PLUGINS_NOACCES_DESCRIPTIONS', 'pl_', 3)
+++ Successful
ALTER TABLE `ip_users` ADD `user_cms_auth` text NOT NULL AFTER `user_mask`
+++ Successful
ALTER TABLE `ip_users` DROP `user_lastlogon`
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('spam_posts_number', '5')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('spam_disable_url', '1')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('spam_hide_signature', '1')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('spam_post_edit_interval', '60')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('mobile_style_disable', '0')
+++ Successful
INSERT INTO `ip_config` (`config_name`, `config_value`) VALUES ('session_gc', '3600')
+++ Successful
UPDATE ip_config SET config_value = '1.3.24.77' WHERE config_name = 'ip_version'
+++ Successful
UPDATE ip_config SET config_value = '.0.23' WHERE `config_name` = 'version'
+++ Successful
UPDATE ip_config SET config_value = '2.0.0' WHERE config_name = 'cms_version'
+++ Successful
UPDATE ip_album_config SET config_value = '1.5.0' WHERE config_name = 'fap_version'
+++ Successful
UPDATE ip_config SET `config_value` = '2.4.5' WHERE `config_name` = 'attach_version'
+++ Successful
UPDATE ip_config SET `config_value` = '3.0.7' WHERE `config_name` = 'upi2db_version'
+++ Successful
Update completed!
Please click Here to return to menu!
Di conseguenza,richiamando il Sito,compare infine,questa finestra d'errore :
Versione di IP: 2.0.0.86
Server: Linux
____________ Sito
Ultima modifica di TopoMotoV3X il Martedì, 18 Ottobre 2011, 23:11, modificato 4 volte in totale
-

vilas
-
Interessato

-
- Età: 109
- Registrato: Novembre 2008
- Messaggi: 336
-
#16 TopoMotoV3X Martedì, 18 Ottobre 2011, 23:24
Gli errori non sono gli stessi, qualcuno dichiara che le tabelle già esistono, quindi mi fa capire che non hai rifatto l'aggiornamento, l'hai solamente ripreso, per fare in modo che l'upgrade sia come previsto devi cancellare tutto, DB e files del forum, reinserisci il backup del database che hai fatto prima di cominciare l'upgrade, reinserisci i files della versione 1.3.0.53a che hai salvato prima di lanciare l'upgrade e ricominci da capo.
Fammi sapere.
Versione di IP: 1.3.0.53b
Server: Linux
____________
Guida ad Icy Phoenix
Mobile Modding Community
-

TopoMotoV3X
-
Staff
 AutoGatto è gay
-
- Età: 47
- Registrato: Agosto 2007
- Residenza: Cagliari
- Messaggi: 893
-
#17 vilas Mercoledì, 19 Ottobre 2011, 10:51
Tu dici di partire dalla vers.1.3.0.53a , ma io ero partito dalla b ,che è la versione che ho attualmente sul mio Sito; questo di prova,sarebbe lo "specchio" del mio Sito principale, dove avevo, come detto, applicato a suo tempo la patch per la b !
Comunque provo a ripartire dalla "a"
Edit:
Appena terminato questo post,sono andato sul Sito di prova,e nonostante gli errori che hai visto,il Sito si è aperto,ed è aggiornato,ecco la prova
Com'è possibile ?
Versione di IP: 2.0.0.86
Server: Linux
____________ Sito
Ultima modifica di vilas il Mercoledì, 19 Ottobre 2011, 10:56, modificato 1 volta in totale
-

vilas
-
Interessato

-
- Età: 109
- Registrato: Novembre 2008
- Messaggi: 336
-
#18 Andrea75 Mercoledì, 19 Ottobre 2011, 12:41
Credo che quello di Topomoto fosse solo un lapsus... a o b non fa differenza in questo caso.
Avevi svuotato la cache (completamente) dopo aver aggiornato?
Versione di IP: 2.0.0.86
Server: Linux
____________ My Icy forum: www.lineameteo.it
Staff Member @ Icy Phoenix.it & Icy Phoenix.com
-

Andrea75
-
Amministratore
 bel tempo con possibili rovesci
-
- Età: 45
- Registrato: Mag 2007
- Residenza: Perugia
- Messaggi: 3984
-
#19 vilas Mercoledì, 19 Ottobre 2011, 13:47
Per la cache,mi prendi in contropiede, non riesco a ricordare se l'avevo fatto,pur sapendo che è la prassi quando si fa un qualunque aggiornamento!
Visto che stamattina il Sito di prova è andato subito,nonostante ieri sera dava quegli errori che ho illustrato,direi di no !
Comunque ora lo stresso un po',(Icy 1.3.24.77 )  per studiarne le nuove funzionalità,anche se ancora non ho capito a cosa serva il plugin scaricato a
parte, ma ci arrivo.................. !
Grazie
Una domanda per topomoto............... secondo te la tua Mod. "Tab menù in header" ,funzionerà sulla 1.3.24.77 ?
Versione di IP: 2.0.0.86
Server: Linux
____________ Sito
Ultima modifica di vilas il Mercoledì, 19 Ottobre 2011, 14:29, modificato 2 volte in totale
-

vilas
-
Interessato

-
- Età: 109
- Registrato: Novembre 2008
- Messaggi: 336
-
#20 TopoMotoV3X Mercoledì, 19 Ottobre 2011, 17:33
Quando ho scritto 1.3.0.53a intendevo la tua versione precedente all'upgrade, poi non ho badato se .053, .053a o .053b
Il fatto che ora non ci siano errori visibili nel forum non vuol dire che tutto funzioni a dovere, quando farai l'upgrade definitivo ti consiglio di farlo con la massima precisione nei vari passaggi... eviteresti problemi futuri.
Per quanto riguarda Tab Menu, non ha nulla di particolare, dovrebbe funzionare magari con qualche accorgimento.. non appena sarà rilasciata la versione definitiva mi occuperò d'aggiornare le mie piccole mods..
Versione di IP: 1.3.0.53b
Server: Linux
____________
Guida ad Icy Phoenix
Mobile Modding Community
-

TopoMotoV3X
-
Staff
 AutoGatto è gay
-
- Età: 47
- Registrato: Agosto 2007
- Residenza: Cagliari
- Messaggi: 893
-
Questo argomento è stato utile?
Questo argomento è stato utile?
Condividi Argomento |
|
 |
Inserisci un link per questo argomento |
URL |
|
BBCode |
|
HTML |
|
Lista Permessi
|
Non puoi inserire nuovi Argomenti Non puoi rispondere ai Messaggi Non puoi modificare i tuoi Messaggi Non puoi cancellare i tuoi Messaggi Non puoi votare nei Sondaggi Non puoi allegare files Puoi scaricare gli allegati Non puoi inserire eventi calendario
|
|
|
|
|