Jump to content

SQL Query Help Needed.


Guest Michael Dray
 Share

Recommended Posts

Guest Michael Dray

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...