Re: [web2py] Re: Updated appliances or web2py blog?
Movuca hasn't received updated for a while. Recent web2py forces sqlite with PRAGMA foreign_keys=ON; which is the reason of the error. If you wanna just try movuca, the easiest solution I suggest is revert that change, see https://github.com/web2py/web2py/blob/master/gluon/dal/adapters/sqlite.py#L87 Paolo 2015-01-13 0:30 GMT+01:00 Austin Taylor atayloru...@gmail.com: Hi Paolo, Thank you for the recommendation. I followed the instructions on the Movuca web page, but this install fails right out of the box File applications\at_blog\modules\movuca.py, line 51, in define_classes obj = cls(self) File applications\at_blog\modules\basemodel.py, line 51, in __init__ self.pre_load() File applications\at_blog\modules\basemodel.py, line 111, in pre_load self.__getattribute__(method)() File applications\at_blog\modules\datamodel\article.py, line 192, in set_fixtures content_type=self.db(self.db.content_type.identifier == 'Article').select().first().id File C:\web2py_src\web2py\gluon\dal.py, line 9317, in insert ret = self._db._adapter.insert(self, self._listify(fields)) File C:\web2py_src\web2py\gluon\dal.py, line 1361, in insert raise e IntegrityError: foreign key constraint failed Using web2py 2.9.11 On Mon, Jan 12, 2015 at 5:22 AM, Paolo Valleri paolo.vall...@gmail.com wrote: Have a look at http://www.web2pyslices.com/home It is built on top of https://github.com/rochacbruno/Movuca Paolo On Sunday, January 11, 2015 at 10:12:08 PM UTC+1, LoveWeb2py wrote: Hello, I'm looking to implement a nice blog for my site. I'd like to use a web2py appliance if there is one available. I went through the old appliances but they all seem fairly old. Is there an site which has a list of all the current web2py projects or more specifically blogs that I could import? Thanks! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to a topic in the Google Groups web2py-users group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/tq1to20yf2w/unsubscribe. To unsubscribe from this group and all its topics, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to a topic in the Google Groups web2py-users group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/tq1to20yf2w/unsubscribe. To unsubscribe from this group and all its topics, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] Re: Updated appliances or web2py blog?
the solution to the problem is investigating what leads to a foreign key error, not to work with an inconsistent backend On Tuesday, January 13, 2015 at 12:17:06 PM UTC+1, Paolo Valleri wrote: Movuca hasn't received updated for a while. Recent web2py forces sqlite with PRAGMA foreign_keys=ON; which is the reason of the error. If you wanna just try movuca, the easiest solution I suggest is revert that change, see https://github.com/web2py/web2py/blob/master/gluon/dal/adapters/sqlite.py#L87 Paolo -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] Re: Updated appliances or web2py blog?
If you want to dive into movuca, the table article_category contains modified_by and created_by fields, which are set to NULL when movuca creates the first empty generic category for articles. that's all. Paolo 2015-01-13 13:42 GMT+01:00 Niphlod niph...@gmail.com: the solution to the problem is investigating what leads to a foreign key error, not to work with an inconsistent backend On Tuesday, January 13, 2015 at 12:17:06 PM UTC+1, Paolo Valleri wrote: Movuca hasn't received updated for a while. Recent web2py forces sqlite with PRAGMA foreign_keys=ON; which is the reason of the error. If you wanna just try movuca, the easiest solution I suggest is revert that change, see https://github.com/web2py/web2py/blob/master/gluon/dal/ adapters/sqlite.py#L87 Paolo -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to a topic in the Google Groups web2py-users group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/tq1to20yf2w/unsubscribe. To unsubscribe from this group and all its topics, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[web2py] Re: Updated appliances or web2py blog?
Have a look at http://www.web2pyslices.com/home It is built on top of https://github.com/rochacbruno/Movuca Paolo On Sunday, January 11, 2015 at 10:12:08 PM UTC+1, LoveWeb2py wrote: Hello, I'm looking to implement a nice blog for my site. I'd like to use a web2py appliance if there is one available. I went through the old appliances but they all seem fairly old. Is there an site which has a list of all the current web2py projects or more specifically blogs that I could import? Thanks! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] Re: Updated appliances or web2py blog?
Hi Paolo, Thank you for the recommendation. I followed the instructions on the Movuca web page, but this install fails right out of the box File applications\at_blog\modules\movuca.py, line 51, in define_classes obj = cls(self) File applications\at_blog\modules\basemodel.py, line 51, in __init__ self.pre_load() File applications\at_blog\modules\basemodel.py, line 111, in pre_load self.__getattribute__(method)() File applications\at_blog\modules\datamodel\article.py, line 192, in set_fixtures content_type=self.db(self.db.content_type.identifier == 'Article').select().first().id File C:\web2py_src\web2py\gluon\dal.py, line 9317, in insert ret = self._db._adapter.insert(self, self._listify(fields)) File C:\web2py_src\web2py\gluon\dal.py, line 1361, in insert raise e IntegrityError: foreign key constraint failed Using web2py 2.9.11 On Mon, Jan 12, 2015 at 5:22 AM, Paolo Valleri paolo.vall...@gmail.com wrote: Have a look at http://www.web2pyslices.com/home It is built on top of https://github.com/rochacbruno/Movuca Paolo On Sunday, January 11, 2015 at 10:12:08 PM UTC+1, LoveWeb2py wrote: Hello, I'm looking to implement a nice blog for my site. I'd like to use a web2py appliance if there is one available. I went through the old appliances but they all seem fairly old. Is there an site which has a list of all the current web2py projects or more specifically blogs that I could import? Thanks! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to a topic in the Google Groups web2py-users group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/tq1to20yf2w/unsubscribe. To unsubscribe from this group and all its topics, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.