7.14.2 installation failure

SuiteCRM Forum - English Language Installation & Upgrade Help
1

Have been beating my head against the wall installing SuiteCRM 7.14.2 on Win11 Pro, I now need to ask the experts.

PHP 8.2.13, Apache 2.4.58 and MySQL 8.0.35.0 are installed.
MySQL Server 8.0\bin, Apache24\bin and PHP added to system variables
MySQL user of “user1” created with ALL privileges.

Database Configuration values attempted are:
Database Name: suitecrm (generated default)
Host Name: localhost
SuiteCRM Database User: ‘Provide existing user’
SuiteCRM Database User: user1
SuiteCRM Database User Password: (correct password)
Re-enter SuiteCRM Database User Password: (correct password)

Installation Step 2 of 2 - Configuration error generated "Database error: Unknown database ‘suitecrm’

I get the same error if I change the database name to ‘SuiteCRM’, the actual case-sensitive folder name.
Please advise, thanks very much.

2

I would start by checking the SQL modules in PHP

3

I also cleared the browser cache and tried again; here is the latest suitecrm install.log contents:

2023-12-04 16:48:13…installerHook: Info: custom/install/install_hooks.php not present, no custom hooks to execute
2023-12-04 16:49:07…Begin System Check Process *************
2023-12-04 16:49:07…XML Parsing Support Found
2023-12-04 16:49:07…JSON Parsing Support Found
2023-12-04 16:49:07…MBString Support Found
2023-12-04 16:49:07…ZIP Support Found
2023-12-04 16:49:07…/custom directory and subdirectory check passed
2023-12-04 16:49:07…cache directory and subdirectory check passed
2023-12-04 16:49:07…/module directory and subdirectory check passed
2023-12-04 16:49:07…/upload directory check passed
2023-12-04 16:49:07…/zip check passed
2023-12-04 16:49:07…PCRE version check passed
2023-12-04 16:49:07…installerHook: Info: custom/install/install_hooks.php not present, no custom hooks to execute
2023-12-04 16:49:07…php.ini location found. C:\php\php.ini
2023-12-04 16:49:07…Outputting HTML for System check
2023-12-04 16:49:07…No Errors were found *************
2023-12-04 16:49:08…installerHook: Info: custom/install/install_hooks.php not present, no custom hooks to execute
2023-12-04 16:49:09…installerHook: Info: custom/install/install_hooks.php not present, no custom hooks to execute

4

Hello pgr. Can you specify what to check?
Thanks.

5

What’s the output of this command:
php -m | grep sql

6

I’m running Win11 Pro; are you able to tell me its equivalent (with findstr)?
Thanks.

7

Just use

php -m

And look at the list (using your eyes to grep) :slight_smile:

8

php -m:

[PHP Modules]
bcmath
calendar
Core
ctype
curl
date
dom
filter
gd
hash
iconv
json
libxml
mbstring
mysqli
mysqlnd
pcre
PDO
pdo_mysql
Phar
random
readline
Reflection
session
SimpleXML
SPL
standard
tokenizer
xml
xmlreader
xmlwriter
zip
zlib

[Zend Modules]

9

Did you install apache, mysql, and php by hand? Or are you using Xampp, or WampServer, to install configure and run these for you?

10

Apache 2.4.58, MySQL 8.0.35, and PHP 8.2.13 installed manually.
Thanks.

11

Can you install PHPmyAdmin, browse to it at the address localhost/phpmyadmin, and look for the names of the databases on your local MySQL. If you don’t see suitecrm in the list of databases, click “Create database” and create it.

12

I had considered manually creating the database through phpmyadmin but one of the discussions on SuiteCRM installationsrecommended to let the software create it. However, I did as you advised and installation did complete, but with several dozen of these occurrences:
Deprecated: Implicit conversion from float 251736.00000000003 to int loses precision in C:\Apache24\htdocs\SuiteCRM\include\utils.php on line 1636
Deprecated: Function strftime() is deprecated in C:\Apache24\htdocs\SuiteCRM\include\SugarLogger\SugarLogger.php on line 239

Deprecated: base64_decode(): Passing null to parameter #1 ($string) of type string is deprecated in C:\Apache24\htdocs\SuiteCRM\modules\Emails\EmailUI.php on line 1088

Deprecated: base64_decode(): Passing null to parameter #1 ($string) of type string is deprecated in C:\Apache24\htdocs\SuiteCRM\modules\Emails\EmailUI.php on line 1315

I ran Repair and Rebuild, but trying to create a user resulted in these:

(3x) Deprecated : base64_decode(): Passing null to parameter #1 ($string) of type string is deprecated in C:\Apache24\htdocs\SuiteCRM\modules\Emails\EmailUI.php on line 1088

(1x) Deprecated : base64_decode(): Passing null to parameter #1 ($string) of type string is deprecated in C:\Apache24\htdocs\SuiteCRM\modules\Emails\EmailUI.php on line 1315

Thanks.

13

I was successful creating a user on the second attempt (I might have had a password mismatch, sorry for the mixup if so).
The successful completion generated two occurrences of this:
Deprecated : Using php-function “url2html” as a modifier is deprecated and will be removed in a future release. Use Smarty::registerPlugin to explicitly register a custom modifier. in C:\Apache24\htdocs\SuiteCRM\vendor\smarty\smarty\libs\sysplugins\smarty_internal_compile_private_modifier.php on line 112
Thanks.

14

The deprecation messages are merely warnings to the developers to update the code to use some newer methods, before the old methods become unavailable in the next major release.

15

I got 7.14.2 running and logged in as a standard user. Just dealing with the email config problems now. Will start a new topic if I can’t get it sorted. Thanks to all.

1 Like