[web2py] Re: Mixing/supporting CMS with Web2py
On Fri, 11 Nov 2011 05:23:24 -0800 (PST) kenji4569 wrote: > I cannot help presenting my developing plugin, which has a concrete5- > like wysiwyg functionality: Wow! This looks very interesting. > Although it's very experimental and plenty remains to be done, the > core logic may be closely related to this discussions. Now the question is we can come to some consensus about what kind of CMS platform we want to build for Web2py, or as Massimo wrote: "list of features". I know that's it probably hard to make it "one size fits all", but I still believe that ONE robust CMS which enables to easily convert HTML/CSS/JS template into native one (theming/skinning), inline editing using custom content blocks etc. would be much better than having dozen of half-or-more-baked solutions. However, for such a thing we need to hear the voice of web2py giants. ;) Sincerely, Gour -- One who restrains his senses, keeping them under full control, and fixes his consciousness upon Me, is known as a man of steady intelligence. http://atmarama.net | Hlapicina (Croatia) | GPG: 52B5C810 signature.asc Description: PGP signature
[web2py] Re: Mixing/supporting CMS with Web2py
On Fri, 11 Nov 2011 14:34:32 -0800 (PST) Michael Ellis wrote: > For a site like this, the CMS feature that's needed most is to make it > dead simple for others to edit text and insert images for upcoming > concerts and have it come out in fonts and colors that are consistent > throughout the site and without messing up things that should be > centralized in the db (e.g. concert dates, ticket prices, soloist > bios, etc.) Have you tried Concrete5 (http://www.concrete5.org/) until we make web2py-based one... Sincerely, Gour -- When your intelligence has passed out of the dense forest of delusion, you shall become indifferent to all that has been heard and all that is to be heard. http://atmarama.net | Hlapicina (Croatia) | GPG: 52B5C810 signature.asc Description: PGP signature
Re: [web2py] Re: Issue Tracker and web interface for Mercurial
if apis are so broken shouldn't we just use hg commands directly (like hgeclipse did?) On Fri, Nov 11, 2011 at 2:20 PM, Gour wrote: > > it is really annoying that the mercurial apis are poorly documented > > and broke already 3 times with mercurial updates. > > Have you seen: > > http://article.gmane.org/gmane.comp.version-control.mercurial.general/28839 > > > Sincerely, > Gour > > > -- > One who restrains his senses, keeping them under full control, > and fixes his consciousness upon Me, is known as a man of > steady intelligence. > > http://atmarama.net | Hlapicina (Croatia) | GPG: 52B5C810 >
[web2py] GAE & unit testing in web2py
Hello, I am trying to migrate an application from MySQL relational database to GAE & Datastore. Could you please suggest how do I perform unit testing with GAE? Before I was following this tutorial and it worked great: http://web2py.com/AlterEgo/default/show/260 I am sure it can be done in a similar way with dev_appserver.py, but can't figure out how. Thanks for your help! Best regards, Andrei Matveyeu
[web2py] Re: Unwanted submit on checkbox click ?
maybe ;return false; at the end of _onclick (after the alert). false will indicate that the event did not complete and so Javascript will not post/submit. On Nov 11, 2:54 pm, BrendanC wrote: > I'm building a dynamic table with a checkbox in each row with the code > below. The table displays correctly and html looks ok. > However when I click on any checkbox, the page is being submitted - not > sure why. > Any suggestions? > > for item in imgtags: > s = [[item.name , '' %item.name]] > chbx = (INPUT( _type='checkbox', _name= 'chk%s' %item.name, > _onclick="alert(this.checked)")) > arr.append ([[item.name],[ chbx]]) > > return XML(TABLE(*[TR(*r) for r in arr], _id = 'tagtable')) > > BrendanC
[web2py] Re: Adding a column to the SQLFORM.grid table - one way to do it
Anthony, Thanks for the pointer. Much better. Cliff Kachinske On Nov 11, 10:50 pm, Anthony wrote: > Also, using the .element() and .elements() methods provides some powerful > options for searching the DOM -- > seehttp://web2py.com/book/default/chapter/05#Server-side-DOM-and-Parsing. > > Anthony > > > > > > > > On Friday, November 11, 2011 5:37:52 PM UTC-5, Cliff wrote: > > > Props to Richard Vezina for posting a similar technique. This is > > built on his post > > > From the book we know that, "Components' objects can be referenced via > > their position, and helpers act as lists with respect to their > > components." > > > A little archaeology in the source code tells us that SQLFORM.grid > > emits a DIV object. When there's an index table involved, the DIV has > > three components: a DIV, a DIV containing a TABLE and another DIV. > > > # first we get the grid > > grid = SQLFORM.grid(query) > > > # examine the div at the top of the grid div > > # for index lists, this div is of the class 'console', > > # so look for 'console' near the start of the div > > # there is CERTAINLY a better way to detect an index table, but > > this works > > if 'console' in str(grid[0])[0:35]: > > ## grid[1][0][1] is the DIV, TABLE and TBODY > > ## so we iterate over TRs in the table body > > for row in grid[1][0][1]: > > ## TR acts like a list, so we use some Python list fu > > row.insert(-1, 'foo') > > return dict(grid=grid) > > > Done. Haven't cleaned up the table head yet, but it should be > > similar.
[web2py] Re: Mixing/supporting CMS with Web2py
Thanks, Gour. It's a nice looking framework and seems to be well- designed. I look forward to the web2py version! On Nov 12, 3:12 am, Gour wrote: > On Fri, 11 Nov 2011 14:34:32 -0800 (PST) > Michael Ellis > wrote: > > > For a site like this, the CMS feature that's needed most is to make it > > dead simple for others to edit text and insert images for upcoming > > concerts and have it come out in fonts and colors that are consistent > > throughout the site and without messing up things that should be > > centralized in the db (e.g. concert dates, ticket prices, soloist > > bios, etc.) > > Have you tried Concrete5 (http://www.concrete5.org/) until we make > web2py-based one... >
[web2py] Using web2py with a non-managed Oracle database
We are considering using Web2Py as one of the front ends for a departmental database project based on Oracle. Since the Oracle database is independently managed, we need to turn off migration and use (I assume) the "legacy table" feature mentioned in Chapter 6 of the book--which is not currently supported for Oracle. How easy is that to add? I think we will also want to write an "extract_oracle_models.py" script along the lines of the extract scripts in the Web2Py scripts directory. Has anyone else done/attempted this? Tim Korb
[web2py] Re: Adding a column to the SQLFORM.grid table - one way to do it
Here is a better way to do it, though:
links = [ lambda row:
A(
SPAN(_class='icon plus'),
SPAN(_class='buttontext button',
_title='Create PO',),
'Create PO',
_href = URL(
'purchase_orders', 'create_po',
# vars = {'product': p.findall(str(row.id))}
vars = {'product': row.id}
),
),
]
grid = SQLFORM.grid(query, csv=False, deletable=False,
columns=columns,
maxtextlength=64, links=links)
On Nov 12, 9:39 am, Cliff wrote:
> Anthony,
>
> Thanks for the pointer. Much better.
>
> Cliff Kachinske
>
> On Nov 11, 10:50 pm, Anthony wrote:
>
>
>
>
>
>
>
> > Also, using the .element() and .elements() methods provides some powerful
> > options for searching the DOM --
> > seehttp://web2py.com/book/default/chapter/05#Server-side-DOM-and-Parsing.
>
> > Anthony
>
> > On Friday, November 11, 2011 5:37:52 PM UTC-5, Cliff wrote:
>
> > > Props to Richard Vezina for posting a similar technique. This is
> > > built on his post
>
> > > From the book we know that, "Components' objects can be referenced via
> > > their position, and helpers act as lists with respect to their
> > > components."
>
> > > A little archaeology in the source code tells us that SQLFORM.grid
> > > emits a DIV object. When there's an index table involved, the DIV has
> > > three components: a DIV, a DIV containing a TABLE and another DIV.
>
> > > # first we get the grid
> > > grid = SQLFORM.grid(query)
>
> > > # examine the div at the top of the grid div
> > > # for index lists, this div is of the class 'console',
> > > # so look for 'console' near the start of the div
> > > # there is CERTAINLY a better way to detect an index table, but
> > > this works
> > > if 'console' in str(grid[0])[0:35]:
> > > ## grid[1][0][1] is the DIV, TABLE and TBODY
> > > ## so we iterate over TRs in the table body
> > > for row in grid[1][0][1]:
> > > ## TR acts like a list, so we use some Python list fu
> > > row.insert(-1, 'foo')
> > > return dict(grid=grid)
>
> > > Done. Haven't cleaned up the table head yet, but it should be
> > > similar.
[web2py] Re: IS_MATCH()
Jonathan, Thanks for your explanation. Kind regards, Annet.
Re: [web2py] Re: "ERROR:Rocket.Errors.Port8000:SSL Error: [Errno 8] _ssl.c:499: EOF occurred in violation of protocol" on Upgraded v1.99.1
Is it already fixed? On Thu, Sep 22, 2011 at 9:04 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Dirk and I ran some tests. 1.99.1 broke rocket with SSL. Do not > upgrade if you use rocket with SSL. We will have a fix asap. > > Massimo > > On Sep 22, 4:50 pm, Massimo Di Pierro > wrote: > > Can you show me what triggers it? > > > > On Sep 22, 4:39 pm, Dirk wrote: > > > > > > > > > > > > > > > > > Upgraded a test environment with the live update, and am seeing the > > > following with embedded server and SSL enabled via CLI: > > > > > ERROR:Rocket.Errors.Port8000:SSL Error: [Errno 8] _ssl.c:499: EOF > > > occurred in violation of protocol > > > > > TIA, > > > Dirk > -- Linux User #387870 . _/_õ|__| ..º[ .-.___.-._| . . . . .__( o)__( o).:___
[web2py] best way to contact a programmer
Dear All, I have a nice project. I have already started to code it. 1) First I would like to make sure that there are no technical limitations to Web2py. For example I have never seen any jQuery multiple autocomplete plug-in implemented in a website powered by Web2py. Why ? Can Web2py really compete with ASP.NET or Ruby on Rails ? 2) Second I am not good enough to write it entirely. Or it would take me too much time. So I would like to contact a programmer. What's the best way to contact a programmer ? Is it through experts4solutions ? 3) Third I don't have too much money ;) So my budget is limited. What's the average price of your last contracts ? Also I don't know if we can make money out of my idea, but I could also give a share in my website... Thanks in advance, Marin
[web2py] Re: Mixing/supporting CMS with Web2py
On Sat, 12 Nov 2011 06:46:18 -0800 (PST) Michael Ellis wrote: > Thanks, Gour. It's a nice looking framework and seems to be well- > designed. Yup, it's quite nice. > I look forward to the web2py version! Let's see if it will happen...otherwise (without decent CMS) we'd have to tinker wiht PHP. :-/ Sincerely, Gour -- From anger, complete delusion arises, and from delusion bewilderment of memory. When memory is bewildered, intelligence is lost, and when intelligence is lost one falls down again into the material pool. http://atmarama.net | Hlapicina (Croatia) | GPG: 52B5C810 signature.asc Description: PGP signature
[web2py] Re: application installation problem
No special characters. web2py doesn't see it. It does not appear in the application list, and it does not find the application when i try to call it in the browser.
[web2py] Re: application installation problem
What is in your application folder? Have you successfully run it in another installation of web2py? On Saturday, November 12, 2011 12:52:54 PM UTC-5, petrasadi wrote: > > No special characters. web2py doesn't see it. It does not appear in the > application list, and it does not find the application when i try to call > it in the browser.
Re: [web2py] application installation problem
On Nov 12, 2011, at 10:09 AM, Anthony wrote: > What is in your application folder? Have you successfully run it in another > installation of web2py? > > On Saturday, November 12, 2011 12:52:54 PM UTC-5, petrasadi wrote: > No special characters. web2py doesn't see it. It does not appear in the > application list, and it does not find the application when i try to call it > in the browser. Maybe a permissions problem? Though that'd be more likely to cause problems writing, not reading. Not sure it's ordinarily necessary, but try restarting web2py, if you haven't already.
[web2py] Fluxflex + Oauth facebook
Hi Folks! Are you able to login using Oauth2.0 on fluxflex? I'm trying to but seems that OAuthAccount grabs the ip of my instance and the facebook never recognizes my redirect URL. Anybody with this problem? Regards, Tito -- Linux User #387870 . _/_õ|__| ..º[ .-.___.-._| . . . . .__( o)__( o).:___
Re: [web2py] application installation problem
You probably copied it as root, you might need chown to unlock it.
[web2py] Passing the newly created record's id to another function in the controller
Hi, In my current project I have a function (a) in the controller which calls Crud to create a new record. After which function (a) sends the user to function (b) using the "next" directive in Crud. I'd like to have function (b) know the id of the record created which sent them over so it could store the reference in one of it's fields. I tried setting args=id, args=[id], args="id" but nothing seems to work. I'd greatly appreciate your help. Thanks, Tsvi Mostovicz Here follows the code I have at the moment: def a(): form = crud.create(db.a, next=URL(args=[id],f='b')) return dict(form=form) def b(): form = crud.create(db.b) a = db(db.b.settings==request.args(0)).select() return dict(a=a, form=form)
[web2py] Re: Passing the newly created record's id to another function in the controller
The 'next' URL literally has to contain the substring '[id]', so you would
probably need to do:
next=URL('b') + '/[id]'
There is a newer feature that allows you to replace any of the form vars in
the URL via Python string formatting notation:
next=URL('b') + '/%(id)s'
Note, I don't think you can specify the latter part of the URL as the
'args' argument to URL() because the special characters will end up getting
escaped.
Anthony
On Saturday, November 12, 2011 4:51:39 PM UTC-5, tsvim wrote:
>
> Hi,
>
> In my current project I have a function (a) in the controller which
> calls Crud to create a new record. After which function (a) sends the
> user to function (b) using the "next" directive in Crud. I'd like to
> have function (b) know the id of the record created which sent them
> over so it could store the reference in one of it's fields.
>
> I tried setting args=id, args=[id], args="id" but nothing seems to
> work. I'd greatly appreciate your help.
>
> Thanks,
>
> Tsvi Mostovicz
>
> Here follows the code I have at the moment:
>
> def a():
> form = crud.create(db.a,
>next=URL(args=[id],f='b'))
> return dict(form=form)
>
> def b():
> form = crud.create(db.b)
> a = db(db.b.settings==request.args(0)).select()
> return dict(a=a, form=form)
[web2py] Need File Chooser which does NOT upload upon form Submit
Is there a widget / technique in web2py forms to choose a file but not upload it?
Re: [web2py] best way to contact a programmer
> > 1) First I would like to make sure that there are no technical > limitations to Web2py. For example I have never seen any jQuery > multiple autocomplete plug-in implemented in a website powered by > Web2py. Why ? Some web2py plugins which implement auto-complete http://dev.s-cubism.com/web2py_plugins > Can Web2py really compete with ASP.NET or Ruby on > Rails ? > web2py can do everything Rails or asp.net does for web development, in fact, web2py and Rails are much better than asp.net because it gives more flexibility and liberty to the programmer (you do not have to rely on a heavy IDE as Visual Studio or windows servers) web2py was inspired too much by Rails ideas and web2py is becoming very close the features that Rails ecosystem has. > > 2) Second I am not good enough to write it entirely. Or it would take > me too much time. So I would like to contact a programmer. What's the > best way to contact a programmer ? Is it through experts4solutions ? > Expers4solutions will let you to contact the best web2py programmers around the world, but I think you can post your job in websites like ODesk (or others) may be good developers that are not member of e4s will be able to apply for the job. > > 3) Third I don't have too much money ;) So my budget is limited. > What's the average price of your last contracts ? Also I don't know if > we can make money out of my idea, but I could also give a share in my > website... That is too much relative to the programmer and region he works, for example I am from Brazil, and here the average price is a bit lower than in U.S, I cannot apply for more jobs for now because my task-list is overloaded, but tell more about your project (you can do it here too). -- Bruno Rocha [http://rochacbruno.com.br]
[web2py] Re: Need File Chooser which does NOT upload upon form Submit
What do you want to do with the file? On Saturday, November 12, 2011 5:12:39 PM UTC-5, dlypka wrote: > > Is there a widget / technique in web2py forms to choose a file but not > upload it?
[web2py] Is there a controller post-action hook? Or should we use a decorator.
Is there a simple way to register code for execution after each controller action has been executed? Our problem is that most of our controller actions eventually obtain a pymongo connection object (from cache.ram) which itself pools connections internally and are thread-safe. These connection objects need to have end_request() called to free up their internal connections. We were originally calling end_request() everywhere a pymongo connection was obtained but that doesn't work for nested invocations, and it's hard to balance when exceptions occur. Would it be better to write a decorator and wrap the controller action with this? Any ideas and feedback much appreciated.
[web2py] Re: Need File Chooser which does NOT upload upon form Submit
Parse it on the local machine. On Nov 12, 4:53 pm, Anthony wrote: > What do you want to do with the file? > > > > > > > > On Saturday, November 12, 2011 5:12:39 PM UTC-5, dlypka wrote: > > > Is there a widget / technique in web2py forms to choose a file but not > > upload it?
[web2py] Re: Need File Chooser which does NOT upload upon form Submit
An input field with type="file" will give you the upload widget. Then I suppose you'd need some Javascript to catch the form submission and do something with the file instead of submitting the form to web2py. That would require client-side Javascript and wouldn't depend on web2py. See http://www.html5rocks.com/en/tutorials/file/dndfiles/. Anthony On Saturday, November 12, 2011 6:45:12 PM UTC-5, dlypka wrote: > > Parse it on the local machine. > > On Nov 12, 4:53 pm, Anthony wrote: > > What do you want to do with the file? > > > > > > > > > > > > > > > > On Saturday, November 12, 2011 5:12:39 PM UTC-5, dlypka wrote: > > > > > Is there a widget / technique in web2py forms to choose a file but not > > > upload it?
[web2py] Re: Need File Chooser which does NOT upload upon form Submit
This is going into a web2py app which I have running in a major U.S. corporation. So far it has 10 users who depend on it 24x7. It is "saving their butts"... Many thanks. On Nov 12, 6:33 pm, Anthony wrote: > An input field with type="file" will give you the upload widget. Then I > suppose you'd need some Javascript to catch the form submission and do > something with the file instead of submitting the form to web2py. That > would require client-side Javascript and wouldn't depend on web2py. > Seehttp://www.html5rocks.com/en/tutorials/file/dndfiles/. > > Anthony > > > > > > > > On Saturday, November 12, 2011 6:45:12 PM UTC-5, dlypka wrote: > > > Parse it on the local machine. > > > On Nov 12, 4:53 pm, Anthony wrote: > > > What do you want to do with the file? > > > > On Saturday, November 12, 2011 5:12:39 PM UTC-5, dlypka wrote: > > > > > Is there a widget / technique in web2py forms to choose a file but not > > > > upload it?
[web2py] Re: Need File Chooser which does NOT upload upon form Submit
Cool. Keep in mind that the methods described in the link below will only work in browsers that implement the HTML5 File API (e.g., works in IE9, but probably not earlier versions of IE). Anthony On Saturday, November 12, 2011 8:07:51 PM UTC-5, dlypka wrote: > > This is going into a web2py app which I have running in a major U.S. > corporation. > So far it has 10 users who depend on it 24x7. > It is "saving their butts"... > Many thanks. > > On Nov 12, 6:33 pm, Anthony wrote: > > An input field with type="file" will give you the upload widget. Then I > > suppose you'd need some Javascript to catch the form submission and do > > something with the file instead of submitting the form to web2py. That > > would require client-side Javascript and wouldn't depend on web2py. > > Seehttp://www.html5rocks.com/en/tutorials/file/dndfiles/. > > > > Anthony > > > > > > > > > > > > > > > > On Saturday, November 12, 2011 6:45:12 PM UTC-5, dlypka wrote: > > > > > Parse it on the local machine. > > > > > On Nov 12, 4:53 pm, Anthony wrote: > > > > What do you want to do with the file? > > > > > > On Saturday, November 12, 2011 5:12:39 PM UTC-5, dlypka wrote: > > > > > > > Is there a widget / technique in web2py forms to choose a file but > not > > > > > upload it?
[web2py] Re: best way to contact a programmer
I am a certified MCSD .NET developer using both ASP.NET 4 and web2py on my current job in a very large company. I consider .NET to be best for 'legacy' .NET designs, and web2py best for green field designs. .NET is fundamentally flawed for web work because it depends on old style compiled dlls. .NET apps are difficult to install on just any windows machine due to both security and licensing issues. So our .NET projects often lose time due to lack of access to a machine that is setup for development of the particular app. With web2py, I can move my app to any machine quickly to continue development. In particular, I can install the development environment on the client's machine and let the client tweak the source code. .NET cannot be put on the client's machine in a lot of cases because the client cannot pay for a VS 2010 license. Bugs are easy to spot in web2py because python is a fraction of the lines of code to scan. Finally, .NET is vendor-designed, not academically designed. If want proper design for your web app, you pretty much have to use web2py. Most of ASP.NET is being replaced by jquery / jquery-ui these days anyway even in .NET web apps. So there is little value in ASP.NET anymore. On Nov 12, 11:03 am, Marin Dodoub wrote: > Dear All, > > I have a nice project. I have already started to code it. > > 1) First I would like to make sure that there are no technical > limitations to Web2py. For example I have never seen any jQuery > multiple autocomplete plug-in implemented in a website powered by > Web2py. Why ? Can Web2py really compete with ASP.NET or Ruby on > Rails ? > > 2) Second I am not good enough to write it entirely. Or it would take > me too much time. So I would like to contact a programmer. What's the > best way to contact a programmer ? Is it through experts4solutions ? > > 3) Third I don't have too much money ;) So my budget is limited. > What's the average price of your last contracts ? Also I don't know if > we can make money out of my idea, but I could also give a share in my > website... > > Thanks in advance, > Marin
[web2py] web2py dal not creating database
Hello, I have been playing around with web2py for about a month.. I have finally got to the point where I wanted to test the packing of my app to test the install on another system. However when I load the app into web2py on the new system the database is never created. I've even gone so far as to use the root mysql database user to see where any possible issues could arise.. I can't see any errors except a ticket which says.. ProgrammingError: (1146, u"Table 'app03.auth_user' doesn't exist") I loaded the app via the administrative interface over the loopback.. The sqllog has nothing interesting it.. I've restarted mysql, apache, the management interface with no success. Any advice would be greatly appreciated. Regards, Jimmy.
[web2py] Re: web2py dal not creating database
web2py will only create the db for you if you're using SQLite -- otherwise you have to create the db (once the db is created, though, web2py will create tables for you). See http://web2py.com/book/default/chapter/06#Connection-Strings. Anthony On Saturday, November 12, 2011 11:10:18 PM UTC-5, Jimmy Stewpot wrote: > > Hello, > > I have been playing around with web2py for about a month.. I have > finally got to the point where I wanted to test the packing of my app > to test the install on another system. However when I load the app > into web2py on the new system the database is never created. I've even > gone so far as to use the root mysql database user to see where any > possible issues could arise.. I can't see any errors except a ticket > which says.. > > ProgrammingError: (1146, u"Table 'app03.auth_user' doesn't exist") > > I loaded the app via the administrative interface over the loopback.. > The sqllog has nothing interesting it.. I've restarted mysql, apache, > the management interface with no success. > > Any advice would be greatly appreciated. > > Regards, > > Jimmy. > > > >
[web2py] Re: Mongo DB, AMFRPC3 and http 500 errors
I keep getting a RestrictedError for certain kinds of output, especially when I try using modules in my views & they are usually hard to trace. I think web2py restricts the kind of things you can output, probably for security reasons... Hope that helped!
Re: [web2py] Re: web2py dal not creating database
Hi, Thanks for the quick response.. I have the DB created in mysql. The user has rights (using the root user).. still no luck. I've turned on query logging in mysql, the app queries are all working as expected but it won't create the model. Regards, Jimmy - Original Message - From: "Anthony" To: web2py@googlegroups.com Sent: Sunday, 13 November, 2011 3:54:58 PM Subject: [web2py] Re: web2py dal not creating database web2py will only create the db for you if you're using SQLite -- otherwise you have to create the db (once the db is created, though, web2py will create tables for you). See http://web2py.com/book/default/chapter/06#Connection-Strings. Anthony On Saturday, November 12, 2011 11:10:18 PM UTC-5, Jimmy Stewpot wrote: Hello, I have been playing around with web2py for about a month.. I have finally got to the point where I wanted to test the packing of my app to test the install on another system. However when I load the app into web2py on the new system the database is never created. I've even gone so far as to use the root mysql database user to see where any possible issues could arise.. I can't see any errors except a ticket which says.. ProgrammingError: (1146, u"Table 'app03.auth_user' doesn't exist") I loaded the app via the administrative interface over the loopback.. The sqllog has nothing interesting it.. I've restarted mysql, apache, the management interface with no success. Any advice would be greatly appreciated. Regards, Jimmy.
Re: [web2py] Re: web2py dal not creating database
what is in your: define_table(..., *migrate=?*) and db = DAL(, * migrate_enabled=?*) It needs to be setted to True or ommited to create the tables. On Sun, Nov 13, 2011 at 4:14 AM, Jimmy Stewpot wrote: > Hi, > > Thanks for the quick response.. > > I have the DB created in mysql. The user has rights (using the root > user).. still no luck. > > I've turned on query logging in mysql, the app queries are all working as > expected but it won't create the model. > > Regards, > > Jimmy > > > > - Original Message - > From: "Anthony" > To: web2py@googlegroups.com > Sent: Sunday, 13 November, 2011 3:54:58 PM > Subject: [web2py] Re: web2py dal not creating database > > web2py will only create the db for you if you're using SQLite -- otherwise > you have to create the db (once the db is created, though, web2py will > create tables for you). See > http://web2py.com/book/default/chapter/06#Connection-Strings. > > > Anthony > > On Saturday, November 12, 2011 11:10:18 PM UTC-5, Jimmy Stewpot wrote: > > Hello, > > I have been playing around with web2py for about a month.. I have > finally got to the point where I wanted to test the packing of my app > to test the install on another system. However when I load the app > into web2py on the new system the database is never created. I've even > gone so far as to use the root mysql database user to see where any > possible issues could arise.. I can't see any errors except a ticket > which says.. > > ProgrammingError: (1146, u"Table 'app03.auth_user' doesn't exist") > > I loaded the app via the administrative interface over the loopback.. > The sqllog has nothing interesting it.. I've restarted mysql, apache, > the management interface with no success. > > Any advice would be greatly appreciated. > > Regards, > > Jimmy. > -- Bruno Rocha [http://rochacbruno.com.br]
