MESSAGES

go to: HOME, CONSTANS or EXAMPLES

MESSAGES

The module messages can be extracted from the "SQL::SimpleOps:errstr" or "getMessage" method.

001E command Database is missing

• Error: The database name value omitted or empty.

• Action: Check the Constructor Command and validate the "db" option.

  my $mymod = SQL::SimpleOps->new( db => dsname, ... );
  

• Command: Constructor (method new)

002E command Server is missing

• Error: The server name value omitted or empty.

• Action: Check the Constructor Command and validate the "server" option.

  my $mymod = SQL::SimpleOps->new( server => servername, ... );
  

• Command: Constructor (method new)

003E command Interface invalid

• Error: The inteface driver name omitted or invalid.

• Action: Check the Constructor Command and validate the "interface" option. The current module support only "dbi" interface. The Open Command must be use the option:

  my $mymod = SQL::SimpleOps->new( interface => "dbi", ... );
  

• Command: Constructor (method new)

004E command The Database driver is omitted or empty

• Error: The database driver name omitted or invalid for the interface driver.

• Action: Check the Open Command and validate the "driver" option. For interface=dbi use:

  my $mymod = SQL::SimpleOps->new( driver=> 'mysql' or 'mariadb' or 'postgres' or 'sqlite3' , ... );
  

• Command: Constructor (method new)

005E command Table is missing or invalid

• Error: The table alias name omitted, empty or is not a single value.

• Action: Check the Command and validate the "table" option. The format depends of the command in use:

  SQL::SimpleOps->Select( table => aliases_table_name, ... ); # single select
  ot
  SQL::SimpleOps->Select( table => [ table1, table2, ... ], ... ); # merged selected

• Command: Select, Delete, Insert and Update

006E command Table invalid, must be single-value or array

• Error: The table alias name is not a single value or array value.

• Action: Check the Select Command and validate the "table" option.

  SQL::SimpleOps->Select( table => single_value_name, ... ); # single select
  or
  SQL::SimpleOps->Select( table => [ table1, table2, ... ], ... ); # merged select

• Command: Select and SelectCursor or getWhere Method

007E command Fields invalid, must be array

• Error: The list of fields is not array.

• Action: Check the Select Command and validate the "fields" option.

  SQL::SimpleOps->Select( fields => [ field1, field2, ... ], ... );

• Command: Select and SelectCursor

008E command Group_by invalid, must be single-value or array

• Error: The option "group_by" is not a single value or array value.

• Action: Check the Select Command and validente the "group_by" option. Example:

  SQL::SimpleOps->Select( group_by => col_name, ... );
  or
  SQL::SimpleOps->Select( group_by => [ col1_name, col2_name, ... ], ... );

• Command: Select and SelectCursor

009E command Order_by invalid, must be single-value or array-pairs

• Error: The option "order_by" is not a single value or array value.

• Action: Check the Select Command and validente the "order_by" option. Example:

  SQL::SimpleOps->Select( order_by => col_name, ... );
  or
  SQL::SimpleOps->Select(
  order_by => [ col1_name => order1, col2_name => order2, ... ],
  ...
  );

• Command: Select and SelectCursor

010E command Field '%s' not mapped in table list"

• Error: The field is using a non-valid table/field identifier.

• Action: Check the field syntax, we can have: Fields with a table identifier where it is not in the "Aliases Table" and is not in the command's table list. Fields without a table identifier that have the same "Aliases Table" for multiple tables.

  SQL::SimpleOps->Select(
  table => [ t1, t2 ],
  where => [ t1.id => '\t2.id', t3.name => "dummy" ],
  ...
  );

The 't3' is not mapped on the Select Command. To fix you must:
a) Use be 't1' or 't2' as aliases on the field 'name' or;
b) Specify the 't3' on the 'table' option.
c) Backslash is mandatory.

• Command: Select and SelectCursor

012I command Key not found

• Error: The SQL Command was successful executed without extracted lines (results).

• Action: Validade the conditions on the "where" option or use "notfound" option to force SQL_SIMPLE_RC_OK return code.

SQL::SimpleOps->Select( notfound => 1, ... );

• Command: Select, Delete, Insert, Update

013E command Cursor is missing or invalid

• Error: The Cursor information is omitted or empty.

• Action: Check the cursor and validate the "cursor" option on the SelectCursor Command.

  SQL::SimpleOps->SelectCursor( cursor => value, ... );

• Command: SelectCursor

014E command Cursor-key is missing or invalid

• Error: The Cursor Key information is omitted or empty.

• Action: Check the cursor key and validate the "cursor_key" option, on the SelectCursor Command.

  SQL::SimpleOps->SelectCursor( cursor_key => value, ... );

• Command: SelectCursor

015E command Cursor Command invalid

• Error: The Cursor Command information is not invalid.

• Action: Check the cursor command and validade the "cursor_command" option. The option must be:

  SQL_SIMPLE_CURSOR_TOP               # goto first page
  SQL_SIMPLE_CURSOR_NEXT              # goto next page, based current cursor
  SQL_SIMPLE_CURSOR_BACK              # goto backward page, based current cursor
  SQL_SIMPLE_CURSOR_LAST              # goto last page
  
  SQL::SimpleOps->SelectCursor( cursor_command => command, ... );
  

• Command: SelectCursor

016W command Key is missing, option 'force' is required

• Warning: One Write Command (Delete or Update) was execute without "where" option. For secure rasons, full updates must use "force" options.

• Beware: For secure rasons, full updates must use "force" option.

rejected command

SQL::SimpleOps->Delete( table => t1 );

correct command

SQL::SimpleOps->Delete( table => t1, force => 1 );

• Command: Delete and Update

017E command Fields is missing

• Error: The List of Fields is omitted or empty.

• Action: Check the list of fields and validate the "fields" option.

rejected command

SQL::SimpleOps->Insert( fields => col1, ... );
or
SQL::SimpleOps->Insert( fields => { col1 }, ... );

correct command

SQL::SimpleOps->Insert( fields => { col1 => value, ... }, ... );

• Command: Insert and Update

018E command Fields Format error, must be hash-pairs or arrayref

• Error: The List of Fields is malformed. One field must have assigned value. The arrayref format is valid only for 'insert' command.

• Action: Check the list of fliends and validate the "fields" option and/or "conflict" option.

rejected command

SQL::SimpleOps->Update( fields => col1, ... );
or
SQL::SimpleOps->Update( fields => { col1 }, ... );

correct command

SQL::SimpleOps->Update( fields => { col1 => value, ... }, ... );

• Command: Insert and Update

019E command Interface '[interface]::[driver]' missing

• Error: The Interface and/or Driver does not exists.

• Action: Check the interface and driver options and libraries on Perl Installation.

List of folder to check:

# perl -E 'print join("\n",@INC),"\n";'

How to check:

# ls [inc_folder]/[interface]/[plugin_name].pm

020E command Where Clause invalid

• Error: The where option or one subitem in the "where" option is empty.

• Action: Check the "where" option on the Command. see "Where Clause".

invalid where

SQL::SimpleOps->Select( where => [], ... );
or
SQL::SimpleOps->Select( where => [ a => 1, b => [] ], ... );

correct where

SQL::SimpleOps->Select( where => [ mycondition => myvalue ], ... );
or
SQL::SimpleOps->Select( where => [ a => 1, b => [ myvalue, ... ], ], ... );

• Command: Select, Delete, Insert and Update

021E command Where invalid, must be single-value or array

• Error: The "where" option or one subitem in the "where" option is not single value or array value.

• Action: Check the "where" option on the Command. see "Where Clause".

invalid where

SQL::SimpleOps->Select( where => { a => 1 }, ... );

correct where

SQL::SimpleOps->Select( where => [ a => 1 ], ... );

• Command: Select, Delete, Insert and Update

022E command Database is not open

• Error: These was a database access before a successful Open Command.

• Action: Check the Open Command process to grant the opened status to the database.

• Command: Select, Delete, Insert, Update and Call

023E command SQL Command is missing

• Error: The SQL Command is omitted or empty.

• Action: Check the SQL Command and validate the "command" option on the Call Command.

  SQL::SimpleOps->Call( command => my-sql-command, ... );

• Command: Call

024E command Buffer Type invalid, must be hashref, arrayref, scalaref or callback_ref

• Error: The Call Command was been executed using a non-valid struct as return buffer.

• Action: Check and validate the "buffer" option on the Command. The buffer must be:

returning on hash_ref

SQL::SimpleOps->Call( buffer => \%myHash, ... );

returning on array_ref

SQL::SimpleOps->Call( buffer => \@myArray, ... );

returning on scalar_ref

SQL::SimpleOps->Call( buffer => \$myScalar, ... );

returning by callback_ref

SQL::SimpleOps->Call( buffer => \@mySubRot, ... );
...
sub mySubRot() { my $ref = shift; ... ; return 0; }

• Command: Select, Delete, Insert, Update and Call

025S command Make Folder error, system-message

• System: The Save Option was been aborted with system error during
  make folder to write.

• Action: Check the "system-message" to fix. Common errors:

a) Permission denied: Check the folder ACL;
b) No left space: Check the folder free space or quota;
c) Invalid filename: Check the filename and use supported characters for your system.

• Command: Select, Delete, Insert, Update and Call

026S command Open File error, system-message

• System: The Save Option was been aborted with system errors during open file to write.

• Action: Check the "system-message" to fix. Common errors:

a) Permission denied: Check the Folder ACL;
b) Permission denied: Check if filer already using an onther ACL;
c) No left space: Check the folder free space or quota;
d) Invalid filename: Check the filename and use supported characters for your system.

Command: Select, Delete, Insert, Update and Call

028E command Table/Field Value invalid, must be single-value or array

• Error: The assigned value for one field is not single value or array value.

• Action: Check the subitem in the "where" option.

invalid

SQL::SimpleOps->Select( where => [ a => \&callback ], ... );
or
SQL::SimpleOps->Select( where => [ b => { c, 1 }, ... );

correct

SQL::SimpleOps->Select( where => [ a => value, ], ... );
or
SQL::SimpleOps->Select( where => [ b => [ c, 1 ], ... );

• Command: Select, Delete, Insert, and Update

029E command The TCP Port invalid, must be numeric and between 1-65535

• Error: The TCP Port value exced the range 1-65535.

• Action: Check and validate the "port" option on the Constructor.

  my $mymod = SQL::SimpleOps->new( port => 1..65535, ... );

NOTE: The 'port' option is not required for standard installation.

• Command: Constructor (method new)

030E command Aliases Table is not hashref

• Error: The Aliases Table was defined but is not a hashref.

• Action: Check the struct and validate the "tables" option on the Constructor. See "Aliases Table"

• Command: Constructor (method new)

031E command Aliases 'table' invalid, table_cols must be hashref

• Error: The "cols" option in the Aliases Table must be hash_ref.

• Action: Check the struct and validate the "tables" option on the Constructor. See "Aliases Table"

• Command: Constructor (method new)

032E command Aliases 'table' invalid, table_cols invalid format

• Error: The "cols" option in the Aliases Table is empty.

• Action: Check the struct validate the "tables" option on the Constructor. See "Aliases Table"

• Command: Constructor (method new)

033E command Table 'table' already, there can be only one

• Error: One table in the "Aliases Table" already defined.

• Action: Check the struct validate the "tables" option on the Constructor. See "Aliases Table"

  invalid

  SQL::SimpleOps->Select( table => [ t1, t2, t1 ], ... );

  correct

  SQL::SimpleOps->Select( table => [ t1, t2 ], ... );

• Command: Select and SelectCursor

034E command Aliases 'table' invalid, table_name is missing

• Error: The "Aliases Table" with missed fields, no table_name mapped.

• Action: Check the list of aliases table and add assign the real table name. "Aliases Table"

• Command: Constructor (method new)

035S command Interface Load error 'interface::plugin', system-message

• Plugin: Plugin loader error

• Action: The require load process fail for "interface" and "drive" options.

036S command Interface 'plugin' load error

• Plugin: The 'new' method in plugin finished with errors.

• Action: Check the options for the plugin or review your code into plugin

037S command Interface 'plugin' error, plugin-message

• Plugin: Plugin aborted with errors

• Action: Check the message for Plugin on "drive" option

038E command Syslog Facility invalid, must be 'local0' to 'local7'

• Error: The "facility" option must be "local0" to "local7".

• Action: Check the "facility" option on Constructor method.

• Command: Constructor (new)

039E command Syslog Service invalid, must contains 'alphanumeric' characters

• Error: The "Service" option must be "alphanumeric" characters.

• Action: Check the "service" option on Constructor method.

• Command: Constructor (new)

040E command Log File invalid, must contains 'alphanumeric' characters

• Error: The "logfile" option must be "alphanumeric" characters.

• Action: Check the "logfile" option on Constructor method.

• Command: Constructor (new)

041E command Values Format error, must be arrayref

• Error: The "values" option must be an arrayref.

• Action: Check the "values" option an insert command.

• Command: Insert

042E command Conflict/Duplicate Format error, must be hashref

• Error: The "conflict" option must be an hashref.

• Action: Check the "conflict" option an insert command.

• Command: Insert

043E command Limit is missing

• Error: The "limit" options must be an numeric value.

• Action: Check the "limit" option an insert command.

• Command: SelectCursor

044E Buffer hashkey invalid, buffer is not hashref

• Error: The buffer_hashkey option should only be used with buffer hashref

• Action: Check the "buffer" option.

• Command: Select and SelectCursor

045E Buffer hashkey not mapped

• Error: The "buffer_hashkey" value does not exist as an index key in the field list.

• Action: Check the field list or buffer_hashkey value.

• Command: Select and SelectCursor

046E Buffer hashkey must be scalaref or arrayref

• Error: The "buffer_hashkey" support only scalaref or arrayref.

• Action: Check the buffer_hashkey option.

• Command: Select and SelectCursor

047E Buffer arrayref Off not allowed for multiple field list

• Error: The "buffer_arrayref" only supports single fields in the selection.

• Action: Check the list of fields in selection.

• Command: Select and SelectCursor

048E Buffer hashindex must be arrayref

• Error: The "buffer_hashindex" is not arrayref format.

• Action: Check the list of value in selection.

• Command: Select and SelectCursor

099S command dbh-interface-message

• System: The interface or driver abort with errors.

• Action: Check the interface and driver reference guide.

• Command: Open, Close, Connect, Select, Delete, Insert, Update and Call.

999S [message] invalid code 'message-code'

• Error: The message code not found on the Table os Messages.

• Action: Internal Module Error, open a issue.

ENDED