[Home] [Downloads] [Search] [Help/forum]


Register forum user name Search FAQ

Gammon Forum

[Folder]  Entire forum
-> [Folder]  MUSHclient
. -> [Folder]  General
. . -> [Subject]  SQL error on statement:

SQL error on statement:

It is now over 60 days since the last post. This thread is closed.     [Refresh] Refresh page


Posted by JohnSeever   (3 posts)  [Biography] bio
Date Sun 13 Dec 2015 08:22 PM (UTC)
Message
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.
[Go to top] top

Posted by Nick Gammon   Australia  (22,973 posts)  [Biography] bio   Forum Administrator
Date Reply #1 on Sun 13 Dec 2015 10:16 PM (UTC)
Message
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

- Nick Gammon

www.gammon.com.au, www.mushclient.com
[Go to top] top

Posted by JohnSeever   (3 posts)  [Biography] bio
Date Reply #2 on Mon 14 Dec 2015 06:55 AM (UTC)
Message
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.
[Go to top] top

Posted by Meerclar   USA  (733 posts)  [Biography] bio
Date Reply #3 on Mon 14 Dec 2015 01:21 PM (UTC)
Message
What's the install directory for your MC?

Meerclar - Lord of Cats
Coder, Builder, and Tormenter of Mortals
Stormbringer: Rebirth
storm-bringer.org:4500
www.storm-bringer.org
[Go to top] top

Posted by Nick Gammon   Australia  (22,973 posts)  [Biography] bio   Forum Administrator
Date Reply #4 on Mon 14 Dec 2015 08:31 PM (UTC)
Message
Template:version Please help us by advising the version of MUSHclient you are using. Use the Help menu -> About MUSHclient.


Template:bug

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.


- Nick Gammon

www.gammon.com.au, www.mushclient.com
[Go to top] top

Posted by JohnSeever   (3 posts)  [Biography] bio
Date Reply #5 on Mon 14 Dec 2015 09:37 PM (UTC)

Amended on Tue 15 Dec 2015 08:09 AM (UTC) by Nick Gammon

Message
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 ----------------------
[Go to top] top

Posted by Meerclar   USA  (733 posts)  [Biography] bio
Date Reply #6 on Tue 15 Dec 2015 01:05 AM (UTC)
Message
What is your MUSHClient install directory and which OS are you using(Windows 10? Windows 8? Debian? Suze? Redhat?)?

Meerclar - Lord of Cats
Coder, Builder, and Tormenter of Mortals
Stormbringer: Rebirth
storm-bringer.org:4500
www.storm-bringer.org
[Go to top] top

The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).

To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.


19,043 views.

It is now over 60 days since the last post. This thread is closed.     [Refresh] Refresh page

Go to topic:           Search the forum


[Go to top] top

Quick links: MUSHclient. MUSHclient help. Forum shortcuts. Posting templates. Lua modules. Lua documentation.

Information and images on this site are licensed under the Creative Commons Attribution 3.0 Australia License unless stated otherwise.

[Home]


Written by Nick Gammon - 5K   profile for Nick Gammon on Stack Exchange, a network of free, community-driven Q&A sites   Marriage equality

Comments to: Gammon Software support
[RH click to get RSS URL] Forum RSS feed ( https://gammon.com.au/rss/forum.xml )

[Best viewed with any browser - 2K]    [Hosted at HostDash]