123,796+ downloads

0
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
Replies (6)
Abhishek Agrawal Accepted Answer Pending Moderation
Team
  1. Replied more than a month ago
  2. #Permalink
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?
angelo bianco Accepted Answer Pending Moderation
  1. Replied more than a month ago
  2. #Permalink
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
angelo bianco Accepted Answer Pending Moderation
  1. Replied more than a month ago
  2. #Permalink
I've tested it on your demo server and the issues still appears.
the issue appears when i try to sort the columns.
Abhishek Agrawal Accepted Answer Pending Moderation
Team
  1. Replied more than a month ago
  2. #Permalink
Can't replicate it, Which demo are we speaking about?
angelo bianco Accepted Answer Pending Moderation
  1. Replied more than a month ago
  2. #Permalink
Here, on your Sellacious Demo
http://demo.sellacious.com/squick/sellacious/
angelo bianco Accepted Answer Pending Moderation
  1. Replied more than a month ago
  2. #Permalink
Try sorting: Shop -> Coupons -> Discount
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Support is Offline
Support Hours
Monday To Saturday
From 09:00 To 21:00 IST
Sellacious Time 00:00:00

Login

?
?