fr.paris.lutece.portal.service.util.AppException: DAOUtil error : user lacks privilege or object not found: STOCK_PRODUCT in statement [SELECT a.id_product FROM stock_product a, stock_product_attribute_date b, stock_product_attribute_date c  WHERE a.id_product = b.owner_id AND b.attribute_key = 'start' AND a.id_product = c.owner_id  AND c.attribute_key = 'end' AND b.attribute_value < ? AND c.attribute_value > ?] - SQL statement :  - Plugin : lutece
	at fr.paris.lutece.plugins.stock.modules.recommendation.service.RecommendationServiceTest.testExtractPurchases(RecommendationServiceTest.java:59)
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: STOCK_PRODUCT in statement [SELECT a.id_product FROM stock_product a, stock_product_attribute_date b, stock_product_attribute_date c  WHERE a.id_product = b.owner_id AND b.attribute_key = 'start' AND a.id_product = c.owner_id  AND c.attribute_key = 'end' AND b.attribute_value < ? AND c.attribute_value > ?]
	at fr.paris.lutece.plugins.stock.modules.recommendation.service.RecommendationServiceTest.testExtractPurchases(RecommendationServiceTest.java:59)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: STOCK_PRODUCT
	at fr.paris.lutece.plugins.stock.modules.recommendation.service.RecommendationServiceTest.testExtractPurchases(RecommendationServiceTest.java:59)

[sql] Failed to execute:    CREATE TABLE IF NOT EXISTS stock_recommendation ( username varchar(255) NOT NULL, id_product int(11) NOT NULL, score DOUBLE NOT NULL, PRIMARY KEY (username , id_product ), INDEX( username ) ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:       CREATE TABLE IF NOT EXISTS stock_category ( id_category int(11) NOT NULL DEFAULT '0', `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, description varchar(255) COLLATE utf8_unicode_ci NOT NULL, parent_id int(11) DEFAULT NULL, provider_id int(11) DEFAULT NULL, PRIMARY KEY (id_category), KEY FK9792900769015ED5 (provider_id), KEY FK97929007A735EC89 (parent_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_category_attribute ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_category_attribute_date ( id int(11) NOT NULL GENERATED BY DEFAULT AS IDENTITY(START WITH 1), owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY owner_id (owner_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_category_attribute_num ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value decimal(10,2) DEFAULT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_offer ( id_offer int(11) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, description varchar(255) COLLATE utf8_unicode_ci NOT NULL, quantity int(11) NOT NULL, price float NOT NULL DEFAULT '0', statut varchar(255) COLLATE utf8_unicode_ci NOT NULL, product_id int(11) NOT NULL, offer_genre_id int(11) NOT NULL, min_tickets INT DEFAULT 0 NOT NULL, max_tickets INT DEFAULT 0 NOT NULL, PRIMARY KEY (id_offer), KEY product_id (product_id), KEY offer_genre_id (offer_genre_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_offer_attribute ( id int(11) NOT NULL GENERATED BY DEFAULT AS IDENTITY(START WITH 1), owner_id int(11) NOT NULL, attribute_key varchar(255) NOT NULL, attribute_value text NOT NULL, PRIMARY KEY (id), KEY owner_id (owner_id) ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_offer_attribute_date ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_offer_attribute_num ( id int(11) NOT NULL GENERATED BY DEFAULT AS IDENTITY(START WITH 1), owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value decimal(10,2) DEFAULT NULL, PRIMARY KEY (id), KEY owner_id (owner_id) ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_offer_genre ( id_offer_genre int(11) NOT NULL, `name` varchar(255) NOT NULL, PRIMARY KEY (id_offer_genre) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_offer_genre_attribute ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_offer_genre_attribute_date ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_offer_genre_attribute_num ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value decimal(10,2) DEFAULT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_product ( id_product int(11) NOT NULL DEFAULT '0', `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, description text COLLATE utf8_unicode_ci, price float DEFAULT NULL, category_id_category int(11) DEFAULT NULL, provider_id_provider int(11) DEFAULT NULL, PRIMARY KEY (id_product), KEY FK1BA2F4C6FC6A399A (category_id_category), KEY provider_id_provider (provider_id_provider), KEY provider_id_provider_2 (provider_id_provider) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:    CREATE TABLE IF NOT EXISTS stock_product_image ( id_product int(11) NOT NULL, tb_image blob, image mediumblob, real_image mediumblob, PRIMARY KEY (id_product) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:      CREATE TABLE IF NOT EXISTS stock_product_attribute ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_product_attribute_date ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_product_attribute_num ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value decimal(10,2) DEFAULT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:      CREATE TABLE IF NOT EXISTS stock_provider ( id_provider int(11) NOT NULL DEFAULT '0', address varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `comment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, contactName varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, mail varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, phone_number varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (id_provider) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_provider_attribute ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_provider_attribute_date ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_provider_attribute_num ( owner_id int(11) NOT NULL, attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value decimal(10,2) DEFAULT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_provider_stock_category ( stock_provider_id_provider int(11) NOT NULL DEFAULT '0', products_id_category int(11) NOT NULL DEFAULT '0', UNIQUE KEY products_id_category (products_id_category), KEY FKF592D1EC8CC9E500 (products_id_category), KEY FKF592D1ECF087CD7C (stock_provider_id_provider) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_purchase ( id_purchase int(11) NOT NULL, userName varchar(255) NOT NULL, quantity int(11) NOT NULL, offer_id int(11) NOT NULL, PRIMARY KEY (id_purchase) ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_purchase_attribute ( owner_id int(11) NOT NULL DEFAULT '0', attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_purchase_attribute_date ( owner_id int(11) NOT NULL DEFAULT '0', attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_purchase_attribute_num ( owner_id int(11) NOT NULL DEFAULT '0', attribute_key varchar(255) COLLATE utf8_unicode_ci NOT NULL, attribute_value decimal(10,2) DEFAULT NULL, PRIMARY KEY (owner_id,attribute_key) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_sequences ( sequence_name varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', next_val bigint(20) DEFAULT NULL, PRIMARY KEY (sequence_name) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_ticket_product_statistic ( id_product_statistic int(11) NOT NULL GENERATED BY DEFAULT AS IDENTITY(START WITH 1), dayOfYear int(11) NOT NULL, `week` int(11) NOT NULL, `month` int(11) NOT NULL, `year` int(11) NOT NULL, product_id_product int(11) NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id_product_statistic) ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:     CREATE TABLE IF NOT EXISTS stock_ticket_purchase_statistic ( id_purchase_statistic int(11) NOT NULL, dayOfYear int(11) NOT NULL, `week` int(11) NOT NULL, `month` int(11) NOT NULL, `year` int(11) NOT NULL, purchase_id_purchase int(11) NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id_purchase_statistic) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:    ALTER TABLE `stock_offer` ADD CONSTRAINT stock_offer_ibfk_1 FOREIGN KEY (product_id) REFERENCES stock_product (id_product)
      [sql] Failed to execute:   ALTER TABLE `stock_offer_attribute` ADD CONSTRAINT stock_offer_attribute_ibfk_2 FOREIGN KEY (owner_id) REFERENCES stock_offer (id_offer), ADD CONSTRAINT stock_offer_attribute_ibfk_1 FOREIGN KEY (owner_id) REFERENCES stock_offer (id_offer)
      [sql] Failed to execute:   ALTER TABLE `stock_offer_attribute_date` ADD CONSTRAINT stock_offer_attribute_date_ibfk_1 FOREIGN KEY (owner_id) REFERENCES stock_offer (id_offer)
      [sql] Failed to execute:   ALTER TABLE `stock_offer_attribute_num` ADD CONSTRAINT stock_offer_attribute_num_ibfk_1 FOREIGN KEY (owner_id) REFERENCES stock_offer (id_offer)
      [sql] Failed to execute:   ALTER TABLE `stock_product_attribute` ADD CONSTRAINT stock_product_attribute_ibfk_3 FOREIGN KEY (owner_id) REFERENCES stock_product (id_product), ADD CONSTRAINT stock_product_attribute_ibfk_1 FOREIGN KEY (owner_id) REFERENCES stock_product (id_product), ADD CONSTRAINT stock_product_attribute_ibfk_2 FOREIGN KEY (owner_id) REFERENCES stock_product (id_product)
      [sql] Failed to execute:   ALTER TABLE `stock_product_attribute_date` ADD CONSTRAINT stock_product_attribute_date_ibfk_1 FOREIGN KEY (owner_id) REFERENCES stock_product (id_product)
      [sql] Failed to execute:   ALTER TABLE `stock_product_attribute_num` ADD CONSTRAINT stock_product_attribute_num_ibfk_1 FOREIGN KEY (owner_id) REFERENCES stock_product (id_product)
      [sql] Failed to execute:    CREATE TABLE IF NOT EXISTS stock_product_subscription_user ( id int(11) NOT NULL, userName varchar(255) COLLATE utf8_unicode_ci NOT NULL, id_product int(11) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
      [sql] Failed to execute:    ALTER TABLE `stock_product_subscription_user` ADD CONSTRAINT stock_product_subscription_user_ibfk_1 FOREIGN KEY (id_product) REFERENCES stock_product (id_product)