[#4969] - Postgres multilang install fixes
- Closed
- 7 Nov 2014
- Medium
- Build: staging
- # 4969
- Diff
- wilsonge:patch-24
- Success The Travis CI build passed Details
User tests: Successful: Unsuccessful:
Executive Summary
The multilingual installer will not install sample data in postgres. This fixes it.
More detail
Various not null fields are not passed into the data being binded in the multilingual installer. To avoid this I've used the bind method to ensure the rules are created properly and added in the missing fields
Testing instructions
In mysql ensure that the multilingual installer continues to work as expected when installing data (make sure you enable all 3 options for data to install to test all options)
In postgres you can try running the multilingual installer first to prove there are errors. Note the languages will install thanks to previous PR's however the data will not be added correctly. Note you MUST test this with the staging branch. Apply the patch and all the data should be created properly (make sure you enable all 3 options for data to install to test all options). This includes the language switcher module, content, category and menu items.
jissues-bot
- | Labels |
Added:
?
|
||
| Category | ⇒ | Postgresql |
mysqli installation went fine, but when going in the category manager there is a warning that doesn´t appear when installing without the patch:
Warning: str_repeat(): Second argument has to be greater than or equal to 0 in 192.168.1.17\joomla33_test\administrator\components\com_categories\views\categories\tmpl\default.php on line 167postgres installation went fine and as you described many core components are broken as long as the language filter is published (same warning as with mysqli)
@waader @infograf768 Can you retest please? Should have fixed that issue with categories
Will test tomorrow
With Postgres I get the following error in launching the category manager:
Error
Database query failed (error # %s): %s SQL=SELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language,l.title AS language_title,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,COUNT(asso2.id)>1 as association FROM couj5_categories AS a LEFT JOIN "couj5_languages" AS l ON l.lang_code = a.language LEFT JOIN couj5_users AS uc ON uc.id=a.checked_out LEFT JOIN couj5_viewlevels AS ag ON ag.id = a.access LEFT JOIN couj5_users AS ua ON ua.id = a.created_user_id LEFT JOIN couj5_associations AS asso ON asso.id = a.id AND asso.context='com_categories.item' LEFT JOIN couj5_associations AS asso2 ON asso2.key = asso.key WHERE a.extension = 'com_content' AND (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.lft asc Database query failed (error # %s): %s SQL=SELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language,l.title AS language_title,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,COUNT(asso2.id)>1 as association FROM couj5_categories AS a LEFT JOIN "couj5_languages" AS l ON l.lang_code = a.language LEFT JOIN couj5_users AS uc ON uc.id=a.checked_out LEFT JOIN couj5_viewlevels AS ag ON ag.id = a.access LEFT JOIN couj5_users AS ua ON ua.id = a.created_user_id LEFT JOIN couj5_associations AS asso ON asso.id = a.id AND asso.context='com_categories.item' LEFT JOIN couj5_associations AS asso2 ON asso2.key = asso.key WHERE a.extension = 'com_content' AND (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.lft asc LIMIT 20 Database query failed (error # %s): %s SQL=SELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language,l.title AS language_title,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,COUNT(asso2.id)>1 as association FROM couj5_categories AS a LEFT JOIN "couj5_languages" AS l ON l.lang_code = a.language LEFT JOIN couj5_users AS uc ON uc.id=a.checked_out LEFT JOIN couj5_viewlevels AS ag ON ag.id = a.access LEFT JOIN couj5_users AS ua ON ua.id = a.created_user_id LEFT JOIN couj5_associations AS asso ON asso.id = a.id AND asso.context='com_categories.item' LEFT JOIN couj5_associations AS asso2 ON asso2.key = asso.key WHERE a.extension = 'com_content' AND (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.lft asc LIMIT 20
OK in mysqli. Merging. Thanks.
| Milestone |
Added: |
||
| Status | Pending | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2014-11-07 11:16:23 |
@test
Multilanguage installation went fine on mysqli