An internal server error occurred.

[Diabolink]

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...)

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' => '[email protected]'
    '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 July 29, 2022 by Diabolink

[osCommerce-Official]

Thanks for reporting this! 

Could you please check and send us stacktrace, it may help us to identify the issue. Thank again!

[Diabolink]

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

I will try and report. 

[osCommerce-Official]

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. 

[pandrei]

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.

[Diabolink]

2 minutes ago, pandrei said:

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

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}

 

[pandrei]

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)