Problem with setup of Poderopedia

[vsusarla]

Hi Folks,

I am getting a

ProgrammingError: ('ERROR', '42P01', 'relation "auth_user" does not exist') when I try to run the poderopedia application from http://localhost:8000/admin/default/site.

The traceback shows (among many others), this line

File "C:\Program Files\AIA\Project\web2py\applications\poderopedia\models\db_colaboracion.py", line 15, in

When change the migrate = True to False in the db_colaboracion.py (table name: actualizacion)

It create the table, but I get another error

ERROR', '42P01', 'relation "plugin_stats" does not exist'). I am a newbie and have limited knowledge of web2py and poderopedia. Any help would be greatly appreciated

[juaneduardo]

Hi vsusarla:

What database are you using for the backend? Is sqlite?
The perfomance of sqlite doesn't well in a concurrency model. We recomend that you use another database such as postgresql or mysql.

Also, I think that you have a prior version of plug and play installed. You must update the repo from github....

Feel free to send questions

[vsusarla]

Hi Juan,

Thank you very much for the response!

I have Postgres as my DB. I have downloaded the zip of the latest version (after the last update). I looked at the models and the db.py has no mention of the table (which I think what 'relation' means in the error) user_auth. The same version has had a smooth installation in a linux system.

As I said I am a newbie and might be missing something very trivial.

Thanks a lot for your help!

Regards,
Venkat

[ericjze]

I talked with Venkat and he is switching his development platform to ubuntu. Here are the steps to get poderopedia up and running:

cd /home/venkat/
wget http://www.web2py.com/examples/static/web2py_src.zip
unzip web2py_src.zip
cd web2py/scripts/
chmod +x setup-web2py-nginx-uwsgi-ubuntu.sh
sudo ./setup-web2py-nginx-uwsgi-ubuntu.sh
cd /home/www-data/web2py/
sudo cp parameters_443.py parameters_80.py
sudo -u postgres createdb poderopediadatabase
sudo chown -R www-data /home/www-data/web2py/
cd /home/www-data/web2py/applications
sudo git clone https://github.com/poderopedia/plug-and-play-1.0-RC.git
cd plug-and-play-1.0-RC
sudo mv * ../
sudo mkdir /home/www-data/web2py/applications/template_app/uploads
sudo ln -s /home/www-data/web2py/applications/template_app/uploads /home/www-data/web2py/applications/admin_app/uploads

Then:
change migrate.settings in admin_app & template_app 0.py's from True to False

[juaneduardo]

Hi Venkat, have you solved the issues or is still open?