Hey everyone,
Osclass 8.0 has been released today and is next milestone to create best classifieds script.
There are several very important topics, make sure to read them

Changelog: https://osclass-classifieds.com/changelog
Read about changes on blog: https://osclasspoint.com/blog/osclass-v8-release-continuous-development-setup-b37

• Versioning of script changed and skipped to not occupied 8.x.x range.
  Originally osclass 4.5, is released as 8.0.0 to avoid misunderstandings and complications caused with other branches.
  Change in major versions frequency, where major version will be changed once per year and smaller updates will be delivered more frequently as minor versions.
• Locations v3.0 introduced:
  Base dataset has size ~2GB and is stored on our servers.
  Much better accuracy: 3x more cities comparing to locations v2.0 (15k vs 45k).
  4 more countries added.
  Improved generator of locations slug.
• IMPORTANT: oc-admin folder can now be easily changed/renamed.
  Once folder is renamed in file system, use OC_ADMIN_FOLDER in config.php to define name of new folder.
  Example: define('OC_ADMIN_FOLDER', 'admi224');
• Child themes feature has been redesigned:
  osc_current_web_theme_path, osc_current_web_theme_url - functions will now "hard" check child theme folders to identify child files.
  osc_current_web_theme_path_value - new function created - function work in same way as osc_current_web_theme_url and return expected path.
  Much better functionality at all, now it is not required to create all theme files for proper functionality of child theme.
  No changes has been made in way how child theme is created and setup.
• Ban rules improvements:
  Ban rules page in oc-admin now contains pagination & search options. Keyword will be searched against name, email and IP of ban rule.
  New examples when creating/editing ban rules, size of inputs has been changed. Show more button removed in ban rules list.
  You can now enter multiple emails into 1 ban rule (separated by comma).
  Ban rules summary has been added into oc-admin home page dashboard.
• Added new custom fields types: PHONE, EMAIL, COLOR, NUMBER.
  IMPORTANT: input types for custom fields has changed and will use now correct HTML5 type (except date field): URL > url, EMAIL > email, PHONE > tel, COLOR > color, NUMBER > number, TEXT > text.
  Design of custom fields page in backoffice has been slightly adjusted and inputs has been resized.
• Updated translit from Cyrilic into Latin for URLs.
• New widget added: Latest product updates on OsclassPoint.com, where you can see last 5 updated products, date, current version, supported osclass version and what has changed.
• Configuration information in oc-admin does not calculate folder sizes and permissions by default to avoid resource wasting and speed-up page loading.
  Admin can run configuration information with details ("Run with details" button) in case these data are needed.
• New function created: osc_theme_get_info($theme):
  Returns information about front-office theme (from index.php of theme). Enter only theme name (name of theme folder). Example: bender, sigma, delta
• Default number of listings matching alert in User > Alerts changed from 3 to 12.
• Added category object into extendData and extendDataSingle functions, so it easy to identify if category has price enabled or not.
• Added "Changelog" menu item under "Tools", so you can now easily see what has changed in last versions.
• Admin can now easily show all plugins available for update in Plugins section.
• Admin hook admin_content_footer has been removed.
• Updated composer dependencies to latest available versions.
• Engine of all database tables has been consolidated.
• Category ID is now visible in oc-admin when editing categories as tooltip on category name and as header in category edit form/iframe.
• Updated notice text in all files, based on Apache version, if this file is present in original file, it must be present on all branches with copyright mention.
• Function osc_user_phone will now return primary mobile phone number, and if not exists, then return land phone number (if exists).
• Native location names are now available in premiums section as well. No modifications in themes are required.
• Optimized minified CSS & JavaScript files will now be cleaned and refreshed on following actions: activate theme, install plugin, uninstall plugin, activate plugin, deactivate plugin.
• Fixed minor issue those could generate error with cookies.
• Fixed incorrect information in backoffice how to enable debug logs.
• Fixed possible problems with API key validation.
• Fixed problem with "Phone visible on ad" checkbox on publish page, is by default properly checked when adding new listing.
• Fixed design of flash messages in some plugins.
• Fixed bug, when theme appeared as eligible for update (need update) after performing its update.
• Fixed bug, when plugin appeared as eligible for update (need update) after performing its update.
• Fixed bug with sanitizing user/item URL and phone data (XSS vulnerability in URL custom fields).
• Fixed bug in Sigma theme regarding image uploader in user profile.
• Fixed typo in oc-admin > Settings > Categories, corrected "Expiration dates" to "Expiration days".
• Fixed changelog design in backoffice.
• Fixed incorrect alignments in Sigma theme for RTL languages.

Please beware that during upgrade you may get fake warnings from database.

• automatic updates - click on dashboard and continue with upgrade
• manual update - simply click to continue with upgrade

 

Hi.
this is what i get when i upgrade afret thid error 500 in admin page, tried thid 3 times and the same
upgrading from 4.4.0

Upgrade
Upgrading your Osclass installation (this could take a while):
ALTER TABLE oc_t_item_location DROP FOREIGN KEY oc_t_item_location_ibfk_2
ALTER TABLE oc_t_item_location DROP FOREIGN KEY oc_t_item_location_ibfk_4
ALTER TABLE oc_t_item_location DROP FOREIGN KEY oc_t_item_location_ibfk_6
ALTER TABLE oc_t_item_location DROP FOREIGN KEY oc_t_item_location_ibfk_8
ALTER TABLE oc_t_item_location DROP FOREIGN KEY oc_t_item_location_ibfk_9
ALTER TABLE oc_t_item_meta DROP FOREIGN KEY oc_t_item_meta_ibfk_3
ALTER TABLE oc_t_item_meta DROP FOREIGN KEY oc_t_item_meta_ibfk_4
ALTER TABLE oc_t_item_resource DROP FOREIGN KEY oc_t_item_resource_ibfk_2
ALTER TABLE oc_t_item_stats DROP FOREIGN KEY oc_t_item_stats_ibfk_2
Osclass has some errors
We've encountered some problems while updating the database structure. The following queries failed:

ALTER TABLE oc_t_preference ADD UNIQUE KEY (s_section, s_name)

Those look like ghost errors as these updates osclass performs because of change in struct.sql.
Have you tried manual upgrade? You may PM me ftp login and will check it in detail.

@Nagy
I've took a detail look on what is going on behind hood and problem should be resolved by adding this line:
define('AUTO_UPGRADE', true);       

above this line:
require(LIB_PATH.'osclass/upgrade-funcs.php');
in file:
oc-admin/upgrade.php
It looks like for some reason, installer/struct.sql may be on upgrade compared against current database structure - but as you see it may bring errors like by attempts to remove some foreign keys or changing field types.
As far as I know, these changes are done manually in upgrade-func.php and this part of code (upgrade-func.php line 15-35) seems to me like obsolete part of upgrade process.

Test and let me know

I want to  backup before I upgrade, but I get an error 500 when I clicked backup in oc-admin

@oneloveb
Please create own thread, as you are doing backup before upgrade on previous version.
Also consider using hosting backup features if available.

Why does version 8 still stand for upgrades (at the top) even though we've already done upgrades to 8.0.0?
Tnx!

@alexborg
It looks like update cache was not cleaned. I suppose if you go to settings > general and check for new updates, this will disappear.

It doesn't work ... it's possible that an error occurred during the "upgrade".

How can I manually clear that cache regarding the upgrade?

@alexborg
Check this in your database:
SELECT * FROM `oc_t_preference` where s_section = 'osclass' and s_name = 'version';
s_value should be 800

Then check in database:
SELECT * FROM `oc_t_preference` where s_section = 'osclass' and s_name ='update_core_json';
s_value should be empty string

Awesome updates, thanks for all the work! 

  We will need a php / mysql expert to upgrade Osclass
very funny.

Problem solved ... thanks!

  We will need a php / mysql expert to upgrade Osclass
very funny.

Problem solved ... thanks!

Using the tips from reply #4 for me the upgrade went well indeed   

Updated without issues here.... clicked update in admin panel and installed update in 1 minute :-) Thanks MB Themes thumbs up