Post by MajorPain » Sun May 12, 2024 9:20 am

I attempted to update our website from 3.0.3.8 to 3.0.3.9 but didn't workout so I attempted to revert it back.
I uploaded the backup files and I imported the backup database.
I can access the front end, but get a 500 error on the admin area.

When I check the error.log in the admin folder I am getting this:
[11-May-2024 21:11:31 America/Toronto] PHP Fatal error: Uncaught Exception: Error: Could not make a database link using valleybe_ocuser@localhost! in /home/valleybee/public_html/system/library/db/mysqli.php:19
Stack trace:
#0 /home/valleybee/storage/modification/system/library/db.php(41): DB\MySQLi->__construct('localhost', 'db_user', 'db_pw', 'db_name', '3306')
#1 /home/valleybee/public_html/system/framework.php(80): DB->__construct('mysqli', 'localhost', 'db_user', 'db_pw', 'db_name', '3306')
#2 /home/valleybee/public_html/system/startup.php(104): require_once('/home/valleybee...')
#3 /home/valleybee/public_html/admin/index.php(19): start('admin')
#4 {main}
thrown in /home/valleybee/public_html/system/library/db/mysqli.php on line 19
I've double and triple checked the config files and the correct information is in both and I'm now at a loss. What am I missing?
Last edited by MajorPain on Tue May 14, 2024 2:08 am, edited 1 time in total.

Active Member

Posts

Joined
Mon Jul 09, 2018 9:05 am

Post by MajorPain » Sun May 12, 2024 9:34 am

Also forgot to mention that I had php set for 7.4 in the past when the website worked, but when I uploaded all the files to restore the website, when I went to the admin page, it told me it required php 7.3. Changed it to 7.3, and it didn't work, and then changed it back to 7.4, and the required 7.3 message wasn't appearing anymore.

Active Member

Posts

Joined
Mon Jul 09, 2018 9:05 am

Post by MajorPain » Sun May 12, 2024 9:54 am

Update. So I resolved the error and 500 issue. Mistyped the db username.
Admin login page appears now. But it's not accepting my credentials.
Sort of the same issue with the timezone issue but it appears all is fine.
I'll keep digging.

Active Member

Posts

Joined
Mon Jul 09, 2018 9:05 am

Post by MajorPain » Sun May 12, 2024 7:29 pm

So still trying to figure it out. I've been getting the message I am locked out for an hour because of too many login attempts.
So I edited the login.php and commented out the line to allow me more attempts.
Still can't login in.
I've done the password change but getting no match for username and password.

Active Member

Posts

Joined
Mon Jul 09, 2018 9:05 am

Post by paulfeakins » Mon May 13, 2024 6:48 pm

MajorPain wrote:
Sun May 12, 2024 9:20 am
I attempted to update our website from 3.0.3.8 to 3.0.3.9 but didn't workout so I attempted to revert it back.
I uploaded the backup files and I imported the backup database.
How exactly did you attempt this upgrade?

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Legendary Member

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by straightlight » Mon May 13, 2024 6:57 pm

MajorPain wrote:
Sun May 12, 2024 7:29 pm
So still trying to figure it out. I've been getting the message I am locked out for an hour because of too many login attempts.
So I edited the login.php and commented out the line to allow me more attempts.
Still can't login in.
I've done the password change but getting no match for username and password.
More information is needed. The login.php file was modified for what reason? What was modified and what are the server error logs outputting since the modifications you didn't need to make on that file?

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by MajorPain » Tue May 14, 2024 2:06 am

paulfeakins wrote:
Mon May 13, 2024 6:48 pm
MajorPain wrote:
Sun May 12, 2024 9:20 am
I attempted to update our website from 3.0.3.8 to 3.0.3.9 but didn't workout so I attempted to revert it back.
I uploaded the backup files and I imported the backup database.
How exactly did you attempt this upgrade?
Backed up files and database.
Uploaded 3.0.3.9
Changed php from 7.4 to 8.0
Went to website.com/install and performed update.
Updated finished
Alt f5 front end and back end
Ran into website issues (forget now but think pages weren't loading)
Reverted back to 3.0.3.8.
With help I eventually was able to login to admin area.

Active Member

Posts

Joined
Mon Jul 09, 2018 9:05 am

Post by MajorPain » Tue May 14, 2024 2:07 am

straightlight wrote:
Mon May 13, 2024 6:57 pm
MajorPain wrote:
Sun May 12, 2024 7:29 pm
So still trying to figure it out. I've been getting the message I am locked out for an hour because of too many login attempts.
So I edited the login.php and commented out the line to allow me more attempts.
Still can't login in.
I've done the password change but getting no match for username and password.
More information is needed. The login.php file was modified for what reason? What was modified and what are the server error logs outputting since the modifications you didn't need to make on that file?
login.php was modified to bypass the 5 login attempts that locked me out.
Error.log had nothing.

Active Member

Posts

Joined
Mon Jul 09, 2018 9:05 am

Post by MajorPain » Tue May 14, 2024 2:08 am

The issues was resolved with some help.
An extension that was working in the past started causing issues when everything was reverted back to 3.0.3.8

Active Member

Posts

Joined
Mon Jul 09, 2018 9:05 am
Who is online

Users browsing this forum: No registered users and 14 guests