Could not make Query after Update https://www.softaculous.com/board/index.php?tid=8821 <![CDATA[Could not make Query after Update]]> https://www.softaculous.com/board/index.php?tid=8821&tpg=1#p55704

Sir, Please let us know for any further assistance.]]> Tue, 15 Nov 2022 07:01:39 GMT https://www.softaculous.com/board/index.php?tid=8821&tpg=1#p55704 <![CDATA[Could not make Query after Update]]> https://www.softaculous.com/board/index.php?tid=8821&tpg=1#p55703
Quote From : sanjeet_virt November 15, 2022, 5:27 am
Sir Please folow below steps

Run this command and check if TMD file does not exists: ls -lha /usr/local/emps/var/mysql/virtualizor/tasks.*
If it does not lists TMD file then you can proceed with following steps and if it exists then move it to other location :
touch /usr/local/emps/var/mysql/virtualizor/tasks.MYD
touch /usr/local/emps/var/mysql/virtualizor/tasks.MYI
chown mysql:mysql /usr/local/emps/var/mysql/virtualizor/tasks.MY*
Then execute this query in mysql cli (after logging to virtualizor database)
grep dbpass /usr/local/virtualizor/universal.php  ...mysql password
# /usr/local/emps/bin/mysql -u root -p virtualizor (to open db, will ask for password)
use virtualizor; (virtualizor is db)
REPAIR TABLE tasks USE_FRM;



I tried again and it worked....
Thank you so much


]]> Tue, 15 Nov 2022 06:20:19 GMT https://www.softaculous.com/board/index.php?tid=8821&tpg=1#p55703 <![CDATA[Could not make Query after Update]]> https://www.softaculous.com/board/index.php?tid=8821&tpg=1#p55702 mysql> REPAIR TABLE tasks USE_FRM;
+-------------------+--------+----------+------------------------------------------------------+
| Table            | Op    | Msg_type | Msg_text                                            |
+-------------------+--------+----------+------------------------------------------------------+
| virtualizor.tasks | repair | error    | Can't create new tempfile: './virtualizor/tasks.TMD' |
| virtualizor.tasks | repair | status  | Operation failed                                    |
+-------------------+--------+----------+------------------------------------------------------+
2 rows in set (0,00 sec)

Dont work  :squi: ]]> Tue, 15 Nov 2022 06:16:43 GMT https://www.softaculous.com/board/index.php?tid=8821&tpg=1#p55702 <![CDATA[Could not make Query after Update]]> https://www.softaculous.com/board/index.php?tid=8821&tpg=1#p55701
Run this command and check if TMD file does not exists: ls -lha /usr/local/emps/var/mysql/virtualizor/tasks.*
If it does not lists TMD file then you can proceed with following steps and if it exists then move it to other location :
touch /usr/local/emps/var/mysql/virtualizor/tasks.MYD
touch /usr/local/emps/var/mysql/virtualizor/tasks.MYI
chown mysql:mysql /usr/local/emps/var/mysql/virtualizor/tasks.MY*
Then execute this query in mysql cli (after logging to virtualizor database)
grep dbpass /usr/local/virtualizor/universal.php  ...mysql password
# /usr/local/emps/bin/mysql -u root -p virtualizor (to open db, will ask for password)
use virtualizor; (virtualizor is db)
REPAIR TABLE tasks USE_FRM;
]]> Tue, 15 Nov 2022 05:27:42 GMT https://www.softaculous.com/board/index.php?tid=8821&tpg=1#p55701 <![CDATA[Could not make Query after Update]]> https://www.softaculous.com/board/index.php?tid=8821&tpg=1#p55698
Quote From : Suhas_Patil November 14, 2022, 10:47 am
;-D Hi,

Sir,If you are unable to load panel then make sure virtualizor service is running which can be checked using :#service virtualizor status

If it is stopped then you will need to start the service
#service virtualizor start

If you use service virtualizor restart command then virtualizor will ping 4.2.2.1 . So if ping is disabled on your server then you can try starting php, nginx and mysql service separately :

/usr/local/emps/bin/fpmctl start
/usr/local/emps/bin/nginxctl start
/usr/local/emps/bin/mysqlctl start

*Firewall

Virtualizor uses ports from 4081 - 4085. If there is any firewall restricting this, you will need to allow these ports.

For RHEL & CentOS < 7

iptables -I INPUT 1 -p tcp -m tcp --dport 4081:4085 -j ACCEPT

iptables -I INPUT 2 -p tcp -m tcp --dport 5900:6000 -j ACCEPT

For RHEL & CentOS 7+

firewall-cmd --zone=public --permanent --add-port=4081-4085/tcp

firewall-cmd --zone=public --permanent --add-port=5900-6000/tcp


Let us know if you need any further assistance




Hi friend, thanks for replying.
Virtualizor is running normally vps are online, client side virtualizor is working normally.

When I try to access the admin panel it gives this error in the database and I can't solve it.]]> Mon, 14 Nov 2022 13:22:53 GMT https://www.softaculous.com/board/index.php?tid=8821&tpg=1#p55698 <![CDATA[Could not make Query after Update]]> https://www.softaculous.com/board/index.php?tid=8821&tpg=1#p55695 Hi,

Sir,If you are unable to load panel then make sure virtualizor service is running which can be checked using :#service virtualizor status

If it is stopped then you will need to start the service
#service virtualizor start

If you use service virtualizor restart command then virtualizor will ping 4.2.2.1 . So if ping is disabled on your server then you can try starting php, nginx and mysql service separately :

/usr/local/emps/bin/fpmctl start
/usr/local/emps/bin/nginxctl start
/usr/local/emps/bin/mysqlctl start

*Firewall

Virtualizor uses ports from 4081 - 4085. If there is any firewall restricting this, you will need to allow these ports.

For RHEL & CentOS < 7

iptables -I INPUT 1 -p tcp -m tcp --dport 4081:4085 -j ACCEPT

iptables -I INPUT 2 -p tcp -m tcp --dport 5900:6000 -j ACCEPT

For RHEL & CentOS 7+

firewall-cmd --zone=public --permanent --add-port=4081-4085/tcp

firewall-cmd --zone=public --permanent --add-port=5900-6000/tcp


Let us know if you need any further assistance

]]> Mon, 14 Nov 2022 10:47:22 GMT https://www.softaculous.com/board/index.php?tid=8821&tpg=1#p55695 <![CDATA[Could not make Query after Update]]> https://www.softaculous.com/board/index.php?tid=8821&tpg=1#p55686
Could not make the Query.
SELECT tasks.actid, tasks.action, users.uid, users.email FROM `tasks` LEFT JOIN users on tasks.uid = users.uid WHERE action NOT IN ('vpsbackups_plan_email', 'send_background_mail', 'backuply_vpsbackups_plan_email') ORDER BY tasks.actid DESC LIMIT 10
Array
(
    [0] => HY000
    [1] => 144
    [2] => Table './virtualizor/tasks' is marked as crashed and last (automatic?) repair failed]]> Sun, 13 Nov 2022 23:18:19 GMT https://www.softaculous.com/board/index.php?tid=8821&tpg=1#p55686 <![CDATA[Could not make Query after Update]]> https://www.softaculous.com/board/index.php?tid=8821&tpg=1#p30568
Seems the update of Virtualizor panel has fixed the issue.
Let us know if you still face any issue.
]]> Mon, 21 Mar 2016 09:04:24 GMT https://www.softaculous.com/board/index.php?tid=8821&tpg=1#p30568 <![CDATA[]]> https://www.softaculous.com/board/index.php?tid=8821&tpg=0#p30545
ould not make the Query.
SELECT (SELECT COUNT(vps.vpsid) FROM `vps`) AS vpsnum, (SELECT COUNT(ipid) FROM `ips`) AS ipsnum, (SELECT COUNT(stid) FROM `storage`) AS numstorage, (SELECT COUNT(plid) FROM `plans`) AS numplans, (SELECT COUNT(uid) FROM `users`) AS numusers, (SELECT COUNT(id) FROM `pdns`) AS numpdns, (SELECT COUNT(osid) FROM `os`) AS numos, (SELECT COUNT(rid) FROM `recipes`) AS numrecipes, (SELECT COUNT(actid) FROM `tasks` WHERE ended = 0 AND updated >= 1458398556 AND started >= 1458398556) AS numtasks
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'virtualizor.recipes' doesn't exist
)

All containers are running properly and everything is reachable from command line.  ]]> Sat, 19 Mar 2016 15:42:55 GMT https://www.softaculous.com/board/index.php?tid=8821&tpg=0#p30545