developer.jelix.org is not used any more and exists only for history. Post new tickets on the Github account.
developer.jelix.org n'est plus utilisée, et existe uniquement pour son historique. Postez les nouveaux tickets sur le compte github.

Opened 7 years ago

Closed 7 years ago

#1506 closed bug (invalid)

jacl2db upgrade, mysql error

Reported by: Arnall Owned by:
Priority: normal Milestone:
Component: module:jacl2db Version: 1.4.2
Severity: normal Keywords:
Cc: Blocked By:
Blocking: Documentation needed: no
Hosting Provider: Php version: 5.3.15

Description

trying to upgrade from jelix 1.3 to jelix 1.4, with installer.php

[error] An error occured during the installation of the module jacl2db: Erreur dans la requête (Unknown column 'test' in 'where clause'(UPDATE jacl2_user_group SET code_grp = '__anonymous' WHERE id_aclgrp=test))

Mysql : 5.1.67-0ubuntu0.10.04.1-log

it works with quoted string 'test'.

Change History (1)

comment:1 Changed 7 years ago by laurentj

  • Resolution set to invalid
  • Status changed from new to closed

You have a problem with your installation.

First, this query is executed to migrate to 1.3a1. So, if you have Jelix 1.3, it should not be executed.

Second, at this step of migration, id_aclgrp is supposed to be an integer (and is transform to varchar at the end of the migration). However it seems you already executed this script since here id_aclgrp is a varchar.

I guess you have two applications running on the same database. On the second application, you should disable the installer for modules that have been already updated databases in an other application

[modules]

mymodule.skipinstaller = skip
Note: See TracTickets for help on using tickets.