Guest Michael Dray Posted February 8, 2007 Share Posted February 8, 2007 Hi guys I need sum1's help I made a but of a mistake. I was running an mod and the 1st bit said > Run these queries before implementing the file changes below: > ALTER TABLE CubeCart_category ADD catDisplayOrderID int(11) NOT NULL > default '0'; > ALTER TABLE CubeCart_inventory ADD productDisplayOrderID int(11) NOT NULL > default '0'; However me bein the genius that I am and no knowing how to run an SQL Query I just ignored it. Now my whole site dont work. :-( I can supply any details of datebase anything etc. Can any1 just run these 2 queries for me. Thanks in advace. Mike Quote Link to comment Share on other sites More sharing options...
convict Posted February 10, 2007 Share Posted February 10, 2007 Paste following code to a new text file, name it whatever but extension php, upload to your root store folder and 'run'. <?php include_once("includes/global.inc.php"); include_once("classes/db.inc.php"); $db = new db(); $db->misc("ALTER TABLE `".$glob['dbprefix']."CubeCart_category` ADD catDisplayOrderID int(11) NOT NULL default '0'"); $db->misc("ALTER TABLE `".$glob['dbprefix']."CubeCart_inventory` ADD productDisplayOrderID int(11) NOT NULL default '0'"); ?> DONE! FYI: it is always prefered to contact the mod author first Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.