[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

[jmauclair]

Hi guys,

 

I've tried to sort orders by new customers only and this happened :

 

How can I remove the fact that the order is sorted this way ? Because I can't go to the order page anymore

[AddWeb Solution]

On 4/19/2023 at 8:22 PM, jmauclair said:

I've tried to sort orders by new customers only and this happened :

 

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?

[JulienPct]

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?

Hello,

Versions : PS 1.7.7.2 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?

[jmauclair]

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>
</form>

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 September 23, 2023 by jmauclair
Might edit the token lol (see edit history)

[ps8modules.com]

Hi

Simply delete the desired filter in the database and ps_admin_filter table.

[jmauclair]

2 minutes ago, ps8moduly.cz said:

Hi

Simply delete the desired filter in the database and ps_admin_filter table.

Undeniably a better fix, in case you can access the DB

[Sebastien MAS]

Great solution to modify the base for resetting the filter. Thank you and happy new year 2024