找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 1589|回复: 2

[ShopEx] 安装出错,Warning: drop table if exists sdb_settings:No database selected

[复制链接]
发表于 2013-1-3 15:23:37 | 显示全部楼层 |阅读模式
本帖最后由 小白 于 2013-1-3 15:28 编辑

安装shopex时出现这样的错误是怎么回事?

安装失败


Warning: drop table if exists sdb_settings:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_settings` ( `s_name` varchar(16) not null default '', `s_data` longtext, `s_time` int(10) unsigned not null default '0', `disabled` enum('true','false') default 'false', primary key (s_name) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_plugins:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_plugins` ( `plugin_id` mediumint(8) unsigned not null auto_increment, `plugin_ident` varchar(100) not null default '', `plugin_name` varchar(100) not null default '', `plugin_type` enum('io','schema','hook','pmt','local','messenger','pay','passport','admin','shop','action','app','mdl') not null default 'io', `app_type` varchar(100) not null default '', `plugin_base` enum('0','9') not null default '0', `plugin_version` varchar(100) default '1.0', `plugin_author` varchar(100), `plugin_package` varchar(100), `plugin_website` varchar(200), `plugin_updatechec` varchar(200), `plugin_desc` text, `plugin_hasopts` enum('true','false') not null default 'false', `plugin_struct` text, `plugin_config` text, `plugin_path` varchar(255) not null default '', `plugin_mode` enum('file','dir') not null default 'file', `status` enum('unused','used','broken') not null default 'unused', `disabled` enum('true','false') not null default 'false', `plugin_mtime` int(11) not null default 0, primary in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_coupons:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_coupons` ( `cpns_id` mediumint(8) unsigned not null auto_increment, `cpns_name` varchar(255), `pmt_id` mediumint(8) unsigned, `cpns_prefix` varchar(50) not null default '', `cpns_gen_quantity` mediumint(8) unsigned not null default 0, `cpns_key` varchar(20) not null default '', `cpns_status` enum('0','1') not null default '1', `cpns_type` enum('0','1','2') not null default '1', `cpns_point` mediumint(8) unsigned, `disabled` enum('true','false') default 'false', primary key (cpns_id), INDEX ind_disabled(`disabled`), INDEX ind_cpns_prefix(`cpns_prefix`) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_triggers:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_triggers` ( `trigger_id` int(11) not null auto_increment, `filter_str` varchar(255) not null default '', `action_str` varchar(255) not null default '', `trigger_event` varchar(100) not null default '', `trigger_memo` varchar(100), `trigger_define` text not null, `trigger_order` tinyint(4) not null default 5, `active` enum('true','false') default 'false', `disabled` enum('true','false') not null default 'false', primary key (trigger_id) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_coupons_u_items:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_coupons_u_items` ( `order_id` bigint(20) unsigned not null default 0, `cpns_id` mediumint(8) unsigned not null default 0, `cpns_name` varchar(255), `memc_code` varchar(255), `cpns_type` enum('0','1','2'), primary key (order_id,cpns_id) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_refunds:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_refunds` ( `refund_id` bigint(20) unsigned not null auto_increment, `order_id` bigint(20) unsigned, `member_id` mediumint(8) unsigned, `account` varchar(50), `bank` varchar(50), `pay_account` varchar(250), `currency` varchar(8), `money` decimal(20,3) not null default '0', `pay_type` enum('online','offline','deposit','recharge') default 'offline', `payment` mediumint(8) unsigned not null default 0, `paymethod` varchar(100), `ip` varchar(20), `t_ready` int(10) unsigned not null default 0, `t_sent` int(10) unsigned, `t_received` int(10) unsigned, `status` enum('ready','progress','sent','received','cancel') not null default 'ready', `memo` longtext, `title` varchar(255) not null default '', `send_op_id` mediumint(8) unsigned, `disabled` enum('true','false') not null default 'false', `trade_no` varchar(30), primary key (refund_id), INDEX ind_disabled(`disabled`) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_pmt_goods:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: select plugin_id,plugin_ident, plugin_name,plugin_type,plugin_base,plugin_version,plugin_author,plugin_package,plugin_website,plugin_hasopts,plugin_path,status,disabled,plugin_mtime,plugin_struct from sdb_plugins where plugin_type="app":No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: select s_data from sdb_settings where s_name='certificate' LIMIT 0, 1:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_pmt_goods` ( `pmt_id` mediumint(8) unsigned not null default 0, `goods_id` mediumint(8) unsigned not null default 0, `count` mediumint(8) unsigned default 0, primary key (pmt_id,goods_id) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_dly_center:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_dly_center` ( `dly_center_id` int(10) unsigned not null auto_increment, `name` varchar(50) not null default '', `address` varchar(200) not null, `region` varchar(255), `zip` varchar(20), `phone` varchar(100), `uname` varchar(100), `cellphone` varchar(100), `sex` enum('female','male'), `memo` longtext, `disabled` enum('true','false') not null default 'false', primary key (dly_center_id), INDEX ind_disabled(`disabled`) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_job_data_sync:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_job_data_sync` ( `job_id` int(10) unsigned not null auto_increment, `from_time` int(10) unsigned not null default 0, `to_time` int(10) unsigned not null default 0, `page` mediumint(8) unsigned not null default 0, `limit` mediumint(8) unsigned not null default 0, `supplier_id` int(10) unsigned not null default 0, `supplier_pline` longtext, `auto_download` enum('true','false') not null default 'false', `to_cat_id` mediumint(8) unsigned, primary key (job_id) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_msgqueue:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_msgqueue` ( `queue_id` mediumint(8) unsigned not null auto_increment, `title` varchar(250), `target` varchar(250) not null default '', `event_name` varchar(50), `data` longtext, `tmpl_name` varchar(50) not null default '', `level` tinyint(3) unsigned not null default 5, `sender` varchar(50) not null default '', `sender_order` tinyint(3) unsigned not null default 5, `message` longtext, `status` enum('ready','succ','fail') default 'ready', `error_msg` varchar(255), `sendnum` smallint(6), `send_time` int(10) unsigned default 0, primary key (queue_id), INDEX ind_level(`level`) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_goods_cat:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_goods_cat` ( `cat_id` int(10) not null auto_increment, `parent_id` int(10), `supplier_id` int(10) unsigned, `supplier_cat_id` mediumint(8) unsigned, `cat_path` varchar(100) default ',', `is_leaf` enum('true','false') not null default 'false', `type_id` int(10), `cat_name` varchar(100) not null default '', `disabled` enum('true','false') not null default 'false', `p_order` mediumint(8) unsigned, `goods_count` mediumint(8) unsigned, `tabs` longtext, `finder` longtext, `addon` longtext, `child_count` mediumint(8) unsigned not null default 0, primary key (cat_id), INDEX ind_cat_path(`cat_path`), INDEX ind_disabled(`disabled`) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_currency:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_currency` ( `cur_code` varchar(8) not null default '', `cur_name` varchar(20) not null default '', `cur_sign` varchar(5), `cur_rate` decimal(10,4) not null default '1.0000', `def_cur` enum('true','false') not null default 'false', `disabled` enum('true','false') default 'false', primary key (cur_code), INDEX ind_disabled(`disabled`) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_autosync_task:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_autosync_task` ( `supplier_id` int(10) unsigned not null default '0', `command_id` int(10) unsigned not null default '0', `local_op_id` mediumint(8) unsigned default '0', primary key (supplier_id,command_id) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_gimages:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_gimages` ( `gimage_id` mediumint(8) unsigned not null auto_increment, `goods_id` mediumint(8) unsigned, `is_remote` enum('true','false') not null default 'false', `source` varchar(255) not null default '', `orderby` tinyint(3) unsigned not null default 0, `src_size_width` int(10) unsigned not null default 0, `src_size_height` int(10) unsigned not null default 0, `small` varchar(255), `big` varchar(255), `thumbnail` varchar(255), `up_time` int(10) unsigned not null default 0, `supplier_id` int(10) unsigned, `supplier_gimage_id` mediumint(8) unsigned, `sync_time` int(10) unsigned default 0, primary key (gimage_id), INDEX ind_up_time(`up_time`) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_trust_login:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_trust_login` ( `login_id` mediumint(8) unsigned not null auto_increment, `member_id` mediumint(8) unsigned not null default 0, `uname` varchar(50) not null default '', `member_refer` varchar(50) not null default '', `show_uname` varchar(50) default '', primary key (login_id), INDEX ind_id(`member_id`) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_magicvars:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_magicvars` ( `var_name` varchar(20) not null, `var_title` varchar(100), `var_remark` varchar(100) not null, `var_value` text, `var_type` enum('system','custom') not null default 'custom', `disabled` enum('true','false') not null default 'false', primary key (var_name) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_package_product:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_package_product` ( `product_id` mediumint(8) unsigned not null default 0, `goods_id` mediumint(8) unsigned not null default 0, `discount` decimal(5,3), `pkgnum` mediumint(8) unsigned not null default 1, primary key (product_id,goods_id) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_autosync_rule:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_autosync_rule` ( `rule_id` mediumint(8) unsigned not null auto_increment, `supplier_op_id` tinyint(3) not null default '0', `local_op_id` tinyint(3) not null default '0', `disabled` enum('true','false') not null default 'false', `memo` varchar(255), `rule_name` varchar(255) not null, primary key (rule_id), INDEX index_1(`rule_id`,`local_op_id`,`disabled`) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_supplier:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_supplier` ( `sp_id` mediumint(8) unsigned not null auto_increment, `supplier_id` int(10) unsigned not null default 0, `supplier_brief_name` varchar(30), `status` tinyint(4) not null default '1', `supplier_pline` longtext, `sync_time` int(10) unsigned not null default '0', `domain` varchar(255) not null, `has_new` enum('true','false') not null default 'true', `has_cost_new` enum('true','false') not null default 'false', `sync_time_for_plat` int(10) unsigned not null default '0', primary key (sp_id), INDEX supplier_id(`supplier_id`) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_gtask:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_gtask` ( `goods_id` mediumint(8) unsigned, `tasktime` int(10) unsigned not null default 0, `action` enum('online','offline') not null default 'online', INDEX tasktime(`tasktime`), INDEX goods(`goods_id`) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_promotion_activity:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_promotion_activity` ( `pmta_id` mediumint(8) unsigned not null auto_increment, `pmta_name` varchar(200), `pmta_enabled` enum('true','false'), `pmta_time_begin` int(10) unsigned, `pmta_time_end` int(10) unsigned, `pmta_describe` longtext, `disabled` enum('true','false') default 'false', primary key (pmta_id), INDEX ind_disabled(`disabled`) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_orders:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_orders` ( `order_id` bigint(20) unsigned not null default 0, `paipai_order_id` varchar(50) not null default 0, `member_id` mediumint(8) unsigned, `confirm` enum('Y','N') not null default 'N', `status` enum('active','dead','finish') not null default 'active', `pay_status` enum('0','1','2','3','4','5') not null default '0', `ship_status` enum('0','1','2','3','4') not null default '0', `user_status` enum('null','payed','shipped') not null default 'null', `is_delivery` enum('Y','N') not null default 'Y', `shipping_id` smallint(4) unsigned, `shipping` varchar(100), `shipping_area` varchar(50), `payment` mediumint(9), `weight` decimal(20,3), `tostr` longtext, `itemnum` mediumint(8) unsigned, `acttime` int(10) unsigned, `delivery_time` int(10) unsigned, `delivery_delay_time` int(10) unsigned, `createtime` int(10) unsigned, `refer_id` varchar(50), `refer_url` varchar(200), `refer_time` int(10) unsigned, `c_refer_id` varchar(50), `c_refer_url` varchar(200), `c_refer_time` in in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

...


Warning: drop table if exists sdb_goods_lv_price:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_goods_lv_price` ( `product_id` mediumint(8) unsigned not null default 0, `level_id` mediumint(8) unsigned not null default 0, `goods_id` mediumint(8) unsigned not null default 0, `price` decimal(20,3), primary key (product_id,level_id,goods_id) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: drop table if exists sdb_seo:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58

Warning: CREATE TABLE `sdb_seo` ( `seo_id` mediumint(8) unsigned not null auto_increment, `source_id` varchar(100) not null, `type` varchar(50) not null, `store_key` varchar(100) not null, `value` text not null, primary key (seo_id) )ENGINE = MyISAM DEFAULT CHARACTER SET utf8;:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58
数据库安装成功

Warning: INSERT INTO `sdb_goods_cat` (`cat_id`, `parent_id`, `supplier_id`, `supplier_cat_id`, `cat_path`, `is_leaf`, `type_id`, `cat_name`, `disabled`, `p_order`, `goods_count`, `tabs`, `finder`, `addon`, `child_count`) VALUES(1, 0, NULL, NULL, ',', 'true', 1, '我的分类', 'false', 99, NULL, NULL, NULL, 'a:1:{s:4:"meta";a:2:{s:8:"keywords";s:0:"";s:11:"description";s:156:" \r\n \r\n \r\n \r\n \r\n \r\n ";}}', 0);:No database selected in /home/diqiou21/public_html/core/include_v5/AloneDB.php on line 58
安装系统内置数据失败!
回复

使用道具 举报

发表于 2013-1-3 15:27:15 | 显示全部楼层
这个应该是数据库用户权限不够,检查下数据库用户的权限
回复 支持 反对

使用道具 举报

 楼主| 发表于 2013-1-3 15:29:41 | 显示全部楼层
原来是这样啊,搞定了,多谢!
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|Archiver|手机版|小黑屋|王牌互联

GMT+8, 2024-11-17 02:29 , Processed in 0.037787 second(s), 17 queries .

Powered by Discuz! X3.5

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表