Quantcast

Jump to content


Photo

Sql Probs :(


  • This topic is locked This topic is locked
24 replies to this topic

#1 Ashaide

Ashaide
  • 4621 posts

Posted 14 June 2005 - 08:09 AM

It's not just me.. Neisha and Star and me get this error

mySQL query error: SELECT count(mt_id) as total FROM ibf_message_topics WHERE mt_to_id= AND mt_owner_id= AND mt_read!=1

mySQL 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 'AND mt_owner_id= AND mt_read!=1' at line 1
mySQL error code:
Date: Tuesday 14th of June 2005 12:05:53 PM

#2 Bahbuu

Bahbuu
  • 2028 posts

Posted 14 June 2005 - 08:17 AM

same thing is happening to me~

seems like it has stopped.....

#3 redlion

redlion
  • I don't exist!

  • 12072 posts


Users Awards

Posted 14 June 2005 - 08:21 AM

Happening more and more for me... :(

#4 Ashaide

Ashaide
  • 4621 posts

Posted 14 June 2005 - 08:25 AM

I can't even comment on anything or view my posts... keeps coming up.. :(

#5 Guest_Rambo_*

Guest_Rambo_*

Posted 14 June 2005 - 08:50 AM

All works correctly now.

#6 Ashaide

Ashaide
  • 4621 posts

Posted 14 June 2005 - 08:52 AM

Still comes up.. Why is it doing it?

#7 Icey Defeat

Icey Defeat
  • 8298 posts


Users Awards

Posted 14 June 2005 - 08:58 AM

Works for me... 0_o

#8 Typhoon

Typhoon
  • 4133 posts

Posted 14 June 2005 - 09:02 AM

It's fine now.

#9 Mumei

Mumei
  • 3545 posts

Posted 15 June 2005 - 08:17 AM

mySQL query error: SELECT count(mt_id) as total FROM ibf_message_topics WHERE mt_to_id= AND mt_owner_id= AND mt_read!=1

mySQL 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 'AND mt_owner_id= AND mt_read!=1' at line 1
mySQL error code:
Date: Wednesday 15th of June 2005 12:16:24 PM

this is still happening (just had 3 occurances of it)

#10 Gargar

Gargar
  • 4901 posts

Posted 15 June 2005 - 08:22 AM

I still get it alot.

#11 redlion

redlion
  • I don't exist!

  • 12072 posts


Users Awards

Posted 15 June 2005 - 08:57 AM

Get it HELLA lot. Just had a about of at least 25 attempts to access a codex page, each one got the MySQL error.

#12 Dark_Sniper

Dark_Sniper
  • 1726 posts

Posted 15 June 2005 - 08:58 AM

yeah im getting it a lot now

#13 Ashaide

Ashaide
  • 4621 posts

Posted 15 June 2005 - 08:59 AM

Tis driving me crazy lol.. keeps happening now, no matter how many times you refresh the page

#14 SteWieH

SteWieH
  • 3423 posts

Posted 15 June 2005 - 08:59 AM

Well what happens it something happens so the admisn need to refresh something in the admin box to fix it. so we have tow ait for a codex admint o login before it goes away

#15 Guest_Rambo_*

Guest_Rambo_*

Posted 15 June 2005 - 09:02 AM

Is happening rarely but becoming more common for me now. Maybe theres a bug in the mysql databas.e

#16 Mumei

Mumei
  • 3545 posts

Posted 15 June 2005 - 01:26 PM

to be fair - I've not looked into it - but the query looks like it's not being fully populated

"SELECT count(mt_id) as total FROM ibf_message_topics WHERE mt_to_id= AND mt_owner_id= AND mt_read!=1"

I would expect the 2 IDs to have some value, I don't know why that could happen sometimes not others - but maybe I'm totally wrong (I've not read the IPB code yet LOL)

#17 Axy

Axy
  • 431 posts

Posted 15 June 2005 - 04:32 PM

it happened for me only when I refreshed right after the michael jakson verdict had been announced.

Thats when I got the sql error

#18 Hydrogen

Hydrogen
  • Neocodex Co-Founder

  • 22213 posts


Users Awards

Posted 15 June 2005 - 06:53 PM

I dont get it too much...can you guys tell me where exactly you do get it?

#19 Hydrogen

Hydrogen
  • Neocodex Co-Founder

  • 22213 posts


Users Awards

Posted 15 June 2005 - 07:07 PM

does the error go away just by refreshing?

#20 Blazin

Blazin
  • 2201 posts

Posted 15 June 2005 - 07:09 PM

It's been happening all throughout the week. I do believe it started to get horrible this morning, though for now it seems to have been tamed, then again, who knows. It mainly happens to me around the Digital Camera Game section, though from today, just loading the home page of Neocodex.us proved problem. Queries are in co-opertaion with bandwidth correct? *Know's nothing of anything technological :mellow: *


Only sometimes does it cease when refreshing. . . Or atleast or me.

#21 Mumei

Mumei
  • 3545 posts

Posted 16 June 2005 - 12:40 AM

yes - refreshing does make it go away (altho not always the first time)

#22 Hydrogen

Hydrogen
  • Neocodex Co-Founder

  • 22213 posts


Users Awards

Posted 16 June 2005 - 12:41 AM

yes - refreshing does make it go away (altho not always the first time)

View Post

thats weird...its the most erratic error I have ever seen :unsure:   :unsure:

#23 Brad

Brad
  • How about a magic trick?

  • 4565 posts

Posted 16 June 2005 - 04:17 AM

yes - refreshing does make it go away (altho not always the first time)

View Post


yesterday it took like 5 minutes of refreshing while I was at school. <_<

#24 Axy

Axy
  • 431 posts

Posted 16 June 2005 - 12:47 PM

just happened again

mySQL query error: SELECT count(mt_id) as total FROM ibf_message_topics WHERE mt_to_id= AND mt_owner_id= AND mt_read!=1

mySQL 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 'AND mt_owner_id= AND mt_read!=1' at line 1
mySQL error code:
Date: Thursday 16th of June 2005 04:35:00 PM

#25 Hydrogen

Hydrogen
  • Neocodex Co-Founder

  • 22213 posts


Users Awards

Posted 16 June 2005 - 12:52 PM

Im getting it now too. Im not sure what caused it but ill look into it.

Problem seems to be solved as this is very old and no one has reported it in some time. Closed.


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users