OpenCart Community

Upon having my 3.0.3.8 site go live, I'm having minor issues with the navigation panel. The left pane is scrunched. Although it works, it is a bit annoying.
I'm guessing it has to do with something in the admin/config.php filed posted below. Any specific ideas?

<?php
// HTTP
define('HTTP_SERVER', 'https://xxxx.com/admin/');
define('HTTP_CATALOG', 'https:/xxxx.com/');

// HTTPS
define('HTTPS_SERVER', 'https://xxxx.com/admin/');
define('HTTPS_CATALOG', 'https://xxxx.com/');

// DIR
define('DIR_APPLICATION', '/home/keepitp1/public_html/xxxx.com/admin/');
define('DIR_SYSTEM', '/home/keepitp1/public_html/xxxx.com/system/');
define('DIR_IMAGE', '/home/keepitp1/public_html/xxxx.com/image/');
define('DIR_STORAGE', '/home/keepitp1/storage/');
define('DIR_CATALOG', '/home/keepitp1/public_html/xxxx/catalog/');
define('DIR_LANGUAGE', DIR_APPLICATION . 'language/');
define('DIR_TEMPLATE', DIR_APPLICATION . 'view/template/');
define('DIR_CONFIG', DIR_SYSTEM . 'config/');
define('DIR_CACHE', DIR_STORAGE . 'cache/');
define('DIR_DOWNLOAD', DIR_STORAGE . 'download/');
define('DIR_LOGS', DIR_STORAGE . 'logs/');
define('DIR_MODIFICATION', DIR_STORAGE . 'modification/');
define('DIR_SESSION', DIR_STORAGE . 'session/');
define('DIR_UPLOAD', DIR_STORAGE . 'upload/');

The full server path should never be posted if the domain name is being specified along for security reasons. I would suggest to edit those entries. Are you using .htaccess or the addon domains from your host?

straightlight wrote: ↑

Mon Apr 04, 2022 10:26 pm

The full server path should never be posted if the domain name is being specified along for security reasons. I would suggest to edit those entries. Are you using .htaccess or the addon domains from your host?

I'm using .htaccess

I was wondering if I needed the full path in the other define('DIR... statements
Or, are you thinking it's something in the .htaccess file

I'm replaced an opencart 2.0 site with 3.0

geotnt wrote: ↑

Tue Apr 05, 2022 1:34 am

straightlight wrote: ↑

Mon Apr 04, 2022 10:26 pm

The full server path should never be posted if the domain name is being specified along for security reasons. I would suggest to edit those entries. Are you using .htaccess or the addon domains from your host?

[b[I'm using .htaccess[/b]

I was wondering if I needed the full path in the other define('DIR... statements
Or, are you thinking it's something in the .htaccess file

I'm replaced an opencart 2.0 site with 3.0

Then, please post your .htaccess file (remember to replace the original paths with 'x'es).

straightlight wrote: ↑

Tue Apr 05, 2022 1:35 am

geotnt wrote: ↑

Tue Apr 05, 2022 1:34 am

straightlight wrote: ↑

Mon Apr 04, 2022 10:26 pm

The full server path should never be posted if the domain name is being specified along for security reasons. I would suggest to edit those entries. Are you using .htaccess or the addon domains from your host?

[b[I'm using .htaccess[/b]

I was wondering if I needed the full path in the other define('DIR... statements
Or, are you thinking it's something in the .htaccess file

I'm replaced an opencart 2.0 site with 3.0

Then, please post your .htaccess file (remember to replace the original paths with 'x'es).

# 1.To use URL Alias you need to be running apache with mod_rewrite enabled.

# 2. In your opencart directory rename htaccess.txt to .htaccess.

# For any support issues please visit: http://www.opencart.com

Options +FollowSymlinks

# Prevent Directory listing
Options -Indexes

# Prevent Direct Access to files
<FilesMatch "(?i)((\.tpl|\.twig|\.ini|\.log|(?<!robots)\.txt))">
Require all denied
## For apache 2.2 and older, replace "Require all denied" with these two lines :
# Order deny,allow
# Deny from all
</FilesMatch>

# SEO URL Settings
RewriteEngine On
# If your opencart installation does not run on the main web folder make sure you folder it does run in ie. / becomes /shop/

RewriteBase /
RewriteRule ^sitemap.xml$ index.php?route=extension/feed/google_sitemap [L]
RewriteRule ^googlebase.xml$ index.php?route=extension/feed/google_base [L]
RewriteRule ^system/storage/(.*) index.php?route=error/not_found [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_URI} !.*\.(ico|gif|jpg|jpeg|png|js|css)
RewriteRule ^([^?]*) index.php?_route_=$1 [L,QSA]

### Additional Settings that may need to be enabled for some servers
### Uncomment the commands by removing the # sign in front of it.
### If you get an "Internal Server Error 500" after enabling any of the following settings, restore the # as this means your host doesn't allow that.

# 1. If your cart only allows you to add one item at a time, it is possible register_globals is on. This may work to disable it:
# php_flag register_globals off

# 2. If your cart has magic quotes enabled, This may work to disable it:
# php_flag magic_quotes_gpc Off

# 3. Set max upload file size. Most hosts will limit this and not allow it to be overridden but you can try
# php_value upload_max_filesize 999M

# 4. set max post size. uncomment this line if you have a lot of product options or are getting errors where forms are not saving all fields
# php_value post_max_size 999M

# 5. set max time script can take. uncomment this line if you have a lot of product options or are getting errors where forms are not saving all fields
# php_value max_execution_time 200

# 6. set max time for input to be recieved. Uncomment this line if you have a lot of product options or are getting errors where forms are not saving all fields
# php_value max_input_time 200

# 7. disable open_basedir limitations
# php_admin_value open_basedir none

You all think the nav panel is SCRUCHED because of htaccess.
I couldn't see an icon that fitted that. :-)

Any chance you could post a screenshot so we can see what you mean ?

cyclops12 wrote: ↑

Tue Apr 05, 2022 2:31 am

Any chance you could post a screenshot so we can see what you mean ?

Absolutely. Also, the ability to access and edit images in the admin panel doesn't work. Basically, I'm unable to access the image folders.

geotnt wrote: ↑

Tue Apr 05, 2022 2:48 am

cyclops12 wrote: ↑

Tue Apr 05, 2022 2:31 am

Any chance you could post a screenshot so we can see what you mean ?

Absolutely. Also, the ability to access and edit images in the admin panel doesn't work. Basically, I'm unable to access the image folders.

Ensure that your CHMOD permission recursive settings from FTP are set to 0755 on your image folder (not on files!) without any error messages involved during the process.

Try a CTRL+F5

straightlight wrote: ↑

Tue Apr 05, 2022 4:11 am

geotnt wrote: ↑

Tue Apr 05, 2022 2:48 am

cyclops12 wrote: ↑

Tue Apr 05, 2022 2:31 am

Any chance you could post a screenshot so we can see what you mean ?

Absolutely. Also, the ability to access and edit images in the admin panel doesn't work. Basically, I'm unable to access the image folders.

Ensure that your CHMOD permission recursive settings from FTP are set to 0755 on your image folder (not on files!) without any error messages involved during the process.

CHMOD permissions are set to 755 for all folders and 644 for all files.

Maybe I should explain "unable to access the image folders" better. When I say that, I mean that when trying to create a new product listing at category>products and click the icon on the image tab and then clicking the icon to go to the image manager, the image manager comes up but is grayed out and nothing is clickable. In addition, I am unable to create or edit any hyperlinks on any of the product pages or information pages and probably other places I've not even discovered yet.

I sure hope these additional symptoms will trigger something for somebody,

xxvirusxx wrote: ↑

Tue Apr 05, 2022 5:40 am

Try a CTRL+F5

Tried that. I'm afraid its nothing that simple

geotnt wrote: ↑

Tue Apr 05, 2022 6:44 am

straightlight wrote: ↑

Tue Apr 05, 2022 4:11 am

geotnt wrote: ↑

Tue Apr 05, 2022 2:48 am

Absolutely. Also, the ability to access and edit images in the admin panel doesn't work. Basically, I'm unable to access the image folders.

Ensure that your CHMOD permission recursive settings from FTP are set to 0755 on your image folder (not on files!) without any error messages involved during the process.

CHMOD permissions are set to 755 for all folders and 644 for all files.

Maybe I should explain "unable to access the image folders" better. When I say that, I mean that when trying to create a new product listing at category>products and click the icon on the image tab and then clicking the icon to go to the image manager, the image manager comes up but is grayed out and nothing is clickable. In addition, I am unable to create or edit any hyperlinks on any of the product pages or information pages and probably other places I've not even discovered yet.

I sure hope these additional symptoms will trigger something for somebody,

Check your developers kit > console and network tab as well as your recent server error logs.

geotnt wrote: ↑

Tue Apr 05, 2022 6:45 am

Tried that. I'm afraid its nothing that simple

What version of PHP are you running ?
I'm going to guess its not 7.4

straightlight wrote: ↑

Tue Apr 05, 2022 6:46 am

geotnt wrote: ↑

Tue Apr 05, 2022 6:44 am

straightlight wrote: ↑

Tue Apr 05, 2022 4:11 am

Ensure that your CHMOD permission recursive settings from FTP are set to 0755 on your image folder (not on files!) without any error messages involved during the process.

CHMOD permissions are set to 755 for all folders and 644 for all files.

Maybe I should explain "unable to access the image folders" better. When I say that, I mean that when trying to create a new product listing at category>products and click the icon on the image tab and then clicking the icon to go to the image manager, the image manager comes up but is grayed out and nothing is clickable. In addition, I am unable to create or edit any hyperlinks on any of the product pages or information pages and probably other places I've not even discovered yet.

I sure hope these additional symptoms will trigger something for somebody,

Check your developers kit > console and network tab as well as your recent server error logs.

The only thing in the server logs was 5 instances of this, all within a span of 1 minute.

[04-Apr-2022 21:04:12 UTC] PHP Fatal error: Uncaught Exception: Error: Could not make a database link using keepxxxx@localhost! in /home/keep/public_html/xxxx/system/library/db/mysqli.php:19
Stack trace:
#0 /home/keep/public_html/xxxx/system/library/db.php(31): DB\MySQLi->__construct('localhost', 'keep_xxxx', 'xxxx', 'keep_OpenCa...', '3306')
#1 /home/keep/public_html/xxxx/system/framework.php(80): DB->__construct('mysqli', 'localhost', 'keep_xxxx', 'xxxx', 'keep_OpenCa...', '3306')
#2 /home/keep/public_html/xxxx/system/startup.php(104): require_once('/home/keep...')
#3 /home/keep/public_html/xxxx/index.php(19): start('catalog')
#4 {main}
thrown in /home/keep/public_html/xxxx/system/library/db/mysqli.php on line 19

You're way above my head with the developer tools, but the only thing I see out of the ordinary in there is a couple of image files throwing a 404 error.

Did I mention this was all working good when it was in a test directory? The problems only happened when moved to a live directory and I edited the config files as shown in the original post.

geotnt wrote: ↑

Tue Apr 05, 2022 7:10 am

straightlight wrote: ↑

Tue Apr 05, 2022 6:46 am

geotnt wrote: ↑

Tue Apr 05, 2022 6:44 am

CHMOD permissions are set to 755 for all folders and 644 for all files.

Maybe I should explain "unable to access the image folders" better. When I say that, I mean that when trying to create a new product listing at category>products and click the icon on the image tab and then clicking the icon to go to the image manager, the image manager comes up but is grayed out and nothing is clickable. In addition, I am unable to create or edit any hyperlinks on any of the product pages or information pages and probably other places I've not even discovered yet.

I sure hope these additional symptoms will trigger something for somebody,

Check your developers kit > console and network tab as well as your recent server error logs.

The only thing in the server logs was 5 instances of this, all within a span of 1 minute.

[04-Apr-2022 21:04:12 UTC] PHP Fatal error: Uncaught Exception: Error: Could not make a database link using keepxxxx@localhost! in /home/keep/public_html/xxxx/system/library/db/mysqli.php:19
Stack trace:
#0 /home/keep/public_html/xxxx/system/library/db.php(31): DB\MySQLi->__construct('localhost', 'keep_xxxx', 'xxxx', 'keep_OpenCa...', '3306')
#1 /home/keep/public_html/xxxx/system/framework.php(80): DB->__construct('mysqli', 'localhost', 'keep_xxxx', 'xxxx', 'keep_OpenCa...', '3306')
#2 /home/keep/public_html/xxxx/system/startup.php(104): require_once('/home/keep...')
#3 /home/keep/public_html/xxxx/index.php(19): start('catalog')
#4 {main}
thrown in /home/keep/public_html/xxxx/system/library/db/mysqli.php on line 19

You're way above my head with the developer tools, but the only thing I see out of the ordinary in there is a couple of image files throwing a 404 error.

Did I mention this was all working good when it was in a test directory? The problems only happened when moved to a live directory and I edited the config files as shown in the original post.

Well, I mean ... it explains quite a few things already regarding your database configuration according to the logs you posted. Therefore, ensure that both config.php files are properly configured with your database as well to ensure from your host console that the database configuration do match with your hostname, port, database name, and credentials.

straightlight wrote: ↑

Tue Apr 05, 2022 7:24 am

geotnt wrote: ↑

Tue Apr 05, 2022 7:10 am

straightlight wrote: ↑

Tue Apr 05, 2022 6:46 am

Check your developers kit > console and network tab as well as your recent server error logs.

The only thing in the server logs was 5 instances of this, all within a span of 1 minute.

[04-Apr-2022 21:04:12 UTC] PHP Fatal error: Uncaught Exception: Error: Could not make a database link using keepxxxx@localhost! in /home/keep/public_html/xxxx/system/library/db/mysqli.php:19
Stack trace:
#0 /home/keep/public_html/xxxx/system/library/db.php(31): DB\MySQLi->__construct('localhost', 'keep_xxxx', 'xxxx', 'keep_OpenCa...', '3306')
#1 /home/keep/public_html/xxxx/system/framework.php(80): DB->__construct('mysqli', 'localhost', 'keep_xxxx', 'xxxx', 'keep_OpenCa...', '3306')
#2 /home/keep/public_html/xxxx/system/startup.php(104): require_once('/home/keep...')
#3 /home/keep/public_html/xxxx/index.php(19): start('catalog')
#4 {main}
thrown in /home/keep/public_html/xxxx/system/library/db/mysqli.php on line 19

You're way above my head with the developer tools, but the only thing I see out of the ordinary in there is a couple of image files throwing a 404 error.

Did I mention this was all working good when it was in a test directory? The problems only happened when moved to a live directory and I edited the config files as shown in the original post.

Well, I mean ... it explains quite a few things already regarding your database configuration according to the logs you posted. Therefore, ensure that both config.php files are properly configured with your database as well to ensure from your host console that the database configuration do match with your hostname, port, database name, and credentials.

Would you agree then, that since it was working properly prior to moving to a new server, and that the actual store works fine (the only issue being in the admin panle), that the admin/config.php is likely the cause of the problem?

geotnt wrote: ↑

Tue Apr 05, 2022 8:25 am

straightlight wrote: ↑

Tue Apr 05, 2022 7:24 am

geotnt wrote: ↑

Tue Apr 05, 2022 7:10 am

The only thing in the server logs was 5 instances of this, all within a span of 1 minute.

[04-Apr-2022 21:04:12 UTC] PHP Fatal error: Uncaught Exception: Error: Could not make a database link using keepxxxx@localhost! in /home/keep/public_html/xxxx/system/library/db/mysqli.php:19
Stack trace:
#0 /home/keep/public_html/xxxx/system/library/db.php(31): DB\MySQLi->__construct('localhost', 'keep_xxxx', 'xxxx', 'keep_OpenCa...', '3306')
#1 /home/keep/public_html/xxxx/system/framework.php(80): DB->__construct('mysqli', 'localhost', 'keep_xxxx', 'xxxx', 'keep_OpenCa...', '3306')
#2 /home/keep/public_html/xxxx/system/startup.php(104): require_once('/home/keep...')
#3 /home/keep/public_html/xxxx/index.php(19): start('catalog')
#4 {main}
thrown in /home/keep/public_html/xxxx/system/library/db/mysqli.php on line 19

You're way above my head with the developer tools, but the only thing I see out of the ordinary in there is a couple of image files throwing a 404 error.

Did I mention this was all working good when it was in a test directory? The problems only happened when moved to a live directory and I edited the config files as shown in the original post.

Well, I mean ... it explains quite a few things already regarding your database configuration according to the logs you posted. Therefore, ensure that both config.php files are properly configured with your database as well to ensure from your host console that the database configuration do match with your hostname, port, database name, and credentials.

Would you agree then, that since it was working properly prior to moving to a new server, and that the actual store works fine (the only issue being in the admin panle), that the admin/config.php is likely the cause of the problem?

Which is why, from my previous instructions, it states to check both config.php files.

straightlight wrote: ↑

Tue Apr 05, 2022 7:24 am

Therefore, ensure that both config.php files are properly configured with your database as well to ensure from your host console that the database configuration do match with your hostname, port, database name, and credentials.

Yep he agreed before you said it :-)

Try this
I think your storage setting was wrong.