Page 3 of 3

Re: Unable to buy anything from any special port.

Posted: Wed May 20, 2020 16:04 UTC
by TheMightyDude
Hmm, seems MySQL doesn't like spaces in it LOL

Ok, in that connectdb.php file...

That line I said to put in there, replace it with this line:

Code: Select all

$db->Execute ("SET SESSION sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';");
It seems that you cannot have spaces in the value.
That "should" resolve the logging out issue.

Re: Unable to buy anything from any special port.

Posted: Wed May 20, 2020 19:41 UTC
by usalabs
Yahooooo, that fixed it alright,,,, thanks.

ADDENDUM
Uh Oh, I spoke to soon, the Planet page after you set a planet to sell, this comes up:-

Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given in /var/www/bnt/backends/adodb/adodb-perf.inc.php on line 170

I figured it out, it was when I was installing an image system, that I had to change to PHP 7.3 and forgot to change it back, and now it's PHP 7.2 everything is working fine now.

Image

Re: Unable to buy anything from any special port.

Posted: Thu May 21, 2020 06:47 UTC
by TheMightyDude
Ok, just to make sure, are you saying its all working fine for you now?

If so, I will get back to what I was doing.

Re: Unable to buy anything from any special port.

Posted: Thu May 21, 2020 12:05 UTC
by usalabs
From the aspects of the current problems, they are fixed, but I found another one that I'll post as a new problem.