Hello,
I launched a new site which features document seller and it has been working great up till now.
One of my users has run into this problem when uploading documents from the front end, I tested it too, I fill out the details and the error message occurs after hitting the submit button to upload the document.
This error message also appears when I visit the "my downloads" page where you can download documents from previous orders.
Here is what I'm seeing. Thanks for your help!
500 - JDatabaseMySQL::query: 1064 - 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 ') ORDER BY a.ordering LIMIT 0, 20' at line 1 SQL=SELECT a.* FROM t0r4j_dms_documents AS a WHERE a.published = 1 AND a.id IN ( ) ORDER BY a.ordering LIMIT 0, 20
You may not be able to visit this page because of:
an out-of-date bookmark/favourite
a search engine that has an out-of-date listing for this site
a mistyped address
you have no access to this page
The requested resource was not found.
An error has occurred while processing your request.
Please try one of the following pages:
Home Page
If difficulties persist, please contact the System Administrator of this site.
JDatabaseMySQL::query: 1064 - 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 ') ORDER BY a.ordering LIMIT 0, 20' at line 1 SQL=SELECT a.* FROM t0r4j_dms_documents AS a WHERE a.published = 1 AND a.id IN ( ) ORDER BY a.ordering LIMIT 0, 20
Call stack
# Function Location
1 JSite->dispatch() /home/content/21/7284721/html/index.php:68
2 JComponentHelper->renderComponent() /home/content/21/7284721/html/includes/application.php:124
3 require_once() /home/content/21/7284721/html/libraries/joomla/application/component/helper.php:162
4 JController->execute() /home/content/21/7284721/html/components/com_dms/dms.php:27
5 DMSController->display() /home/content/21/7284721/html/libraries/joomla/application/component/controller.php:236
6 JController->display() /home/content/21/7284721/html/components/com_dms/controller.php:94
7 DMSViewMyDocs->display() /home/content/21/7284721/html/libraries/joomla/application/component/controller.php:310
8 JView->get() /home/content/21/7284721/html/components/com_dms/views/mydocs/view.html.php:25
9 DMSModelMyDocs->getData() /home/content/21/7284721/html/libraries/joomla/application/component/view.php:364
10 JModel->_getList() /home/content/21/7284721/html/components/com_dms/models/mydocs.php:82
11 JDatabaseMySQL->loadObjectList() /home/content/21/7284721/html/libraries/joomla/application/component/model.php:284
12 JDatabaseMySQL->query() /home/content/21/7284721/html/libraries/joomla/database/database/mysql.php:458
13 JError->raiseError() /home/content/21/7284721/html/libraries/joomla/database/database/mysql.php:231
14 JError->raise() /home/content/21/7284721/html/libraries/joomla/error/error.php:171
15 JException->__construct() /home/content/21/7284721/html/libraries/joomla/error/error.php:136
