Comments (5)
数据库迁移过去,程序肯定没问题。
from yii2cmf.
那如果在安装的时候有选择安装数据库的类型,就可以直接安装成postgresql了,甚至可以新增其他的数据库支持,这样就更通用了
from yii2cmf.
我已经把mysql数据库转换为pgsql了,大部分没问题,还是有些地方有问题
from yii2cmf.
这数据库没玩过 = =大概什么错误呢
from yii2cmf.
有好几个地方那个,主要都是数据库sql语句的问题,存在不兼容的现象,因为mysql的语句有些不是标准的sql语句,比如说创建文章的时候:
common--》models->Category.php里面:130行
$query->where(new Expression("FIND_IN_SET('{$module}', module) "));
这个sql语句,里面的函数FIND_IN_SET,再postgres里面没有,所以会出错。
主要postgres数据库的功能挺强,事物,地理位置,空间类型,还有强大的json类型,基本上你需要的类型里面都可以直接提供
要不然我把数据库发你,你试试看
链接: https://pan.baidu.com/s/1gfsWc99 密码: 98h6
from yii2cmf.
Related Issues (20)
- 源码和示例网站的源码貌似不一致 HOT 1
- 建议修改前台页面布局 HOT 2
- 全新安装,在输入管理员信息界面提示:数据表已经存在,或者其他错误! HOT 2
- 非常遗憾,好多文件丢失 HOT 6
- 前台,跟好友发私信的链接也是错的 HOT 12
- 请教 composer.lock 可否删除 HOT 1
- 存储位置不对 HOT 2
- 前台发私信显示成功,但对方收不到 HOT 2
- 菜单管理,修改路由时,一直提示 Route "/article/index" not found. HOT 3
- 发表评论 Editormd 无法发表图片 HOT 1
- 还出vue版本吗?
- frontend/themes/basic/static/js/site.js问题
- 登录页面css的一个小错误 HOT 1
- 搜索框无法搜索的问题 HOT 2
- 用户信息浮动窗口出现后点击窗口中的图片才会消失
- 登录后直接输入新密码即可修改密码不安全
- 添加和修改用户时,密码应重复输入两遍
- tab+iframe显示异常 HOT 1
- 这里的env函数没效果,应该是getenv才对啊,不是吗?
- is there anyone here ? HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from yii2cmf.