Welcome Guest. Please Login or Register  


You are here: Index > Virtualizor - Virtual Server Control Panel > General Support > Topic : Could not make Query after Update



Threaded Mode | Print  

 Could not make Query after Update, Could not make Query after Update (8 Replies, Read 16739 times)
morsepi
Group: Member
Post Group: Newbie
Posts: 2
Status:
After running an update in the GUI it errored out.  Now when GUI loads I get the following error:

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. 
IP: --   

Could not make Query after Update
jevingala
Group: Virtualizor Team
Post Group: Super Member
Posts: 716
Status:
Hi,

Seems the update of Virtualizor panel has fixed the issue.
Let us know if you still face any issue.


-----------------------
Regards,
Virtualizor Team.
http://virtualizor.com/
IP: --   

Could not make Query after Update
avense
Group: Member
Post Group: Newbie
Posts: 4
Status:
I can't access my virtualizor

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
IP: --   

Could not make Query after Update
Suhas_Patil
Group: Member
Post Group: Newbie
Posts: 1
Status:
;-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

IP: --   

Could not make Query after Update
avense
Group: Member
Post Group: Newbie
Posts: 4
Status:
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.
IP: --   

Could not make Query after Update
sanjeet_virt
Group: Member
Post Group: Newbie
Posts: 9
Status:
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;
IP: --   

Could not make Query after Update
avense
Group: Member
Post Group: Newbie
Posts: 4
Status:
:squi: 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:
IP: --   

Could not make Query after Update
avense
Group: Member
Post Group: Newbie
Posts: 4
Status:
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


IP: --   

Could not make Query after Update
sanjeet_virt
Group: Member
Post Group: Newbie
Posts: 9
Status:
Hi,


Sir, Please let us know for any further assistance.
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is February 2, 2023, 7:31 am.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.079