[rs] Remote Scheduling v1

Indeed; I don't seem to have had an email since Monday (and I deliberately have a collection of broken recordings).
 
The new links on the schedule email work perfectly thanks.

I did notice that +"war" produced no results though (there is a film called war on 5 usa) I'm assuming there is a lower limit on the lenght of an exact match search? No bother.

Great work!

Sent from my GT-N7100
 
Black Hole said:
Indeed; I don't seem to have had an email since Monday (and I deliberately have a collection of broken recordings).
Click to expand...
Do you remember the last rs version that worked? How would one install that version?
Did anyone else have failed recording with Secrets of British sharia councils on 8 April 20.30?

Edit:
I just received an email. What are the chances? It looks like sthing was fixed now because the failed recording was 4 days ago and no emails.
 
Kev_w said:
I did notice that +"war" produced no results though (there is a film called war on 5 usa) I'm assuming there is a lower limit on the lenght of an exact match search? No bother.
Click to expand...

That's fixed now. Yes, there's a lower limit on what is added to the fulltext index (was 4, now 3 but also the system will back down to a substring search if appropriate).

Multi-region RS will be back on-line tomorrow. I have some more testing to do before I re-enable it for everyone but it is looking good again (and still very fast).
 
feature request 2:
Can we have similar links for the failed recording emails? So that if a doctor who recording fails for example it links to a search for doctor who so we can record a repeat.

sent on the move from my Note2
 
Hi,

Not sure if the server is on the blink of its me but I'm receving a long list of MySQL database problems:

Code: 
Using email address: **address removed**
Registering with remote scheduling server.
 
>>> Found existing account, **address removed**
Sending TBL_RESERVATION schedule information to remote server.
Already up-to-date.
Sending pending schedule information to remote server.
Already up-to-date.
Sending channel information to remote server.
Already up-to-date.
+ Negotiating EPG transfer for net 12320 (Cambs & Beds)
- Wants service 4173 (>1), 206 entries found.
- Wants service 4287 (>1), 182 entries found.
- Wants service 4288 (>1), 141 entries found.
- Wants service 4352 (>1), 326 entries found.
- Wants service 4416 (>1), 0 entries found.
- Wants service 4544 (>1), 107 entries found.
- Wants service 4608 (>1), 252 entries found.
- Wants service 4672 (>1), 482 entries found.
- Wants service 4736 (>1), 112 entries found.
- Wants service 5632 (>1), 106 entries found.
- Wants service 5696 (>1), 36 entries found.
- Wants service 5760 (>1), 94 entries found.
- Wants service 5824 (>1), 348 entries found.
- Wants service 5888 (>1), 85 entries found.
- Wants service 5952 (>1), 63 entries found.
- Wants service 6016 (>1), 509 entries found.
- Wants service 6720 (>1), 97 entries found.
- Wants service 6784 (>1), 98 entries found.
- Wants service 6848 (>1), 105 entries found.
- Wants service 6912 (>1), 349 entries found.
- Wants service 7168 (>1), 42 entries found.
- Wants service 7232 (>1), 32 entries found.
- Wants service 8258 (>1), 223 entries found.
- Wants service 8325 (>1), 189 entries found.
- Wants service 8357 (>1), 224 entries found.
- Wants service 8384 (>1), 256 entries found.
- Wants service 8442 (>1), 169 entries found.
- Wants service 8448 (>1), 284 entries found.
- Wants service 8452 (>1), 255 entries found.
- Wants service 8500 (>1), 376 entries found.
- Wants service 8577 (>1), 0 entries found.
- Wants service 8646 (>1), 0 entries found.
- Wants service 12928 (>1), 233 entries found.
- Wants service 12992 (>1), 245 entries found.
- Wants service 13024 (>1), 380 entries found.
- Wants service 13120 (>1), 179 entries found.
- Wants service 14272 (>1), 92 entries found.
- Wants service 14372 (>1), 78 entries found.
- Wants service 14498 (>1), 276 entries found.
- Wants service 14532 (>1), 32 entries found.
- Wants service 14544 (>1), 24 entries found.
- Wants service 14688 (>1), 55 entries found.
- Wants service 14720 (>1), 66 entries found.
- Wants service 14752 (>1), 65 entries found.
- Wants service 14784 (>1), 48 entries found.
- Wants service 14800 (>1), 66 entries found.
- Wants service 14816 (>1), 56 entries found.
- Wants service 14832 (>1), 66 entries found.
- Wants service 14864 (>1), 0 entries found.
- Wants service 14912 (>1), 96 entries found.
- Wants service 14928 (>1), 96 entries found.
- Wants service 14944 (>1), 96 entries found.
- Wants service 14976 (>1), 10 entries found.
- Wants service 15056 (>1), 0 entries found.
- Wants service 15072 (>1), 227 entries found.
- Wants service 15088 (>1), 96 entries found.
- Wants service 15136 (>1), 8 entries found.
- Wants service 15152 (>1), 0 entries found.
- Wants service 15200 (>1), 0 entries found.
- Wants service 15232 (>1), 106 entries found.
- Wants service 15504 (>1), 0 entries found.
- Wants service 15552 (>1), 32 entries found.
- Wants service 15792 (>1), 0 entries found.
- Wants service 15952 (>1), 188 entries found.
- Wants service 16032 (>1), 339 entries found.
- Wants service 16048 (>1), 168 entries found.
- Wants service 16096 (>1), 131 entries found.
- Wants service 16144 (>1), 16 entries found.
- Wants service 16176 (>1), 227 entries found.
- Wants service 16224 (>1), 23 entries found.
- Wants service 16288 (>1), 22 entries found.
- Wants service 16292 (>1), 22 entries found.
- Wants service 16300 (>1), 8 entries found.
- Wants service 17472 (>1), 182 entries found.
- Wants service 17540 (>1), 208 entries found.
- Wants service 17603 (>1), 223 entries found.
- Wants service 17664 (>1), 256 entries found.
- Wants service 19648 (>1), 32 entries found.
- Wants service 20288 (>1), 26 entries found.
- Wants service 22080 (>1), 384 entries found.
- Wants service 22208 (>1), 270 entries found.
- Wants service 22226 (>1), 255 entries found.
- Wants service 22272 (>1), 234 entries found.
- Wants service 22336 (>1), 283 entries found.
- Wants service 22400 (>1), 24 entries found.
- Wants service 22464 (>1), 56 entries found.
- Wants service 22592 (>1), 58 entries found.
- Wants service 23040 (>1), 324 entries found.
- Wants service 23120 (>1), 0 entries found.
- Wants service 23184 (>1), 0 entries found.
- Wants service 23680 (>1), 32 entries found.
- Wants service 23712 (>1), 197 entries found.
- Wants service 23872 (>1), 0 entries found.
- Wants service 23904 (>1), 24 entries found.
- Wants service 23936 (>1), 0 entries found.
- Wants service 24032 (>1), 130 entries found.
- Wants service 24064 (>1), 112 entries found.
- Wants service 24128 (>1), 16 entries found.
- Wants service 24256 (>1), 24 entries found.
- Wants service 24288 (>1), 0 entries found.
- Wants service 24384 (>1), 131 entries found.
- Wants service 24448 (>1), 167 entries found.
- Wants service 24512 (>1), 0 entries found.
- Wants service 25664 (>1), 161 entries found.
- Wants service 25728 (>1), 205 entries found.
- Wants service 25792 (>1), 181 entries found.
- Wants service 25920 (>1), 159 entries found.
- Wants service 26176 (>1), 91 entries found.
- Wants service 26240 (>1), 63 entries found.
- Wants service 26304 (>1), 57 entries found.
- Wants service 26368 (>1), 52 entries found.
- Wants service 26560 (>1), 75 entries found.
- Wants service 26624 (>1), 59 entries found.
- Wants service 26688 (>1), 50 entries found.
- Wants service 27040 (>1), 25 entries found.
- Wants service 27136 (>1), 85 entries found.
- Wants service 27168 (>1), 194 entries found.
- Wants service 27232 (>1), 149 entries found.
- Wants service 27296 (>1), 155 entries found.
- Wants service 27456 (>1), 371 entries found.
- Wants service 27520 (>1), 16 entries found.
- Wants service 27584 (>1), 0 entries found.
- Wants service 27712 (>1), 296 entries found.
- Wants service 27808 (>1), 65 entries found.
- Wants service 27840 (>1), 146 entries found.
- Wants service 27904 (>1), 24 entries found.
- Wants service 27936 (>1), 0 entries found.
- Wants service 28032 (>1), 135 entries found.
- Wants service 28160 (>1), 261 entries found.
- Wants service 28224 (>1), 0 entries found.
- Wants service 28288 (>1), 48 entries found.
- Wants service 28320 (>1), 96 entries found.
- Wants service 28352 (>1), 352 entries found.
- Wants service 28384 (>1), 188 entries found.
- Wants service 28416 (>1), 130 entries found.
+ Prepared 17157 entries, 5867955 bytes.
- Compressing...Done, saved 83.96%
+ Transmitting 941223 bytes.
>>> Received 941223 bytes.
>>> Uncompressing received data...
>>> Done, restored 5867955 bytes.
 
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 'where service_id = 4173
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/4173, 188 events.
 
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 'where service_id = 4287
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/4287, 169 events.
 
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 'where service_id = 4288
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/4288, 131 events.
 
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 'where service_id = 4352
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/4352, 296 events.
 
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 'where service_id = 4544
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/4544, 100 events.
 
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 'where service_id = 4608
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/4608, 223 events.
 
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 'where service_id = 4672
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/4672, 420 events.
 
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 'where service_id = 4736
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/4736, 95 events.
 
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 'where service_id = 5632
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/5632, 93 events.
 
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 'where service_id = 5696
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/5696, 33 events.
 
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 'where service_id = 5760
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/5760, 84 events.
 
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 'where service_id = 5824
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/5824, 319 events.
 
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 'where service_id = 5888
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/5888, 77 events.
 
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 'where service_id = 5952
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/5952, 58 events.
 
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 'where service_id = 6016
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/6016, 459 events.
 
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 'where service_id = 6720
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/6720, 89 events.
 
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 'where service_id = 6784
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/6784, 89 events.
 
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 'where service_id = 6848
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/6848, 95 events.
 
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 'where service_id = 6912
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/6912, 311 events.
 
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 'where service_id = 7168
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/7168, 39 events.
 
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 'where service_id = 7232
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/7232, 29 events.
 
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 'where service_id = 8258
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/8258, 196 events.
 
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 'where service_id = 8325
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/8325, 175 events.
 
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 'where service_id = 8357
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/8357, 196 events.
 
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 'where service_id = 8384
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/8384, 235 events.
 
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 'where service_id = 8442
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/8442, 147 events.
 
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 'where service_id = 8448
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/8448, 261 events.
 
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 'where service_id = 8452
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/8452, 235 events.
 
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 'where service_id = 8500
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/8500, 337 events.
 
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 'where service_id = 12928
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/12928, 211 events.
 
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 'where service_id = 12992
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/12992, 223 events.
 
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 'where service_id = 13024
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/13024, 336 events.
 
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 'where service_id = 13120
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/13120, 160 events.
 
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 'where service_id = 14272
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/14272, 83 events.
 
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 'where service_id = 14372
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/14372, 72 events.
 
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 'where service_id = 14498
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/14498, 245 events.
 
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 'where service_id = 14532
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/14532, 29 events.
 
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 'where service_id = 14544
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/14544, 21 events.
 
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 'where service_id = 14688
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/14688, 49 events.
 
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 'where service_id = 14720
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/14720, 60 events.
 
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 'where service_id = 14752
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/14752, 59 events.
 
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 'where service_id = 14784
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/14784, 43 events.
 
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 'where service_id = 14800
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/14800, 60 events.
 
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 'where service_id = 14816
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/14816, 51 events.
 
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 'where service_id = 14832
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/14832, 60 events.
 
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 'where service_id = 14912
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/14912, 87 events.
 
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 'where service_id = 14928
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/14928, 87 events.
 
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 'where service_id = 14944
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/14944, 87 events.
 
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 'where service_id = 14976
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/14976, 9 events.
 
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 'where service_id = 15072
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/15072, 210 events.
 
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 'where service_id = 15088
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/15088, 87 events.
 
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 'where service_id = 15136
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/15136, 8 events.
 
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 'where service_id = 15232
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/15232, 95 events.
 
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 'where service_id = 15552
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/15552, 31 events.
 
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 'where service_id = 15952
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/15952, 174 events.
 
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 'where service_id = 16032
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/16032, 300 events.
 
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 'where service_id = 16048
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/16048, 154 events.
 
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 'where service_id = 16096
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/16096, 121 events.
 
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 'where service_id = 16144
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/16144, 14 events.
 
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 'where service_id = 16176
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/16176, 206 events.
 
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 'where service_id = 16224
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/16224, 22 events.
 
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 'where service_id = 16288
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/16288, 20 events.
 
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 'where service_id = 16292
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/16292, 20 events.
 
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 'where service_id = 16300
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/16300, 7 events.
 
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 'where service_id = 17472
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/17472, 169 events.
 
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 'where service_id = 17540
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/17540, 190 events.
 
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 'where service_id = 17603
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/17603, 196 events.
 
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 'where service_id = 17664
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/17664, 235 events.
 
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 'where service_id = 19648
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/19648, 29 events.
 
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 'where service_id = 20288
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/20288, 26 events.
 
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 'where service_id = 22080
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/22080, 346 events.
 
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 'where service_id = 22208
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/22208, 239 events.
 
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 'where service_id = 22226
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/22226, 229 events.
 
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 'where service_id = 22272
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/22272, 212 events.
 
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 'where service_id = 22336
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/22336, 259 events.
 
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 'where service_id = 22400
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/22400, 22 events.
 
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 'where service_id = 22464
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/22464, 50 events.
 
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 'where service_id = 22592
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/22592, 53 events.
 
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 'where service_id = 23040
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/23040, 297 events.
 
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 'where service_id = 23680
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/23680, 29 events.
 
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 'where service_id = 23712
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/23712, 177 events.
 
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 'where service_id = 23904
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/23904, 22 events.
 
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 'where service_id = 24032
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/24032, 116 events.
 
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 'where service_id = 24064
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/24064, 101 events.
 
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 'where service_id = 24128
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/24128, 14 events.
 
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 'where service_id = 24256
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/24256, 22 events.
 
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 'where service_id = 24384
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/24384, 117 events.
 
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 'where service_id = 24448
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/24448, 151 events.
 
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 'where service_id = 25664
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/25664, 152 events.
 
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 'where service_id = 25728
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/25728, 193 events.
 
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 'where service_id = 25792
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/25792, 168 events.
 
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 'where service_id = 25920
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/25920, 144 events.
 
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 'where service_id = 26176
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/26176, 80 events.
 
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 'where service_id = 26240
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/26240, 56 events.
 
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 'where service_id = 26304
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/26304, 51 events.
 
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 'where service_id = 26368
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/26368, 47 events.
 
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 'where service_id = 26560
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/26560, 66 events.
 
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 'where service_id = 26624
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/26624, 53 events.
 
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 'where service_id = 26688
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/26688, 47 events.
 
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 'where service_id = 27040
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/27040, 22 events.
 
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 'where service_id = 27136
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/27136, 75 events.
 
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 'where service_id = 27168
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/27168, 172 events.
 
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 'where service_id = 27232
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/27232, 137 events.
 
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 'where service_id = 27296
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/27296, 142 events.
 
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 'where service_id = 27456
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/27456, 333 events.
 
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 'where service_id = 27520
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/27520, 15 events.
 
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 'where service_id = 27712
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/27712, 266 events.
 
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 'where service_id = 27808
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/27808, 60 events.
 
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 'where service_id = 27840
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/27840, 132 events.
 
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 'where service_id = 27904
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/27904, 23 events.
 
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 'where service_id = 28032
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/28032, 124 events.
 
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 'where service_id = 28160
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/28160, 233 events.
 
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 'where service_id = 28288
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/28288, 42 events.
 
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 'where service_id = 28320
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/28320, 87 events.
 
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 'where service_id = 28352
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/28352, 315 events.
 
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 'where service_id = 28384
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/28384, 172 events.
 
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 'where service_id = 28416
 
group by 1,2,3' at line 4
 
>>> Imported service ID 12320/28416, 120 events.
 
jdtaylor said:
Hi,

Not sure if the server is on the blink of its me but I'm receving a long list of MySQL database problems:
Click to expand...

Thanks - fixed now. It would have been causing data to be uploaded more often than necessary but shouldn't have caused any problems.
 
Hi,
Newbie here running CF 2.16.
In rs settings I can't select an EPG favourites group, the only option is "None". Also the Auto search restricts me to "Any" channel.
The full EPG correctly reflects my edited channel list and the region is correct.
My Humax is checking in regularly with the rs server.
 
I would force your Humax to refresh the data held on the RS server with Web-If >> Diagnostics >> chanpush and diskpush Notes HERE
 
Thanks but I'd already tried chanpush and diskpush. They both end with "already up to date". I've just run them again to confirm it's made no difference.
 
Although schedule information seems to be updating correctly, the rs portal is showing that the disk information has not updated since I did the last manual diskpush on Monday. It would seem that the automated diskpush is not happening. When does it normally happen, presumably it is different from when the schedule is pushed? I am wondering if it is an overnight thing, which would not work for me as I always turn my modem off overnight.
 
Disk contents is usually updated during the 4:30am Humax wake-up to look for OTA info. e.g. 02/05/2013 04:35:09 Updated disk contents. if this is the first time the Humax has been out of stand-by since Midnight, or some time between Midnight and 4:30am if the Humax is awake
 
Thanks, I think that helps...
Just looked at /mod/etc/anacrontab and found what appears to be scheduled overnight pushes. However, I wasn't sure if anacron would wake the Humax; from what you say, it can't.
So it looks to me as though I just need to change the time of the anacronjob to a time of day when my modem will be on. I will give it a try.
 
hairy_mutley said:
So it looks to me as though I just need to change the time of the anacronjob to a time of day when my modem will be on. I will give it a try.
Click to expand...

Unfortunately that won't work : (
Things scheduled through anacron are just supposed to run once per day (or once per X days). They will usually run on the first boot of the day which for a lot of people is around 04:30. The cron job that runs anacron is just there to catch anyone who leaves their box on all the time.

You could just add a disk push to every startup by creating a file in /mod/etc/init.d/ on your Humax.
 
Maybe, maybe not... but I am trying the anacron option START_HOURS_RANGE=06-23, since if it turns on between 06:00 and 23:00, the modem will normally be on. See what happens. If it doesn't then I will look at the init.d option. Thanks
 
A problem in both rs and web-if.
I just tried to set recording of next weekend's F1 practice sessions as a series (starts Fri 08:55) on rs.
However, after the reboot the rs log says !Error encountered whilst scheduling: Duplicate reservation. and it wasn't added to the schedule.
OK, lets try the web-if... find the first practice session and select series record, but the same error is reported by the web-if.
Finally, do it on the box... no problem.
Any suggestions as to the problem or any useful diagnostics that could be obtained?

By the way, took af123's suggestion (thanks) and have added the push disk to the init.d.
Have left the START_HOURS_RANGE in anacron as it will be more appropriate for the other scheduled tasks to run when the modem is more likely to be on.
(actually, not sure whether it is working, maybe not supported by this version of anacron?)
 
You must log in or register to reply here.
Back
Top