Suljettu

Magento / SQL problem needs fixing!

I have an issue with a part of the Magento administrator control panel as follows:

When I go to Sales -> Orders, instead of a list of orders I get an error:

SQLSTATE[42000]: Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

Unfortunately the Magento Forums don't offer much help so I really need this fixing asap!

I would also like to know exactly why this issue has occurred and how it can be prevented in the future.

Taidot: Magento, SQL

Näytä lisää: reporting sql server, syntax error access violation 1104 sql, sql tuning, problem fixing, part problem, no problem part 1, need sql help, fixing problem, magento sql, t-sql with, t-sql in, magento go, violation, t-sql;, SQL Access, magento\ , magento+, mAGENTO issue, magento help, magento 20, get sql help, fixing, error fixing, access sql, sales problem

About the Employer:
( 2 reviews ) Cheltenham, United Kingdom

Projektin tunnus: #468249

9 freelanceria on tarjonnut keskimäärin 54 $ tähän työhön

TakeReal

I can fix issue and explain what it was. I need FTP access to start right now.

40 $ USD 1 päivässä
(183 arvostelua)
5.7
shoppingcartguru

Dear Sir I have experienced and expertise in magento fields. Please view PMB about my developed magento sites. I hope that you will provide this job to me and reply to me as soon as possible. Regards Raj

30 $ USD 1 päivässä
(4 arvostelua)
3.9
anode

Ready to fix the problem. Can start right away.

30 $ USD 1 päivässä
(9 arvostelua)
3.8
imre11

Hello, I've seen this error before and can fix it for you.

30 $ USD 1 päivässä
(0 arvostelua)
0.0
snaz3d

I'm online and know how to fix this. let's do it. Cheers

30 $ USD 0 päivässä
(0 arvostelua)
0.0
FallWind

Hello. I can do this project. Regards.

30 $ USD 0 päivässä
(0 arvostelua)
0.0
Hsofttech

Hi, We are ready for this job. Thanks Hsofttech Team

30 $ USD 0 päivässä
(0 arvostelua)
0.0
team12

I have excellent expertise developers and programmers specialized in different technologies for the better accomplishment of the clients needs. Please find PMB Thanks.

30 $ USD 1 päivässä
(0 arvostelua)
0.0
nasirmehmoodpser

i have to do it

240 $ USD 5 päivässä
(0 arvostelua)
0.0