Table 'secretname_invoi99.ip_login_log' doesn't exist

Support
1

I updated invoiceplane through softaculous a few days ago, but hadn’t tried to log in until this morning. I got the following error:

<<<>>>>

A Database Error Occurred

Error Number: 1146

Table ‘redactedname_invoi99.ip_login_log’ doesn’t exist

SELECT * FROM ip_login_log WHERE login_name = ‘redactedemail’

Filename: modules/sessions/controllers/Sessions.php

Line Number: 303
<<<>>>>

I tried restoring the redactedname_invoi99 database back to when I last succesfully used the program (about 20 days ago), and got the same error. Then I tried a week before that with the same error.

I have Invoiceplane located at redacteddomain .com/inv/

I tried, per a previous post here to use redacteddomain .com/inv/index.php/setup , but it gave the following error:
<<<>>>>
An Error Was Encountered

The setup is disabled.
<<<>>>>

Any ideas?

1 Like
2

can you go to /setup in your InvoicePlane?
It should run a database upgrade.

You’re missing the table from version 1.5.12:

CREATE TABLE `ip_login_log` (
    `login_name` varchar(100),
    `log_count` int DEFAULT 0,
    `log_create_timestamp` datetime,
    PRIMARY KEY (login_name)
)

It’s in this file:
/application/modules/setup/sql/035_1.5.12.sql

I don’t think softaculous has prepared 1.6.3 (which is the latest version) yet, but you can always check.

  • Can you reach your database?
  • if you add that table manually, then you’re missing a record in the versions table

The /setup that runs the migrations should take care of adding that table for you

3

Nope, as per above:

4

and the version I have (latest from softaculous) is 1.6.2

1 Like
5

I used phpmyadmin and created a table with the info above, and that seems to work.

Thanks! I learned something today (and for an old coot like me who’s last coding or programming classes were in the late 80s, that something!).

1 Like