double entries in styles and types

Help
2009-05-05
2013-05-28
  • Knut Krüger
    Knut Krüger
    2009-05-05

    Hi all,
    I found double entries in styles and types, and I don not know how it happens.
    The double numbers, both in styles and types are having ids like 11 21 31 or 15,25,35 and so on
    I deleted the double entries from styles but I don not know whether I could delete the double types also.
    Regards Knut
    Daten für Tabelle types

    15    Abstract    true    2
    17    Abstract    true    2
    27    Abstract    true    2
    37    Abstract    true    2
    2    Book Chapter    true    2
    3    Book Whole    true    3
    7    Conference Article    true    2
    18    Conference Article    true    2
    28    Conference Article    true    2
    38    Conference Article    true    2
    8    Conference Volume    true    3
    19    Conference Volume    true    3
    29    Conference Volume    true    3
    39    Conference Volume    true    3
    4    Journal    true    3
    1    Journal Article    true    1
    16    Magazine Article    true    1
    20    Magazine Article    true    1
    30    Magazine Article    true    1
    40    Magazine Article    true    1
    9    Manual    true    3
    21    Manual    true    3
    31    Manual    true    3
    41    Manual    true    3
    5    Manuscript    true    3
    6    Map    true    3
    10    Miscellaneous    true    3
    22    Miscellaneous    true    3
    32    Miscellaneous    true    3
    42    Miscellaneous    true    3
    11    Newspaper Article    true    1
    23    Newspaper Article    true    1
    33    Newspaper Article    true    1
    43    Newspaper Article    true    1
    12    Patent    true    3
    24    Patent    true    3
    34    Patent    true    3
    44    Patent    true    3
    13    Report    true    3
    25    Report    true    3
    35    Report    true    3
    45    Report    true    3
    14    Software    true    3
    26    Software    true    3
    36    Software    true    3
    46    Software    true    3

     
    • Hi Knut,

      I'm not sure how this could happen. Maybe you did use 'update.sql' (several times) instead of 'update.php' in an attempt to update your refbase database? In any case, using 'update.php' should avoid such issues in the future.

      I think you can safely delete all entries in table 'types' where the 'type_id' is greater than 16. That said, it's probably a good idea to make sure that your types are still set correctly for your users. I.e., after cleaning up the 'types' table you should login as admin and verify that the types are selected correctly for each user.

      Matthias

       
      • Knut Krüger
        Knut Krüger
        2009-05-05

        Hi Matthias
        Thank you very much, maybe I used update.sql I don't know when and what happened ....

        Knut