SQLSTATE[42000]: Syntax error or access violation: 1064 index joboffers: syntax error, unexpected '/' near '/ka do spraw administracji)|(asystent/ka ds administracji)|(asystent/ka administracji)|(Administrative Assistant)))(with portuguese language)' Jobs.pl - napotkano błąd

PDO ERROR


SELECT id, WEIGHT() as weight FROM `joboffers` WHERE MATCH('(((asystentka ds administracji)|(asystent/ka do spraw administracji)|(asystent/ka ds administracji)|(asystent/ka administracji)|(Administrative Assistant)))(with portuguese language)') ORDER BY is_jobg ASC, weight DESC LIMIT 0,3 OPTION field_weights=(location=1000, job_title=10000, content=1, employer=1000), max_matches=180000

ERROR:

TRACE:
#0 /home/admin/domains/jobs.pl/public_html/libs/Cube/PDO/Sphinx.php(74): PDO->query('SELECT id, WEIG...')
#1 /home/admin/domains/jobs.pl/public_html/libs/Cube/Sphinx/Sphinx.php(200): Cube_PDO_Sphinx->fetchAll('SELECT id, WEIG...')
#2 /home/admin/domains/jobs.pl/public_html/system/models/JobofferCurrentFrontend.php(500): Cube_Sphinx_Sphinx->findInMainIndex(Array, -1, '0,3', 0, Array, NULL)
#3 /home/admin/domains/jobs.pl/public_html/system/packages/Joboffer/CurrentController.php(744): JobofferCurrentFrontend->getOffers(Array, '0,3', NULL, 'Administrative ...')
#4 /home/admin/domains/jobs.pl/public_html/libs/Cube/Controller/Abstract.php(85): Joboffer_CurrentController->viewofferAction()
#5 /home/admin/domains/jobs.pl/public_html/libs/Cube/Controller/Front.php(128): Cube_Controller_Abstract->run('viewofferAction')
#6 /home/admin/domains/jobs.pl/public_html/index.php(207): Cube_Controller_Front->dispatch()
#7 {main}


powrót