Don't know the reasoning behind this but it causes a lot of problems for both MS SQL and PostgreSQL. The schema provided with the install and the software using the database don't match. Advice to trust the software and change the schema.
Currently, they do something strange. first declare something as NOT NULL next add DEFAULT "". Unfortunately it is not consistently used.
You have two options to fix this:
1. Remove the NOT NULL for those fields that apparantly don't need a value.
2. Add DEFAULT "" to those fields
Would limit this to the nvarchar type fields with the exception of those used in primarey keys or indexes.
Advice to do this one time on the schema provided as joomla.sql in the joomla installation.
AFAIK there is no such thing as setting is on server level, but DBA's problably can come up with a script to do this for you via the information schema.
This removes the data consistency check from the database and leaves it to the application to do that. While purists will probably dislike that, pragmatic joomla users will get a working environment.
via Joomla! http://ift.tt/1vX2spi
Currently, they do something strange. first declare something as NOT NULL next add DEFAULT "". Unfortunately it is not consistently used.
You have two options to fix this:
1. Remove the NOT NULL for those fields that apparantly don't need a value.
2. Add DEFAULT "" to those fields
Would limit this to the nvarchar type fields with the exception of those used in primarey keys or indexes.
Advice to do this one time on the schema provided as joomla.sql in the joomla installation.
AFAIK there is no such thing as setting is on server level, but DBA's problably can come up with a script to do this for you via the information schema.
This removes the data consistency check from the database and leaves it to the application to do that. While purists will probably dislike that, pragmatic joomla users will get a working environment.
Statistics: Posted by sovainfo — Sat Oct 11, 2014 6:21 pm
via Joomla! http://ift.tt/1vX2spi
No comments:
Post a Comment