X-Cart forums

[PatPgtips]

hi i notice this morning im getting this error on the shop front page

ERROR: "0" (code N/A)
An exception occurred while executing 'SELECT t0.id AS id1, t0.cleanURL AS cleanURL2, t0.page_id AS page_id3, t0.product_id AS product_id4, t0.category_id AS category_id5 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 'client132661_shop.xc_clean_urls' doesn't exist

i can access the admin area without any issues allthough i keep getting asked to enter activation key

anyone any ideas what this could be

[totaltec]

Curious: did you set t0 as your table prefix when you installed?

Looks like a database table is missing.

Have you tried rebuilding cache?

[PatPgtips]

the site was working yesterday i havent done anything with it and this morning i get this error

were do i rebuild cache about not realy sure

[tony_sologubov]

Hello @PatPgtips,

Could you please post the whole error message fired? You can find it in the php_errors and xlite files in <X-Cart>/var/log folder.

Thank you.

Tony

[PatPgtips]

tony im not going to bother mate

im just going to sell items from my forum

thanks again though

[cherie]

Originally Posted by totaltec

Curious: did you set t0 as your table prefix when you installed?

t0 is the table alias defined by this part: "FROM xc_clean_urls t0"
(not database table prefix)

[Grahame Thompson]

I'm having the same issue.

Installed from the bitnami OS X installer

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

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

SELECT * FROM bitnami_xcart.xc_clean_urls;

in MySQL Workbench...

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

[qualiteam]

What table does appear when you run this MySQL query in the MySQL console?

SHOW TABLES LIKE '%clean_urls';

Is it "bitnami_xcart.xc_clean_urls", or just "xc_clean_urls"?

Also, what are your database settings (the "[database_details]" section) in the etc/config.php file (replace your password with asterisks)?