Only maintenance mode after setup


#1

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


Testshop 6.0.0 CE - nur Maintenance mode / Wartungsarbeiten
#2

what database are you using?


#3

Server configuration:

  1. Apache 2.4
  2. PHP 7.1
  3. MySQL 8.0

#4


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


#5

Thanks, i will try it !


#6

Hi,

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


#7

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


#8

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!


#9

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


#10

Hi @zalnam,

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


#11

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


#12

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 :wink:


#13

Maybe some persmissions issue with the DB user.


#14


Hi,
Privileges i think is OK., DB after install is empty :frowning: Any help ?