SQL error on statement:

Posted by JohnSeever on Sun 13 Dec 2015 08:22 PM — 7 posts, 29,600 views.

JohnSeever Sun 13 Dec 2015 08:22 PM #0

Yesterday, 12/11/15, I stared up MUSHClient and I received two error messages: SQL error on statement: "UPDATE prefs SET value = 'EN' WHERE name = 'Local'" disk I/O error when I double click on the icon and then I received the following message after a world was opened, SQL error on statement:
"UPDATE control SET value = '4970' WHERE name = 'Tip_FilePos'"
disk I/O error

What is going on and how can I fix these errors.

Thank you.

Nick Gammon Australia Forum Administrator Sun 13 Dec 2015 10:16 PM #1

The MUSHclient global preferences are stored in a SQLite3 database file (mushclient_prefs.sqlite). The I/O error sounds like that file is in a write-protected location. The file is in the same folder (directory) as MUSHclient.exe file. Check your permissions for that folder and ensure that you have write access.

If necessary move the entire MUSHclient installed folder somewhere else (eg. the Desktop).

You could also try removing that file if it has become corrupted. MUSHclient will then create a new one. Remove the file:


mushclient_prefs.sqlite

JohnSeever Mon 14 Dec 2015 06:55 AM #2

I got the initial error again and now got the following errors:

SQL error on statement:
"UPDATE control SET value = 'Mon Aug 21 16:08:02 2006' WHERE name = 'Tip_TimeStamp'"
disk I/O error
SQL error on statement:
"UPDATE control SET value = '102' WHERE name = 'Tip_FilePos'"
disk I/O error

This was after removing the file you mentioned.

Meerclar USA Mon 14 Dec 2015 01:21 PM #3

What's the install directory for your MC?

Nick Gammon Australia Forum Administrator Mon 14 Dec 2015 08:31 PM #4

Please help us by advising the version of MUSHclient you are using. Use the Help menu -> About MUSHclient.

Please provide a summary of your world configuration:

Either use the scripting Immediate window (Ctrl+I) to execute: Debug ("summary")
or
Install the Summary plugin (see "Summary" feature) and type "summary"

Then copy the resulting information from the output window, and paste into a Forum message.

You need version 4.55 onwards of MUSHclient to do this.

JohnSeever Mon 14 Dec 2015 09:37 PM #5

I am using version 4.94



-------------- MUSHclient summary --------------

MUSHclient version: 4.94
Compiled: Jul 28 2014.
Time now: Monday, December 14, 2015, 3:36 PM
Client running for:  0d 00h 09m 36s
World opened for:    0d 00h 02m 07s
World connected for: 0d 00h 02m 06s
Operating system: Unknown (Platform 2, Major 6, Minor 2)
Libraries: Lua 5.1.4, PCRE 8.35, PNG 1.5.14, SQLite3 3.8.4.3, Zlib 1.2.8
World name: 'Multiverse Crisis MUSH', ID: c4e6a6af4a88310f6a6f48d7
-- Scripting --
Script language: Lua, enabled: yes
Scripting active: yes
Lua sandbox is 127 characters, DLL loading allowed: yes
Scripting prefix: ''. External editor in use: NO.
Scripting for: 0.000060 seconds.
-- Triggers, aliases, timers, variables --
** Triggers: 0 in world file, triggers enabled: yes.
   0 enabled, 0 regexp, 0 attempts, 0 matched, 0.000000 seconds.
** Aliases: 0 in world file, aliases enabled: yes.
   0 enabled, 0 regexp, 0 attempts, 0 matched, 0.000000 seconds.
** Timers: 0 in world file, timers enabled: yes.
   0 enabled, 0 fired.
   Timers checked every 0.1 seconds.
** Variables: 0.
-- MCCP --
MCCP not active.
-- Plugins (Processing order) --
** Plugins: 0 loaded, 0 enabled.
-- Comms --
Connect phase: 8 (Open). NAWS wanted: NO
Received: 1588 bytes (1 Kb)
Sent: 178 bytes (0 Kb)
Received 5 packets, sent 7 packets.
Total lines received: 82
This connection: Sent 1 lines, received 73 lines.
Telnet (IAC) received: DO: 3, DONT: 0, WILL: 2, WONT: 0, SB: 1 [Telnet]
-- MXP --
MXP active: yes, Pueblo mode: yes, Activated: On command
MXP tags received: 19
MXP entities received: 8
MXP errors: 0
-- Commands --
Commands in command history: 0
Speed walking enabled: NO. Speed walking prefix: #
Command stacking enabled: NO. Command stack character: ';'
Accelerators defined: 0
-- Miniwindows --
** Miniwindows: 0 loaded, 0 shown.
-- Output window --
Output pixels: width 1321, height: 398, font width: 8, font height: 15
               can show 165 characters, wrapping at column 165, height 26 lines.
Output buffer: 100 of 5000 lines.
-- Miscellaneous --
Logging: NO, tracing: NO
** SQLite3 databases: 0
Sound buffers in use: 0

---------------------- End summary ----------------------

Meerclar USA Tue 15 Dec 2015 01:05 AM #6

What is your MUSHClient install directory and which OS are you using(Windows 10? Windows 8? Debian? Suze? Redhat?)?