Set the marketplace : error

[GuillaumeSochon]

Upgrade&Marketplace

Marketplace access don't work.

https://........../ClicShoppingAdmin/index.php?A&Tools\Upgrade&Marketplace

 

I need to install import/export for products import and there is no module installed.

Thank you for regards

Edited August 23, 2023 by ClicShopping
remove link for your website security

[GuillaumeSochon]

[23-Aug-2023 02:57:54 America/New_York] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/sogu7276/shop/includes/ClicShopping/Sites/ClicShoppingAdmin/Templates/Default/header.php:81) in /home/sogu7276/shop/includes/ClicShopping/OM/HTTP.php on line 62
[23-Aug-2023 03:09:47 America/New_York] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/sogu7276/shop/includes/ClicShopping/Sites/ClicShoppingAdmin/Templates/Default/header.php:81) in /home/sogu7276/shop/includes/ClicShopping/OM/HTTP.php on line 62
[23-Aug-2023 03:14:06 America/New_York] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/sogu7276/shop/includes/ClicShopping/Sites/ClicShoppingAdmin/Templates/Default/header.php:81) in /home/sogu7276/shop/includes/ClicShopping/OM/HTTP.php on line 62
[23-Aug-2023 03:14:07 America/New_York] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/sogu7276/shop/includes/ClicShopping/Sites/ClicShoppingAdmin/Templates/Default/header.php:81) in /home/sogu7276/shop/includes/ClicShopping/OM/HTTP.php on line 62
[23-Aug-2023 03:14:08 America/New_York] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/sogu7276/shop/includes/ClicShopping/Sites/ClicShoppingAdmin/Templates/Default/header.php:81) in /home/sogu7276/shop/includes/ClicShopping/OM/HTTP.php on line 62
[23-Aug-2023 03:14:26 America/New_York] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/sogu7276/shop/includes/ClicShopping/Sites/ClicShoppingAdmin/Templates/Default/header.php:81) in /home/sogu7276/shop/includes/ClicShopping/OM/HTTP.php on line 62
[23-Aug-2023 03:18:13 America/New_York] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/sogu7276/shop/includes/ClicShopping/Sites/ClicShoppingAdmin/Templates/Default/header.php:81) in /home/sogu7276/shop/includes/ClicShopping/OM/HTTP.php on line 62
[23-Aug-2023 03:18:16 America/New_York] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/sogu7276/shop/includes/ClicShopping/Sites/ClicShoppingAdmin/Templates/Default/header.php:81) in /home/sogu7276/shop/includes/ClicShopping/OM/HTTP.php on line 62
[23-Aug-2023 03:18:18 America/New_York] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sogu7276_clic451.csw2_marketplace_file_informations' doesn't exist in /home/sogu7276/shop/includes/ClicShopping/OM/Db.php:107
Stack trace:
#0 /home/sogu7276/shop/includes/ClicShopping/OM/Db.php(107): PDO->exec()
#1 /home/sogu7276/shop/includes/ClicShopping/OM/Db.php(406): ClicShopping\OM\Db->exec()
#2 /home/sogu7276/shop/includes/ClicShopping/Apps/Tools/Upgrade/Sites/ClicShoppingAdmin/Pages/Home/Actions/Marketplace/UpdateMarketplace.php(29): ClicShopping\OM\Db->delete()
#3 /home/sogu7276/shop/includes/ClicShopping/OM/PagesAbstract.php(143): ClicShopping\Apps\Tools\Upgrade\Sites\ClicShoppingAdmin\Pages\Home\Actions\Marketplace\UpdateMarketplace->execute()
#4 /home/sogu7276/shop/includes/ClicShopping/OM/PagesAbstract.php(178): ClicShopping\OM\PagesAbstract->runAction()
#5 /home/sogu7276/shop/includes/ClicShopping/Sites/ClicShoppingAdmin/ClicShoppingAdmin.php(185): ClicShopping\OM\PagesAbstract->runActions()
#6 /home/sogu7276/shop/includes/ClicShopping/OM/CLICSHOPPING.php(128): ClicShopping\Sites\ClicShoppingAdmin\ClicShoppingAdmin->setPage()
#7 /home/sogu7276/shop/includes/ClicShopping/OM/CLICSHOPPING.php(109): ClicShopping\OM\CLICSHOPPING::setSite()
#8 /home/sogu7276/shop/ClicShoppingAdmin/index.php(24): ClicShopping\OM\CLICSHOPPING::loadSite()
#9 {main}
  thrown in /home/sogu7276/shop/includes/ClicShopping/OM/Db.php on line 107
[23-Aug-2023 03:18:24 America/New_York] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sogu7276_clic451.csw2_marketplace_file_informations' doesn't exist in /home/sogu7276/shop/includes/ClicShopping/OM/Db.php:107
Stack trace:
#0 /home/sogu7276/shop/includes/ClicShopping/OM/Db.php(107): PDO->exec()
#1 /home/sogu7276/shop/includes/ClicShopping/OM/Db.php(406): ClicShopping\OM\Db->exec()
#2 /home/sogu7276/shop/includes/ClicShopping/Apps/Tools/Upgrade/Sites/ClicShoppingAdmin/Pages/Home/Actions/Marketplace/UpdateMarketplace.php(29): ClicShopping\OM\Db->delete()
#3 /home/sogu7276/shop/includes/ClicShopping/OM/PagesAbstract.php(143): ClicShopping\Apps\Tools\Upgrade\Sites\ClicShoppingAdmin\Pages\Home\Actions\Marketplace\UpdateMarketplace->execute()
#4 /home/sogu7276/shop/includes/ClicShopping/OM/PagesAbstract.php(178): ClicShopping\OM\PagesAbstract->runAction()
#5 /home/sogu7276/shop/includes/ClicShopping/Sites/ClicShoppingAdmin/ClicShoppingAdmin.php(185): ClicShopping\OM\PagesAbstract->runActions()
#6 /home/sogu7276/shop/includes/ClicShopping/OM/CLICSHOPPING.php(128): ClicShopping\Sites\ClicShoppingAdmin\ClicShoppingAdmin->setPage()
#7 /home/sogu7276/shop/includes/ClicShopping/OM/CLICSHOPPING.php(109): ClicShopping\OM\CLICSHOPPING::setSite()
#8 /home/sogu7276/shop/ClicShoppingAdmin/index.php(24): ClicShopping\OM\CLICSHOPPING::loadSite()
#9 {main}
  thrown in /home/sogu7276/shop/includes/ClicShopping/OM/Db.php on line 107
[23-Aug-2023 03:18:26 America/New_York] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/sogu7276/shop/includes/ClicShopping/Sites/ClicShoppingAdmin/Templates/Default/header.php:81) in /home/sogu7276/shop/includes/ClicShopping/OM/HTTP.php on line 62
[23-Aug-2023 03:19:30 America/New_York] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/sogu7276/shop/includes/ClicShopping/Sites/ClicShoppingAdmin/Templates/Default/header.php:81) in /home/sogu7276/shop/includes/ClicShopping/OM/HTTP.php on line 62
[23-Aug-2023 03:19:39 America/New_York] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/sogu7276/shop/includes/ClicShopping/Sites/ClicShoppingAdmin/Templates/Default/header.php:81) in /home/sogu7276/shop/includes/ClicShopping/OM/HTTP.php on line 62
[23-Aug-2023 03:33:15 America/New_York] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/sogu7276/shop/includes/ClicShopping/Sites/ClicShoppingAdmin/Templates/Default/header.php:81) in /home/sogu7276/shop/includes/ClicShopping/OM/HTTP.php on line 62

[Drack]

Hello,

I suppose you want to install this app : catalog apps catalog import export
- What is the version of ClicShopping AI do you have ?
- First, I tested the marketplace and do not have error as you, I suppose inside the setting you make a mistake : Do you insert your email and password ?
- I noted a bug on my side, the api do send the information, I think it's better to report this issue on github
- If nothing work for you, you can install manually the application, download it and push the files inside your repository.
- to install it,look the section install for this App. In your case it will be ......./index.php?A&Catalog\ImportExport.

Little note. Do not include your website. Just the most important. You will be more safe again an attack.

Do you read this tuto  ?
https://www.clicshopping.org/forum/blogs/entry/5-secure-clicshopping/

[ClicShopping]

Hello @GuillaumeSochon,

Welcome,
i just change the title and remove your website link, just a better practice. I hope it's fine for you.
About the Drack report, I will look but I recommend to open an issue on Github. If there is a bug it will be fixed for a next release.
I looked the log and I see you, something happen with the api.

After testing, it's important to  update the sql request. It will be implemented on the next release. Do not forget after to actualize your page to see the information

 

ALTER TABLE `clic_marketplace_file_informations` CHANGE `is_installed` `is_installed` TINYINT(4) NOT NULL DEFAULT '0';
ALTER TABLE `clic_marketplace_categories` CHANGE `sort_order` `sort_order` INT(3) NULL DEFAULT '0';
ALTER TABLE `clic_marketplace_categories` CHANGE `parent_id` `parent_id` INT(11) NOT NULL DEFAULT '0'; 

 

[Drack]

@ClicShopping,
Thank you for this update, yes work for me  now

@GuillaumeSochon
look this error in your log
[23-Aug-2023 03:18:24 America/New_York] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sogu7276_clic451.csw2_marketplace_file_informations' doesn't exist in /home/sogu7276/shop/includes/ClicShopping/OM/Db.php:107

You must applied this patch in your phpMyadmin.
Before the latest release marketplace_file_informations inside schema directory was not correct, a patch has been applied and resolve this problem.
 

CREATE TABLE `clic_marketplace_file_informations` (
  `id` int(11) NOT NULL,
  `file_id` int(11) NOT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `date_created` date DEFAULT NULL,
  `date_updated` date DEFAULT NULL,
  `file_version` varchar(255) DEFAULT NULL,
  `file_downloads` int(11) NOT NULL,
  `file_rating` int(11) NOT NULL,
  `file_prices` decimal(15,4) DEFAULT NULL,
  `file_date_added` date DEFAULT NULL,
  `file_url_screenshot` text DEFAULT NULL,
  `file_url_download` text DEFAULT NULL,
  `is_installed` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `clic_marketplace_file_informations`
--
ALTER TABLE `clic_marketplace_file_informations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `index_file_id` (`file_id`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `clic_marketplace_file_informations`
--
ALTER TABLE `clic_marketplace_file_informations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;


## patch

ALTER TABLE `clic_marketplace_file_informations` CHANGE `is_installed` `is_installed` TINYINT(4) NOT NULL DEFAULT '0';
ALTER TABLE `clic_marketplace_categories` CHANGE `sort_order` `sort_order` INT(3) NULL DEFAULT '0';
ALTER TABLE `clic_marketplace_categories` CHANGE `parent_id` `parent_id` INT(11) NOT NULL DEFAULT '0';