SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias:

August 08, 2021, 04:17:48 AM

Hello,

I am trying to make a master/detail relation - but it fails with below error - how can i troubleshoot?

SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'recipe_ingrediens'

File
C:\wamp64\www\chocobase2\app\models\PDODb.php On Line 1045

Stack Trace
1 C:\wamp64\www\chocobase2\app\models\PDODb.php(1045): PDOStatement->execute()
2 C:\wamp64\www\chocobase2\app\models\PDODb.php(1079): PDODb->get('choco_recipe', 1, Array)
3 C:\wamp64\www\chocobase2\app\controllers\Choco_recipeController.php(117): PDODb->getOne('choco_recipe', Array)
4 C:\wamp64\www\chocobase2\system\Router.php(196): Choco_recipeController->view('1')
5 C:\wamp64\www\chocobase2\system\Router.php(109): Router->run('choco_recipe/view/1')
6 C:\wamp64\www\chocobase2\index.php(106): Router->init()

Re: SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias:

Reply #1 – August 10, 2021, 02:46:26 PM

Please take a look at this video (12) PHPRAD | View and List Page Master Details Relation - YouTube on how to configure Master Details Correctly.