Help with installation

Frappe Framework Bug
1

Hi,
I just saw this group id. Before that I had send a mails to couple of developers. Please ignore that and I apologise if that was an inconvenience. Could you help me out this errors please.Am sending this mail again as yahoo dint attach my message in my previous mail.I am trying to install webnotes but get the following error in browser.Am using secondcases as dbname and 'root' as the password in def.py.When I use install script also I get errors.


best,
Nijil

THIS IN BROWSER:

{"message": "", "exc": "
Traceback (innermost last):
File "/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/handler.py", line 268, in

webnotes.request = webnotes.auth.HTTPRequest()
File "/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/auth.py", line 28, in init
if webnotes.conn.get_global("__session_status")=='stop':

File "/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/db.py", line 301, in get_global
g = self.sql("select defvalue from tabDefaultValue where defkey=%s and parent=%s", (key, user))

File "/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/db.py", line 150, in sql
raise e
ProgrammingError: (1146, "Table 'secondcases.tabDefaultValue' doesn't exist")
"}


THIS IN TERMINAL:
la…@laserbled-MCP73:/var/www/webnotes-wnframework-67ef4b2/cgi-bin$ python webnotes/install_lib/install.py root root secondcases
Traceback (most recent call last):
File "webnotes/install_lib/install.py", line 243, in <module>

password = options.password, verbose = 1)
File "webnotes/install_lib/install.py", line 111, in import_from_db
self.dbman.delete_user(target)
File "webnotes/model/db_schema.py", line 306, in delete_user

raise e
_mysql_exceptions.OperationalError: (1227, 'Access denied; you need the CREATE USER privilege for this operation')

–

You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

2
Hello Nijil,

It says you do not have enough permission to create a user (MySQL)

Are you sure you are supplying the root password?

- Rushabh

On Aug 21, 2011, at 9:32 PM, nijil y wrote:

Hi,
I just saw this group id. Before that I had send a mails to couple of developers. Please ignore that and I apologise if that was an inconvenience. Could you help me out this errors please.Am sending this mail again as yahoo dint attach my message in my previous mail.I am trying to install webnotes but get the following error in browser.Am using secondcases as dbname and 'root' as the password in def.py.When I use install script also I get errors.

best,
Nijil

THIS IN BROWSER:

{"message": "", "exc": "
Traceback (innermost last):
File \"/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/handler.py\", line 268, in
webnotes.request = webnotes.auth.HTTPRequest()
File \"/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/auth.py\", line 28, in __init__
if webnotes.conn.get_global(\"__session_status\")=='stop':
File \"/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/db.py\", line 301, in get_global
g = self.sql(\"select defvalue from tabDefaultValue where defkey=%s and parent=%s\", (key, user))
File \"/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/db.py\", line 150, in sql
raise e
ProgrammingError: (1146, \"Table 'secondcases.tabDefaultValue' doesn't exist\")
"}

THIS IN TERMINAL:
la...@laserbled-MCP73:/var/www/webnotes-wnframework-67ef4b2/cgi-bin$ python webnotes/install_lib/install.py root root secondcases
Traceback (most recent call last):
File "webnotes/install_lib/install.py", line 243, in <module>
password = options.password, verbose = 1)
File "webnotes/install_lib/install.py", line 111, in import_from_db
self.dbman.delete_user(target)
File "webnotes/model/db_schema.py", line 306, in delete_user
raise e
_mysql_exceptions.OperationalError: (1227, 'Access denied; you need the CREATE USER privilege for this operation')

--
You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

---------------------------------------------------------------------------------
ERPNext - World's most affordable ERP - (Rs 299 / $7 per user per month)

Twitter: @rushabh_mehta

–

You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

3
Hi,
I did with root root - then I get the following:


la...@laserbled-MCP73:/var/www/webnotes-wnframework-67ef4b2/cgi-bin$ sudo python webnotes/install_lib/install.py root root secondcases
Created user secondcases
webnotes/db.py:143: Warning: Can't create database 'secondcases'; database exists
self._cursor.execute(query)
Created database secondcases
Granted privileges to user secondcases and database secondcases
Starting database import...
Imported from database /var/www/webnotes-wnframework-67ef4b2/data/Framework.sql
Importing core module...
Traceback (most recent call last):
File "webnotes/install_lib/install.py", line 243, in <module>
password = options.password, verbose = 1)
File "webnotes/install_lib/install.py", line 144, in import_from_db
self.import_core_module()
File "webnotes/install_lib/install.py", line 64, in import_core_module
core.sync_all(verbose=1)
File "webnotes/modules/__init__.py", line 165, in sync_all
self.sync_all_of_type('txt', verbose)
File "webnotes/modules/__init__.py", line 156, in sync_all_of_type
self.get_file(path).sync()
File "webnotes/modules/__init__.py", line 262, in sync
% (doclist[0]['doctype'], '%s'), doclist[0]['name'])
File "webnotes/db.py", line 150, in sql
raise e
_mysql_exceptions.ProgrammingError: (1146, "Table 'secondcases.tabModule Def' doesn't exist")
la...@laserbled-MCP73:/var/www/webnotes-wnframework-67ef4b2/cgi-bin$
and browser error remains same at:
{"message": "", "exc": "

Traceback (innermost last):
File \"/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/handler.py\", line 268, in
webnotes.request = webnotes.auth.HTTPRequest()
File \"/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/auth.py\", line 28, in __init__
if webnotes.conn.get_global(\"__session_status\")=='stop':
File \"/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/db.py\", line 301, in get_global
g = self.sql(\"select defvalue from tabDefaultValue where defkey=%s and parent=%s\", (key, user))
File \"/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/db.py\", line 150, in sql
raise e
ProgrammingError: (1146, \"Table 'secondcases.tabDefaultValue' doesn't exist\")

"}

–

You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

4
Hi,

I just ran the install on my local and it went through.

Are you using the latest 'master' branch?

Also try dropping the database before running it again.

- Rushabh



On Aug 21, 2011, at 10:28 PM, nijil y wrote:

Hi,
I did with root root - then I get the following:


la...@laserbled-MCP73:/var/www/webnotes-wnframework-67ef4b2/cgi-bin$ sudo python webnotes/install_lib/install.py root root secondcases
Created user secondcases
webnotes/db.py:143: Warning: Can't create database 'secondcases'; database exists
self._cursor.execute(query)
Created database secondcases
Granted privileges to user secondcases and database secondcases
Starting database import...
Imported from database /var/www/webnotes-wnframework-67ef4b2/data/Framework.sql
Importing core module...
Traceback (most recent call last):
File "webnotes/install_lib/install.py", line 243, in <module>
password = options.password, verbose = 1)
File "webnotes/install_lib/install.py", line 144, in import_from_db
self.import_core_module()
File "webnotes/install_lib/install.py", line 64, in import_core_module
core.sync_all(verbose=1)
File "webnotes/modules/__init__.py", line 165, in sync_all
self.sync_all_of_type('txt', verbose)
File "webnotes/modules/__init__.py", line 156, in sync_all_of_type
self.get_file(path).sync()
File "webnotes/modules/__init__.py", line 262, in sync
% (doclist[0]['doctype'], '%s'), doclist[0]['name'])
File "webnotes/db.py", line 150, in sql
raise e
_mysql_exceptions.ProgrammingError: (1146, "Table 'secondcases.tabModule Def' doesn't exist")
la...@laserbled-MCP73:/var/www/webnotes-wnframework-67ef4b2/cgi-bin$
and browser error remains same at:
{"message": "", "exc": "

Traceback (innermost last):
File \"/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/handler.py\", line 268, in
webnotes.request = webnotes.auth.HTTPRequest()
File \"/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/auth.py\", line 28, in __init__
if webnotes.conn.get_global(\"__session_status\")=='stop':
File \"/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/db.py\", line 301, in get_global
g = self.sql(\"select defvalue from tabDefaultValue where defkey=%s and parent=%s\", (key, user))
File \"/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/db.py\", line 150, in sql
raise e
ProgrammingError: (1146, \"Table 'secondcases.tabDefaultValue' doesn't exist\")

"}

--
You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

---------------------------------------------------------------------------------
ERPNext - World's most affordable ERP - (Rs 299 / $7 per user per month)

Twitter: @rushabh_mehta

–

You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

5
Hi,
The error persist.The creating database works.so the autentication is also fine I assume.From there it gives 5 errors most reffering to modules.Am I supposed to install that before doing the fraamework ?

Traceback (most recent call last):
File "webnotes/install_lib/install.py", line 251, in <module>
password = options.password, verbose = 1)
File "webnotes/install_lib/install.py", line 152, in import_from_db
self.import_core_module()
File "webnotes/install_lib/install.py", line 64, in import_core_module
core.sync_all(verbose=1)
File "webnotes/modules/__init__.py", line 165, in sync_all
self.sync_all_of_type('txt', verbose)
File "webnotes/modules/__init__.py", line 156, in sync_all_of_type
self.get_file(path).sync()
File "webnotes/modules/__init__.py", line 262, in sync
% (doclist[0]['doctype'], '%s'), doclist[0]['name'])
File "webnotes/db.py", line 152, in sql
raise e
_mysql_exceptions.ProgrammingError: (1146, "Table 'secondcases.tabModule Def' doesn't exist")


I cant figure out what this error means and that I should do. I am now working with master clone.

–

You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

6
File \"/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/db.py\", line 150, in sql

raise e
ProgrammingError: (1146, &quot;Table 'secondcases.tabDefaultValue' doesn't exist&quot;)


@Rushabh:
This does happen if you install the webnotes master db and use that in defs.py as default db.


tabDefaultValue table is present only in the erp master sql dump and not in the webnotes master db sql.

@Nijil:
If you are trying to install the erp application follow the corresponding instructions and change defs.py to use the erpdb. If you just want to develop on top of the wnframework, create the table tabDefaultValue manually.(You can get the schema from https://github.com/webnotes/erpnext/blob/master/master.sql.gz)



==============================================
Anand Jeyahar
https://sites.google.com/site/anandjeyahar
==============================================

The man who is really serious,
with the urge to find out what truth is,
has no style at all. He lives only in what is.
~Bruce Lee

Love is a trade with lousy accounting policies.
~Aang Jie





On Sun, Aug 21, 2011 at 23:13, nijil y <ni…@gmail.com> wrote:
> Hi,
> The error persist.The creating database works.so the autentication is also

> fine I assume.From there it gives 5 errors most reffering to modules.Am I
> supposed to install that before doing the fraamework ?
> Traceback (most recent call last):
> File "webnotes/install_lib/install.py", line 251, in <module>

> password = options.password, verbose = 1)
> File "webnotes/install_lib/install.py", line 152, in import_from_db
> self.import_core_module()
> File "webnotes/install_lib/install.py", line 64, in import_core_module

> core.sync_all(verbose=1)
> File "webnotes/modules/init.py", line 165, in sync_all
> self.sync_all_of_type('txt', verbose)
> File "webnotes/modules/init.py", line 156, in sync_all_of_type

> self.get_file(path).sync()
> File "webnotes/modules/init.py", line 262, in sync
> % (doclist[0]['doctype'], '%s'), doclist[0]['name'])
> File "webnotes/db.py", line 152, in sql

> raise e
> _mysql_exceptions.ProgrammingError: (1146, "Table 'secondcases.tabModule
> Def' doesn't exist")
>
>
> I cant figure out what this error means and that I should do. I am now

> working with master clone.
>
> –
> You received this message because you are subscribed to the Google Groups
> "Web Notes Framework Forum" group.
> To post to this group, send email to wn…@googlegroups.com.

> To unsubscribe from this group, send email to
> wnframework+un…@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/wnframework?hl=en.

>

–

You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

7
@Nijil, did you try deleting the database? I just tried master on my local machine and I am unable to replicate the issue. Can you try with a new database name?

@Anand, I don't thing he is trying to install erpnext. Can you try it on your machine and see if it works?

- Rushabh


On Aug 21, 2011, at 11:36 PM, anand jeyahar wrote:

File \"/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/db.py\", line 150, in sql
raise e
ProgrammingError: (1146, \"Table 'secondcases.tabDefaultValue' doesn't exist\")

@Rushabh:
This does happen if you install the webnotes master db and use that in defs.py as default db.

tabDefaultValue table is present only in the erp master sql dump and not in the webnotes master db sql.

@Nijil:
    If you are trying to install the erp application follow the corresponding instructions and change defs.py to use the erpdb. If you just want to develop on top of the wnframework, create the table tabDefaultValue manually.(You can get the schema from https://github.com/webnotes/erpnext/blob/master/master.sql.gz)


 
==============================================
Anand Jeyahar
https://sites.google.com/site/anandjeyahar
==============================================
The man who is really serious,
with the urge to find out what truth is,
has no style at all. He lives only in what is.
                  ~Bruce Lee

Love is a trade with lousy accounting policies.
                 ~Aang Jie




On Sun, Aug 21, 2011 at 23:13, nijil y <ni...@gmail.com> wrote:
> Hi,
> The error persist.The creating database works.so the autentication is also
> fine I assume.From there it gives 5 errors most reffering to modules.Am I
> supposed to install that before doing the fraamework ?
> Traceback (most recent call last):
> File "webnotes/install_lib/install.py", line 251, in <module>
> password = options.password, verbose = 1)
> File "webnotes/install_lib/install.py", line 152, in import_from_db
> self.import_core_module()
> File "webnotes/install_lib/install.py", line 64, in import_core_module
> core.sync_all(verbose=1)
> File "webnotes/modules/__init__.py", line 165, in sync_all
> self.sync_all_of_type('txt', verbose)
> File "webnotes/modules/__init__.py", line 156, in sync_all_of_type
> self.get_file(path).sync()
> File "webnotes/modules/__init__.py", line 262, in sync
> % (doclist[0]['doctype'], '%s'), doclist[0]['name'])
> File "webnotes/db.py", line 152, in sql
> raise e
> _mysql_exceptions.ProgrammingError: (1146, "Table 'secondcases.tabModule
> Def' doesn't exist")
>
>
> I cant figure out what this error means and that I should do. I am now
> working with master clone.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Web Notes Framework Forum" group.
> To post to this group, send email to wn...@googlegroups.com.
> To unsubscribe from this group, send email to
> wnframework+un...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/wnframework?hl=en.
>


--
You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

---------------------------------------------------------------------------------
ERPNext - World's most affordable ERP - (Rs 299 / $7 per user per month)

Twitter: @rushabh_mehta

–

You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

8

Hi Rushabh,



@Anand, I don't thing he is trying to install erpnext. Can you try it on your machine and see if it works?

It did give me the error, when i tried about 2 weeks ago. I found that webnotes/master.sql.gz does not have the tabDefaultValue. And the problem was fixed when i installed the erpnext db and changed defs.py.



Thanks and Regards,
Anand Jeyahar

–

You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

9
well actually I am trying to install erp for which I need to get the framework runningfirst ( i assume ).The same thing happens if I use diff db name.
As to the prev create user privilage issue it comes whenb I put def __init__(self, host=None, user=None, password=None, ac_name=None, use_default = 0): the use_default to true where it has the dbname and password.No idea about that.Let me check the schema for erp and use that to get this running

On Sun, Aug 21, 2011 at 11:44 PM, Rushabh Mehta <rm...@gmail.com> wrote:
@Nijil, did you try deleting the database? I just tried master on my local machine and I am unable to replicate the issue. Can you try with a new database name?

@Anand, I don't thing he is trying to install erpnext. Can you try it on your machine and see if it works?

- Rushabh


On Aug 21, 2011, at 11:36 PM, anand jeyahar wrote:

File \"/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/db.py\", line 150, in sql
raise e
ProgrammingError: (1146, \"Table 'secondcases.tabDefaultValue' doesn't exist\")

@Rushabh:
This does happen if you install the webnotes master db and use that in defs.py as default db.

tabDefaultValue table is present only in the erp master sql dump and not in the webnotes master db sql.

@Nijil:
If you are trying to install the erp application follow the corresponding instructions and change defs.py to use the erpdb. If you just want to develop on top of the wnframework, create the table tabDefaultValue manually.(You can get the schema from https://github.com/webnotes/erpnext/blob/master/master.sql.gz)


==============================================
Anand Jeyahar
https://sites.google.com/site/anandjeyahar
==============================================
The man who is really serious,
with the urge to find out what truth is,
has no style at all. He lives only in what is.
~Bruce Lee

Love is a trade with lousy accounting policies.
~Aang Jie




On Sun, Aug 21, 2011 at 23:13, nijil y <ni...@gmail.com> wrote:
> Hi,
> The error persist.The creating database works.so the autentication is also
> fine I assume.From there it gives 5 errors most reffering to modules.Am I
> supposed to install that before doing the fraamework ?
> Traceback (most recent call last):
> File "webnotes/install_lib/install.py", line 251, in <module>
> password = options.password, verbose = 1)
> File "webnotes/install_lib/install.py", line 152, in import_from_db
> self.import_core_module()
> File "webnotes/install_lib/install.py", line 64, in import_core_module
> core.sync_all(verbose=1)
> File "webnotes/modules/__init__.py", line 165, in sync_all
> self.sync_all_of_type('txt', verbose)
> File "webnotes/modules/__init__.py", line 156, in sync_all_of_type
> self.get_file(path).sync()
> File "webnotes/modules/__init__.py", line 262, in sync
> % (doclist[0]['doctype'], '%s'), doclist[0]['name'])
> File "webnotes/db.py", line 152, in sql
> raise e
> _mysql_exceptions.ProgrammingError: (1146, "Table 'secondcases.tabModule
> Def' doesn't exist")
>
>
> I cant figure out what this error means and that I should do. I am now
> working with master clone.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Web Notes Framework Forum" group.
> To post to this group, send email to wn...@googlegroups.com.
> To unsubscribe from this group, send email to
> wnframework+un...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/wnframework?hl=en.
>


--
You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

---------------------------------------------------------------------------------
ERPNext - World's most affordable ERP - (Rs 299 / $7 per user per month)

Twitter: @rushabh_mehta

–


You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.

To post to this group, send email to wn…@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un…@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.


–

You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

10

@anand - thanks a bunch :smiley: - am in - phew - did spent a lot of time on this trying to figure out what went wrong - but now finally works :).

On Sun, Aug 21, 2011 at 11:50 PM, nijil y <ni…@gmail.com> wrote:

well actually I am trying to install erp for which I need to get the framework runningfirst ( i assume ).The same thing happens if I use diff db name.
As to the prev create user privilage issue it comes whenb I put def __init__(self, host=None, user=None, password=None, ac_name=None, use_default = 0): the use_default to true where it has the dbname and password.No idea about that.Let me check the schema for erp and use that to get this running

On Sun, Aug 21, 2011 at 11:44 PM, Rushabh Mehta <rm...@gmail.com> wrote:
@Nijil, did you try deleting the database? I just tried master on my local machine and I am unable to replicate the issue. Can you try with a new database name?

@Anand, I don't thing he is trying to install erpnext. Can you try it on your machine and see if it works?

- Rushabh


On Aug 21, 2011, at 11:36 PM, anand jeyahar wrote:

File &quot;/var/www/webnotes-wnframework-67ef4b2/cgi-bin/webnotes/db.py&quot;, line 150, in sql
raise e
ProgrammingError: (1146, &quot;Table 'secondcases.tabDefaultValue' doesn't exist&quot;)


@Rushabh:
This does happen if you install the webnotes master db and use that in defs.py as default db.

tabDefaultValue table is present only in the erp master sql dump and not in the webnotes master db sql.


@Nijil:
If you are trying to install the erp application follow the corresponding instructions and change defs.py to use the erpdb. If you just want to develop on top of the wnframework, create the table tabDefaultValue manually.(You can get the schema from https://github.com/webnotes/erpnext/blob/master/master.sql.gz)



==============================================
Anand Jeyahar
https://sites.google.com/site/anandjeyahar
==============================================

The man who is really serious,
with the urge to find out what truth is,
has no style at all. He lives only in what is.
~Bruce Lee

Love is a trade with lousy accounting policies.
~Aang Jie





On Sun, Aug 21, 2011 at 23:13, nijil y <ni…@gmail.com> wrote:
> Hi,
> The error persist.The creating database works.so the autentication is also

> fine I assume.From there it gives 5 errors most reffering to modules.Am I
> supposed to install that before doing the fraamework ?
> Traceback (most recent call last):
> File "webnotes/install_lib/install.py", line 251, in <module>

> password = options.password, verbose = 1)
> File "webnotes/install_lib/install.py", line 152, in import_from_db
> self.import_core_module()
> File "webnotes/install_lib/install.py", line 64, in import_core_module

> core.sync_all(verbose=1)
> File "webnotes/modules/init.py", line 165, in sync_all
> self.sync_all_of_type('txt', verbose)
> File "webnotes/modules/init.py", line 156, in sync_all_of_type

> self.get_file(path).sync()
> File "webnotes/modules/init.py", line 262, in sync
> % (doclist[0]['doctype'], '%s'), doclist[0]['name'])
> File "webnotes/db.py", line 152, in sql

> raise e
> _mysql_exceptions.ProgrammingError: (1146, "Table 'secondcases.tabModule
> Def' doesn't exist")
>
>
> I cant figure out what this error means and that I should do. I am now

> working with master clone.
>
> –
> You received this message because you are subscribed to the Google Groups
> "Web Notes Framework Forum" group.
> To post to this group, send email to wn…@googlegroups.com.

> To unsubscribe from this group, send email to
> wnframework+un…@googlegroups.com.
> For more options, visit this group at

> http://groups.google.com/group/wnframework?hl=en.
>


–
You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.

To post to this group, send email to wn…@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un…@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.


---------------------------------------------------------------------------------

ERPNext - World's most affordable ERP - (Rs 299 / $7 per user per month)

–


You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.

To post to this group, send email to wn…@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un…@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.



–

You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

11

I have one more query,where exactly should I put the erp files in wnframework - there doesnt seem to be any installation involved

–

You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

12

Nijil,

Okay, so which sql file did you use ? ERPNext one?
For the ERPNext installation, just put the files somewhere say
/var/www/erpnext and set the modules path in defs.py. (plus run the
install command)

Anand (J),
As you must be aware, we now generate tables dynamically create tables
from DocType txt files ( notice they are more human readable now). The
DefaultValue one is here[1]. I think we have a race condition here, We
need dependency resolution of sorts, I guess.

[1] : https://github.com/webnotes/wnframework/blob/master/cgi-bin/core/doctype/defaultvalue/defaultvalue.txt

–
Pratik Vyas
Twitter : @pdvyas

ERPNext - World’s most affordable ERP - (Rs 299 / $7 per user per month)
Website: https://www.erpnext.com

–
You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

13

Anand (J),
As you must be aware, we now generate tables dynamically create tables
from DocType txt files ( notice they are more human readable now). The
DefaultValue one is here[1]. I think we have a race condition here, We
need dependency resolution of sorts, I guess.

Bad grammar, sorry!

–
You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

14

@Pratik: ya, I used the master.sql dump in erpnext. Now its working. :slight_smile: erpnext too. hope it stays that way :slight_smile:

On Mon, Aug 22, 2011 at 12:42 AM, Pratik Vyas <pd…@erpnext.com> wrote:

> Anand (J),
> As you must be aware, we now generate tables dynamically create tables
> from DocType txt files ( notice they are more human readable now). The
> DefaultValue one is here[1]. I think we have a race condition here, We
> need dependency resolution of sorts, I guess.
>
Bad grammar, sorry!

--
You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.


–

You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

15

On Mon, Aug 22, 2011 at 1:05 AM, nijil y ni...@gmail.com wrote:

@Pratik: ya, I used the master.sql dump in erpnext. Now its working. :slight_smile:
erpnext too. hope it stays that way :slight_smile:

Just a feedback of sorts, Are the install too instructions vague? Is
there any step we are missing or something? We really dont want the
installation to be a firefight :slight_smile:

–
You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

16
Hey,
Well in general if you are asking there is a bit of uncertainity about dbpassword option - is it the root pass or the dbuser pass that was created.And the apache config - it would be more helpful if the actual commands are listed and paths given in install.txt so that someone new to apache neednt have to go looking as to where to put those and how to add them. And finally the dbdumb that need to be used to get wnframework running is in erpnet download.So please add that in wnframework and include in documentation.This is what I felt :) .Hope that helped

On Mon, Aug 22, 2011 at 1:20 AM, Pratik Vyas <pd...@erpnext.com> wrote:
On Mon, Aug 22, 2011 at 1:05 AM, nijil y <ni...@gmail.com> wrote:
> @Pratik: ya, I used the master.sql dump in erpnext. Now its working. :)
> erpnext too. hope it stays that way :)

Just a feedback of sorts, Are the install too instructions vague? Is
there any step we are missing or something? We really dont want the
installation to be a firefight :)

--
You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.


–

You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

17

Thanks!

On Mon, Aug 22, 2011 at 1:28 AM, nijil y ni...@gmail.com wrote:

Hey,
Well in general if you are asking there is a bit of uncertainity about
dbpassword option - is it the root pass or the dbuser pass that was
created.

Yup, I just realized that a potential confusion is there.

And the apache config - it would be more helpful if the actual
commands are listed and paths given in install.txt so that someone new to
apache neednt have to go looking as to where to put those and how to add
them.

True. Actual set of commands ( put into a shell script ) that would
work on a pristine installation of a distro is a good idea.

And finally the dbdumb that need to be used to get wnframework running
is in erpnet download.So please add that in wnframework and include in
documentation.This is what I felt :slight_smile: .Hope that helped

Actually, the dbdump for wnframework is taken up by the install script
by default ( data/Framework.sql , in wnframework repository itself ).
Why the install script fails sometimes, appears to be a subtle
problem.

–
You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

18

Mea culpa, I forgot that the modules are imported from core.
It seems the core/doctypes are not getting updated during the login
(index.cgi?cmd=login) process.

Anyway, a hacky quick fix in install.py
is to force module.reload_doc for all doctypes under the folder core/
doctypes
immediately after the import_db.

On Aug 22, 12:12 am, Pratik Vyas pd...@erpnext.com wrote:

Anand (J),
As you must be aware, we now generate tables dynamically create tables
from DocType txt files ( notice they are more human readable now). The
DefaultValue one is here[1]. I think we have a race condition here, We
need dependency resolution of sorts, I guess.

Bad grammar, sorry!

–
You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

19
Hey,
I have a small issue now.Everytime I load index.cgi it stays on that page for like 2 seconds and then runs off to erpnext.com - why is that happening ?.

On Mon, Aug 22, 2011 at 2:34 AM, anand jeyahar <an...@gmail.com> wrote:
Mea culpa, I forgot that the modules are imported from core.
It seems the core/doctypes are not getting updated during the login
(index.cgi?cmd=login) process.

Anyway, a hacky quick fix in install.py
is to force module.reload_doc for all doctypes under the folder core/
doctypes
immediately after the import_db.

On Aug 22, 12:12 am, Pratik Vyas <pd...@erpnext.com> wrote:
> > Anand (J),
> > As you must be aware, we now generate tables dynamically create tables
> > from DocType txt files ( notice they are more human readable now). The
> > DefaultValue one is here[1]. I think we have a race condition here, We
> > need dependency resolution of sorts, I guess.
>
> Bad grammar, sorry!

--
You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.


–

You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

20
Run this in your db

delete from tabSingles where field='sync_with_gateway'

Sorry - this is setup for our Saas model. (note: remove this in the repos)




On Aug 22, 2011, at 8:12 AM, nijil y wrote:

Hey,
I have a small issue now.Everytime I load index.cgi it stays on that page for like 2 seconds and then runs off to erpnext.com - why is that happening ?.

On Mon, Aug 22, 2011 at 2:34 AM, anand jeyahar <an...@gmail.com> wrote:
Mea culpa, I forgot that the modules are imported from core.
It seems the core/doctypes are not getting updated during the login
(index.cgi?cmd=login) process.

Anyway, a hacky quick fix in install.py
is to force module.reload_doc for all doctypes under the folder core/
doctypes
immediately after the import_db.

On Aug 22, 12:12 am, Pratik Vyas <pd...@erpnext.com> wrote:
> > Anand (J),
> > As you must be aware, we now generate tables dynamically create tables
> > from DocType txt files ( notice they are more human readable now). The
> > DefaultValue one is here[1]. I think we have a race condition here, We
> > need dependency resolution of sorts, I guess.
>
> Bad grammar, sorry!

--
You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.



--
You received this message because you are subscribed to the Google Groups "Web Notes Framework Forum" group.
To post to this group, send email to wn...@googlegroups.com.
To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.

---------------------------------------------------------------------------------
ERPNext - World's most affordable ERP - (Rs 299 / $7 per user per month)

Twitter: @rushabh_mehta

–

You received this message because you are subscribed to the Google Groups “Web Notes Framework Forum” group.

To post to this group, send email to wn...@googlegroups.com.

To unsubscribe from this group, send email to wnframework+un...@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/wnframework?hl=en.