Ignore:
Timestamp:
11/07/10 17:11:39 (9 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.