Website Database

[khemomo]

Guys how can I fix this one I've already change this in xinc_config.
I'am using Plesk webhost I dont know why I cant fix this one
Everytime I open my website it gives me a bunch of errors.

There is currently no database connection.

I'am 100% that the SQL Password "123456" is correct then the "FLYFF\SQLEXPRESS" is also 100% correct

this website is working on my Other pc with localhost IP.

 Spoiler

define('ODBC_USER', 'sa');
define('ODBC_PASS', '123456'); //
$odbc_connect = odbc_connect('DRIVER={SQL Server};SERVER=FLYFF\SQLEXPRESS', ODBC_USER, ODBC_PASS);

Example Problem

 Spoiler

Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\Inetpub\vhosts\Flyff.com\httpdocs\includes\site _boxes.phtml on line 27 Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\Inetpub\vhosts\Flyff.com\httpdocs\includes\site _boxes.phtml on line 28 Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\Inetpub\vhosts\Flyff.com\httpdocs\includes\site _boxes.phtml on line 29 Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\Inetpub\vhosts\Flyff.com\httpdocs\includes\site _boxes.phtml on line 30 Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\Inetpub\vhosts\Flyff.com\httpdocs\includes\site _boxes.phtml on line 31 Warning: odbc_exec() expects parameter 1 to be resource, boolean
C:\Inetpub\vhosts\Flyff.com\httpdocs\index.php on line 95

Please guys help me

I'am using Aurea Website

[Lumi]

Try it without any password.

[Michi]

You can add me in Skype and I would help you :-)!

[xsrf]

1. Dont use sa as master database user.

2. When your credentials are all fine there is maybe a probnlem in C:\Inetpub\vhosts\Flyff.com\httpdocs\includes\site _boxes.phtml.

[flyffdev]

define('ODBC_USER', 'sa');
define('ODBC_PASS', '123456'); //
$odbc_connect = odbc_connect('DRIVER={SQL Server};SERVER=127.0.0.1, 1433', ODBC_USER, ODBC_PASS);


Then Follow this Steps

[khemomo]

thanks guys now I have an access to my website but my problem now is this

Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'ACCOUNT_DBF.dbo.usp_createAccount'., SQL state 37000 in SQLExecDirect in C:\Inetpub\vhosts\Flyff.com\httpdocs\sites\regist. php on line 72

Line 71-72

 Spoiler

EXEC [' . $_CONFIG['db_databases']['acc'] . '].[dbo].[usp_createAccount] @account=\'' . $account . '\', @pw=\''.$md5pw.'\', @=\''.$email.'\', @ra=\''.$gefra.'\', @t=\''.md5($_CONFIG['security_secretAnswerSalt'].$geant).'\', @=\''.date($_CONFIG['web_date_format']['date'], strtotime($birthday)).'\', @ip = \'' . $_SERVER['REMOTE_ADDR'] . '\', @=\'' . $_CONFIG['web_default_lang'] . '\'
')) {

and about the captcha I cant input a captcha because of this error.

ERROR for site owner:
Invalid domain for site key

[Lumi]

Could not find stored procedure 'ACCOUNT_DBF.dbo.usp_createAccount'.

 Spoiler

USE [ACCOUNT_DBF]
GO

/****** Object: StoredProcedure [dbo].[usp_createAccount] Script Date: 08/22/2013 12:08:16 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_createAccount]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[usp_createAccount]
GO

USE [ACCOUNT_DBF]
GO

/****** Object: StoredProcedure [dbo].[usp_createAccount] Script Date: 08/22/2013 12:08:16 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE proc [dbo].[usp_createAccount]
@account varchar(32),
@pw varchar(32),
@cash int = 0,
@email varchar(100) = '',
@gefra smallint = 0,
@geant varchar(50),
@birthday varchar(10),
@ip varchar(39),
@lang varchar(3)
as
set nocount on
set xact_abort on

if not exists (select * from ACCOUNT_TBL where account = @account)
begin


begin tran
INSERT ACCOUNT_TBL(account,password,isuse,member,id_no1,i d_no2,realname,OldPassword,cash)
VALUES(@account, @pw, 'T', 'A', @pw, @pw, 'P',@pw, @cash)
INSERT ACCOUNT_TBL_DETAIL(account,gamecode,tester,m_chLog inAuthority,regdate,BlockTime,EndTime,WebTime,isus e,secession, email,secretquestion,secretanswer,birthday,regIP)
VALUES(@account,'A000','2','F',GETDATE(),CONVERT(C HAR(8),GETDATE()-1,112),CONVERT(CHAR(8),DATEADD(year,10,GETDATE()), 112),CONVERT(CHAR(8),GETDATE()-1,112),'T',NULL, @email, @gefra, @geant, @birthday,@ip)

if @@error <> 0
begin
rollback tran
select -1
end
else
begin
commit tran
select 1
end
end
else
begin
select 0
end


GO

[khemomo]

Originally Posted by ​Lumi

Could not find stored procedure 'ACCOUNT_DBF.dbo.usp_createAccount'.

I got this error when i'am trying to Execute the code you've given to me

 Spoiler

Msg 102, Level 15, State 1, Procedure usp_createAccount, Line 22
Incorrect syntax near 'd_no2'.
Msg 102, Level 15, State 1, Procedure usp_createAccount, Line 24
Incorrect syntax near 'inAuthority'.

[Lumi]

 Spoiler

USE [ACCOUNT_DBF]
GO

/****** Object: StoredProcedure [dbo].[usp_createAccount] Script Date: 08/22/2013 12:08:16 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_createAccount]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[usp_createAccount]
GO

USE [ACCOUNT_DBF]
GO

/****** Object: StoredProcedure [dbo].[usp_createAccount] Script Date: 08/22/2013 12:08:16 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE proc [dbo].[usp_createAccount]
@account varchar(32),
@pw varchar(32),
@cash int = 0,
@email varchar(100) = '',
@gefra smallint = 0,
@geant varchar(50),
@birthday varchar(10),
@ip varchar(39),
@lang varchar(3)
as
set nocount on
set xact_abort on

if not exists (select * from ACCOUNT_TBL where account = @account)
begin


begin tran
INSERT ACCOUNT_TBL(account,password,isuse,member,id_no1,i d_no2,realname,OldPassword,cash)
VALUES(@account, @pw, 'T', 'A', @pw, @pw, 'P',@pw, @cash)
INSERT ACCOUNT_TBL_DETAIL(account,gamecode,tester,m_chLog inAuthority,regdate,BlockTime,EndTime,WebTime,isus e,secession, email,secretquestion,secretanswer,birthday,regIP)
VALUES(@account,'A000','2','F',GETDATE(),CONVERT(C HAR(8),GETDATE()-1,112),CONVERT(CHAR(8),DATEADD(year,10,GETDATE()), 112),CONVERT(CHAR(8),GETDATE()-1,112),'T',NULL, @email, @gefra, @geant, @birthday,@ip)

if @@error <> 0
begin
rollback tran
select -1
end
else
begin
commit tran
select 1
end
end
else
begin
select 0
end


GO

Please just look at the error. There were 2 syntax error in line 22 and 24.
In some cases like this you could also investigate it first for yourself.

[khemomo]

Originally Posted by ​Lumi

Please just look at the error. There were 2 syntax error in line 22 and 24.
In some cases like this you could also investigate it first for yourself.

thank you!!!

how about this one?

[Michi]

Originally Posted by khemomo

thank you!!!

how about this one?

You can delete it. In this case its just useless because its not fixed.

[MarcioSouza]

Hi, I'm having trouble editing anything on the site when it's in the dedicated. In the localhost opens the window to edit what I want, but in the dedicated buga the window, I can not edit, it follows images: