Quote:
Originally Posted by x123x123x
To get rid of a error in the LogDBManager:
42S01 [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'tbl_AT_Inca_20200110' in the database.
Modify the rows in the stored procedure [AtlanticaLog].[dbo].[rsp_Log_TotalSet]
EXEC dbo.rasp_MakeLogTable @  TableName
To
if OBJECT_ID @ TableName) IS NULL AND OBJECTPROPERTY(OBJECT_ID @ TableName), 'IsTable') = 0
begin
EXEC dbo.rasp_MakeLogTable @ TableName
end
The error is that the manager is trying to create a table that has already been created.
Changes make it a condition that if such a table exists, the table is not recreated.
After that, you will quickly fill the database with logs and increase the size of the database even faster. |
This is not the right way to fix it..
If you look inside the dbo.rasp_MakeLogTable function you will see it already has this functionality
CREATE PROCEDURE [dbo].[rasp_MakeLogTable]
@
TableName sysname
AS
SET NOCOUNT ON
SET XACT_ABORT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
DECLARE @
nvarchar(2000)
-- 肺弊抛捞喉捞 绝栏搁 货肺 父电促.
IF NOT EXISTS (SELECT * FROM sysobjects where name = @TableName)
begin
-- ...
---------------------------------------------------------------------------------------------------
Updated my Database Installer with a few fixes I found in all 18 pages of this thread!.
if you want x123x123x can you put the Database Installer links to first page to help people quicker but its up to you though
.
It's pre-setup so it will work on fresh servers out of the box.. only need to modify the Master Server's serverinfo.txt with the correct paths in ExecFile and PublicIP's for FrontServer and GameServer
Code:
Comes with accounts
GM accounts
----------------
user: highgamer pw: test
user: test1 pw: test
----------------
Regular accounts
----------------
user: test pw: test
user: test2 pw: test114
user: test5 pw: test114
user: test114 pw: test114
user: testacc pw: asdfqwerty
Install Video
New Update Download link for small DB (Installed size 261 MB, .BAK size: 145 MB) :
Comes with auto installer! [Run Restore Database Backups.bat] file!
MediaFire
Mirror Google Drive:
Mirror Google Drive 2:
----------------------------------------------------------------------------------------------------
Got database down from 50GB to 1.95 GB to 285 MB and now final version 261 MB!
the .bak files some dropped in half their sizes because I backed up twice in previous update.. so now they total 145 MB.
Added a few fixes to 3 Database files.. also updated the .BAK files with new changes, from scanning all 18 pages of New Year's surprise! thread I updated these 3 patches to the database files.
Fixed all database .SQL/.Bak file growths from 5 MB to 1 MB.
---------------------------------
Found a bug when you perform a Backup to .BAK files if a previous .BAK file exists it will not overwrite it but append to it.. so your .BAK file will have 2 backup's of the same database so your .BAK file will grow twice the size for no reason thats why I deleted all .BAK's and recreated them to make them as small as possible.
------------------------------------------
updated
AT_GameDB01.sql
AT_InterDB01.sql
replaced
UPDATE [dbp].[tbl_VillageStructure]
to
UPDATE [dbo].[tbl_VillageStructure]
updated
AT_Community.sql
replaced
UPDATE dbo.tbl_GuildTraning SET StartHourvary = 0 WHERE GuildUnique = @
Unique
to
UPDATE dbo.tbl_GuildTraining SET StartHourvary = 0 WHERE GuildUnique = @
Unique
Another bug I discovered in AT_InterDB01
---------------------------------
A bunch of procedures in AT_InterDB01 like
rasp_PersonInfoToWeb117_VIP
rasp_PersonInfoToWeb117
require new database's (LinkedServer doesn't help here).
AT_GameDB01,
AT_GameDB02,
AT_GameDB03,
AT_GameDB10,
AT_GameDB11,
AT_GameDB12,
AT_GameDB14,
Also AT_AccountDB uses these databases..
They call procedure
rasp_PersonInfoToWeb
Figured best way to fix this is call AT_GameDB01 instead..
but what I found out was AT_GameDB01's rasp_PersonInfoToWeb requires 2 parameters (ServerId, IDNum),
but this one only sent (IDNum) so it's not AT_GameDB01
I found in AT_InterDB01 it contains rasp_PersonInfoToWeb which requires 1 paramter (IDNum), thats probably the right way to fix it.
I decided not to fix it by changing AT_GameDB's in AT_InterDB01 to AT_InterDB01 instead of AT_GameDB##.
Since this is for updating stats like leaderboards on website. It will never be used.
