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