Jump to content

[ISSUE] - Sort by new customer on order controller page in back office - The given alias 'o' is not part of any FROM or JOIN clause table


Recommended Posts

  • 4 months later...
On 4/21/2023 at 7:45 AM, AddWeb Solution said:

I think You will need to modify the SQL query which you used to sort orders by New customers.

In BO SQL Manager, Do you see ORDER BY {$orderBy} {$orderWay} line in the query?


Versions : PS and PHP 7.2

I have the same problem but after activating the debug mode, I see that the error is present in the Prestashop source / vendor files.

The request is not present in the BO but is native to PS.

Do you have any idea how to deal with this error?

CleanShot 2023-09-01 at 10.39.16.png

Link to comment
Share on other sites

  • 4 weeks later...

Hi, I've finaly found my way by :

- Disabling the debug mode 

- Creating a new user in the back office (Advanced parameters -> Team )

- Go to the order tab, use a random filter

-  Inspect the reset button (with the Chrome Devtools for example )

- Get the data-url of the element

- Go back to your stucked account

- With chrome devtools, edit the body of your page 

Add this :

<form action="[THE_URL]" method="POST">
  <button type="submit">Repare</button>

Click the repare button and it might work again ;)


PS : if it doesn't work, just get the token from your current url and modifiy the token of the action url

Edited by jmauclair
Might edit the token lol (see edit history)
Link to comment
Share on other sites

  • 3 months later...
  • 5 months later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...