Register for your free account! | Forgot your password?

You last visited: Today at 16:11

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



itemmall error

Discussion on itemmall error within the Shaiya PServer Development forum part of the Shaiya Private Server category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jul 2017
Posts: 39
Received Thanks: 1
Question itemmall error

hey, im using Omega Files, with shaiya ep5 client, i tried changing clients,SQL,shen files "ps_game etc.." and everything in epvp's forum, and nothing worked... ingame itemmall, says "no item located at that spot", and whenever i try to execute the Cash.sdata in sql i get this error :
"Msg 213, Level 16, State 1, Line 2
Column name or number of supplied values does not match table definition."
i tried deleting everything in the cash.sdata and creating new items, still not working. would appreciate any help.
Ashura313 is offline  
Old 09/08/2018, 22:28   #2
 
elite*gold: 0
Join Date: Mar 2018
Posts: 251
Received Thanks: 104
Wink

Quote:
Originally Posted by Ashura313 View Post
hey, im using Omega Files, with shaiya ep5 client, i tried changing clients,SQL,shen files "ps_game etc.." and everything in epvp's forum, and nothing worked... ingame itemmall, says "no item located at that spot", and whenever i try to execute the Cash.sdata in sql i get this error :
"Msg 213, Level 16, State 1, Line 2
Column name or number of supplied values does not match table definition."
i tried deleting everything in the cash.sdata and creating new items, still not working. would appreciate any help.
Ok you executed the cash.sdata query not working i guess the code is wrong and not working check something if i'ts wrong
[DEV]Wan is offline  
Thanks
1 User
Old 09/08/2018, 23:04   #3
 
elite*gold: 0
Join Date: Jun 2014
Posts: 134
Received Thanks: 124
Quote:
Originally Posted by Ashura313 View Post
hey, im using Omega Files, with shaiya ep5 client, i tried changing clients,SQL,shen files "ps_game etc.." and everything in epvp's forum, and nothing worked... ingame itemmall, says "no item located at that spot", and whenever i try to execute the Cash.sdata in sql i get this error :
"Msg 213, Level 16, State 1, Line 2
Column name or number of supplied values does not match table definition."
i tried deleting everything in the cash.sdata and creating new items, still not working. would appreciate any help.
good, first of all, see if your Product List table has the RowID column, if it has, DELETE, save and then run cash.sql again
perlisson is offline  
Thanks
1 User
Old 09/09/2018, 11:41   #4
 
elite*gold: 0
Join Date: Mar 2017
Posts: 111
Received Thanks: 123
Services / Distributed Transaction Editor / Network Service
Get Running


Services / KtmRm for Distributed Transaction Coordinator / Network Service
Get Running
RebirthEpic is offline  
Thanks
1 User
Old 09/09/2018, 19:49   #5
 
elite*gold: 0
Join Date: Jul 2017
Posts: 39
Received Thanks: 1
nothing working yet :/
Ashura313 is offline  
Old 09/11/2018, 02:44   #6
 
elite*gold: 0
Join Date: Mar 2018
Posts: 251
Received Thanks: 104
Question hi

Quote:
Originally Posted by Ashura313 View Post
nothing working yet :/
yyou can add me in skype will help you
[DEV]Wan is offline  
Old 09/13/2018, 21:58   #7
 
oldjayy's Avatar
 
elite*gold: 16
Join Date: Jun 2011
Posts: 63
Received Thanks: 159
Just enable identity for RowID and that’s it.
oldjayy is offline  
Thanks
2 Users
Old 09/14/2018, 01:14   #8
 
elite*gold: 0
Join Date: Jul 2017
Posts: 39
Received Thanks: 1
#Fixed thanks to @.
Ashura313 is offline  
Reply


Similar Threads Similar Threads
help my server 5.4 connection error buy in itemmall
06/25/2018 - Shaiya PServer Development - 4 Replies
:mad::mad::mad::mad: pls help is server
Itemmall Error for SQL Server 2012
12/25/2017 - Shaiya PServer Development - 1 Replies
Hi Epvp , i use SQL Server 2012 and EP 5.4 Serverfiles i try shen1l and cups itemmal fix files and don't work when select character and start game button dc & ps_game drop this is my logs
I curse ITEMMALL, I hate ITEMMALL, I'll burn ITEMMALL [calm down szokersonik]
02/19/2016 - SRO Private Server - 7 Replies
Hey Fellas! As You can see my patient is over, ITEMALL ruined it. I dont fcking get it, no matter wich one(item), no matter how, if i add any new ITEM to itemmall im getting DC all time when im trying to buy it(with any other items old, existed in itemmall i dont have any problems, i can buy'em easily). IF i add exacly the same item using the same rule to NPC shop i dont have any problems, so wth is wrong with that ITEMMALL? Okay:
[HELP] Itemmall crash game Error 0
11/11/2015 - Shaiya PServer Development - 12 Replies
Hi all, i need help please .. I have edit my cash.Sdata et item.Sdata i have make a event, no problem, players can play, and now when i buy on the itemmall i have that error : connection with server has been disconnected ERROR 0, help me please i have delete and restart download in my database and i have the problem, i use SQL 2005 and i can't use 2008 R2 or 2012 ... I can't play and my players wait me :( I have test service.msc and i have error too .. Please help me ! :(
Help Itemmall error
02/01/2014 - Shaiya PServer Development - 3 Replies
When i buy an item from the item mall i get this error "Please try to reconnect to the server ERROR 1" and i executed the Item.sql and Cash.sql idk why i'm getting this error please help.



All times are GMT +1. The time now is 16:12.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.