Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Diabolink

An internal server error occurred.

Recommended Posts

Posted (edited)

Hi everyone, 

I just made a fresh install of OsCommerce 4.0 on my VPS. 

Quote

CentOS 7
Apache 2.4 + PHP-FPM + Varnish
PHP 8.1
MariaDB 10.2

 

After taking reading wiki installation page, I've edited the php.ini file matching what is requested. 

Everything seems to be OK, 0 error showing during the installation process of OsCommerce.

Front end and back end works well, except an internal error showing in some modules (languages, theme>customize>widget...)

image.png.e39e69f43e1f887daada5ac7ea3c26cb.png

I checked the logs stored in backend folder (/lib/backend/runtime/logs) but couldn't find any answer to what is happening. 

Here is the latest log from language page resulting in an error (I edited out server and URL infos) :

$_SERVER = [
    'USER' => 'XXXX'
    'HOME' => '/home/XXXX'
    'SCRIPT_NAME' => '/XXXX/admin/index.php'
    'REQUEST_URI' => '/XXXX/admin/languages/edit?languages_id=1&row=0'
    'QUERY_STRING' => 'languages_id=1&row=0'
    'REQUEST_METHOD' => 'GET'
    'SERVER_PROTOCOL' => 'HTTP/1.1'
    'GATEWAY_INTERFACE' => 'CGI/1.1'
    'REDIRECT_QUERY_STRING' => 'languages_id=1&row=0'
    'REDIRECT_URL' => '/XXXXX/admin/languages/edit'
    'REMOTE_PORT' => '47926'
    'SCRIPT_FILENAME' => '/home/XXXX/public_html/XXXX/admin/index.php'
    'SERVER_ADMIN' => 'webmaster@XXXX.com'
    'CONTEXT_DOCUMENT_ROOT' => '/home/XXXX/public_html'
    'CONTEXT_PREFIX' => ''
    'REQUEST_SCHEME' => 'https'
    'DOCUMENT_ROOT' => '/home/XXXX/public_html'
    'REMOTE_ADDR' => 'XXX.XXX.XXX.XXX'
    'SERVER_PORT' => '443'
    'SERVER_ADDR' => 'XXX.XXX.XXX.XXX'
    'SERVER_NAME' => 'xxxx.com'
    'SERVER_SOFTWARE' => 'Apache'
    'SERVER_SIGNATURE' => ''
    'PATH' => '/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin'
    'HTTP_X_HTTPS' => '1'
    'HTTP_COOKIE' => 'tips=1; scrolltop=0; tlSID1=XXXX; was_visit=XXXXXwas_visiXXXXXX; tlAdminID=XXXXXX; xwidth=1920; xheight=1040; store_noticeXXXXXXXXX=hidden; _csrf=XXXXXXXXXX'
    'HTTP_SEC_FETCH_DEST' => 'document'
    'HTTP_SEC_FETCH_USER' => '?1'
    'HTTP_SEC_FETCH_MODE' => 'navigate'
    'HTTP_SEC_FETCH_SITE' => 'same-origin'
    'HTTP_SEC_GPC' => '1'
    'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9'
    'HTTP_ACCEPT_LANGUAGE' => 'fr-FR;q=0.6'
    'HTTP_USER_AGENT' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.134 Safari/537.36'
    'HTTP_UPGRADE_INSECURE_REQUESTS' => '1'
    'HTTP_X_REAL_IP' => '93.23.249.75'
    'HTTP_X_FORWARDED_SERVER' => 'XXXX.com'
    'HTTP_X_FORWARDED_PROTO' => 'https'
    'HTTP_X_FORWARDED_PORT' => '443'
    'HTTP_X_FORWARDED_HOST' => 'XXXXXX.com'
    'HTTP_X_FORWARDED_FOR' => 'XXX.XXX.XXX.XXX'
    'HTTP_REFERER' => 'https://XXXXXX/XXXX/admin/languages'
    'HTTP_HOST' => 'XXXXX.com'
    'proxy-nokeepalive' => '1'
    'HTTPS' => 'on'
    'SCRIPT_URI' => 'XXXXX.com/XXXXX/admin/languages/edit'
    'SCRIPT_URL' => '/XXXXX/admin/languages/edit'
    'UNIQUE_ID' => 'XXXXXXXXXXXXXXXXX'
    'REDIRECT_STATUS' => '200'
    'REDIRECT_HTTPS' => 'on'
    'REDIRECT_SCRIPT_URI' => 'https://XXXXX.com/XXXXX/admin/languages/edit'
    'REDIRECT_SCRIPT_URL' => '/XXXXX/admin/languages/edit'
    'REDIRECT_isproxyrequest' => '1'
    'REDIRECT_UNIQUE_ID' => 'YuOrblrktQfYa6W0j95ikgAAAVM'
    'FCGI_ROLE' => 'RESPONDER'
    'PHP_SELF' => '/XXXX/admin/index.php'
    'REQUEST_TIME_FLOAT' => 1659087726.9487
    'REQUEST_TIME' => 1659087726
    'argv' => [
        0 => 'languages_id=1&row=0'
    ]
    'argc' => 1
]

I'm looking for advise, where to look first? 

As the error description is a little bit light, I checked the usual but everything seems OK so far. 
I can send more logs or anything else if needed. 

Hope this post will help new and existing Oscommerce user experimenting the same issue...

Edited by Diabolink

Share this post


Link to post
Share on other sites
10 minutes ago, Diabolink said:

I'm not familiar with stacktrace, could you send me some documentation please? 

I will try and report. 

My colleague will respond to this shortly. 

Share this post


Link to post
Share on other sites
24 minutes ago, Diabolink said:

I'm not familiar with stacktrace, could you send me some documentation please? 

I will try and report. 

Just find in the same file the lines that looks like lines at the image.

Untitled.png

Share this post


Link to post
Share on other sites
2 minutes ago, pandrei said:

Just find in the same file the lines that looks like lines at the image.

Untitled.png

All right, thanks for your help I found it in list.log :

Stack trace:
#0 /home/XXX/public_html/XXX/admin/includes/functions/database.php(98): mysqli_query(Object(mysqli), 'insert into inf...')
#1 /home/XXX/public_html/XXX/admin/includes/functions/database.php(170): tep_db_query('insert into inf...', 'db_link')
#2 /home/XXX/public_html/XXX/lib/backend/controllers/LanguagesController.php(423): tep_db_perform('information', Array)
#3 [internal function]: backend\controllers\LanguagesController->actionSave()
#4 /home/XXX/public_html/XXX/lib/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#5 /home/XXX/public_html/XXX/lib/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams(Array)
#6 /home/XXX/public_html/XXX/lib/vendor/yiisoft/yii2/base/Module.php(552): yii\base\Controller->runAction('save', Array)
#7 /home/XXX/public_html/XXX/lib/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction('languages/save', Array)
#8 /home/XXX/public_html/XXX/lib/vendor/yiisoft/yii2/base/Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request))
#9 /home/XXX/public_html/XXX/lib/backend/web/index.php(29): yii\base\Application->run()
#10 /home/XXX/public_html/XXX/admin/index.php(15): require('/home/XXX/...')
#11 {main}

 

Share this post


Link to post
Share on other sites
7 hours ago, Diabolink said:

All right, thanks for your help I found it in list.log :

Thanks, but that is not enough.

1) We need the first line before stack. It starts from date and time like 2022-07-05 19:29:00 on my screenshot and includes the error message

2) We need full list.log file (you can send it as private message and replace all private info)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×