[Ql-Users] QL Forum
Anyone else having problems accessing QL Forum? When I try this morning I get the error General Error SQL ERROR [ mysql4 ] Table ‘./qlforum_phpbb/phpbb_sessions’ is marked as crashed and should be repaired [145] An sql error occurred while fetching this page. If Rob or Pete are reading this, perhaps you could take a look to see? Dilwyn Jones ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm
Re: [Ql-Users] QL Forum
On 08/06/12 11:25, Dilwyn Jones wrote: Anyone else having problems accessing QL Forum? Yes, SQL ERROR [ mysql4 ] Table ‘./qlforum_phpbb/phpbb_sessions’ is marked as crashed and should be repaired [145] An sql error occurred while fetching this page. There's a corruption in the phpbb_sessions table that needs to be fixed. If Rob or Pete are reading this, perhaps you could take a look to see? This might help http://community.mybb.com/thread-32115.html where there are instructions on using phpMyAdmin to fix tables in a MySql database. Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm
Re: [Ql-Users] QL Forum
On Fri, Jun 8, 2012 at 5:25 AM, Dilwyn Jones dil...@evans1511.fsnet.co.uk wrote: Anyone else having problems accessing QL Forum? When I try this morning I get the error General Error SQL ERROR [ mysql4 ] Table ‘./qlforum_phpbb/phpbb_sessions’ is marked as crashed and should be repaired [145] An sql error occurred while fetching this page. If Rob or Pete are reading this, perhaps you could take a look to see? Dilwyn Jones I'm getting that too. Looks like they need to fix their database just a little bit. And just when I was about to ask a question that suits the forum, but would get me a pat on the head here! ;) SIDETRACK: The question is: is their a limit on the size of a value that can be handled by DIV? Example: tempsecs=99 --- no problem days=tempsecs DIV 86400 --- overflows if tempsecs=32768 Another oddity I discovered: If I create a REPeat loop thus: 100 Frame=0 : Keypress=0 110 REPEAT loop 120 a$=INKEY$ 130 Frame=Frame+1 140 IF a$ THEN Keypress=Keypress+1 150 AT 0,0 : PRINT Frame, Keypress 160 END REPeat loop ...I reasonably expect that when a key is pressed, the Keypress value will increase in step with the Frame value (every time the loop repeats, a keypress is detected) but no. I can type run, and hold down the enter key, and Frame will increment 55 times for each detected Keypress. It seems INKEY$ is limited to approx 15 keyboard scans/sec. On my original QL, with or without GC, they increment together, 1:1. Q-EmuLator 1.1, JS ROM QL, JSU ROM Just throwing that in here, completely off topic ;) Dave, playing with stuff ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm
Re: [Ql-Users] QL Forum
From: Dilwyn Jones dil...@evans1511.fsnet.co.uk To: QL Users List ql-us...@q-v-d.com Sent: Friday, 8 June 2012, 11:25 Subject: [Ql-Users] QL Forum Anyone else having problems accessing QL Forum? When I try this morning I get the error General Error SQL ERROR [ mysql4 ] Table ‘./qlforum_phpbb/phpbb_sessions’ is marked as crashed and should be repaired [145] An sql error occurred while fetching this page. If Rob or Pete are reading this, perhaps you could take a look to see? Dilwyn Jones ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm Second time it's gone off this week! I'll have a quick look but it might be a job for Rob. It's been up and down like brides nightie! Pete. ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm
Re: [Ql-Users] QL Forum
- Original Message - From: Norman Dunbar nor...@dunbar-it.co.uk To: ql-users@lists.q-v-d.com Cc: Sent: Friday, 8 June 2012, 11:39 Subject: Re: [Ql-Users] QL Forum On 08/06/12 11:25, Dilwyn Jones wrote: Anyone else having problems accessing QL Forum? Yes, SQL ERROR [ mysql4 ] Table ‘./qlforum_phpbb/phpbb_sessions’ is marked as crashed and should be repaired [145] An sql error occurred while fetching this page. There's a corruption in the phpbb_sessions table that needs to be fixed. If Rob or Pete are reading this, perhaps you could take a look to see? This might help http://community.mybb.com/thread-32115.html where there are instructions on using phpMyAdmin to fix tables in a MySql database. Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm Ha! That worked, many thanks Norman :) All back up and running. Pete. ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm
Re: [Ql-Users] QL Forum
On 08/06/12 11:57, peet vanpeebles wrote: Second time it's gone off this week! I'll have a quick look but it might be a job for Rob. It's been up and down like brides nightie! Sounds to me like you have a table going corrupt. Could be down to a bad bit of disc? Especially if it's the same table each time. I'd be thinking of shutting down, taking a backup, and recreating the table (at the very minimum) and reloading it again from the backup - assuming MySql lets you do that - I'm more of a Firebird and Oracle man myself! Have fun. Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm
Re: [Ql-Users] QL Forum
Am 08.06.2012 um 12:54 schrieb Dave Park: On Fri, Jun 8, 2012 at 5:25 AM, Dilwyn Jones dil...@evans1511.fsnet.co.uk wrote: Anyone else having problems accessing QL Forum? When I try this morning I get the error General Error SQL ERROR [ mysql4 ] Table ‘./qlforum_phpbb/phpbb_sessions’ is marked as crashed and should be repaired [145] An sql error occurred while fetching this page. If Rob or Pete are reading this, perhaps you could take a look to see? Dilwyn Jones I'm getting that too. Looks like they need to fix their database just a little bit. And just when I was about to ask a question that suits the forum, but would get me a pat on the head here! ;) SIDETRACK: The question is: is their a limit on the size of a value that can be handled by DIV? Example: tempsecs=99 --- no problem days=tempsecs DIV 86400 --- overflows if tempsecs=32768 Another oddity I discovered: If I create a REPeat loop thus: 100 Frame=0 : Keypress=0 110 REPEAT loop 120 a$=INKEY$ 130 Frame=Frame+1 140 IF a$ THEN Keypress=Keypress+1 150 AT 0,0 : PRINT Frame, Keypress 160 END REPeat loop ...I reasonably expect that when a key is pressed, the Keypress value will increase in step with the Frame value (every time the loop repeats, a keypress is detected) but no. I can type run, and hold down the enter key, and Frame will increment 55 times for each detected Keypress. It seems INKEY$ is limited to approx 15 keyboard scans/sec. On my original QL, with or without GC, they increment together, 1:1. Q-EmuLator 1.1, JS ROM QL, JSU ROM Just throwing that in here, completely off topic ;) Dave, playing with stuff ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm Dave, Question I: DIV is an INTEGER divide. Will only work on INTEGERs in the range -32768 to +32767 (while I seem to recall that -32768 DIV x doesn't work on some ROM versions) Cheers, Tobias ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm
Re: [Ql-Users] QL Forum
On Fri, Jun 8, 2012 at 6:09 AM, Tobias Fröschle tobias.froesc...@t-online.de wrote: Am 08.06.2012 um 12:54 schrieb Dave Park: On Fri, Jun 8, 2012 at 5:25 AM, Dilwyn Jones dil...@evans1511.fsnet.co.uk wrote: Anyone else having problems accessing QL Forum? When I try this morning I get the error General Error SQL ERROR [ mysql4 ] Table ‘./qlforum_phpbb/phpbb_sessions’ is marked as crashed and should be repaired [145] An sql error occurred while fetching this page. If Rob or Pete are reading this, perhaps you could take a look to see? Dilwyn Jones I'm getting that too. Looks like they need to fix their database just a little bit. And just when I was about to ask a question that suits the forum, but would get me a pat on the head here! ;) SIDETRACK: The question is: is their a limit on the size of a value that can be handled by DIV? Example: tempsecs=99 --- no problem days=tempsecs DIV 86400 --- overflows if tempsecs=32768 Another oddity I discovered: If I create a REPeat loop thus: 100 Frame=0 : Keypress=0 110 REPEAT loop 120 a$=INKEY$ 130 Frame=Frame+1 140 IF a$ THEN Keypress=Keypress+1 150 AT 0,0 : PRINT Frame, Keypress 160 END REPeat loop ...I reasonably expect that when a key is pressed, the Keypress value will increase in step with the Frame value (every time the loop repeats, a keypress is detected) but no. I can type run, and hold down the enter key, and Frame will increment 55 times for each detected Keypress. It seems INKEY$ is limited to approx 15 keyboard scans/sec. On my original QL, with or without GC, they increment together, 1:1. Q-EmuLator 1.1, JS ROM QL, JSU ROM Just throwing that in here, completely off topic ;) Dave, playing with stuff ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm Dave, Question I: DIV is an INTEGER divide. Will only work on INTEGERs in the range -32768 to +32767 (while I seem to recall that -32768 DIV x doesn't work on some ROM versions) Cheers, Tobias I don't see an FP version of DIV. Is there one? Dave ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm
Re: [Ql-Users] QL Forum
On Fri, Jun 8, 2012 at 6:13 AM, Dave Park plasticu...@gmail.com wrote: On Fri, Jun 8, 2012 at 6:09 AM, Tobias Fröschle tobias.froesc...@t-online.de wrote: Am 08.06.2012 um 12:54 schrieb Dave Park: On Fri, Jun 8, 2012 at 5:25 AM, Dilwyn Jones dil...@evans1511.fsnet.co.uk wrote: Anyone else having problems accessing QL Forum? When I try this morning I get the error General Error SQL ERROR [ mysql4 ] Table ‘./qlforum_phpbb/phpbb_sessions’ is marked as crashed and should be repaired [145] An sql error occurred while fetching this page. If Rob or Pete are reading this, perhaps you could take a look to see? Dilwyn Jones I'm getting that too. Looks like they need to fix their database just a little bit. And just when I was about to ask a question that suits the forum, but would get me a pat on the head here! ;) SIDETRACK: The question is: is their a limit on the size of a value that can be handled by DIV? Example: tempsecs=99 --- no problem days=tempsecs DIV 86400 --- overflows if tempsecs=32768 Another oddity I discovered: If I create a REPeat loop thus: 100 Frame=0 : Keypress=0 110 REPEAT loop 120 a$=INKEY$ 130 Frame=Frame+1 140 IF a$ THEN Keypress=Keypress+1 150 AT 0,0 : PRINT Frame, Keypress 160 END REPeat loop ...I reasonably expect that when a key is pressed, the Keypress value will increase in step with the Frame value (every time the loop repeats, a keypress is detected) but no. I can type run, and hold down the enter key, and Frame will increment 55 times for each detected Keypress. It seems INKEY$ is limited to approx 15 keyboard scans/sec. On my original QL, with or without GC, they increment together, 1:1. Q-EmuLator 1.1, JS ROM QL, JSU ROM Just throwing that in here, completely off topic ;) Dave, playing with stuff ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm Dave, Question I: DIV is an INTEGER divide. Will only work on INTEGERs in the range -32768 to +32767 (while I seem to recall that -32768 DIV x doesn't work on some ROM versions) Cheers, Tobias I don't see an FP version of DIV. Is there one? Dave To answer my own question, hours=INT(tempsecs/3600) works fine :) Yay programming at 6:30am on no sleep! Dave ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm
Re: [Ql-Users] QL Forum
Question I: DIV is an INTEGER divide. Will only work on INTEGERs in the range -32768 to +32767 (while I seem to recall that -32768 DIV x doesn't work on some ROM versions) Cheers, Tobias I don't see an FP version of DIV. Is there one? Dave DIV and MOD work on 16-bit values in SuperBASIC, 32 bit in SBASIC. Umm, not sure what you mean by FP version of DIV - by definition it works on integer values. Nearest equivalent to x DIV y would be INT(x/y) but this would also be limited to a 32 bit value on both SuperBASIC and SBASIC. Might be possible to use the TK2 functions FDEC$, IDEC$ and CDEC$ (section 13.2 of TK2 manual) to work around these limits, but I don't know if they are limited to any particular length of number or integer value. QDOS has problems with the extreme negative values of integers when using INPUT. This text is quoted from Simon Goodwin's ROM bugs articles in QL World: INTEGER INPUT BUG A sometimes annoying bug in all QL ROMs: Integers - whole number values, stored in variables with a per cent sign at the end of their names - can have values between -32768 and 32767. The statement X%=-32768 works fine, but X%=-32769 gives an error, as you might expect. However you can't INPUT a value of -32768. If you try you get an 'error in expression' report, because the QL works out the value of the digits before it sorts out the sign, plus or minus - and +32768 is not a valid integer. QDOS uses the same code to convert values from all devices, so the bug is present whether you're INPUT comes from the keyboard or a file. This is really just sloppy coding on the part of the ROM authors, who seem to have a lot of trouble with the value -32768. Last year I pointed out the weird results you can get using that value with the integer DIV and MOD operators. Dilwyn Jones ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm
[Ql-Users] Easyptr manual
Before I reinvent the wheel and OCR my Easyptr manual to use on my eBook reader, has anyone else already done this? The Easyptr commands are the hardest syntax to remember of all the BASIC extensions, I think! Dilwyn Jones ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm
Re: [Ql-Users] Easyptr manual
Seems to be on Marcel's site...? - Original Message - From: Dilwyn Jones dil...@evans1511.fsnet.co.uk To: QL Users List ql-us...@q-v-d.com Sent: Friday, June 08, 2012 3:16 PM Subject: [Ql-Users] Easyptr manual Before I reinvent the wheel and OCR my Easyptr manual to use on my eBook reader, has anyone else already done this? The Easyptr commands are the hardest syntax to remember of all the BASIC extensions, I think! Dilwyn Jones ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm
Re: [Ql-Users] Easyptr manual
Umm, where? I can find the update notes for the version 4 upgrade, but not the full manual. (Let me state that this is purely for my own use and won't go on my website for example) Dilwyn Jones -Original Message- From: Ralf Reköndt Sent: Friday, June 08, 2012 2:33 PM To: ql-us...@q-v-d.com Subject: Re: [Ql-Users] Easyptr manual Seems to be on Marcel's site...? - Original Message - From: Dilwyn Jones dil...@evans1511.fsnet.co.uk To: QL Users List ql-us...@q-v-d.com Sent: Friday, June 08, 2012 3:16 PM Subject: [Ql-Users] Easyptr manual Before I reinvent the wheel and OCR my Easyptr manual to use on my eBook reader, has anyone else already done this? The Easyptr commands are the hardest syntax to remember of all the BASIC extensions, I think! Dilwyn Jones ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2178 / Virus Database: 2433/5055 - Release Date: 06/07/12 ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm
Re: [Ql-Users] QL Forum
On 8 Jun 2012, at 11:54, Dave Park wrote: If I create a REPeat loop thus: 100 Frame=0 : Keypress=0 110 REPEAT loop 120 a$=INKEY$ 130 Frame=Frame+1 140 IF a$ THEN Keypress=Keypress+1 150 AT 0,0 : PRINT Frame, Keypress 160 END REPeat loop INKEY$(-1) will wait until you press a key. INKEY$(3) will wait for 3 ticks for your keypress. INKEY$ will return (nearly) immediately. George ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm
Re: [Ql-Users] Easyptr manual
On 08/06/12 14:16, Dilwyn Jones wrote: Before I reinvent the wheel and OCR my Easyptr manual to use on my eBook reader, has anyone else already done this? Not yet, no. The Easyptr commands are the hardest syntax to remember of all the BASIC extensions, I think! I'll second that! Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 ___ QL-Users Mailing List http://www.q-v-d.demon.co.uk/smsqe.htm
