How to Update Osclass 3.9.0 from 3.8.0?

How to Update Osclass 3.9.0 from 3.8.0? From dashborad it is impossible to update, can you advice a tutorial best way to update new version?

Currently it’s not possible to update to 3.9.0 with dashboard option. You have to manually upgrade your installation.
It’s very simple download latest osclass and overwrite it’s content on your installation except oc-content directory.
For proper guide visit https://osclass.gitbook.io/osclass-docs/beginners/updating-osclass

After updating, started to record those errors;

==================================================
= Date: December 26, 2019 December 26, 2019 =
= Total queries: 23 =
= Total queries time: 0.066092729568481 =

QUERY TIME 0.0034258365631104


SELECT *
FROM (oc_t_preference)

QUERY TIME 0.0035171508789062


SELECT *
FROM (oc_t_preference)

QUERY TIME 0.0020589828491211


DELETE FROM oc_t_preference
WHERE s_name = ‘default_logo’
AND s_section = ‘osclasswizards_theme’

QUERY TIME 0.0030989646911621


SELECT *
FROM (oc_t_preference)

QUERY TIME 0.00043702125549316


SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC

QUERY TIME 0.015424013137817


SELECT a., b., c.i_num_items
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON (a.pk_i_id = b.fk_i_category_id AND b.fk_c_locale_code = “tr_TR”)
LEFT JOIN oc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id
WHERE b.s_name != ‘’ AND a.b_enabled = 1
ORDER BY i_position ASC

QUERY TIME 0.024047136306763


SELECT a.pk_i_id, a.i_position, b.*
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
WHERE b.s_name != ‘’ AND a.b_enabled = 1
GROUP BY a.pk_i_id
ORDER BY i_position ASC

QUERY TIME 0.0030531883239746


SELECT a., b., c.i_num_items
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON (a.pk_i_id = b.fk_i_category_id AND b.fk_c_locale_code = “tr_TR”)
LEFT JOIN oc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id
WHERE a.fk_i_parent_id IS NULL AND a.b_enabled = 1
ORDER BY i_position ASC

QUERY TIME 0.0032789707183838


SELECT a.pk_i_id, a.i_position, b.*
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
WHERE a.fk_i_parent_id IS NULL AND a.b_enabled = 1
GROUP BY a.pk_i_id
ORDER BY i_position ASC

QUERY TIME 0.00037622451782227


SELECT pk_i_id, fk_c_country_code, s_name, b_active, s_slug
FROM (oc_t_region)

QUERY TIME 0.0026040077209473


SELECT oc_t_city_stats.fk_i_city_id as city_id, oc_t_city_stats.i_num_items as items, oc_t_city.s_name as city_name, oc_t_city.s_slug as city_slug
FROM (oc_t_city_stats)
LEFT JOIN oc_t_city ON oc_t_city_stats.fk_i_city_id = oc_t_city.pk_i_id
WHERE i_num_items > 0
ORDER BY city_name ASC

QUERY TIME 0.00036287307739258


SELECT *
FROM (oc_t_widget)
WHERE s_location = ‘header’

QUERY TIME 0.00046086311340332


SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name
FROM (oc_t_item, oc_t_item_stats)
WHERE oc_t_item_stats.fk_i_item_id = oc_t_item.pk_i_id
AND oc_t_item.b_premium = 1
AND oc_t_item.b_enabled = 1
AND oc_t_item.b_active = 1
AND oc_t_item.b_spam = 0
GROUP BY oc_t_item.pk_i_id
ORDER BY SUM(oc_t_item_stats.i_num_premium_views) ASC, RAND()
LIMIT 0, 6

QUERY TIME 0.0005030632019043


SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name
FROM (oc_t_item)
WHERE oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND (oc_t_item.b_premium = 1 || oc_t_item.dt_expiration >= ‘2019-12-26 21:09:10’)
ORDER BY dt_pub_date DESC
LIMIT 0, 2

QUERY TIME 0.00069808959960938


SELECT oc_t_item.pk_i_id
FROM (oc_t_item)
WHERE oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND (oc_t_item.b_premium = 1 || oc_t_item.dt_expiration >= ‘2019-12-26 21:09:10’)
ORDER BY dt_pub_date DESC
LIMIT 200

QUERY TIME 0.00042605400085449


SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = ‘5741’

QUERY TIME 0.00062704086303711


SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(s.i_num_views) as i_num_views, SUM(s.i_num_spam) as i_num_spam, SUM(s.i_num_bad_classified) as i_num_bad_classified, SUM(s.i_num_repeated) as i_num_repeated, SUM(s.i_num_offensive) as i_num_offensive, SUM(s.i_num_expired) as i_num_expired, SUM(s.i_num_premium_views) as i_num_premium_views
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = ‘5741’
AND s.fk_i_item_id = ‘5741’
AND cd.fk_i_category_id = ‘2224’
AND cd.fk_c_locale_code = ‘tr_TR’
GROUP BY fk_i_item_id

QUERY TIME 0.00023722648620605


SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = ‘5740’

QUERY TIME 0.00027108192443848


SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(s.i_num_views) as i_num_views, SUM(s.i_num_spam) as i_num_spam, SUM(s.i_num_bad_classified) as i_num_bad_classified, SUM(s.i_num_repeated) as i_num_repeated, SUM(s.i_num_offensive) as i_num_offensive, SUM(s.i_num_expired) as i_num_expired, SUM(s.i_num_premium_views) as i_num_premium_views
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = ‘5740’
AND s.fk_i_item_id = ‘5740’
AND cd.fk_i_category_id = ‘2222’
AND cd.fk_c_locale_code = ‘tr_TR’
GROUP BY fk_i_item_id

QUERY TIME 0.00042605400085449


SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 5741

QUERY TIME 0.00020480155944824


SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 5740

QUERY TIME 0.00026798248291016


SELECT *
FROM (oc_t_widget)
WHERE s_location = ‘footer’

QUERY TIME 0.00028610229492188


SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC