Hi DepotMart,
Osclass needs to make the following changes to continue (taken from upgrade-funcs.php)
if(osc_version() < 310) {
//$comm->query(sprintf("ALTER TABLE %st_alerts ADD `pk_i_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY", DB_TABLE_PREFIX));
$comm->query(sprintf("ALTER TABLE %st_pages ADD `s_meta` TEXT NULL", DB_TABLE_PREFIX));
$comm->query(sprintf("ALTER TABLE %st_pages ADD `b_link` TINYINT(1) NOT NULL DEFAULT 1", DB_TABLE_PREFIX));
$comm->query(sprintf("UPDATE %st_alerts SET dt_date = '%s' ", DB_TABLE_PREFIX, date("Y-m-d H:i:s")));
// remove files moved to controller folder
@unlink(osc_base_path() . 'ajax.php');
@unlink(osc_base_path() . 'contact.php');
@unlink(osc_base_path() . 'custom.php');
@unlink(osc_base_path() . 'item.php');
@unlink(osc_base_path() . 'language.php');
@unlink(osc_base_path() . 'login.php');
@unlink(osc_base_path() . 'main.php');
@unlink(osc_base_path() . 'page.php');
@unlink(osc_base_path() . 'register.php');
@unlink(osc_base_path() . 'search.php');
@unlink(osc_base_path() . 'user-non-secure.php');
@unlink(osc_base_path() . 'user.php');
@unlink(osc_base_path() . 'readme.php');
@unlink(osc_lib_path() . 'osclass/plugins.php');
@unlink(osc_lib_path() . 'osclass/feeds.php');
$comm->query(sprintf('UPDATE %st_user t, (SELECT pk_i_id FROM %st_user) t1 SET t.s_username = t1.pk_i_id WHERE t.pk_i_id = t1.pk_i_id', DB_TABLE_PREFIX, DB_TABLE_PREFIX));
osc_set_preference('username_blacklist', 'admin,user', 'osclass', 'STRING');
osc_set_preference('rewrite_user_change_username', 'username/change');
osc_set_preference('csrf_name', 'CSRF'.mt_rand(0,mt_getrandmax()));
@mkdir(CONTENT_PATH.'uploads/page-images');
}
It also has to made some changes to the database prior to this, not sure why it failed.
So, go to your phpMyAdmin or whatever you use to control your database, and please, run this SQL files
ALTER TABLE oc_t_alerts ADD `pk_i_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY;
ALTER TABLE oc_t_pages ADD `s_meta` TEXT NULL;
ALTER TABLE oc_t_pages ADD `b_link` TINYINT(1) NOT NULL DEFAULT 1;
UPDATE oc_t_alerts SET dt_date = 'NOW()';
UPDATE oc_t_user t, (SELECT pk_i_id FROM oc_t_user) t1 SET t.s_username = t1.pk_i_id WHERE t.pk_i_id = t1.pk_i_id;
Do it one by one and tell us if something failed (First may fail, but the rest should be run smoothly)
Thanks and sorry for any inconvenience
