Junkman Posted January 4, 2022 Share Posted January 4, 2022 First time trying this, so could be something I've got wrong, but have tried a number of things, and nothing seems to work. Have checked host details, user names privlidges and all seem correct. I get no warnings or error messages during the install, and it all goes through without any obvious issues, but when I check the database there is nothing, not even the tables? My back end is a SME server, version 10 Even tried changing the php version to 7.3 instead of 7.5 still no joy. Is there a way to get more feed back from the installer as to where the problem might be? Link to comment Share on other sites More sharing options...
Al Brookbanks Posted January 4, 2022 Share Posted January 4, 2022 Have you checked the PHP error log? Link to comment Share on other sites More sharing options...
Junkman Posted January 4, 2022 Author Share Posted January 4, 2022 Maybe you can decipher this for me ... Not the whole file, just a bit from the beginning: [04-Jan-2022 22:35:45 UTC] PHP Notice: Trying to get property 'value' of non-object in /home/e-smith/files/ibays/cc_2022/html/cache/skin/788345d789a93a9de87decc7df66ccf9334605fa_0.file.skin.install.php.php on line 280 [04-Jan-2022 22:35:45 UTC] PHP Notice: Undefined index: FORM in /home/e-smith/files/ibays/cc_2022/html/cache/skin/788345d789a93a9de87decc7df66ccf9334605fa_0.file.skin.install.php.php on line 283 [04-Jan-2022 22:35:45 UTC] PHP Notice: Trying to get property 'value' of non-object in /home/e-smith/files/ibays/cc_2022/html/cache/skin/788345d789a93a9de87decc7df66ccf9334605fa_0.file.skin.install.php.php on line 283 [04-Jan-2022 22:35:45 UTC] PHP Notice: Undefined index: FORM in /home/e-smith/files/ibays/cc_2022/html/cache/skin/788345d789a93a9de87decc7df66ccf9334605fa_0.file.skin.install.php.php on line 286 [04-Jan-2022 22:35:45 UTC] PHP Notice: Trying to get property 'value' of non-object in /home/e-smith/files/ibays/cc_2022/html/cache/skin/788345d789a93a9de87decc7df66ccf9334605fa_0.file.skin.install.php.php on line 286 [04-Jan-2022 22:35:45 UTC] PHP Notice: Undefined index: FORM in /home/e-smith/files/ibays/cc_2022/html/cache/skin/788345d789a93a9de87decc7df66ccf9334605fa_0.file.skin.install.php.php on line 289 [04-Jan-2022 22:35:45 UTC] PHP Notice: Trying to get property 'value' of non-object in /home/e-smith/files/ibays/cc_2022/html/cache/skin/788345d789a93a9de87decc7df66ccf9334605fa_0.file.skin.install.php.php on line 289 [04-Jan-2022 22:36:20 UTC] PHP Warning: mysqli::__construct() expects parameter 5 to be int, string given in /home/e-smith/files/ibays/cc_2022/html/setup/setup.install.php on line 100 [04-Jan-2022 22:36:20 UTC] PHP Warning: mysqli_options() [<a href='http://docs.php.net/manual/en/function.mysqli-options.php'>function.mysqli-options.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/setup/setup.install.php on line 102 [04-Jan-2022 22:36:20 UTC] PHP Warning: mysqli::close() [<a href='http://docs.php.net/manual/en/mysqli.close.php'>mysqli.close.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/setup/setup.install.php on line 109 [04-Jan-2022 22:36:20 UTC] PHP Warning: mysqli::__construct() expects parameter 5 to be int, string given in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 37 [04-Jan-2022 22:36:20 UTC] PHP Warning: mysqli_options() [<a href='http://docs.php.net/manual/en/function.mysqli-options.php'>function.mysqli-options.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 39 [04-Jan-2022 22:36:20 UTC] PHP Warning: mysqli::query() [<a href='http://docs.php.net/manual/en/mysqli.query.php'>mysqli.query.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 217 [04-Jan-2022 22:36:20 UTC] PHP Warning: Database::error() [<a href='http://docs.php.net/manual/en/database.error.php'>database.error.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 97 [04-Jan-2022 22:36:20 UTC] PHP Notice: Undefined offset: 0 in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 258 [04-Jan-2022 22:36:20 UTC] PHP Warning: mysqli::query() [<a href='http://docs.php.net/manual/en/mysqli.query.php'>mysqli.query.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 217 [04-Jan-2022 22:36:20 UTC] PHP Warning: Database::error() [<a href='http://docs.php.net/manual/en/database.error.php'>database.error.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 97 [04-Jan-2022 22:36:20 UTC] PHP Warning: mysqli::query() [<a href='http://docs.php.net/manual/en/mysqli.query.php'>mysqli.query.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 217 [04-Jan-2022 22:36:20 UTC] PHP Warning: Database::error() [<a href='http://docs.php.net/manual/en/database.error.php'>database.error.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 97 [04-Jan-2022 22:36:20 UTC] PHP Warning: mysqli::query() [<a href='http://docs.php.net/manual/en/mysqli.query.php'>mysqli.query.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 217 [04-Jan-2022 22:36:20 UTC] PHP Warning: Database::error() [<a href='http://docs.php.net/manual/en/database.error.php'>database.error.php</a>]: Couldn't fetch mysqli in /home/e-smith/files/ibays/cc_2022/html/classes/db/mysqli.class.php on line 97 Link to comment Share on other sites More sharing options...
bsmither Posted January 5, 2022 Share Posted January 5, 2022 When entering the details of where and what to use to connect to the database, are you entering something other than 3306 for the "database port"? If anything at all? If not entering anything, then there should be a relevant directive in the system's PHP.INI file, [mysqli] section. Link to comment Share on other sites More sharing options...
Junkman Posted January 5, 2022 Author Share Posted January 5, 2022 39 minutes ago, bsmither said: When entering the details of where and what to use to connect to the database, are you entering something other than 3306 for the "database port"? If anything at all? I didn't see any option to enter a database port, the server has port 3306 open and set to listen (as reported by: netstat -ant ) The SMEServer FAQ file ( https://wiki.koozali.org/MySQL#Optimizing_MYSQL_default_settings ) does talk about not using ports any more, and is using sockets instead, not sure if this will have any impact on what is happening? But that FAQ file is for version 9 and I now have version 10 installed. Which says "MySQL is provided by MariaDB" so I'm thinking it is using port 3306 again, especially since the netstat reported the the port is actively in LISTEN mode. That all said, this is getting above my limited understanding on how things work, so I could be totally wrong. Link to comment Share on other sites More sharing options...
Junkman Posted January 5, 2022 Author Share Posted January 5, 2022 Looking at the error log, and pondering bsmither's comments. I looked at line 100 of file setup.install.php, parameter 5 is the port number, so the code above that might be returning blank: $dbport = !empty($_POST['global']['dbport']) ? $_POST['global']['dbport'] : ini_get('mysqli.default_port'); So I'm looking to see what the mysqli.default_port is set for the SME server, if anyone has any hints that would be great, if I find it first I'll post it here. SME Server is based on CentOS 7 if that is any help Link to comment Share on other sites More sharing options...
bsmither Posted January 5, 2022 Share Posted January 5, 2022 Please visit this URL: https://www.MY_STORE_DOMAIN.com/setup/info.php where MY_STORE_DOMAIN is the web name of your server (however you access CubeCart). In the top table, you will find the location of the Loaded Configuration File. In this file, in the [mysqli] section, you will find the details PHP is expecting to use. Then, scroll down to the mysqli table. Here , it will show the specific details that PHP is expecting to use, if any are stated. Unfortunately, I cannot make suggestions on where to find the Maria database configuration file. It might be at: etc/mysql/my.cnf In that file, the [client] section, will be the details on how to connect to the database -- I assume. Link to comment Share on other sites More sharing options...
Junkman Posted January 8, 2022 Author Share Posted January 8, 2022 On 1/5/2022 at 10:26 PM, bsmither said: Please visit this URL: https://www.MY_STORE_DOMAIN.com/setup/info.php where MY_STORE_DOMAIN is the web name of your server (however you access CubeCart). Which give me [08-Jan-2022 17:50:43 Pacific/Auckland] PHP Warning: phpinfo() has been disabled for security reasons in /home/e-smith/files/ibays/cc_2022/html/setup/info.php on line 14 So, somewhere in the SME server it is locking down the phpinfo() option, which might also be causing issues in other places ... I'll do some hunting. Thanks Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.