fbpx
  Friday, 30 June 2017
  6 Replies
  4.9K Visits
  Subscribe
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
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?
7 years ago
·
#506
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
7 years ago
·
#507
I've tested it on your demo server and the issues still appears.
the issue appears when i try to sort the columns.
Can't replicate it, Which demo are we speaking about?
7 years ago
·
#514
Here, on your Sellacious Demo
https://demo.sellacious.com/squick/sellacious/
7 years ago
·
#515
Try sorting: Shop -> Coupons -> Discount
  • Page :
  • 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
  • +1 (408) 821-8283
  • Email hello@sellacious.com