Community Support Forums - Sellacious

Welcome to Sellacious Support Forums, You are at the right place if you are facing an issue with Sellacious.
Support Online
We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours:
Monday To Friday except Saturday and Sunday
From 9:00AM To 9:00PM
  1. angelo bianco
  2. Bug Report Desk
  3. Friday, June 30 2017, 08:05 PM
  4.  Subscribe via email
hello,
i found some sql syntax errors.

-> BACKEND

1. SHIPPING RULES -> sorting does not work at all!

2. COUPONS:
- Coupon Code, Per User Limit, Overall Usage Limit, Discount, Min. Purchase, Max. Discount, Discount Limit, Start Date, End Date -> Warning: 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 'LIMIT 20' at line 6 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 '' at line 6

3. ORDERS:
- Payment Method -> does not sort right!
- Shipment Methode -> Warning: 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 'LIMIT 20' at line 8

4. TRANSACTIONS (Accounts Transactions):
- Transactions For, Trans.No., Order ID, Reason, Amount+, Amount-, Balance, Date, Notes -> Warning: 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 'LIMIT 20' at line 5

5. USER PROFILE:
- Manufacturers -> Company, Email, Phone, Manufacturers Category
- Sellers -> Company, Email, Phone, Seller Category
- Clients -> Email, Phone, Client Category
- Staffs -> Email, Phone, Staff Category
- All Users -> Client Category, Manufacturer Category, Staff Category, Seller Category
-> Warning: 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 'LIMIT 20' at line 14 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 '' at line 14

6. CATEGORIES:
- Special Categories -> Status, Subscription Fee -> Warning: 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 'LIMIT 20' at line 6 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 '' at line 6

7. MESSAGES:
- Read Message -> Subject -> Warning: 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 'LIMIT 20' at line 8 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 '' at line 8

8. ADDITIONAL ATTRIBUTES:
- Product Attributes, Query Form Fields, Payment Form Fields, Custom Fields, etc. -> All Context -> Warning: 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 'LIMIT 20' at line 6 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 '' at line 6

9. REPORTING:
- Communication Log -> Created Date -> sorting does not work at all!

10. At least: 2 missing Strings
Coupons:
COM_SELLACIOUS_COUPONS_N_ITEMS_UNPUBLISHED
COM_SELLACIOUS_COUPONS_N_ITEMS_PUBLISHED

using joomla 3.7.x and sellacious 1.4.7
best regards
Comment
There are no comments made yet.
Ankit Agrawal Accepted Answer
0
Votes
Undo
Hi Angelo,

Thanks for reporting the errors. Seems that there is an issue with the installation itself. May i know the following:

1. Where have you installed this? Server or Local development environment? Please mention the specs as well.
2. Which method did you use to install this? QuickStart, Install Via Web, Download from Site?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Bug Report Desk
  3. # 1
angelo bianco Accepted Answer
0
Votes
Undo
Hello Ankit,
I've installed it through QuickStart (squick_quickstart_v2.1.0, all updates were made).

SQL: 5.7.16
utf8_general_ci
utf8mb4_general_ci
PHP-Version: 7.1.6
Webserver: Apache
Joomla!-Version: Joomla! 3.7.2 Stable [ Amani ] 22-May-2017 09:46 GMT
Comment
There are no comments made yet.
  1. more than a month ago
  2. Bug Report Desk
  3. # 2
angelo bianco Accepted Answer
0
Votes
Undo
I've tested it on your demo server and the issues still appears.
the issue appears when i try to sort the columns.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Bug Report Desk
  3. # 3
Ankit Agrawal Accepted Answer
0
Votes
Undo
Can't replicate it, Which demo are we speaking about?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Bug Report Desk
  3. # 4
angelo bianco Accepted Answer
0
Votes
Undo
Here, on your Sellacious Demo
http://demo.sellacious.com/squick/sellacious/
Comment
There are no comments made yet.
  1. more than a month ago
  2. Bug Report Desk
  3. # 5
angelo bianco Accepted Answer
0
Votes
Undo
Try sorting: Shop -> Coupons -> Discount
Comment
There are no comments made yet.
  1. more than a month ago
  2. Bug Report Desk
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
  • SeedStars World
  • Commodo
  • NASSCOM 10k