erpnext login on my localhost fails after initial setup [Missing table 'tabScheduler Log']

[Aditya Mukhopadhyay]

Hi,

Tried posting this query on stackoverflow, but couldn't since the tag 'erpnext' is non-existent till date and I don't have enough brownie points on the site to create it anew.

I am trying to get the erpnext application setup and running on my Fedora 17 64 bit machine. I followed the instructions given here. Everything went through smoothly enough, and I got to the login page. When I login using the credential 'Administrator/admin' (as given in the setup instructions) I am greeted by a blank screen. Checked the logs and saw the following error stacktrace:

    Traceback (most recent call last):

      File "lib/wnf.py", line 485, in <module>

        run()

      File "lib/wnf.py", line 391, in run

        print webnotes.utils.scheduler.execute()

      File "/var/www/html/erpnext/lib/webnotes/utils/scheduler.py", line 63, in execute

        out.append('daily:' + trigger('execute_daily'))

      File "/var/www/html/erpnext/lib/webnotes/utils/scheduler.py", line 94, in trigger

        return log(method)

      File "/var/www/html/erpnext/lib/webnotes/utils/scheduler.py", line 107, in log

        d.save()

      File "/var/www/html/erpnext/lib/webnotes/model/doc.py", line 406, in save

        make_autoname, keep_timestamps = keep_timestamps)

      File "/var/www/html/erpnext/lib/webnotes/model/doc.py", line 270, in _insert

        self._validate_name(case)

      File "/var/www/html/erpnext/lib/webnotes/model/doc.py", line 244, in _validate_name

        if webnotes.conn.sql('select name from `tab%s` where name=%s' % (self.doctype,'%s'), self.name):

      File "/var/www/html/erpnext/lib/webnotes/db.py", line 111, in sql

        raise e

    _mysql_exceptions.ProgrammingError: (1146, "Table 'erpnext.tabScheduler Log' doesn't exist")

Checked the database and found no table by the name 'tabScheduler Log'. Any idea why the application is looking for a non-existent table? Missing table or an error in app logic? Or did I miss something in the installation?

[Anand Doshi]

Hi,

It seems your installation is not complete.

Try running:
lib/wnf.py --patch_sync_build

Thanks,
Anand.

--
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/G46_ejYhTTQJ.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Aditya Mukhopadhyay]

Tried a fresh install, ran the patch, no errors. Login -> Blank screen
-> no errors in logfile.

One thing I have changed is the hostname and port. My named vhost is
set to (host: erpnext, port: 80). Have an entry in my /etc/hosts file
pointing erpnext to localhost.

Modified the domain setting command params to make it look like:
'lib/wnf.py --domain erpnext'

Cleared browser cache, set log level to DEBUG in conf.py, restarted
httpd (to clear out possible stale code caches).... rewarded with blank
screen and no logged error msgs again.

I think my changes with the host settings ought to be legit enough. Any
clues? Should I try using localhost:8080? (This cannot be a long-term
solution, since I normally use my 'localhost' vhost for man2html, and
port 8080 is often required by tomcat.)

Regards,
Aditya Mukhopadhyay

On Thu 24 Jan 2013 12:28:56 IST, Anand Doshi wrote:
> Hi,
>
> It seems your installation is not complete.
>
> Try running:
> lib/wnf.py --patch_sync_build
>
> Thanks,
> Anand.
>
> On Jan 24, 2013 12:20 PM, "Aditya Mukhopadhyay" <Adi...@gocoop.com

> <mailto:Adi...@gocoop.com>> wrote:
>
> Hi,
> Tried posting this query on stackoverflow, but couldn't since the
> tag 'erpnext' is non-existent till date and I don't have enough
> brownie points on the site to create it anew.
>
> I am trying to get the erpnext

> <https://github.com/webnotes/erpnext> application setup and

> running on my Fedora 17 64 bit machine. I followed the
> instructions given here

> <https://github.com/webnotes/erpnext/wiki/How-to-Install-ERPNext>.

> name=%s' % (self.doctype,'%s'), self.name <http://self.name>):

> File "/var/www/html/erpnext/lib/webnotes/db.py", line 111,
> in sql
> raise e
> _mysql_exceptions.ProgrammingError: (1146, "Table
> 'erpnext.tabScheduler Log' doesn't exist")
>
> Checked the database and found no table by the name 'tabScheduler
> Log'. Any idea why the application is looking for a non-existent
> table? Missing table or an error in app logic? Or did I miss
> something in the installation?
>
> --
> You received this message because you are subscribed to the Google
> Groups "ERPNext Developer Forum" group.
> To post to this group, send email to
> erpnext-dev...@googlegroups.com

> <mailto:erpnext-dev...@googlegroups.com>.

> To unsubscribe from this group, send email to
> erpnext-developer...@googlegroups.com

> <mailto:erpnext-developer-forum%2Bunsu...@googlegroups.com>.

[Anand Doshi]

Hi Aditya,

If you are using firefox, install firebug add-on and check its console when trying to login.
If using chrome, check its javascript console.

You will get the error there. Once we have the error, we can think of a solution.

Thanks,
Anand.

[Rushabh Mehta]

Please also do:

public/server.py?cmd=startup 

and check if you see a traceback there.

On 24-Jan-2013, at 1:22 PM, Aditya Mukhopadhyay <adi...@gocoop.com> wrote:

   <mailto:erpnext-developer-forum%2Bunsubscribe@googlegroups.com>.

   To view this discussion on the web visit
   https://groups.google.com/d/msg/erpnext-developer-forum/-/G46_ejYhTTQJ.
   For more options, visit https://groups.google.com/groups/opt_out.


--
You received this message because you are subscribed to the Google
Groups "ERPNext Developer Forum" group.
To post to this group, send email to
erpnext-dev...@googlegroups.com.
To unsubscribe from this group, send email to
erpnext-developer...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Aditya Mukhopadhyay]

Hurray, got it running! Here's a rundown of my organized buffoonery:

1. Need memcached. Already had couchbase running, so thought I'd just go ahead and create a memcached bucket there. One little quirk with couchbase is that if your memcached bucket is named anything other than 'default' (mine was erpnext), it doesn't let you run in auth-less mode unless you specify a port other than 11211. So I had gone ahead and set a password for SASL auth to let it run on 11211, and then completely forgot about it.
2. Flash forward to all-too-familiar blank screen. Firebug console shows the following error:
   

   Traceback (innermost last):

     File "../lib/webnotes/handler.py", line 159, in handle

       execute_cmd(cmd)

     File "../lib/webnotes/handler.py", line 191, in execute_cmd

       ret = call(method, webnotes.form_dict)

     File "../lib/webnotes/handler.py", line 210, in call

       return fn(**newargs)

     File "../lib/webnotes/handler.py", line 54, in startup

       webnotes.response.update(webnotes.sessions.get())

     File "../lib/webnotes/sessions.py", line 76, in get

       if not webnotes.cache().get_stats():

     File "/usr/lib/python2.7/site-packages/memcache.py", line 228, in get_stats

       line = readline()

     File "/usr/lib/python2.7/site-packages/memcache.py", line 1055, in readline

       data = recv(4096)

    timeout: timed out

This is what led me to the discovery of an overly secure memcached server being the source of all my trouble. So all I had to do was create a bucket named 'default' (duh)... so now I have an auth-less bucket available on standard port 11211 and the things start working.

Thanks for the heads up!

-- 
Regards,
Aditya Mukhopadhyay