Sql error 1109

DELETE
   ABC.theory_sheet_set,
   ABC.theory_sheet_questions
FROM
   ABC.theory_sheet_set AS theory_sheet_set,
   OCN.theory_sheet_questions AS theory_sheet_questions
WHERE
   theory_sheet_set.theory_sheet_set_id = theory_sheet_questions.theory_sheet_set_id
   AND theory_sheet_set.theory_sheet_id=".$theory_sheet_id

MySQL Error: 1109 (Unknown table 'theory_sheet_set' in MULTI DELETE)
Session halted.

1

WARNING: Setting locale failed.
  Check the following variables for correct values:
  LC_MONETARY=de_CH.UTF-8
  LC_NUMERIC=de_CH.UTF-8
  LC_TIME=de_CH.UTF-8
sb-impl::*default-external-format* :UTF-8
tmpdir: #P"/tmp/pgloader/"
2018-02-17T10:49:31.049000Z NOTICE Starting pgloader, log system is ready.
2018-02-17T10:49:31.077000Z INFO Starting monitor
2018-02-17T10:49:31.085000Z LOG Main logs in '/tmp/pgloader/pgloader.log'
2018-02-17T10:49:31.085000Z LOG Data errors in '/tmp/pgloader/'
2018-02-17T10:49:31.086000Z INFO SOURCE: #<PGLOADER.MYSQL:MYSQL-CONNECTION mysql://renate@localhost:3306/renate_with_spree {1008CF6D73}>
2018-02-17T10:49:31.089000Z INFO TARGET: #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://rails@UNIX:5432/renate_with_spree {1008EF25C3}>
2018-02-17T10:49:31.089000Z DEBUG LOAD DATA FROM #<PGLOADER.MYSQL:MYSQL-CONNECTION mysql://renate@localhost:3306/renate_with_spree {1008CF6D73}>
2018-02-17T10:49:31.090000Z DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://rails@UNIX:5432/renate_with_spree {1008EF25C3}>
2018-02-17T10:49:31.290000Z DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://renate@localhost:3306/renate_with_spree {1008CF6D73}>
2018-02-17T10:49:31.290000Z DEBUG MySQL: sending query: 
  select c.table_name, c.column_name,
         c.data_type, c.column_type, c.column_default,
         c.is_nullable, c.extra
    from information_schema.columns c
         join information_schema.tables t using(table_schema, table_name)
   where c.table_schema = 'renate_with_spree' and t.table_type = 'BASE TABLE'
         
         
         
order by table_name, ordinal_position
2018-02-17T10:49:31.691000Z DEBUG MySQL: sending query: 
    SELECT table_name, table_comment
      FROM information_schema.tables
    WHERE     table_schema = 'renate_with_spree'
          and table_type = 'BASE TABLE'
         
         
         
2018-02-17T10:49:31.891000Z DEBUG MySQL: sending query: 
  select c.table_name, c.column_name, c.column_comment
    from information_schema.columns c
         join information_schema.tables t using(table_schema, table_name)
   where     c.table_schema = 'renate_with_spree'
         and t.table_type = 'BASE TABLE'
         
         
         
order by table_name, ordinal_position
An unhandled error condition has been signalled:
   MySQL Error [1109]: "Unknown table 'referential_constraints' in information_schema"

Date/time: 2018-02-17-10:49An unhandled error condition has been signalled:
                              MySQL Error [1109]: "Unknown table 'referential_constraints' in information_schema"


Backtrace for: #<SB-THREAD:THREAD "main thread" RUNNING {1008B846C3}>
0: ((LAMBDA NIL :IN SB-DEBUG::FUNCALL-WITH-DEBUG-IO-SYNTAX))
1: (SB-IMPL::CALL-WITH-SANE-IO-SYNTAX #<CLOSURE (LAMBDA NIL :IN SB-DEBUG::FUNCALL-WITH-DEBUG-IO-SYNTAX) {100AA7A5DB}>)
2: (SB-IMPL::%WITH-STANDARD-IO-SYNTAX #<CLOSURE (LAMBDA NIL :IN SB-DEBUG::FUNCALL-WITH-DEBUG-IO-SYNTAX) {100AA7A5AB}>)
3: (PRINT-BACKTRACE :STREAM #<SYNONYM-STREAM :SYMBOL SB-SYS:*STDOUT* {10002C3A43}> :START 0 :FROM :DEBUGGER-FRAME :COUNT 4611686018427387903 :PRINT-THREAD T :PRINT-FRAME-SOURCE NIL :METHOD-FRAME-STYLE NIL)
4: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE-TO-STREAM #<SYNONYM-STREAM :SYMBOL SB-SYS:*STDOUT* {10002C3A43}>)
5: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE #<QMYND:MYSQL-ERROR {100AA76083}> :OUTPUT #<SYNONYM-STREAM :SYMBOL SB-SYS:*STDOUT* {10002C3A43}> :IF-EXISTS :APPEND :VERBOSE T)
6: (SIGNAL #<QMYND:MYSQL-ERROR {100AA76083}>)
7: (ERROR #<QMYND:MYSQL-ERROR {100AA76083}>)
8: (QMYND-IMPL:PARSE-RESPONSE #<QMYND-IMPL::MY-PACKET-STREAM 70/70 [2]>)
9: (QMYND:MYSQL-QUERY #<QMYND-IMPL::MYSQL-INET-CONNECTION {1009EE9DF3}> "
    SELECT tc.table_name, tc.constraint_name, k.referenced_table_name ft,

           group_concat(         k.column_name
                        order by k.ordinal_position) as cols,

           group_concat(         k.referenced_column_name
                        order by k.position_in_unique_constraint) as fcols,

           rc.update_rule, rc.delete_rule

      FROM information_schema.table_constraints tc

           JOIN information_schema.referential_constraints rc
             ON rc.constraint_schema = tc.table_schema
            AND rc.constraint_name = tc.constraint_name
            AND rc.table_name = tc.table_name

      LEFT JOIN information_schema.key_column_usage k
             ON k.table_schema = tc.table_schema
            AND k.table_name = tc.table_name
            AND k.constraint_name = tc.constraint_name

    WHERE     tc.table_schema = 'renate_with_spree'
          AND k.referenced_table_schema = 'renate_with_spree'
          AND tc.constraint_type = 'FOREIGN KEY'
         
         
         

 GROUP BY tc.table_name, tc.constraint_name, ft" :ROW-FN NIL :AS-TEXT T :RESULT-TYPE LIST)
10: (PGLOADER.MYSQL::LIST-ALL-FKEYS :ONLY-TABLES NIL :INCLUDING NIL :EXCLUDING NIL)
11: (PGLOADER.MYSQL::FETCH-MYSQL-METADATA #<PGLOADER.MYSQL:COPY-MYSQL {10098ED113}> :STATE #S(PGLOADER.UTILS::PGSTATE :TABLES #<HASH-TABLE :TEST EQUAL :COUNT 1 {100908C783}> :TABNAMES ("fetch meta data") :READ 0 :ROWS 0 :ERRS 0 :SECS 0.0) :MATERIALIZE-VIEWS NIL :ONLY-TABLES NIL :INCLUDING NIL :EXCLUDING NIL)
12: ((:METHOD PGLOADER.SOURCES:COPY-DATABASE (PGLOADER.MYSQL:COPY-MYSQL)) #<PGLOADER.MYSQL:COPY-MYSQL {10098ED113}> :STATE-BEFORE #S(PGLOADER.UTILS::PGSTATE :TABLES #<HASH-TABLE :TEST EQUAL :COUNT 1 {100908C783}> :TABNAMES ("fetch meta data") :READ 0 :ROWS 0 :ERRS 0 :SECS 0.0) :STATE-AFTER #S(PGLOADER.UTILS::PGSTATE :TABLES #<HASH-TABLE :TEST EQUAL :COUNT 0 {100908D503}> :TABNAMES NIL :READ 0 :ROWS 0 :ERRS 0 :SECS 0.0) :STATE-INDEXES #S(PGLOADER.UTILS::PGSTATE :TABLES #<HASH-TABLE :TEST EQUAL :COUNT 0 {100908D083}> :TABNAMES NIL :READ 0 :ROWS 0 :ERRS 0 :SECS 0.0) :TRUNCATE NIL :DISABLE-TRIGGERS NIL :DATA-ONLY NIL :SCHEMA-ONLY NIL :CREATE-TABLES T :INCLUDE-DROP T :CREATE-INDEXES T :INDEX-NAMES :UNIQUIFY :RESET-SEQUENCES T :FOREIGN-KEYS NIL :ONLY-TABLES NIL :INCLUDING NIL :EXCLUDING NIL :DECODING-AS NIL :MATERIALIZE-VIEWS NIL) [fast-method]
13: ((LAMBDA ()))
14: (PGLOADER:RUN-COMMANDS (LAMBDA NIL (LET* ((PGLOADER.PARSER::STATE-BEFORE (PGLOADER.UTILS:MAKE-PGSTATE)) (PGLOADER.PARAMS:*STATE* (OR PGLOADER.PARAMS:*STATE* (PGLOADER.UTILS:MAKE-PGSTATE))) (PGLOADER.PARSER::STATE-IDX (PGLOADER.UTILS:MAKE-PGSTATE)) (PGLOADER.PARSER::STATE-AFTER (PGLOADER.UTILS:MAKE-PGSTATE)) (PGLOADER.SOURCES:*DEFAULT-CAST-RULES* (QUOTE ((:SOURCE (:TYPE #1="int" :AUTO-INCREMENT T :TYPEMOD (< PGLOADER.TRANSFORMS:PRECISION 10)) :TARGET (:TYPE #2="serial")) (:SOURCE (:TYPE #1# :AUTO-INCREMENT T :TYPEMOD (<= 10 PGLOADER.TRANSFORMS:PRECISION)) :TARGET (:TYPE #3="bigserial")) (:SOURCE (:TYPE #1# :AUTO-INCREMENT NIL :TYPEMOD (< PGLOADER.TRANSFORMS:PRECISION 10)) :TARGET (:TYPE #1#)) (:SOURCE (:TYPE #1# :AUTO-INCREMENT NIL :TYPEMOD (<= 10 PGLOADER.TRANSFORMS:PRECISION)) :TARGET (:TYPE #4="bigint")) (:SOURCE (:TYPE #5="tinyint" :AUTO-INCREMENT T) :TARGET (:TYPE #2#)) (:SOURCE (:TYPE #6="smallint" :AUTO-INCREMENT T) :TARGET (:TYPE #2#)) (:SOURCE (:TYPE #7="mediumint" :AUTO-INCREMENT T) :TARGET (:TYPE #2#)) (:SOURCE (:TYPE #4# :AUTO-INCREMENT T) :TARGET (:TYPE #3#)) (:SOURCE (:TYPE #5# :TYPEMOD (= 1 PGLOADER.TRANSFORMS:PRECISION)) :TARGET (:TYPE #8="boolean" :DROP-TYPEMOD T) :USING PGLOADER.TRANSFORMS::TINYINT-TO-BOOLEAN) (:SOURCE (:TYPE "bit" :TYPEMOD (= 1 PGLOADER.TRANSFORMS:PRECISION)) :TARGET (:TYPE #8# :DROP-TYPEMOD T) :USING PGLOADER.TRANSFORMS::BITS-TO-BOOLEAN) (:SOURCE (:TYPE #4# :TYPEMOD (< 19 PGLOADER.TRANSFORMS:PRECISION)) :TARGET (:TYPE #9="numeric" :DROP-TYPEMOD T)) (:SOURCE (:TYPE #5#) :TARGET (:TYPE #6# :DROP-TYPEMOD T)) (:SOURCE (:TYPE #6#) :TARGET (:TYPE #6# :DROP-TYPEMOD T)) (:SOURCE (:TYPE #7#) :TARGET (:TYPE #10="integer" :DROP-TYPEMOD T)) (:SOURCE (:TYPE #10#) :TARGET (:TYPE #10# :DROP-TYPEMOD T)) (:SOURCE (:TYPE #11="float") :TARGET (:TYPE #11# :DROP-TYPEMOD T)) (:SOURCE (:TYPE #4#) :TARGET (:TYPE #4# :DROP-TYPEMOD T)) (:SOURCE (:TYPE "double") :TARGET (:TYPE "double precision" :DROP-TYPEMOD T)) (:SOURCE (:TYPE #9#) :TARGET (:TYPE #9# :DROP-TYPEMOD NIL)) (:SOURCE (:TYPE #12="decimal") :TARGET (:TYPE #12# :DROP-TYPEMOD NIL)) (:SOURCE (:TYPE #13="varchar") :TARGET (:TYPE #14="text")) (:SOURCE (:TYPE "tinytext") :TARGET (:TYPE #14#)) (:SOURCE (:TYPE #14#) :TARGET (:TYPE #14#)) (:SOURCE (:TYPE "mediumtext") :TARGET (:TYPE #14#)) (:SOURCE (:TYPE "longtext") :TARGET (:TYPE #14#)) (:SOURCE (:TYPE "char") :TARGET (:TYPE #13# :DROP-TYPEMOD NIL)) (:SOURCE (:TYPE "binary") :TARGET (:TYPE #15="bytea") :USING PGLOADER.TRANSFORMS::BYTE-VECTOR-TO-BYTEA) (:SOURCE (:TYPE "varbinary") :TARGET (:TYPE #15#) :USING PGLOADER.TRANSFORMS::BYTE-VECTOR-TO-BYTEA) (:SOURCE (:TYPE "tinyblob") :TARGET (:TYPE #15#) :USING PGLOADER.TRANSFORMS::BYTE-VECTOR-TO-BYTEA) (:SOURCE (:TYPE "blob") :TARGET (:TYPE #15#) :USING PGLOADER.TRANSFORMS::BYTE-VECTOR-TO-BYTEA) (:SOURCE (:TYPE "mediumblob") :TARGET (:TYPE #15#) :USING PGLOADER.TRANSFORMS::BYTE-VECTOR-TO-BYTEA) (:SOURCE (:TYPE "longblob") :TARGET (:TYPE #15#) :USING PGLOADER.TRANSFORMS::BYTE-VECTOR-TO-BYTEA) (:SOURCE (:TYPE #16="datetime" :DEFAULT #17="0000-00-00 00:00:00" :NOT-NULL T) :TARGET (:TYPE #18="timestamptz" :DROP-DEFAULT T :DROP-NOT-NULL T) :USING PGLOADER.TRANSFORMS::ZERO-DATES-TO-NULL) (:SOURCE (:TYPE #16# :DEFAULT #17#) :TARGET (:TYPE #18# :DROP-DEFAULT T) :USING PGLOADER.TRANSFORMS::ZERO-DATES-TO-NULL) (:SOURCE (:TYPE #19="timestamp" :DEFAULT #17# :NOT-NULL T) :TARGET (:TYPE #18# :DROP-DEFAULT T :DROP-NOT-NULL T) :USING PGLOADER.TRANSFORMS::ZERO-DATES-TO-NULL) (:SOURCE (:TYPE #19# :DEFAULT #17#) :TARGET (:TYPE #18# :DROP-DEFAULT T) :USING PGLOADER.TRANSFORMS::ZERO-DATES-TO-NULL) (:SOURCE (:TYPE #20="date" :DEFAULT "0000-00-00") :TARGET (:TYPE #20# :DROP-DEFAULT T) :USING PGLOADER.TRANSFORMS::ZERO-DATES-TO-NULL) (:SOURCE (:TYPE #20#) :TARGET (:TYPE #20#)) (:SOURCE (:TYPE "year") :TARGET (:TYPE #10# :DROP-TYPEMOD T)) (:SOURCE (:TYPE #16#) :TARGET (:TYPE #18#) :USING PGLOADER.TRANSFORMS::ZERO-DATES-TO-NULL) (:SOURCE (:TYPE #19#) :TARGET (:TYPE #18#) :USING PGLOADER.TRANSFORMS::ZERO-DATES-TO-NULL) (:SOURCE (:TYPE "enum") :TARGET (:TYPE #<FUNCTION PGLOADER.MYSQL::CAST-ENUM>)) (:SOURCE (:TYPE "set") :TARGET (:TYPE #<FUNCTION PGLOADER.MYSQL::CAST-SET>) :USING PGLOADER.TRANSFORMS::SET-TO-ENUM-ARRAY) (:SOURCE (:TYPE #21="point") :TARGET (:TYPE #21#) :USING PGLOADER.TRANSFORMS::CONVERT-MYSQL-POINT)))) (PGLOADER.SOURCES:*CAST-RULES* (QUOTE NIL)) (PGLOADER.PARAMS:*PG-SETTINGS* (QUOTE NIL)) (PGLOADER.PGSQL::*PGSQL-RESERVED-KEYWORDS* (PGLOADER.PGSQL:LIST-RESERVED-KEYWORDS #22=#<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://rails@UNIX:5432/renate_with_spree {1008EF25C3}>)) (PGLOADER.PARAMS:*COPY-BATCH-ROWS* (OR NIL PGLOADER.PARAMS:*COPY-BATCH-ROWS*)) (PGLOADER.PARAMS:*COPY-BATCH-SIZE* (OR NIL PGLOADER.PARAMS:*COPY-BATCH-SIZE*)) (PGLOADER.PARAMS:*CONCURRENT-BATCHES* (OR NIL PGLOADER.PARAMS:*CONCURRENT-BATCHES*)) (PGLOADER.PARAMS:*IDENTIFIER-CASE* (OR NIL PGLOADER.PARAMS:*IDENTIFIER-CASE*)) (PGLOADER.PARSER::SOURCE (MAKE-INSTANCE (QUOTE PGLOADER.MYSQL:COPY-MYSQL) :TARGET-DB #22# :SOURCE-DB #<PGLOADER.MYSQL:MYSQL-CONNECTION mysql://renate@localhost:3306/renate_with_spree {1008CF6D73}>))) NIL (PGLOADER.SOURCES:COPY-DATABASE PGLOADER.PARSER::SOURCE :INCLUDING (QUOTE NIL) :EXCLUDING (QUOTE NIL) :DECODING-AS (QUOTE NIL) :MATERIALIZE-VIEWS (QUOTE NIL) :STATE-BEFORE PGLOADER.PARSER::STATE-BEFORE :STATE-AFTER PGLOADER.PARSER::STATE-AFTER :STATE-INDEXES PGLOADER.PARSER::STATE-IDX :FOREIGN-KEYS NIL) NIL (PGLOADER.UTILS:REPORT-FULL-SUMMARY "Total import time" PGLOADER.PARAMS:*STATE* :BEFORE PGLOADER.PARSER::STATE-BEFORE :FINALLY PGLOADER.PARSER::STATE-AFTER :PARALLEL PGLOADER.PARSER::STATE-IDX))) :START-LOGGER NIL :SUMMARY NIL :LOG-FILENAME NIL :LOG-MIN-MESSAGES NIL :CLIENT-MIN-MESSAGES NIL)
15: ((FLET #:CLEANUP-FUN-267 :IN PGLOADER::MAIN)) [cleanup]
16: (PGLOADER::MAIN ("pgloader" "--with" "no foreign keys" "--debug" "mysql://renate:coosoyduj5go@localhost/renate_with_spree" "postgresql:///renate_with_spree"))
17: ((LAMBDA NIL :IN "/build/pgloader-o2qdpu/pgloader-3.2.2+dfsg/dumper-2SKVI5f7.lisp"))
18: ((FLET #:WITHOUT-INTERRUPTS-BODY-82 :IN SAVE-LISP-AND-DIE))
19: ((LABELS SB-IMPL::RESTART-LISP :IN SAVE-LISP-AND-DIE))


debugger invoked on a QMYND:MYSQL-ERROR in thread
#<THREAD "main thread" RUNNING {1008B846C3}>:
  MySQL Error [1109]: "Unknown table 'referential_constraints' in information_schema"

Type HELP for debugger help, or (SB-EXT:EXIT) to exit from SBCL.

restarts (invokable by number or by possibly-abbreviated name):
  0: [ABORT] Exit application

(INVOKE-DEBUGGER #<QMYND:MYSQL-ERROR {100AA76083}>)
0] 2018-02-17T10:49:32.292000Z DEBUG MySQL: sending query: 
    SELECT tc.table_name, tc.constraint_name, k.referenced_table_name ft,

           group_concat(         k.column_name
                        order by k.ordinal_position) as cols,

           group_concat(         k.referenced_column_name
                        order by k.position_in_unique_constraint) as fcols,

           rc.update_rule, rc.delete_rule

      FROM information_schema.table_constraints tc

           JOIN information_schema.referential_constraints rc
             ON rc.constraint_schema = tc.table_schema
            AND rc.constraint_name = tc.constraint_name
            AND rc.table_name = tc.table_name

      LEFT JOIN information_schema.key_column_usage k
             ON k.table_schema = tc.table_schema
            AND k.table_name = tc.table_name
            AND k.constraint_name = tc.constraint_name

    WHERE     tc.table_schema = 'renate_with_spree'
          AND k.referenced_table_schema = 'renate_with_spree'
          AND tc.constraint_type = 'FOREIGN KEY'
         
         
         

 GROUP BY tc.table_name, tc.constraint_name, ft
2018-02-17T10:49:32.293000Z FATAL We have a situation here.

Я создаю базу данных, в которой проверяю входные данные с помощью триггеров. Я добавил их успешно, но при попытке ввести точные данные возникает ошибка.

Создание БД, таблиц и триггеров

CREATE DATABASE IF NOT EXISTS DBWorkers;

CREATE TABLE IF NOT EXISTS Ludzie(
PESEL char(11) NOT NULL,
imie varchar(30) NOT NULL,
nazwisko varchar(30) NOT NULL,
data_urodzenia date NOT NULL,
wzrost float NOT NULL,
waga float NOT NULL,
rozmiar_buta int NOT NULL,

PRIMARY KEY(PESEL));

DELIMITER $$
CREATE FUNCTION check_pesel(PESEL char(11)) RETURNS bool
BEGIN
IF(
    CHAR_LENGTH(NEW.PESEL) <> 11 AND
    CONVERT(PESEL, SIGNED INT) > 0 AND
    CONVERT(LEFT(PESEL,2), SIGNED INT) BETWEEN 0 AND 99 AND
    CONVERT(SUBSTRING(PESEL,3,2), SIGNED INT) BETWEEN 1 AND 12 AND
    CONVERT(SUBSTRING(PESEL,3,2), SIGNED INT) BETWEEN 1 AND     DAY(LAST_DAY(CONCAT('19',LEFT(PESEL,2),'-',SUBSTRING(PESEL,3,2),'-01')))
    )
    THEN
        RETURN TRUE;
    ELSE
        RETURN FALSE;
END IF;
END $$

CREATE TRIGGER `ludzie_data_check_before_insert` BEFORE INSERT ON `Ludzie`
FOR EACH ROW
BEGIN
IF NOT(
        check_pesel(NEW.PESEL) AND
        NEW.WZROST > 0.0 AND
        NEW.WAGA > 0.0 AND
        NEW.ROZMIAR_BUTA > 0
    )
THEN
    SIGNAL SQLSTATE '45000'
    SET MESSAGE_TEXT = 'check on Ludzie failed during insert';
END IF;
END $$
DELIMITER ;

Когда я пытаюсь ввести данные

INSERT INTO Ludzie VALUES ('7810396705', 'Anders', 'Kennedy','1958-08-20', 1.70, 88.6, 43)

Я получил

Error Code: 1109. Unknown table 'new' in field list

Я уже пробовал включать и выключать сервер mysql, проверял, делаю ли я это с правильной базой данных. Вроде все нормально, но это не так: /

Думаю, я нашел вашу проблему:

CHAR_LENGTH(NEW.PESEL) <> 11 AND
CONVERT(PESEL, SIGNED INT) > 0 AND

Это непоследовательное использование NEW.PESEL и PESEL, вы не должны использовать ключевое слово new в функции, которая ничего не добавляет в базу данных. В этом контексте ошибка распознала NEW как таблицу вместо ключевого слова.

Да, почитав немного, я тоже готов поспорить, что ключевое слово «NEW» не требуется в

CHAR_LENGTH (NEW.PESEL).

Ключевое слово NEW используется в командах обновления и вставки.