Control Web Panel

WebPanel => Installation => Topic started by: kendelein on December 05, 2019, 04:18:59 PM

Title: how to reinstall root_cwp or cwp system default database ?
Post by: kendelein on December 05, 2019, 04:18:59 PM

how to reinstall root_cwp or cwp system default database ?

my server mysql got error few day ago (cannot updatecwp,connect/repair/backup database) and cannot view to cwp panel after login
so i was reinstall the mysql/mariadb, now site/server is work now
but the ori database all is missing, so i recreate 'root_cwp' and 'postfix' database by root user in phpmyadmin
but the system was not auto recrate all table inside the database.

control panel show error 

Code: [Select]

mysqli_error() expects exactly 1 parameter, 0 given in <b>/usr/local/cwpsrv/htdocs/resources/admin/include/functions.php</b> on line <b>0</b>
<b>Warning</b>:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in <b>/usr/local/cwpsrv/htdocs/resources/admin/include/functions.php</b> o


Title: Re: how to reinstall root_cwp or cwp system default database ?
Post by: Igor S. on December 14, 2019, 06:12:52 AM

Hi, check if you have backups in /backup/mysql/ or you have created the backups manually.

Title: Re: how to reinstall root_cwp or cwp system default database ?
Post by: fainbuff on November 08, 2020, 05:34:08 AM

Quote from: kendelein on December 05, 2019, 04:18:59 PM

how to reinstall root_cwp or cwp system default database ?

my server mysql got error few day ago (cannot updatecwp,connect/repair/backup database) and cannot view to cwp panel after login
so i was reinstall the mysql/mariadb, now site/server is work now
but the ori database all is missing, so i recreate 'root_cwp' and 'postfix' database by root user in phpmyadmin
but the system was not auto recrate all table inside the database.

control panel show error 

Code: [Select]

mysqli_error() expects exactly 1 parameter, 0 given in <b>/usr/local/cwpsrv/htdocs/resources/admin/include/functions.php</b> on line <b>0</b>
<b>Warning</b>:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in <b>/usr/local/cwpsrv/htdocs/resources/admin/include/functions.php</b> o


I have the same problem. Anybody who know about the solution please share exact answer here.

Title: Re: how to reinstall root_cwp or cwp system default database ?
Post by: Igor S. on November 10, 2020, 12:58:36 PM

@fainbuff the same and for you :) Check if you have the backup.
And I wonder why do you delete system databases?

Title: Re: how to reinstall root_cwp or cwp system default database ?
Post by: gracerobo on October 01, 2021, 06:54:53 AM

Quote from: fainbuff on November 08, 2020, 05:34:08 AM

Quote from: kendelein on December 05, 2019, 04:18:59 PM

how to reinstall root_cwp or cwp system default database ?

my server mysql got error few day ago (cannot updatecwp,connect/repair/backup database) and cannot view to cwp panel after login
so i was reinstall the mysql/mariadb, now site/server is work now
but the ori database all is missing, so i recreate 'root_cwp' and 'postfix' database by root user in phpmyadmin
but the system was not auto recrate all table inside the database.

control panel show error 

Code: [Select]

mysqli_error() expects exactly 1 parameter, 0 given in <b>/usr/local/cwpsrv/htdocs/resources/admin/include/functions.php</b> on line <b>0</b>
<b>Warning</b>:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in <b>/usr/local/cwpsrv/htdocs/resources/admin/include/functions.php</b> o


I have the same problem. Anybody who know about the solution please share exact answer here.

any suggestion.