error in your SQL syntax #379
Unanswered
guilherme-paiva-castro
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Estou instalando via Xampp, porém com banco de dados Maria DB, mas me deparo com esse erro
Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INT NOT NULL DEFAULT 0,
plan_name
varchar(40) CHARACTER SET utf8mb4 COLLA...' at line 5 in C:\xampp\htdocs\phpnuxbill\install\step4.php:92 Stack trace: #0 C:\xampp\htdocs\phpnuxbill\install\step4.php(92): PDO->exec('\nSET FOREIGN_KE...') #1 {main} thrown in C:\xampp\htdocs\phpnuxbill\install\step4.php on line 92consegue me ajudar a resolver?
já olhando para o PHPNuxBill Updater.
CREATE TABLE
tbl_payment_gateway
(id
int(11) NOT NULL,username
varchar(32) COLLATE utf8mb4_general_ci NOT NULL,gateway
varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'xendit | midtrans',gateway_trx_id
varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',plan_id
int(11) NOT NULL,plan_name
varchar(40) COLLATE utf8mb4_general_ci NOT NULL,routers_id
int(11) NOT NULL,routers
varchar(32) COLLATE utf8mb4_general_ci NOT NULL,price
varchar(40) COLLATE utf8mb4_general_ci NOT NULL,pg_url_payment
varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',payment_method
varchar(32) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',payment_channel
varchar(32) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',pg_request
text COLLATE utf8mb4_general_ci,pg_paid_response
text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,expired_date
datetime DEFAULT NULL,created_date
datetime NOT NULL,paid_date
datetime DEFAULT NULL,status
tinyint(1) NOT NULL DEFAULT '1' COMMENT '1 unpaid 2 paid 3 failed 4 canceled') ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;
Error Failed to connect to database: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'tbl_payment_gateway' already exists
Beta Was this translation helpful? Give feedback.
All reactions