Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Your requirements could not be resolved to an installable set of packages. #4

Open
BMLO-DWhite opened this issue Mar 31, 2023 · 4 comments

Comments

@BMLO-DWhite
Copy link

As I report this issue, please keep in mind I'm fully aware this may be my lack of knowledge on how composer, php, packages, repo's and laravel works. I'm very new to this and still learning.

I downloaded the demo and also purchased the pro/dashboard package. I was able to get the demo working on my xampp by just dropping it into the htdocs folder and opening localhost. After my purchase, I extracted all the pro and dashboard files into the kool directory where the demo is.

I updated the composer.json file to add the repo and packages (pro, blade and dashboard), added the auth.json file using the license instructions and ran composer update.

I get this error:
Problem 1
- koolreport/excel 10.6.0 requires phpoffice/phpspreadsheet ^1 -> satisfiable by phpoffice/phpspreadsheet[1.0.0, ..., 1.28.0].
- koolreport/pro[6.0.3, ..., 6.0.6] require koolreport/core 6.0.1 -> satisfiable by koolreport/core[6.0.1] from composer repo (https://repo.packagist.org) but koolreport/core is the root package and cannot be modified. See https://getcomposer.org/dep-on-root for details and assistance.
- koolreport/pro[6.0.0, ..., 6.0.2] require koolreport/core 6.0.0 -> satisfiable by koolreport/core[6.0.0] from composer repo (https://repo.packagist.org) but koolreport/core is the root package and cannot be modified. See https://getcomposer.org/dep-on-root for details and assistance.
- koolreport/pro[5.9.0, ..., 5.9.1] require koolreport/core 5.5.0 -> satisfiable by koolreport/core[5.5.0] from composer repo (https://repo.packagist.org) but koolreport/core is the root package and cannot be modified. See https://getcomposer.org/dep-on-root for details and assistance.
- koolreport/pro[5.7.0, ..., 5.7.1] require koolreport/core 5.1.0 -> satisfiable by koolreport/core[5.1.0] from composer repo (https://repo.packagist.org) but koolreport/core is the root package and cannot be modified. See https://getcomposer.org/dep-on-root for details and assistance.
- koolreport/pro 5.16.2 requires koolreport/core 5.6.2 -> satisfiable by koolreport/core[5.6.2] from composer repo (https://repo.packagist.org) but koolreport/core is the root package and cannot be modified. See https://getcomposer.org/dep-on-root for details and assistance.
- koolreport/pro 5.16.1 requires koolreport/core 5.6.1 -> satisfiable by koolreport/core[5.6.1] from composer repo (https://repo.packagist.org) but koolreport/core is the root package and cannot be modified. See https://getcomposer.org/dep-on-root for details and assistance.
- koolreport/pro[5.10.0, ..., 5.16.0] require koolreport/core 5.6.0 -> satisfiable by koolreport/core[5.6.0] from composer repo (https://repo.packagist.org) but koolreport/core is the root package and cannot be modified. See https://getcomposer.org/dep-on-root for details and assistance.
- phpoffice/phpspreadsheet[1.0.0, ..., 1.8.2] require php ^5.6|^7.0 -> your php version (8.1.17) does not satisfy that requirement.
- koolreport/pro 5.0.4 requires koolreport/core 5.0.1 -> satisfiable by koolreport/core[5.0.1] from composer repo (https://repo.packagist.org) but koolreport/core is the root package and cannot be modified. See https://getcomposer.org/dep-on-root for details and assistance.
- koolreport/pro[5.0.0, ..., 5.0.3] require koolreport/core 5.0.0 -> satisfiable by koolreport/core[5.0.0] from composer repo (https://repo.packagist.org) but koolreport/core is the root package and cannot be modified. See https://getcomposer.org/dep-on-root for details and assistance.
- koolreport/pro 4.7.1 requires koolreport/core 4.7.1 -> satisfiable by koolreport/core[4.7.1] from composer repo (https://repo.packagist.org) but koolreport/core is the root package and cannot be modified. See https://getcomposer.org/dep-on-root for details and assistance.
- koolreport/pro 4.7.0 requires koolreport/core 4.7.0 -> satisfiable by koolreport/core[4.7.0] from composer repo (https://repo.packagist.org) but koolreport/core is the root package and cannot be modified. See https://getcomposer.org/dep-on-root for details and assistance.
- koolreport/pro 4.5.1 requires koolreport/core 4.5.1 -> satisfiable by koolreport/core[4.5.1] from composer repo (https://repo.packagist.org) but koolreport/core is the root package and cannot be modified. See https://getcomposer.org/dep-on-root for details and assistance.
- koolreport/pro 4.5.0 requires koolreport/core 4.5.0 -> satisfiable by koolreport/core[4.5.0] from composer repo (https://repo.packagist.org) but koolreport/core is the root package and cannot be modified. See https://getcomposer.org/dep-on-root for details and assistance.
- koolreport/pro[4.3.0, ..., 4.3.2] require koolreport/core 4.3.0 -> satisfiable by koolreport/core[4.3.0] from composer repo (https://repo.packagist.org) but koolreport/core is the root package and cannot be modified. See https://getcomposer.org/dep-on-root for details and assistance.
- koolreport/pro[4.0.0, ..., 4.1.2] require koolreport/core 4.0.0 -> satisfiable by koolreport/core[4.0.0] from composer repo (https://repo.packagist.org) but koolreport/core is the root package and cannot be modified. See https://getcomposer.org/dep-on-root for details and assistance.
- phpoffice/phpspreadsheet[1.9.0, ..., 1.12.0] require php ^7.1 -> your php version (8.1.17) does not satisfy that requirement.
- phpoffice/phpspreadsheet[1.13.0, ..., 1.14.1] require php ^7.2 -> your php version (8.1.17) does not satisfy that requirement.
- phpoffice/phpspreadsheet[1.15.0, ..., 1.17.1] require ext-gd * -> it is missing from your system. Install or enable PHP's gd extension.
- phpoffice/phpspreadsheet[1.18.0, ..., 1.28.0] require ext-fileinfo * -> it is missing from your system. Install or enable PHP's fileinfo extension.
- koolreport/pro 6.2.0 requires koolreport/excel 10.6.0 -> satisfiable by koolreport/excel[10.6.0].
- Root composer.json requires koolreport/pro * -> satisfiable by koolreport/pro[4.0.0, ..., 4.7.1, 5.0.0, ..., 5.16.2, 6.0.0, ..., 6.2.0].

To enable extensions, verify that they are enabled in your .ini files:
- C:\Users\danie\php81\php.ini
You can also run php --ini in a terminal to see which files are used by PHP in CLI mode.
Alternatively, you can run Composer with --ignore-platform-req=ext-gd --ignore-platform-req=ext-fileinfo to temporarily ignore these required extensions.

@koolreport
Copy link
Owner

It seems the root issue is the phpspreadsheet in koolreport pro requires php 7.x and your php is upgraded to 8.x. I will forward the issue to devteam. A quick solution would be upgrading your koolreport pro to 6.2.0 or at least 6.0.2, the issue will be resolved immediately.

@koolreport
Copy link
Owner

Please Install or enable PHP's gd extension and ext-fileinfo extensions. Then try composer install or composer update again and let us know if there's any issue with KoolReport Pro or Dashboard. Thanks,

@BMLO-DWhite
Copy link
Author

BMLO-DWhite commented Apr 3, 2023

I did that and now composer update ran (at least it seems to have run. I did this by going into the php.ini file and uncommenting those 2 extensions and then running composer update from the core folder.

I'm following this example: https://www.youtube.com/watch?v=ZomIqvpVMo8

I have mysql running and the database on localhost. I can connect via a test php file.

I have the pro version of koolreport and also the dashboard. I downloaded both from my licenses and set up the auth.json. dashboard_4.2.0 koolreport_pro_6.2.0. I haven't unzipped the dashboard yet because I'm not sure where I should unzip it to or if I need it for this "test." I am confused that my composer.json says this: "name": "koolreport/core",

"version":"6.1.0", (I downloaded 6.2 zip so I expected it to say 6.2)
I have gone into my php.ini file and uncommented these 2 lines; extension=fileinfo extension=gd

In the directory I created following the tutorial, I ran composer require koolreport/core and it created the vendor dir as expected.

My dataSource is this:

return array(
    "dataSources"=>array(
        "automaker"=>array(
            "connectionString"=>"mysql:host=localhost;dbname=automaker",
            "username"=>"root",
            "password"=>"",
            "charset"=>"utf8"

        )
    )
);

Using MySql Workbench, I'm able to connect and run the query, producing results as expected. I just can't get it to run as it does in the tutorial via the index.php without the above error.

I also found this db test demo and it connects and runs fine.

<?php
# Fill our vars and run on cli
# $ php -f db-connect-test.php

$dbname = 'automaker';
$dbuser = 'root';
$dbpass = '';
$dbhost = 'localhost';

$link = mysqli_connect($dbhost, $dbuser, $dbpass) or die("Unable to Connect to '$dbhost'");
mysqli_select_db($link, $dbname) or die("Could not open the db '$dbname'");

$test_query = " SELECT customers.customerName, sum(payments.amount) as salesamount
FROM payments
JOIN customers on customers.customerNumber = payments.customerNumber
GROUP BY customers.customerName
LIMIT 10";
$result = mysqli_query($link, $test_query);

$tblCnt = 0;
while($tbl = mysqli_fetch_array($result)) {
  $tblCnt++;
  #echo $tbl[0]."<br />\n";
}

if (!$tblCnt) {
  echo "There are no tables<br />\n";
} else {
  echo "There are $tblCnt tables<br />\n";
} 
?>

@BMLO-DWhite
Copy link
Author

after going through the above all over, I'm still able to connect and get results from the db connection test.php file but not from the index.php file following the tutorial. Now the error is this from the browser:

Warning: require_once(../vendor/autoload.php): Failed to open stream: No such file or directory in C:\xampp\htdocs\kool\koolreport\BMLO\index.php on line 3

Fatal error: Uncaught Error: Failed opening required '../vendor/autoload.php' (include_path='C:\xampp\php\PEAR') in C:\xampp\htdocs\kool\koolreport\BMLO\index.php:3 Stack trace: #0 {main} thrown in C:\xampp\htdocs\kool\koolreport\BMLO\index.php on line 3

Since I really don't know what's going on, I checked the PEAR folder exists: it does.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants