[web2py] Re: plugin wiki issues
David-
No dice. Still getting the same errors. It does not want to create the
tables in my MySQL database. I've made sure the settings are as you
stated. These are things I've already done, but just got into the office
today and retried them.
On Friday, May 4, 2012 5:49:46 PM UTC-4, villas wrote:
Hi Larry
Generating tables is a general thing, not just for the plugin_wiki. As
you obviously do not have any data in your plugin_wiki yet, I suggest:
1. Get yourself a DB management tool for your DB.
2. Using the tool, have a look in the DB. If you are using Sqlite,
you should find it here: yourapp/databases/storage.sqlite, are there any
plugin_wiki tables in there? If so, drop them.
3. Look in the yourapp/databases folder. Do you see .table files with
plugin_wiki in the filename? If so, delete them.
4. Make sure that there are NO settings for migrate=False in your
db.py. For example,
db = DAL('sqlite://storage.sqlite', migrate=False)
db = DAL(...,migrate_enabled=False)
5. Access any page in your app. This should now generate the tables.
I appreciate that step one is a bit of a hassle, but it is so useful to
be able to look inside your DB that I think it is well worth the effort.
You should be able to find something easily on google, especially if you
are using Sqlite.
Regards, David
On Friday, 4 May 2012 20:12:25 UTC+1, Larry Wapnitsky wrote:
It looks as though the database table generation does not automatically
take place unless you use the wizard.
How can I initiate this and get the plugin active? The book doesn't
really give great details on that.
Thanks
On Friday, May 4, 2012 2:38:51 PM UTC-4, villas wrote:
1. *class 'gluon.contrib.pymysql.err.ProgrammingError' (1146,
uTable 'rbl.plugin_wiki_page' doesn't exist*
Sounds like a migration error. Do you have the tables in your DB? If
not, make sure you delete plugin_wiki table defs from the databases folder
so that they can be created
2. when loading the plugin in a brand-new app, I don't see any
additional menu called pages.
I think you have to be logged in with either user.id == 1 or role ==
'editor'.
Hope that helps, David
[web2py] Re: plugin wiki issues
Hmm keep trying...
Check you have appropriate read/write permissions from your host.
Connect with your DB management tool and create a test table to make sure
your DB server etc is running.
Take one single table definition, let's call it 'yourexample'.
Make sure there is no yourexample.table file in the yourapp/databases
folder.
Delete (or comment out) any migrate or fake_migrate settings on your
define_table function (migrate has a default of True).
Make sure there are no countering migration settings on the DAL connection.
Make sure there are no fake_migration settings anywhere.
Run python web2py.py -N -M -S yourapp to start web2py
Are there any error messages?
On Tuesday, 8 May 2012 14:51:45 UTC+1, Larry Wapnitsky wrote:
David-
No dice. Still getting the same errors. It does not want to create the
tables in my MySQL database. I've made sure the settings are as you
stated. These are things I've already done, but just got into the office
today and retried them.
On Friday, May 4, 2012 5:49:46 PM UTC-4, villas wrote:
Hi Larry
Generating tables is a general thing, not just for the plugin_wiki. As
you obviously do not have any data in your plugin_wiki yet, I suggest:
1. Get yourself a DB management tool for your DB.
2. Using the tool, have a look in the DB. If you are using Sqlite,
you should find it here: yourapp/databases/storage.sqlite, are there
any
plugin_wiki tables in there? If so, drop them.
3. Look in the yourapp/databases folder. Do you see .table files
with plugin_wiki in the filename? If so, delete them.
4. Make sure that there are NO settings for migrate=False in your
db.py. For example,
db = DAL('sqlite://storage.sqlite', migrate=False)
db = DAL(...,migrate_enabled=False)
5. Access any page in your app. This should now generate the tables.
I appreciate that step one is a bit of a hassle, but it is so useful to
be able to look inside your DB that I think it is well worth the effort.
You should be able to find something easily on google, especially if you
are using Sqlite.
Regards, David
On Friday, 4 May 2012 20:12:25 UTC+1, Larry Wapnitsky wrote:
It looks as though the database table generation does not automatically
take place unless you use the wizard.
How can I initiate this and get the plugin active? The book doesn't
really give great details on that.
Thanks
On Friday, May 4, 2012 2:38:51 PM UTC-4, villas wrote:
1. *class 'gluon.contrib.pymysql.err.ProgrammingError' (1146,
uTable 'rbl.plugin_wiki_page' doesn't exist*
Sounds like a migration error. Do you have the tables in your DB? If
not, make sure you delete plugin_wiki table defs from the databases
folder
so that they can be created
2. when loading the plugin in a brand-new app, I don't see any
additional menu called pages.
I think you have to be logged in with either user.id == 1 or role ==
'editor'.
Hope that helps, David
[web2py] Re: plugin wiki issues
In order:
Yes
Yes
No existing tables
Files don't exist
migration settings removed
Only error message from running web2py that way: WARNING:web2py:import
IPython error; use default python shell
On Tuesday, May 8, 2012 10:50:38 AM UTC-4, villas wrote:
Hmm keep trying...
Check you have appropriate read/write permissions from your host.
Connect with your DB management tool and create a test table to make sure
your DB server etc is running.
Take one single table definition, let's call it 'yourexample'.
Make sure there is no yourexample.table file in the yourapp/databases
folder.
Delete (or comment out) any migrate or fake_migrate settings on your
define_table function (migrate has a default of True).
Make sure there are no countering migration settings on the DAL
connection.
Make sure there are no fake_migration settings anywhere.
Run python web2py.py -N -M -S yourapp to start web2py
Are there any error messages?
On Tuesday, 8 May 2012 14:51:45 UTC+1, Larry Wapnitsky wrote:
David-
No dice. Still getting the same errors. It does not want to create the
tables in my MySQL database. I've made sure the settings are as you
stated. These are things I've already done, but just got into the office
today and retried them.
On Friday, May 4, 2012 5:49:46 PM UTC-4, villas wrote:
Hi Larry
Generating tables is a general thing, not just for the plugin_wiki. As
you obviously do not have any data in your plugin_wiki yet, I suggest:
1. Get yourself a DB management tool for your DB.
2. Using the tool, have a look in the DB. If you are using Sqlite,
you should find it here: yourapp/databases/storage.sqlite, are there
any
plugin_wiki tables in there? If so, drop them.
3. Look in the yourapp/databases folder. Do you see .table files
with plugin_wiki in the filename? If so, delete them.
4. Make sure that there are NO settings for migrate=False in your
db.py. For example,
db = DAL('sqlite://storage.sqlite', migrate=False)
db = DAL(...,migrate_enabled=False)
5. Access any page in your app. This should now generate the tables.
I appreciate that step one is a bit of a hassle, but it is so useful to
be able to look inside your DB that I think it is well worth the effort.
You should be able to find something easily on google, especially if you
are using Sqlite.
Regards, David
On Friday, 4 May 2012 20:12:25 UTC+1, Larry Wapnitsky wrote:
It looks as though the database table generation does not automatically
take place unless you use the wizard.
How can I initiate this and get the plugin active? The book doesn't
really give great details on that.
Thanks
On Friday, May 4, 2012 2:38:51 PM UTC-4, villas wrote:
1. *class 'gluon.contrib.pymysql.err.ProgrammingError' (1146,
uTable 'rbl.plugin_wiki_page' doesn't exist*
Sounds like a migration error. Do you have the tables in your DB?
If not, make sure you delete plugin_wiki table defs from the databases
folder so that they can be created
2. when loading the plugin in a brand-new app, I don't see any
additional menu called pages.
I think you have to be logged in with either user.id == 1 or role ==
'editor'.
Hope that helps, David
[web2py] Re: plugin wiki issues
I guess it still didn't work then. At this point [scratching head]: Consider upgrading your web2py. Create a brand new app to test the most basic DB function is there. Delete contents of the databases folder. Change the DAL connection string in db.py Put a simple table def in the db.py Run your app, check whether there are *.table files in the databases folder, and real tables in the DB. If not, I suggest posting your DB connection string (needless to say change the passwd), and define_table function here. Sorry if I'm missing something obvious, maybe someone else also has some better advice to get this working. Regards, D
[web2py] Re: plugin wiki issues
A new, test app worked with no problems.
Here is my DAL DB connection string: db =
DAL('mysql://user:passw...@dbserer.company.com/dbname')
I was getting can't create table errors until I added grant rights to
the remote user account. Now, the page just spins...
On Tuesday, May 8, 2012 4:06:05 PM UTC-4, villas wrote:
I guess it still didn't work then. At this point [scratching head]:
Consider upgrading your web2py.
Create a brand new app to test the most basic DB function is there.
Delete contents of the databases folder.
Change the DAL connection string in db.py
Put a simple table def in the db.py
Run your app, check whether there are *.table files in the databases
folder, and real tables in the DB.
If not, I suggest posting your DB connection string (needless to say
change the passwd), and define_table function here.
Sorry if I'm missing something obvious, maybe someone else also has some
better advice to get this working.
Regards, D
[web2py] Re: plugin wiki issues
restarted web2py. no dice. died immediately when accessing any page
class 'gluon.contrib.pymysql.err.InternalError' (1005, uCan't create
table 'rbl.plugin_wiki_page' (errno: 150))
On Tuesday, May 8, 2012 4:16:50 PM UTC-4, Larry Wapnitsky wrote:
A new, test app worked with no problems.
Here is my DAL DB connection string: db = DAL('mysql://
user:passw...@dbserer.company.com/dbname')
I was getting can't create table errors until I added grant rights to
the remote user account. Now, the page just spins...
On Tuesday, May 8, 2012 4:06:05 PM UTC-4, villas wrote:
I guess it still didn't work then. At this point [scratching head]:
Consider upgrading your web2py.
Create a brand new app to test the most basic DB function is there.
Delete contents of the databases folder.
Change the DAL connection string in db.py
Put a simple table def in the db.py
Run your app, check whether there are *.table files in the databases
folder, and real tables in the DB.
If not, I suggest posting your DB connection string (needless to say
change the passwd), and define_table function here.
Sorry if I'm missing something obvious, maybe someone else also has some
better advice to get this working.
Regards, D
[web2py] Re: plugin wiki issues
Hi Larry, it sounds like your DB is not configured properly for your
username. I don't use MySql but maybe this prob sounds familiar to those
that do. Anyone?
Sorry I can't think of anything more
D
On Tuesday, 8 May 2012 21:16:50 UTC+1, Larry Wapnitsky wrote:
A new, test app worked with no problems.
Here is my DAL DB connection string: db = DAL('mysql://
user:passw...@dbserer.company.com/dbname')
I was getting can't create table errors until I added grant rights to
the remote user account. Now, the page just spins...
On Tuesday, May 8, 2012 4:06:05 PM UTC-4, villas wrote:
I guess it still didn't work then. At this point [scratching head]:
Consider upgrading your web2py.
Create a brand new app to test the most basic DB function is there.
Delete contents of the databases folder.
Change the DAL connection string in db.py
Put a simple table def in the db.py
Run your app, check whether there are *.table files in the databases
folder, and real tables in the DB.
If not, I suggest posting your DB connection string (needless to say
change the passwd), and define_table function here.
Sorry if I'm missing something obvious, maybe someone else also has some
better advice to get this working.
Regards, D
Re: [web2py] Re: plugin wiki issues
It's been working up to this point...not sure why it won't work now...
On 5/8/2012 4:25 PM, villas wrote:
Hi Larry, it sounds like your DB is not configured properly for your
username. I don't use MySql but maybe this prob sounds familiar to
those that do. Anyone?
Sorry I can't think of anything more
D
On Tuesday, 8 May 2012 21:16:50 UTC+1, Larry Wapnitsky wrote:
A new, test app worked with no problems.
Here is my DAL DB connection string: db =
DAL('mysql://user:passw...@dbserer.company.com/dbname
http://user:passw...@dbserer.company.com/dbname')
I was getting can't create table errors until I added grant
rights to the remote user account. Now, the page just spins...
On Tuesday, May 8, 2012 4:06:05 PM UTC-4, villas wrote:
I guess it still didn't work then. At this point [scratching
head]:
Consider upgrading your web2py.
Create a brand new app to test the most basic DB function is
there.
Delete contents of the databases folder.
Change the DAL connection string in db.py
Put a simple table def in the db.py
Run your app, check whether there are *.table files in the
databases folder, and real tables in the DB.
If not, I suggest posting your DB connection string (needless
to say change the passwd), and define_table function here.
Sorry if I'm missing something obvious, maybe someone else
also has some better advice to get this working.
Regards, D
Re: [web2py] Re: plugin wiki issues
and it just worked on my test db server with the exact same config..
On 5/8/2012 4:25 PM, villas wrote:
Hi Larry, it sounds like your DB is not configured properly for your
username. I don't use MySql but maybe this prob sounds familiar to
those that do. Anyone?
Sorry I can't think of anything more
D
On Tuesday, 8 May 2012 21:16:50 UTC+1, Larry Wapnitsky wrote:
A new, test app worked with no problems.
Here is my DAL DB connection string: db =
DAL('mysql://user:passw...@dbserer.company.com/dbname
http://user:passw...@dbserer.company.com/dbname')
I was getting can't create table errors until I added grant
rights to the remote user account. Now, the page just spins...
On Tuesday, May 8, 2012 4:06:05 PM UTC-4, villas wrote:
I guess it still didn't work then. At this point [scratching
head]:
Consider upgrading your web2py.
Create a brand new app to test the most basic DB function is
there.
Delete contents of the databases folder.
Change the DAL connection string in db.py
Put a simple table def in the db.py
Run your app, check whether there are *.table files in the
databases folder, and real tables in the DB.
If not, I suggest posting your DB connection string (needless
to say change the passwd), and define_table function here.
Sorry if I'm missing something obvious, maybe someone else
also has some better advice to get this working.
Regards, D
Re: [web2py] Re: plugin wiki issues
nix that last comment...didn't have the plugin loaded. did not work
On 5/8/2012 4:25 PM, villas wrote:
Hi Larry, it sounds like your DB is not configured properly for your
username. I don't use MySql but maybe this prob sounds familiar to
those that do. Anyone?
Sorry I can't think of anything more
D
On Tuesday, 8 May 2012 21:16:50 UTC+1, Larry Wapnitsky wrote:
A new, test app worked with no problems.
Here is my DAL DB connection string: db =
DAL('mysql://user:passw...@dbserer.company.com/dbname
http://user:passw...@dbserer.company.com/dbname')
I was getting can't create table errors until I added grant
rights to the remote user account. Now, the page just spins...
On Tuesday, May 8, 2012 4:06:05 PM UTC-4, villas wrote:
I guess it still didn't work then. At this point [scratching
head]:
Consider upgrading your web2py.
Create a brand new app to test the most basic DB function is
there.
Delete contents of the databases folder.
Change the DAL connection string in db.py
Put a simple table def in the db.py
Run your app, check whether there are *.table files in the
databases folder, and real tables in the DB.
If not, I suggest posting your DB connection string (needless
to say change the passwd), and define_table function here.
Sorry if I'm missing something obvious, maybe someone else
also has some better advice to get this working.
Regards, D
Re: [web2py] Re: plugin wiki issues
even tried it as rootno dice.
On 5/8/2012 4:25 PM, villas wrote:
Hi Larry, it sounds like your DB is not configured properly for your
username. I don't use MySql but maybe this prob sounds familiar to
those that do. Anyone?
Sorry I can't think of anything more
D
On Tuesday, 8 May 2012 21:16:50 UTC+1, Larry Wapnitsky wrote:
A new, test app worked with no problems.
Here is my DAL DB connection string: db =
DAL('mysql://user:passw...@dbserer.company.com/dbname
http://user:passw...@dbserer.company.com/dbname')
I was getting can't create table errors until I added grant
rights to the remote user account. Now, the page just spins...
On Tuesday, May 8, 2012 4:06:05 PM UTC-4, villas wrote:
I guess it still didn't work then. At this point [scratching
head]:
Consider upgrading your web2py.
Create a brand new app to test the most basic DB function is
there.
Delete contents of the databases folder.
Change the DAL connection string in db.py
Put a simple table def in the db.py
Run your app, check whether there are *.table files in the
databases folder, and real tables in the DB.
If not, I suggest posting your DB connection string (needless
to say change the passwd), and define_table function here.
Sorry if I'm missing something obvious, maybe someone else
also has some better advice to get this working.
Regards, D
Re: [web2py] Re: plugin wiki issues
if I recreate the database from scratch, then re-import my data, it works
fine.
On Tuesday, May 8, 2012 4:33:54 PM UTC-4, Larry Wapnitsky wrote:
even tried it as rootno dice.
On 5/8/2012 4:25 PM, villas wrote:
Hi Larry, it sounds like your DB is not configured properly for your
username. I don't use MySql but maybe this prob sounds familiar to those
that do. Anyone?
Sorry I can't think of anything more
D
On Tuesday, 8 May 2012 21:16:50 UTC+1, Larry Wapnitsky wrote:
A new, test app worked with no problems.
Here is my DAL DB connection string: db = DAL('mysql://
user:passw...@dbserer.company.com/dbname')
I was getting can't create table errors until I added grant rights
to the remote user account. Now, the page just spins...
On Tuesday, May 8, 2012 4:06:05 PM UTC-4, villas wrote:
I guess it still didn't work then. At this point [scratching head]:
Consider upgrading your web2py.
Create a brand new app to test the most basic DB function is there.
Delete contents of the databases folder.
Change the DAL connection string in db.py
Put a simple table def in the db.py
Run your app, check whether there are *.table files in the databases
folder, and real tables in the DB.
If not, I suggest posting your DB connection string (needless to say
change the passwd), and define_table function here.
Sorry if I'm missing something obvious, maybe someone else also has
some better advice to get this working.
Regards, D
Re: [web2py] Re: plugin wiki issues
:-)
On Tuesday, 8 May 2012 21:37:52 UTC+1, Larry Wapnitsky wrote:
if I recreate the database from scratch, then re-import my data, it works
fine.
On Tuesday, May 8, 2012 4:33:54 PM UTC-4, Larry Wapnitsky wrote:
even tried it as rootno dice.
On 5/8/2012 4:25 PM, villas wrote:
Hi Larry, it sounds like your DB is not configured properly for your
username. I don't use MySql but maybe this prob sounds familiar to those
that do. Anyone?
Sorry I can't think of anything more
D
On Tuesday, 8 May 2012 21:16:50 UTC+1, Larry Wapnitsky wrote:
A new, test app worked with no problems.
Here is my DAL DB connection string: db = DAL('mysql://
user:passw...@dbserer.company.com/dbname')
I was getting can't create table errors until I added grant rights
to the remote user account. Now, the page just spins...
On Tuesday, May 8, 2012 4:06:05 PM UTC-4, villas wrote:
I guess it still didn't work then. At this point [scratching head]:
Consider upgrading your web2py.
Create a brand new app to test the most basic DB function is there.
Delete contents of the databases folder.
Change the DAL connection string in db.py
Put a simple table def in the db.py
Run your app, check whether there are *.table files in the databases
folder, and real tables in the DB.
If not, I suggest posting your DB connection string (needless to say
change the passwd), and define_table function here.
Sorry if I'm missing something obvious, maybe someone else also has
some better advice to get this working.
Regards, D
[web2py] Re: plugin wiki issues
1. *class 'gluon.contrib.pymysql.err.ProgrammingError' (1146, uTable 'rbl.plugin_wiki_page' doesn't exist* Sounds like a migration error. Do you have the tables in your DB? If not, make sure you delete plugin_wiki table defs from the databases folder so that they can be created 2. when loading the plugin in a brand-new app, I don't see any additional menu called pages. I think you have to be logged in with either user.id == 1 or role == 'editor'. Hope that helps, David
[web2py] Re: plugin wiki issues
It looks as though the database table generation does not automatically take place unless you use the wizard. How can I initiate this and get the plugin active? The book doesn't really give great details on that. Thanks On Friday, May 4, 2012 2:38:51 PM UTC-4, villas wrote: 1. *class 'gluon.contrib.pymysql.err.ProgrammingError' (1146, uTable 'rbl.plugin_wiki_page' doesn't exist* Sounds like a migration error. Do you have the tables in your DB? If not, make sure you delete plugin_wiki table defs from the databases folder so that they can be created 2. when loading the plugin in a brand-new app, I don't see any additional menu called pages. I think you have to be logged in with either user.id == 1 or role == 'editor'. Hope that helps, David
[web2py] Re: plugin wiki issues
Hi Larry
Generating tables is a general thing, not just for the plugin_wiki. As
you obviously do not have any data in your plugin_wiki yet, I suggest:
1. Get yourself a DB management tool for your DB.
2. Using the tool, have a look in the DB. If you are using Sqlite,
you should find it here: yourapp/databases/storage.sqlite, are there any
plugin_wiki tables in there? If so, drop them.
3. Look in the yourapp/databases folder. Do you see .table files with
plugin_wiki in the filename? If so, delete them.
4. Make sure that there are NO settings for migrate=False in your db.py.
For example,
db = DAL('sqlite://storage.sqlite', migrate=False)
db = DAL(...,migrate_enabled=False)
5. Access any page in your app. This should now generate the tables.
I appreciate that step one is a bit of a hassle, but it is so useful to be
able to look inside your DB that I think it is well worth the effort. You
should be able to find something easily on google, especially if you are
using Sqlite.
Regards, David
On Friday, 4 May 2012 20:12:25 UTC+1, Larry Wapnitsky wrote:
It looks as though the database table generation does not automatically
take place unless you use the wizard.
How can I initiate this and get the plugin active? The book doesn't
really give great details on that.
Thanks
On Friday, May 4, 2012 2:38:51 PM UTC-4, villas wrote:
1. *class 'gluon.contrib.pymysql.err.ProgrammingError' (1146,
uTable 'rbl.plugin_wiki_page' doesn't exist*
Sounds like a migration error. Do you have the tables in your DB? If
not, make sure you delete plugin_wiki table defs from the databases folder
so that they can be created
2. when loading the plugin in a brand-new app, I don't see any
additional menu called pages.
I think you have to be logged in with either user.id == 1 or role ==
'editor'.
Hope that helps, David
