Skip to content

[Error] WordPress database error #61

@guneetnarula

Description

@guneetnarula

Logs show the following error:

[error] 2003#2003: *25084010 FastCGI sent in stderr: "PHP message: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank INT DEFAULT 0,
			survey_id BIGINT(20) NOT NULL,
			PRIMARY KEY(ID)
		) DEF' at line 5 for query CREATE TABLE IF NOT EXISTS ykas_space_page (
			ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
			title VARCHAR(255) NOT NULL,
			description TEXT,
			rank INT DEFAULT 0,
			survey_id BIGINT(20) NOT NULL,
			PRIMARY KEY(ID)
		) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci; made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/space-survey/space-survey.php'), require_once('/plugins/space-survey/db/db.php'), require_once('/plugins/space-survey/db/class-space-db-survey.php'), SPACE_BASE::getInstance, SPACE_DB_SURVEY->__construct, require_once('/plugins/space-survey/db/class-space-db-page.php'), SPACE_BASE::getInstance, SPACE_DB_PAGE->__construct... 
PHP message: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank INT DEFAULT 0,
			PRIMARY KEY(ID)
		) DEFAULT CHARACTER SET utf8mb4 COLLATE' at line 5 for query CREATE TABLE IF NOT EXISTS ykas_space_page_question_relation (
			ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
			page_id BIGINT(20) NOT NULL,
			question_id BIGINT(20) NOT NULL,
			rank INT DEFAULT 0,
			PRIMARY KEY(ID)
		) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci; made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/space-survey/space-survey.php'), require_once('/plugins/space-survey/db/db.php'), require_once('/plugins/space-survey/db/class-space-db-survey.php'), SPACE_BASE::getInstance, SPACE_DB_SURVEY->__construct, require_once('/plugins/space-survey/db/class-space-db-page.php')

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions