Hi there, very new to OXID and trying to install on Siteground!
After step 5 in the web setup I instantly get a 500 - Internal Server Error and never get to step 6
If I browse to domain I get Maintenance mode, please try again later.
Please help?
Hi there, very new to OXID and trying to install on Siteground!
After step 5 in the web setup I instantly get a 500 - Internal Server Error and never get to step 6
If I browse to domain I get Maintenance mode, please try again later.
Please help?
Hi @tech2you and welcome to this forum!
Do you find any more detailed information in the server or DB logs? Actually, in this step some database scripts are triggered. Maybe there are some issues with your web hosting provider/the package you use. Maybe insufficient rights or something?
If you tried to install OXID 4.10 from github repository, this happens because it’s missing demo data sql file. You have to get the zip file from oxidforge.org
I am trying to install version 6.1.4 using Composer
There are some errors repeated in source/log/oxideshop.log:
LATEST ERROR:
[2019-09-04 15:12:54] OXID Logger.ERROR: An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user ‘letmesho_oxid’@‘localhost’ (using password: YES) ["[object] (OxidEsales\Eshop\Core\Exception\DatabaseConnectionException(code: 0): An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user ‘letmesho_oxid’@‘localhost’ (using password: YES) at /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php:938, Doctrine\DBAL\Exception\ConnectionException(code: 0): An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user ‘letmesho_oxid’@‘localhost’ (using password: YES) at /home/letmesho/public_html/oxid/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:103, Doctrine\DBAL\Driver\PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user ‘letmesho_oxid’@‘localhost’ (using password: YES) at /home/letmesho/public_html/oxid/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47, PDOException(code: 1045): SQLSTATE[HY000] [1045] Access denied for user ‘letmesho_oxid’@‘localhost’ (using password: YES) at /home/letmesho/public_html/oxid/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43)\n[stacktrace]\n#0 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php(112): OxidEsales\EshopCommunity\Core\Database\Adapter\Doctrine\Database->convertException(Object(Doctrine\DBAL\Exception\ConnectionException))\n#1 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/DatabaseProvider.php(198): OxidEsales\EshopCommunity\Core\Database\Adapter\Doctrine\Database->connect()\n#2 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/DatabaseProvider.php(96): OxidEsales\EshopCommunity\Core\DatabaseProvider->createDatabase()\n#3 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/Config.php(537): OxidEsales\EshopCommunity\Core\DatabaseProvider::getDb()\n#4 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/Config.php(382): OxidEsales\EshopCommunity\Core\Config->_loadVarsFromDb(1)\n#5 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(554): OxidEsales\EshopCommunity\Core\Config->init()\n#6 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(131): OxidEsales\EshopCommunity\Core\ShopControl->_runOnce()\n#7 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/Oxid.php(26): OxidEsales\EshopCommunity\Core\ShopControl->start()\n#8 /home/letmesho/public_html/oxid/source/index.php(15): OxidEsales\EshopCommunity\Core\Oxid::run()\n#9 {main}\n"] []
ANOTHER
[2019-09-04 14:27:08] OXID Logger.ERROR: Table ‘letmesho_oxid.oxv_oxshops_en’ doesn’t exist ["[object] (OxidEsales\Eshop\Core\Exception\DatabaseErrorException(code: 1146): Table ‘letmesho_oxid.oxv_oxshops_en’ doesn’t exist at /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php:938, Doctrine\DBAL\Exception\TableNotFoundException(code: 0): An exception occurred while executing ‘select oxv_oxshops_en
.oxid
, oxv_oxshops_en
.oxactive
, oxv_oxshops_en
.oxproductive
, oxv_oxshops_en
.oxdefcurrency
, oxv_oxshops_en
.oxdeflanguage
, oxv_oxshops_en
.oxname
, oxv_oxshops_en
.oxtitleprefix
, oxv_oxshops_en
.oxtitlesuffix
, oxv_oxshops_en
.oxstarttitle
, oxv_oxshops_en
.oxinfoemail
, oxv_oxshops_en
.oxorderemail
, oxv_oxshops_en
.oxowneremail
, oxv_oxshops_en
.oxordersubject
, oxv_oxshops_en
.oxregistersubject
, oxv_oxshops_en
.oxforgotpwdsubject
, oxv_oxshops_en
.oxsendednowsubject
, oxv_oxshops_en
.oxsmtp
, oxv_oxshops_en
.oxsmtpuser
, oxv_oxshops_en
.oxsmtppwd
, oxv_oxshops_en
.oxcompany
, oxv_oxshops_en
.oxstreet
, oxv_oxshops_en
.oxzip
, oxv_oxshops_en
.oxcity
, oxv_oxshops_en
.oxcountry
, oxv_oxshops_en
.oxbankname
, oxv_oxshops_en
.oxbanknumber
, oxv_oxshops_en
.oxbankcode
, oxv_oxshops_en
.oxvatnumber
, oxv_oxshops_en
.oxtaxnumber
, oxv_oxshops_en
.oxbiccode
, oxv_oxshops_en
.oxibannumber
, oxv_oxshops_en
.oxfname
, oxv_oxshops_en
.oxlname
, oxv_oxshops_en
.oxtelefon
, oxv_oxshops_en
.oxtelefax
, oxv_oxshops_en
.oxurl
, oxv_oxshops_en
.oxdefcat
, oxv_oxshops_en
.oxhrbnr
, oxv_oxshops_en
.oxcourt
, oxv_oxshops_en
.oxadbutlerid
, oxv_oxshops_en
.oxaffilinetid
, oxv_oxshops_en
.oxsuperclicksid
, oxv_oxshops_en
.oxaffiliweltid
, oxv_oxshops_en
.oxaffili24id
, oxv_oxshops_en
.oxedition
, oxv_oxshops_en
.oxversion
, oxv_oxshops_en
.oxseoactive
, oxv_oxshops_en
.oxtimestamp
from oxv_oxshops_en where 1 and oxv_oxshops_en.oxid = ‘1’’:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table ‘letmesho_oxid.oxv_oxshops_en’ doesn’t exist at /home/letmesho/public_html/oxid/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:53, Doctrine\DBAL\Driver\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘letmesho_oxid.oxv_oxshops_en’ doesn’t exist at /home/letmesho/public_html/oxid/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘letmesho_oxid.oxv_oxshops_en’ doesn’t exist at /home/letmesho/public_html/oxid/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104)\n[stacktrace]\n#0 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php(621): OxidEsales\EshopCommunity\Core\Database\Adapter\Doctrine\Database->convertException(Object(Doctrine\DBAL\Exception\TableNotFoundException))\n#1 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/Model/BaseModel.php(736): OxidEsales\EshopCommunity\Core\Database\Adapter\Doctrine\Database->select(‘select oxv_oxs...')\n#2 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/Model/BaseModel.php(717): OxidEsales\\EshopCommunity\\Core\\Model\\BaseModel->getRecordByQuery('select
oxv_oxs…’)\n#3 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/Model/BaseModel.php(669): OxidEsales\EshopCommunity\Core\Model\BaseModel->assignRecord(‘select `oxv_oxs…’)\n#4 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/Config.php(1966): OxidEsales\EshopCommunity\Core\Model\BaseModel->load(1)\n#5 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/Utils.php(976): OxidEsales\EshopCommunity\Core\Config->getActiveShop()\n#6 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Application/Controller/FrontendController.php(491): OxidEsales\EshopCommunity\Core\Utils->seoIsActive()\n#7 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Application/Controller/FrontendController.php(521): OxidEsales\EshopCommunity\Application\Controller\FrontendController->_processRequest()\n#8 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(382): OxidEsales\EshopCommunity\Application\Controller\FrontendController->init()\n#9 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(272): OxidEsales\EshopCommunity\Core\ShopControl->_initializeViewObject(‘OxidEsales\\Esho…’, NULL, NULL, NULL)\n#10 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(137): OxidEsales\EshopCommunity\Core\ShopControl->_process(‘OxidEsales\\Esho…’, NULL, NULL, NULL)\n#11 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/Oxid.php(26): OxidEsales\EshopCommunity\Core\ShopControl->start()\n#12 /home/letmesho/public_html/oxid/source/index.php(15): OxidEsales\EshopCommunity\Core\Oxid::run()\n#13 {main}\n"] []
ANOTHER
[2019-09-04 15:04:20] OXID Logger.ERROR: Table ‘letmesho_oxid.oxv_oxcategories_en’ doesn’t exist ["[object] (OxidEsales\Eshop\Core\Exception\DatabaseErrorException(code: 1146): Table ‘letmesho_oxid.oxv_oxcategories_en’ doesn’t exist at /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php:938, Doctrine\DBAL\Exception\TableNotFoundException(code: 0): An exception occurred while executing ‘show columns from oxv_oxcategories_en where field = ‘oxseoid’’:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table ‘letmesho_oxid.oxv_oxcategories_en’ doesn’t exist at /home/letmesho/public_html/oxid/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:53, Doctrine\DBAL\Driver\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘letmesho_oxid.oxv_oxcategories_en’ doesn’t exist at /home/letmesho/public_html/oxid/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘letmesho_oxid.oxv_oxcategories_en’ doesn’t exist at /home/letmesho/public_html/oxid/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104)\n[stacktrace]\n#0 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php(304): OxidEsales\EshopCommunity\Core\Database\Adapter\Doctrine\Database->convertException(Object(Doctrine\DBAL\Exception\TableNotFoundException))\n#1 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/SeoDecoder.php(272): OxidEsales\EshopCommunity\Core\Database\Adapter\Doctrine\Database->getOne(‘show columns fr…’)\n#2 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/SeoDecoder.php(243): OxidEsales\EshopCommunity\Core\SeoDecoder->_getObjectUrl(‘backend’, ‘oxv_oxcategorie…’, 1, ‘oxcategory’)\n#3 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/SeoDecoder.php(206): OxidEsales\EshopCommunity\Core\SeoDecoder->_decodeSimpleUrl(‘backend/’)\n#4 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/Config.php(358): OxidEsales\EshopCommunity\Core\SeoDecoder->processSeoCall()\n#5 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/Config.php(449): OxidEsales\EshopCommunity\Core\Config->_processSeoCall()\n#6 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/Config.php(407): OxidEsales\EshopCommunity\Core\Config->initializeShop()\n#7 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(554): OxidEsales\EshopCommunity\Core\Config->init()\n#8 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(131): OxidEsales\EshopCommunity\Core\ShopControl->_runOnce()\n#9 /home/letmesho/public_html/oxid/vendor/oxid-esales/oxideshop-ce/source/Core/Oxid.php(26): OxidEsales\EshopCommunity\Core\ShopControl->start()\n#10 /home/letmesho/public_html/oxid/source/index.php(15): OxidEsales\EshopCommunity\Core\Oxid::run()\n#11 /home/letmesho/public_html/oxid/source/oxseo.php(28): require(’/home/letmesho/…’)\n#12 {main}\n"] []
I can be wrong, but i think the user needs grant privileges.
Anyway needs OXID 6 PHP 7.0+
Ok I was looking at the php version phpMyAdmin is running on! OXID is actually running on
Indeed, you would need PHP 7.0 or 7.1 on the CLI (not web server!) for setting up OXID eShop 6.1.4.
Could you please check in phpMyAdmin if your database is filled with demo data or similar entries or if it is completely empty? If empty, please check this article: https://www.siteground.com/kb/i_have_problems_setting_up_the_mysql_database_for_my_applica/. If filled it seems to be another problem.
Ok I had reinstalled yesterday WITHOUT demo data, I have re-run setup WITH demo data.
There is data there now but still crashes after Step 5:
Provoke a 500 internal again and then look up in cpanel error logs what happened. Maybe the application crashes before it can write the error.
Didn’t expect that dude, as you approved before that you have the rights to create views…
Show your config.inc.php