#202 Fatal error: Column 'rep_opt' specified twice

Major
closed
None
5
2012-07-20
2010-08-22
No

I have sql error after I book repeat entries: weekly, n-repeat etc.:
Fatal error: Column 'rep_opt' specified twice

But daily repeats works just fine.
How can I fix this?

info: mrbs -datepicker svn rev.1417

Discussion

  • Mateusz Palonek

    Mateusz Palonek - 2010-08-23

    Ok I fixed it by myself. The problem is in file mrbs_sql.inc : line 275 :

    // special case - rep_opt
    case 'rep_opt':
    // pgsql doesn't like empty strings
    $sql_col[] = $key;
    $sql_val[] = (empty($data[$key])) ? "'0'" : "'" . addslashes($data[$key]) . "'";

    I deleted this part and repet entries work good now.

     
  • Campbell Morrison

    Fixed in SVN Rev 1418. (The fix suggested below won't work for PostgreSQL. The problem was that the break statement was missing at the end of the rep_opt case.)

     
  • John Beranek

    John Beranek - 2011-02-10

    Made available in MRBS 1.4.5.

     


Anonymous

Cancel  Add attachments





Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks