B-2-0 Website error

Alright im using the B-2-0 website and i found the fixes and what not someone else posted but there are still some errors i need help fixing if someone wouldn't mind if they've already set it up before.


this is at the top of every page and im not sure how to fix it

Quote:

---

Warning: touch() [function.touch]: Unable to create file logs/DoSlogs/f8d because No such file or directory in C:\xampp\htdocs\secondwebsite\includes\shield.php on line 71

---

When i click on items gallery i get this error i ran the .dbo file but i guess these didn't work? i opened things like account.dbo and tried to replace the .dbo with the one that was included but it wouldn't let me change it because i couldn't delete the .dbo file and replace it or just edit it and replace it because it already existed

Quote:

---

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'Slot'. (severity 16) in C:\xampp\htdocs\secondwebsite\modules\mod_itemshop.php on line 29

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\secondwebsite\modules\mod_itemshop.php on line 29

Fatal error: Call to undefined function mssql_error() in C:\xampp\htdocs\secondwebsite\modules\mod_itemshop.php on line 29

---

this is also what happens after you log in

http://i44.tinypic.com/q2qo.jpg

May i have the link to the Web you are using please?

the error is exactly what it says...the header was already sent o-o

and also that the directory in your shield.php its trying to create logs in a folder that does not exsist.

- "No such file or directory in C:\xampp\htdocs\secondwebsite\includes\shield.php on line 71". Check which file/directory it is in includes/shield.php and create it.

- "Invalid column name 'Slot'." The column Slot obviously does not exist. Maybe you didn't import the SQL file correctly.

Read the error carefully...read the addresses and create log file in .php files..just delete the "touch()" function in shield.php
the place where u get 'SLOT' error. Just go to mssql and add new column or if u cant add , delete the 'slot' value in .php files..

bout Loging in, please check your config.php in includes folder and check login.php too..check whether u have entered your MSSQL information( id pass server name) correct..
THATS ALL.. Minor mistakes. :)

i re-read the first error i put um there and went into logs and made a folder called DoSlogs and that error went away. i can't get the item gallery error fixed but whatever

post the query that is causing the error?

Code:

---

warning: Mssql_query() [function.mssql-query]: Message: Invalid column name 'slot'. (severity 16) in c:\xampp\htdocs\secondwebsite\modules\mod_itemshop.php on line 29

warning: Mssql_query() [function.mssql-query]: Query failed in c:\xampp\htdocs\secondwebsite\modules\mod_itemshop.php on line 29

fatal error: Call to undefined function mssql_error() in c:\xampp\htdocs\secondwebsite\modules\mod_itemshop.php on line 29

---

here is just part of it when i run gunzdb that is included with the website:

Code:

---

msg 15023, level 16, state 1, line 12
-------user, group, or role 'gunz' already exists in the current database.
Msg 2714, level 16, state 6, line 6
-------there is already an object named 'account' in the database.
Msg 1913, level 16, state 1, line 2
-------the operation failed because an index or statistics with name -------'ix_account_regdate' already exists on table 'dbo.account'.
Msg 1913, level 16, state 1, line 2
--------the operation failed because an index or statistics with name --------'ix_account_userid' already exists on table 'dbo.account'.
Msg 2714, level 16, state 6, line 6
--------there is already an object named 'accountitem' in the database.
Msg 1913, level 16, state 1, line 2
---------the operation failed because an index or statistics with name --------'ix_accountitem_aid' already exists on table 'dbo.accountitem'.
Msg 1913, level 16, state 1, line 2
----------the operation failed because an index or statistics with name ------'ix_accountitem_rentdate' already exists on table 'dbo.accountitem'.
Msg 2714, level 16, state 6, line 6
-----there is already an object named 'accountpenaltylog' in the database.
Msg 1913, level 16, state 1, line 2
-------the operation failed because an index or statistics with name -------'ix_accountpenaltylog_aid' already exists on table -------'dbo.accountpenaltylog'.
Msg 2714, level 16, state 6, line 6
-----there is already an object named 'accountpenaltyperiod' in the database.
Msg 2714, level 16, state 6, line 6
--------there is already an object named 'billingmethod' in the database.
Msg 2714, level 16, state 6, line 6
----------there is already an object named 'blockcountrycode' in the database.
Msg 1913, level 16, state 1, line 2
--------the operation failed because an index or statistics with name ---------'ix_blockcountrycode_isblock' already exists on table 'dbo.blockcountrycode'.
Msg 2714, level 16, state 6, line 6
-------there is already an object named 'bringaccountitemlog' in the database.
Msg 1913, level 16, state 1, line 2
----------the operation failed because an index or statistics with name ------'ix_bringaccoutitem_aid' already exists on table --------'dbo.bringaccountitemlog'.
Msg 2714, level 16, state 6, line 6
-----there is already an object named 'cashitempresentlog' in the database.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashitempresentlog_date' already exists on table 'dbo.cashitempresentlog'.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashitempresentlog_receiveraid' already exists on table 'dbo.cashitempresentlog'.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashitempresentlog_senderuserid' already exists on table 'dbo.cashitempresentlog'.
Msg 2714, level 16, state 6, line 6
there is already an object named 'cashsetitem' in the database.
Msg 2714, level 16, state 6, line 6
there is already an object named 'cashsetshop' in the database.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashsetshop_newitemorder' already exists on table 'dbo.cashsetshop'.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashsetshop_opened' already exists on table 'dbo.cashsetshop'.
Msg 2714, level 16, state 6, line 6
there is already an object named 'cashshop' in the database.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashshop_itemid_opened' already exists on table 'dbo.cashshop'.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashshop_newitemorder' already exists on table 'dbo.cashshop'.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashshop_opened' already exists on table 'dbo.cashshop'.
Msg 2714, level 16, state 6, line 6
there is already an object named 'cashshopnewitem' in the database.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashshopnewitem_neworder' already exists on table 'dbo.cashshopnewitem'.
Msg 2714, level 16, state 6, line 6
there is already an object named 'cashshopnewitemcategory' in the database.
Msg 2714, level 16, state 6, line 6
there is already an object named 'cashshoprank' in the database.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashshoprank_category' already exists on table 'dbo.cashshoprank'.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_cashshoprank_rank' already exists on table 'dbo.cashshoprank'.
Msg 2714, level 16, state 6, line 6
there is already an object named 'character' in the database.
Msg 1913, level 16, state 1, line 2
the operation failed because an index or statistics with name 'ix_character_aid' already exists on table 'dbo.character'.

---

Code:

---

if(!function_exists("ListAllItems")){
function ListAllItems(){
    if(!isset($_GET['type'])){
        $type = "";
    }else{
        $type = "Slot = '".antisql($_GET['type'])."' AND";
    }
    if(($_GET['type']) == 10){
        msgbox ("Press Ok to go to Change Character Name page","index.php?do=ccn");
    }
if ((!isset($_GET['pagenum'])) || (!is_numeric($_GET['pagenum'])) || ($_GET['pagenum'] < 1)) { $pagenum = 1; }
else { $pagenum = $_GET['pagenum']; }
$result = mssql_query ("SELECT * FROM CashShop WHERE ".$type." Opened = '1'") or die(mssql_error());
$rows = mssql_num_rows($result);

---

this is were the error is in the php i guess

UPDATE CashShop ADD slot varchar(50)

Quote:

---

Originally Posted by Vusion

UPDATE CashShop ADD slot varchar(50)

---

what do you mean? i clicked design cashshop to "add" something but idk what you want me to add....

why not create the column yourself.
just as test use Varchar(100) as key or something.
most of the time it will work.

Quote:

---

Originally Posted by jur13n

why not create the column yourself.
just as test use Varchar(100) as key or something.
most of the time it will work.

---

what do you mean, in the database?

i also just came across another error

Quote:

---

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'sa'. (severity 16) in C:\xampp\htdocs\secondwebsite\modules\mod_register.php on line 185

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'sq'. (severity 16) in C:\xampp\htdocs\secondwebsite\modules\mod_register.php on line 185

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'captcha_code'. (severity 16) in C:\xampp\htdocs\secondwebsite\modules\mod_register.php on line 185

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\secondwebsite\modules\mod_register.php on line 185

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'euCoins'. (severity 16) in C:\xampp\htdocs\secondwebsite\modules\mod_register.php on line 189

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\secondwebsite\modules\mod_register.php on line 189



The Account 'monk' has been created successfully.
To edit your profile, login and click Profile "Edit my account"

---

when i try and register an account this happens but the account is never made. please help me :$:

my code was an sql query.

Code:

---

ALTER TABLE CashShop ADD slot varchar(50)
ALTER TABLE Account ADD sa varchar(500)
ALTER TABLE Account ADD sq varchar(500)
ALTER TABLE Account ADD captcha_code varchar(50)
ALTER TABLE Login Add euCoins int

---

thank you that fixed the cash shop error i've been getting also another error when im trying to create or edit my account's "sex" "zip code" and "address" it get an error after click update and it doesn't work.

Quote:

---

Warning: mssql_query() [function.mssql-query]: message: Conversion failed when converting the varchar value 'Male' to data type tinyint. (severity 16) in C:\xampp\htdocs\secondwebsite\modules\mod_register.php on line 185

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\secondwebsite\modules\mod_register.php on line 185



The Account 'daniel13605' has been created successfully.
To edit your profile, login and click Profile "Edit my account"

---

im not very good with database edits but can you do the same thing for this for me please? if im correct by how you did it would it be
ALTER TABLE Account ADD male varchar(500) ?

After filling out the register data and click submit it still doesn't create the account

change sex's datatype to varchar(50) OR, you change the register to insert 1 or 0. why do you need to know his gender anyway..