Updated appliances or web2py blog?

[LoveWeb2py]

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!

[Paolo Valleri]

Have a look at http://www.web2pyslices.com/home

It is built on top of https://github.com/rochacbruno/Movuca

Paolo

[Austin Taylor]

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

--
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+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Paolo Valleri]

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

[Niphlod]

the solution to the problem is investigating what leads to a foreign key error, not to work with an inconsistent backend....

[Paolo Valleri]

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