I have following problem with one of my vps which is very strange.
"Sentora Panel Database Missing 5 Tables"
I try to login to my sentora login panel but it's shown only blank ( it's doesn't display the field for entering user & password, like my another sentora login )
After comparing with one of another my working sentora login with the problem ones, I found there are Sentora Panel Database Missing 5 Tables. As show below :
As shown above tables that is gone / missing is :
x_accounts
x_aliases
x_bandwidth
x_cronjobs
x_distlists
I have try to copy the table from working sentora panel the 5 missing one, but it's show me an error look's like the table still exist.
here is the code I have to execute :
Ps: I didn't remember when the last time the panel was working or what kind of task I have done before.
"Sentora Panel Database Missing 5 Tables"
I try to login to my sentora login panel but it's shown only blank ( it's doesn't display the field for entering user & password, like my another sentora login )
After comparing with one of another my working sentora login with the problem ones, I found there are Sentora Panel Database Missing 5 Tables. As show below :
sentora working Wrote:
sentora doesn\t working Wrote:
As shown above tables that is gone / missing is :
x_accounts
x_aliases
x_bandwidth
x_cronjobs
x_distlists
I have try to copy the table from working sentora panel the 5 missing one, but it's show me an error look's like the table still exist.
here is the code I have to execute :
Quote:DROP TABLE IF EXISTS `x_accounts`;My last idea is to deploy or re install the VPS with the new ones. If someone have same problem with me please help.
CREATE TABLE `x_accounts` (
`ac_id_pk` int(6) unsigned NOT NULL AUTO_INCREMENT,
`ac_user_vc` varchar(50) DEFAULT NULL,
`ac_pass_vc` varchar(200) DEFAULT NULL,
`ac_email_vc` varchar(250) DEFAULT NULL,
`ac_reseller_fk` int(6) DEFAULT NULL,
`ac_package_fk` int(6) DEFAULT NULL,
`ac_group_fk` int(6) DEFAULT NULL,
`ac_usertheme_vc` varchar(45) DEFAULT NULL,
`ac_usercss_vc` varchar(45) DEFAULT NULL,
`ac_enabled_in` int(1) DEFAULT '1',
`ac_lastlogon_ts` int(30) DEFAULT NULL,
`ac_notice_tx` text,
`ac_resethash_tx` text,
`ac_passsalt_vc` varchar(22) DEFAULT NULL,
`ac_catorder_vc` varchar(255) DEFAULT NULL,
`ac_created_ts` int(30) DEFAULT NULL,
`ac_deleted_ts` int(30) DEFAULT NULL,
PRIMARY KEY (`ac_id_pk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
insert into `x_accounts` (`ac_id_pk`, `ac_user_vc`, `ac_pass_vc`, `ac_email_vc`, `ac_reseller_fk`, `ac_package_fk`, `ac_group_fk`, `ac_usertheme_vc`, `ac_usercss_vc`, `ac_enabled_in`, `ac_lastlogon_ts`, `ac_notice_tx`, `ac_resethash_tx`, `ac_passsalt_vc`, `ac_catorder_vc`, `ac_created_ts`, `ac_deleted_ts`) VALUES
(1, 'zadmin', 'xxxxxxxxxxxxxxxx', 'zadmin@localhost', 1, 1, 1, 'Sentora_Default', 'default', 1, xxxxxxxxxxx, 'Welcome to your new Sentora installation! You can remove this message from the Client Notice Manager module. This module allows you to notify your clients of service outages, upgrades and new features etc :-)', NULL, 'xxxxxxxxxxxxxxxxxxxxxxxx', NULL, 0, NULL),
(2, 'client1', 'xxxxxxxxxxxxxx', 'admin@client.com', 1, 3, 3, 'Sentora_Default', 'default', 1, 1455877011, NULL, NULL, 'xxxxxxxxxxx', NULL, xxxxxxxxx, NULL);
Ps: I didn't remember when the last time the panel was working or what kind of task I have done before.