• Effective immediately we will be deleting, without notice, any negative threads or posts that deal with the use of encryption and streaming of scanner audio.

    We've noticed a huge increase in rants and negative posts that revolve around agencies going to encryption due to the broadcasting of scanner audio on the internet. It's now worn out and continues to be the same recycled rants. These rants hijack the threads and derail the conversation. They no longer have a place anywhere on this forum other than in the designated threads in the Rants forum in the Tavern.

    If you violate these guidelines your post will be deleted without notice and an infraction will be issued. We are not against discussion of this issue. You just need to do it in the right place. For example:
    https://forums.radioreference.com/rants/224104-official-thread-live-audio-feeds-scanners-wait-encryption.html

SQL query error

Status
Not open for further replies.

w2xq

Mentor
Joined
Jul 13, 2004
Messages
1,876
Location
Burlington County, NJ
I was searching in NJ/Burlington for only Expired and Cancelled licenses, and an SQL error message popped up. Hope this helps.

"error on FCC Count Query-> AND EN.entity_name NOT REGEXP "New Jersey, STATE OF" AND EN.entity_name NOT REGEXP "New Jersey STATE OF" AND () AND FR.class_station_code NOT IN ("MO","MO2","MO3","MO8") AND (FR.frequency_assigned < "806.0000" OR FR.frequency_assigned > "851.0000")
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 FR.class_station_code NOT IN ("MO","MO2","MO3","MO8") AND (FR.' at line 12"
 

Cloydlane

Newbie
Joined
Sep 27, 2011
Messages
2
U should go through ur new MySql server version manual..there might be change in the syntax of count function..
 
Status
Not open for further replies.
Top