https://wiki.partkeepr.org/api.php?action=feedcontributions&user=Apex&feedformat=atomPartKeepr Wiki - User contributions [en]2024-03-29T08:57:47ZUser contributionsMediaWiki 1.31.0https://wiki.partkeepr.org/index.php?title=Main_Page&diff=79Main Page2012-01-01T14:48:15Z<p>Apex: </p>
<hr />
<div>Welcome to the PartKeepr Wiki.<br />
<br />
Getting Started Guide: [[Getting Started]]<br />
<br />
How to update: [[How to update]]<br />
<br />
Read all tips: [[:Category:TipOfTheDay]]</div>Apexhttps://wiki.partkeepr.org/index.php?title=PartKeepr_0.1_issues&diff=74PartKeepr 0.1 issues2011-12-28T18:30:40Z<p>Apex: </p>
<hr />
<div>== Findings of partkeepr 0.1 on Ubuntu 10.4 LTS, PostgreSQL 8.4.9 ==<br />
''Author: apex''<br />
<br />
Just collecting, lets see which one will make it to the bug tracker<br />
<br />
<br />
* '''FIXED''': Installer lockup during Database Setup, see https://github.com/partkeepr/PartKeepr/issues/114<br />
* After Setting up Partkeeper, no parts are shown in the Parts List even after adding some. Plain SQL shows that the part table<br />
actually contains the expected entries. The parts are shown only after a restart of the browser (session/cache issue?)<br />
<br />
* When renaming categories, the contained parts categorypath is not updated leading to wrong grouping in the Parts List window<br />
(there may be other consequences, too)<br />
<br />
* '''Only applies to PostgreSQL 8.x''': View->Statistics->Summary gives an SQL Exception:<br />
SQLSTATE[42803]: Grouping error: 7 ERROR: column "p1_.name" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...LECT SUM(p0_.stockLevel) AS sclr0, p1_.id AS id1, p1_.name A... ^<br />
Backtrace:<br />
0 /usr/share/php/Doctrine/DBAL/Connection.php(618): PDO->query('SELECT SUM(p0_....') #1 /usr/share/php/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(46): Doctrine\DBAL\Connection->executeQuery('SELECT SUM(p0_....', Array, Array) #2 /usr/share/php/Doctrine/ORM/Query.php(249): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 /usr/share/php/Doctrine/ORM/AbstractQuery.php(607): Doctrine\ORM\Query->_doExecute() #4 /usr/share/php/Doctrine/ORM/AbstractQuery.php(413): Doctrine\ORM\AbstractQuery->execute(Array, 1) #5 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/PartUnit/PartUnitManager.php(103): Doctrine\ORM\AbstractQuery->getResult() #6 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/Statistic/StatisticService.php(22): de\RaumZeitLabor\PartKeepr\PartUnit\PartUnitManager->getUnitCounts() #7 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/Service/ServiceManager.php(79): de\RaumZeitLabor\PartKeepr\Statistic\StatisticService->getCurrentStats() #8 /var/www/partkeepr/frontend/rest.php(54): de\RaumZeitLabor\PartKeepr\Service\ServiceManager::call() #9 {main}<br />
<br />
* The attachted Footprint PDFs added the installer result in 0 byte files when trying to<br />
download them. This does not happen to files attached by myself.<br />
BTW: Why are there so many more footprints on the PartKeepr demo website?<br />
<br />
* It seems that innermost part categries can be deleted although they contain parts. The<br />
foreign key constraints on the database tables prevents PartKeepr of actually doing so<br />
but for the user the category seem to be gone (until he pushes the refresh button... :-))<br />
<br />
To be continued... :-)</div>Apexhttps://wiki.partkeepr.org/index.php?title=PartKeepr_0.1_issues&diff=73PartKeepr 0.1 issues2011-12-27T17:27:48Z<p>Apex: </p>
<hr />
<div>== Findings of partkeepr 0.1 on Ubuntu 10.4 LTS, PostgreSQL 8.4.9 ==<br />
''Author: apex''<br />
<br />
Just collecting, lets see which one will make it to the bug tracker<br />
<br />
<br />
* '''FIXED''': Installer lockup during Database Setup, see https://github.com/partkeepr/PartKeepr/issues/114<br />
* After Setting up Partkeeper, no parts are shown in the Parts List even after adding some. Plain SQL shows that the part table<br />
actually contains the expected entries. The parts are shown only after a restart of the browser (session/cache issue?)<br />
<br />
* When renaming categories, the contained parts categorypath is not updated leading to wrong grouping in the Parts List window<br />
(there may be other consequences, too)<br />
<br />
* View->Statistics->Summary gives an SQL Exception:<br />
SQLSTATE[42803]: Grouping error: 7 ERROR: column "p1_.name" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...LECT SUM(p0_.stockLevel) AS sclr0, p1_.id AS id1, p1_.name A... ^<br />
Backtrace:<br />
0 /usr/share/php/Doctrine/DBAL/Connection.php(618): PDO->query('SELECT SUM(p0_....') #1 /usr/share/php/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(46): Doctrine\DBAL\Connection->executeQuery('SELECT SUM(p0_....', Array, Array) #2 /usr/share/php/Doctrine/ORM/Query.php(249): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 /usr/share/php/Doctrine/ORM/AbstractQuery.php(607): Doctrine\ORM\Query->_doExecute() #4 /usr/share/php/Doctrine/ORM/AbstractQuery.php(413): Doctrine\ORM\AbstractQuery->execute(Array, 1) #5 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/PartUnit/PartUnitManager.php(103): Doctrine\ORM\AbstractQuery->getResult() #6 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/Statistic/StatisticService.php(22): de\RaumZeitLabor\PartKeepr\PartUnit\PartUnitManager->getUnitCounts() #7 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/Service/ServiceManager.php(79): de\RaumZeitLabor\PartKeepr\Statistic\StatisticService->getCurrentStats() #8 /var/www/partkeepr/frontend/rest.php(54): de\RaumZeitLabor\PartKeepr\Service\ServiceManager::call() #9 {main}<br />
<br />
* The attachted Footprint PDFs added the installer result in 0 byte files when trying to<br />
download them. This does not happen to files attached by myself.<br />
BTW: Why are there so many more footprints on the PartKeepr demo website?<br />
<br />
* It seems that innermost part categries can be deleted although they contain parts. The<br />
foreign key constraints on the database tables prevents PartKeepr of actually doing so<br />
but for the user the category seem to be gone (until he pushes the refresh button... :-))<br />
<br />
To be continued... :-)</div>Apexhttps://wiki.partkeepr.org/index.php?title=PartKeepr_0.1_issues&diff=72PartKeepr 0.1 issues2011-12-27T15:10:51Z<p>Apex: </p>
<hr />
<div>== Findings of partkeepr 0.1 on Ubuntu 10.4 LTS, PostgreSQL 8.4.9 ==<br />
''Author: apex''<br />
<br />
Just collecting, lets see which one will make it to the bug tracker<br />
<br />
<br />
* Installer lockup during Database Setup, see https://github.com/partkeepr/PartKeepr/issues/114<br />
* After Setting up Partkeeper, no parts are shown in the Parts List even after adding some. Plain SQL shows that the part table<br />
actually contains the expected entries. The parts are shown only after a restart of the browser (session/cache issue?)<br />
<br />
* When renaming categories, the contained parts categorypath is not updated leading to wrong grouping in the Parts List window<br />
(there may be other consequences, too)<br />
<br />
* View->Statistics->Summary gives an SQL Exception:<br />
SQLSTATE[42803]: Grouping error: 7 ERROR: column "p1_.name" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...LECT SUM(p0_.stockLevel) AS sclr0, p1_.id AS id1, p1_.name A... ^<br />
Backtrace:<br />
0 /usr/share/php/Doctrine/DBAL/Connection.php(618): PDO->query('SELECT SUM(p0_....') #1 /usr/share/php/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(46): Doctrine\DBAL\Connection->executeQuery('SELECT SUM(p0_....', Array, Array) #2 /usr/share/php/Doctrine/ORM/Query.php(249): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 /usr/share/php/Doctrine/ORM/AbstractQuery.php(607): Doctrine\ORM\Query->_doExecute() #4 /usr/share/php/Doctrine/ORM/AbstractQuery.php(413): Doctrine\ORM\AbstractQuery->execute(Array, 1) #5 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/PartUnit/PartUnitManager.php(103): Doctrine\ORM\AbstractQuery->getResult() #6 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/Statistic/StatisticService.php(22): de\RaumZeitLabor\PartKeepr\PartUnit\PartUnitManager->getUnitCounts() #7 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/Service/ServiceManager.php(79): de\RaumZeitLabor\PartKeepr\Statistic\StatisticService->getCurrentStats() #8 /var/www/partkeepr/frontend/rest.php(54): de\RaumZeitLabor\PartKeepr\Service\ServiceManager::call() #9 {main}<br />
<br />
* The attachted Footprint PDFs added the installer result in 0 byte files when trying to<br />
download them. This does not happen to files attached by myself.<br />
BTW: Why are there so many more footprints on the PartKeepr demo website?<br />
<br />
To be continued... :-)</div>Apexhttps://wiki.partkeepr.org/index.php?title=PartKeepr_0.1_issues&diff=71PartKeepr 0.1 issues2011-12-26T19:54:41Z<p>Apex: </p>
<hr />
<div>== Findings of partkeepr 0.1 on Ubuntu 10.4 LTS, PostgreSQL 8.4.9 ==<br />
''Author: apex''<br />
<br />
Just collecting, lets see which one will make it to the bug tracker<br />
<br />
<br />
* Installer lockup during Database Setup, see https://github.com/partkeepr/PartKeepr/issues/114<br />
* After Setting up Partkeeper, no parts are shown in the Parts List even after adding some. Plain SQL shows that the part table<br />
actually contains the expected entries. The parts are shown only after a restart of the browser (session/cache issue?)<br />
<br />
* When renaming categories, the contained parts categorypath is not updated leading to wrong grouping in the Parts List window<br />
(there may be other consequences, too)<br />
<br />
* View->Statistics->Summary gives an SQL Exception:<br />
SQLSTATE[42803]: Grouping error: 7 ERROR: column "p1_.name" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...LECT SUM(p0_.stockLevel) AS sclr0, p1_.id AS id1, p1_.name A... ^<br />
Backtrace:<br />
0 /usr/share/php/Doctrine/DBAL/Connection.php(618): PDO->query('SELECT SUM(p0_....') #1 /usr/share/php/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(46): Doctrine\DBAL\Connection->executeQuery('SELECT SUM(p0_....', Array, Array) #2 /usr/share/php/Doctrine/ORM/Query.php(249): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 /usr/share/php/Doctrine/ORM/AbstractQuery.php(607): Doctrine\ORM\Query->_doExecute() #4 /usr/share/php/Doctrine/ORM/AbstractQuery.php(413): Doctrine\ORM\AbstractQuery->execute(Array, 1) #5 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/PartUnit/PartUnitManager.php(103): Doctrine\ORM\AbstractQuery->getResult() #6 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/Statistic/StatisticService.php(22): de\RaumZeitLabor\PartKeepr\PartUnit\PartUnitManager->getUnitCounts() #7 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/Service/ServiceManager.php(79): de\RaumZeitLabor\PartKeepr\Statistic\StatisticService->getCurrentStats() #8 /var/www/partkeepr/frontend/rest.php(54): de\RaumZeitLabor\PartKeepr\Service\ServiceManager::call() #9 {main}<br />
<br />
* The attachted Footprint PDF files result in 0 byte files when trying to<br />
download them. <br />
BTW: Why are there so many more footprints on the partkeepr demo website <br />
<br />
<br />
To be continued... :-)</div>Apexhttps://wiki.partkeepr.org/index.php?title=PartKeepr_0.1_issues&diff=70PartKeepr 0.1 issues2011-12-26T19:50:17Z<p>Apex: </p>
<hr />
<div>== Findings of partkeepr 0.1 on Ubuntu 10.4 LTS, PostgreSQL 8.4.9 ==<br />
''Author: apex''<br />
<br />
Just collecting, lets see which one will make it to the bug tracker<br />
<br />
* Installer lockup during Database Setup, see https://github.com/partkeepr/PartKeepr/issues/114<br />
<br />
* After Setting up Partkeeper, no parts are shown in the Parts List even after adding some. Plain SQL shows that the part table<br />
actually contains the expected entries. The parts are shown only after a restart of the browser (session/cache issue?)<br />
<br />
<br />
* When renaming categories, the contained parts categorypath is not updated leading to wrong grouping in the Parts List window<br />
(there may be other consequences, too)<br />
<br />
<br />
* View->Statistics->Summary gives an SQL Exception:<br />
SQLSTATE[42803]: Grouping error: 7 ERROR: column "p1_.name" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...LECT SUM(p0_.stockLevel) AS sclr0, p1_.id AS id1, p1_.name A... ^<br />
Backtrace:<br />
0 /usr/share/php/Doctrine/DBAL/Connection.php(618): PDO->query('SELECT SUM(p0_....') #1 /usr/share/php/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(46): Doctrine\DBAL\Connection->executeQuery('SELECT SUM(p0_....', Array, Array) #2 /usr/share/php/Doctrine/ORM/Query.php(249): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 /usr/share/php/Doctrine/ORM/AbstractQuery.php(607): Doctrine\ORM\Query->_doExecute() #4 /usr/share/php/Doctrine/ORM/AbstractQuery.php(413): Doctrine\ORM\AbstractQuery->execute(Array, 1) #5 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/PartUnit/PartUnitManager.php(103): Doctrine\ORM\AbstractQuery->getResult() #6 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/Statistic/StatisticService.php(22): de\RaumZeitLabor\PartKeepr\PartUnit\PartUnitManager->getUnitCounts() #7 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/Service/ServiceManager.php(79): de\RaumZeitLabor\PartKeepr\Statistic\StatisticService->getCurrentStats() #8 /var/www/partkeepr/frontend/rest.php(54): de\RaumZeitLabor\PartKeepr\Service\ServiceManager::call() #9 {main}<br />
<br />
<br />
* The attachted Footprint PDF files result in 0 byte files when trying to<br />
download them. <br />
BTW: Why are there so many more footprints on the partkeepr demo website <br />
<br />
<br />
To be continued... :-)</div>Apexhttps://wiki.partkeepr.org/index.php?title=PartKeepr_0.1_issues&diff=69PartKeepr 0.1 issues2011-12-26T19:47:18Z<p>Apex: </p>
<hr />
<div>== Findings of partkeepr 0.1 on Ubuntu 10.4 LTS, PostgreSQL 8.4.9 ==<br />
''Author: apex''<br />
<br />
Just collecting, lets see which one will make it to the bug tracker<br />
<br />
<br />
* After Setting up Partkeeper, no parts are shown in the Parts List even after adding some. Plain SQL shows that the part table<br />
actually contains the expected entries. The parts are shown only after a restart of the browser (session/cache issue?)<br />
<br />
<br />
* When renaming categories, the contained parts categorypath is not updated leading to wrong grouping in the Parts List window<br />
(there may be other consequences, too)<br />
<br />
<br />
* View->Statistics->Summary gives an SQL Exception:<br />
SQLSTATE[42803]: Grouping error: 7 ERROR: column "p1_.name" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...LECT SUM(p0_.stockLevel) AS sclr0, p1_.id AS id1, p1_.name A... ^<br />
Backtrace:<br />
0 /usr/share/php/Doctrine/DBAL/Connection.php(618): PDO->query('SELECT SUM(p0_....') #1 /usr/share/php/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(46): Doctrine\DBAL\Connection->executeQuery('SELECT SUM(p0_....', Array, Array) #2 /usr/share/php/Doctrine/ORM/Query.php(249): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 /usr/share/php/Doctrine/ORM/AbstractQuery.php(607): Doctrine\ORM\Query->_doExecute() #4 /usr/share/php/Doctrine/ORM/AbstractQuery.php(413): Doctrine\ORM\AbstractQuery->execute(Array, 1) #5 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/PartUnit/PartUnitManager.php(103): Doctrine\ORM\AbstractQuery->getResult() #6 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/Statistic/StatisticService.php(22): de\RaumZeitLabor\PartKeepr\PartUnit\PartUnitManager->getUnitCounts() #7 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/Service/ServiceManager.php(79): de\RaumZeitLabor\PartKeepr\Statistic\StatisticService->getCurrentStats() #8 /var/www/partkeepr/frontend/rest.php(54): de\RaumZeitLabor\PartKeepr\Service\ServiceManager::call() #9 {main}<br />
<br />
<br />
* The attachted Footprint PDF files result in 0 byte files when trying to<br />
download them. <br />
BTW: Why are there so many more footprints on the partkeepr demo website <br />
<br />
<br />
To be continued... :-)</div>Apexhttps://wiki.partkeepr.org/index.php?title=PartKeepr_0.1_issues&diff=68PartKeepr 0.1 issues2011-12-26T19:43:26Z<p>Apex: </p>
<hr />
<div>Findings of partkeepr 0.1 on Ubuntu 10.4 LTS, PostgreSQL 8.4.9<br />
Author: apex<br />
<br />
Just collecting, lets see which one will make it to the bug tracker<br />
<br />
* After Setting up Partkeeper, no parts are shown in the Parts List even after adding some. Plain SQL shows that the part table<br />
actually contains the expected entries. The parts are shown only after a restart of the browser (session/cache issue?)<br />
<br />
<br />
* When renaming categories, the contained parts categorypath is not updated leading to wrong grouping in the Parts List window<br />
(there may be other consequences, too)<br />
<br />
<br />
* View->Statistics->Summary gives an SQL Exception:<br />
SQLSTATE[42803]: Grouping error: 7 ERROR: column "p1_.name" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...LECT SUM(p0_.stockLevel) AS sclr0, p1_.id AS id1, p1_.name A... ^<br />
Backtrace:<br />
0 /usr/share/php/Doctrine/DBAL/Connection.php(618): PDO->query('SELECT SUM(p0_....') #1 /usr/share/php/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(46): Doctrine\DBAL\Connection->executeQuery('SELECT SUM(p0_....', Array, Array) #2 /usr/share/php/Doctrine/ORM/Query.php(249): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 /usr/share/php/Doctrine/ORM/AbstractQuery.php(607): Doctrine\ORM\Query->_doExecute() #4 /usr/share/php/Doctrine/ORM/AbstractQuery.php(413): Doctrine\ORM\AbstractQuery->execute(Array, 1) #5 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/PartUnit/PartUnitManager.php(103): Doctrine\ORM\AbstractQuery->getResult() #6 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/Statistic/StatisticService.php(22): de\RaumZeitLabor\PartKeepr\PartUnit\PartUnitManager->getUnitCounts() #7 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/Service/ServiceManager.php(79): de\RaumZeitLabor\PartKeepr\Statistic\StatisticService->getCurrentStats() #8 /var/www/partkeepr/frontend/rest.php(54): de\RaumZeitLabor\PartKeepr\Service\ServiceManager::call() #9 {main}<br />
<br />
<br />
* The attachted Footprint PDF files result in 0 byte files when trying to<br />
download them. <br />
BTW: Why are there so many more footprints on the partkeepr demo website <br />
<br />
<br />
To be continued... :-)</div>Apexhttps://wiki.partkeepr.org/index.php?title=PartKeepr_0.1_issues&diff=67PartKeepr 0.1 issues2011-12-26T19:29:48Z<p>Apex: </p>
<hr />
<div>Findings of partkeepr 0.1 on Ubuntu 10.4 LTS, PostgreSQL 8.4.9<br />
<br />
<br />
* After Setting up Partkeeper, no parts are shown in the Parts List even after adding some. Plain SQL shows that the part table<br />
actually contains the expected entries. The parts are shown only after a restart of the browser (session/cache issue?)<br />
<br />
<br />
* When renaming categories, the contained parts categorypath is not updated leading to wrong grouping in the Parts List window<br />
(there may be other consequences, too)<br />
<br />
<br />
* View->Statistics->Summary gives an SQL Exception:<br />
SQLSTATE[42803]: Grouping error: 7 ERROR: column "p1_.name" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...LECT SUM(p0_.stockLevel) AS sclr0, p1_.id AS id1, p1_.name A... ^<br />
Backtrace:<br />
0 /usr/share/php/Doctrine/DBAL/Connection.php(618): PDO->query('SELECT SUM(p0_....') #1 /usr/share/php/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(46): Doctrine\DBAL\Connection->executeQuery('SELECT SUM(p0_....', Array, Array) #2 /usr/share/php/Doctrine/ORM/Query.php(249): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 /usr/share/php/Doctrine/ORM/AbstractQuery.php(607): Doctrine\ORM\Query->_doExecute() #4 /usr/share/php/Doctrine/ORM/AbstractQuery.php(413): Doctrine\ORM\AbstractQuery->execute(Array, 1) #5 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/PartUnit/PartUnitManager.php(103): Doctrine\ORM\AbstractQuery->getResult() #6 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/Statistic/StatisticService.php(22): de\RaumZeitLabor\PartKeepr\PartUnit\PartUnitManager->getUnitCounts() #7 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/Service/ServiceManager.php(79): de\RaumZeitLabor\PartKeepr\Statistic\StatisticService->getCurrentStats() #8 /var/www/partkeepr/frontend/rest.php(54): de\RaumZeitLabor\PartKeepr\Service\ServiceManager::call() #9 {main}<br />
<br />
<br />
* The attachted Footprint PDF files result in 0 byte files when trying to<br />
download them. <br />
BTW: Why are there so many more footprints on the partkeepr demo website <br />
<br />
<br />
To be continued... :-)</div>Apexhttps://wiki.partkeepr.org/index.php?title=PartKeepr_0.1_issues&diff=66PartKeepr 0.1 issues2011-12-26T19:25:37Z<p>Apex: Created page with "Findings of partkeepr 0.1 on Ubuntu 10.4 LTS, PostgreSQL 8.4.9 - After Setting up partkeeper, no parts are shown in the Parts List even after adding some. Plain SQL shows that t..."</p>
<hr />
<div>Findings of partkeepr 0.1 on Ubuntu 10.4 LTS, PostgreSQL 8.4.9<br />
<br />
- After Setting up partkeeper, no parts are shown in the Parts<br />
List even after adding some. Plain SQL shows that the part table<br />
actually contains the expected entries. The parts are shown only after a<br />
restart of the browser (session/cache issue?)<br />
<br />
- When renaming categories, the contained parts categorypath is not<br />
updated leading to wrong grouping in the Parts List window<br />
(there may be other consequences, too)<br />
<br />
-View->Statistics->Summary gives an SQL Exception:<br />
SQLSTATE[42803]: Grouping error: 7 ERROR: column "p1_.name" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...LECT SUM(p0_.stockLevel) AS sclr0, p1_.id AS id1, p1_.name A... ^<br />
Backtrace:<br />
#0 /usr/share/php/Doctrine/DBAL/Connection.php(618): PDO->query('SELECT SUM(p0_....') #1 /usr/share/php/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(46): Doctrine\DBAL\Connection->executeQuery('SELECT SUM(p0_....', Array, Array) #2 /usr/share/php/Doctrine/ORM/Query.php(249): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 /usr/share/php/Doctrine/ORM/AbstractQuery.php(607): Doctrine\ORM\Query->_doExecute() #4 /usr/share/php/Doctrine/ORM/AbstractQuery.php(413): Doctrine\ORM\AbstractQuery->execute(Array, 1) #5 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/PartUnit/PartUnitManager.php(103): Doctrine\ORM\AbstractQuery->getResult() #6 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/Statistic/StatisticService.php(22): de\RaumZeitLabor\PartKeepr\PartUnit\PartUnitManager->getUnitCounts() #7 /var/www/partkeepr/src/backend/de/RaumZeitLabor/PartKeepr/Service/ServiceManager.php(79): de\RaumZeitLabor\PartKeepr\Statistic\StatisticService->getCurrentStats() #8 /var/www/partkeepr/frontend/rest.php(54): de\RaumZeitLabor\PartKeepr\Service\ServiceManager::call() #9 {main}<br />
<br />
-The attachted Footprint PDF files result in 0 byte files when trying to<br />
download them. <br />
BTW: Why are there so many more footprints on the partkeepr demo website <br />
<br />
<br />
To be continued... :-)</div>Apexhttps://wiki.partkeepr.org/index.php?title=Main_Page&diff=65Main Page2011-12-26T19:24:53Z<p>Apex: </p>
<hr />
<div>Welcome to the PartKeepr Wiki.<br />
<br />
Getting Started Guide: [[Getting Started]]<br />
<br />
Read all tips: [[:Category:TipOfTheDay]]<br />
<br />
<br />
[[PartKeepr 0.1 issues]]</div>Apex