summaryrefslogtreecommitdiff
path: root/installer/install.sql
AgeCommit message (Collapse)Author
2013-01-27Add a key on relative_path_cache in the items table to improve performance ↵Bharat Mediratta
on installs that use File_Proxy heavily. Fixes #1920.
2013-01-26#1946, 1947 - Make altered names/slugs more user-friendly, make ↵shadlaws
conflict-finding code check filenames with no extensions - Reduced from four places that alter names/slugs to two (one to populate empty slugs, one to handle conflicting names/slugs). - For empty slugs, fill with generic human-readable name (e.g. "photo") instead of random value. - For conflicting names/slugs, add suffix that's sequential (e.g. "-01"), only using random after 99 conflicts. - Made conflict-finding code check filenames with no extensions. - Renamed _randomize_name_or_slug_on_conflict to _check_and_fix_conflicts. - Added unit tests. Also cleaned up existing unit tests to reflect new logic and removed a redundant test. - Added installer logic to correct existing items now considered in conflict. - Revised gallery_task to look for duplicate names based on new criteria.
2012-12-18[#1928 - Make thumbnail generation more flexible for movies (graphics and ↵shadlaws
movie helpers)] - graphics helper: add movie_extract_frame event to generate function (allows modules to add to the options sent to movie::extract_frame or to generate the thumbnail on their own without movie::extract_frame) - movie helper: add extra optional argument to movie::extract_frame (can add ffmpeg arguments and/or change the frame extract time) - gallery_installer: add movie_extract_time module variable, update to v53 - module.info: update to v53 - install.sql: update to v53
2012-12-16[#1924, #1925, #1927 - enhance compatibility with movies (movie helper) and ↵shadlaws
file types (legal_file helper)] bug fix: modify movie.php helper to take DAR (display aspect ratio) into account in get_file_metadata bug fix / enhancement: add duration to get_file_metadata output bug fix: modify movie.php helper to use correct resolution and duration from get_file_metadata in extract_frame bug fix: modify movie.php helper to be more robust against ffmpeg failures and limitations, including adding "-threads 1" argument if needed enhancement: modified to include ordered maps of extensions to MIME types (get_photo_types_by_extension and get_movie_types_by_extension functions), modified get_file_metadata in movie and photo helpers to use them gallery_installer, module.info, install.sql: updated to v52 with m4v mime correction code (was video/mp4)
2012-11-13[#1907] Added administrative variable to set lock timeout.chalbertgit
2012-10-08Installer for comment module version 6 still set rss_visible to "both"Bharat Mediratta
not "all". Fix that now and rebuild the installer package. Fixes #1917.
2012-07-21Rename any files that have two dots in them to a legal name. ThisBharat Mediratta
fixes the bug where we made those files invalid in 3.0.4 without providing a clean upgrade path. Bump gallery module to 50. Fixes
2012-05-07Oops, fix up a bug originally added inBharat Mediratta
7d66ab2e949bc915f108737f08cac2f9057ef729 when I tweaked the name of the rss_available variable to be rss_visible, but got it wrong. Bump the comment module to 6 so that we run the installer and clean up old vars. Fixes #1854.
2012-05-06Update the installer bundle for the comment module. Fixes #1852.Bharat Mediratta
2011-04-23Further cleanup for minimum_password_length -- updateBharat Mediratta
user_installer::initialize() with the right module version number for the user module and fix the misspelling there then rebuild the installer.sql. #1694.
2011-04-23Set the default value for gallery.timezone to null so that each install usesBharat Mediratta
date_default_timezone_get() in modules/gallery/config/locale.php but it's still overrideable in Admin > Settings > Advanced. Follow on fix for #1637.
2011-04-23Fix ticket #1694. Correct Spelling of mininum_password_length to ↵Tim Almdal
minimum_password_length
2011-04-22A few more fixes for #1637:Bharat Mediratta
- Update gallery_installer::install() to set the version to 48 and set the timezone - Rebuild installer.sql
2011-04-22Allow the administrator to set the number of tags to display in the cloud ↵Tim Almdal
via the advanced settings. Fixes ticket #1649.
2011-04-22Follow on fix for #1645 to update the installer.sqlBharat Mediratta
2011-04-22Renamed apple_touch_url to apple_touch_icon_url.Chad Kieffer
2011-04-22Created apple-touch-icon and added to wind and admin_wind themes.Chad Kieffer
2011-03-27A little more work on kandsten's fix for IPv6 support inBharat Mediratta
10785b1e820c5e10d982c6b49125903886f7b889: - some style cleanup - bump the module version in module.info - rebuild the installer.sql
2011-01-18Get rid of the "organize needs rest" message when upgrading to theBharat Mediratta
new organize; it may be hanging around from a prior version. Reinstate the installer for this. Bump organize module to v4. Follow-on for #1584.
2011-01-17Update installer for #1612 and #1605.Bharat Mediratta
2011-01-16Fixed paging for albums ordered by random.Joe7
MySql has problems when comparing float values against -seemingly same- float input, see http://dev.mysql.com/doc/refman/5.0/en/problems-with-float.html for details. Fixes #1610
2011-01-08Use the code version when installing a module that has no installer,Bharat Mediratta
instead of hardcoding version 1. Fixes #1589.
2011-01-08Bump the organize module to version 3 and get rid of the code thatBharat Mediratta
makes sure that it depends on the REST module.
2011-01-07Don't enable the REST module by default (fixes #1585).Bharat Mediratta
Bump the info module per changes for #662.
2011-01-03Some small follow on fixes for #1559 and #1568:Bharat Mediratta
1) Make database changes in gallery_installer::install() instead of in installer/install.ql 2) Bump the version number in modules/gallery/module.info
2011-01-03Updated installer for the bump of the gallery module to v43. Fixes #1568.Bharat Mediratta
2011-01-03case fixJoe7
2011-01-03Bugfix: input validation validates description up to length of 65535 chars, ↵Joe7
but DB trimmed data over 2048 chars. Converting column into TEXT type. Note: The effective maximum length of a VARCHAR in MySQL 5.0.3 and later is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used. In contrast to CHAR, VARCHAR values are stored as a one-byte or two-byte length prefix plus data. The length prefix indicates the number of bytes in the value. A column uses one length byte if values require no more than 255 bytes, two length bytes if values may require more than 255 bytes.
2010-12-31Update gallery module to v42 to reflect key changes in the cacheBharat Mediratta
table in 440597356d8719bdc6733d2d86aaef5f86d05a1e for #1559.
2010-12-28Added changes to installer and upgrader scripts to support INSERT ON ↵Joe7
DUPLICATE KEY UPDATE SYNTAX in cache lib
2010-10-02Oops, forgot to update installer to match change inBharat Mediratta
f84782d6200efb424731c93bd029c7cbeb9f3dad
2010-09-16Add a module variable containing extra paths to search for binaries.Bharat Mediratta
Fixes ticket #1384.
2010-09-16Restrict viewing user profile pages to registered users only, butBharat Mediratta
provide a "show_user_profiles_to" setting to allow admins to open it up to everybody (choices there are "registered_users", "admin_users" or "everybody"). Fixes ticket #1378.
2010-09-01One more adjustment for ticket #1216. The packaging process forcesBharat Mediratta
the default email address for admin to be unknown@unknown.com and when that happens the gallery_event::user_updated() event listener fires and sets the default values. This is hard to work around, so let's just roll with it and use unknown@unknown.com as our default placeholder. So now, if an admin sets their email address and the current values are unknown@unknown.com we adopt the admin's email address for the site's mail_from/reply_to fields.
2010-08-31Don't use HTTP_HOST to get the hostname. We force that toBharat Mediratta
"example.com" when we are using the CLI so we'll get inconsistent behavior between CLI and the web interface. For now hardcode it to be example.com so that it's clear. But to do it right we need an after_install step which actually fixes it up. And probably an after_upgrade step as well.
2010-08-31Update the install sql to correspond to the change to fix ticket #1216Tim Almdal
2010-08-29Bump gallery module to v36 and add a favicon_url variable, which weBharat Mediratta
expose in Admin > Appearance > Theme Options and defaults to lib/images/favicon.ico. Thix fixes ticket #1312.
2010-08-28Add a "visible_title_length" variable that defaults to 15 and use thatBharat Mediratta
as the max title length when we do title truncation in the wind theme. Bump the gallery module to 35.
2010-08-28Oops, forgot to create an install() function and set the version ofBharat Mediratta
the organize module to 2 in 8fb56abf034dd1f5c561e7af12bf6e097a3de6f6
2010-08-14Add a key on access_caches.item_id. Without this, the Fix task queryBharat Mediratta
to find missing access_caches is very slow. Bump Gallery module to v34.
2010-08-14Update install.sql for gallery module version 3. This was left out ofBharat Mediratta
779d91cca01567a09b894e9fff4dfa32cb82d3d9 but it doesn't cause any real damage, it just means that anybody who got the code in the intervening window and did an initial install required an upgrade as well.
2010-08-06Add a "weight" column to the module table. This allows us to specifyBharat Mediratta
module ordering, which is currently being done in the moduleorder contrib module. By default, the weight will be the same as the id of the row which means that new modules will get added at the end of the list. This is covered in the upgrade case as well. The one gotcha is that we need to make sure that we don't try to sort by the weight column if the gallery module version is < 32, which is something we haven't done before.
2010-08-01Updated for gallery module v31.Bharat Mediratta
2010-06-18Update the installer/install.sql properly.Tim Almdal
2010-06-18Fix ticket #1155. For compatibility with gallery2 increase the size of the ↵Tim Almdal
tag name field from 64 bytes to 128 bytes.
2010-06-15Install the rest module by default.Bharat Mediratta
2010-06-15New dump generated by new mysqladmin has a slightly different format:Bharat Mediratta
mysqladmin Ver 8.42 Distrib 5.1.47, for debian-linux-gnu on i486 Also, updated for comment module v2.
2010-02-22Fix for ticket #1027: Add index on cache key column.Andy Staudacher
(and fix the packager to truncate the cache table before packaging)
2010-02-14Fix for ticket 901: Wrap Gallery version string into bdo tag to override the ↵Andy Staudacher
BiDi algorithm. Also, properly marking the "Powere by" string for translation. See: http://www.w3.org/International/tutorials/bidi-xhtml/#Slide0420
2010-02-09Refresh installer codeAndy Staudacher