Hi guys,
I’ve been running v4.5.19 for a while now and never really updated it as it was working fine. This was around the time v5 was also out and required totally separate installation. So today, I thought let’s try to use the script to update instead.
However, there are two things.
I notice that the script is attempting to update directly to v5.10.8
I believe v4.5.50 uses PHP7.4 now right? I’ve been running 4.5.19 with PHP7.3
I do have both of them installed, just need confirmation as I see a lot of mixed comments in the forums.
I am setting up a fresh installation of 4.5.50 and there’s a little problem.
I managed to get to the setup page, filled up all the information including the database credentials. All the tests were successful, and upon continuing, I get Error 500
When I try to run sudo -u user /opt/cpanel/ea-php74/root/usr/bin/php /home/user/public_html/artisan migrate --force
I get this error:
In Connection.php line 669:
SQLSTATE[HY000] [1045] Access denied for user 'dbuser'@'localhost' (using password: YES) (SQL: select * from information_schema.tables where table_schema = dbname and table_name =
migrations and table_type = 'BASE TABLE')
In PDOConnection.php line 47:
SQLSTATE[HY000] [1045] Access denied for user 'dbuser'@'localhost' (using password: YES)
In PDOConnection.php line 43:
SQLSTATE[HY000] [1045] Access denied for user 'dbuser'@'localhost' (using password: YES)
** Private credentials have been altered for security reasons. I am able to connect to the database via the user and password and it has all the permissions granted, so I’m not sure what is going on.
I have also tried changing the DB_HOST=127.0.0.1 instead of localhost and then ran:
sudo -u user /opt/cpanel/ea-php74/root/usr/bin/php /home/user/public_html/artisan config:clear
sudo -u user /opt/cpanel/ea-php74/root/usr/bin/php /home/userpublic_html/artisan cache:clear
So you recommend I restore the database over the new installation? I was under the impression I get a fresh copy running, and then only overwrite the database.
I’ll try to overwrite the database for now with the mysqldump of the 4.5.19 and see if that fixes it
Hey @hillel Since things were getting really broken, I restored everything back to 4.5.19 again.
So what I’m doing now is just overwrite the existing files with the ones from 4.5.50 and then go into the UI, settings → Account Management and hit Migration. I select self hosted, add the URL and credentials and upon hitting submit, nothing really happens. It still stays at 4.5.19. What am I missing here? Is there any way to troubleshoot this?
If I setup a new install altogether, will I be able to still bring my data (clients, invoices, payment records, etc) over to the new version though? Maybe by exporting or something?
Hmm… that is what I was doing earlier but it didnt really install properly… I’ll try it again, this time with a totally clean slate since the backups are still working fine when I restore them…
One more question, to move to v5 later on, will I need a new domain? Or will I be able to use the existing domain still? I remember the last time it required a totally new domain and install for setting up v5
Oh! This is new. I believe I’ve seen this many times in the docs that invoice ninja only runs on primary domain and cannot run on subdomains. Okay, I’ll try doing a clean slate v4.5.50 install once again and see if this works.
So, after countless attempts of upgrading and constant fails, I have finally given up. I just cant upgrade the 4.5.19 to 4.5.50 no matter how I try it. So, for now, I’m just going to continue using this version and maybe eventually just start fresh on v5 from scratch.
However, since I have migrated to a new host, there’s a new issue that’s rising. For some reasons, it cant connect to my mailserver, throwing the following error:
Connection could not be established with host mail.jerungmail.com [Connection timed out #110]
I use the exact same credentials on Outlook and it works perfectly fine. What could be the problem here?
I’m able to ping to my mailserver from the server where its hosted. I enabled debug and this is what it shows:
[15:27:24] LOG.error: Connection could not be established with host mail.jerungmail.com [Connection timed out #110]
{"context":"PHP","user_id":1,"account_id":1,"user_name":"M******* A****","method":"POST","user_agent":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36","locale":"en","ip":"xxx.xxx.xxx.xxx","count":8,"is_console":"no","is_api":"no","db_server":"mysql","url":"setup"}
Sensitive information has been redacted. Any help is appreciated. Everything else seems to be working fine, only the mailserver is not connecting.