Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 VPCart 9 Questions
 Query window not allows to run ALTER command
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Alex123
VP-CART Super User

USA
223 Posts

Posted - March 02 2021 :  16:12:54  Show Profile  Reply with Quote
Hello,

I am trying to modify a table using ALTER command. For this i have run the query using query & export window in vpcart admin. But it shows error ''Only s elect is allowed''. Please help.

Regards,
Alex



Edited by - Alex123 on March 02 2021 17:52:52

support
Administrator

4679 Posts

Posted - March 02 2021 :  17:50:51  Show Profile  Visit support's Homepage  Reply with Quote
Dear Alex,

You can run ALTER commands from VPCart admin >> ''Misc'' >> ''Database tool'' section. Firstly save the SQL syntax into a txt file e.g. sql-query.txt. Then upload the txt file into the admin folder using FTP.Then you can try to execute it from the Database Tool menu in the administration, and entering the txt filename that you have uploaded and click Convert. Please refer the following helpguide for more details.

https://helpnotes.vpcart.com/userguide900/#!Documents/databasetool.htm

If you need any help you may open a helpdesk ticket including your VPCart admin login details, and we are more than happy to assist you further.

You can access our Helpdesk from url:

https://helpdesk.vpcart.com/

Thank you,

VPCart Customer Care Team
www.vpcart.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00