Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
group by metabolite.id' at line 6 in D:\biodeepdb_www\biodeepdb_v3_web\framework\php.NET\Framework\MVC\MySql\driver.php:190
Stack trace:
#0 D:\biodeepdb_www\biodeepdb_v3_web\framework\php.NET\Framework\MVC\MySql\driver.php(190): mysqli_query(Object(mysqli), 'SELECT metaboli...')
#1 D:\biodeepdb_www\biodeepdb_v3_web\framework\php.NET\Framework\Debugger\Ubench\Ubench.php(119): MVC\MySql\MySqlExecDriver->MVC\MySql\{closure}()
#2 D:\biodeepdb_www\biodeepdb_v3_web\framework\php.NET\Framework\MVC\MySql\driver.php(189): Ubench->run(Object(Closure))
#3 D:\biodeepdb_www\biodeepdb_v3_web\scripts\show\show_page.php(79): MVC\MySql\MySqlExecDriver->Fetch('SELECT metaboli...')
#4 D:\biodeepdb_www\biodeepdb_v3_web\scripts\show\show_page.php(117): show_page::biodeep_idset_sql('1729, 2971, 322...')
#5 D:\biodeepdb_www\biodeepdb_v3_web\src\index.php(178): show_page::get_data('PathBank%3ASMP0...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 500)
#6 [internal function]: App->show('PathBank%3ASMP0...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 500)
#7 D:\biodeepdb_www\biodeepdb_v3_web\framework\php.NET\Framework\MVC\handler\appCaller.php(50): ReflectionMethod->invokeArgs(Object(App), Array)
#8 D:\biodeepdb_www\biodeepdb_v3_web\framework\php.NET\Framework\MVC\handler\appCaller.php(18): MVC\Controller\appCaller::CallWithPayload(Object(App), 'show', Object(WebRequest), true)
#9 D:\biodeepdb_www\biodeepdb_v3_web\framework\php.NET\Framework\MVC\controller.php(417): MVC\Controller\appCaller::doCall(Object(App), 'show', true)
#10 D:\biodeepdb_www\biodeepdb_v3_web\framework\php.NET\Framework\Debugger\Ubench\Ubench.php(119): controller->{closure}(Object(AccessController))
#11 D:\biodeepdb_www\biodeepdb_v3_web\framework\php.NET\Framework\MVC\controller.php(415): Ubench->run(Object(Closure), Object(AccessController))
#12 D:\biodeepdb_www\biodeepdb_v3_web\framework\php.NET\Framework\dotnet.php(124): controller->handleRequest()
#13 D:\biodeepdb_www\biodeepdb_v3_web\.etc\bootstrap.php(36): dotnet::HandleRequest(Object(App), Object(AccessController))
#14 D:\biodeepdb_www\biodeepdb_v3_web\src\index.php(3): include('D:\\biodeepdb_ww...')
#15 {main}
Next Exception: sql_query: SELECT metabolite.id as biodeep_id,name, formula, exact_mass, iupac_name,`description`,
group_concat(distinct smiles.struct_data separator '; ') as smiles
FROM biodeepdb_full.metabolite
left join molecular_structures smiles on (smiles.biodeep_id = metabolite.id AND smiles.type = (
SELECT id from biodeep_vocabulary where vocabulary = 'smiles' limit 1))
where metabolite.id in (1729, 2971, 3224, 3343, 3516, 14766, 69652, 108503, 109000, )
group by metabolite.id
in D:\biodeepdb_www\biodeepdb_v3_web\framework\php.NET\Framework\MVC\MySql\driver.php:193
Stack trace:
#0 D:\biodeepdb_www\biodeepdb_v3_web\scripts\show\show_page.php(79): MVC\MySql\MySqlExecDriver->Fetch('SELECT metaboli...')
#1 D:\biodeepdb_www\biodeepdb_v3_web\scripts\show\show_page.php(117): show_page::biodeep_idset_sql('1729, 2971, 322...')
#2 D:\biodeepdb_www\biodeepdb_v3_web\src\index.php(178): show_page::get_data('PathBank%3ASMP0...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 500)
#3 [internal function]: App->show('PathBank%3ASMP0...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 500)
#4 D:\biodeepdb_www\biodeepdb_v3_web\framework\php.NET\Framework\MVC\handler\appCaller.php(50): ReflectionMethod->invokeArgs(Object(App), Array)
#5 D:\biodeepdb_www\biodeepdb_v3_web\framework\php.NET\Framework\MVC\handler\appCaller.php(18): MVC\Controller\appCaller::CallWithPayload(Object(App), 'show', Object(WebRequest), true)
#6 D:\biodeepdb_www\biodeepdb_v3_web\framework\php.NET\Framework\MVC\controller.php(417): MVC\Controller\appCaller::doCall(Object(App), 'show', true)
#7 D:\biodeepdb_www\biodeepdb_v3_web\framework\php.NET\Framework\Debugger\Ubench\Ubench.php(119): controller->{closure}(Object(AccessController))
#8 D:\biodeepdb_www\biodeepdb_v3_web\framework\php.NET\Framework\MVC\controller.php(415): Ubench->run(Object(Closure), Object(AccessController))
#9 D:\biodeepdb_www\biodeepdb_v3_web\framework\php.NET\Framework\dotnet.php(124): controller->handleRequest()
#10 D:\biodeepdb_www\biodeepdb_v3_web\.etc\bootstrap.php(36): dotnet::HandleRequest(Object(App), Object(AccessController))
#11 D:\biodeepdb_www\biodeepdb_v3_web\src\index.php(3): include('D:\\biodeepdb_ww...')
#12 {main}
thrown in D:\biodeepdb_www\biodeepdb_v3_web\framework\php.NET\Framework\MVC\MySql\driver.php on line 193