OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



2.0.1 import problem

Are you an Editor, Author, or Journal Manager in need of help? Want to talk to us about workflow issues? This is your forum.

Moderators: jmacgreg, michael, vgabler, John

Forum rules
This forum is meant for general questions about the usability of OJS from an everyday user's perspective: journal managers, authors, and editors are welcome to post questions here, as are librarians and other support staff. We welcome general questions about the role of OJS and how the workflow works, as well as specific function- or user-related questions.

What to do if you have general, workflow or usability questions about OJS:

1. Read the documentation. We've written documentation to cover from OJS basics to system administration and code development, and we encourage you to read it.

2. take a look at the tutorials. We will continue to add tutorials covering OJS basics as time goes on.

3. Post a question. Questions are always welcome here, but if it's a technical question you should probably post to the OJS Technical Support subforum; if you have a development question, try the OJS Development subforum.

2.0.1 import problem

Postby pashton » Sat Jul 09, 2005 8:27 am

Hi

When I run the import script I get this (see below), any ideas very welcome.

Regards
Paul Ashton

Warning: set_time_limit(): Cannot set time limit in safe mode in /home/cosmosan/public_html/ojs2/classes/site/ImportOJS1.inc.php on line 124

Warning: getimagesize(/home/cosmosan/public_html/ojs/images/custom/ojs_home_title.gif): failed to open stream: Permission denied in/home/cosmosan/public_html/ojs2/classes/site/ImportOJS1.inc.php on line 1347

Warning: copy(/home/cosmosan/public_html/ojs/images/custom/ojs_home_title.gif): failed to open stream: Permission denied in/home/cosmosan/public_html/ojs2/classes/file/FileManager.inc.php on line 134
Failed to copy file /home/cosmosan/public_html/ojs/images/custom/ojs_home_title.gif
Warning: getimagesize(/home/cosmosan/public_html/ojs/images/custom/ojs_title.gif): failed to open stream: Permission denied in/home/cosmosan/public_html/ojs2/classes/site/ImportOJS1.inc.php on line 1347

Warning: copy(/home/cosmosan/public_html/ojs/images/custom/ojs_title.gif): failed to open stream: Permission denied in/home/cosmosan/public_html/ojs2/classes/file/FileManager.inc.php on line 134
Failed to copy file /home/cosmosan/public_html/ojs/images/custom/ojs_title.gif
Notice: Uninitialized string offset: 0 in /home/cosmosan/public_html/ojs2/classes/site/ImportOJS1.inc.php on line 434

Notice: Uninitialized string offset: 0 in /home/cosmosan/public_html/ojs2/classes/site/ImportOJS1.inc.php on line 434

Notice: Uninitialized string offset: 0 in /home/cosmosan/public_html/ojs2/classes/site/ImportOJS1.inc.php on line 434

Notice: Uninitialized string offset: 0 in /home/cosmosan/public_html/ojs2/classes/site/ImportOJS1.inc.php on line 434

Notice: Uninitialized string offset: 0 in /home/cosmosan/public_html/ojs2/classes/site/ImportOJS1.inc.php on line 434
DB Error: Unknown column 'Array' in 'field list'
pashton
 
Posts: 38
Joined: Fri Dec 17, 2004 5:51 pm

Postby kevin » Sat Jul 09, 2005 11:54 am

I can see at least two problems:

1) You are apparently running PHP in "safe mode". This may or may not be a problem, as it's not something that PKP has tested. If this is a server you control then I suggest disabling it.

2) The user you are running the import script as does not have filesystem permissions to access /home/cosmosan/public_html/ojs/images/custom

I'm not sure with the information you've provided what could cause the "Uninitialized string offset" or "DB Error" warnings (I suspect they're related). If you set "debug = On" in the database section of config.inc.php that should print the database query that fails.

What version of PHP are you using, by the way?
kevin
 
Posts: 338
Joined: Tue Oct 14, 2003 8:23 pm

install probs

Postby pashton » Sun Jul 10, 2005 5:40 pm

Hi Kevin,

Thanks for your prompt reply. I have posted a response a couple of times to your message but they don't seem to be appearing on the BB. Anyway, here is some info that may help.

1) Yes safe mode is on and unfortunately I cannot get it turned off.

2) Yes for some reason when ojs 1.x uploaded the images to the custom folder it created a set of permissions that could not be altered, but I have fixed that problem now.

3) I am using PHP version 4.3.10 and MySQL version 4.0.22-standard

4) If you need any more info usernames etc to help me just let me know. I realise that only limited help is possible but we hope to put the first issue out in the next week or so and would like to start off with v2 so any help is really appreciated.

5) I have pasted the debug code here. I have copied a small portion to the top as I think that is the key piece, but the whole debug code is below.

thanks again
Paul


1054: Unknown column 'Array' in 'field list'

adodb_mysql._execute(INSERT INTO journal_settings
(journal_id, setting_name, setting_value, setting_type)
VALUES
('2', 'sponsors', Arr...) % line 838, file: adodb.inc.php
adodb_mysql.execute(INSERT INTO journal_settings
(journal_id, setting_name, setting_value, setting_type)
VALUES
(?, ?, ?, ?), Array[4]) % line 107, file: DAO.inc.php
journalsettingsdao.update(INSERT INTO journal_settings
(journal_id, setting_name, setting_value, setting_type)
VALUES
(?, ?, ?, ?), Array[4]) % line 144, file: JournalSettingsDAO.inc.php
journalsettingsdao.updatesetting(2, sponsors, Array[3], Array[2]) % line 435, file: ImportOJS1.inc.php
importojs1.importjournal() % line 158, file: ImportOJS1.inc.php

DB Error: Unknown column 'Array' in 'field list'







HERE IS THE WHOLE THING

(mysql): SELECT * FROM sessions WHERE session_id = 'c29e1193fd4d92f89b09d4a08df2a35f' (mysql): SELECT * FROM users WHERE user_id = '1'
Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/cosmosan/public_html/ojs2/lib/adodb/adodb.inc.php:379) in /home/cosmosan/public_html/ojs2/classes/session/SessionManager.inc.php on line 56

Warning: Cannot modify header information - headers already sent by (output started at /home/cosmosan/public_html/ojs2/lib/adodb/adodb.inc.php:379) in /home/cosmosan/public_html/ojs2/classes/session/SessionManager.inc.php on line 193
(mysql): UPDATE sessions SET user_id = '1', ip_address = '140.159.4.1', user_agent = 'Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)', created = '1121041625', last_used = 1121041753, remember = 1, data = 'userId|s:1:\"1\";username|s:5:\"admin\";' WHERE session_id = 'c29e1193fd4d92f89b09d4a08df2a35f'
Warning: set_time_limit(): Cannot set time limit in safe mode in /home/cosmosan/public_html/ojs2/classes/site/ImportOJS1.inc.php on line 124
(mysql): SELECT * FROM journals WHERE path = 'ch5' (mysql): INSERT INTO journals (title, description, path, seq) VALUES ('Cosmos and History: The Journal of Natural and Social Philosophy', NULL, 'ch5', 0) (mysql): SELECT LAST_INSERT_ID() (mysql): SELECT journal_id FROM journals ORDER BY seq (mysql): UPDATE journals SET seq = 1 WHERE journal_id = '2' (mysql): UPDATE journals SET seq = 2 WHERE journal_id = '1' (mysql): SELECT u.* FROM users AS u, roles AS r WHERE u.user_id = r.user_id AND r.role_id = 1 ORDER BY u.last_name, u.first_name (mysql): INSERT INTO roles (journal_id, user_id, role_id) VALUES ('2', '1', 16) (mysql): SELECT * FROM site (mysql): INSERT INTO rt_versions (journal_id, version_key, locale, title, description) VALUES ('2', 'Agriculture', 'en_US', 'Agriculture', 'The Reading Tools can help readers of this study consult a wide range of related resources that can provide a context for interpreting, situating and evaluating the study.') (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_contexts (version_id, title, abbrev, description, author_terms, define_terms, seq) VALUES ('20', 'Author\'s Other Works', 'Other Works', 'Identify other works by the article\'s author(s) by using OAI engines.', 1, 0, 0) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('286', 'OAIster (Open Archives Inititive research databases)', 'OAIster is a project of the University of Michigan Digital Library Production Services, and provides searching a wide variety of collections from a wide variety of institutions. These institutions have made the records of their digital resources available to access, and the project team has gathered and aggregated them into the OAIster service.', 'http://oaister.umdl.umich.edu/', 'http://oaister.umdl.umich.edu/cgi/b/bib/bib-idx?type=boolean&size=10&c=oaister&q1=&rgn1=entire+record&op2=and&q2=&rgn2=entire+record&op3=And&q3=&rgn3=title&op4=And&rgn4=author&op5=And&q5=&rgn5=subject&op6=And&rgn6=norm&q6=all+types&sort=author%2Fcreator&submit2=search&q4=', NULL, 0) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('286', 'PlantFacts', 'PlantFacts includes guides for answering plant-related questions from 46 different universities and government institutions across the United States and Canada. Over 20, 000 pages of Extension fact sheets and bulletins provide a concentrated source of plant-related information. PlantFacts has merged several digital collections developed at Ohio State University to become an international knowledge bank and multimedia learning center.', 'http://plantfacts.osu.edu/', 'http://plantfacts.osu.edu/action.lasso?-Layout=input&-Search=-nothing&-Response=results_list2.lasso&-AnyError=error.lasso&searchitem=', NULL, 1) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('286', 'Rice bibliography', 'The Rice Bibliography was begun in 1961 and is now the world\'s largest source of scientific information about rice. Almost 8, 000 new references are added each year and these cover all subjects related to rice culture.', 'http://ricelib.irri.cgiar.org:81/search/w', 'http://ricelib.irri.cgiar.org:81/search/a?SEARCH=', NULL, 2) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('286', 'AgNIC', 'AgNIC is a guide to quality agricultural information on the Internet as selected by the National Agricultural Library, Land-Grant Universities, and other institutions.', 'http://www.agnic.org/agnic/index_html', 'http://www.central.agnic.org/cgi-bin/search.pl?database=ALL&caseful=off&stemming=on&ranking=on&view=simple&maxserver=8&method=any&referrals=on&templatetype=all&x=23&y=11&query=', NULL, 3) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('286', 'Public Knowledge Project Open Archives Harvester', 'The PKP Open Archives Harvester is a free metadata indexing system developed by the Public Knowledge Project through its federally funded efforts to expand and improve access to research. The PKP OAI Harvester allows you to create a searchable index of the metadata from Open Archives Initiative-compliant archives, such as sites using Open Journal Systems or Open Conference Systems.', 'http://pkp.sfu.ca/harvester/', 'http://pkp.sfu.ca/harvester/search.php?limit=author&query=', NULL, 4) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('286', 'AgEcon Search: Research in agricultural Economics', 'AgEcon Search is designed to electronically distribute reports of scholarly research in the field of agricultural economics.', 'http://agecon.lib.umn.edu/', 'http://agecon.lib.umn.edu/cgi-bin/view.pl?bool=AND&fields=author&detail=0&keywords=', NULL, 5) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('286', 'The Digital Library of the Commons (DLC)', 'DLC is a gateway to the international literature on the commons . This site contains a Working Paper Archive of author-submitted papers, as well as full-text conference papers, dissertations, working papers and pre-prints, and reports.', 'http://dlc.dlib.indiana.edu/', 'http://dlc.dlib.indiana.edu/perl/search?abstract%2Fagency%2Fauthors%2Fconfdates%2Fconference%2Fconfloc%2Fcountry%2Fdiscipline%2Feditors%2Fkeywords%2Flanguage%2Fresearch%2Fseries%2Fsubjecttext%2Fthesistype%2Ftitle%2Fyear_srchtype=ALL&_action_search=Search&abstract%2Fagency%2Fauthors%2Fconfdates%2Fconference%2Fconfloc%2Fcountry%2Fdiscipline%2Feditors%2Fkeywords%2Flanguage%2Fresearch%2Fseries%2Fsubjecttext%2Fthesistype%2Ftitle%2Fyear=', NULL, 6) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('286', 'FAS online', 'The Foreign Agricultural Service (FAS) of the U.S. Department of Agriculture (USDA) produces hundreds of documents each year that chart and analyze production, consumption, trade flows, and market opportunities for about 100 agricultural products. Includes market-and commodity-specific reports, data and statistics, news, trade leads, information on export and import programs, and more.', 'http://www.fas.usda.gov/fassearch.asp', 'http://www.fas.usda.gov/FASSearch_results_H.asp?SearchString=', NULL, 7) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('286', 'PESTIS document database', 'The Pesticide Information Service (PESTIS) is an on-line database for the pesticide use reform and sustainable agriculture communities, made available on the EcoNet computer network. It contains over 400 news items, action alerts, newsletter articles and fact sheets.', 'http://www.panna.org/resources/pestis.html', 'http://www.panna.org/system/searchResults.html?p=1&lang=en&include=&exclude=&penalty=.05&mode=&searchScope=all&q=', NULL, 8) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('286', 'Common Names for Plant Diseases', 'This resource is an electronic version of: Common names for plant diseases, 1994. Published: St. Paul, Minn.: APS Press, 1994. This compilation provides an updated, combined version of lists of names published in Phytopathology News and Plant Disease.', 'http://www.apsnet.org/online/common/', 'http://www.apsnet.org/online/common/query.asp', 'scope=/online/common/names/&FreeText=on&SearchString=', 9) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('286', 'Vegetable MD online', 'Vegetable MD Online was developed to provide access to the many Vegetable Disease Fact Sheets produced over the years by Media Services at Cornell. The addition of color photographs enhances the use of these sheets for plant disease diagnosis. The fact sheets also include information about planting methods, irrigation, weed control, insects, handling, field selection, and other issues related to vegetables and their cultivation.', 'http://vegetablemdonline.ppath.cornell.edu/Vegmd.asp', 'http://vegetablemdonline.ppath.cornell.edu/Vegmd.asp?target=', NULL, 10) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('286', 'VITIS-VEA', 'VITIS-VEA, Viticulture and Enology Abstracts is an international German or English-language publications database in the field of viticulture and enology. It covers grapevine morphology, physiology, and biochemistry, soil science, genetics and grapevine breeding, phytopathology and grapevine protection, cellar techniques, economics of viticulture and enology, and the microbiology of wine.', 'http://vitis-vea.zadi.de/stichwortsuche_eng.htm', 'http://vitis-vea.zadi.de/VITISVEA_ENG/SDF?STICHWORT_O=includes&FORM_F1=AUT1&FORM_SO=Ascend&STICHWORT=', NULL, 11) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('286', 'World Agricultural Information Centre (WAICENT)', 'This site contains information management and dissemination on desertification, gender and sustainable development, food standards, animal genetic resources, post-harvest operations, agro-biodiversity and food systems in urban centres.', 'http://www.fao.org/waicent/index_en.asp', 'http://www.fao.org/waicent/search/simple_s_result.asp?publication=1&webpage=2&photo=3&press=5&CGIAR=1&QueryString=', NULL, 12) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('286', 'FAO document repository', 'FAO Document Repository collects and disseminates on the Internet full FAO documents and publications as well as selected non-FAO publications. Three types of searches are provided and several language options are available.', 'http://www.fao.org/documents/', 'http://www.fao.org/documents/advanced_s_result.asp?form_c=AND&RecordsPerPage=50&QueryString=', NULL, 13) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_contexts (version_id, title, abbrev, description, author_terms, define_terms, seq) VALUES ('20', 'Define Terms', 'Define Terms', 'Double click on any word in the text and it will appear in the \"Define Terms\" box. You can also type or paste a word into the box. Then use the search function to find a definition for the word. These resources have been selected because of their relevance and their open (free) access to all or part of their contents.', 0, 1, 1) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('287', 'FAO Glossary of Biotechnology for Food and Agriculture', 'This site provides a tabbed list of words and their definitions, but no search function. Online searches are free. There is a bound book version of the dictionary available for sale.', 'http://www.fao.org/biotech/index_glossary.asp', 'http://www.fao.org/biotech/find-form-n.asp', 'terms=', 0) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('287', 'NAL Agricultural Thesaurus', 'NAL Agricultural Thesaurus was created to meet the needs of the United States Department of Agriculture (USDA), Agricultural Research Service (ARS), for an agricultural thesaurus. NAL Agricultural Thesaurus is for anyone describing, organizing and classifying agricultural resources such as: books, articles, catalogs, databases, patents, games, educational materials, pictures, slides, film, videotapes, software, other electronic media, or websites. It is organized into 17 subject categories.', 'http://agclass.nal.usda.gov/agt/agt.htm', 'http://agclass.nal.usda.gov/mtmcgi80.dll?k=6&l=1&n=100&t=1&s=2&w=', NULL, 1) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('287', 'Merriam-Webster Online', 'A dictionary based on the Webster 10th Collegiate edition, 1993, with updates added annually. More than 160, 000 entries. Each word is accompanied by definition, pronunciation, usage, grammatical function, and a brief etymology. Includes a thesaurus. Misspellings return suggested spellings. The dictionary\'s search system supports internal wildcards and right hand truncation searching. Includes an extensive pronunciation guide and sound files for the pronunciation of many terms.', 'http://www.merriam-webster.com/', 'http://www.merriam-webster.com/cgi-bin/dictionary?book=Dictionary&va=', NULL, 2) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('287', 'OneLook Dictionaries', 'OneLook is a meta-dictionary. Enter an English language \nword or acronym, and OneLook will search its index of 5, 292, 362 words in 934 \ndictionaries indexed in general and special interest dictionaries for the \ndefinition.', 'http://www.onelook.com/index.html', 'http://www.onelook.com/?ls=a&w=', NULL, 3) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_contexts (version_id, title, abbrev, description, author_terms, define_terms, seq) VALUES ('20', 'Related Studies', 'Related Studies', 'Access to related studies by establishing a working link with an open-access (free) database, with abstracts and/or full texts related to your topic.', 0, 0, 2) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('288', 'AgEcon Search: Research in agricultural Economics', 'AgEcon Search is designed to electronically distribute reports of scholarly research in the field of agricultural economics.', 'http://agecon.lib.umn.edu/', 'http://agecon.lib.umn.edu/cgi-bin/view.pl?bool=AND&fields=key&detail=0&keywords=', NULL, 0) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('288', 'CropSEARCH', 'Index to plant lists of hundreds of crop species.', 'http://www.hort.purdue.edu/newcrop/SearchEngine.html', 'http://index.cc.purdue.edu:8765/query.html?col=pumerge&charset=iso-8859-1&ht=0&qp=%2Bsite%3Ahort.purdue.edu&qs=&qc=&pw=100%25&ws=0&la=en&qm=0&st=1&nh=10&lk=1&rf=0&rq=0&si=0&puhead=header.html&pufoot=footer.html&qt=', NULL, 1) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('288', 'The Digital Library of the Commons (DLC)', 'DLC is a gateway to the international literature on the commons . This site contains a Working Paper Archive of author-submitted papers, as well as full-text conference papers, dissertations, working papers and pre-prints, and reports.', 'http://dlc.dlib.indiana.edu/', 'http://dlc.dlib.indiana.edu/perl/search?abstract%2Fagency%2Fauthors%2Fconfdates%2Fconference%2Fconfloc%2Fcountry%2Fdiscipline%2Feditors%2Fkeywords%2Flanguage%2Fresearch%2Fseries%2Fsubjecttext%2Fthesistype%2Ftitle%2Fyear_srchtype=ALL&_action_search=Search&abstract%2Fagency%2Fauthors%2Fconfdates%2Fconference%2Fconfloc%2Fcountry%2Fdiscipline%2Feditors%2Fkeywords%2Flanguage%2Fresearch%2Fseries%2Fsubjecttext%2Fthesistype%2Ftitle%2Fyear=', NULL, 2) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('288', 'FAS online', 'The Foreign Agricultural Service (FAS) of the U.S. Department of Agriculture (USDA) produces hundreds of documents each year that chart and analyze production, consumption, trade flows, and market opportunities for about 100 agricultural products. Includes market-and commodity-specific reports, data and statistics, news, trade leads, information on export and import programs, and more.', 'http://www.fas.usda.gov/fassearch.asp', 'http://www.fas.usda.gov/FASSearch_results_H.asp?SearchString=', NULL, 3) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('288', 'PESTIS document database', 'The Pesticide Information Service (PESTIS) is an on-line database for the pesticide use reform and sustainable agriculture communities, made available on the EcoNet computer network. It contains over 400 news items, action alerts, newsletter articles and fact sheets.', 'http://www.panna.org/resources/pestis.html', 'http://www.panna.org/system/searchResults.html?p=1&lang=en&include=&exclude=&penalty=.05&mode=&searchScope=all&q=', NULL, 4) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('288', 'PlantFacts', 'PlantFacts includes guides for answering plant-related questions from 46 different universities and government institutions across the United States and Canada. Over 20, 000 pages of Extension fact sheets and bulletins provide a concentrated source of plant-related information. PlantFacts has merged several digital collections developed at Ohio State University to become an international knowledge bank and multimedia learning center.', 'http://plantfacts.osu.edu/', 'http://plantfacts.osu.edu/action.lasso?-Layout=input&-Search=-nothing&-Response=results_list2.lasso&-AnyError=error.lasso&searchitem=', NULL, 5) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('288', 'National PLANTS database', 'Focuses on the vascular and nonvascular plants of the United States and its territories. The PLANTS database includes checklists, distributional data, crop information, plants symbols, plant growth data, references and other plant information.', 'http://plants.usda.gov/', 'http://plants.usda.gov/cgi_bin/plant_search.cgi?mode=Common%20Name&go=go&keywordquery=', NULL, 6) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('288', 'Common Names for Plant Diseases', 'This resource is an electronic version of: Common names for plant diseases, 1994. Published: St. Paul, Minn.: APS Press, 1994. This compilation provides an updated, combined version of lists of names published in Phytopathology News and Plant Disease.', 'http://www.apsnet.org/online/common/', 'http://www.apsnet.org/online/common/query.asp', 'scope=/online/common/names/&FreeText=on&SearchString=', 7) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('288', 'Rice bibliography', 'The Rice Bibliography was begun in 1961 and is now the world\'s largest source of scientific information about rice. Almost 8, 000 new references are added each year and these cover all subjects related to rice culture.', 'http://ricelib.irri.cgiar.org:81/search/w', 'http://ricelib.irri.cgiar.org:81/search/w?SEARCH=', NULL, 8) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('288', 'Vegetable MD online', 'Vegetable MD Online was developed to provide access to the many Vegetable Disease Fact Sheets produced over the years by Media Services at Cornell. The addition of color photographs enhances the use of these sheets for plant disease diagnosis. The fact sheets also include information about planting methods, irrigation, weed control, insects, handling, field selection, and other issues related to vegetables and their cultivation.', 'http://vegetablemdonline.ppath.cornell.edu/Vegmd.asp', 'http://vegetablemdonline.ppath.cornell.edu/Vegmd.asp?target=', NULL, 9) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('288', 'VITIS-VEA', 'VITIS-VEA, Viticulture and Enology Abstracts is an international German or English-language publications database in the field of viticulture and enology. It covers grapevine morphology, physiology, and biochemistry, soil science, genetics and grapevine breeding, phytopathology and grapevine protection, cellar techniques, economics of viticulture and enology, and the microbiology of wine.', 'http://vitis-vea.zadi.de/stichwortsuche_eng.htm', 'http://vitis-vea.zadi.de/VITISVEA_ENG/SDF?STICHWORT_O=includes&FORM_F1=AUT1&FORM_SO=Ascend&STICHWORT=', NULL, 10) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_contexts (version_id, title, abbrev, description, author_terms, define_terms, seq) VALUES ('20', 'Government', 'Government', 'Check various government resources.', 0, 0, 3) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('289', 'Access to Australian Government Information and Services', 'The Australian Government Entry Point offers comprehensive and integrated access to Australian Government information and services. You will find a concentrated body of Australian Government information through this site. <a href=\"http://www.australia.gov.au\">www.australia.gov.au</a> currently signposts over 700 Australian Government web sites, indexes more than 5, 000, 000 pages and uses both metadata and full text indexing to ensure it is a comprehensive government portal.', 'http://www.fed.gov.au', 'http://govsearch.australia.gov.au/search/search.cgi?collection=gov&form=au&query=&query_phrase=&query_or=&query_not=&meta_f_sand=&scope=&fscope=512&num_ranks=20&chksummary=chksummary&query_and=', NULL, 0) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('289', 'Canadian Government Information', 'Includes links to Canadian government libraries, federal documents and news releases, publications catalogues, and provincial governments. Most information is in English, but some of the linked material is in French, or a combination of French and English.', 'http://www.nlc-bnc.ca/8/4/index-e.html', 'http://www.collectionscanada.ca/search/006001-110.01-e.php?q%5B1%5D=pagelevel%3A1&q%5B2%5D=&x=15&y=13&q%5B0%5D=', NULL, 1) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('289', 'Directgov', 'Directgov is a government service giving people access to the latest and widest range of public service information in one place on the Web and on Digital TV. Directgov uses the specifications formulated and consulted on through UK GovTalk.', 'http://www.direct.gov.uk', 'http://www.direct.gov.uk/AdvancedSearch/SearchResults/fs/en?NP=1&PO1=C&PI1=W&PF1=A&PG=1&RP=20&SC=__dgov_site&Z=1&PT1=', NULL, 2) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('289', 'Info4local.gov.uk', 'Information for local government from central government. This site gives local authorities a quick and easy way to find relevant information on the web sites of central government departments, agencies and public bodies. It includes extensive information on implementing electronic government.', 'http://www.info4local.gov.uk', 'http://www.info4local.gov.uk/searchresults.asp?formname=frmAdvanced&keywordstype=1&month=&year=&pub=1&news=1&links=1&allsubjects=1&alldepts=1&alldoctypes=1&keywords=', NULL, 3) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('289', 'The New Zealand government portal', 'The New Zealand government portal is a website providing search capability for, and links into the online and offline information and services of most government agencies. This site is managed and maintained by the State Services Commission, a New Zealand government department.', 'http://www.govt.nz', 'http://www.govt.nz/search?type=spider&t=spider&q=', NULL, 4) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('289', 'Europa', 'Current information on the member countries of the European Union, including statistical data, policies, news, official documents, legal texts, and other publications.', 'http://europa.eu.int/index_en.htm', 'http://europa.eu.int/geninfo/query/engine/search/query.pl?action=FilterSearch&filter=europaflt.hts&Collection=fullEUROPA&ResultTemplate=europarslt_ascii.hts&ResultCount=25&ResultMaxDocs=200&DefaultLG=en&ViewTemplate=europaview.hts&QueryText=', NULL, 5) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('289', 'The Global Legal Information Network (GLIN)', 'The Global Legal Information Network (GLIN) is a database of laws, regulations, judicial decisions, and other complementary legal sources contributed by governmental agencies and international organizations. These GLIN members contribute the official full texts of published documents to the database in their original language. Each document is accompanied by a summary in English and subject terms selected from the multilingual index to GLIN.', 'http://www.glin.gov', 'http://www.glin.gov/search.do?refineQuery=&offset=0&refineQueryType=&fromSearch=true&queryType=ALL&searchBtn=Search&includeAllFields=on&searchAll=on&sumLanguage=any&pubLanguage=any&pubJurisdiction=any&publicationJurisdictionExclude=false&searchPublicationDate=true&dateFromDay=01&dateFromMonth=01&dateFromYear=&dateToDay=01&dateToMonth=01&dateToYear=&subjTerm=&subjTermConjunction%5B0%5D=AND&subjTerm=&subjTermConjunction%5B1%5D=AND&subjTerm=&subjTermConjunction%5B2%5D=AND&subjTerm=&subjTermConjunction%5B3%5D=AND&subjTerm=&searchOrder=default&hitsPerPage=10&showSummary=on&queryString=', NULL, 6) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_contexts (version_id, title, abbrev, description, author_terms, define_terms, seq) VALUES ('20', 'Book', 'Book', 'Book-related Resources', 0, 0, 4) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('290', 'Google Print', 'Google is working with libraries at the University of Michigan, Harvard University, Stanford University, Oxford University and the New York Public Library to digitize books in their collections and make them accessible via Google Print, a massive scanning project that will bring millions of volumes of printed books into the Google Print database. Click a book title and you\'ll see the page of the book that has your search terms, your can search for more information within that specific book, find reviews, find related information, learn about the publisher, buy this book, and find nearby libraries that have it.', 'http://print.google.com', 'http://print.google.com/print?q=', NULL, 0) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('290', 'Online Books Page', 'Online Books Page, edited by John Mark Ockerbloom, at the University of Pennsylvania. This is an excellent starting point in the search for full-text books on the Internet. Over 20, 000 English works in various formats available online at different sites. Entries may be searched by author or title. An interesting feature allows browsing by Library of Congress call number categories. New listings are added regularly and are listed on a separate web page at <a href=\"http://onlinebooks.library.upenn.edu/new.html\">http://onlinebooks.library.upenn.edu/new.html</a>.', 'http://digital.library.upenn.edu/books/', 'http://onlinebooks.library.upenn.edu/webbin/book/search?tmode=words&title=', NULL, 1) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('290', 'Books-On-Line', 'A collection of over 32935 titles, although some are only excerpts. Browse by subject or search by author or title. Not all items are free.', 'http://www.books-on-line.com/', 'http://www.books-on-line.com/bol/KeyWordSearch.cfm?RowCount=50&Searchquery=', NULL, 2) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('290', 'Universal Library', 'The Universal Library is considerably more involved, and more ambitious -- it has amassed a collection of 100, 000 e-books (some of them from Project Gutenberg), and is aiming for 1 million e-books by the end of 2006.', 'http://delta.ulib.org/html/index.html', 'http://serv.ul.cs.cmu.edu/cgi-bin/srcfull.pl?search=', NULL, 3) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_contexts (version_id, title, abbrev, description, author_terms, define_terms, seq) VALUES ('20', 'Dictionary', 'Dictionary', 'Find definitions for terms using these resources.', 0, 0, 5) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('291', 'Wikipedia: The Free Encyclopedia', '\"Wikipedia is a free content encyclopedia that is being written collaboratively by contributors from all around the world. The site is a WikiWiki, meaning that anyone ... can edit any article. ...\" Without editorial oversight, the quality of the content on this site varies dramatically, but it is worth exploring. The English version has hundreds of thousands of entries. Spanish, French, and Esperanto are among the several other languages offered.', 'http://en.wikipedia.org/wiki/Main_Page', 'http://en.wikipedia.org/wiki/Special:Search?go=Go&fulltext=Search&search=', NULL, 0) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('291', 'Infoplease.com', 'This site includes contents of the Information Please Almanacs, a biography database, a dictionary, an atlas, and articles from the Columbia Encyclopedia. You can search these ready reference works together or separately or browse the Almanacs. There are feature stories each week covering topics in the news, with links to pertinent Almanac content and other Web resources.', 'http://www.infoplease.com', 'http://www.infoplease.com/search?fr=iptn&in=all&x=0&y=0&query=', NULL, 1) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_contexts (version_id, title, abbrev, description, author_terms, define_terms, seq) VALUES ('20', 'Portals', 'Portals', 'Offer an entry point to other websites.', 0, 0, 6) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('292', 'AgNIC', 'AgNIC is a guide to quality agricultural information on the Internet as selected by the National Agricultural Library, Land-Grant Universities, and other institutions.', 'http://www.agnic.org/', 'http://www.central.agnic.org/cgi-bin/search.pl?database=ALL&caseful=off&stemming=on&ranking=on&view=simple&maxserver=8&method=any&referrals=on&templatetype=all&x=23&y=11&query=', NULL, 0) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('292', 'AGRICOLA articles (NAL Web: 1982- )', 'AGRICOLA covers the areas of agriculture, agricultural administration, agricultural laws and legislation, agricultural regulations, agricultural economics, agricultural education and training, agricultural extension and advisory work, agricultural engineering, agricultural products, animal science, entomology, aquatic science, fisheries, feed science, food science, food products, forestry, geography, meteorology, climatology, history, home economics, human ecology, household textiles and clothing, human nutrition, natural resources, pesticides, plant science, pollution, soil science, rural sociology, rural development, and human parasitology. It indexes journal articles and other publications as well as audiovisual materials, maps, books, software, conference proceedings, theses, research reports and government documents.', 'http://agricola.nal.usda.gov/', 'http://agricola.nal.usda.gov/cgi-bin/Pwebrecon.cgi?DB=local&CNT=25&Search_Code=GKEY&STARTDB=AGRIDB&Search_Arg=', NULL, 1) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('292', 'AgriSurf! - The Farmers Search Engine', 'From family farms to agribusiness, almost 20, 000 sites \"hand picked by agricultural experts\" are arranged in categories, indexed, rated for speed and reliability of access, labeled with the flag of their country of origin, and may be searched using keywords. Annotations are taken from the sites\' self-descriptions.', 'http://www.agrisurf.com/agrisurfscripts/agrisurf.asp?index=_25', 'http://www.agrisurf.com/agrisurfscripts/search.asp?index=_25&rbtn=ALL&ft=on&SearchString=', NULL, 2) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('292', 'Farms.com', 'Established in 1995, Farms.com has been instrumental in the development of the Agricultural Internet. Now recognized throughout North America as the leading Agriculture Internet resource, Farms.com has successfully combined agri-business experience with the vast power of the Internet to provide producers with the information, services, and markets they need to make sound business decisions and increase profitability.', 'http://canada.eharvest.com/', 'http://www.agrisurf.com/agrisurfscripts/inc/farms/search.asp?index=_25&rbtn=ALL&ft=on&SearchString=', NULL, 3) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('292', 'Scirus', 'Scirus is the most comprehensive science-specific search engine on the Internet. Driven by the latest search engine technology, Scirus searches over 150 million science-specific Web pages.', 'http://www.scirus.com/srsapp/', 'http://www.scirus.com/search_simple/?frm=simple&dsmem=on&dsweb=on&wordtype_1=phrase&query_1=', NULL, 4) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('292', 'World Agricultural Information Centre (WAICENT)', 'This site contains information management and dissemination on desertification, gender and sustainable development, food standards, animal genetic resources, post-harvest operations, agro-biodiversity and food systems in urban centres.', 'http://www.fao.org/waicent/index_en.asp', 'http://www.fao.org/waicent/search/simple_s_result.asp?publication=1&webpage=2&photo=3&press=5&CGIAR=1&QueryString=', NULL, 5) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('292', 'AgriFor (uK)', 'AgriFor is a gateway to evaluated, quality Internet resources in agriculture, food and forestry, aimed at students, researchers, academics and practitioners in agriculture, food or forestry. AgriFor is created by a core team of information specialists and subject experts based at the University of Nottingham Greenfield Medical Library, in partnership with key organizations throughout the UK and further afield.', 'http://agrifor.ac.uk/', 'http://agrifor.ac.uk/cgi/biome-search/search.cgi?formtype=advanced&zport=2169&sortBy=relevance&category=Any&batch_size=10&titles_only=on&term=', NULL, 6) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('292', 'Agriculture 21', 'Contains news and features on agricultural and food-supply issues worldwide, as well as downloadable publications, links to databases, subject guides, and access to divisions of the FAO Agriculture Department. Includes search engine.', 'http://www.fao.org/ag/', 'http://www.fao.org/ag/search/agfind.asp?Find=Find&SortBy=rank[d]&Scope=/ag&CiuserParam3=agfind.asp&lang=en&FMMod=any&FSRest=<&FSRestval=any&Action=Execute&SearchString=', NULL, 7) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_contexts (version_id, title, abbrev, description, author_terms, define_terms, seq) VALUES ('20', 'Databases', 'Databases', 'Provide access to open-access abstract and/or full-text databases.', 0, 0, 7) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('293', 'FAO document repository', 'FAO Document Repository collects and disseminates on the Internet full FAO documents and publications as well as selected non-FAO publications. Three types of searches are provided and several language options are available.', 'http://www.fao.org/documents/', 'http://www.fao.org/documents/advanced_s_result.asp?form_c=AND&RecordsPerPage=50&QueryString=', NULL, 0) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('293', 'National Ag Safety Database (NASD)', 'The National Ag Safety Database (NASD) is a database of materials devoted to increased safety, health and injury prevention in agriculture, listed by topic and state. Video resources are indexed, there are special listings for conference proceedings, posters and other materials.', 'http://www.cdc.gov/search.htm', 'http://search.cdc.gov/search97cgi/s97is.dll?SortField=score&Action=FilterSearch&Collection=cdcall1&ResultTemplate=nsearchresult.hts&filter=newsearch.hts&queryText=', NULL, 1) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('293', 'E-Answers', 'A collection of over 250, 000 pages of full text electronic documents from the Extension Services and Agricultural Experiment Stations of over fifteen states of the United States, searchable by keyword and by region of the country. A single-stop access to a large number of useful and reputable publications on topics in agriculture, family topics, consumer issues, environment, economics, and public policy.', 'http://e-answers.adec.edu/', 'http://e-answers.adec.edu/cgi-bin/htsearch?config=ea-all&words=', NULL, 2) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('293', 'Plants Database', 'From the U.S. Department of Agriculture Natural Resources Conservation Service, \"The PLANTS Database is a single source of standardized information about plants. . . focuse[d] on vascular plants, mosses, liverworts, hornworts, and lichens of the U.S. and its territories. The PLANTS Database includes names, checklists, automated tools, identification information, species abstracts, distributional data, crop information, plant symbols, plant growth data, plant materials information, plant links, references, and other plant information.\" An FAQ section linked to the banner provides additional information.', 'http://plants.usda.gov/', 'http://plants.usda.gov/cgi_bin/plant_search.cgi?mode=Common Name&keywordquery=', NULL, 3) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_contexts (version_id, title, abbrev, description, author_terms, define_terms, seq) VALUES ('20', 'Online Forum', 'Online Forum', 'Choose online, open-access online forums that would enrich the context of the research studies on your site.', 0, 0, 8) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('294', 'Agricultural Conferences, Meetings, Seminars Calendar', 'This calendar strives to include all major national and international agricultural meetings and others of apparent scientific importance. We will incorporate local level meetings only when they seem to be scientifically significant. Meetings outside our purview will be left to appropriate local, regional, or organization-specific calendars. We do plan to create links to such calendars when they are available. Provides a central repository for information and links to information concerning upcoming agricultural conferences, with emphasis on those of scientific significance.', 'http://laurel.nal.usda.gov:8080/agnic/Calendar/calendar', 'http://laurel.nal.usda.gov:8080/agnic/Calendar/calendar?query=', NULL, 0) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('294', 'Liszt', 'Liszt, hosted by Topica, is a free service that allows you to find, manage and participate in email lists and discussion groups in biology.', 'http://lists.topica.com/dir/?cid=187', 'http://www.liszt.com/search/?search_type=cat&query=', NULL, 1) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('294', 'MInd: the Meetings Index', 'Use this service to identify and locate the organizers and sponsors for future conferences, congresses, meetings and symposia, as well as conference proceedings (for future and past conferences).', 'http://www.interdok.com/', 'http://www.google.com/search?q=site%3Ainterdok.com+mind+', NULL, 2) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_contexts (version_id, title, abbrev, description, author_terms, define_terms, seq) VALUES ('20', 'Data', 'Data', 'Provides access to agricultural statistics.', 0, 0, 9) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('295', 'Breeds of Livestock', 'Web site allows users to search for information on livestock by world region or by species name. Data is available on cattle, horses, swine, goats, and sheep and organized as encyclopedia entries.', 'http://www.ansi.okstate.edu/breeds/', 'http://www.google.com/search?q=site%3Aansi.okstate.edu+breeds+', NULL, 0) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('295', 'USDA Economics and Statistics System', 'USDA Economics and Statistics System contains more than 400 reports and datasets from the economics agencies of the U.S. Department of Agriculture. These materials cover U.S. and international agriculture and related topics. Most reports are text files that contain time-sensitive information. Most data sets are in spreadsheet format and include time-series data that are updated yearly.', 'http://usda.mannlib.cornell.edu/', 'http://usda.mannlib.cornell.edu/cgi-bin/usda/ess_keyword.cgi/06?type=All&ERS=on&NASS=on&WAOB=on&selected=KEYWORD&query=', NULL, 1) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_contexts (version_id, title, abbrev, description, author_terms, define_terms, seq) VALUES ('20', 'Pay-per-View', 'Pay-per-View', 'A pay-per-view service is for those who do not have direct access to electronic journal articles via subscriptions. The service allows customers to gain direct access to an article by paying by credit card using the RSC\'s secure payment mechanism. Immediately the payment details have been validated, the customer can gain access to the required article file for a period of 30 days.', 0, 0, 10) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('296', 'Ingenta', 'Ingenta restricts access to full text articles. Although access to the full text costs money, the site can be used as a free index.', 'http://www.ingenta.com/', 'http://www.ingenta.com/isis/searching/Search/ingenta?database=1&title=', NULL, 0) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('296', 'ebrary', 'Independent researchers who do not have access to ebrary_ databases through their library may now set up an individual account for as little as $5. ebrary Discover spans multiple academic disciplines and provides anytime, anywhere access to over 20, 000 authoritative titles including books in full-text, sheet music, reports and other authoritative documents from more than 175 leading publishers such as Cambridge University Press, Random House, Inc., and The McGraw-Hill Companies.', 'http://www.ebrary.com/company/', 'http://shop.ebrary.com/Top?layout=search&frm=smp.x&sch=%A0%A0%A0%A0%A0Search%A0%A0%A0%A0%A0&p00=', NULL, 1) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('296', 'Questia', 'Questia provides access to over 47, 000 books and 375, 000 journal, magazine, and newspaper articles. All books and articles are available in their entirety - search every page. The subscription rate is raning from 19.05 per month to 119.95 per year.', 'http://www.questia.com', 'http://www.questia.com/SM.qst?act=search&keywordsSearchType=1000&mediaType=book&mediaType=journal&mediaType=magazine&mediaType=newspaper&mediaType=encyclopedia&mediaType=startpage&keywords=', NULL, 2) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('296', 'Wiley InterScience Pay-Per-View Service', 'Wiley InterScience Pay-Per-View affords instant, full-text access to an extensive collection of journal articles or book chapters available on Wiley InterScience without the need for a subscription. This service allows anyone to purchase access to individual journal articles or book chapters directly by using a credit card. Access is instant and available for 24 hours.', 'http://www3.interscience.wiley.com/aboutus/ppv-articleselect.html', 'http://www3.interscience.wiley.com/search/allsearch', 'allContentSearchForm=&mode=quicksearch&WISindexid1=WISall&WISsearch1=', 3) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_contexts (version_id, title, abbrev, description, author_terms, define_terms, seq) VALUES ('20', 'Media Reports', 'Media Reports', 'Immediately initiates a search based on the subject of the article or paper that connects users to free current and archival articles in the field from leading newspapers around the world.', 0, 0, 11) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('297', 'Agriculture 21', 'This site contains news and features on agricultural and food-supply issues worldwide, as well as downloadable publications, links to databases, subject guides, and access to divisions of the FAO Agriculture Department. Includes search engine.', 'http://www.fao.org/ag/', 'http://www.fao.org/ag/search/agfind.asp?SortBy=rank%5Bd%5D&Scope=%2Fag&FSRestVal=any&Action=Execute&SearchString=', NULL, 0) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('297', 'People\'s Daily', 'People\'s Daily, China (January 1999-)', 'http://english.peopledaily.com.cn/', 'http://english.peopledaily.com.cn/cgi-bin/htsearch?method=boolean&format=builtin-long&sort=score&config=english&exclude=&words=', NULL, 1) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('297', 'Globe and Mail', 'Globe and Mail, Toronto (last seven days)', 'http://www.globeandmail.com/', 'http://www.globeandmail.com/servlet/HTMLTemplate/search?tf=tgam/search/tgam/SearchResults.html&cf=tgam/search/tgam/SearchResults.cfg&current_row=1&start_row=1&num_rows=10&keywords=', NULL, 2) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('297', 'Mail & Guardian Newspaper', 'Mail & Guardian Newspaper, South Africa (1994-)', 'http://www.mg.co.za/', 'http://archive.mg.co.za/MGArchive/FrameSet.asp?f=xhitlist&xhitlist_x=Advanced&xhitlist_s=contents&xhitlist_d=&xhitlist_hc=&xhitlist_xsl=xhitlist.xsl&xhitlist_vpc=first&xhitlist_sel=title%3Bpath%3Brelevance-weight%3Bcontent-type%3Bhom&xhitlist_q=', NULL, 3) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('297', 'National Public Radio', 'National Public Radio, United States (unlimited)', 'http://www.npr.org/archives/', 'http://search1.npr.org/search97cgi/s97_cgi?ResultTemplate=simple_date.hts&SortSpec=Date+Desc+Score+Desc&ViewTemplate=docview.hts&collection=zeus&collection=C1&collection=WEB&Action=FilterSearch&filter=topic_filter.hts&x=23&y=13&QueryText=', NULL, 4) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('297', 'New York Times', 'New York Times, New York (last seven days)', 'http://www.nytimes.com/', 'http://query.nytimes.com/search/query?date=past30days&submit.x=11&submit.y=12&query=', NULL, 5) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('297', 'The Japan Times Online', 'The Japan Times Online, Japan (January 1999-)', 'http://www.japantimes.co.jp/search.htm', 'http://www.japantimes.co.jp/cgi-bin/search-intro3.pl5', 'SUBMIT=Search&term1=&radio=and&term2=', 6) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('297', 'The Moscow Times', 'The Moscow Times, Russia (1994-)', 'http://www.moscowtimes.ru/doc/Search.html', 'http://www.moscowtimes.ru/cgi-bin/search?config=&exclude=&method=and&format=long&sort=score&matchesperpage=10&words=', NULL, 7) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('297', 'Washington Post', 'Washington Post, Washington, DC (last two weeks)', 'http://www.washingtonpost.com/', 'http://www.washingtonpost.com/cgi-bin/search99.pl?searchsection=news&searchdatabase=news&x=11&y=8&searchtext=', NULL, 8) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('297', 'Newsdirectory', 'Newsdirectory is a comprehensive and searchable guide to the world\'s English-language online media. Currently over 8, 000 newspapers and magazines are listed, as well as more than 1, 000 U.S. television broadcasters.', 'http://www.newsdirectory.com/', 'http://ask.elibrary.com/search.asp?refid=NEWSD&datetype=all&srcmags=checked&srcnews=checked&srcbooks=checked&srctvrad=checked&query=', NULL, 9) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_contexts (version_id, title, abbrev, description, author_terms, define_terms, seq) VALUES ('20', 'Search Engines', 'Search Engines', 'Enter search terms for Internet resources through various search engines.', 0, 0, 12) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('298', 'Google', 'Search using the popular Google search engine.', 'http://www.google.com/', 'http://www.google.com/search?q=', NULL, 0) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('298', 'Google Scholar', 'Google Scholar enables specific searches of scholarly literature, including peer-reviewed papers, theses, books, pre-prints, abstracts, and technical reports. Content includes a range of publishers and aggregators with whom Google already has standing arrangements, e.g., the Association for Computing Machinery, IEEE, OCLC\'s Open WorldCat library locator service, etc. Result displays will show different version clusters, citation analysis, and library location (currently books only).', 'http://scholar.google.com', 'http://scholar.google.com/scholar?ie=UTF-8&oe=UTF-8&hl=en&q=', NULL, 1) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('298', 'Clusty the Clustering Engine', 'This search tool from Vivismo offers clustered results for a selection of searches. Metasearch the whole web, or use tabs to search for news, gossip, images, orproducts via Bizrate or eBay.', 'http://clusty.com/', 'http://clusty.com/search?query=', NULL, 2) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('298', 'Vivisimo', 'The award-winning Vivisimo clustering technology, developed by Carnegie Mellon research scientists, is unlocking the value of stored information at Fortune 500 companies, top websites, prestigious publishers and government agencies by categorizing research results on the fly into meaningful orders, thus achieving breakthrough improvement in access to relevant information.', 'http://vivisimo.com', 'http://vivisimo.com/search?tb=homepage&v%3Asources=Web&query=', NULL, 3) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_versions (journal_id, version_key, locale, title, description) VALUES ('2', 'Art_Architecture', 'en_US', 'Art & Architecture', 'The Reading Tools can help readers of this study consult a wide range of related resources that can provide a context for interpreting, situating and evaluating the study.') (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_contexts (version_id, title, abbrev, description, author_terms, define_terms, seq) VALUES ('21', 'Author\'s Other Works', 'Other Works', 'Identify other works by the article\'s author(s) by using OAI engines.', 1, 0, 0) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('299', 'OAIster (Open Archives Inititive research databases)', 'OAIster is a project of the University of Michigan Digital Library Production Services, and provides searching a wide variety of collections from a wide variety of institutions. These institutions have made the records of their digital resources available to access, and the project team has gathered and aggregated them into the OAIster service.', 'http://oaister.umdl.umich.edu/', 'http://oaister.umdl.umich.edu/cgi/b/bib/bib-idx?type=boolean&size=10&c=oaister&q1=&rgn1=entire+record&op2=and&q2=&rgn2=entire+record&op3=And&q3=&rgn3=title&op4=And&rgn4=author&op5=And&q5=&rgn5=subject&op6=And&rgn6=norm&q6=all+types&sort=author%2Fcreator&submit2=search&q4=', NULL, 0) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('299', 'Public Knowledge Project Open Archives Harvester', 'The PKP Open Archives Harvester is a free metadata indexing system developed by the Public Knowledge Project through its federally funded efforts to expand and improve access to research. The PKP OAI Harvester allows you to create a searchable index of the metadata from Open Archives Initiative-compliant archives, such as sites using Open Journal Systems or Open Conference Systems.', 'http://pkp.sfu.ca/harvester/', 'http://pkp.sfu.ca/harvester/search.php?limit=author&query=', NULL, 1) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('299', 'SPIRO (Architecture Slide Library, University of California - Berkeley)', 'SPIRO (slide & photograph image retrieval online) provides access to images and descriptive information about 20% of the Library\'s collection of 200, 000 35mm slides.', 'http://www.mip.berkeley.edu/query_forms/browse_spiro_form.html', 'http://www.mip.berkeley.edu/cgi-bin/browse_spiro_new/tmp?db_handle=browse_spiro&period=any&result_type=thumbnail_with_descr&name=', NULL, 2) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('299', 'GreatBuildings.com', 'This gateway to architecture around the world and across history documents a thousand buildings and hundreds of leading architects, with 3D models, photographic images and architectural drawings, commentaries, bibliographies, web links, and more, for famous designers and structures of all kinds.', 'http://www.greatbuildings.com/search.html', 'http://www.greatbuildings.com/cgi-bin/gbc-search.cgi?search=architect&architect=', NULL, 3) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('299', 'The Art, Design, Architecture & Media Information Gateway (ADAM)', 'ADAM is being developed to provide a gateway to information about fine art, design, architecture, applied arts, media, theory, museum studies and conservation and professional practice related to any of the above. It is one of the eLib Access to Network Resources (ANR) projects and received its funding from JISC. A user survey to measure information needs and search methods, annual reports, and service usage statistics are published at the site.', 'http://www.adam.ac.uk/index.html', 'http://www.adam.ac.uk/ixbin/hixserv?_IXDB_=adam&%7BUPPER%7D%24%3Fany%3A+IX_MODE+rel%3D1+%28%24any%29+INDEX+res_keywords=.&%24+with+res_pub=.&%24sort+@descending+%24%24relevance=.&%24%3F%21x%3A%28%28collection+or+item%29+in+res_granularity%29=.&_IXSPFX_=s&submit-button=SUMMARY&%24%3Dany%3D%24=', NULL, 4) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_contexts (version_id, title, abbrev, description, author_terms, define_terms, seq) VALUES ('21', 'Define Terms', 'Define Terms', 'Double click on any word in the text and it will appear in the \"Define Terms\" box. You can also type or paste a word into the box. Then use the search function to find a definition for the word. These resources have been selected because of their relevance and their open (free) access to all or part of their contents.', 0, 1, 1) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('300', 'Columbia Encyclopedia', 'Serving as a \"first aid\" for those who read, the sixth edition of the Columbia Encyclopedia contains over 51, 000 entries with 80, 000 hypertext links.', 'http://www.bartleby.com/65/', 'http://www.bartleby.com/cgi-bin/texis/webinator/65search?search_type=full&query=', NULL, 0) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('300', 'Encyclopedia.com', 'Online version of the Concise Electronic Encyclopedia. Entries are very short, so this site is better suited for fact checking than research.', 'http://www.encyclopedia.com/', 'http://www.encyclopedia.com/searchpool.asp?target=', NULL, 1) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('300', 'Merriam-Webster Online', 'A dictionary based on the Webster 10th Collegiate edition, 1993, with updates added annually. More than 160, 000 entries. Each word is accompanied by definition, pronunciation, usage, grammatical function, and a brief etymology. Includes a thesaurus. Misspellings return suggested spellings. The dictionary\'s search system supports internal wildcards and right hand truncation searching. Includes an extensive pronunciation guide and sound files for the pronunciation of many terms.', 'http://www.merriam-webster.com/', 'http://www.merriam-webster.com/cgi-bin/dictionary?book=Dictionary&va=', NULL, 2) (mysql): SELECT LAST_INSERT_ID() (mysql): INSERT INTO rt_searches (context_id, title, description, url, search_url, search_post, seq) VALUES ('300', 'OneLook Dic
pashton
 
Posts: 38
Joined: Fri Dec 17, 2004 5:51 pm

Postby kevin » Sun Jul 10, 2005 6:30 pm

Strange; could you test if changing these two lines makes any difference:

Code: Select all
--- classes/site/ImportOJS1.inc.php     10 Jul 2005 09:32:52 -0000      1.5
+++ classes/site/ImportOJS1.inc.php     11 Jul 2005 01:29:00 -0000
@@ -433,8 +433,8 @@
 
                $settingsDao = &DAORegistry::getDAO('JournalSettingsDAO');
 
-               foreach ($journalSettings as $settingName => $settingValue) {
-                       list($settingType, $settingValue) = $settingValue;
+               foreach ($journalSettings as $settingName => $settingInfo) {
+                       list($settingType, $settingValue) = $settingInfo;
                        $settingsDao->updateSetting($this->journalId, $settingName, $settingValue, $settingType);
                }
        }
kevin
 
Posts: 338
Joined: Tue Oct 14, 2003 8:23 pm

Sort of worked.

Postby pashton » Mon Jul 11, 2005 5:06 am

Hi Kevin,

Thanks that code worked (and I found another piece of code that fixed a file upload problem).

One last thing (for now!!!) when I clcik the final button in the submit article process the following error occours.

Thanks Again
Paul

Warning: mail(): SAFE MODE Restriction in effect. The fifth parameter is disabled in SAFE MODE. in/home/cosmosan/public_html/ojs2/classes/core/String.inc.php on line 155

Warning: Cannot modify header information - headers already sent by (output started at /home/cosmosan/public_html/ojs2/classes/core/String.inc.php:155) in/home/cosmosan/public_html/ojs2/classes/template/TemplateManager.inc.php on line 152
pashton
 
Posts: 38
Joined: Fri Dec 17, 2004 5:51 pm


Return to OJS Editorial Support and Discussion

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 1 guest