• Closed by: Fred
  • Closed on: 09.07.20, 20:51
  • Reason: Closed
  • Comment: Glad to help!

Ticket #18506 - pk_menu error with ph_simpleblog

Hi,

when i’m changing language that isn’t default i see this error.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':|:menu title AND l.id_lang = 4) LIMIT 1' at line 3


SELECT l.link_rewrite
FROM `ps_simpleblog_category_lang` l
WHERE (l.id_simpleblog_category = 0:|:menu title AND l.id_lang = 4) LIMIT 1

See attached image for more detail.
Any way to fix this?

Thanks

Attachments:

Screenshot 2020-06-30 at 15.5... (217.3 KiB)

Comments

Fred 30 Jun 2020, 20:50

Is that a back office or front office issue?

Victor Santacreu 30 Jun 2020, 23:55

Front, actually is home page.

Fred 01 Jul 2020, 23:37

I’m not able to open your front page, it ask a password

Victor Santacreu 02 Jul 2020, 00:52

yes, i haven’t any space in my profile to add credentials.

Fred 03 Jul 2020, 09:36

you can replace your current credentials

Victor Santacreu 03 Jul 2020, 09:38

I can add some more new. Let me your user and pass for that very first security screen :)

Victor Santacreu 07 Jul 2020, 17:13

Hi,

any news on that?

u: web
p: vidres

This is the very first credentials

Fred 08 Jul 2020, 17:07

Still not able to connect https://take.ms/yFwEL

Tried different options: FTP/SFTP, secure/insecure

Victor Santacreu 09 Jul 2020, 09:21

No, this was web credentials. FTP credentials are in my profile.

Attachments:

Screenshot 2020-07-09 at 09.2... (161.8 KiB)
Fred 09 Jul 2020, 10:58

Sorry, my fault.
Now I have access.
But now I can’t find how to cause the error. I tried to open the page http://vw.ebavs.net/en/blog and change the language but didn’t get such error like you have

Victor Santacreu 09 Jul 2020, 11:21

I was adding translations yesterday. Seems that if you haven’t translated menus this happens. Let me few hours and I try again to generate error.

Thanks

Fred 09 Jul 2020, 11:21

ok

Victor Santacreu 09 Jul 2020, 12:38

Hi, I was trying to raise error with no luck.

Yesterday we was adding translations and doing some work in blog. Maybe someone add the exact information needed to do this work.

Anyway, I will request close ticket.

Thanks