I'm having the same issue.
Installed from the bitnami OS X installer
Code:
ERROR: "0" (code N/A)
An exception occurred while executing 'SELECT t0.id AS id_1, t0.cleanURL AS cleanURL_2, t0.page_id AS page_id_3, t0.news_message_id AS news_message_id_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM xc_clean_urls t0 WHERE t0.category_id = ? ORDER BY t0.id ASC' with params [1]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_xcart.xc_clean_urls' doesn't exist
[10-Jan-2017 14:32:54] Error (code: 0): An exception occurred while executing 'SELECT t0.id AS id_1, t0.cleanURL AS cleanURL_2, t0.page_id AS page_id_3, t0.news_message_id AS news_message_id_4, t0.product_id AS product_id_5, t0.category_id AS category_id_6 FROM xc_clean_urls t0 WHERE t0.category_id = ? ORDER BY t0.id ASC' with params [1]:
From the php_error.log
Code:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bitnami_xcart.xc_clean_urls' doesn't exist
Server API: apache2handler;
Request method: GET;
URI: /;
Backtrace:
#0 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(116): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))
#1 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(XLite\Core\PDOMySqlDriver), Object(Doctrine\DBAL\Driver\PDOException), 'SELECT t0.id AS...', Array)
#2 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/var/run/classes/XLite/Core/Connection.php(51): Doctrine\DBAL\Connection->executeQuery('SELECT t0.id AS...', Array, Array, NULL)
#3 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(1808): XLite\Core\Connection->executeQuery('SELECT t0.id AS...', Array, Array)
#4 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/vendor/doctr ine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(1747): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement(Array, Object(XLite\Model\Category))
#5 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(2844): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection(Array, Object(XLite\Model\Category), Object(Doctrine\ORM\PersistentCollection))
#6 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/PersistentCollection.php(697): Doctrine\ORM\UnitOfWork->loadCollection(Object(Doctrine\ORM\PersistentCollection))
#7 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/PersistentCollection.php(214): Doctrine\ORM\PersistentCollection->doInitialize()
#8 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/vendor/doctrine/collections/lib/Doctrine/Common/Collections/AbstractLazyCollection.php(49): Doctrine\ORM\PersistentCollection->initialize()
#9 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/PersistentCollection.php(462): Doctrine\Common\Collections\AbstractLazyCollection->count()
#10 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/var/run/classes/XLite/Model/Base/Catalog.php(119): Doctrine\ORM\PersistentCollection->count()
#11 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/var/run/classes/XLite/Controller/Customer/Base/Catalog.php(160): XLite\Model\Base\Catalog->getCleanURL()
#12 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/var/run/classes/XLite/Controller/Customer/Category.php(87): XLite\Controller\Customer\Base\Catalog->isRedirectToCleanURLNeeded()
#13 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/var/run/classes/XLite/Controller/Customer/ACustomerAbstract.php(605): XLite\Controller\Customer\Category->isRedirectToCleanURLNeeded()
#14 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/var/run/classes/XLite/Controller/Customer/Base/Catalog.php(145): XLite\Controller\Customer\ACustomerAbstract->doNoAction()
#15 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/var/run/classes/XLite/Controller/Customer/MainAbstract.php(30): XLite\Controller\Customer\Base\Catalog->doNoAction()
#16 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/var/run/classes/XLite/Controller/AControllerAbstract.php(1408): XLite\Controller\Customer\MainAbstract->doNoAction()
#17 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/var/run/classes/XLite/Controller/AControllerAbstract.php(540): XLite\Controller\AControllerAbstract->run()
#18 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/var/run/classes/XLite/Module/QSL/CloudSearch/Controller/AController.php(28): XLite\Controller\AControllerAbstract->handleRequest()
#19 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/var/run/classes/XLite/Controller/Customer/ACustomerAbstract.php(284): XLite\Module\QSL\CloudSearch\Controller\AController->handleRequest()
#20 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/var/run/classes/XLite/Controller/Customer/Base/Catalog.php(47): XLite\Controller\Customer\ACustomerAbstract->handleRequest()
#21 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/var/run/classes/XLiteAbstract.php(624): XLite\Controller\Customer\Base\Catalog->handleRequest()
#22 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/var/run/classes/XLiteAbstract.php(649): XLiteAbstract->runController()
#23 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/var/run/classes/XLiteAbstract.php(665): XLiteAbstract->processRequest()
#24 /Applications/xcart-5.3.1.3-1/apps/xcart/htdocs/cart.php(16): XLiteAbstract->runCustomerZone()
#25 {main}
I also get this stage error when I run a
Code:
SELECT * FROM bitnami_xcart.xc_clean_urls;
in MySQL Workbench...
Code:
09:53:55 SELECT * FROM bitnami_xcart.xc_clean_urls LIMIT 0, 1000 Error Code: 1146. Table 'bitnami_xcart.xc_clean_urls' doesn't exist 0.00051 sec