Please help! My live site has these log error messages! [#1405898]

Hi,

I have got lots of error messages in the recent log entries in my live site every morning but there isn't any error messages showing in the log entries in my testing site. The testing site server is seperate with the live site server but the testing server is copied from the live server. Any idea what might cause it and how I can solve it? Thank you for your help in advance!

I have copied error messages as follows:
"Data too long for column 'type' at row 1 query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'import_publications', 'file has been archived', 'a:0:{}', 5, '', 'http://msl.irl.cri.nz/cron.php', '', '127.0.0.1', 1326646896) in D:\sites\msl.irl.cri.nz\htdocs\modules\dblog\dblog.module on line 146."

"Column 'nid' cannot be null query: UPDATE content_type_publication SET vid = 0, nid = NULL, field_authors_value = 'Schantz, M.; Samuel, L.*', field_id_value = 14549, field_bibliographic_code_value = 'M', field_year_publication_value = 2008, field_source_title_value = 'Report of Analysis (ROA) to NIST Analytical Chemistry', field_source_information_value = NULL, field_broad_work_areas_value = 'Chemical' WHERE vid = 0 in D:\sites\msl.irl.cri.nz\htdocs\sites\all\modules\contrib\cck\content.module on line 1213."

"in D:\sites\msl.irl.cri.nz\htdocs\includes\common.inc on line 3538."

"htmlspecialchars() [function.htmlspecialchars]: Invalid multibyte sequence in argument in D:\sites\msl.irl.cri.nz\htdocs\includes\bootstrap.inc on line 856."

Thanks,
Lan

Comments

Comment #1

alan d. commented 23 January 2012 at 12:44

Project:	Drupal core	» Bibliography Module
Version:	6.22	» 6.x-2.x-dev
Component:	dblog.module	» Code
Assigned:	lan	» Unassigned
Priority:	Critical	» Major

The error hints at the biblio module, but I could be wrong.

Have you run all of your update scripts on the live site? www.mysite.com/update.php

Comment #2

rjerome commented 23 January 2012 at 18:54

I'm guessing it's not Biblio. The first one

"Data too long for column 'type' at row 1 query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'import_publications', 'file has been archived', 'a:0:{}', 5, '', 'http://msl.irl.cri.nz/cron.php', '', '127.0.0.1', 1326646896) in D:\sites\msl.irl.cri.nz\htdocs\modules\dblog\dblog.module on line 146."

indicates that the string "import_publications" is to large for the column in the database. Biblio does not contain that string, so I'm guessing maybe you have some automated harvesting for feed import going on, as this is being generated by a cron job.

"Column 'nid' cannot be null query: UPDATE content_type_publication SET vid = 0, nid = NULL, field_authors_value = 'Schantz, M.; Samuel, L.*', field_id_value = 14549, field_bibliographic_code_value = 'M', field_year_publication_value = 2008, field_source_title_value = 'Report of Analysis (ROA) to NIST Analytical Chemistry', field_source_information_value = NULL, field_broad_work_areas_value = 'Chemical' WHERE vid = 0 in D:\sites\msl.irl.cri.nz\htdocs\sites\all\modules\contrib\cck\content.module on line 1213."

refers to cck fields and Biblio doesn't have any of those.

Comment #3

lan commented 23 January 2012 at 20:27

Thanks for your response. My site doesn't use Biblio module but we have our own custom Import Publications module, it sets up auto updating the publications file every morning, and these error log messages are showing in the meantime that i mentioned in the first post. As there are no error message showing before I updated admin_menu, jquery_ui, module_grants,webform and views modules, I don't know what is wrong. Please help me out to solve the problem.

Many thanks,
Lan

Comment #4

rjerome commented 23 January 2012 at 21:47

Well as I said before, the first one is fairly self evident. What ever is generating that watchdog message (perhaps your "custom Import Publications" module is using an invalid value for the $type argument. Although it doesn't say so in the documentation, the "type" string cannot exceed 16 characters in length and "import_publications" is 19 characters.

The second error indicates that there is no value for 'nid' in the data being saved, why it has no value is impossible for me to say without seeing the code.

Ron.