In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
680 [In-Portal CMS] Install / Upgrages bug report always 2010-04-06 10:27 2010-05-11 02:59
Dmitry  
alex  
critical  
closed 5.0.3-B1  
fixed  
 
none 5.0.3-B2  
0
0000680: SQL error during clean Installation of In-News module
SQL error during Fresh Installation of In-News module.

Error occurs on the next step after modules for installation have been selected.

Error reads:

===========
Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '})' at line 1

INSERT INTO Permissions VALUES (DEFAULT, 'NEWS.VIEW', 14, 1, 0, {NewsCatId})
===========
child of 0000641closed  (5.0.3)alex MultiLanguage formatter incorrectly processes translatable virtual fields 
patch module_category_not_created_at_install.patch (3,121) 2010-04-06 11:04
http://tracker.in-portal.org/file_download.php?file_id=444&type=bug
Issue History
2010-05-11 02:59 alex Note Added: 0002091
2010-05-11 02:59 alex Status resolved => closed
2010-04-06 12:36 alex Note Added: 0001830
2010-04-06 12:36 alex Status reviewed and tested => resolved
2010-04-06 12:36 alex Fixed in Version => 5.0.3-B2
2010-04-06 12:36 alex Resolution open => fixed
2010-04-06 12:36 alex Changeset attached 5.0.x r13355
2010-04-06 11:40 Dmitry Note Added: 0001829
2010-04-06 11:40 Dmitry Assigned To !COMMUNITY => alex
2010-04-06 11:40 Dmitry Status needs testing => reviewed and tested
2010-04-06 11:08 alex Relationship added child of 0000641
2010-04-06 11:07 alex Note Added: 0001828
2010-04-06 11:07 alex Assigned To => !COMMUNITY
2010-04-06 11:07 alex Status active => needs testing
2010-04-06 11:04 alex File Added: module_category_not_created_at_install.patch
2010-04-06 10:27 Dmitry Developer => alex
2010-04-06 10:27 Dmitry Priority normal => critical
2010-04-06 10:27 Dmitry New Issue

Notes
(0001828)
alex   
2010-04-06 11:07   
There a 2 things, that this patch fixes:
1. multi language formatter didn't added translatable field to virtual field list, so it will be skipped during dbitem update.

2. site config was applied multiple times during installation, since we called OnAfterConfigRead for "c" prefix multiple times to update custom field list, that were added dynamically
(0001829)
Dmitry   
2010-04-06 11:40   
Patch successfully tested on both - Clean install and Upgrade (from 5.0.1 to 5.0.3-B2).

Also, so basic operation were tested as well.

Pleased commit
(0001830)
alex   
2010-04-06 12:36   
Fix committed to 5.0.x branch. Commit Message:

Fixes 0000680: SQL error during clean Installation of In-News module
(0002091)
alex   
2010-05-11 02:59   
Closing all tasks from released versions.