Ciao,
ho provato ad installare il componente JoomlaPack in remoto e mi da questo errore:
JInstaller::install: SQL Error. DB function failed with error number 1142
ALTER command denied to user: 'dmi@localhost' for table 'jos_jp_stats' SQL=-- JoomlaPack Database Tables Patches -- -- JoomlaPack version ever since 2.0.a1 can upgrade. Therefore, changes to the database -- schema used are issued as SQL "patches" (ALTER commands) instead of being integrated -- to the CREATE TABLE commands above -- Tables patch 2.0.a1 to 2.0.b1 (added 'extradbonly' to the enumeration type) ALTER TABLE `jos_jp_stats` MODIFY COLUMN `type` ENUM('full','dbonly','extradbonly') NOT NULL DEFAULT 'full';
SQL =
-- JoomlaPack Database Tables Patches
--
-- JoomlaPack version ever since 2.0.a1 can upgrade. Therefore, changes to the database
-- schema used are issued as SQL "patches" (ALTER commands) instead of being integrated
-- to the CREATE TABLE commands above
-- Tables patch 2.0.a1 to 2.0.b1 (added 'extradbonly' to the enumeration type)
ALTER TABLE `jos_jp_stats` MODIFY COLUMN `type` ENUM('full','dbonly','extradbonly') NOT NULL DEFAULT 'full';Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 1142
ALTER command denied to user: 'dmi@localhost' for table 'jos_jp_stats' SQL=-- JoomlaPack Database Tables Patches -- -- JoomlaPack version ever since 2.0.a1 can upgrade. Therefore, changes to the database -- schema used are issued as SQL "patches" (ALTER commands) instead of being integrated -- to the CREATE TABLE commands above -- Tables patch 2.0.a1 to 2.0.b1 (added 'extradbonly' to the enumeration type) ALTER TABLE `jos_jp_stats` MODIFY COLUMN `type` ENUM('full','dbonly','extradbonly') NOT NULL DEFAULT 'full';
SQL =
-- JoomlaPack Database Tables Patches
--
-- JoomlaPack version ever since 2.0.a1 can upgrade. Therefore, changes to the database
-- schema used are issued as SQL "patches" (ALTER commands) instead of being integrated
-- to the CREATE TABLE commands above
-- Tables patch 2.0.a1 to 2.0.b1 (added 'extradbonly' to the enumeration type)
ALTER TABLE `jos_jp_stats` MODIFY COLUMN `type` ENUM('full','dbonly','extradbonly') NOT NULL DEFAULT 'full';
Qualcuno sa cosa potrebbe essere??
Grazie
