Advertisement:

Author Topic: 3.5.5 - Admin panel OFF. Can't upgrade!  (Read 3675 times)

gicu

  • Newbie
  • *
  • Posts: 18
3.5.5 - Admin panel OFF. Can't upgrade!
« on: March 24, 2015, 09:56:24 pm »
When I'm back from work I want to see how Is going on my PinAds.eu and I see...
Maintenance » PinAds.eu - Free and simple ads!

We are sorry for any inconvenience. PinAds.eu - Free and simple ads! is undergoing maintenance..


After log in to admin panel:
Upgrade

You have uploaded a new version of Osclass, you need to upgrade Osclass for it to work correctly.

UPGRADE.

After clicking on "UPGRADE" it says:

"Upgrading your Osclass installation (this could take a while):".

I leave it for a hour and NOTHING.

What's going on?!
« Last Edit: March 25, 2015, 01:50:07 am by gicu »

Aficionado

  • Guest
Re: 3.5.5 - Site OFF. Can't upgrade!
« Reply #1 on: March 24, 2015, 10:11:19 pm »
That is why the Auto-update should ALWAYS be set to OFF in Osclass. And Wordpress also.

Is this the first update or auto-update you have done ?

Any errors in the Log file of Osclass ?

Enable Debug and see the extended log ...

gicu

  • Newbie
  • *
  • Posts: 18
Re: 3.5.5 - Site OFF. Can't upgrade!
« Reply #2 on: March 24, 2015, 11:15:23 pm »
This is my FIRST problem with osclass.
Where this logs are located on ftp?

Already done this: http://doc.osclass.org/Debug_PHP_errors

But nothing happens.

« Last Edit: March 24, 2015, 11:22:20 pm by gicu »

Aficionado

  • Guest
Re: 3.5.5 - Site OFF. Can't upgrade!
« Reply #3 on: March 24, 2015, 11:23:41 pm »
This is my FIRST problem with osclass.
Where this logs are located on ftp?

Already done this: http://doc.osclass.org/Debug_PHP_errors

But nothing happens.

The normal log is at the root of the website and the extended log when you enable DEBUG is located at oc-content folder.


gicu

  • Newbie
  • *
  • Posts: 18
Re: 3.5.5 - Site OFF. Can't upgrade!
« Reply #4 on: March 24, 2015, 11:56:06 pm »
Debug.log

Code: [Select]
[24-Mar-2015 21:22:41]  ------- START upgrade-funcs -------
[24-Mar-2015 21:22:41]  ----- START updateDB -----
[24-Mar-2015 21:22:41]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[24-Mar-2015 21:22:41]  --- s_name VARCHAR(100) NOT NULL
[24-Mar-2015 21:22:41]  --- s_username VARCHAR(40) NOT NULL
[24-Mar-2015 21:22:41]  --- s_password CHAR(60) NOT NULL
[24-Mar-2015 21:22:41]  --- s_email VARCHAR(100) NULL
[24-Mar-2015 21:22:41]  --- s_secret VARCHAR(40) NULL
[24-Mar-2015 21:22:41]  --- b_moderator TINYINT(1) NOT NULL DEFAULT 0
[24-Mar-2015 21:22:41]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[24-Mar-2015 21:22:41]  --- s_email VARCHAR(100) DEFAULT NULL
[24-Mar-2015 21:22:41]  --- fk_i_user_id INT(10) UNSIGNED DEFAULT NULL
[24-Mar-2015 21:22:41]  --- s_search LONGTEXT
[24-Mar-2015 21:22:41]  --- s_secret VARCHAR(40) NULL
[24-Mar-2015 21:22:41]  --- b_active TINYINT(1) NOT NULL DEFAULT 0
[24-Mar-2015 21:22:41]  --- e_type enum('INSTANT','HOURLY','DAILY','WEEKLY','CUSTOM') NOT NULL
[24-Mar-2015 21:22:41]  --- dt_date DATETIME NULL
[24-Mar-2015 21:22:41]  --- dt_unsub_date DATETIME NULL DEFAULT NULL
[24-Mar-2015 21:22:41]  --- d_date DATE NOT NULL PRIMARY KEY
[24-Mar-2015 21:22:41]  --- i_num_alerts_sent INT(10) UNSIGNED NOT NULL DEFAULT 0
[24-Mar-2015 21:22:41]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[24-Mar-2015 21:22:41]  --- s_name VARCHAR(250) NOT NULL DEFAULT ''
[24-Mar-2015 21:22:41]  --- s_ip VARCHAR(50) NOT NULL DEFAULT ''
[24-Mar-2015 21:22:41]  --- s_email VARCHAR(250) NOT NULL DEFAULT ''
[24-Mar-2015 21:22:41]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[24-Mar-2015 21:22:41]  --- fk_i_parent_id INT(10) UNSIGNED NULL
[24-Mar-2015 21:22:41]  --- i_expiration_days INT(3) UNSIGNED NOT NULL DEFAULT 0
[24-Mar-2015 21:22:41]  --- i_position INT(2) UNSIGNED NOT NULL DEFAULT 0
[24-Mar-2015 21:22:41]  --- b_enabled TINYINT(1) NOT NULL DEFAULT 1
[24-Mar-2015 21:22:41]  --- b_price_enabled TINYINT(1) NOT NULL DEFAULT 1
[24-Mar-2015 21:22:41]  --- s_icon VARCHAR(250) NULL
[24-Mar-2015 21:22:41]  --- fk_i_category_id INT(10) UNSIGNED NOT NULL
[24-Mar-2015 21:22:41]  --- fk_c_locale_code CHAR(5) NOT NULL
[24-Mar-2015 21:22:41]  --- s_name VARCHAR(100) NULL DEFAULT NULL
[24-Mar-2015 21:22:41]  --- s_description TEXT NULL
[24-Mar-2015 21:22:41]  --- s_slug VARCHAR(100) NOT NULL
[24-Mar-2015 21:22:41]  --- fk_i_category_id INT(10) UNSIGNED NOT NULL PRIMARY KEY
[24-Mar-2015 21:22:41]  --- i_num_items INT(10) UNSIGNED NOT NULL DEFAULT 0
[24-Mar-2015 21:22:41]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[24-Mar-2015 21:22:41]  --- fk_i_region_id INT(10) UNSIGNED NOT NULL
[24-Mar-2015 21:22:41]  --- s_name VARCHAR(60) NOT NULL
[24-Mar-2015 21:22:41]  --- s_slug VARCHAR(60) NOT NULL DEFAULT ''
[24-Mar-2015 21:22:41]  --- fk_c_country_code CHAR(2) NULL
[24-Mar-2015 21:22:41]  --- b_active TINYINT(1) NOT NULL DEFAULT 1
[24-Mar-2015 21:22:41]  --- pk_i_id INT(10) UNSIGNED NOT NULL PRIMARY KEY
[24-Mar-2015 21:22:41]  --- fk_i_city_id INT(10) UNSIGNED NOT NULL
[24-Mar-2015 21:22:41]  --- s_name VARCHAR(255) NOT NULL
[24-Mar-2015 21:22:41]  --- fk_i_city_id INT(10) UNSIGNED NOT NULL PRIMARY KEY
[24-Mar-2015 21:22:41]  --- i_num_items INT(10) UNSIGNED NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- pk_c_code CHAR(2) NOT NULL PRIMARY KEY
[24-Mar-2015 21:22:42]  --- s_name VARCHAR(80) NOT NULL
[24-Mar-2015 21:22:42]  --- s_slug VARCHAR(80) NOT NULL DEFAULT ''
[24-Mar-2015 21:22:42]  --- fk_c_country_code CHAR(2) NOT NULL PRIMARY KEY
[24-Mar-2015 21:22:42]  --- i_num_items INT(10) UNSIGNED NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- e_type enum('INSTANT','HOURLY','DAILY','WEEKLY','CUSTOM') NOT NULL
[24-Mar-2015 21:22:42]  --- d_last_exec DATETIME NOT NULL
[24-Mar-2015 21:22:42]  --- d_next_exec DATETIME NOT NULL
[24-Mar-2015 21:22:42]  --- pk_c_code CHAR(3) NOT NULL PRIMARY KEY
[24-Mar-2015 21:22:42]  --- s_name VARCHAR(40) NOT NULL
[24-Mar-2015 21:22:42]  --- s_description VARCHAR(80) NULL
[24-Mar-2015 21:22:42]  --- b_enabled TINYINT(1) NOT NULL DEFAULT 1
[24-Mar-2015 21:22:42]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[24-Mar-2015 21:22:42]  --- fk_i_user_id INT(10) UNSIGNED NULL
[24-Mar-2015 21:22:42]  --- fk_i_category_id INT(10) UNSIGNED NOT NULL
[24-Mar-2015 21:22:42]  --- dt_pub_date DATETIME NOT NULL
[24-Mar-2015 21:22:42]  --- dt_mod_date DATETIME NULL
[24-Mar-2015 21:22:42]  --- f_price FLOAT NULL
[24-Mar-2015 21:22:42]  --- i_price BIGINT(20) NULL
[24-Mar-2015 21:22:42]  --- fk_c_currency_code CHAR(3) NULL
[24-Mar-2015 21:22:42]  --- s_contact_name VARCHAR(100) NULL
[24-Mar-2015 21:22:42]  --- s_contact_email VARCHAR(140) NOT NULL
[24-Mar-2015 21:22:42]  --- s_ip VARCHAR(64) NOT NULL DEFAULT ''
[24-Mar-2015 21:22:42]  --- b_premium TINYINT(1) NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- b_enabled TINYINT(1) NOT NULL DEFAULT 1
[24-Mar-2015 21:22:42]  --- b_active TINYINT(1) NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- b_spam TINYINT(1) NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- s_secret VARCHAR(40) NULL
[24-Mar-2015 21:22:42]  --- b_show_email TINYINT(1) NULL
[24-Mar-2015 21:22:42]  --- dt_expiration datetime NOT NULL DEFAULT '9999-12-31 23:59:59'
[24-Mar-2015 21:22:42]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[24-Mar-2015 21:22:42]  --- fk_i_item_id INT(10) UNSIGNED NOT NULL
[24-Mar-2015 21:22:42]  --- dt_pub_date DATETIME NOT NULL
[24-Mar-2015 21:22:42]  --- s_title VARCHAR(200) NOT NULL
[24-Mar-2015 21:22:42]  --- s_author_name VARCHAR(100) NOT NULL
[24-Mar-2015 21:22:42]  --- s_author_email VARCHAR(100) NOT NULL
[24-Mar-2015 21:22:42]  --- s_body TEXT NOT NULL
[24-Mar-2015 21:22:42]  --- b_enabled TINYINT(1) NOT NULL DEFAULT 1
[24-Mar-2015 21:22:42]  --- b_active TINYINT(1) NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- b_spam TINYINT(1) NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- fk_i_user_id INT(10) UNSIGNED NULL
[24-Mar-2015 21:22:42]  --- fk_i_item_id INT(10) UNSIGNED NOT NULL
[24-Mar-2015 21:22:42]  --- fk_c_locale_code CHAR(5) NOT NULL
[24-Mar-2015 21:22:42]  --- s_title VARCHAR(100) NOT NULL
[24-Mar-2015 21:22:42]  --- s_description MEDIUMTEXT NOT NULL
[24-Mar-2015 21:22:42]  --- fk_i_item_id INT(10) UNSIGNED NOT NULL PRIMARY KEY
[24-Mar-2015 21:22:42]  --- fk_c_country_code CHAR(2) NULL
[24-Mar-2015 21:22:42]  --- s_country VARCHAR(40) NULL
[24-Mar-2015 21:22:42]  --- s_address VARCHAR(100) NULL
[24-Mar-2015 21:22:42]  --- s_zip VARCHAR(15) NULL
[24-Mar-2015 21:22:42]  --- fk_i_region_id INT(10) UNSIGNED NULL
[24-Mar-2015 21:22:42]  --- s_region VARCHAR(100)
[24-Mar-2015 21:22:42]  --- fk_i_city_id INT(10) UNSIGNED NULL
[24-Mar-2015 21:22:42]  --- s_city VARCHAR(100) NULL
[24-Mar-2015 21:22:42]  --- fk_i_city_area_id INT(10) UNSIGNED NULL
[24-Mar-2015 21:22:42]  --- s_city_area VARCHAR(200) NULL
[24-Mar-2015 21:22:42]  --- d_coord_lat DECIMAL(10,6)
[24-Mar-2015 21:22:42]  --- d_coord_long DECIMAL(10,6)
[24-Mar-2015 21:22:42]  --- fk_i_item_id INT(10) UNSIGNED NOT NULL
[24-Mar-2015 21:22:42]  --- fk_i_field_id INT(10) UNSIGNED NOT NULL
[24-Mar-2015 21:22:42]  --- s_value TEXT NULL
[24-Mar-2015 21:22:42]  --- s_multi VARCHAR(20) NOT NULL DEFAULT ''
[24-Mar-2015 21:22:42]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[24-Mar-2015 21:22:42]  --- fk_i_item_id INT(10) UNSIGNED NOT NULL
[24-Mar-2015 21:22:42]  --- s_name VARCHAR(60) NULL
[24-Mar-2015 21:22:42]  --- s_extension VARCHAR(10) NULL
[24-Mar-2015 21:22:42]  --- s_content_type VARCHAR(40) NULL
[24-Mar-2015 21:22:42]  --- s_path VARCHAR(250) NULL
[24-Mar-2015 21:22:42]  --- fk_i_item_id INT(10) UNSIGNED NOT NULL
[24-Mar-2015 21:22:42]  --- i_num_views INT(10) UNSIGNED NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- i_num_spam INT(10) UNSIGNED NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- i_num_repeated INT(10) UNSIGNED NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- i_num_bad_classified INT(10) UNSIGNED NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- i_num_offensive INT(10) UNSIGNED NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- i_num_expired INT(10) UNSIGNED NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- i_num_premium_views INT(10) UNSIGNED NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- dt_date DATE NOT NULL
[24-Mar-2015 21:22:42]  --- s_md5 VARCHAR(32) NOT NULL
[24-Mar-2015 21:22:42]  --- fk_c_locale_code CHAR(5) NOT NULL
[24-Mar-2015 21:22:42]  --- s_original_text VARCHAR(255) NOT NULL
[24-Mar-2015 21:22:42]  --- s_anchor_text VARCHAR(255) NOT NULL
[24-Mar-2015 21:22:42]  --- s_normalized_text VARCHAR(255) NOT NULL
[24-Mar-2015 21:22:42]  --- fk_i_category_id INT(10) UNSIGNED NULL
[24-Mar-2015 21:22:42]  --- fk_i_city_id INT(10) UNSIGNED NULL
[24-Mar-2015 21:22:42]  --- d_date DATETIME NOT NULL
[24-Mar-2015 21:22:42]  --- s_search VARCHAR(255) NOT NULL
[24-Mar-2015 21:22:42]  --- pk_c_code CHAR(5) NOT NULL PRIMARY KEY
[24-Mar-2015 21:22:42]  --- s_name VARCHAR(100) NOT NULL
[24-Mar-2015 21:22:42]  --- s_short_name VARCHAR(40) NOT NULL
[24-Mar-2015 21:22:42]  --- s_description VARCHAR(100) NOT NULL
[24-Mar-2015 21:22:42]  --- s_version VARCHAR(20) NOT NULL
[24-Mar-2015 21:22:42]  --- s_author_name VARCHAR(100) NOT NULL
[24-Mar-2015 21:22:42]  --- s_author_url VARCHAR(100) NOT NULL
[24-Mar-2015 21:22:42]  --- s_currency_format VARCHAR(50) NOT NULL
[24-Mar-2015 21:22:42]  --- s_dec_point VARCHAR(2) NULL DEFAULT '.'
[24-Mar-2015 21:22:42]  --- s_thousands_sep VARCHAR(2) NULL DEFAULT ''
[24-Mar-2015 21:22:42]  --- i_num_dec TINYINT(4) NULL DEFAULT 2
[24-Mar-2015 21:22:42]  --- s_date_format VARCHAR(20) NOT NULL
[24-Mar-2015 21:22:42]  --- s_stop_words TEXT NULL
[24-Mar-2015 21:22:42]  --- b_enabled TINYINT(1) NOT NULL DEFAULT 1
[24-Mar-2015 21:22:42]  --- b_enabled_bo TINYINT(1) NOT NULL DEFAULT 1
[24-Mar-2015 21:22:42]  --- id_location varchar(10) NOT NULL
[24-Mar-2015 21:22:42]  --- e_type enum('COUNTRY','REGION','CITY') NOT NULL
[24-Mar-2015 21:22:42]  --- dt_date DATETIME NOT NULL
[24-Mar-2015 21:22:42]  --- s_section VARCHAR(50) NOT NULL
[24-Mar-2015 21:22:42]  --- s_action VARCHAR(50) NOT NULL
[24-Mar-2015 21:22:42]  --- fk_i_id INT(10) UNSIGNED NOT NULL
[24-Mar-2015 21:22:42]  --- s_data VARCHAR(250) NOT NULL
[24-Mar-2015 21:22:42]  --- s_ip VARCHAR(50) NOT NULL
[24-Mar-2015 21:22:42]  --- s_who VARCHAR(50) NOT NULL
[24-Mar-2015 21:22:42]  --- fk_i_who_id INT(10) UNSIGNED NOT NULL
[24-Mar-2015 21:22:42]  --- fk_i_category_id INT(10) UNSIGNED NOT NULL
[24-Mar-2015 21:22:42]  --- fk_i_field_id INT(10) UNSIGNED NOT NULL
[24-Mar-2015 21:22:42]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[24-Mar-2015 21:22:42]  --- s_name VARCHAR(255) NOT NULL
[24-Mar-2015 21:22:42]  --- s_slug VARCHAR(255) NOT NULL
[24-Mar-2015 21:22:42]  --- e_type ENUM('TEXT','TEXTAREA','DROPDOWN','RADIO','CHECKBOX','URL', 'DATE', 'DATEINTERVAL') NOT NULL DEFAULT  'TEXT'
[24-Mar-2015 21:22:42]  --- s_options VARCHAR(2048) NULL
[24-Mar-2015 21:22:42]  --- b_required TINYINT(1) NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- b_searchable TINYINT(1) NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[24-Mar-2015 21:22:42]  --- s_internal_name VARCHAR(50) NULL
[24-Mar-2015 21:22:42]  --- b_indelible TINYINT(1) NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- b_link TINYINT(1) NOT NULL DEFAULT 1
[24-Mar-2015 21:22:42]  --- dt_pub_date DATETIME NOT NULL
[24-Mar-2015 21:22:42]  --- dt_mod_date DATETIME NULL
[24-Mar-2015 21:22:42]  --- i_order INT(3) NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- s_meta TEXT NULL
[24-Mar-2015 21:22:42]  --- fk_i_pages_id INT(10) UNSIGNED NOT NULL
[24-Mar-2015 21:22:42]  --- fk_c_locale_code CHAR(5) NOT NULL
[24-Mar-2015 21:22:42]  --- s_title VARCHAR(255) NOT NULL
[24-Mar-2015 21:22:42]  --- s_text TEXT
[24-Mar-2015 21:22:42]  --- s_plugin_name VARCHAR(40) NOT NULL
[24-Mar-2015 21:22:42]  --- fk_i_category_id INT(10) UNSIGNED NOT NULL
[24-Mar-2015 21:22:42]  --- s_section VARCHAR(40) NOT NULL
[24-Mar-2015 21:22:42]  --- s_name VARCHAR(40) NOT NULL
[24-Mar-2015 21:22:42]  --- s_value LONGTEXT NOT NULL
[24-Mar-2015 21:22:42]  --- e_type ENUM('STRING', 'INTEGER', 'BOOLEAN') NOT NULL
[24-Mar-2015 21:22:42]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[24-Mar-2015 21:22:42]  --- fk_c_country_code CHAR(2) NOT NULL
[24-Mar-2015 21:22:42]  --- s_name VARCHAR(60) NOT NULL
[24-Mar-2015 21:22:42]  --- s_slug VARCHAR(60) NOT NULL DEFAULT ''
[24-Mar-2015 21:22:42]  --- b_active TINYINT(1) NOT NULL DEFAULT 1
[24-Mar-2015 21:22:42]  --- fk_i_region_id INT(10) UNSIGNED NOT NULL PRIMARY KEY
[24-Mar-2015 21:22:42]  --- i_num_items INT(10) UNSIGNED NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[24-Mar-2015 21:22:42]  --- dt_reg_date DATETIME NOT NULL
[24-Mar-2015 21:22:42]  --- dt_mod_date DATETIME NULL
[24-Mar-2015 21:22:42]  --- s_name VARCHAR(100) NOT NULL
[24-Mar-2015 21:22:42]  --- s_username VARCHAR(100) NOT NULL
[24-Mar-2015 21:22:42]  --- s_password CHAR(60) NOT NULL
[24-Mar-2015 21:22:42]  --- s_secret VARCHAR(40) NULL
[24-Mar-2015 21:22:42]  --- s_email VARCHAR(100) NOT NULL
[24-Mar-2015 21:22:42]  --- s_website VARCHAR(100) NULL
[24-Mar-2015 21:22:42]  --- s_phone_land VARCHAR(45)
[24-Mar-2015 21:22:42]  --- s_phone_mobile VARCHAR(45)
[24-Mar-2015 21:22:42]  --- b_enabled TINYINT(1) NOT NULL DEFAULT 1
[24-Mar-2015 21:22:42]  --- b_active TINYINT(1) NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- s_pass_code VARCHAR(100) NULL
[24-Mar-2015 21:22:42]  --- s_pass_date DATETIME NULL
[24-Mar-2015 21:22:42]  --- s_pass_ip VARCHAR(15) NULL
[24-Mar-2015 21:22:42]  --- fk_c_country_code CHAR(2) NULL
[24-Mar-2015 21:22:42]  --- s_country VARCHAR(40) NULL
[24-Mar-2015 21:22:42]  --- s_address VARCHAR(100) NULL
[24-Mar-2015 21:22:42]  --- s_zip VARCHAR(15) NULL
[24-Mar-2015 21:22:42]  --- fk_i_region_id INT(10) UNSIGNED NULL
[24-Mar-2015 21:22:42]  --- s_region VARCHAR(100)
[24-Mar-2015 21:22:42]  --- fk_i_city_id INT(10) UNSIGNED NULL
[24-Mar-2015 21:22:42]  --- s_city VARCHAR(100) NULL
[24-Mar-2015 21:22:42]  --- fk_i_city_area_id INT(10) UNSIGNED NULL
[24-Mar-2015 21:22:42]  --- s_city_area VARCHAR(200) NULL
[24-Mar-2015 21:22:42]  --- d_coord_lat DECIMAL(10,6)
[24-Mar-2015 21:22:42]  --- d_coord_long DECIMAL(10,6)
[24-Mar-2015 21:22:42]  --- b_company TINYINT(1) NOT NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- i_items INT(10) UNSIGNED NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- i_comments INT(10) UNSIGNED NULL DEFAULT 0
[24-Mar-2015 21:22:42]  --- dt_access_date DATETIME NOT NULL DEFAULT  '0000-00-00 00:00:00'
[24-Mar-2015 21:22:42]  --- s_access_ip VARCHAR(15) NOT NULL DEFAULT ''
[24-Mar-2015 21:22:42]  --- fk_i_user_id INT(10) UNSIGNED NOT NULL
[24-Mar-2015 21:22:42]  --- fk_c_locale_code CHAR(5) NOT NULL
[24-Mar-2015 21:22:42]  --- s_info TEXT NULL
[24-Mar-2015 21:22:42]  --- fk_i_user_id INT(10) UNSIGNED NOT NULL PRIMARY KEY
[24-Mar-2015 21:22:42]  --- s_new_email VARCHAR(100) NOT NULL
[24-Mar-2015 21:22:42]  --- dt_date DATETIME NOT NULL
[24-Mar-2015 21:22:42]  --- pk_i_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
[24-Mar-2015 21:22:42]  --- s_description VARCHAR(40) NOT NULL
[24-Mar-2015 21:22:42]  --- s_location VARCHAR(40) NOT NULL
[24-Mar-2015 21:22:42]  --- e_kind ENUM('TEXT', 'HTML') NOT NULL
[24-Mar-2015 21:22:42]  --- s_content MEDIUMTEXT NOT NULL
[24-Mar-2015 21:22:42]  --- last_struct_queries ---
[24-Mar-2015 21:22:42]  --- ALTER TABLE oc_t_category ADD INDEX (fk_i_parent_id)
[24-Mar-2015 21:22:42]  --- ALTER TABLE oc_t_category ADD INDEX (i_position)
[24-Mar-2015 21:22:42]  --- ALTER TABLE oc_t_city ADD INDEX (fk_i_region_id)
[24-Mar-2015 21:22:42]  --- ALTER TABLE oc_t_city_area ADD INDEX (fk_i_city_id)
[24-Mar-2015 21:22:42]  --- ALTER TABLE oc_t_item ADD INDEX (fk_i_user_id)
[24-Mar-2015 21:22:42]  --- ALTER TABLE oc_t_item ADD INDEX (fk_i_category_id)
[24-Mar-2015 21:22:42]  --- ALTER TABLE oc_t_item ADD INDEX (fk_c_currency_code)
[24-Mar-2015 21:22:42]  --- ALTER TABLE oc_t_item_comment ADD INDEX (fk_i_item_id)
[24-Mar-2015 21:22:42]  --- ALTER TABLE oc_t_item_resource ADD INDEX (fk_i_item_id)
[24-Mar-2015 21:22:42]  --- ALTER TABLE oc_t_item_stats ADD INDEX (dt_date, fk_i_item_id)
[24-Mar-2015 21:22:42]  --- ALTER TABLE oc_t_keywords ADD INDEX (fk_i_category_id)
[24-Mar-2015 21:22:42]  --- ALTER TABLE oc_t_keywords ADD INDEX (fk_i_city_id)
[24-Mar-2015 21:22:42]  --- ALTER TABLE oc_t_plugin_category ADD INDEX (fk_i_category_id)
[24-Mar-2015 21:22:42]  --- ALTER TABLE oc_t_region ADD INDEX (fk_c_country_code)

No other logs is available on the root directory.

Aficionado

  • Guest
Re: 3.5.5 - Site OFF. Can't upgrade!
« Reply #5 on: March 25, 2015, 12:00:57 am »
So the debug log is clean from what i see.

Sorry, i have no idea what to do next. Others may help ...

Aficionado

  • Guest
Re: 3.5.5 - Site OFF. Can't upgrade!
« Reply #6 on: March 25, 2015, 12:05:02 am »
At admin backsite what is the version of Osclass shown ? The old or the new one 3.5.5 ?

gicu

  • Newbie
  • *
  • Posts: 18
Re: 3.5.5 - Site OFF. Can't upgrade!
« Reply #7 on: March 25, 2015, 12:10:41 am »
Osclass 3.5.5

Aficionado

  • Guest
Re: 3.5.5 - Site OFF. Can't upgrade!
« Reply #8 on: March 25, 2015, 12:15:48 am »
Osclass 3.5.5

So the update went well. Try turn maintenance to OFF from the admin.


gicu

  • Newbie
  • *
  • Posts: 18
Re: 3.5.5 - Site OFF. Can't upgrade!
« Reply #9 on: March 25, 2015, 12:21:24 am »
Yep, it's done already but I can't do anything in admin panel.

Website works well ( pinads.eu ) but stuck in admin with: "You have uploaded a new version of Osclass, you need to upgrade Osclass for it to work correctly.".

And in header I see button with "Osclass 3.5.5 is available".

dev101

  • Osclass Hero
  • Hero Member
  • *
  • Posts: 2155
  • osclass.work
Re: 3.5.5 - Site OFF. Can't upgrade!
« Reply #10 on: March 25, 2015, 12:47:09 am »
Hi,

From your logs the update went well for database until the very last step, but failed at region update step and when upgrade-funcs code was about to be executed which explains your white page. My guess is that you are on a slower server, have a country with lots of regions and your php execution time limit was hit. Press the Upgrade button and see what will happen, but in any case, you should be fine.

gicu

  • Newbie
  • *
  • Posts: 18
Re: 3.5.5 - Site OFF. Can't upgrade!
« Reply #11 on: March 25, 2015, 12:50:40 am »
"Upgrading your Osclass installation (this could take a while):"

And this while takes up to many hours.
Simply nothing happens. Just loading and loading until F5.
After F5 again "You have uploaded a new version of Osclass, you need to upgrade Osclass for it to work correctly."

I've got a VPS from OVH.
2 cores, 2GB ram. Website works pretty well and fast.

dev101

  • Osclass Hero
  • Hero Member
  • *
  • Posts: 2155
  • osclass.work
Re: 3.5.5 - Site OFF. Can't upgrade!
« Reply #12 on: March 25, 2015, 12:59:13 am »
Well, "pretty well and fast" is a relative term, you have many widgets and external ads which do slowdown overall website "speed" impression with ~7 sec for front page, this is absolutely not fast. In any case, try to perform a manual update.

gicu

  • Newbie
  • *
  • Posts: 18
Re: 3.5.5 - Site OFF. Can't upgrade!
« Reply #13 on: March 25, 2015, 01:37:45 am »
"If you have permalinks enabled, you should disable them before updating Osclass." - I can't do this because admin panel is useless now so can be much worse after that.
There must be some way to fix it without "hard reset".
« Last Edit: March 25, 2015, 01:44:35 am by gicu »

Aficionado

  • Guest
Re: 3.5.5 - Admin panel OFF. Can't upgrade!
« Reply #14 on: March 25, 2015, 02:34:48 am »
White page reminds me sometime back, i was trying to add some cities and i was hitting the memory limit. But 2 gb of ram, can't be a problem.