Hi,
when I try to apply for a job,I get this errors:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'recruiter.message' doesn't exist: INSERT INTO {message} (type, arguments, uid, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3); Array ( [:db_insert_placeholder_0] => job_application_recruiter [:db_insert_placeholder_1] => a:0:{} [:db_insert_placeholder_2] => 17 [:db_insert_placeholder_3] => 1476617998 ) in drupal_write_record() (line 7361 of /var/www/html/recruiter/includes/common.inc).
Someone help please?
thanks
Comments
Comment #2
pinkonomy CreditAttribution: pinkonomy commentedThis is a serious bug,it doens't allow me to create a new blogpost (using the core blog module) and probably and other functions in the site.
Anyone help me?
thanks
Comment #3
pinkonomy CreditAttribution: pinkonomy commentedComment #4
pinkonomy CreditAttribution: pinkonomy commentedComment #5
pinkonomy CreditAttribution: pinkonomy commentedI finally solved this,I did this
-First enabled the Message module and then the Job application module
-I rebuild permissions after enabling the Job application module
That's it
Comment #6
pinkonomy CreditAttribution: pinkonomy commentedComment #7
pinkonomy CreditAttribution: pinkonomy commentedComment #8
pinkonomy CreditAttribution: pinkonomy commentedUsing the simpletest.me service it works fine but using it locally it still gives a PDO exception error.Thoughts?
Comment #9
pinkonomy CreditAttribution: pinkonomy commentedComment #10
pinkonomy CreditAttribution: pinkonomy commentedComment #11
pinkonomy CreditAttribution: pinkonomy commentedComment #12
pinkonomy CreditAttribution: pinkonomy commentedAnyone help me on this?Apache shows no information.
thanks
Comment #13
pinkonomy CreditAttribution: pinkonomy commentedThis is what I take when I try to enable the Message module:
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1171 All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead: CREATE TABLE {message} ( `mid` INT unsigned auto_increment DEFAULT NULL COMMENT 'The Unique ID of the message.', `type` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Reference to a message a type.', `arguments` TEXT DEFAULT NULL COMMENT 'Serialized array with the arguments', `uid` INT unsigned DEFAULT NULL COMMENT 'The user ID of the acting user.', `timestamp` INT unsigned NOT NULL COMMENT 'When the message instance was recorded.', `language` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'The languages.language of this message.', PRIMARY KEY (`mid`), INDEX `type_index` (`type`), INDEX `timestamp` (`timestamp`) ) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COMMENT 'An instance of a message type (e.g. like a node is an...'; Array ( ) in db_create_table() (line 2753 of /var/www/html/recruiter7110/includes/database/database.inc).
Comment #14
pinkonomy CreditAttribution: pinkonomy commentedFinally found a solution.I was using Mysql 5.7 on ubuntu 16.04 .AFter downgrading to mysql 5.6 it worked.
Comment #15
pinkonomy CreditAttribution: pinkonomy commented