Localhost:8080 mysql error

ferenc_tot · September 4, 2013, 9:27am

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

–

Note:

If you are posting an issue,

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.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

system · September 4, 2013, 9:32am

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.

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

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
–

Note:

If you are posting an issue,

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.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

–

Note:

If you are posting an issue,

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.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

rmehta · September 4, 2013, 9:36am

On what page are you getting this error?

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

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

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
–

Note:

If you are posting an issue,

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.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

–

Note:

If you are posting an issue,

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.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

rmehta · September 4, 2013, 9:43am

Please update and check again.

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

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

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
–

Note:

If you are posting an issue,

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.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

–

Note:

If you are posting an issue,

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.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

ferenc_tot · September 4, 2013, 10:23am

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

On Wednesday, September 4, 2013 11:32:41 AM UTC+2, Anand Doshi wrote:

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.
On 04-Sep-2013, at 2:57 PM, Ferenc <fe...@gmail.com> wrote:
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
–

Note:

If you are posting an issue,

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.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

–

Note:

If you are posting an issue,

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.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

system · September 4, 2013, 10:29am

Hi Ferenc,

Have you updated after a long time?

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

-Anand.

On 04-Sep-2013, at 3:53 PM, Ferenc <fe...@gmail.com> wrote:

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

On Wednesday, September 4, 2013 11:32:41 AM UTC+2, Anand Doshi wrote:
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.
On 04-Sep-2013, at 2:57 PM, Ferenc <fe...@gmail.com> wrote:
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
–

Note:

If you are posting an issue,

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.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.
–

Note:

If you are posting an issue,

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.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

–

Note:

If you are posting an issue,

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.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

ferenc_tot · September 4, 2013, 10:33am

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

On Wednesday, September 4, 2013 11:36:14 AM UTC+2, rushabh wrote:

On what page are you getting this error?

W: https://erpnext.com
T: @rushabh_mehta
On 04-Sep-2013, at 2:57 PM, Ferenc <fe...@gmail.com> wrote:
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
–

Note:

If you are posting an issue,

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.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

–

Note:

If you are posting an issue,

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.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

ferenc_tot · September 4, 2013, 10:44am

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

On Wednesday, September 4, 2013 12:29:29 PM UTC+2, Anand Doshi wrote:

Hi Ferenc,

Have you updated after a long time?
Can you try going to localhost:8080/login and see what happens?

-Anand.
On 04-Sep-2013, at 3:53 PM, Ferenc <fe...@gmail.com> wrote:
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

On Wednesday, September 4, 2013 11:32:41 AM UTC+2, Anand Doshi wrote:
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.
On 04-Sep-2013, at 2:57 PM, Ferenc <fe...@gmail.com> wrote:
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
–

Note:

If you are posting an issue,

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.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.
–

Note:

If you are posting an issue,

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.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

–

Note:

If you are posting an issue,

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.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

system · September 4, 2013, 10:50am

Hi Ferenc,

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

-Anand.

On 04-Sep-2013, at 4:14 PM, Ferenc <fe...@gmail.com> wrote:

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

On Wednesday, September 4, 2013 12:29:29 PM UTC+2, Anand Doshi wrote:
Hi Ferenc,

Have you updated after a long time?
Can you try going to localhost:8080/login and see what happens?

-Anand.
On 04-Sep-2013, at 3:53 PM, Ferenc <fe...@gmail.com> wrote:
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

On Wednesday, September 4, 2013 11:32:41 AM UTC+2, Anand Doshi wrote:
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.
On 04-Sep-2013, at 2:57 PM, Ferenc <fe...@gmail.com> wrote:
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
–

Note:

If you are posting an issue,

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.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.
–

Note:

If you are posting an issue,

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.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.
–

Note:

If you are posting an issue,

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.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

–

Note:

If you are posting an issue,

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.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

ferenc_tot · September 4, 2013, 11:00am

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

On Wednesday, September 4, 2013 12:50:26 PM UTC+2, Anand Doshi wrote:

Hi Ferenc,

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

-Anand.
On 04-Sep-2013, at 4:14 PM, Ferenc <fe...@gmail.com> wrote:
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

On Wednesday, September 4, 2013 12:29:29 PM UTC+2, Anand Doshi wrote:
Hi Ferenc,

Have you updated after a long time?
Can you try going to localhost:8080/login and see what happens?

-Anand.
On 04-Sep-2013, at 3:53 PM, Ferenc <fe...@gmail.com> wrote:
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

On Wednesday, September 4, 2013 11:32:41 AM UTC+2, Anand Doshi wrote:
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.
On 04-Sep-2013, at 2:57 PM, Ferenc <fe...@gmail.com> wrote:
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
–

Note:

If you are posting an issue,

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.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.
–

Note:

If you are posting an issue,

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.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.
–

Note:

If you are posting an issue,

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.

Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

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-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

–

Note:

If you are posting an issue,

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.
Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
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-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.