Bitmessage/PyBitmessage-2025-02-20
Archived
2
0
Fork 0
Code Issues 167 Pull Requests 54 Actions Packages Projects Releases 5 Wiki Activity

Running for first time fails with OperationalError: no such table: inventory #941

New Issue
Closed
opened 2017-01-29 02:57:43 +01:00 by crypdick · 4 comments
crypdick commented 2017-01-29 02:57:43 +01:00 (Migrated from github.com)
Copy Link

Here is the error:

richard@motherload:~/Apps$ python2 PyBitmessage/src/bitmessagemain.py
Loading existing config files from /home/richard/.config/PyBitmessage/
Failed to load debug config from /home/richard/.config/PyBitmessage/logging.dat, using default logging config
(<class 'ConfigParser.NoSectionError'>, No section: 'formatters', <traceback object at 0x7f85fead1d88>)
Exception in thread SQL:
Traceback (most recent call last):
  File "/usr/lib/python2.7/threading.py", line 801, in __bootstrap_inner
    self.run()
  File "/home/richard/Apps/PyBitmessage/src/class_sqlThread.py", line 224, in run
    self.cur.execute(item, parameters)
OperationalError: no such table: inventory

Here are the commands I used (taken from .bash_history):

git clone https://github.com/Bitmessage/PyBitmessage
python PyBitmessage/src/bitmessagemain.py
touch ~/.namecoin/namecoin.conf
python2 PyBitmessage/src/bitmessagemain.py
Here is the error: ``` richard@motherload:~/Apps$ python2 PyBitmessage/src/bitmessagemain.py Loading existing config files from /home/richard/.config/PyBitmessage/ Failed to load debug config from /home/richard/.config/PyBitmessage/logging.dat, using default logging config (<class 'ConfigParser.NoSectionError'>, No section: 'formatters', <traceback object at 0x7f85fead1d88>) Exception in thread SQL: Traceback (most recent call last): File "/usr/lib/python2.7/threading.py", line 801, in __bootstrap_inner self.run() File "/home/richard/Apps/PyBitmessage/src/class_sqlThread.py", line 224, in run self.cur.execute(item, parameters) OperationalError: no such table: inventory ``` Here are the commands I used (taken from `.bash_history`): ``` git clone https://github.com/Bitmessage/PyBitmessage python PyBitmessage/src/bitmessagemain.py touch ~/.namecoin/namecoin.conf python2 PyBitmessage/src/bitmessagemain.py ```
PeterSurda commented 2017-01-29 10:20:27 +01:00 (Migrated from github.com)
Copy Link

I think that you interrupted it when you first ran the script as it was in the middle of creating the tables. This isn't handled correctly. In the meantime, delete ~/.config/PyBitmessage/messages.dat, but be warned, if you have any received or sent messages, if you have any subscriptions, they will be deleted as well.

I think that you interrupted it when you first ran the script as it was in the middle of creating the tables. This isn't handled correctly. In the meantime, delete `~/.config/PyBitmessage/messages.dat`, but be warned, if you have any received or sent messages, if you have any subscriptions, they will be deleted as well.
crypdick commented 2017-01-29 22:00:07 +01:00 (Migrated from github.com)
Copy Link

Ok. Deleting messages.dat allowed me to log in for the first time, thanks! FYI the terminal spewed a few other errors, in case it is at all relevant:

Failed to load debug config from /home/richard/.config/PyBitmessage/logging.dat, using default logging config
(<class 'ConfigParser.NoSectionError'>, No section: 'formatters', <traceback object at 0x7f383792c908>)
Info: we could not tell whether your OS is limited to having very few half open connections because we couldn't interpret the platform version. Don't worry; we'll assume that it is not limited. This tends to occur on Raspberry Pis. : invalid version number '#78-Ubuntu SMP Fri Dec 9 23:50:32 UTC 2016'
2017-01-29 15:58:05,353 - ERROR - HTTP connection error
Traceback (most recent call last):
  File "/home/richard/Apps/PyBitmessage/src/namecoin.py", line 203, in queryHTTP
    self.con.endheaders()
  File "/usr/lib/python2.7/httplib.py", line 1053, in endheaders
    self._send_output(message_body)
  File "/usr/lib/python2.7/httplib.py", line 897, in _send_output
    self.send(msg)
  File "/usr/lib/python2.7/httplib.py", line 859, in send
    self.connect()
  File "/usr/lib/python2.7/httplib.py", line 836, in connect
    self.timeout, self.source_address)
  File "/usr/lib/python2.7/socket.py", line 575, in create_connection
    raise err
error: [Errno 111] Connection refused
2017-01-29 15:58:05,391 - ERROR - Namecoin connection test failure
Traceback (most recent call last):
  File "/home/richard/Apps/PyBitmessage/src/namecoin.py", line 134, in test
    res = self.callRPC ("getinfo", [])
  File "/home/richard/Apps/PyBitmessage/src/namecoin.py", line 173, in callRPC
    val = json.loads (resp)
  File "/usr/lib/python2.7/json/__init__.py", line 339, in loads
    return _default_decoder.decode(s)
  File "/usr/lib/python2.7/json/decoder.py", line 364, in decode
    obj, end = self.raw_decode(s, idx=_w(s, 0).end())
TypeError: expected string or buffer
2017-01-29 15:58:05,415 - WARNING - WARNING: MessagingMenu is not available.  Is libmessaging-menu-dev installed?
Ok. Deleting `messages.dat` allowed me to log in for the first time, thanks! FYI the terminal spewed a few other errors, in case it is at all relevant: ``` Failed to load debug config from /home/richard/.config/PyBitmessage/logging.dat, using default logging config (<class 'ConfigParser.NoSectionError'>, No section: 'formatters', <traceback object at 0x7f383792c908>) Info: we could not tell whether your OS is limited to having very few half open connections because we couldn't interpret the platform version. Don't worry; we'll assume that it is not limited. This tends to occur on Raspberry Pis. : invalid version number '#78-Ubuntu SMP Fri Dec 9 23:50:32 UTC 2016' 2017-01-29 15:58:05,353 - ERROR - HTTP connection error Traceback (most recent call last): File "/home/richard/Apps/PyBitmessage/src/namecoin.py", line 203, in queryHTTP self.con.endheaders() File "/usr/lib/python2.7/httplib.py", line 1053, in endheaders self._send_output(message_body) File "/usr/lib/python2.7/httplib.py", line 897, in _send_output self.send(msg) File "/usr/lib/python2.7/httplib.py", line 859, in send self.connect() File "/usr/lib/python2.7/httplib.py", line 836, in connect self.timeout, self.source_address) File "/usr/lib/python2.7/socket.py", line 575, in create_connection raise err error: [Errno 111] Connection refused 2017-01-29 15:58:05,391 - ERROR - Namecoin connection test failure Traceback (most recent call last): File "/home/richard/Apps/PyBitmessage/src/namecoin.py", line 134, in test res = self.callRPC ("getinfo", []) File "/home/richard/Apps/PyBitmessage/src/namecoin.py", line 173, in callRPC val = json.loads (resp) File "/usr/lib/python2.7/json/__init__.py", line 339, in loads return _default_decoder.decode(s) File "/usr/lib/python2.7/json/decoder.py", line 364, in decode obj, end = self.raw_decode(s, idx=_w(s, 0).end()) TypeError: expected string or buffer 2017-01-29 15:58:05,415 - WARNING - WARNING: MessagingMenu is not available. Is libmessaging-menu-dev installed? ```
PeterSurda commented 2017-01-29 22:25:17 +01:00 (Migrated from github.com)
Copy Link

These are really warnings rather than errors and it's been reworked in the v0.6 branch. It means that

  • you don't have a custom logging configuration so it's using the default one
  • you don't seem to have namecoin running so it's disabling namecoin functionality
  • you don't have libmessaging so it's disabling the new mail notifications / system tray menu. This is the only really important thing, most linux distros have a package for this somewhere (libmessaging-menu or something like this)
These are really warnings rather than errors and it's been reworked in the v0.6 branch. It means that - you don't have a custom logging configuration so it's using the default one - you don't seem to have namecoin running so it's disabling namecoin functionality - you don't have libmessaging so it's disabling the new mail notifications / system tray menu. This is the only really important thing, most linux distros have a package for this somewhere (libmessaging-menu or something like this)
👍 1
g1itch commented 2020-04-28 13:10:12 +02:00 (Migrated from github.com)
Copy Link

It seems there is nothing to do here.

It seems there is nothing to do here.
This repo is archived. You cannot comment on issues.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
bug
Something isn't working as it's supposed to
build
Related to building or build system
dependencies
Pull requests that update a dependency file
developers
The issue is relevant mainly for developers rather than users
documentation
duplicate
enhancement
New feature
formatting
Code or UI text formatting
invalid
legal
mobile
Frontend for mobile devices (kivy)
obsolete
packaging
performance
protocol
Protocol change
question
refactoring
regression
Some issue, fixed in the past, appears again
security
test
translation
usability
wontfix
No Label
bug
Milestone
No items
No Milestone v0.6.3
Projects
Clear projects
No project
Assignees
Clear assignees
PeterSurda
No Assignees
1 Participants
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: Bitmessage/PyBitmessage-2025-02-20#941
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?