Answers

• tangerine Posts: 3,365Questions: 39Answers: 395

  March 2019

  You're missing the closing bracket for validator:

              ->validator( Validate::unique( new ValidateOptions::inst()
                  ->message( 'Duplicate Entry') ) ),
  
• hamlet1964 Posts: 43Questions: 8Answers: 1

  March 2019

  Still getting error after inserting the code, above.

  DataTables warning: table id=words - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1
  
• colin Posts: 15,240Questions: 1Answers: 2,599

  March 2019

  Hi @hamlet1964 ,

  Looking at the examples on this page it looks like you don't need the new before ValidateOptions.

  Hope that does the trick,

  Cheers,

  Colin
• hamlet1964 Posts: 43Questions: 8Answers: 1

  March 2019

  Thanks for the suggestion, Colin, however, that does not work, either.
• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  March 2019

  ->validator(
    Validate::unique(
      ValidateOptions::inst()
        ->message( 'Duplicate Entry')
    )
  ),
  

  should do it. If that isn't working for you, can you show me the response from the server (i.e. what the invalid JSON is) - likely it contains an error message.

  My guess is that ValidateOptions isn't in your use statement.

  Allan
• hamlet1964 Posts: 43Questions: 8Answers: 1

  March 2019

  Allan - still not working - here's the response i received:

  <br />
  <b>Fatal error</b>:  Uncaught Error: Class 'ValidateOptions' not found in /Applications/XAMPP/xamppfiles/htdocs/ourpage/words/php/table.words.php:26
  Stack trace:
  #0 {main}
    thrown in <b>/Applications/XAMPP/xamppfiles/htdocs/ourpage/words/php/table.words.php</b> on line <b>26</b><br />
  

  Here is the entire PHP file:

  <?php
  
  /*
   * Editor server script for DB table table1
   * Created by http://editor.datatables.net/generator
   */
  
  // DataTables PHP library and database connection
  include( "lib/DataTables.php" );
  
  // Alias Editor classes so they are easy to use
  use
      DataTables\Editor,
      DataTables\Editor\Field,
      DataTables\Editor\Format,
      DataTables\Editor\Mjoin,
      DataTables\Editor\Options,
      DataTables\Editor\Upload,
      DataTables\Editor\Validate;
  
  // Build our Editor instance and process the data coming from _POST
  Editor::inst( $db, 'Words', 'WCount' )
      ->fields(
          Field::inst( 'Word' )
              ->validator( Validate::unique(
      ValidateOptions::inst()
        ->message( 'Duplicate Entry'))),
          Field::inst( 'Type'),
          Field::inst( 'Phonetic' ),
          Field::inst( 'Definition' )
      )
      ->process( $_POST )
      ->json();
  
• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  March 2019 Answer ✓

  Perfect - thanks. As I suggested above you don't have a ValidateOptions definition in your use statement. Add that and I would expect it to work - e.g.:

  DataTables\Editor\ValidateOptions
  

  Allan
• hamlet1964 Posts: 43Questions: 8Answers: 1

  March 2019

  Yes, this now works! Thanks!!