mysql - 尝试为 zencart 运行 SQL 查询时出现意外 token 问题

Question

我对此相当陌生，我正在尝试在附加组件中运行以下查询 - Add Pages to More Information Sidebox

有人能看到我看不到的东西吗？ PHPmyadmin 在以下三个查询中均显示许多意外的 token 问题!

Unexpected Tokens

查询#1:

insert into configuration (configuration_title, configuration_key, configuration_value, 
configuration_description, configuration_group_id, sort_order, last_modified, date_added, 
use_function, set_function) values ('Define Page 5', 'DEFINE_PAGE_5_STATUS', '1', 'Enable 
the Defined Page 5 Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define 
Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', '25', '85', 
now(), now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),');

查询#2:

insert into configuration (configuration_title, configuration_key, configuration_value, 
configuration_description, configuration_group_id, sort_order, last_modified, date_added, 
use_function, set_function) values ('Define Page 6', 'DEFINE_PAGE_6_STATUS', '1', 'Enable 
the Defined Page 6 Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define 
Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', '25', '85', 
now(), now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),');

查询#3:

insert into configuration (configuration_title, configuration_key, configuration_value, 
    configuration_description, configuration_group_id, sort_order, last_modified, date_added, 
    use_function, set_function) values ('Define Page 7', 'DEFINE_PAGE_7_STATUS', '1', 'Enable 
    the Defined Page 7 Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define 
    Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', '25', '85', 
    now(), now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'),');

肯定有一些我看不到的东西，但我对此还是新手!预先感谢您的任何帮助和/或指导!

Answer 1

问题出在INSERT语句最后插入数据zen_cfg_select_option上。

您应该'zen_cfg_select_option(array(\'0\',\'1\',\'2\',\'3\'),') 插入 'zen_cfg_select_option(array(\'0\',\'1\',\'2\',\'3\'))'

顺便说一句，你下次可以在sql语句上设置一下排版，也许你就能找出问题所在了。

查询 1

insert into configuration 
(
    configuration_title, 
    configuration_key, 
    configuration_value, 
    configuration_description, 
    configuration_group_id, 
    sort_order, 
    last_modified, 
    date_added, 
    use_function, 
    set_function
) 
values 
(
    'Define Page 5', 
    'DEFINE_PAGE_5_STATUS', 
    '1', 
    'Enable the Defined Page 5 Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF',
    '25',
    '85', 
    now(), 
    now(), 
    NULL, 
    'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\')'
);

查询 2

INSERT INTO configuration 
(
    configuration_title, 
    configuration_key, 
    configuration_value, 
    configuration_description, 
    configuration_group_id, 
    sort_order, 
    last_modified, 
    date_added, 
    use_function, 
    set_function
) 
VALUES 
(
    'Define Page 6', 
    'DEFINE_PAGE_6_STATUS', 
    '1', 
    'Enable the Defined Page 6 Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF',
    '25', 
    '85', 
    now(), 
    now(), 
    NULL, 
    'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\')'
);

查询3

INSERT INTO configuration 
(
    configuration_title, 
    configuration_key, 
    configuration_value, 
    configuration_description, 
    configuration_group_id, 
    sort_order, 
    last_modified, 
    date_added, 
    use_function, 
    set_function
) 
VALUES 
(
    'Define Page 7', 
    'DEFINE_PAGE_7_STATUS', 
    '1', 
    'Enable the Defined Page 7 Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', 
    '25', 
    '85', 
    now(), 
    now(),
    NULL, 
    'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'))'
);