Severity: Warning
Message: pg_query(): Query failed: ERROR: syntax error at or near "UNSIGNED" LINE 2: id INT UNSIGNED NOT NULL AUTO_INCREMENT, ^
Filename: postgre/postgre_driver.php
Line Number: 234
Backtrace:
File: /var/www/ci3/application/models/Index_model.php
Line: 7796
Function: query
File: /var/www/ci3/application/models/Index_model.php
Line: 9022
Function: ensure_news_table
File: /var/www/ci3/application/controllers/Index.php
Line: 2199
Function: count_news
File: /var/www/ci3/index.php
Line: 292
Function: require_once
Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /var/www/ci3/system/core/Exceptions.php:272)
Filename: core/Common.php
Line Number: 571
Backtrace:
File: /var/www/ci3/application/models/Index_model.php
Line: 7796
Function: query
File: /var/www/ci3/application/models/Index_model.php
Line: 9022
Function: ensure_news_table
File: /var/www/ci3/application/controllers/Index.php
Line: 2199
Function: count_news
File: /var/www/ci3/index.php
Line: 292
Function: require_once
Error Number:
ERROR: syntax error at or near "UNSIGNED" LINE 2: id INT UNSIGNED NOT NULL AUTO_INCREMENT, ^
CREATE TABLE IF NOT EXISTS uzexiao_news ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, title VARCHAR(255) NOT NULL, category VARCHAR(50) NOT NULL DEFAULT '汽车要闻', cover VARCHAR(255) DEFAULT NULL, content MEDIUMTEXT, summary VARCHAR(600) DEFAULT NULL, source_site VARCHAR(50) DEFAULT NULL, source_url VARCHAR(600) DEFAULT NULL, source_ts INT DEFAULT 0, author VARCHAR(50) DEFAULT NULL, status TINYINT UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=已发布 0=草稿', is_scraped TINYINT UNSIGNED NOT NULL DEFAULT 0, is_polished TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT '0=待润色 1=已润色', created_at INT NOT NULL, updated_at INT NOT NULL, published_at INT DEFAULT 0, PRIMARY KEY (id), KEY idx_cat_status (category, status), KEY idx_source_url (source_url(191)), KEY idx_source_ts (source_ts) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Filename: models/Index_model.php
Line Number: 7796