Only maintenance mode after setup

zalnam · March 12, 2019, 9:56am

Hallo,

Have same problem with CE 6.12. installation. After fresh install - Maintenance mode, please try again later.
Exception log:
Community\Core\UtilsObject->oxNew(‘OxidEsales\Esho…’)
#10 D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\Oxid.php(24): oxNew(‘OxidEsales\Esho…’)
#11 D:\puslapiai\zneshop1\source\index.php(15): OxidEsales\EshopCommunity\Core\Oxid::run()
#12 {main}
[12 Mar 10:54:49.689640 2019] [exception] [type OxidEsales\Eshop\Core\Exception\DatabaseErrorException] [code 1305] [file D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\Database\Adapter\Doctrine\Database.php] [line 938] [message FUNCTION zneshop1.DECODE does not exist]
[12 Mar 10:54:49.689640 2019] [exception] [stacktrace] #0 D:\puslapiai\zneshop1\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\DriverException))
#1 D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\Module\ModuleVariablesLocator.php(130): OxidEsales\EshopCommunity\Core\Database\Adapter\Doctrine\Database->getOne(‘SELECT DECODE( …’, Array)
#2 D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\Module\ModuleVariablesLocator.php(60): OxidEsales\EshopCommunity\Core\Module\ModuleVariablesLocator->getModuleVarFromDB(‘aModules’)
#3 D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\Module\ModuleChainsGenerator.php(442): OxidEsales\EshopCommunity\Core\Module\ModuleVariablesLocator->getModuleVariable(‘aModules’)
#4 D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\Module\ModuleChainsGenerator.php(88): OxidEsales\EshopCommunity\Core\Module\ModuleChainsGenerator->getModulesArray(Object(OxidEsales\Eshop\Core\Module\ModuleVariablesLocator))
#5 D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\Module\ModuleChainsGenerator.php(64): OxidEsales\EshopCommunity\Core\Module\ModuleChainsGenerator->getFullChain(‘OxidEsales\Esho…’, ‘oxshopcontrol’)
#6 D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\Module\ModuleChainsGenerator.php(43): OxidEsales\EshopCommunity\Core\Module\ModuleChainsGenerator->getActiveChain(‘OxidEsales\Esho…’, ‘oxshopcontrol’)
#7 D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\UtilsObject.php(269): OxidEsales\EshopCommunity\Core\Module\ModuleChainsGenerator->createClassChain(‘OxidEsales\Esho…’, ‘oxshopcontrol’)
#8 D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\UtilsObject.php(219): OxidEsales\EshopCommunity\Core\UtilsObject->getClassName(‘oxshopcontrol’)
#9 D:\puslapiai\zneshop1\source\oxfunctions.php(101): OxidEsales\EshopCommunity\Core\UtilsObject->oxNew(‘OxidEsales\Esho…’)
#10 D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\Oxid.php(24): oxNew(‘OxidEsales\Esho…’)
#11 D:\puslapiai\zneshop1\source\index.php(15): OxidEsales\EshopCommunity\Core\Oxid::run()
#12 {main}
[12 Mar 10:54:59.967154 2019] [exception] [type OxidEsales\Eshop\Core\Exception\DatabaseErrorException] [code 1305] [file D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\Database\Adapter\Doctrine\Database.php] [line 938] [message FUNCTION zneshop1.DECODE does not exist]
[12 Mar 10:54:59.967154 2019] [exception] [stacktrace] #0 D:\puslapiai\zneshop1\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\DriverException))
#1 D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\Module\ModuleVariablesLocator.php(130): OxidEsales\EshopCommunity\Core\Database\Adapter\Doctrine\Database->getOne(‘SELECT DECODE( …’, Array)
#2 D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\Module\ModuleVariablesLocator.php(60): OxidEsales\EshopCommunity\Core\Module\ModuleVariablesLocator->getModuleVarFromDB(‘aModules’)
#3 D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\Module\ModuleChainsGenerator.php(442): OxidEsales\EshopCommunity\Core\Module\ModuleVariablesLocator->getModuleVariable(‘aModules’)
#4 D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\Module\ModuleChainsGenerator.php(88): OxidEsales\EshopCommunity\Core\Module\ModuleChainsGenerator->getModulesArray(Object(OxidEsales\Eshop\Core\Module\ModuleVariablesLocator))
#5 D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\Module\ModuleChainsGenerator.php(64): OxidEsales\EshopCommunity\Core\Module\ModuleChainsGenerator->getFullChain(‘OxidEsales\Esho…’, ‘oxshopcontrol’)
#6 D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\Module\ModuleChainsGenerator.php(43): OxidEsales\EshopCommunity\Core\Module\ModuleChainsGenerator->getActiveChain(‘OxidEsales\Esho…’, ‘oxshopcontrol’)
#7 D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\UtilsObject.php(269): OxidEsales\EshopCommunity\Core\Module\ModuleChainsGenerator->createClassChain(‘OxidEsales\Esho…’, ‘oxshopcontrol’)
#8 D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\UtilsObject.php(219): OxidEsales\EshopCommunity\Core\UtilsObject->getClassName(‘oxshopcontrol’)
#9 D:\puslapiai\zneshop1\source\oxfunctions.php(101): OxidEsales\EshopCommunity\Core\UtilsObject->oxNew(‘OxidEsales\Esho…’)
#10 D:\puslapiai\zneshop1\vendor\oxid-esales\oxideshop-ce\source\Core\Oxid.php(24): oxNew(‘OxidEsales\Esho…’)
#11 D:\puslapiai\zneshop1\source\index.php(15): OxidEsales\EshopCommunity\Core\Oxid::run()
#12 {main}
Any help ?

Vaidas

vanilla_thunder · March 12, 2019, 10:23am

what database are you using?

zalnam · March 12, 2019, 10:29am

Server configuration:

Apache 2.4
PHP 7.1
MySQL 8.0

vanilla_thunder · March 12, 2019, 10:54am

while there are AES_ENCRYPT() and AES_DECRYPT() functions for removed DECODE() and ENCODE(), i guess there will be other problems with new mysql version, since its not supported at all

zalnam · March 12, 2019, 2:23pm

Thanks, i will try it !

zalnam · March 13, 2019, 9:15am

Hi,

After intall MySQL Server 5.7, the problem is the same: Maintenance mode, please try again later.
Where can be problem ?

vanilla_thunder · March 13, 2019, 9:22am

make sure oxid is connecting to 5.7 instance and not 8.0.
in the versions before 6 OXID did not support other mysql ports than default, right now i have no idea if current oxid supports custom mysql ports during installation, but you should check the port number of 5.7 instance and try passing it with server ip.
If it does not work, try changing ports fpr your instances, so 5.7 will listen do default port, which might be currently used by the 8.0 instance

zalnam · March 13, 2019, 12:18pm

After install without demo data and set $this->blSkipViewUsage = true; , eshop run. Now i can’t log as administrator: Error! Incorrect username and/or password!

zalnam · March 14, 2019, 12:52pm

After install with demo data, i have DB zneshop, but empty. Where can be problem ?

marco.steinhaeuser · March 14, 2019, 1:39pm

Hi @zalnam,

try resetting the password. I could imagine that MySQL 8 uses different hashing mechanisms.

zalnam · March 14, 2019, 2:00pm

Hi Marco,
But wy oxuser table after install is empty ?

marco.steinhaeuser · March 14, 2019, 5:32pm

Maybe DB was not copied properly…
BTW: I made a new Thread out of your request. It is appreciated to stick to one language in a thread

leofonic · March 14, 2019, 6:43pm

Maybe some persmissions issue with the DB user.

zalnam · March 19, 2019, 12:37pm

Hi,
Privileges i think is OK., DB after install is empty

Any help ?