View Issue Details

IDProjectCategoryView StatusLast Update
0015361phplist applicationSubscribe Processpublic19-04-10 19:24
ReporterSubhash 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version2.10.10 
Target Version2.10.12Fixed in Version2.10.12 
Summary0015361: Attribut value is not saved
DescriptionHavingh set an own table prefix the value of an attribute of the type select is not saved on subscription.

The bug ist in "admin/commonlib/lib/userlib.php" from line 913 on.

WRONG:
      $curval = Sql_Fetch_Row_Query(sprintf('select id from phplist_listattr_%s
      where name = "%s"',$atttable,$data["displayvalue"]),1);
      if (!$curval[0] && $data['displayvalue'] && $data['displayvalue'] != '') {
        Sql_Query(sprintf('insert into phplist_listattr_%s (name) values("%s")',$atttable,
        $data["displayvalue"]));

RIGHT:

      $curval = Sql_Fetch_Row_Query(sprintf('select id from ' . $usertable_prefix . 'listattr_%s
        where name = "%s"',$atttable,$data["displayvalue"]),1);
      if (!$curval[0] && $data['displayvalue'] && $data['displayvalue'] != '') {
        Sql_Query(sprintf('insert into ' . $usertable_prefix . 'listattr_%s (name) values("%s")',$atttable,
          $data["displayvalue"]));
TagsNo tags attached.

Activities

There are no notes attached to this issue.