I tried to grant a user a license here on oxwall and received the following error:
Message:SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'itemId' cannot be nullFile:/ow_core/database.phpLine:311Trace:#0 /ow_core/database.php(311): PDOStatement->execute()
#1 /ow_core/database.php(420): OW_Database->execute('INSERT INTO `15...', Array)
#2 /ow_core/database.php(457): OW_Database->insert('INSERT INTO `15...', Array)
#3 /ow_core/base_dao.php(209): OW_Database->insertObject('15091_store_ite...', Object(STORE_BOL_ItemPurchase))
#4 /ow_plugins/store/bol/item_service.php(795): OW_BaseDao->save(Object(STORE_BOL_ItemPurchase))
#5 /ow_plugins/store/bol/item_service.php(817): STORE_BOL_ItemService->grantItem(1621, 80, '1')
#6 /ow_plugins/store/components/grant_item.php(25): STORE_BOL_ItemService->grantItems(1621, Array, Array)
#7 [internal function]: STORE_CMP_GrantItem->__construct(Array)
#8 [internal function]: ReflectionClass->newInstance(Array)
#9 /ow_system_plugins/base/components/profile_action_toolbar.php(89): call_user_func_array(Array, Array)
#10 /ow_system_plugins/base/controllers/component_panel.php(305): BASE_CMP_ProfileActionToolbar->__construct('1621')
#11 [internal function]: BASE_CTRL_ComponentPanel->profile(Array)
#12 /ow_core/dispatcher.php(257): ReflectionMethod->invokeArgs(Object(BASE_CTRL_ComponentPanel), Array)
#13 /ow_core/application.php(293): OW_Dispatcher->dispatch()
#14 /index.php(65): OW_Application->dispatch()
#15 {main}Type:PDOException
We build. You grow.
Get best community software hereStart a social network, a fan-site, an education project with oxwall - free opensource community software
Grant Licenses on oxwall | Forum
Team
Team
Team
Honsa
Jan 4 '12
Yes this error is not coming again.
by the way, why I am not able to "de"-grant licenses? Also you may have to optimize the exceptions
User has been granted -1.0E+63 licenses
edit: also it would be nice if I can get a list of all used licenses, because at time of the error I granted someone 999999 licenses and other values ;)
by the way, why I am not able to "de"-grant licenses? Also you may have to optimize the exceptions
User has been granted -1.0E+63 licenses
edit: also it would be nice if I can get a list of all used licenses, because at time of the error I granted someone 999999 licenses and other values ;)
The Forum post is edited by Honsa Jan 4 '12
Team
Honsa
Jan 4 '12
ok, I granted myself 999999 licenses and now i get a memory error if I want to view my licenses, oxwall.org was not reachable too for a short while ;)
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 77 bytes) in /ow_core/database.php on line 380
edit: I guess your dev team is working on it
OW Debug - ExceptionMessage:SQLSTATE[HY000]: General error: 145 Table '.[]store_item_purchase' is marked as crashed and should be repairedFile:/ow_core/database.phpLine:311Trace:#0 /ow_core/database.php(311): PDOStatement->execute() #1 /ow_core/database.php(378): OW_Database->execute('SELECT `p`.*, `...', Array) #2 /ow_plugins/store/bol/item_purchase_dao.php(89): OW_Database->queryForList('SELECT `p`.*, `...', Array) #3 /ow_plugins/store/bol/item_service.php(732): STORE_BOL_ItemPurchaseDao->findPurchaseListByUserId(1763) #4 /ow_plugins/store/controllers/buy_item.php(184): STORE_BOL_ItemService->getUserPurchaseList(1763) #5 [internal function]: STORE_CTRL_BuyItem->grantedList(Array) #6 /ow_core/dispatcher.php(257): ReflectionMethod->invokeArgs(Object(STORE_CTRL_BuyItem), Array) #7 /ow_core/application.php(293): OW_Dispatcher->dispatch() #8 /index.php(65): OW_Application->dispatch() #9 {main}Type:PDOException
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 77 bytes) in /ow_core/database.php on line 380
edit: I guess your dev team is working on it
OW Debug - ExceptionMessage:SQLSTATE[HY000]: General error: 145 Table '.[]store_item_purchase' is marked as crashed and should be repairedFile:/ow_core/database.phpLine:311Trace:#0 /ow_core/database.php(311): PDOStatement->execute() #1 /ow_core/database.php(378): OW_Database->execute('SELECT `p`.*, `...', Array) #2 /ow_plugins/store/bol/item_purchase_dao.php(89): OW_Database->queryForList('SELECT `p`.*, `...', Array) #3 /ow_plugins/store/bol/item_service.php(732): STORE_BOL_ItemPurchaseDao->findPurchaseListByUserId(1763) #4 /ow_plugins/store/controllers/buy_item.php(184): STORE_BOL_ItemService->getUserPurchaseList(1763) #5 [internal function]: STORE_CTRL_BuyItem->grantedList(Array) #6 /ow_core/dispatcher.php(257): ReflectionMethod->invokeArgs(Object(STORE_CTRL_BuyItem), Array) #7 /ow_core/application.php(293): OW_Dispatcher->dispatch() #8 /index.php(65): OW_Application->dispatch() #9 {main}Type:PDOException
The Forum post is edited by Oxwall Software Jan 4 '12
Team