Test Joomla su database PostgreSQL

[gpongelli]

provando ad installare il pacchetto segnalato da Gabriele:
https://github.com/gpongelli/joomla-cms/zipball/postgresql_3.0

l'installazione resta "freezata" all'inserimento delle credenziali di accesso al db, proprio come era accaduto con la 2.5

Dobbiamo attendere una nuova versione Alpha2 per i test?

ancora non ho dato il via


la versione alpha2 ancora non la rendo pubblica e sto lavorando proprio sull'installazione, è meno semplice del previsto...

[jeckodevelopment]

Allora attendo aggiornamenti!

[gpongelli]

potete cominciare a provare, il link è sempre https://github.com/gpongelli/joomla-cms/zipball/postgresql_3.0
vi avviso che se a termine installazione vi trovate tutto sballato è normale, manca il template isis ma non saprei dirvi come installarlo.


Gabriele.

[alexred]

ho provato ma a fine della procedura di installazione mi mostra le barre di avanzamento ma poi mi ritorna sempre all'ultima schermata della procedura di installazione

[gpongelli]

Ti mostra qualche errore, solitamente in alto con sfondo rosso o giallo ?
Oppure ti mostra i pulsanti per accedere al sito e alla sezione amministrativa?

[alexred]

no, niente errore e niente pulsanti per accedere al sito, mi riporta all'ultima schermata con il tasto per lanciare l'installazione e tutto il riepilogo dei dati

[giovi]

Confermo il problema: l'installazione non va oltre "Creating database tables" e ritorna alla schermata di riepilogo

[gpongelli]

ragazzi, io ho appena provato quel pacchetto che vi ho linkato, è aggiornato con il mio workspace che uso per sviluppare e non ho avuto problemi di sorta.
Ho fatto diversi test in locale, ho installato da zero tutto il cms e l'installazione è andata a buon fine, ho ritentato eliminando il contenuto del database e installando di nuovo tutto il cms e non ho avuto problemi, ho rieseguito l'installazione facendo il backup delle tabelle (vuote, senza dati di esempio) e installando stavolta anche i dati di esempio, nessun problema.


fatemi uno screen così almeno capisco.


ps
forse anche se ve l'avevo già detto, il database e l'utente devono essere creati PRIMA di eseguire l'installazione joomla.


Gabriele.

[giovi]

il database e l'utente devono essere creati PRIMA di eseguire l'installazione joomla.

Alex ci ha già fornito un utente ed un database ciascuno per testare il pacchetto: perchè non provi anche tu direttamente sullo stesso server su cui stiamo provando noi? In questo modo toccheresti con mano il problema che incontriamo (io credo che la screen servirà a poco)

[jeckodevelopment]

io sto caricando (per la terza volta) tutto il pacchetto via FTP, tra poco farò le mie prove.

[jeckodevelopment]

Non riesco a completare la procedura, si blocca "Creating Database Table", resta in attesa qualche secondo e poi ritorna alla schermata di riepilogo.

[jeckodevelopment]

l'installazione si blocca!
che si fa?


[allegato eliminato da un amministratore essendo vecchio più di un anno]

[gpongelli]

sto provando anche io sul mio spazio web, effettivamente è molto strano che durante la creazione delle tabelle ritorni indietro alla schermata "overview"...
sarebbe da controllare il database che tabelle ha creato, o i suoi messaggi di errore...alex, non è possibile avere queste informazioni da joomlahost ?


la cosa strana è che lo stesso pacchetto in locale mi va tutto liscio...e va liscio anche ad altre persone che stanno testando quel branch.

[alexred]

vedo che le tabelle te le ha create tutte nel db  testdb02

[jeckodevelopment]

ma nel testdb03 la procedura rimane bloccata!

[gpongelli]

andiamo con ordine.
alex, visto che puoi in qualche modo accede al database, se hai a disposizione un pannello stile phpmyadmin prova ad eseguire il contenuto dei file installation/sql/postgresql/joomla.sql e poi di installation/sql/postgresql/sample_data.sql .
prima di eseguire il contenuto, sostituisci tutte le stringhe "#__" con un prefisso di tabella come quelli che chiede durante l'installazione ( "qwerty_" per capirci).
almeno così siamo sicuri che i miei file sql non diano problemi.

[alexred]

Ho provato a fare quello che mi hai chiesto,
questo il risultato quando ho inserito il joomla.sql:

Codice: [Seleziona]

Output from uploaded SQL commands ..

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:23: NOTICE:  CREATE TABLE will create implicit sequence "asd_assets_id_seq" for serial column "asd_assets.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:23: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_assets_pkey" for table "asd_assets"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:23: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "asd_assets_idx_asset_name" for table "asd_assets"
CREATE TABLE
CREATE INDEX
CREATE INDEX
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
 nextval
---------
       1
(1 row)

 setval
--------
     35
(1 row)

INSERT 0 34
 nextval
---------
      35
(1 row)

 setval
--------
     34
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:93: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_associations_idx_context_id" for table "asd_associations"
CREATE TABLE
CREATE INDEX
COMMENT
COMMENT
COMMENT
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:140: NOTICE:  CREATE TABLE will create implicit sequence "asd_banners_id_seq" for serial column "asd_banners.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:140: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_banners_pkey" for table "asd_banners"
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
 nextval
---------
       1
(1 row)

 setval
--------
      1
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:169: NOTICE:  CREATE TABLE will create implicit sequence "asd_banner_clients_id_seq" for serial column "asd_banner_clients.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:169: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_banner_clients_pkey" for table "asd_banner_clients"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:183: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_banner_tracks_pkey" for table "asd_banner_tracks"
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:225: NOTICE:  CREATE TABLE will create implicit sequence "asd_categories_id_seq" for serial column "asd_categories.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:225: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_categories_pkey" for table "asd_categories"
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
COMMENT
COMMENT
COMMENT
COMMENT
INSERT 0 7
 nextval
---------
       1
(1 row)

 setval
--------
      8
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:304: NOTICE:  CREATE TABLE will create implicit sequence "asd_contact_details_id_seq" for serial column "asd_contact_details.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:304: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_contact_details_pkey" for table "asd_contact_details"
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
COMMENT
COMMENT
 nextval
---------
       1
(1 row)

 setval
--------
      1
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:359: NOTICE:  CREATE TABLE will create implicit sequence "asd_content_id_seq" for serial column "asd_content.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:359: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_content_pkey" for table "asd_content"
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
COMMENT
COMMENT
COMMENT
COMMENT
 nextval
---------
       1
(1 row)

 setval
--------
      1
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:384: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_content_frontpage_pkey" for table "asd_content_frontpage"
CREATE TABLE
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:395: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_content_rating_pkey" for table "asd_content_rating"
CREATE TABLE
CREATE TABLE
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:429: NOTICE:  CREATE TABLE will create implicit sequence "asd_extensions_extension_id_seq" for serial column "asd_extensions.extension_id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:429: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_extensions_pkey" for table "asd_extensions"
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
INSERT 0 27
INSERT 0 4
INSERT 0 24
INSERT 0 14
INSERT 0 47
INSERT 0 5
INSERT 0 2
INSERT 0 1
INSERT 0 1
 nextval
---------
       1
(1 row)

 setval
--------
  10000
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:608: NOTICE:  CREATE TABLE will create implicit sequence "asd_finder_filters_filter_id_seq" for serial column "asd_finder_filters.filter_id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:608: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_filters_pkey" for table "asd_finder_filters"
CREATE TABLE
 nextval
---------
       1
(1 row)

 setval
--------
      1
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:637: NOTICE:  CREATE TABLE will create implicit sequence "asd_finder_links_link_id_seq" for serial column "asd_finder_links.link_id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:637: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_links_pkey" for table "asd_finder_links"
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
 nextval
---------
       1
(1 row)

 setval
--------
      1
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:656: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_links_terms0_pkey" for table "asd_finder_links_terms0"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:668: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_links_terms1_pkey" for table "asd_finder_links_terms1"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:680: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_links_terms2_pkey" for table "asd_finder_links_terms2"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:692: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_links_terms3_pkey" for table "asd_finder_links_terms3"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:704: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_links_terms4_pkey" for table "asd_finder_links_terms4"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:716: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_links_terms5_pkey" for table "asd_finder_links_terms5"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:728: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_links_terms6_pkey" for table "asd_finder_links_terms6"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:740: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_links_terms7_pkey" for table "asd_finder_links_terms7"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:752: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_links_terms8_pkey" for table "asd_finder_links_terms8"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:764: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_links_terms9_pkey" for table "asd_finder_links_terms9"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:776: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_links_termsa_pkey" for table "asd_finder_links_termsa"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:788: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_links_termsb_pkey" for table "asd_finder_links_termsb"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:800: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_links_termsc_pkey" for table "asd_finder_links_termsc"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:812: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_links_termsd_pkey" for table "asd_finder_links_termsd"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:824: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_links_termse_pkey" for table "asd_finder_links_termse"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:836: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_links_termsf_pkey" for table "asd_finder_links_termsf"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:851: NOTICE:  CREATE TABLE will create implicit sequence "asd_finder_taxonomy_id_seq" for serial column "asd_finder_taxonomy.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:851: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_taxonomy_pkey" for table "asd_finder_taxonomy"
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
UPDATE 0
INSERT 0 1
 nextval
---------
       1
(1 row)

 setval
--------
      2
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:879: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_taxonomy_map_pkey" for table "asd_finder_taxonomy_map"
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:897: NOTICE:  CREATE TABLE will create implicit sequence "asd_finder_terms_term_id_seq" for serial column "asd_finder_terms.term_id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:897: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_terms_pkey" for table "asd_finder_terms"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:897: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "asd_finder_terms_idx_term" for table "asd_finder_terms"
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
 nextval
---------
       1
(1 row)

 setval
--------
      1
(1 row)

CREATE TABLE
CREATE INDEX
CREATE INDEX
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
UPDATE 0
INSERT 0 1
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE TABLE
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1652: NOTICE:  CREATE TABLE will create implicit sequence "asd_finder_types_id_seq" for serial column "asd_finder_types.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1652: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_finder_types_pkey" for table "asd_finder_types"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1652: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "asd_finder_types_title" for table "asd_finder_types"
CREATE TABLE
 nextval
---------
       1
(1 row)

 setval
--------
      1
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1678: NOTICE:  CREATE TABLE will create implicit sequence "asd_languages_lang_id_seq" for serial column "asd_languages.lang_id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1678: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_languages_pkey" for table "asd_languages"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1678: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "asd_languages_idx_sef" for table "asd_languages"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1678: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "asd_languages_idx_image" for table "asd_languages"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1678: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "asd_languages_idx_langcode" for table "asd_languages"
CREATE TABLE
CREATE INDEX
CREATE INDEX
INSERT 0 1
 nextval
---------
       1
(1 row)

 setval
--------
      2
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1741: NOTICE:  CREATE TABLE will create implicit sequence "asd_menu_id_seq" for serial column "asd_menu.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1741: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_menu_pkey" for table "asd_menu"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1741: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "asd_menu_idx_client_id_parent_id_alias_language" for table "asd_menu"
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
INSERT 0 23
 nextval
---------
       1
(1 row)

 setval
--------
    102
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1810: NOTICE:  CREATE TABLE will create implicit sequence "asd_menu_types_id_seq" for serial column "asd_menu_types.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1810: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_menu_types_pkey" for table "asd_menu_types"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1810: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "asd_menu_types_idx_menutype" for table "asd_menu_types"
CREATE TABLE
INSERT 0 1
 nextval
---------
       1
(1 row)

 setval
--------
      2
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1835: NOTICE:  CREATE TABLE will create implicit sequence "asd_messages_message_id_seq" for serial column "asd_messages.message_id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1835: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_messages_pkey" for table "asd_messages"
CREATE TABLE
CREATE INDEX
 nextval
---------
       1
(1 row)

 setval
--------
      1
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1849: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "asd_messages_cfg_idx_user_var_name" for table "asd_messages_cfg"
CREATE TABLE
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1874: NOTICE:  CREATE TABLE will create implicit sequence "asd_modules_id_seq" for serial column "asd_modules.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1874: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_modules_pkey" for table "asd_modules"
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
INSERT 0 15
 nextval
---------
       1
(1 row)

 setval
--------
     87
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1910: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_modules_menu_pkey" for table "asd_modules_menu"
CREATE TABLE
INSERT 0 17
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1971: NOTICE:  CREATE TABLE will create implicit sequence "asd_newsfeeds_id_seq" for serial column "asd_newsfeeds.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1971: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_newsfeeds_pkey" for table "asd_newsfeeds"
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
COMMENT
 nextval
---------
       1
(1 row)

 setval
--------
      1
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1995: NOTICE:  CREATE TABLE will create implicit sequence "asd_overrider_id_seq" for serial column "asd_overrider.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:1995: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_overrider_pkey" for table "asd_overrider"
CREATE TABLE
COMMENT
 nextval
---------
       1
(1 row)

 setval
--------
      1
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2017: NOTICE:  CREATE TABLE will create implicit sequence "asd_redirect_links_id_seq" for serial column "asd_redirect_links.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2017: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_redirect_links_pkey" for table "asd_redirect_links"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2017: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "asd_redirect_links_idx_link_old" for table "asd_redirect_links"
CREATE TABLE
CREATE INDEX
 nextval
---------
       1
(1 row)

 setval
--------
      1
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2031: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_schemas_pkey" for table "asd_schemas"
CREATE TABLE
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2047: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_session_pkey" for table "asd_session"
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2064: NOTICE:  CREATE TABLE will create implicit sequence "asd_template_styles_id_seq" for serial column "asd_template_styles.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2064: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_template_styles_pkey" for table "asd_template_styles"
CREATE TABLE
CREATE INDEX
CREATE INDEX
INSERT 0 5
 nextval
---------
       1
(1 row)

 setval
--------
      7
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2101: NOTICE:  CREATE TABLE will create implicit sequence "asd_updates_update_id_seq" for serial column "asd_updates.update_id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2101: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_updates_pkey" for table "asd_updates"
CREATE TABLE
COMMENT
 nextval
---------
       1
(1 row)

 setval
--------
      1
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2119: NOTICE:  CREATE TABLE will create implicit sequence "asd_update_categories_categoryid_seq" for serial column "asd_update_categories.categoryid"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2119: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_update_categories_pkey" for table "asd_update_categories"
CREATE TABLE
COMMENT
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2135: NOTICE:  CREATE TABLE will create implicit sequence "asd_update_sites_update_site_id_seq" for serial column "asd_update_sites.update_site_id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2135: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_update_sites_pkey" for table "asd_update_sites"
CREATE TABLE
COMMENT
INSERT 0 2
 nextval
---------
       1
(1 row)

 setval
--------
      3
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2158: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_update_sites_extensions_pkey" for table "asd_update_sites_extensions"
CREATE TABLE
COMMENT
INSERT 0 2
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2185: NOTICE:  CREATE TABLE will create implicit sequence "asd_usergroups_id_seq" for serial column "asd_usergroups.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2185: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_usergroups_pkey" for table "asd_usergroups"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2185: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "asd_usergroups_idx_usergroup_parent_title_lookup" for table "asd_usergroups"
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
COMMENT
COMMENT
COMMENT
COMMENT
INSERT 0 9
 nextval
---------
       1
(1 row)

 setval
--------
      9
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2223: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_user_usergroup_map_pkey" for table "asd_user_usergroup_map"
CREATE TABLE
COMMENT
COMMENT
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2247: NOTICE:  CREATE TABLE will create implicit sequence "asd_users_id_seq" for serial column "asd_users.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2247: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_users_pkey" for table "asd_users"
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
COMMENT
COMMENT
 nextval
---------
       1
(1 row)

 setval
--------
      1
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2281: NOTICE:  CREATE TABLE will create implicit sequence "asd_user_notes_id_seq" for serial column "asd_user_notes.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2281: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_user_notes_pkey" for table "asd_user_notes"
CREATE TABLE
CREATE INDEX
CREATE INDEX
 nextval
---------
       1
(1 row)

 setval
--------
      1
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2298: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "asd_user_profiles_idx_user_id_profile_key" for table "asd_user_profiles"
CREATE TABLE
COMMENT
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2315: NOTICE:  CREATE TABLE will create implicit sequence "asd_viewlevels_id_seq" for serial column "asd_viewlevels.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2315: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_viewlevels_pkey" for table "asd_viewlevels"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2315: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "asd_viewlevels_idx_assetgroup_title_lookup" for table "asd_viewlevels"
CREATE TABLE
COMMENT
COMMENT
INSERT 0 4
 nextval
---------
       1
(1 row)

 setval
--------
      4
(1 row)

psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2368: NOTICE:  CREATE TABLE will create implicit sequence "asd_weblinks_id_seq" for serial column "asd_weblinks.id"
psql:/tmp/.webmin/648179_26569_1_exec_file.cgi:2368: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "asd_weblinks_pkey" for table "asd_weblinks"
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
COMMENT
COMMENT
CREATE FUNCTION

Questo per i dati di esempio:

Codice: [Seleziona]

Output from uploaded SQL commands ..

TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
INSERT 0 165
 nextval
---------
       1
(1 row)

 setval
--------
    174
(1 row)

INSERT 0 3
 nextval
---------
       1
(1 row)

 setval
--------
      5
(1 row)

INSERT 0 3
 nextval
---------
       1
(1 row)

 setval
--------
      4
(1 row)

TRUNCATE TABLE
INSERT 0 68
 nextval
---------
       1
(1 row)

 setval
--------
     78
(1 row)

INSERT 0 8
 nextval
---------
       1
(1 row)

 setval
--------
      9
(1 row)

INSERT 0 26
INSERT 0 30
INSERT 0 13
 nextval
---------
       1
(1 row)

 setval
--------
     71
(1 row)

INSERT 0 4
TRUNCATE TABLE
INSERT 0 70
INSERT 0 55
INSERT 0 18
 nextval
---------
       1
(1 row)

 setval
--------
    468
(1 row)

TRUNCATE TABLE
INSERT 0 6
 nextval
---------
       1
(1 row)

 setval
--------
      8
(1 row)

INSERT 0 63
 nextval
---------
       1
(1 row)

 setval
--------
     87
(1 row)

TRUNCATE TABLE
INSERT 0 161
INSERT 0 4
 nextval
---------
       1
(1 row)

 setval
--------
      5
(1 row)

INSERT 0 1
 nextval
---------
       7
(1 row)

 setval
--------
    115
(1 row)

DELETE 0
INSERT 0 11
 nextval
---------
       1
(1 row)

 setval
--------
     14
(1 row)

INSERT 0 5
 nextval
---------
       1
(1 row)

 setval
--------
      6
(1 row)

INSERT 0 9
 nextval
---------
       1
(1 row)

 setval
--------
     10
(1 row)

UPDATE 1


[gpongelli]

non mi sembra ci siano errori, il database lo vedi popolato correttamente, giusto ?

[alexred]

si, risulta popolato con tutte le tabelle ed i relativi contenuti

[gpongelli]

ho provato a chiedere se anche altre persone avessero problemi a installare la versione del mio branch su un hosting condiviso, sembra che vada bene a tutti... al momento purtroppo non ho un minuto di tempo per indagare meglio...