localhost:8080 mysql error

[Ferenc]

Hello,

After Erpnext update, localhost:8080 address shows the following error

Oops, a server error has occured

Traceback (innermost last):
  File "../lib/webnotes/webutils.py", line 16, in render
    html = get_html(page_name)
  File "../lib/webnotes/webutils.py", line 43, in get_html
    html = load_into_cache(page_name)
  File "../lib/webnotes/webutils.py", line 97, in load_into_cache
    args = prepare_args(page_name)
  File "../lib/webnotes/webutils.py", line 143, in prepare_args
    args = get_doc_fields(page_name)
  File "../lib/webnotes/webutils.py", line 153, in get_doc_fields
    doc_type, doc_name = get_source_doc(page_name)
  File "../lib/webnotes/webutils.py", line 174, in get_source_doc
    get_generators()[doctype]["condition_field"]), page_name)
  File "../lib/webnotes/db.py", line 111, in sql
    raise e
 ProgrammingError: (1064, "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 '%s and ifnull(show_in_website, 0)=1' at line 2")

I am using Ubuntu 12.04.1 and mySql ver. 5.5.32

Pls. advise.

Thank you,
Ferenc

[Anand Doshi]

Hi Ferenc,

From terminal, go to where you've' installed erpnext and check the output of:

lib/wnf.py --git status

See if there are any merge conflicts.

-Anand.

--
Note:
 
If you are posting an issue,
1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
 
End of Note
---
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Rushabh Mehta]

On what page are you getting this error?

W: https://erpnext.com
T: @rushabh_mehta

On 04-Sep-2013, at 2:57 PM, Ferenc <feren...@gmail.com> wrote:

[Rushabh Mehta]

Please update and check again.

W: https://erpnext.com
T: @rushabh_mehta

On 04-Sep-2013, at 2:57 PM, Ferenc <feren...@gmail.com> wrote:

[Ferenc]

Hi Anand,
this is the output:
# On branch master
# Your branch is ahead of 'origin/master' by 50 commits.
#
nothing to commit (working directory clean)
# On branch master
# Your branch is ahead of 'origin/master' by 84 commits.
#
nothing to commit (working directory clean)

Ferenc

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+unsub...@googlegroups.com.

[Anand Doshi]

Hi Ferenc,

Have you updated after a long time? 

Can you try going to localhost:8080/login and see what happens?

-Anand.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer...@googlegroups.com.

[Ferenc]

Hi Rushabh,
address bar shows http://localhost:8080/

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+unsub...@googlegroups.com.

[Ferenc]

Anand,
Iogin page on localhost:8080/login works correctly, I am able to get dashboard.
Error message shows up only on localhost:8080
It is acceptable solution for me, but I am interested in the cause of error

Thank you,
Ferenc

[Anand Doshi]

Hi Ferenc,

Can you login, go to Website > Website Settings and check if there is any home page specified?

-Anand.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer...@googlegroups.com.

[Ferenc]

Yes, it was a "home" as home page, I deleted it (left it blank) ant now localhost:8080
Thank you for your excellent assistance
Ferenc