Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Can't use LIMIT clause in Sql request manager #31785

Open
2 tasks done
web-cooking-factory opened this issue Mar 14, 2023 · 1 comment
Open
2 tasks done

Can't use LIMIT clause in Sql request manager #31785

web-cooking-factory opened this issue Mar 14, 2023 · 1 comment
Labels
1.7.8.8 Affects versions Advanced parameters Component: Which BO section is concerned BO Category: Back Office Bug Type: Bug Database Label: Which BO under menu is concerned Minor Severity: minor bug > https://build.prestashop.com/news/severity-classification PR available Solution: issue is being addressed Ready Status: Issue is ready to be worked on SQL Manager Label: Which BO under menu is concerned Verified The issue has been reproduced
Projects
PrestaShop Roadmap

Comments

@web-cooking-factory
Copy link
Contributor

Prerequisites

Describe the bug and add attachments

Using LIMIT in a request results in the error : "The LIMIT clause must contain numeric arguments.".

Expected behavior

No error, get limited results.

Steps to reproduce

  1. Go in BO > Advanced Parmeters > Database > Sql request manager
  2. Create this request : SELECT id_product FROM ps_product LIMIT 0,10

PrestaShop version(s) where the bug happened

1.7.8.8

PHP version(s) where the bug happened

7.4

If your bug is related to a module, specify its name and its version

No response
@web-cooking-factory web-cooking-factory added Bug Type: Bug New New issue not yet processed by QA labels Mar 14, 2023
@djoelleuch
Copy link

Hello @web-cooking-factory ,
I reproduce the issue with PrestaShop 1.7.8.8 ,develop .

Untitled_.Mar.15.2023.2_40.PM.webm

The expected behavior on database :

image

Thank you

@djoelleuch djoelleuch added Minor Severity: minor bug > https://build.prestashop.com/news/severity-classification BO Category: Back Office Advanced parameters Component: Which BO section is concerned Database Label: Which BO under menu is concerned SQL Manager Label: Which BO under menu is concerned Ready Status: Issue is ready to be worked on Verified The issue has been reproduced and removed New New issue not yet processed by QA labels Mar 15, 2023
@hibatallahAouadni hibatallahAouadni added the 1.7.8.8 Affects versions label Mar 16, 2023
@Codencode Codencode mentioned this issue May 9, 2023
Merged
@prestonBot prestonBot added the PR available Solution: issue is being addressed label May 9, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
1.7.8.8 Affects versions Advanced parameters Component: Which BO section is concerned BO Category: Back Office Bug Type: Bug Database Label: Which BO under menu is concerned Minor Severity: minor bug > https://build.prestashop.com/news/severity-classification PR available Solution: issue is being addressed Ready Status: Issue is ready to be worked on SQL Manager Label: Which BO under menu is concerned Verified The issue has been reproduced
Projects
PrestaShop Roadmap
Awaiting triage
Milestone
No milestone
Development

No branches or pull requests
4 participants
@prestonBot @hibatallahAouadni @web-cooking-factory @djoelleuch