Register forum user name Search FAQ

Gammon Forum

Notice: Any messages purporting to come from this site telling you that your password has expired, or that you need to verify your details, confirm your email, resolve issues, making threats, or asking for money, are spam. We do not email users with any such messages. If you have lost your password you can obtain a new one by using the password reset link.

Due to spam on this forum, all posts now need moderator approval.

 Entire forum ➜ MUSHclient ➜ Bug reports ➜ GUI Mapper error reporting
GUI Mapper error reporting

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

Posted by Starcomet   (15 posts)  Bio
Date Fri 01 May 2015 12:33 AM (UTC)
Message
After installing the newer version of Mushclient, the GUI mapper no longer wishes to work for me. Here is the error crash report I received.

Error number: 0
Event: Run-time error
Description: [string "Plugin"]:112: FOREIGN KEY constraint failed

stack traceback:

[C]: in function 'error'

[string "Plugin"]:66: in function 'dbcheck'

[string "Plugin"]:112: in function 'save_exits_to_database'

[string "Plugin"]:952: in function 'f'

[string "Plugin"]:1048: in function <[string "Plugin"]:1044>
Called by: Function/Sub: OnPluginBroadcast called by Plugin ATCP_Mapper

Reason: Executing plugin ATCP_Mapper sub OnPluginBroadcast
Top
Posted by Starcomet   (15 posts)  Bio
Date Reply #1 on Fri 01 May 2015 12:49 AM (UTC)
Message
Hmm could it be that the plugin requiring 4.51 is the issue? Is there an updated version of it?
Top
Posted by Starcomet   (15 posts)  Bio
Date Reply #2 on Fri 01 May 2015 12:59 AM (UTC)
Message
Here is another error after I uninstalled and reinstalled version 4.97

[string "Plugin"]:131: FOREIGN KEY constraint failed
stack traceback:
[C]: in function 'error'
[string "Plugin"]:74: in function 'dbcheck'
[string "Plugin"]:131: in function 'save_exits_to_database'
[string "Plugin"]:1122: in function 'f'
[string "Plugin"]:1239: in function <[string "Plugin"]:1233>
Top
Posted by Starcomet   (15 posts)  Bio
Date Reply #3 on Fri 01 May 2015 01:04 AM (UTC)
Message
And I am playing Achaea in case that helps.
Top
Posted by Nick Gammon   Australia  (23,158 posts)  Bio   Forum Administrator
Date Reply #4 on Fri 01 May 2015 06:51 AM (UTC)
Message
Starcomet said:

Hmm could it be that the plugin requiring 4.51 is the issue?


No, that is the minimum version.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Nick Gammon   Australia  (23,158 posts)  Bio   Forum Administrator
Date Reply #5 on Fri 01 May 2015 06:52 AM (UTC)
Message
If everything was working before you could always go back to the earlier version.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Starcomet   (15 posts)  Bio
Date Reply #6 on Fri 01 May 2015 04:54 PM (UTC)
Message
I re downloaded version 4.75 and the mapper is working fine again. I am not sure why it refuses to draw the paths on the newer version.
Top
Posted by Meerclar   USA  (733 posts)  Bio
Date Reply #7 on Fri 01 May 2015 07:28 PM (UTC)
Message
I suspect it has something to do with
Quote:
Upgraded SQLite3 library to 3.8.8.3
update in the 4.97 release, though it's odd that it hasn't cropped up until now.
Meerclar - Lord of Cats
Coder, Builder, and Tormenter of Mortals
Stormbringer: Rebirth
storm-bringer.org:4500
www.storm-bringer.org
Top
Posted by Starcomet   (15 posts)  Bio
Date Reply #8 on Fri 01 May 2015 08:33 PM (UTC)

Amended on Fri 01 May 2015 08:35 PM (UTC) by Starcomet

Message
What is your suggestion for fixing it Meerclar? I am fine with using this older version, but I think it would be best to update to the newest version.
Top
Posted by Nick Gammon   Australia  (23,158 posts)  Bio   Forum Administrator
Date Reply #9 on Fri 01 May 2015 09:13 PM (UTC)
Message
My guess from the error message is that something to do with foreign keys is now being enforced more.

One solution, that you probably won't want, is to delete the old mapper database and let it make a new one. (Of course, just rename/backup it, just in case).


Another thing you could try is turning foreign key checking off.

I'm not sure which version you have exactly, but if you look in the mapper plugin you should be able to find a line like this:


  
  -- open databases on disk 
  db    = assert (sqlite3.open(GetInfo (66) .. Trim (WorldAddress ()) .. "_" .. WorldPort () .. ".db"))


After that (after the database is opened) add this line:


dbcheck (db:execute ("PRAGMA foreign_keys = OFF;"))


Then reload the plugin and try again. This may simply lead to a different error, but it is worth trying.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Nick Gammon   Australia  (23,158 posts)  Bio   Forum Administrator
Date Reply #10 on Fri 01 May 2015 09:14 PM (UTC)
Message
Or if there is a line like this:


create_tables ()    -- create database structure if necessary


Do it after that, because create_tables turns foreign key checking back on.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Meerclar   USA  (733 posts)  Bio
Date Reply #11 on Sat 02 May 2015 05:34 AM (UTC)
Message
Starcomet said:

What is your suggestion for fixing it Meerclar? I am fine with using this older version, but I think it would be best to update to the newest version.

I'm honestly not familiar enough with the changes from the library Nick was using prior to the upgrade to offer even as good a solution as Nick has already offered. I was more pointing out the likely cause for working properly on the older version but not the 2 latest releases in the fairly likely event someone else from Achaea comes along with the same issue in the near future.
Meerclar - Lord of Cats
Coder, Builder, and Tormenter of Mortals
Stormbringer: Rebirth
storm-bringer.org:4500
www.storm-bringer.org
Top
Posted by Nick Gammon   Australia  (23,158 posts)  Bio   Forum Administrator
Date Reply #12 on Tue 05 May 2015 11:01 PM (UTC)
Message
I've just tried it on Achaea and had the same problem.

Edit the plugin, find the line with the foreign key restraint on it, and remove it. Also remove the comma from the previous line like this:


  CREATE TABLE IF NOT EXISTS exits (
      exitid      INTEGER PRIMARY KEY AUTOINCREMENT,
      dir         TEXT    NOT NULL, -- direction, eg. "n", "s"
      fromuid     STRING  NOT NULL, -- exit from which room (in rooms table)
      touid       STRING  NOT NULL, -- exit to which room (in rooms table)
      date_added  DATE              -- date added to database
    );


Close MUSHclient, delete the database file (achaea.com_23.db) and then try again.
- Nick Gammon

www.gammon.com.au, www.mushclient.com
Top
Posted by Fiendish   USA  (2,535 posts)  Bio   Global Moderator
Date Reply #13 on Wed 06 May 2015 12:16 AM (UTC)
Message
Foreign key constraints are kinda useless anyway.
https://github.com/fiendish/aardwolfclientpackage
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.

34,868 views.

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

Go to topic:           Search the forum

[Go to top] top

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

Home