Tag: Update

¿Como evito que mysql update elimine los 0 a la izquierda?

Estoy haciendo un UPDATE en mysql y al ejecutarlo ingresa el dato nuevo pero si tiene un 0 a la izquierda lo elimina. Como puedo evitar esto? Ya verifique en el código de php anterior a ejecutar la consulta y la variable todavía tiene el cero a la izquierda, es en el UPDATE que se elimina.

die(var_dump($  pwdNueva));// 0123  $  sql="UPDATE `socios` SET `password`= $  pwdNueva WHERE socios.ci = $  ci";  $  resultado = mysqli_query($  mysqli, $  sql);

Luego de este código el dato insertado en la base es 123.

Document Properties Under Quick Parts Don’t Update When A New Column Is Created

I have a SharePoint 2013 site that contains a document set with multiple content types. Each content type has its own document template. When I open a document template in Word, and then select Quick Parts -> Document Property, I can see all the properties related to the content type. However, if I add a new column to the content type and then open the template again in Word, I don’t see the new column in the list of properties when I select Quick Parts -> Document Property. Is there an additional step that needs to be taken after a new column is added, in order for it to show up under Quick Parts?

Cannot update ubuntu gitlab-ce_12.2.0-ce.0_amd64.deb

I encountered the following problem.

 /var/cache/apt/archives/gitlab-ce_12.2.0-ce.0_amd64.deb E: Sub-process /usr/bin/dpkg returned an error code (1)

My cli output

Reading package lists... Done Building dependency tree        Reading state information... Done Calculating upgrade... Done The following packages will be upgraded:   gitlab-ce 1 to upgrade, 0 to newly install, 0 to remove and 0 not to upgrade. Need to get 0 B/680 MB of archives. After this operation, 145 MB of additional disk space will be used. Do you want to continue? [Y/n] y (Reading database ... 319765 files and directories currently installed.) Preparing to unpack .../gitlab-ce_12.2.0-ce.0_amd64.deb ... gitlab preinstall: It seems you are upgrading from 11.x version series gitlab preinstall: to 12.x series. It is recommended to upgrade gitlab preinstall: to the last minor version in a major version series first before gitlab preinstall: jumping to the next major version. gitlab preinstall: Please follow the upgrade documentation at https://docs.gitlab.com/ee/policy/maintenance.html#upgrade-recommendations gitlab preinstall: and upgrade to 11.11 first. dpkg: error processing archive /var/cache/apt/archives/gitlab-ce_12.2.0-ce.0_amd64.deb (--unpack):  new gitlab-ce package pre-installation script subprocess returned error exit status 1 Errors were encountered while processing:  /var/cache/apt/archives/gitlab-ce_12.2.0-ce.0_amd64.deb E: Sub-process /usr/bin/dpkg returned an error code (1)

I have tried:

sudo dpkg -i --force-overwrite  /var/cache/apt/archives/gitlab-ce_12.2.0-ce.0_amd64.deb 
sudo apt-get update && sudo apt-get upgrade

Update / Deleting Custom Site Templates

I have created a custom site template in sharepoint online using the modern experience. However, there have been changes made that would impact future sites created with that template. Is there a way i can update the site template to accommodate the changes i have made?

Otherwise, if i delete the site template, will it delete the sites i created using said template? It would work just as well for me if i could delete the template, whilst retaining the sites utilizing it, and create a new template based on the changes I’ve made.

Thanks