I try use e-publish module in drupal 5.2.2. But when I add a journal take below error:
"user warning: Column count doesn't match value count at row 1 query: INSERT INTO klp_ejournal_journals (jid, vid, title, description, path, about_page, ejournal_layout, archive_order, enabled, issn, publisher_name, publisher_url, publisher_email, issue_format) VALUES ('1', '', 'sample journal', '', 'sj1', '', '', 'DESC', '1', '0', '', '', '', '', '0') in c:\documents ".
Please help me.

Comments

romca’s picture

romca commented
Status: Active » Fixed

hi, please grab the new files from the csv (http://cvs.drupal.org/viewvc.py/drupal/contributions/modules/ejournal/?p...), at least ejournal.install and ejournal.module), copy them over the old files and run the update script (ie. site building > modules > update --- then run the update for ejournal)

The table will be fixed (if you see an error message, than ignore it, it might be that you have created tables with some development version that already had the tables schema correct and fixing it will generate an error)

Thanks for reporting, please let me know if it worked for you

roman

surfer_1’s picture

surfer_1 commented
Title: Can not add journal in 5.x-1.x-dev » Error when add an article in to issue...

Hi,
There is a new error.
When I add an article in a new issue take below message:

"user warning: 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 ')' at line 1 query: DELETE FROM klp_term_node WHERE nid='3' AND tid IN () in c:\documents and ........."

Thanx

Surfer_1

romca’s picture

romca commented

Hi,
could you please try the updated version of ejournal.module from CVS? And let me know...
Thanks,

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)