starred/ViMbAdmin-opensolutions
1
0
Fork 0
mirror of https://github.com/opensolutions/ViMbAdmin.git synced 2026-04-26 08:45:54 +03:00
Code Issues 16 Projects Releases 10 Packages Wiki Activity

[GH-ISSUE #61] "Semantical error" exception when accessing certain pages as admin #50

New issue
Closed
opened 2026-02-26 09:35:26 +03:00 by kerem · 1 comment
kerem commented 2026-02-26 09:35:26 +03:00
Owner
Copy link

Originally created by @ghost on GitHub (Mar 1, 2014).
Original GitHub issue: https://github.com/opensolutions/ViMbAdmin/issues/61

When accessing the Archives or Mailboxes view with a normal Admin account (NOT Super Admin), you will get an exception:

[Semantical Error] line 0, col 350 near 'Admin = ?1 AND': Error: Class Entities\Admin has no field or association named Admin
Development Platform Detected! Display errors enabled via application.ini. Disable in production!

0 /srv/www/mailadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(483): Doctrine\ORM\Query\QueryException::semanticalError('line 0, col 350...', Object(Doctrine\ORM\Query\QueryException))

1 /srv/www/mailadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(759): Doctrine\ORM\Query\Parser->semanticalError('Class Entities...', Array)

2 /srv/www/mailadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(279): Doctrine\ORM\Query\Parser->processDeferredPathExpressions(Object(Doctrine\ORM\Query\AST\SelectStatement))

3 /srv/www/mailadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(351): Doctrine\ORM\Query\Parser->getAST()

4 /srv/www/mailadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(266): Doctrine\ORM\Query\Parser->parse()

5 /srv/www/mailadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(278): Doctrine\ORM\Query->_parse()

6 /srv/www/mailadmin/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(967): Doctrine\ORM\Query->_doExecute()

7 /srv/www/mailadmin/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(922): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 2)

8 /srv/www/mailadmin/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(738): Doctrine\ORM\AbstractQuery->execute(NULL, 2)

9 /srv/www/mailadmin/application/Repositories/Mailbox.php(65): Doctrine\ORM\AbstractQuery->getArrayResult()

10 /srv/www/mailadmin/application/controllers/MailboxController.php(138): Repositories\Mailbox->loadForMailboxList(Object(Entities\Admin), Object(Entities\Domain))

11 /srv/www/mailadmin/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php(516): MailboxController->listAction()

12 /srv/www/mailadmin/vendor/zendframework/zendframework1/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('listAction')

13 /srv/www/mailadmin/vendor/zendframework/zendframework1/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))

14 /srv/www/mailadmin/vendor/zendframework/zendframework1/library/Zend/Application/Bootstrap/Bootstrap.php(101): Zend_Controller_Front->dispatch()

15 /srv/www/mailadmin/vendor/zendframework/zendframework1/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()

16 /srv/www/mailadmin/public/index.php(34): Zend_Application->run()

17 {main}

Looking at the referenced code usually reveals code like this:

        if( !$admin->isSuper() )
                $qb->join( 'mp.Mailbox', 'm' )
                    ->join( 'm.Domain', 'd' )
                    ->join( 'd.DomainToAdmin', 'd2a' )
                    ->where( 'd2a.Admin = ?1' )
                    ->setParameter( 1, $admin );

When comparing with views that do work with normal admin accounts, the only difference is the where clause, which is 'd2a = ?1' in views that do work, and 'd2a.Admin = ?1' in views that do throw the error. Removing the ".Admin" will fix the error. Though I am not experienced enough with the used frameworks to figure out whether or not that's safe.

Originally created by @ghost on GitHub (Mar 1, 2014). Original GitHub issue: https://github.com/opensolutions/ViMbAdmin/issues/61 When accessing the Archives or Mailboxes view with a normal Admin account (NOT Super Admin), you will get an exception: > [Semantical Error] line 0, col 350 near 'Admin = ?1 AND': Error: Class Entities\Admin has no field or association named Admin > Development Platform Detected! Display errors enabled via application.ini. Disable in production! > --- > # 0 /srv/www/mailadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(483): Doctrine\ORM\Query\QueryException::semanticalError('line 0, col 350...', Object(Doctrine\ORM\Query\QueryException)) > # 1 /srv/www/mailadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(759): Doctrine\ORM\Query\Parser->semanticalError('Class Entities...', Array) > # 2 /srv/www/mailadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(279): Doctrine\ORM\Query\Parser->processDeferredPathExpressions(Object(Doctrine\ORM\Query\AST\SelectStatement)) > # 3 /srv/www/mailadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(351): Doctrine\ORM\Query\Parser->getAST() > # 4 /srv/www/mailadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(266): Doctrine\ORM\Query\Parser->parse() > # 5 /srv/www/mailadmin/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(278): Doctrine\ORM\Query->_parse() > # 6 /srv/www/mailadmin/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(967): Doctrine\ORM\Query->_doExecute() > # 7 /srv/www/mailadmin/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(922): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 2) > # 8 /srv/www/mailadmin/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(738): Doctrine\ORM\AbstractQuery->execute(NULL, 2) > # 9 /srv/www/mailadmin/application/Repositories/Mailbox.php(65): Doctrine\ORM\AbstractQuery->getArrayResult() > # 10 /srv/www/mailadmin/application/controllers/MailboxController.php(138): Repositories\Mailbox->loadForMailboxList(Object(Entities\Admin), Object(Entities\Domain)) > # 11 /srv/www/mailadmin/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php(516): MailboxController->listAction() > # 12 /srv/www/mailadmin/vendor/zendframework/zendframework1/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('listAction') > # 13 /srv/www/mailadmin/vendor/zendframework/zendframework1/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http)) > # 14 /srv/www/mailadmin/vendor/zendframework/zendframework1/library/Zend/Application/Bootstrap/Bootstrap.php(101): Zend_Controller_Front->dispatch() > # 15 /srv/www/mailadmin/vendor/zendframework/zendframework1/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run() > # 16 /srv/www/mailadmin/public/index.php(34): Zend_Application->run() > # 17 {main} Looking at the referenced code usually reveals code like this: ``` if( !$admin->isSuper() ) $qb->join( 'mp.Mailbox', 'm' ) ->join( 'm.Domain', 'd' ) ->join( 'd.DomainToAdmin', 'd2a' ) ->where( 'd2a.Admin = ?1' ) ->setParameter( 1, $admin ); ``` When comparing with views that do work with normal admin accounts, the only difference is the where clause, which is 'd2a = ?1' in views that do work, and 'd2a.Admin = ?1' in views that do throw the error. Removing the ".Admin" will fix the error. Though I am not experienced enough with the used frameworks to figure out whether or not that's safe.
kerem closed this issue 2026-02-26 09:35:26 +03:00
kerem commented 2026-02-26 09:35:27 +03:00
Author
Owner
Copy link

@barryo commented on GitHub (Mar 3, 2014):

Removing the ".Admin" will fix the error.

It would indeed.

<!-- gh-comment-id:36505935 --> @barryo commented on GitHub (Mar 3, 2014): > Removing the ".Admin" will fix the error. It would indeed.
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
master
dependabot/composer/smarty/smarty-4.3.1
v2
3.4.1
3.4.0
3.3.0
3.2.1
3.2.0
3.1.1
3.1.0
3.0.15
3.0.14
3.0.13
3.0.12
3.0.11
2.2.4
3.0.10
3.0.9
3.0.8
3.0.7
3.0.6
3.0.5
3.0.4
3.0.3
3.0.2
3.0.1
3.0.0
2.2.3
2.2.2
2.2.1
2.2.0
2.1.0
2.0.8
2.0.7
2.0.6
2.0.5
2.0.4
2.0.3
2.0.2
2.0.1
2.0.0
0.3.4
0.3.3
0.3.2
0.3.1
0.3
Labels
Clear labels   
bug

   
feature

   
feature

   
improvement

   
improvement

   
pull-request

Mirrored from GitHub Pull Request

No labels
bug
feature
feature
improvement
improvement
pull-request
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/ViMbAdmin-opensolutions#50
No description provided.