Re: no such table: main.auth_user__old

[Integr@te System]

Hi,
plz use python 3.7.

On Sun, Dec 1, 2019, 01:53 Chetan Rokade  wrote:

> Hi Friends
> Getting below error while adding new user  from admin page. I am using
> python 3.8 with django 2.1 version
> Exception Value:
>
> no such table: main.auth_user__old
>
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/9b9e2d7b-89bd-41c5-bd0f-ce8a865570fb%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CAP5HUWq_FDrUW8aKDKKV03WQNEAOB3U2x9k5-wbF9kKxO32oWg%40mail.gmail.com.

Re: How can I host my application in web hosting?

[Debabrata Chakraborty]

Thanks a bunch Jorge,

That was very helpful.

Best

Deb

On Sun, Dec 1, 2019 at 11:31 AM Jorge Gimeno  wrote:

> Deb,
>
> Digital Ocean will allow you to run what you can install.  If you can get
> it on the server, you can use it.
>
> Heroku and Python Anywhere do have specific services that are available.
> You can check out their documentation to see what they are.
>
> I don't know much about AWS, so that I will not be able to answer.
>
> Hope it helps!
>
> -Jorge
>
> On Sat, Nov 30, 2019 at 6:01 AM Debabrata Chakraborty <
> debobroto.c...@gmail.com> wrote:
>
>> Hi everyone,
>>
>> I'm a beginner Django developer. So my apologies in advance for newbie
>> like questions.
>>
>> I am building my site with *" *Django version 2.2.5 *"* and *" *SQLite
>> 3.30 *" *in back-end. My question is -
>>
>> *#* Do services like "Heroku", "Digital Ocean", "Python Anywhere" and
>> "AWS" - have limitation on *which version of Django*  or *which DBMS* I
>> can use?
>>
>> I've seen this before with PHP/MySQL hosting where some hosting companies
>> will limit which version of PHP or MySQL one can use. Is the same
>> applicable to Django hosting in the above mentioned hosting platforms as
>> well?
>>
>> I will very much grateful if you can help me out with this confusion.
>>
>> Best
>>
>> Deb
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Django users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to django-users+unsubscr...@googlegroups.com.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/django-users/a6ccc082-ae9d-4f67-8038-9db16008b956%40googlegroups.com
>> 
>> .
>>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/CANfN%3DK9JwU8_NbuTUwhuO7YB_WiUKthkNNSwhO0OPE49pgd8tA%40mail.gmail.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CAPDzUOhBsOxyyTDAZdbLXNU1WgfBDfT_o9V7WMitB%3DQsYyuCKQ%40mail.gmail.com.

orm relation

[bill dexter]

ELECT a.matr
  ,[nom]
  ,[prn]
  ,cast([dat_nais] as date) as dat_nais
  , (YEAR(getdate()) - YEAR(dat_nais)) as age
  ,cast([dat_deces] as date) as dat_deces
  ,cast([dat_imm] as date) as dat_imm
  ,cast([dat_aj] as date) as dat_j
  ,[cod_position]
  ,YEAR(dat_imm) as anne_imm
  ,YEAR(dat_encais) as ann_regl
  ,[annee]
  ,[cod_nat]
  ,cast([dat_e

Snc] as date) as dat_regl
  ,[mt_encais]
  FROM users a
left join enca e on e.matr = a.matr
left join encr c on (c.cod_encais = e.cod_encais)
  where (YEAR(c.dat_enc) - c.annee > 3 ) and ((YEAR(getdate()) - 
YEAR(a.dat_nais)) between 54 and 70) and c.cod_nat = 'CN'
  order by a.nom_, a.prn, c.annee asc;

hello;
my models are users, enca; encr;
who can i performe this query using django ORM, note that i'm using MSSQL; 
thank very much

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/85f7f91b-0f52-4a96-8700-bee588eb4a3d%40googlegroups.com.

Re: no such table: main.auth_user__old

[Tim Graham]

If you're using Django 2.1, try upgrading to the latest Django 2.1.x 
(2.1.14 as of this writing). You should always use the latest point release 
to get the most recent security and bug fixes. 

See 
https://stackoverflow.com/questions/53637182/django-no-such-table-main-auth-user-old

On Saturday, November 30, 2019 at 1:54:04 PM UTC-5, Chetan Rokade wrote:
>
> Hi Friends
> Getting below error while adding new user  from admin page. I am using 
> python 3.8 with django 2.1 version
> Exception Value: 
>
> no such table: main.auth_user__old   
>
>
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/c9442dfe-3759-4592-9629-5ad1f9d50835%40googlegroups.com.

Re: orm relation

[Integr@te System]

Hi,

here u can try for complex queryset


https://docs.djangoproject.com/en/2.2/topics/db/queries/#complex-lookups-with-q

On Sun, Dec 1, 2019, 21:08 bill dexter <55dexte...@gmail.com> wrote:

> ELECT a.matr
>   ,[nom]
>   ,[prn]
>   ,cast([dat_nais] as date) as dat_nais
>   , (YEAR(getdate()) - YEAR(dat_nais)) as age
>   ,cast([dat_deces] as date) as dat_deces
>   ,cast([dat_imm] as date) as dat_imm
>   ,cast([dat_aj] as date) as dat_j
>   ,[cod_position]
>   ,YEAR(dat_imm) as anne_imm
>   ,YEAR(dat_encais) as ann_regl
>   ,[annee]
>   ,[cod_nat]
>   ,cast([dat_e
>
> Snc] as date) as dat_regl
>   ,[mt_encais]
>   FROM users a
> left join enca e on e.matr = a.matr
> left join encr c on (c.cod_encais = e.cod_encais)
>   where (YEAR(c.dat_enc) - c.annee > 3 ) and ((YEAR(getdate()) -
> YEAR(a.dat_nais)) between 54 and 70) and c.cod_nat = 'CN'
>   order by a.nom_, a.prn, c.annee asc;
>
> hello;
> my models are users, enca; encr;
> who can i performe this query using django ORM, note that i'm using MSSQL;
> thank very much
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/85f7f91b-0f52-4a96-8700-bee588eb4a3d%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CAP5HUWqap3ddCEmW-7yD_uRWhwxDNQdSNZ%2BQPPvHzcAwDf1e5Q%40mail.gmail.com.

Re: How can I host my application in web hosting?

[Asif Khan]

I am using Webfaction and quit happy. it is quit fast and scalable platform 
for Django application.

On Thursday, August 22, 2019 at 4:47:51 PM UTC+5, Wasim Rana wrote:
>
> Hello, I am building a web application locally in my computer. It's almost 
> done and I want to host it in Siteground hosting. How can I do that? Please 
> help.
> Thanks
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/1398c821-9ecb-4a4a-af78-87950f9f623e%40googlegroups.com.

Re: How can I host my application in web hosting?

[Integr@te System]

Hi friend,

In real world matter, it not just technical aspect, also one should
consider business, services, sth else around from now to future.
For publish in production, ask provider's technical that you want first as
essential basic, break down which items, then business and so on.

In technical, please see previous email of one expert on sharing many
details. On deployment as approximate you implement locally and reference
to doc to migrate.

It just simpler with personal work (for yourself) than company's enviroment.




On Mon, Dec 2, 2019, 01:25 Asif Khan  wrote:

> I am using Webfaction and quit happy. it is quit fast and scalable
> platform for Django application.
>
> On Thursday, August 22, 2019 at 4:47:51 PM UTC+5, Wasim Rana wrote:
>>
>> Hello, I am building a web application locally in my computer. It's
>> almost done and I want to host it in Siteground hosting. How can I do that?
>> Please help.
>> Thanks
>>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/1398c821-9ecb-4a4a-af78-87950f9f623e%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CAP5HUWp6HtJn0RgeH3hxP_4JREbicu3SB-Eci6%2B%3DWFKVgDywGQ%40mail.gmail.com.

Re: How can I host my application in web hosting?

[RLM]

Hello.
AWS has no limitations.
Simply start an instance running ubuntu, windows, or what ever, just 
like you have for development,  install dependencies and updates and you 
should be good to go. Read the Docs first, it's not click and go like 
some other providers.
With AWS you are totally responsible for security and everything else, 
and can lock it down so that your server is virtually hidden from the 
web. It's just like you are running a home dev machine, it's brilliant 
for our purposes. And for us, it's not expensive.


On AWS we are currently running several Hugo static sites, a ubuntu 
server with python3.8, we've got django on it but not used since we 
moved to Hugo.


HTH
Roger

On 1/12/19 5:00 pm, Jorge Gimeno wrote:

Deb,

Digital Ocean will allow you to run what you can install. If you can 
get it on the server, you can use it.


Heroku and Python Anywhere do have specific services that are 
available.  You can check out their documentation to see what they are.


I don't know much about AWS, so that I will not be able to answer.

Hope it helps!

-Jorge

On Sat, Nov 30, 2019 at 6:01 AM Debabrata Chakraborty 
mailto:debobroto.c...@gmail.com>> wrote:


Hi everyone,

I'm a beginner Django developer. So my apologies in advance for
newbie like questions.

I am building my site with *" *Django version 2.2.5 *"* and *"
*SQLite 3.30 *" *in back-end. My question is -

*#* Do services like "Heroku", "Digital Ocean", "Python Anywhere"
and "AWS" - have limitation on _which version of Django_  or
_which DBMS_ I can use?

I've seen this before with PHP/MySQL hosting where some hosting
companies will limit which version of PHP or MySQL one can use. Is
the same applicable to Django hosting in the above mentioned
hosting platforms as well?

I will very much grateful if you can help me out with this confusion.

Best

Deb
-- 
You received this message because you are subscribed to the Google

Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to django-users+unsubscr...@googlegroups.com
.
To view this discussion on the web visit

https://groups.google.com/d/msgid/django-users/a6ccc082-ae9d-4f67-8038-9db16008b956%40googlegroups.com

.

--
You received this message because you are subscribed to the Google 
Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to django-users+unsubscr...@googlegroups.com 
.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CANfN%3DK9JwU8_NbuTUwhuO7YB_WiUKthkNNSwhO0OPE49pgd8tA%40mail.gmail.com 
.


--
You received this message because you are subscribed to the Google Groups "Django 
users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/a677294d-25da-6165-8aa4-f78aab170b56%40gmail.com.

Re: Groups and summarys in template

[Elias Coutinho]

Well, the result I expect is a list with subtotals similar to the figure
below:

[image: image.png]

Can you do it without javascript?

Em sáb., 30 de nov. de 2019 às 03:36, Dvenum  escreveu:

> Not sure I understand, what you doing, but you may use F() expression to
> compare fields in the query:
> https://docs.djangoproject.com/en/2.2/ref/models/expressions/#f-expressions
>
> On Sat, Nov 30, 2019 at 2:36 AM Elias Coutinho 
> wrote:
>
>> Good afternoon people!
>>
>> I have the following querysets:
>>
>>  accounts = Account.objects.filter (person__is_representative = False
>> ) .order_by ('due date')
>>  groups = Account.objects.values ('due_date'). annotate (total_day =
>> Sum ('sold_value')). order_by ('due_date')
>>
>>
>> Accounts Returns a List of Information Sorted by Due Date
>> groups returns another list sorted and grouped by due date
>>
>> I would like django to place a total groups in the template below the
>> line of accounts when it realizes that the next due date is different from
>> the previous one, ie totaling by date.
>>
>> Can someone help me?
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Django users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to django-users+unsubscr...@googlegroups.com.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/django-users/8ea05b06-1eb1-4de3-8787-6d80570a6283%40googlegroups.com
>> 
>> .
>>
>
>
> --
> dvenum
> dvenum...@gmail.com
>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "Django users" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/django-users/fxaeopAyJj8/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> django-users+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/CAHBRYSeBvJr6cDTRtUXEqsJFb03cZw66G2jk1DqY_7P7-jYq1g%40mail.gmail.com
> 
> .
>


-- 
Elias Coutinho.
Aprender sobre alguns assuntos é fundamental.
Aprender sobre Deus é indiscutivelmente o melhor conteúdo.

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CALgom8oa_fEfWMiyCdvr0cWGjKzB9Fk8fENkCjnvXOof%3DKMR%2Bg%40mail.gmail.com.

Link a .css to a Html template

[Leó Horváth]

Hi guys, I am experiencing an error while trying to Link a .css file to a 
Html template of one of my Views. What is the correct way to do it?

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/b37e10ec-3b9d-4178-8757-1d0277f6cd15%40googlegroups.com.

Re: Link a .css to a Html template

[אורי]

Hi,

Look at these templates for example:
https://github.com/speedy-net/speedy-net/blob/master/speedy/core/templates/base.html#L12-L27

https://github.com/speedy-net/speedy-net/blob/master/speedy/match/templates/base_site.html#L7-L13

https://github.com/speedy-net/speedy-net/blob/master/speedy/match/templates/accounts/edit_profile/activate.html#L13-L18


אורי
u...@speedy.net


On Mon, Dec 2, 2019 at 3:26 AM Leó Horváth 
wrote:

> Hi guys, I am experiencing an error while trying to Link a .css file to a
> Html template of one of my Views. What is the correct way to do it?
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/b37e10ec-3b9d-4178-8757-1d0277f6cd15%40googlegroups.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CABD5YeHFgym3pJ4Q5_gE3ATWJiVJ9KDnoBCN8UqM0%2BhWPxXpbg%40mail.gmail.com.

Re: Groups and summarys in template

[Integr@te System]

Hi Man,
Plz try:
desired_value = Account.object.aggregate( subtotal = sum('Value', filter =
Q(Date = date.todat(




On Mon, Dec 2, 2019, 07:14 Elias Coutinho  wrote:

> Well, the result I expect is a list with subtotals similar to the figure
> below:
>
> [image: image.png]
>
> Can you do it without javascript?
>
> Em sáb., 30 de nov. de 2019 às 03:36, Dvenum 
> escreveu:
>
>> Not sure I understand, what you doing, but you may use F() expression to
>> compare fields in the query:
>>
>> https://docs.djangoproject.com/en/2.2/ref/models/expressions/#f-expressions
>>
>> On Sat, Nov 30, 2019 at 2:36 AM Elias Coutinho 
>> wrote:
>>
>>> Good afternoon people!
>>>
>>> I have the following querysets:
>>>
>>>  accounts = Account.objects.filter (person__is_representative =
>>> False) .order_by ('due date')
>>>  groups = Account.objects.values ('due_date'). annotate (total_day =
>>> Sum ('sold_value')). order_by ('due_date')
>>>
>>>
>>> Accounts Returns a List of Information Sorted by Due Date
>>> groups returns another list sorted and grouped by due date
>>>
>>> I would like django to place a total groups in the template below the
>>> line of accounts when it realizes that the next due date is different from
>>> the previous one, ie totaling by date.
>>>
>>> Can someone help me?
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Django users" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to django-users+unsubscr...@googlegroups.com.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/django-users/8ea05b06-1eb1-4de3-8787-6d80570a6283%40googlegroups.com
>>> 
>>> .
>>>
>>
>>
>> --
>> dvenum
>> dvenum...@gmail.com
>>
>> --
>> You received this message because you are subscribed to a topic in the
>> Google Groups "Django users" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/django-users/fxaeopAyJj8/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> django-users+unsubscr...@googlegroups.com.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/django-users/CAHBRYSeBvJr6cDTRtUXEqsJFb03cZw66G2jk1DqY_7P7-jYq1g%40mail.gmail.com
>> 
>> .
>>
>
>
> --
> Elias Coutinho.
> Aprender sobre alguns assuntos é fundamental.
> Aprender sobre Deus é indiscutivelmente o melhor conteúdo.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/CALgom8oa_fEfWMiyCdvr0cWGjKzB9Fk8fENkCjnvXOof%3DKMR%2Bg%40mail.gmail.com
> 
> .
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/CAP5HUWos_QUR1C2ZTHJreRVutVUEEEw_41sx94bPw6O4YUJqRg%40mail.gmail.com.