[resolved] Migration issues while moving MySQL DB from old server: Page 2

[resolved] Migration issues while moving MySQL DB from old server

KevinTheJedi

Might be something with your PHP version, PHP extensions, JavaScript version, etc. You see, we use PHP date/time formats (with a few minor exceptions) to configure the different system formats but to actually display the dates in the browser they get reformatted/translated into JavaScript formats (as they are different than PHP's). So the issue could lie anywhere between the aforementioned areas.

Cheers.

Arao

@KevinTheJedi

Absolutely. I have only one version, PHP-7.4 but something must be wrong in the extension setup, etc. It doesn't really matter. Thanks again for your help.

ntozier

Try aaa

Arao

Thanks @ntozier but that doesn't work. Not an issue because I can live with that. A bigger problem started today when I wanted to install PhpMyadmin and the whole thing broke. The websites wouldn't work and I quickly uninstalled phpmyadmin. Retained package db-common

The error i see in /var/log/nginx/error.log

 2021/07/10 12:25:59 [error] 950#950: *23 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Call to undefined function _S() in /var/www/osticket/upload/include/class.mailer.php:612
Stack trace:
#0 /var/www/osticket/upload/include/class.mailer.php(632): Mailer->send()
#1 /var/www/osticket/upload/bootstrap.php(316): Mailer::sendmail()
#2 /var/www/osticket/upload/bootstrap.php(201): Bootstrap::croak()
#3 /var/www/osticket/upload/main.inc.php(28): Bootstrap::connect()
#4 /var/www/osticket/upload/client.inc.php(21): require_once('/var/www/ostick...')
#5 /var/www/osticket/upload/index.php(16): require('/var/www/ostick...')
#6 {main}
  thrown in /var/www/osticket/upload/include/class.mailer.php on line 612" while reading response header from upstream, client: 172.25.1.1, server: support.konspec.in, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.4-fpm.sock:", host: "support.konspec.in:6443"

I can't believe this could get so messed up with an install/uninstall of PhpMyadmin. I checked the php.ini for php7.4 files in the 3 directories and they are fine. I only have 1 version of php which 7.4.

Could you please let me know what is the issue?

Arao

Re-installed php7.4, no difference. All configuration in nginx and OsTicket are intact.

Also, I tried http://support.konspec.in:8081/phpmyinfo but I get a 404 not found. /var/www/html/phpinfo.php file is present. I also tried using the local IP but no use.

As you may have noticed, this thread is closely related to another one https://forum.osticket.com/d/99659-force-ssl-not-working.

Should I start a new thread for this issue?

Arao

Hi @ntozier and @KevinTheJedi ,

Do you think there is some way to troubleshoot this issue? I feel rather sheepish about messing this up when everything was working fine but I thought PhpMyadmin is a harmless tool. Little did I know...feels so close yet so far!

Would appreciate any input in solving this issue.

Thanks,
Anand

KevinTheJedi

@Arao

Uncaught Error: Call to undefined function _S()

This means that osTicket can’t connect to the database (for whatever reason). Make sure MySQL is still running and has the osTicket database present. You should check your ost-config.php file (in /path/to/osTicket/include/ost-config.php) for the database connection information and verify it’s still accurate.

Cheers.

Arao

@KevinTheJedi

Many thanks and you are right! I am actually aghast as to how did the credentials change....the website(s) were working perfectly and all I did was install/uninstall phpmyadmin. So, there is no business for anyone to touch ost-config.php. That is the reason I never bothered to check it. It is well now and things are working fine.

Just hope that I don't have revive this thread 😅

I thank you and @ntozier for all your support. Have a quite weekend. Please close thread.

Best Regards,
Anand

« Previous Page