Hello Clemens, here you are the answers:
- What about your sql.log? I don't have in the databases folder. I tried
with different combinations of migrate and fake_migrate_all but no way
- Do your have direct access to the database (w/o web2py) using this
user/password account? (sorry for that question, but sometimes it's that
easy :-) YES
- Are there any .table files already in your database folder? Yes all
tables are now in the databases folder
My application is now fully functional, I could change one table in the
db_asset.py because maybe with migrate=true and fake_migrate_all=True it
generates the sql.log. What do you think?
Thank you
Il giorno giovedì 27 agosto 2020 10:51:21 UTC+2, Clemens ha scritto:
>
> Hi,
>
> one more distance try: What does your sql.log file say? It's also to be
> found in the databases folder. For example, I can find there entries like:
> timestamp: 2020-08-21T17:53:29.984015
> CREATE TABLE "functionality_attributes"(
> "id" SERIAL PRIMARY KEY,
> ...
> );
> success!
>
> I had a similar problem about 2 years ago. I can't remember exactly the
> problem/solution. But the reason was, that I've tried to switch the uri to
> another database and therefore the .table files were already existing. That
> confuses the system since the tables were already processed in the (old)
> .table files but didn't exist in the (new) database. It's important for the
> .table files that different databases have different "file IDs"
> (db['_uri_hash']) since these are used for .table file naming.
>
> Well then:
>
> - What about your sql.log?
> - Do your have direct access to the database (w/o web2py) using this
> user/password account? (sorry for that question, but sometimes it's that
> easy :-)
> - Are there any .table files already in your database folder?
>
> Since it's fresh new database I would set fake_migrate to false and
> migrate to true.
>
> Best regards,
> Clemens
>
> On Thursday, August 27, 2020 at 9:30:39 AM UTC+2 and...@gmail.com wrote:
>
>> thank you Jim, but I don't understand...
>>
>> If I set
>> migrate=False
>> fake_migrate= True
>>
>> it means that web2py create the .table files without touching the db,
>> isn'it?
>>
>> If I set
>> migrate=True
>> fake_migrate=True
>>
>> It means what exactly?
>>
>> thank you so much
>>
>>
>> Il giorno mercoledì 26 agosto 2020 17:32:09 UTC+2, Jim S ha scritto:
>>
>>> You still have migrate set to False in your appconfig.ini.
>>>
>>> -Jim
>>>
>>> On Wed, Aug 26, 2020 at 10:14 AM Andrea Fae' <and...@gmail.com> wrote:
>>>
>> Thank you for your suggestions...Like this (see attaached files)?
>>>> but, no way, no .tables created...I don't know why...
>>>>
>>>> Il giorno mercoledì 26 agosto 2020 14:46:05 UTC+2, Jim S ha scritto:
>>>>>
>>>>> Did you remove the apostrophe at the bottom as well?
>>>>>
>>>>> I haven't used migrate / fake migrate in the past the way that you are
>>>>> implementing.
>>>>>
>>>>> Are you intentionally trying to set it by table?
>>>>>
>>>>> For me, on my DAL statement I'd include:
>>>>>
>>>>> migrate_enabled=myconf.get('db.migrate')
>>>>> fake_migrate_all=myconf.get('db.fake_migrate_all')
>>>>>
>>>>>
>>>>> then in appconfig.ini I'd have:
>>>>>
>>>>> [db]
>>>>> uri = mssql4://sa/Web2PyPassword@TS-SQL2016R2/itassetdb
>>>>> migrate = True
>>>>> fake_migrate_all = True
>>>>>
>>>>>
>>>>>
>>>>> Can you try that and see if it helps?
>>>>>
>>>>> Also, I'd remove all the migrate stuff from auth and all the
>>>>> individual tables. I just set it globally, but that may be a personal
>>>>> preference kind of thing.
>>>>>
>>>>> -Jim
>>>>>
>>>>> On Wednesday, August 26, 2020 at 1:32:13 AM UTC-5, Andrea Fae' wrote:
>>>>>>
>>>>>> Hello, thank you for your answer.
>>>>>> I deleted the character but nothing changes.
>>>>>> Best regards
>>>>>> Andrea
>>>>>>
>>>>>> Il giorno lunedì 24 agosto 2020 12:39:47 UTC+2, Clemens ha scritto:
>>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>> I'm not very deep in your issue. But opening your appconfig.ini with
>>>>>>> my default editor shows that the apostrophe in your authors value could
>>>>>>> be
>>>>>>> a problem:
>>>>>>>
>>>>>>> [image: Untitled.jpg]
>>>>>>>
>>>>>>> Thus, just delete it and have try. If it doesn't change anything,
>>>>>>> please let me know and I will have a closer look.
>>>>>>>
>>>>>>> Best regards
>>>>>>> Clemens
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Monday, August 24, 2020 at 11:18:32 AM UTC+2 and...@gmail.com
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hello, if I chose migrate= False and fake_migrate=True the .tables
>>>>>>>> in databases folder are not created.
>>>>>>>> Why?
>>>>>>>> I'm attaching appconfig.ini and py.db and my custom db db_asset.py
>>>>>>>> Thank you
>>>>>>>>
>>>>>>> --
>>>> 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/PLIV6cNvRnc/unsubscribe.
>>>>
>>> To unsubscribe from this group and all its topics, send an email to
>>>> web...@googlegroups.com.
>>>
>>>
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/web2py/e1702e2a-1c5f-4d0b-a27b-67cece00d923o%40googlegroups.com
>>>>
>>>> <https://groups.google.com/d/msgid/web2py/e1702e2a-1c5f-4d0b-a27b-67cece00d923o%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>>
--
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 the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/03288c11-8204-4838-a5a1-a5b034f697d0o%40googlegroups.com.
