I'm going to bump this, it's fairly critical since a few peopl seem to
be affected by it.
On May 4, 11:26 am, TheDude <officed...@gmail.com> wrote:
> Massimo,
> Just out of curiosity, how would appending "IF NOT EXIST" to the
> create table command for MySQL create more problems? This doesn't make
> any logical sense. Unless you're referring to the ALTER TABLE commands
> after that, even then I think there is a IF NOT EXIST command within
> MySQL. Sure, it wouldn't solve for other DBMS, but at least MySQL is
> having more support, and it's not changing the web2py functionality.
>
> If this is still a problem, web2py should have a global migrate
> command so that you can completely disable migration altogether. Does
> this function already exist? :S
>
> Either way, doing that migrate=false thing, is just a work-around. It
> isn't focusing on the problem, but rather ignoring it. The weird thing
> is how does changing the connection string affect the entire
> migration? I understand if I changed the db name, but changing the
> user/pass/port/host should be allowed without web2py forcing the re-
> migrate.
>
> On May 4, 10:54 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > T2 is dead. I will be no longer be supported. In fact much of the T2
> > functionality is in gluon.tools
> > T3 will survive but will be rebuilt on top of tools and events
>
> > Massimo
>
> > On May 4, 9:39 am, Hans <johann.scheibelho...@easytouch-edv.com>
> > wrote:
>
> > > how to apply this for T2 tables like t2_person?
> > > would this workaround survive version updates of T2?
>
> > > hans
>
> > > On May 4, 4:23 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > > This is complex. Currently the way to avoid the problem is to name
> > > > the .table files via
>
> > > > db.define_table('something',....,migrate='something.table')
>
> > > > using "IF EXISTS" would only solve this problem to create others.
>
> > > > Massimo
>
> > > > On May 4, 7:02 am, Hans <johann.scheibelho...@easytouch-edv.com>
> > > > wrote:
>
> > > > > I'm having a similar problem. Last time I solved it by deleting the
> > > > > database and setting it up new. With more data it gets a pain. I read
> > > > > about setting 'migrate=False' to avoid the issue. I could use that for
> > > > > 'own' tables, but I get the same error for tables created by the T2
> > > > > plugin.
> > > > > Like TheDude also I have changed the user/pass for MySQL connection.
> > > > > Maybe Web2Py thinks it needs to create the tables new after user/pass
> > > > > change?
>
> > > > > Traceback (most recent call last):
> > > > > File "/usr/lib/web2py/gluon/restricted.py", line 98, in restricted
> > > > > exec ccode in environment
> > > > > File "/usr/lib/web2py/applications/ips/models/db.py", line 19, in
> > > > > <module>
> > > > > t2=T2(request,response,session,cache,T,db)
> > > > > File "/usr/lib/web2py/applications/plugin_t2/modules/t2.py", line
> > > > > 98, in __init__
> > > > > self._create_tables()
> > > > > File "/usr/lib/web2py/applications/plugin_t2/modules/t2.py", line
> > > > > 341, in _create_tables
> > > > > t=db.define_table('t2_person',T2.base_table(db,'t2_person'))
> > > > > File "/usr/lib/web2py/gluon/sql.py", line 938, in define_table
> > > > > raise e
> > > > > OperationalError: (1050, "Table 't2_person' already exists")
>
> > > > > On May 4, 7:10 am, TheDude <officed...@gmail.com> wrote:
>
> > > > > > Massimo, I know that we've talked about this in the past, but here
> > > > > > we
> > > > > > go again...
>
> > > > > > I'm using the latest web2py, in my applications, I would define
> > > > > > tables
> > > > > > as usual only to get an SQL error saying the table exists. I tried
> > > > > > clearing out my "databases" folder, and the only way to clear out
> > > > > > would be to delete the database entirely (which is something that I
> > > > > > *should not* have to do). According to web2py docs, the DAL handles
> > > > > > this type of crap perfectly and just fine. As it should, leave the
> > > > > > migration/DAL issues to DAL and not to the user. This is what turned
> > > > > > my head towards web2py over Django.
>
> > > > > > Is CREATE TABLE `tablename` IF NOT EXISTS SQL ANSI? Either way, the
> > > > > > MySQL handler should perform this rather than just create table
> > > > > > under
> > > > > > the next patch. It would solve *a lot* of hassle. The problem
> > > > > > occurred
> > > > > > AFTER I changed my user/pass combo for the MySQL connection string.
> > > > > > Could this cause any problems?
>
> > > > > > Someone else had this problem unresolved a long time
> > > > > > ago...http://groups.google.com/group/web2py/browse_thread/thread/94a7107c68...
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
