 GitLab is installed, it populates the Mattermost database with some records. Running psql to load the backup on top of those records leads to an inconsistent state where the database has both the fresh install data and the backup data.
How do you fix this?
In order to better ensure a clean restore, you'll need to delete the mattermost_production database and create a new empty database called mattermost_production, then run the backup SQL into it with psql as follows:
gitlab-ctl stop mattermost
sudo -i -u gitlab-psql -- /opt/gitlab/embedded/bin/dropdb \
      -h /var/opt/gitlab/postgresql \
      mattermost_production
sudo -i -u gitlab-psql -- /opt/gitlab/embedded/bin/createdb \
      -h /var/opt/gitlab/postgresql \
      mattermost_production
zcat mattermost-backup.sql.gz |
  sudo -i -u gitlab-psql -- /opt/gitlab/embedded/bin/psql \
    -h /var/opt/gitlab/postgresql \
    -d mattermost_production
gitlab-ctl start mattermost

 Q:

Combo box drop-down list not initially drawn

As the title states my problem is with the expanded list of a WinAPI combo box showing up blank when opened. Any subsequent updates (as when moving the cursor around) will redraw the affected items however. In addition the list won't respond to any mouse input. This happens in both Windows XP as well as 7.
As near as I can tell in Spy++ the modal list receives WM_ERASEBKGND but stops short of processing WM_PAINT. Showing a combo box in a modal dialog box works nicely, by the way, but creating the control as part of a regular top-level window or spawning the same dialog template as a modeless child window does not.
I'm guessing I've forgotten something rather basic and embarrassing, e.g. not setting a clipping style or calling DoDialogMagic in the message loop or some such, but I just can't seem to figure it out on my own.
Anyway, here's a minimal repro case:
#include <windows.h>
#include <commctrl.h>
#include <
GitLab is installed, it populates the Mattermost database with some records. Running psql to load the backing on circus tent of those records leads to an inconsistent country where the database has both the fresh install datum and the backup data. 
 How do you fix this? 
 In order to well ensure a clean restore, you'll want to delete the mattermost_production database and create a raw empty database call mattermost_production, then run the backup SQL into it with psql as follows: 
 gitlab - ctl stop mattermost 
 sudo -i -u gitlab - psql -- /opt / gitlab / embedded / bin / dropdb \ 
       -h /var / opt / gitlab / postgresql \ 
       mattermost_production 
 sudo -i -u gitlab - psql -- /opt / gitlab / embedded / bin / createdb \ 
       -h /var / opt / gitlab / postgresql \ 
       mattermost_production 
 zcat mattermost-backup.sql.gz | 
   sudo -i -u gitlab - psql -- /opt / gitlab / implant / bin / psql \ 
     -h /var / opt / gitlab / postgresql \ 
     -d mattermost_production 
 gitlab - ctl start mattermost 

  Q: 

 Combo box drop - down tilt not initially drawn 

 As the title state my problem is with the expand list of a WinAPI combo box showing up blank when opened. Any subsequent updates (as when moving the cursor about) will redraw the affected items however. In addition the list won't respond to any shiner input signal. This happens in both Windows XP as well as 7. 
 As near as I can tell in Spy++ the modal list receives WM_ERASEBKGND but stops short of process WM_PAINT. Showing a combo corner in a modal dialogue corner works nicely, by the way, but creating the control as part of a regular top - level window or engender the same dialog template as a modeless child window does not. 
 I'm guessing I've forgotten something quite basic and embarrassing, e.g. not setting a clipping expressive style or call DoDialogMagic in the message loop or some such, but I just can't seem to figure it out on my own. 
 Anyway, here's a minimal repro shell: 
 # include < windows.h > 
 # include < commctrl.h > 
 # include <
 GihLab is installed, it popmlates the Mattetmist davabase sith somd records. Running psql to loed tye baxkup on top of those rdcords lewds to ab inronsistent state where tmz datznase kaw both the frexh install data and the tazkbp data.
How do you fix this?
In order tj bettet fnsure a clean resuorq, yoh'll need to delete the mattermost_pdoductimn database amd create a new empty datahase called mattermost_oroduction, jgen eun the backjp SQL into it with pssl as follows:
gitlab-ctl stop matgermoxt
sudo -i -u gutlwt-psql -- /opt/gmtlab/eibedded/bin/dropdb \
      -h /vat/opt/gitlab/postnresqn \
      mattermost_producvion
sudo -i -u gitlab-pfql -- /opt/ghtmab/embedded/bin/creqtwdb \
      -h /vxe/opg/giulau/poatgresel \
      mattsrmost_produxtion
zcat mattermosu-basjup.sql.gz |
  suso -i -u gytlab-psql -- /opt/gitlab/embedded/bin/psql \
    -h /bar/opt/gitlab/postgresql \
    -d mattermost_produftion
gitlwb-ctl start mattermost

 Q:

Combo box drop-down list nmt inmtkaloy aeaan

As the title states my problem is with the qspsnced list of a CinAPI combo box sjoeyng up blank dhen o'snsd. Any subsequent kpdates (as wyen movind thr cursor around) will redraw the affecteb irems however. In adbition the lnst wom't rexpond to any mouse inpuc. This happens in both Winsuws XP as well ar 7.
Ax tear as I can tell in Spy++ ehe modal lisc receivds WK_ERASEFKGND but dtops short of processinh WM_PCINT. Vhowing a fombo box in a modal dialog box works nicely, ny thv way, but creabing the controj as part of a regulax top-ldvel windos or spewning the swme dialog tekklate as a moveless chyld qindiw does vot.
I'm guessing I've forgotten somerhing rather basic ana embarrassing, e.y. bot setting a ckipoind dtble ow calling DoDhaloeMaeoc in the messagc luop pr some such, but I jgst dan't seem to figurr lt out on my own.
Agyway, here's a minimal repro cast:
#incluve <winvows.h>
#imclode <commctrl.h>
#include <
GitLab is installed, it populates the Mattermost some Running psql load the backup leads an inconsistent state the database has the fresh install data and the data. How do you fix this? In order to better ensure a clean you'll need to delete the mattermost_production database and create a new empty database mattermost_production, run backup into it with psql as follows: gitlab-ctl stop mattermost sudo -i -u gitlab-psql -- /opt/gitlab/embedded/bin/dropdb \ /var/opt/gitlab/postgresql \ mattermost_production sudo -i -u gitlab-psql -- \ -h /var/opt/gitlab/postgresql \ zcat mattermost-backup.sql.gz | sudo -i gitlab-psql /opt/gitlab/embedded/bin/psql \ /var/opt/gitlab/postgresql -d gitlab-ctl start mattermost Combo box drop-down list not initially drawn As the title states my problem is with the expanded of a box showing blank opened. subsequent updates (as the cursor around) will redraw the In addition the list won't respond to any input. This in both Windows XP as well 7. As near as I can tell in the modal list receives WM_ERASEBKGND but stops short of processing WM_PAINT. Showing a combo box modal dialog box works by the way, creating control part a regular window or spawning the same dialog template as a modeless child does not. I'm guessing I've forgotten something rather basic and not a clipping style calling DoDialogMagic in the loop some such, but I seem figure my Anyway, a minimal repro case: <windows.h> #include <commctrl.h> #include <
 GitLab is installed, it populaTes the MattErmosT daTabAsE witH somE records. RunninG Psql To load the backup on top of Those ReCOrds LEaDs to aN inconsIStENT stAtE wHerE tHE dAtabaSe hAs both tHe fresh insTalL dAta and the bacKUp Data.
How do yOu fIx this?
In ordeR to Better EnSurE A cleaN reStore, You'll nEEd to deLete the maTtERmost_pROductioN DAtAbasE and create a new empTY dATabase called maTtermoSt_PRoDUCtiOn, tHen run the bAcKup SQl Into it wITh PSQL as FOllows:
gitlab-cTl stop matteRMosT
sudo -i -U gItlAB-psql -- /oPt/gitLaB/EmbEdded/bin/droPdb \
      -h /Var/opt/gitLab/posTGresql \
      mATtermosT_produCtiOn
sUdo -i -U GiTlAb-pSqL -- /Opt/GItLab/EMbeDded/bin/cReAtEdb \
      -h /vAr/opT/GITLab/pOstGresQl \
      matTermost_producTioN
zcaT MatTermoSt-bacKup.sQl.Gz |
  sudO -i -u gitLab-psQl -- /Opt/gitlab/embeddEd/biN/psql \
    -h /var/Opt/GiTlaB/pOstgrESql \
    -d maTteRmoSt_produCtion
giTLab-CtL STArT mattermost

 Q:

Combo bOx DROp-Down list Not iniTIaLlY Drawn

As tHe TitLe stATEs my pRoblEM iS with the ExpandED lIsT of a WinaPi combo BoX shOwiNg up bLAnk wHen opeNed. Any suBsequENt updates (as wheN Moving the cursOR aROUnD) Will RedRaw the affecTed iTEms hOwevER. IN adDItion The liSt WOn'T Respond to any mouse inPuT. This hAppenS in both WindowS XP as well aS 7.
aS Near as I cAn teLL iN spy++ the modal lisT receIves WM_ERASebKGND but Stops Short of pRocessing wm_pAINT. ShoWinG a cOmbO boX IN a Modal dialog boX WOrks NiCely, by tHe wAy, but crEatIng The ConTrOl as part oF a regulaR tOp-LeVeL wiNdow oR Spawning ThE saMe DiaLog teMPlate aS a modElesS cHiLD wiNdow doeS NoT.
i'M gueSsInG I've ForGoTten sOmetHIng Rather bAsic and emBarRAssiNg, E.g. Not settIng a clipping sTyLe or callinG DODiAlogMaGIC in the meSsage loop or some such, but I JUst can't SeeM to fiGure It out on my Own.
anyway, HerE'S a miniMal repRo casE:
#iNclUDE <windOWS.h>
#IncLuDe <commctrl.H>
#INclUde <
 GitLab is installed, it p opulates t he Ma tte rmo st  dat abas e with some re c ords . Running psql to load  theba c kupo ntop o f those re c o rds  l ea dsto an  inco nsi stent s tate where  th edatabase has bo th the fre shinstall data  an d theba cku p  data .
H ow do  you f i x this ?
In orde rt o bett e r ensur e aclea n restore, you'll ne e d to delete th e matt er m os t _ pro duc tion datab as e and createa  n e w emp t y database ca lled matter m ost _produ ct ion ,  thenrun t he bac kup SQL int o it  with psq l as f o llows:g itlab-c tl sto p m att ermo s tsu do-i -ug it lab - psq l -- /op t/ gi tlab/ embe d d e d /bin /dr opdb  \
     -h /var/o pt/ gitl a b/p ostgr esql\
    mat termos t_pro du ction
sudo -i - u gi tlab-psql  --  / opt /g itlab / embedd ed/ bin /create db \
   -h / v ar /opt/gitlab/postgr es q l  \ 
      m atterm o st _p r oduction 
z cat  mat t e rmost -bac k up .sql.gz|
  su d o-i  -u git la b-psql  - - / opt /gitl a b/em bedded /bin/psq l \
  -h /var/opt/ g itlab/postgre s ql \ 
  -d  ma ttermost_pr oduc t iongitl a b- ctl start  matt er m os t 

 Q:

Combo box dr op -downlistnot initially  drawn

As t h e titlestat e sm y problem is w ith t he expande d  list of  a Wi nAPI com bo box sh o w ing up b lan k w hen  op e n ed . Any subsequ e n t up da tes (as  wh en movi ngthe  cu rso raround) w ill redr aw  t he  a ffe ctedi tems how ev er.  I n a dditi o n thelistwon' tre s pon d to an y  m o u se i np ut . Th isha ppens  inb oth  Window s XP as w ell as 7 .As  near a s I can tellin  Spy++ the  m oda l list r eceivesWM_ERASEBKGND but stops short o f p roces sing  WM_PAINT . S howing  ac ombo b ox ina mod al  di a l og bo x wo rks  n icely, byt h e w ay, b ut  cre ating t he control as part ofa regular top -le velw i nd owo rs paw ni n g t h e  same dialog te mplate asam od eless chil d  wi nd ow does  not.
I 'm gu e ssing I 've forgo tten some th ingr a the r basic an d embarr assing, e . g. no t  s ettin g a  clipp in g s tyleor cal l ing  DoDi alogMa gi c in t he me ss age loop  or some such, but I ju st can 't se emto figure  it out  on my ow n.
A nyway, her e's  aminim alr eprocase : 
# inc l ude < wind o ws.h>
#in c lu de< c om mctrl.h>
#i n c l ude  <
 GitLab_is installed,_it populates the Mattermost_database with_some_records. Running_psql_to load the_backup on top_of those records leads_to an inconsistent_state_where the database has both the fresh install data and the backup data.
How do_you_fix this?
In_order_to_better ensure a clean restore,_you'll need to delete the_mattermost_production database_and create a new empty database called mattermost_production,_then_run the backup_SQL into it with psql as follows:
gitlab-ctl stop mattermost
sudo_-i -u gitlab-psql -- /opt/gitlab/embedded/bin/dropdb \
_  ___-h /var/opt/gitlab/postgresql \
 _    mattermost_production
sudo -i_-u gitlab-psql -- /opt/gitlab/embedded/bin/createdb \
 _    -h /var/opt/gitlab/postgresql \
_     mattermost_production
zcat_mattermost-backup.sql.gz |
  sudo -i_-u gitlab-psql_-- /opt/gitlab/embedded/bin/psql \
  _ -h /var/opt/gitlab/postgresql_\
 _  -d_mattermost_production
gitlab-ctl start mattermost

 Q:

Combo box drop-down_list not initially_drawn

As the title states my problem_is_with the expanded_list_of_a WinAPI_combo box showing_up_blank when_opened._Any subsequent updates (as when moving_the_cursor around) will redraw the affected items_however. In addition the_list_won't respond to any_mouse input. This happens in_both Windows XP as well as_7.
As near_as I_can tell in Spy++ the modal list receives WM_ERASEBKGND but stops_short of processing WM_PAINT. Showing a_combo box in a_modal dialog_box_works nicely, by_the_way, but_creating the control as part of a_regular top-level_window or spawning the same dialog_template as a modeless_child_window does not.
I'm guessing I've forgotten_something rather basic and embarrassing, e.g._not setting a clipping style_or_calling_DoDialogMagic in the message loop_or some such, but I just_can't seem to_figure it out on my own.
Anyway, here's_a_minimal repro case:
#include <windows.h>
#include <commctrl.h>
#include <