Ignore:
Timestamp:
Nov 7, 2010, 5:11:39 PM (13 years ago)
Author:
grum
Message:

fix bug:2015 - Can't add a new personnal tag
fix bug:2017 - MySQL 5.1 incompatibility

File:
1 edited

Legend:

Unmodified
Added
Removed
  • extensions/AMetaData/amd_ajax.php

    r7519 r7677  
    841841      elseif($selected=='n')
    842842      {
    843         $sql="DELETE FROM ".$this->tables['selected_tags']." st
     843        $sql="DELETE FROM ".$this->tables['selected_tags']."
    844844                USING ".$this->tables['used_tags']." ut
    845                   LEFT JOIN ".$this->tables['selected_tags']." st
    846                     ON ut.tagID = st.tagId
     845                  LEFT JOIN ".$this->tables['selected_tags']."
     846                    ON ut.tagID = ".$this->tables['selected_tags'].".tagId
    847847                WHERE ut.numId = $numId;";
    848848        pwg_query($sql);
     
    13711371        // add a new metadata
    13721372        $sql="INSERT INTO ".$this->tables['used_tags']."
    1373               VALUES ('', '".$properties['tagId']."', 'n', '".$properties['name']."', 0, '".$properties['name']."')";
     1373              VALUES ('', '".$properties['tagId']."', 'n', '".$properties['name']."', 0, '".$properties['name']."', 'n')";
    13741374        $result=pwg_query($sql);
    13751375        $id=pwg_db_insert_id();
Note: See TracChangeset for help on using the changeset viewer.