Log in

No account? Create an account
.::.::...... ..

May 2019
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31

Aerden [userpic]
Spreading Error - Need IT Help!

All--I am unable to gain access to the Star Trek RPG I'm in. When I try to access the site, I get the following error message:

A Database Error Occurred

Error Number: 1064

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 4

SELECT COUNT(*) AS `numrows` FROM (`nova_posts`) WHERE `post_status` = 'saved' AND (post_authors LIKE '%,' OR post_authors LIKE ',%' OR post_authors = '%,,%' OR post_authors = )

I understand what it's saying, I think. I think it's saying that there's a parsing error in line four of the MySQL code. But I don't know how to access this code on my computer or anything related to it.

Most disturbing is that this error seems to be spreading--I can access less of the site than I could a couple of days ago--and the problem seems to be with my computer, as I can access the site fine from work. Unfortunately, I can't write RPG posts at work.

Can anyone help?

I spoke with the CO of my RPG, and he says the site has been optimized to work with Firefox, which is what I'm running. I've run adware detection software, and it sees nothing.

Current Mood: Hellllp! Please?

Does it happen with any other site, or just that one? I guess it could be a virus, but I'm not exactly a computer expert. You may want to run anti-virus software, just in case.

Ardys--So far, it's only preventing access to the RPGResource.net site and the NOVA forums which are associated with that domain. It concerns me that the RPG Resource site has become increasingly inaccessible, and I'm worried about this problem spreading to other sites I visit. But I'll see if I can go there in IE. I did run Symantec, which found nothing.


Have you tried accessing the site in IE from your home computer? There are some sites that, even if they've been optimized to work with Firefox, simply don't, or don't work as well as they do with IE.

Anna--I'll give IE a try. Maybe that will help. I've run Symantec anti-virus, and it hasn't found anything, but I know my computer has been repeatedly attacked by the Trojan.Gen.2 virus over the last few days, according to Symantec's risk logs. I wish I knew where that was coming from, so I could avoid whatever site puts it out.


Edited at 2011-01-05 12:54 am (UTC)

have you tried uninstalling your firefox and reinstalling it?

Chris--No, I haven't, but I'll give that a shot. Thanks!


Did you ever figure this out?

A 1064 is, IIRC, a version mismatch error and, unless you're programming in mySQL, probably has nothing to do with your computer. My money's on your access company having compatibility issues.

Dave--It isn't truly resolved, but it was resolved for the site I was concerned about. I did encounter the same MySQL issue on another site when I tried to post a comment to someone's blog.

And you're right, I'm definitely not programming in MySQL. Thanks for giving me some insight as to what might be wrong.

Say, have you talked to Charles about Evilness at StarRise? He's on Facebook as Charles William. Syris might blow up a prominent Weyr. Intrigued?