please help me, my page has an error due to dokan lite

renyk

New member

Apr 11, 2020

11

3

3

• May 3, 2020

• #1

Error en la base de datos de WordPress: [Tiene un error en su sintaxis SQL; consulte el manual que corresponde a la versión de su servidor MySQL para obtener la sintaxis correcta para usar cerca de ') ORDENAR POR ID ASC' en la línea 1]
SELECCIONE * DESDE wp_fpd_products DONDE user_id IN (3,) ORDENAR POR ID ASC
Error en la base de datos de WordPress: [Tiene un error en su sintaxis SQL; consulte el manual que corresponde a la versión de su servidor MySQL para obtener la sintaxis correcta para usar cerca de ') ORDENAR POR ID ASC' en la línea 1]
SELECCIONE * DESDE wp_fpd_products DONDE user_id IN (3,) ORDENAR POR ID ASC


Eliminar el complemento y el error desaparece y lo activo de nuevo y vuelve a aparecer

actualizar a la última versión y el error aún continúa, incluso una copia de seguridad antes de que el error siga apareciendo

 

Last edited: May 4, 2020

MrSam_1

Well-known member

Administrative

Trusted Seller

Dec 1, 2018

23,638

26,980

120

• May 3, 2020

• #2

renyk said:

SELECCIONE * DESDE wp_fpd_products DONDE user_id IN (3,)

Click to expand...

Find in your plugins/themes where this line appear and remove the , after 3 so it will be (3)

without other details like what themes and plugins are you using this is the best advice one can give you

 

• 

Reactions: renyk

renyk

New member

Apr 11, 2020

11

3

3

• May 4, 2020

• #3

this is the Query i dont know what have to do.

 

MrSam_1

Well-known member

Administrative

Trusted Seller

Dec 1, 2018

23,638

26,980

120

• May 4, 2020

• #4

that's not the whole query, it must have also a filter ... search more

 

• 

Reactions: renyk

renyk

New member

Apr 11, 2020

11

3

3

• May 4, 2020

• #5

No soy muy experto donde puedo ver la consulta completa?

 

MrSam_1

Well-known member

Administrative

Trusted Seller

Dec 1, 2018

23,638

26,980

120

• May 4, 2020

• #6

Please upload the archive of plugin here.

 

• 

Reactions: renyk

renyk

New member

Apr 11, 2020

11

3

3

• May 4, 2020

• #7

In what format do I export it?

 

MrSam_1

Well-known member

Administrative

Trusted Seller

Dec 1, 2018

23,638

26,980

120

• May 4, 2020

• #8

Are you using Fancy Product Designer?

 

• 

Reactions: renyk

renyk

New member

Apr 11, 2020

11

3

3

• May 4, 2020

• #9

no, mi problema es con dokan lite.
Es el complemento que me presenta el error, lo comprobé.

 

MrSam_1

Well-known member

Administrative

Trusted Seller

Dec 1, 2018

23,638

26,980

120

• May 4, 2020

• #10

The only resemblance I found in fancy product designer -> class-wc-dokan.php



So it seems that your fancy product designer have issues with your dokan lite. Try to use dokan pro from babiato and see if you have the same error

https://babiato.tech/resources/dokan-business-multi-vendor-marketplace.1387/

Another question: what is your fancy product designer version?

 

• 

Reactions: renyk

renyk

New member

Apr 11, 2020

11

3

3

• May 4, 2020

• #11

ready, I had removed the Fancy check and saw that it had an active derivative, I deleted it and the error was corrected ... thank you very much you are the best.

 

• 

Reactions: Mr G