SQL Errors..?

[Guest Tessera]

Been getting this error fairly often as of late:

 

mySQL query error: SELECT COUNT(reward) AS rewards FROM ibf_rewards WHERE reward_member_id=

 

SQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

SQL error code:

Date: Saturday 03rd of February 2007 04:32:11 AM

 

Seems to be connected with your files area.

 

 

- Tessera -

[Dark0ne]

On what page?

[Jitansgate]

I have also been getting this SQL Error aswell and it happens on every page even when I'm trying to access the Forums or simply while trying to Post a Response to a Topic. Edited December 9, 2012 by Jitansgate

[AwfulArchdemon]

I've been trying all day to log on to my favorite site (I'm doing work there), and I get this message:

 

SQL Error

An error occured with the SQL server:

This is not a problem with the IPS Community Suite but rather with your SQL server. Please contact your host and copy the message shown above.

← Return to the index
**************************************************************************************************************************************************************

This happened before, but I was given the option to return to an earlier session (date) and read earlier posts. When that happened, I started browsing the site, and I realized that I was suddenly viewing new material. The problem was then fixed, until now.

 

I have gotten no option to return to an earlier session this time, and downloading Microsoft SQL Server 2012 changed nothing, so I immediately uninstalled it. Using the "start" menu, I attempted to restore my computer to an earlier date (before my latest Windows update, on May 28th, and I tried May 21st), but I recieved an "unspecific error" that made them both fail. No other browsers let me visit the site, as all give the same exact SQL Error.

I have searched a lot of FAQ forums, but none seem to give an answer. They all give answers to SQL Errors with numers and descriptions, but my error displays neither. Can my computer solve this problem on it's own, or do I need to download an program? I do not wish to install anything else on my computer, but if it's the only way to solve this problem once and for all, then so be it.

I use an Alienware i-7 X51

6 G Ram

1 Terra harddrive

Windows 7

I use the programs that were already installed on my computer, meaning Windows 7 was already there, and I have altered it in no way, aside from standard updates.

I have attempted to view the site using IE, Google, and Bing. All give the same error.

I checked, and the site is up and running, and it is under no maintainance at the time.

[DrakeTheDragon]

Oh, no, no, this is a server-side error with 'their' SQL-Server! Nothing you do on 'your' computer can affect or fix this in any way!

 

This line "but rather with 'your' SQL server" is very misleading, if it really made you think 'you' could do anything against this on your computer (the 'client'), while it clearly is a 'server'-side issue only!

 

These errors happen rather frequently at times, and they usually go away as quickly as they showed up. It can be caused by anything going wonky on the server, from a misconfiguration, or a died process, to simply too many simultaneous connections to the site, while each of them also opens another connection to the site's SQL server, and there simply is a 'limit' how many simultaneous connections an SQL server will allow until any such request dies with an error, which is exactly what the site ran into there and told you about. This has nothing to do with your computer, browser, or anything else on 'your' end. And nothing you could possibly do, apart from retrying later, can fix it.

 

Everything 'SQL' happens only between the 'web'-server and the SQL-server. Neither your PC nor your browser is even remotely involved in this process.

No content management system (like the IP.Board forum software) will ever allow a 'client' (PC, browser, mobile app, etc.) to directly access their SQL-server. That's far too unsafe, insecure and dirty. It is strictly limited to only take place between web-server (where the site is hosted) and SQL-server (where the database is). They can be physically the same machine, of course, but your PC (as the browsing client) will never be a part of this.

Edited June 3, 2013 by DrakeTheDragon

[AwfulArchdemon]

Great. That certainly sucks. I've been getting that error since I woke up today. Oh well, that's life. Thanks anyway, DrakeTheDragon. Time will have to heal this wound I guess. Looks like there's no way to mark THIS problem solved... :(