mployr.com

Topic: Upgrading from 1.5 to 1.6

I wanted to start a discussion on how to upgrade from previous version/1.5 to 1.6. What we're looking for and encourage users is provide information to everyone info on how this is done, what files were changed, added, etc. This will help everyone in the meantime until a module/plugin to auto-upgrade is released.

Code:

1.6 changelog

    * fixed: ‘Invalid use of group function’ exception in class.Stats.php
    * fixed: a database query exception was thrown if the search string contained a city that existed in the DB and ended in a space character (ie: “london “). This happened only for live-searches (via AJAX)
    * fixed: made the select query compatible with mysql 4 in class.SpamReport.php
    * fixed: a database query exception was thrown if the words in the search query were separated by many whitespace characters (ie: “one two three”) delete the jobs but don’t remove the job applications) category were displayed which could lead to huge results because if you’re on the index page you will get *ALL* active jobs from the DB
    * fixed: allow to install jobberbase in a folder called “jobs” - thanks to links
    * fixed: the total number of applications/searches was not computed correctly; return meaningful data even if there are no applications/searches in class.Stats.php
    * fixed: the number of jobs per company was wrong - it also included jobs that are not active
    * fixed: CheckPosterEmail was called needlessly when displaying jobs thus degrading performance (see http://www.jobberbase.com/forum/post2994.html)
    * fixed: although set, the job type (ie: full time, part time) was not remembered in the pagination process and thus the pagination was incorrect
    * fixed: a database query exception was thrown if more than one city was found from the search keywords
    * fixed: the URLs in the mail that is sent after a job is actived by the administrator are wrong
    * fixed: multiple emails were sent to the job poster if the jobberbase based site had google ads - thanks to links
    * fixed: moved stats in admin (/admin/stats/)
    * fix/enh: tweaked the query that gets the job applications so that only applications which still point to a job are returned (in case you manually
    * enh: GetJobsCountForAllCategs makes a single query now instead of a query for *each* category
    * enh: now, only one query is used to get the number of jobs per companies, instead of one query for *each* company
    * enh: if the search query is empty, do nothing - until now (which was pretty confusing from end user point of view), all the jobs for the current
    * added: i18n for labels inside javascript files
    * new: possibility to show cities in sidebar instead of categories (configurable from config.php)
    * new: SEO for Job Categories - thanks to CtCoder
    * new: spotlight jobs (sponsored jobs) - thanks to chronos
    * new: ‘Edit post’ functionality in admin

Would like to comment first?

Entrepreneur? Check this out...
http://www.eugeneg.com/overview/

Chronos

Re: Upgrading from 1.5 to 1.6

The way I did it was to manually apply all fixes that where done since the last version of jobberbase, which makes upgrading to a new version a lot less of a hassle (if done more than once per half year that is).

Check: http://code.google.com/p/jobberbase/source/list

The only downside is that when I copy blocks of code it also takes the 1., 2., 3. rule numbers, maybe there is some firefox extension to avoid this..

Member of Jobberbase Development Team - Implementation and Coding

Visit my Blog: ChronoScripts (JobberBase scripts, support and freelance)
JobBoards: Telefonisch Werk and Top Bijbaan