|
You last visited: Today at 02:35
Advertisement
Website Database
Discussion on Website Database within the Flyff Private Server forum part of the Flyff category.
01/29/2017, 00:23
|
#1
|
elite*gold: 0
Join Date: Jun 2008
Posts: 355
Received Thanks: 5
|
Website Database
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.
define('ODBC_USER', 'sa');
define('ODBC_PASS', '123456'); //
$odbc_connect = odbc_connect('DRIVER={SQL Server};SERVER=FLYFF\SQLEXPRESS', ODBC_USER, ODBC_PASS);
Example Problem
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
|
|
|
01/29/2017, 20:25
|
#2
|
ベトナム警察
elite*gold: 725
Join Date: Jan 2012
Posts: 16,377
Received Thanks: 3,429
|
Try it without any password.
|
|
|
01/29/2017, 21:24
|
#3
|
elite*gold: 0
Join Date: May 2014
Posts: 4,405
Received Thanks: 933
|
You can add me in Skype and I would help you :-)!
|
|
|
01/29/2017, 22:59
|
#4
|
elite*gold: 0
Join Date: May 2012
Posts: 870
Received Thanks: 642
|
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.
|
|
|
01/30/2017, 06:50
|
#5
|
elite*gold: 0
Join Date: Mar 2013
Posts: 200
Received Thanks: 38
|
|
|
|
01/30/2017, 13:07
|
#6
|
elite*gold: 0
Join Date: Jun 2008
Posts: 355
Received Thanks: 5
|
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
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
|
|
|
01/30/2017, 16:42
|
#7
|
ベトナム警察
elite*gold: 725
Join Date: Jan 2012
Posts: 16,377
Received Thanks: 3,429
|
Could not find stored procedure 'ACCOUNT_DBF.dbo.usp_createAccount'.
Quote:
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
|
|
|
|
01/30/2017, 22:40
|
#8
|
elite*gold: 0
Join Date: Jun 2008
Posts: 355
Received Thanks: 5
|
Quote:
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
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'.
|
|
|
01/31/2017, 00:06
|
#9
|
ベトナム警察
elite*gold: 725
Join Date: Jan 2012
Posts: 16,377
Received Thanks: 3,429
|
Quote:
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.
|
|
|
01/31/2017, 05:35
|
#10
|
elite*gold: 0
Join Date: Jun 2008
Posts: 355
Received Thanks: 5
|
Quote:
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?
|
|
|
01/31/2017, 06:21
|
#11
|
elite*gold: 0
Join Date: May 2014
Posts: 4,405
Received Thanks: 933
|
Quote:
Originally Posted by khemomo
thank you!!!
how about this one?
|
You can delete it. In this case its just useless because its not fixed.
|
|
|
03/27/2018, 01:19
|
#12
|
elite*gold: 0
Join Date: Jun 2012
Posts: 2
Received Thanks: 0
|
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:
|
|
|
|
Similar Threads
|
Linking website to database
02/22/2012 - Shaiya Private Server - 9 Replies
I have searched High and low and altho there are posts on fixing Apache issues i cannot find a way to setup in the first place. This sadly is where I lack and unfortunately a large part of getting a server public so any help advice pointing's to tutorials would be wholly appreciated.
What i need is to know
1)what programs i need to get my php(registration,pvprank, etc)linked to my database(MS SQL 2008)
2)anyway i need to change things when intallation is complete
3)Noob language as i...
|
Archlord Database Website
08/23/2011 - Archlord - 9 Replies
hey all,
im looking for all archlord database website plz post me some :)
thx
|
Website database ?
04/20/2011 - Archlord - 4 Replies
Hello,
Anyone noticed that they erased link for Webzen Database <=> Oracle ?
When you go on Ranking page, last update script was made 13th.
And when you go on Guild ranking / Castle holders it seems a bit disturbed ... :D
|
[HELP] How do i add my database to my website?
07/20/2010 - EO PServer Hosting - 12 Replies
Im hosting a webs.com website. Can anyone help me with adding my database to the register page or something? Or can you give me a link to a website that can do it, im not sure if webs.com can do it.
How do i fix MsgServer2.700.exe? Everytime i open it, it closes around 1 minute after it being open.
Thank you.
|
All times are GMT +2. The time now is 02:35.
|
|