In history page, there's a warning message:
user warning: Unknown column 'l.lid' in 'order clause' query: SELECT l.* FROM ejournal_log l INNER JOIN users u ON l.uid = u.uid WHERE l.id= '1' ORDER BY l.lid DESC LIMIT 0, 50

Comments

romca’s picture

romca commented

you probably haven't update the table, please go to site building > modules and click on update, then process with the ejournal update. The columns will be fixed for you

whizzopia’s picture

whizzopia commented

Hi, after running the ejournal update, all of update#2 are failed.
In the create table script, 'ejournal_log' table is created with the old column name such as id,nid,iid.
This update table script (alter table {ejournal_articles_log} ,change `id` `lid` int (9) NOT NULL AUTO_INCREMENT , change `nid` `id` int (9) NOT NULL , change `iid` `entity` varchar (16) NOT NULL) fails because table 'ejournal_articles_log' does not exist. As a result, table 'ejournal_log' still has the old column name.

romca’s picture

romca commented
Status: Active » Closed (fixed)

Hi, sorry, it was me who forgot to update the code for the scheme installation after making changes into the module. So, the update failed. It is fixed now in the cvs, thanks.

You might uninstall and install the module again, or if not appropriate, then execute these two queries:

drop table {ejournal_log};
CREATE TABLE {ejournal_log} (
lid int(9) NOT NULL auto_increment,
id int(9) NOT NULL default '0',
entity varchar(16) NOT NULL default '',
uid int(6) NOT NULL default '0',
type varchar(16) NOT NULL default '',
message text NOT NULL default '',
hostname varchar(128) NOT NULL default '',
timestamp int(11) NOT NULL default '0',
PRIMARY KEY (id)
) Type=MyISAM;