Mohanjith

end to end solutions…

Log Table – Not Found

Home › Forums › WordPress › Web Invoice – Invoicing and billing for WordPress › Log Table – Not Found

Tagged: , , ,

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • August 3, 2009 at 14:27 #3424
    cooper
    Member

    I had first tried to install Web Invoice and Billing by TwinCities Tech. Although I could set up a test invoice, I was unable to access the settings. The tabs were at the top but nothing below.

    So I installed Web Invoice by Mohanjith, which worked just as well, plus the settings showed up, yet but gave be an error on the top in red:

    “The plugin database tables are gone, deactivate and reactivate plugin to re-create them.”

    Main Table – Good

    Meta Table – Good

    Log Table – Not Found

    Payment Table – Good

    Payment Meta Table – Good

    I noticed that the invoice post also didn’t show up.

    I contacted my Host and they told me to add this to my .htaccess:

    AddHandler application/x-httpd-php5 .php

    This fixed the invoice post so now it shows the invoice, but the log table error is still there. I’m not what info is on this table but I’m sure it is there for a reason.

    I have a feeling that the other WP plugin tables are affecting this one, yet I’m not quite sure how to delete them, since the setting panel is blank and I don’t do Mysql.

    Any suggestions would be great.

    FYI: I have also tried deactivating and reactivating and uninstalling and reinstalling.

    August 3, 2009 at 14:43 #4507
    S H Mohanjith
    Member

    Log table is where the “audit” logs are maintained. Have you tried disabling and enabling the plugin. If it doesn’t help try “Remove All Web Invoice Databases” and then disable and enable the

    plugin.

    Please post here how it goes.

    August 5, 2009 at 15:22 #4510
    cooper
    Member

    I have done that in a number of combinations. I have even forced my host to upgrade my server (it was almost 10 years old, I was paying todays prices for 4GB of space!). Still no fix. My theory was that the other WP invoice plugin’s database was conflicting. I scoured the code, disabling CSS because the setting panel never displayed properly, I finally found the URL that would delete the twin cities tables.

    I reinstalled your plugin, same message at top:

    The plugin database tables are gone, deactivate and reactivate plugin to re-create them.

    and on the bottom:

    Log Table – Not Found

    I’m about to give up.

    August 5, 2009 at 19:33 #4513
    S H Mohanjith
    Member

    Only other option is to manually create the table. Run the following SQL (using MySQL client or phpMyAdmin).

    CREATE TABLE IF NOT EXISTS _table_prefix_web_invoice_log (
    
id bigint(20) NOT NULL auto_increment,
    
invoice_id int(11) NOT NULL default '0',
    
action_type varchar(255) NOT NULL,
    
value longtext NOT NULL,
    
time_stamp timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    
PRIMARY KEY  (id)
    
);

    Replace _table_prefix_ with your table prefix and escape value field with backticks (backtics are automatically converted to <code> tags by bbpress :( )

    August 6, 2009 at 15:27 #4516
    cooper
    Member

    Ok, thanks.

    What would my table prefix be?

    August 6, 2009 at 16:30 #4519
    S H Mohanjith
    Member

    Look for $table_prefix in wordpress/wp-config.php .

    August 10, 2009 at 14:57 #4522
    cooper
    Member

    I used phpMyAdmin:

    CREATE TABLE IF NOT EXISTS wp_web_invoice_log(

    id bigint( 20 ) NOT NULL AUTO_INCREMENT ,

    invoice_id int( 11 ) NOT NULL default ‘0’,

    action_type varchar( 255 ) NOT NULL ,

    value longtext NOT NULL ,

    time_stamp timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,

    PRIMARY KEY ( id )

    )

    and I got this error:

    #1064 – You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

    PRIMARY KEY (

    August 17, 2009 at 07:13 #4525
    S H Mohanjith
    Member

    I believe you are running MySQL 4.0 or bellow. I have added compatibility for versions bellow MySQL 4.1 in Web Invoice 1.9.4.

    Please remove all Web Invoice tables and upgrade to the latest Web Invoice version.

    Thanks for your help to triangulate this bug, much appreciated.

  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.