|
![]()
Does anybody know how to fix this problem? I have just moved to a different hosting and I have exported the old sql database from the old site and imported to the new. The site seems to be working OK apart from when you click on a game, you get this error message:-
SQL Error:
Query: SELECT * FROM games WHERE cat=\'Other\' AND id!=\'47\' ORDER BY RAND() DESC LIMIT 0, 5
http://www.arcadevoyage.com/index.php?pa...
Any ideas please.
SQL Error on a game Arcade Website?
Not really sure why it wouldn't work on a new sql server. Is the RAND function supported by the new server. What version of sql did you move to and from?
What happens when you remove the order by RAND function and create the simplest query. You can remove the RAND function and still get randomness ... check this site...
http://www.titov.net/2005/09/21/do-not-u...
SQL Error on a game Arcade Website?
It is probably something wrong with their database server. Report the error to the site admin so it can be fixed.
Good luck.
SQL Error on a game Arcade Website?
maybe the db is out of order... are you the designer/webmaster of the site? if not, i think there's nothing you can do about it.
|
