Register for your free account! | Forgot your password?

You last visited: Today at 00:27

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

Advertisement



Any idea to fix this issue?

Discussion on Any idea to fix this issue? within the Shaiya PServer Development forum part of the Shaiya Private Server category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Feb 2013
Posts: 63
Received Thanks: 44
Question Any idea to fix this issue?

Error 701 There is insufficient system memory to run this query? never dealt with this before. even researched how to fix it yet the answers given did nothing... Notice this is occuring when i inject any item.sql from item.sdatas.
\(^O^)/ is offline  
Old 05/04/2013, 23:01   #2
 
elite*gold: 0
Join Date: Mar 2013
Posts: 113
Received Thanks: 121
Can you post the whole SQL error thingy?
Nubness's-Son is offline  
Old 05/04/2013, 23:08   #3
 
elite*gold: 0
Join Date: Feb 2013
Posts: 63
Received Thanks: 44
Quote:
Originally Posted by Nubness's-Son View Post
Can you post the whole SQL error thingy?
Quote:
Originally Posted by \(^O^)/ View Post
Error 701 There is insufficient system memory to run this query
Sadly i have already that was the issue right there in the first sentence yet alone that when i check the data that has been executed it's blank..
\(^O^)/ is offline  
Old 05/05/2013, 00:39   #4
 
TeddyBear94's Avatar
 
elite*gold: 10
Join Date: May 2012
Posts: 1,857
Received Thanks: 2,632
Quote:
Originally Posted by \(^O^)/ View Post
Error 701 There is insufficient system memory to run this query
uhm sry am im the only one that sees the full error in the error report? <.<
obviously ur ram of u pc/vps is not big enough to handle the situation. U would need atleast 2gb ram to run sql propper.
TeddyBear94 is offline  
Old 05/05/2013, 00:46   #5
 
elite*gold: 0
Join Date: Feb 2013
Posts: 63
Received Thanks: 44
Quote:
Originally Posted by TeddyBear94 View Post
uhm sry am im the only one that sees the full error in the error report? <.<
obviously ur ram of u pc/vps is not big enough to handle the situation. U would need atleast 2gb ram to run sql propper.
Sadly it has 3gb of ram and page file has 3gb also.. that is what i do not understand...
\(^O^)/ is offline  
Old 05/05/2013, 00:57   #6
 
elite*gold: 0
Join Date: Mar 2013
Posts: 113
Received Thanks: 121
You'r SQL cant run on that PC/Host... so yeah ^_^
Nubness's-Son is offline  
Old 05/05/2013, 01:00   #7
 
elite*gold: 0
Join Date: Feb 2013
Posts: 63
Received Thanks: 44
Quote:
Originally Posted by Nubness's-Son View Post
You'r SQL cant run on that PC/Host... so yeah ^_^
Sadly enough it was working perfectly fine, yet out of the blue it is being so werid.. yes it can run on the machine
\(^O^)/ is offline  
Old 05/05/2013, 08:53   #8
 
elite*gold: 0
Join Date: Apr 2010
Posts: 38
Received Thanks: 26
You SQL is not the problem. The problem is a recursive event that is happening in your sql query. Either the stuidio has incerted an unusual character or you have one in the description field. Scroll through your sql query created by the stuido and look for a strange looking character in the text/data fields. It will have a ^ next to some characters. Sometimes this is a tab or control character that was accidently entered. Also you MUST Quote special characters in text fields, ie. /\{}[]:;"()or , and . are special characters and must be "ed.
(recursive event means that your sql statment is recalling it's self untill your memory is exausted)
russell0659 is offline  
Thanks
1 User
Old 05/05/2013, 11:21   #9
 
elite*gold: 0
Join Date: Feb 2013
Posts: 63
Received Thanks: 44
Quote:
Originally Posted by russell0659 View Post
You SQL is not the problem. The problem is a recursive event that is happening in your sql query. Either the stuidio has incerted an unusual character or you have one in the description field. Scroll through your sql query created by the stuido and look for a strange looking character in the text/data fields. It will have a ^ next to some characters. Sometimes this is a tab or control character that was accidently entered. Also you MUST Quote special characters in text fields, ie. /\{}[]:;"()or , and . are special characters and must be "ed.
(recursive event means that your sql statment is recalling it's self untill your memory is exausted)
Thank you so very much your help was actually the thing that helped me fix it thanks sooo much
\(^O^)/ is offline  
Old 05/19/2013, 23:30   #10
 
elite*gold: 0
Join Date: Apr 2013
Posts: 22
Received Thanks: 44
Cool Easy [FIXED]

This error comes up whenever u'r connect to wrong DB location as in if you downloaded SQLEXPR as main on the Service Instance instead of Default Instance, anyways it might also show up if you have SQL Express Service Pack 1 and SSMSE Service pack 2 or 3 you have to check on "Help > About" it will tell you if you have different packs.

easiest way to get the right one:

SQLEXPR (2005/2008/2012) - without the '()' -- First link
SSMSE (2005/2008/2012) - without the '()' -- First link
Shaiya-DreamWorld is offline  
Old 12/07/2013, 13:57   #11
 
elite*gold: 0
Join Date: Nov 2012
Posts: 36
Received Thanks: 4
Just stop Shaiya Server Services . if you have 1G ram free you can run it . happend to me too.
bar2eldad is offline  
Reply


Similar Threads Similar Threads
[Idea]I have an idea about Uri Resselers
05/17/2012 - DarkOrbit - 25 Replies
I have a good idea for uridium resselers. For example they can make an accounts that will be full updated(lf4,havoc..etc) and then sell them to us but in low prices :D How much you agree with me.:handsdown:
New Bypass Idea *IDEA NOT A HACK*
01/19/2009 - Soldier Front - 5 Replies
Think about it..xfire to bypass GameGuard. I dunno about anyone else or why it hasn't been mentioned ..or maybe it has. But let me give you an example of what i mean. You would Inject your "wallhack.dll" into the xfire.exe process. Then Login to xFire.Then login to SF and let your Xfire ingame Load up. Since xfire layers its chat windows over the SF screen freely without causing the ALT+TAB error that means its has some kind of control over the D3D.
Good idea or bad idea?
05/22/2007 - Conquer Online 2 - 4 Replies
I have a water(110)-Trojan(130) but i dont know if i should go to trojan again for 2nd rb or should i rb to water? If i am water(110)-trojan(130)-water(130) how much hp would i have if i went melee and had about 2.4k mana?
Idea:Possibly good potential idea!
10/26/2005 - Conquer Online 2 - 3 Replies
Well today I was thinking and it was stated that it's impossible to view if you have a +1 item unless you look in your inventory, but it is generated before its picked up. This could be a big job, could be worth it if it was possible and done correctly though. Turn the items on the floors into items in your inventory images, I should probably explain a bit more. The images that are used in your inventory, put those on the floor. That way if you moused over the image it'd show the +1...



All times are GMT +1. The time now is 00:27.


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.