Ciao a tutti..
Ho in problema con l'installazione di Solidres Bundle Quickstart
in pratica una volta creato il database vado ad installare in locale e durante la configurazione mi escono i codici di errore che riporto più sotto..
uso
xampp v3.0.12
qualcuno riesce a spiegarmi in che cosa ho sbagliato?
graziee
RISOLTO: Stavo usando un database (database-1) con il quale avevo precedentemente creato un altro sito.. ho provato a creare un nuovo databae (database-2) e usando le nuove credenziali in fase di configurazione tutto è andato per il meglio!!
Joomla!® è un software libero rilasciato sotto licenza
GNU General Public License. Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_coupons` ADD CONSTRAINT `fk_sr_coupons_sr_customer_groups1` FOREIGN KEY (`customer_group_id`) REFERENCES `f40ty_sr_customer_groups` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_coupons_sr_reservation_assets1` FOREIGN KEY (`reservation_asset_id`) REFERENCES `f40ty_sr_reservation_assets` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_customers` ADD CONSTRAINT `fk_sr_customers_sr_countries1` FOREIGN KEY (`country_id`) REFERENCES `f40ty_sr_countries` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_customers_sr_customer_groups1` FOREIGN KEY (`customer_group_id`) REFERENCES `f40ty_sr_customer_groups` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_customers_sr_geo_states1` FOREIGN KEY (`geo_state_id`) REFERENCES `f40ty_sr_geo_states` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_customer_fields` ADD CONSTRAINT `fk_sr_customer_fields_sr_customers1` FOREIGN KEY (`user_id`) REFERENCES `f40ty_sr_customers` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_extras` ADD CONSTRAINT `fk_sr_extras_sr_reservation_assets1` FOREIGN KEY (`reservation_asset_id`) REFERENCES `f40ty_sr_reservation_assets` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_extras_sr_taxes1` FOREIGN KEY (`tax_id`) REFERENCES `f40ty_sr_taxes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_geo_states` ADD CONSTRAINT `fk_sr_geo_states_sr_countries1` FOREIGN KEY (`country_id`) REFERENCES `f40ty_sr_countries` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_invoices` ADD CONSTRAINT `fk_sr_invoices_sr_reservations1` FOREIGN KEY (`reservation_id`) REFERENCES `f40ty_sr_reservations` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_limit_bookings` ADD CONSTRAINT `fk_sr_limit_bookings_sr_reservation_assets1` FOREIGN KEY (`reservation_asset_id`) REFERENCES `f40ty_sr_reservation_assets` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_limit_booking_details` ADD CONSTRAINT `fk_sr_limit_booking_details_sr_limit_bookings1` FOREIGN KEY (`limit_booking_id`) REFERENCES `f40ty_sr_limit_bookings` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_limit_booking_details_sr_rooms1` FOREIGN KEY (`room_id`) REFERENCES `f40ty_sr_rooms` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_media_reservation_assets_xref` ADD CONSTRAINT `fk_sr_media_ref_reservation_assets_sr_media1` FOREIGN KEY (`media_id`) REFERENCES `f40ty_sr_media` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_media_ref_reservation_assets_sr_reservation1` FOREIGN KEY (`reservation_asset_id`) REFERENCES `f40ty_sr_reservation_assets` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_media_roomtype_xref` ADD CONSTRAINT `fk_sr_media_ref_roomtype_sr_media1` FOREIGN KEY (`media_id`) REFERENCES `f40ty_sr_media` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_media_ref_roomtype_sr_room_types1` FOREIGN KEY (`room_type_id`) REFERENCES `f40ty_sr_room_types` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_reservations` ADD CONSTRAINT `fk_sr_reservations_sr_coupons1` FOREIGN KEY (`coupon_id`) REFERENCES `f40ty_sr_coupons` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_reservations_sr_reservation_assets1` FOREIGN KEY (`reservation_asset_id`) REFERENCES `f40ty_sr_reservation_assets` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_reservation_assets` ADD CONSTRAINT `fk_jos_sr_reservation_assets_jos_sr_taxes1` FOREIGN KEY (`tax_id`) REFERENCES `f40ty_sr_taxes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_reservation_assets_sr_countries1` FOREIGN KEY (`country_id`) REFERENCES `f40ty_sr_countries` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_reservation_assets_sr_currencies1` FOREIGN KEY (`currency_id`) REFERENCES `f40ty_sr_currencies` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_reservation_assets_sr_customers1` FOREIGN KEY (`partner_id`) REFERENCES `f40ty_sr_customers` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_reservation_assets_sr_geo_states1` FOREIGN KEY (`geo_state_id`) REFERENCES `f40ty_sr_geo_states` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_reservation_asset_fields` ADD CONSTRAINT `fk_sr_reservation_asset_fields_sr_reservation_assets1` FOREIGN KEY (`reservation_asset_id`) REFERENCES `f40ty_sr_reservation_assets` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_reservation_extra_xref` ADD CONSTRAINT `fk_sr_reservation_extra_xref_sr_reservations1` FOREIGN KEY (`reservation_id`) REFERENCES `f40ty_sr_reservations` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_reservation_extra_xref_sr_sr_extras1` FOREIGN KEY (`extra_id`) REFERENCES `f40ty_sr_extras` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_reservation_notes` ADD CONSTRAINT `fk_jos_sr_reservation_notes_jos_sr_reservations1` FOREIGN KEY (`reservation_id`) REFERENCES `f40ty_sr_reservations` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_reservation_room_details` ADD CONSTRAINT `fk_sr_reservation_room_details_sr_reservation_room_xr1` FOREIGN KEY (`reservation_room_id`) REFERENCES `f40ty_sr_reservation_room_xref` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_reservation_room_extra_xref` ADD CONSTRAINT `fk_sr_reservation_room_extra_xref_sr_extras1` FOREIGN KEY (`extra_id`) REFERENCES `f40ty_sr_extras` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_reservation_room_extra_xref_sr_reservations1` FOREIGN KEY (`reservation_id`) REFERENCES `f40ty_sr_reservations` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_reservation_room_extra_xref_sr_rooms1` FOREIGN KEY (`room_id`) REFERENCES `f40ty_sr_rooms` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_reservation_room_xref` ADD CONSTRAINT `fk_reservations_rooms_xref_reservations1` FOREIGN KEY (`reservation_id`) REFERENCES `f40ty_sr_reservations` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_reservation_room_coupon_extra_xref_sr_rooms1` FOREIGN KEY (`room_id`) REFERENCES `f40ty_sr_rooms` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_reservation_room_xref_sr_tariffs1` FOREIGN KEY (`tariff_id`) REFERENCES `f40ty_sr_tariffs` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_rooms` ADD CONSTRAINT `fk_sr_rooms_sr_room_types1` FOREIGN KEY (`room_type_id`) REFERENCES `f40ty_sr_room_types` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_room_types` ADD CONSTRAINT `fk_sr_room_types_sr_reservation_assets1` FOREIGN KEY (`reservation_asset_id`) REFERENCES `f40ty_sr_reservation_assets` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_room_type_coupon_xref` ADD CONSTRAINT `fk_sr_room_type_coupon_xref_sr_coupons1` FOREIGN KEY (`coupon_id`) REFERENCES `f40ty_sr_coupons` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_room_type_coupon_xref_sr_room_types1` FOREIGN KEY (`room_type_id`) REFERENCES `f40ty_sr_room_types` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_room_type_extra_xref` ADD CONSTRAINT `fk_sr_room_type_extra_xref_sr_extras1` FOREIGN KEY (`extra_id`) REFERENCES `f40ty_sr_extras` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_room_type_extra_xref_sr_room_types1` FOREIGN KEY (`room_type_id`) REFERENCES `f40ty_sr_room_types` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_room_type_fields` ADD CONSTRAINT `fk_sr_room_type_fields_sr_room_types1` FOREIGN KEY (`room_type_id`) REFERENCES `f40ty_sr_room_types` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_tariffs` ADD CONSTRAINT `fk_sr_prices_sr_currencies1` FOREIGN KEY (`currency_id`) REFERENCES `f40ty_sr_currencies` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_prices_sr_customer_groups1` FOREIGN KEY (`customer_group_id`) REFERENCES `f40ty_sr_customer_groups` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_prices_sr_room_types1` FOREIGN KEY (`room_type_id`) REFERENCES `f40ty_sr_room_types` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_tariff_details` ADD CONSTRAINT `fk_sr_tariff_details_sr_tariffs1` FOREIGN KEY (`tariff_id`) REFERENCES `f40ty_sr_tariffs` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
Can't create table 'database-1.#sql-a0c_3' (errno: 121) SQL=ALTER TABLE `f40ty_sr_taxes` ADD CONSTRAINT `fk_sr_taxes_sr_countries1` FOREIGN KEY (`country_id`) REFERENCES `f40ty_sr_countries` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `fk_sr_taxes_sr_geo_states1` FOREIGN KEY (`geo_state_id`) REFERENCES `f40ty_sr_geo_states` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
- 1 Configurazione
- 2 Database
- 3 Riepilogo dati
Indietro Avanti Configurazione database
Tipo database * Generalmente è "MySQLi"
Nome Host * Generalmente è "localhost"
Nome utente * Potrebbe essere il nome utente Mysql predefinito "root" oppure un nome utente fornito dal tuo gestore di hosting oppure un nome utente da te impostato al momento della creazione del database.
Password Per la sicurezza del sito è obbligatorio utilizzare la password per l'account del database.
Nome database * Alcuni gestori di host consentono un solo nome DB per sito. Se questo è il tuo caso, utilizza il prefisso tabelle per distinguere più di un sito Joomla!®.
Prefisso tabelle * Scegli un prefisso per le tabelle del database oppure utilizza quello
generato casualmente. La lunghezza ideale sono tre o quattro caratteri, solo alfanumerici e DEVE finire con un underscore.
Assicurati che il prefisso scelto non sia utilizzato da altre tabelle.
Processa database vecchio * SalvaElimina In caso il prefisso delle tabelle sia lo stesso utilizzato da altre tabelle del database già esistenti, selezionando 'Salva' le tabelle esistenti verranno rinominate in bak_, selezionando 'Elimina' verranno eliminate.
RISOLTO: Stavo usando un database (database-1) con il quale avevo precedentemente creato un altro sito.. ho provato a creare un nuovo databae (database-2) e usando le nuove credenziali in fase di configurazione tutto è andato per il meglio!!
