Solved

Cannot migrate my sql database to joomla 1.5 site

Posted on 2009-05-18
19
1,121 Views
Last Modified: 2012-05-07
Hi I am trying to migrate my 1.0 sql database into a 1.5 joomla site.
I have tried to do the migration many times now and keep getting the same error.
I don't know why the error is here, so I don't know how to fix it.
I used the migrator RC7 to download the sql file from my 1.0 site but its got the error below when I tried to migrate to the 1.5 site
---------------------------------------------------
Error at the line 235: INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '1','mainmenu','Home','index.php?option=com_frontpage','components','1','0','10','0','6','0','0000-00-00 00:00:00','0','0','0','3','num_leading_articles=1\r\nnum_intro_articles=2\r\nnum_links=1\r\nimage=1\r\nshow_page_title=0\r\npage_title=Welcome to the Frontpage\r\norderby_sec=front\r\nshow_print_icon=0\r\nshow_pdf_icon=0\r\nshow_email_icon=0\r\nback_button=0\nshow_title=1\n','home-mainmenu-1');

Query:INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '1','mainmenu','Home','index.php?option=com_frontpage','components','1','0','10','0','6','0','0000-00-00 00:00:00','0','0','0','3','num_leading_articles=1\r\nnum_intro_articles=2\r\nnum_links=1\r\nimage=1\r\nshow_page_title=0\r\npage_title=Welcome to the Frontpage\r\norderby_sec=front\r\nshow_print_icon=0\r\nshow_pdf_icon=0\r\nshow_email_icon=0\r\nback_button=0\nshow_title=1\n','home-mainmenu-1');

MySQL: Duplicate entry '1' for key 1

Stopped on error


Can anyone help me figure out why this is happening. Is there something I need to do with my 1.0 version to help create an sql file that will migrate?

I hope someone can help me.. ;0
0
Comment
Question by:Amanda Watson
  • 11
  • 8
19 Comments
 
LVL 10

Expert Comment

by:OnALearningCurve
ID: 24422228
Hi snowball77,

Looking at your insert query the VALUES section of the statemetn starts

VALUES ( '1','mainmenu'...

Looking at the error and the fact htat the filed is called ID I would geuss that this filed is classed as a unique identifier and will therfore not accept the same value for two records.


This means you are trying to insert a value of 1 into every record in the 'id' field.  I have no experience of joomla, but I would recommend either one of two options to try and resolve this.

Option 1.  If you have a unique field in your MySql table then edit your query to insert the contents of that field instead.

Option 2. Do not try to inser anything into the ID filed in the new table and it may automatically assign values as records are entered.

Hope this is some help.

Mark.
0
 
LVL 11

Author Comment

by:Amanda Watson
ID: 24426881
Hi, and thanks very much for the reply.
I have just looked at all the entries of jos_menu, it is attached.
Now I don't know how to do the things you suggested, but I was thinking maybe I could do something with the generated sql code so that it inserts.
The thing I am confused about also, is the id is there for each menu, and every menu has its own unique code, so I can't understand how two "1"' show up for example?

Is there any other option?
INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '1','mainmenu','Home','index.php?option=com_frontpage','components','1','0','10','0','6','0','0000-00-00 00:00:00','0','0','0','3','num_leading_articles=1\r\nnum_intro_articles=2\r\nnum_links=1\r\nimage=1\r\nshow_page_title=0\r\npage_title=Welcome to the Frontpage\r\norderby_sec=front\r\nshow_print_icon=0\r\nshow_pdf_icon=0\r\nshow_email_icon=0\r\nback_button=0\nshow_title=1\n','home-mainmenu-1');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '2','mainmenu','News','index.php?option=com_content&task=section&id=1','content_section','0','0','1','0','10','0','0000-00-00 00:00:00','0','0','0','3','menu_image=-1\nshow_page_title=1\npageclass_sfx=\nback_button=\ndescription_sec=1\ndescription_sec_image=1\norderby=\nother_cat_show_section=1\nempty_cat_show_section=0\nshow_category_description=1\ndescription_cat_image=1\nshow_categories=1\nshow_empty_categories=0\nshow_cat_num_articles=1\ncat_show_description=1\ndate_format=\nshow_date=\nshow_author=\nshow_hits=\nshow_headings=1\nshow_item_navigation=1\norder_select=1\nshow_pagination_limit=1\ndisplay_num=50\nfilter=1\nfilter_type=title\nunpublished=1\nshow_title=1\n','news-mainmenu-2');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '3','mainmenu','Contacts','index.php?option=com_contact&view=category&catid=0','components','1','0','7','0','20','0','0000-00-00 00:00:00','0','0','0','3','show_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\ncatid=0\nother_cat_section=1\nother_cat=1\ncat_description=1\ncat_items=1\ndescription=1\ndescription_text=\nimage=-1\nimage_align=right\nheadings=1\nshow_position=1\nshow_icon_email=0\nshow_icon_telephone=1\nshow_icon_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsessionCheck=1','contacts-mainmenu-3');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '23','mainmenu','Links','index.php?option=com_weblinks','components','1','0','4','0','19','0','0000-00-00 00:00:00','0','0','0','0','menu_image=web_links.jpg\npageclass_sfx=\nback_button=\nshow_page_title=1\npage_title=\nshow_headings=1\nshow_hits=\nitem_show_description=1\nshow_categories=1\nshow_description=1\ndescription_text=\nimage=-1\nimage_align=right\nweblink_icons=\nshow_title=1\n','links-mainmenu-23');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '6','mainmenu','Joomla! License','index.php?option=com_content&task=view&id=5','content_typed','0','0','5','0','8','0','0000-00-00 00:00:00','0','0','0','0','\nshow_title=1\nshow_page_title=1\n','joomla-license-mainmenu-6');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '7','mainmenu','News Feeds','index.php?option=com_newsfeeds','components','0','0','12','0','12','0','0000-00-00 00:00:00','0','0','0','3','menu_image=-1\npageclass_sfx=\nback_button=\nshow_page_title=1\npage_title=\nshow_title=1\n','news-feeds-mainmenu-7');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '8','mainmenu','Wrapper','index.php?option=com_wrapper','wrapper','0','0','0','0','21','0','0000-00-00 00:00:00','0','0','0','3','menu_image=-1\npageclass_sfx=\nback_button=\nshow_page_title=1\npage_title=\nscrolling=auto\nwidth=100%\nheight=600\nheight_auto=0\nurl=http://www.joomla.org\nshow_title=1\n','wrapper-mainmenu-8');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '9','mainmenu','Blog','index.php?option=com_content&task=blogsection&id=0','content_blog_section','0','0','0','0','11','0','0000-00-00 00:00:00','0','0','0','3','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=A blog of all sections with no images\nshow_page_title=1\nnum_leading_articles=0\nnum_intro_articles=6\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=0\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nsectionid=\nshow_title=1\n','blog-mainmenu-9');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '10','othermenu','Joomla! Home','http://www.joomla.org','url','0','0','0','0','5','0','0000-00-00 00:00:00','0','0','0','3','\nshow_title=1\nshow_page_title=1\n','joomla-home-othermenu-10');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '11','othermenu','Joomla! Forums','http://forum.joomla.org','url','0','0','0','0','6','0','0000-00-00 00:00:00','0','0','0','3','\nshow_title=1\nshow_page_title=1\n','joomla-forums-othermenu-11');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '12','othermenu','OSM Home','http://www.opensourcematters.org','url','0','0','0','0','7','0','0000-00-00 00:00:00','0','0','0','3','\nshow_title=1\nshow_page_title=1\n','osm-home-othermenu-12');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '24','othermenu','Administrator','administrator/','url','0','0','0','0','8','0','0000-00-00 00:00:00','0','0','0','3','menu_image=-1\nshow_title=1\nshow_page_title=1\n','administrator-othermenu-24');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '21','usermenu','Your Details','index.php?option=com_user&task=UserDetails','url','1','0','0','0','1','0','0000-00-00 00:00:00','0','0','1','3','\nshow_title=1\nshow_page_title=1\n','your-details-usermenu-21');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '13','usermenu','Submit News','index.php?option=com_content&task=new&sectionid=1&Itemid=0','url','1','0','0','0','2','0','0000-00-00 00:00:00','0','0','1','2','\nshow_title=1\nshow_page_title=1\n','submit-news-usermenu-13');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '14','usermenu','Submit WebLink','index.php?option=com_weblinks&task=new','url','1','0','0','0','3','0','0000-00-00 00:00:00','0','0','1','2','\nshow_title=1\nshow_page_title=1\n','submit-weblink-usermenu-14');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '15','usermenu','Check-In My Items','index.php?option=com_user&task=CheckIn','url','0','0','0','0','4','0','0000-00-00 00:00:00','0','0','1','2','\nshow_title=1\nshow_page_title=1\n','check-in-my-items-usermenu-15');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '16','usermenu','Logout','index.php?option=com_login','components','1','0','15','0','5','0','0000-00-00 00:00:00','0','0','1','3','\nshow_title=1\nshow_page_title=1\n','logout-usermenu-16');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '17','topmenu','Home','index.php','url','1','0','0','0','1','0','0000-00-00 00:00:00','0','0','0','3','\nshow_title=1\nshow_page_title=1\n','home-topmenu-17');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '18','topmenu','Contact Us','index.php?option=com_contact&Itemid=3','url','1','0','0','0','2','0','0000-00-00 00:00:00','0','0','0','3','show_image=-1','contact-us-topmenu-18');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '19','topmenu','News','index.php?option=com_content&task=section&id=1&Itemid=2','url','1','0','0','0','3','0','0000-00-00 00:00:00','0','0','0','3','\nshow_title=1\nshow_page_title=1\n','news-topmenu-19');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '20','topmenu','Links','index.php?option=com_weblinks&Itemid=23','url','1','0','0','0','4','0','0000-00-00 00:00:00','0','0','0','3','menu_image=-1\nshow_title=1\nshow_page_title=1\n','links-topmenu-20');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '25','mainmenu','FAQs','index.php?option=com_content&task=category&sectionid=3&id=7','content_category','0','0','7','0','13','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\nshow_page_title=1\npageclass_sfx=\nback_button=\norderby=\ndate_format=\nshow_date=\nshow_author=\ntitle=1\nshow_hits=\nshow_headings=1\nshow_item_navigation=1\norder_select=1\nshow_pagination_limit=1\ndisplay_num=50\nfilter=1\nfilter_type=title\nshow_categories=1\nshow_empty_categories=0\nshow_cat_num_articles=1\ncat_show_description=1\nshow_title=1\n','faqs-mainmenu-25');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '26','mainmenu','About Us','index.php?option=com_content&task=blogsection&id=5','content_blog_section','1','0','5','0','14','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=1\nnum_columns=1\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\nsectionid=5\nshow_title=1\n','about-us-mainmenu-26');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '27','mainmenu','Wagyu in Australia','index.php?option=com_content&task=blogcategory&id=49','content_blog_category','1','26','49','0','4','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=49\nshow_title=1\n','wagyu-in-australia-mainmenu-27');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '28','mainmenu','Membership','index.php?option=com_content&task=blogcategory&id=14','content_blog_category','1','26','14','0','3','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=14\nshow_title=1\n','membership-mainmenu-28');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '29','mainmenu','Breed History','index.php?option=com_content&task=blogcategory&id=15','content_blog_category','1','26','15','0','5','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=15\nshow_title=1\n','breed-history-mainmenu-29');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '30','mainmenu','Network','index.php?option=com_content&task=blogsection&id=6','content_blog_section','1','0','6','0','15','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=1\nnum_columns=1\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\nsectionid=6\nshow_title=1\n','network-mainmenu-30');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '31','mainmenu','Seedstock','index.php?option=com_content&task=blogcategory&id=16','content_blog_category','1','30','16','0','30','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=16\nshow_title=1\n','seedstock-mainmenu-31');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '36','othermenu','Restricted Login','https://abri.une.edu.au/online/cgi-bin/i4.dll?1=wagy&2=lo','url','1','0','0','0','9','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\nshow_title=1\nshow_page_title=1\n','restricted-login-othermenu-36');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '37','othermenu','Database Search','http://abri.une.edu.au/online/cgi-bin/i4.dll?1=3C212A07&2=322B&4=59272F59252D24252E232E2F2A','url','1','0','0','0','11','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\nshow_title=1\nshow_page_title=1\n','database-search-othermenu-37');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '38','othermenu','Sales Catalogues','https://abri.une.edu.au/online/cgi-bin/i4.dll?1=3c212A07&2=3228&3=56&5=2B3C2B3C3A','url','1','0','0','0','12','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\nshow_title=1\nshow_page_title=1\n','sales-catalogues-othermenu-38');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '40','mainmenu','Commercial Breeders','index.php?option=com_content&task=blogcategory&id=22','content_blog_category','1','30','22','0','28','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=22\nshow_title=1\n','commercial-breeders-mainmenu-40');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '41','mainmenu','Feedlots','index.php?option=com_content&task=blogcategory&id=23','content_blog_category','1','30','23','0','25','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=23\nshow_title=1\n','feedlots-mainmenu-41');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '42','mainmenu','Wholesalers','index.php?option=com_content&task=blogcategory&id=24','content_blog_category','1','30','24','0','23','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=24\nshow_title=1\n','wholesalers-mainmenu-42');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '43','mainmenu','Marketing Agents','index.php?option=com_content&task=blogcategory&id=25','content_blog_category','1','30','25','0','19','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=25\nshow_title=1\n','marketing-agents-mainmenu-43');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '44','mainmenu','Restaurants','index.php?option=com_content&task=blogcategory&id=26','content_blog_category','1','30','26','0','16','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=26\nshow_title=1\n','restaurants-mainmenu-44');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '45','mainmenu','Live Exporters','index.php?option=com_content&task=blogcategory&id=27','content_blog_category','1','30','27','0','15','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=27\nshow_title=1\n','live-exporters-mainmenu-45');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '46','mainmenu','Meat Exporters','index.php?option=com_content&task=blogcategory&id=29','content_blog_category','1','30','29','0','6','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=29\nshow_title=1\n','meat-exporters-mainmenu-46');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '47','mainmenu','Downloads','index.php?option=com_content&task=blogcategory&id=30','content_blog_category','1','26','30','0','2','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=30\nshow_title=1\n','downloads-mainmenu-47');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '49','mainmenu','Merchandise','index.php?option=com_content&task=blogcategory&id=32','content_blog_category','1','50','32','0','9','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=32\nshow_title=1\n','merchandise-mainmenu-49');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '50','mainmenu','Products','index.php?option=com_content&task=blogsection&id=8','content_blog_section','1','0','8','0','16','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=1\nnum_columns=1\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\nsectionid=8\nshow_title=1\n','products-mainmenu-50');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '53','mainmenu','Culinary Ideas','index.php?option=com_content&task=blogcategory&id=34','content_blog_category','1','56','34','0','11','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=34\nshow_title=1\n','culinary-ideas-mainmenu-53');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '54','mainmenu','Advertising','index.php?option=com_content&task=blogcategory&id=21','content_blog_category','1','56','21','0','32','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=21\nshow_title=1\n','advertising-mainmenu-54');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '56','mainmenu','Services','index.php?option=com_content&task=blogsection&id=7','content_blog_section','1','0','7','0','17','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=1\nnum_columns=1\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\nsectionid=7\nshow_title=1\n','services-mainmenu-56');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '57','topmenu','News Item','index.php?option=com_content&task=blogsection&id=10','content_blog_section','1','0','10','0','5','0','0000-00-00 00:00:00','0','0','0','0','sectionid=10\nshow_title=1\nshow_page_title=1\n','news-item-topmenu-57');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '58','topmenu','March','index.php?option=com_content&task=blogcategory&id=43','content_blog_category','1','0','43','0','6','0','0000-00-00 00:00:00','0','0','0','0','categoryid=43\nshow_title=1\nshow_page_title=1\n','march-topmenu-58');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '59','mainmenu','Newsletter','index.php?option=com_content&task=blogcategory&id=44','content_blog_category','1','50','44','0','20','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=44\nshow_title=1\n','newsletter-mainmenu-59');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '60','mainmenu','Butchers','index.php?option=com_content&task=blogcategory&id=45','content_blog_category','1','30','45','0','4','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=45\nshow_title=1\n','butchers-mainmenu-60');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '64','mainmenu','Markets for Wagyu','index.php?option=com_content&task=blogcategory&id=53','content_blog_category','1','26','53','0','6','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=53\nshow_title=1\n','markets-for-wagyu-mainmenu-64');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '65','mainmenu','Making the Grade','index.php?option=com_content&task=blogcategory&id=52','content_blog_category','1','26','52','0','7','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=52\nshow_title=1\n','making-the-grade-mainmenu-65');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '67','othermenu','AI Sire List','https://abri.une.edu.au/online/cgi-bin/i4.dll?1=3C212A07&2=2928&3=56&5=2B3C2B3C3A&11=5A595827','url','1','0','0','0','10','0','0000-00-00 00:00:00','0','1','0','0','menu_image=-1\nshow_title=1\nshow_page_title=1\n','ai-sire-list-othermenu-67');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '69','usermenu','Livestock Recording Software','index.php?option=com_content&task=category&sectionid=7&id=54','content_category','1','0','54','0','6','0','0000-00-00 00:00:00','0','0','0','0','\nshow_title=1\nshow_page_title=1\n','livestock-recording-software-usermenu-69');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '73','mainmenu','Latest News','index.php?option=com_content&task=blogcategory&id=1','content_blog_category','1','0','1','0','18','0','0000-00-00 00:00:00','0','0','0','0','menu_image=-1\npageclass_sfx=\nback_button=\npage_title=\nshow_page_title=1\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=1\nnum_links=4\norderby_pri=\norderby_sec=\nshow_pagination=2\nshow_pagination_results=1\nimage=1\nshow_description=0\nshow_description_image=0\nshow_category=0\ncategory_num_links=0\nshow_title=1\nlink_titles=\nshow_readmore=\nshow_vote=\nshow_author=\nshow_create_show_date=\nshow_modify_show_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nunpublished=0\ncategoryid=1\nshow_title=1\n','latest-news-mainmenu-73');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '74','mainmenu','AWA Contacts','index.php?option=com_contact&catid=36','contact_category_table','1','3','36','0','1','0','0000-00-00 00:00:00','0','0','0','0','show_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nother_cat=1\ncat_description=0\ncat_items=1\nheadings=1\nshow_position=1\nshow_icon_email=0\nshow_icon_telephone=1\nshow_icon_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1','awa-contacts-mainmenu-74');

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '75','mainmenu','AWA Council Contacts','index.php?option=com_contact&catid=12','contact_category_table','1','3','12','0','2','0','0000-00-00 00:00:00','0','0','0','0','show_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nother_cat=1\ncat_description=0\ncat_items=1\nheadings=1\nshow_position=1\nshow_icon_email=0\nshow_icon_telephone=1\nshow_icon_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1','awa-council-contacts-mainmenu-75');

Open in new window

0
 
LVL 11

Author Comment

by:Amanda Watson
ID: 24427221
So I had an idea.  I changed the first entry to id number 4, as I noticed that one wasn't in the list.
And it worked...up until this error:
Error at the line 290: INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '1','Polls','','1','right','0','0000-00-00 00:00:00','0','mod_poll','0','0','1','','0','0');

Query:INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '1','Polls','','1','right','0','0000-00-00 00:00:00','0','mod_poll','0','0','1','','0','0');

MySQL: Duplicate entry '1' for key 1

Stopped on error

So I have checked all the jos_ module entries which is attached.
I am going to change the number 1 to another missing entry and see if it works
INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '1','Polls','','1','right','0','0000-00-00 00:00:00','0','mod_poll','0','0','1','','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '2','User Menu','','6','left','0','0000-00-00 00:00:00','0','mod_mainmenu','0','1','1','menutype=usermenu','1','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '3','Main Menu','','1','abovemenu','0','0000-00-00 00:00:00','0','mod_mainmenu','0','0','0','class_sfx=\nmoduleclass_sfx=_top\nmenutype=mainmenu\nmenu_style=horiz_flat\nfull_active_id=0\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nactivate_parent=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=','1','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '4','Login Form','','5','right','0','0000-00-00 00:00:00','0','mod_login','0','0','1','moduleclass_sfx=\npretext=\nposttext=\nlogin=\nlogout=\nlogin_message=1\nlogout_message=1\ngreeting=1\nname=0','1','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '5','Syndicate','','8','left','0','0000-00-00 00:00:00','0','mod_rssfeed','0','0','1','','1','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '6','Latest News','','1','user1','0','0000-00-00 00:00:00','0','mod_latestnews','0','0','1','moduleclass_sfx=\ncache=0\ntype=1\nshow_front=1\ncount=5\ncatid=\nsecid=','1','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '7','Statistics','','1','leftsponso','0','0000-00-00 00:00:00','0','mod_stats','0','0','1','serverinfo=1\nsiteinfo=1\ncounter=1\nincrease=0\nmoduleclass_sfx=','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '8','Who\'s Online','','6','right','0','0000-00-00 00:00:00','0','mod_whosonline','0','0','1','online=1\nusers=1\nmoduleclass_sfx=','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '9','Popular','','2','user2','0','0000-00-00 00:00:00','0','mod_mostread','0','0','1','','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '10','Template Chooser','','9','left','0','0000-00-00 00:00:00','0','mod_templatechooser','0','0','1','show_preview=1','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '11','Archive','','10','left','0','0000-00-00 00:00:00','0','mod_archive','0','0','1','','1','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '12','Sections','','11','left','0','0000-00-00 00:00:00','0','mod_sections','0','0','1','','1','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '13','Newsflash','','1','top','0','0000-00-00 00:00:00','0','mod_newsflash','0','0','1','catid=0\nstyle=random\nimage=0\nlink_titles=\nreadmore=1\nitem_title=1\nitems=5\ncache=0\nmoduleclass_sfx=','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '14','Related Items','','12','left','0','0000-00-00 00:00:00','0','mod_related_items','0','0','1','','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '15','Search Wagyu website','','4','left','0','0000-00-00 00:00:00','1','mod_search','0','0','1','moduleclass_sfx=\ncache=0\nset_itemid=\nwidth=0\ntext=search the website\nbutton=1\nbutton_pos=right\nbutton_text=>>','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '16','Random Image','','3','user1','0','0000-00-00 00:00:00','0','mod_random_image','0','0','0','type=jpg\nfolder=images/B_images\nlink=\nwidth=786px\nheight=131px\nmoduleclass_sfx=','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '17','Top Menu','','3','abovemenu','0','0000-00-00 00:00:00','0','mod_mainmenu','0','0','0','class_sfx=\nmoduleclass_sfx=_top\nmenutype=topmenu\nmenu_style=horiz_flat\nfull_active_id=0\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nactivate_parent=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=','1','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '18','Banners','','3','left','0','0000-00-00 00:00:00','0','mod_banners','0','0','0','banner_cids=\nmoduleclass_sfx=','1','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '19','Components','','2','cpanel','0','0000-00-00 00:00:00','1','mod_components','0','99','1','','1','1');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '20','Popular','','3','cpanel','0','0000-00-00 00:00:00','1','mod_popular','0','99','1','','0','1');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '21','Latest Items','','4','cpanel','0','0000-00-00 00:00:00','1','mod_latest','0','99','1','','0','1');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '22','Menu Stats','','5','cpanel','0','0000-00-00 00:00:00','1','mod_stats','0','99','1','','0','1');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '23','Unread Messages','','1','header','0','0000-00-00 00:00:00','1','mod_unread','0','99','1','','1','1');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '24','Online Users','','2','header','0','0000-00-00 00:00:00','1','mod_online','0','99','1','','1','1');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '25','Full Menu','','1','top','0','0000-00-00 00:00:00','1','mod_fullmenu','0','99','1','','1','1');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '26','Pathway','','1','pathway','0','0000-00-00 00:00:00','1','mod_pathway','0','99','1','','1','1');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '27','Toolbar','','1','toolbar','0','0000-00-00 00:00:00','1','mod_toolbar','0','99','1','','1','1');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '28','System Message','','1','inset','0','0000-00-00 00:00:00','1','mod_mosmsg','0','99','1','','1','1');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '29','Quick Icons','','1','icon','0','0000-00-00 00:00:00','1','mod_quickicon','0','99','1','','1','1');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '30','Internet Solutions','','2','abovemenu','0','0000-00-00 00:00:00','1','mod_mainmenu','0','0','1','class_sfx=\nmoduleclass_sfx=\nmenutype=othermenu\nmenu_style=horiz_flat\nfull_active_id=0\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nactivate_parent=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '31','Wrapper','','13','left','0','0000-00-00 00:00:00','0','mod_wrapper','0','0','1','','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '32','Logged','','0','cpanel','0','0000-00-00 00:00:00','1','mod_logged','0','99','1','','0','1');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '33','Resize Text','','2','left','0','0000-00-00 00:00:00','0','mod_FWResizeFont','0','0','1','class_sfx=\ntags=div,td,tr,p,b,table,strong,em,a,h1,h2,h3,pre,sub,sup,i,th,cp,ul,ol,li,dt,dd,input\ndefaultSize=12\nincrement=2\nspacer=|\nincreaseTitle=Increase Size\ndecreaseTitle=Decrease Size\nresetTitle=Reset Size','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '44','Running Front Page Banner','','2','user1','0','0000-00-00 00:00:00','1','mod_html','0','0','0','fwd_html=<script language=\"JavaScript1.2\">\r<br />\r<br />/*\r<br />Cross browser Marquee script- © Dynamic Drive (www.dynamicdrive.com)\r<br />For full source code, 100\'s more DHTML scripts, and Terms Of Use, visit http://www.dynamicdrive.com\r<br />Credit MUST stay intact\r<br />*/\r<br />\r<br />//Specify the marquee\'s width (in pixels)\r<br />var marqueewidth=\"700px\"\r<br />//Specify the marquee\'s height\r<br />var marqueeheight=\"35px\"\r<br />//Specify the marquee\'s marquee speed (larger is faster 1-10)\r<br />var marqueespeed=2\r<br />//configure background color:\r<br />var marqueebgcolor=\"\"\r<br />//Pause marquee onMousever (0=no. 1=yes)?\r<br />var pauseit=1\r<br />\r<br />//Specify the marquee\'s content (don\'t delete <nobr> tag)\r<br />//Keep all content on ONE line, and backslash any single quotations (ie: that\\\'s great):\r<br />\r<br />\r<br />var marqueecontent=\'<nobr><font face=\"Arial\" <font color=\"#FF3000\">Breeding Better FB Females ....<a href=\"http://www.australianwagyuforum.com.au\">&nbsp;CLICK HERE</a></font></nobr>\'\r<br />\r<br />\r<br />////NO NEED TO EDIT BELOW THIS LINE////////////\r<br />marqueespeed=(document.all)? marqueespeed : Math.max(1, marqueespeed-1) //slow speed down by 1 for NS\r<br />var copyspeed=marqueespeed\r<br />var pausespeed=(pauseit==0)? copyspeed: 0\r<br />var iedom=document.all||document.getElementById\r<br />if (iedom)\r<br />document.write(\'<span id=\"temp\" style=\"visibility:hidden;position:absolute;top:-100px;left:-9000px\">\'+marqueecontent+\'</span>\')\r<br />var actualwidth=\'\'\r<br />var cross_marquee, ns_marquee\r<br />\r<br />function populate(){\r<br />if (iedom){\r<br />cross_marquee=document.getElementById? document.getElementById(\"iemarquee\") : document.all.iemarquee\r<br />cross_marquee.style.left=parseInt(marqueewidth)+8+\"px\"\r<br />cross_marquee.innerHTML=marqueecontent\r<br />actualwidth=document.all? temp.offsetWidth : document.getElementById(\"temp\").offsetWidth\r<br />}\r<br />else if (document.layers){\r<br />ns_marquee=document.ns_marquee.document.ns_marquee2\r<br />ns_marquee.left=parseInt(marqueewidth)+8\r<br />ns_marquee.document.write(marqueecontent)\r<br />ns_marquee.document.close()\r<br />actualwidth=ns_marquee.document.width\r<br />}\r<br />lefttime=setInterval(\"scrollmarquee()\",20)\r<br />}\r<br />window.onload=populate\r<br />\r<br />function scrollmarquee(){\r<br />if (iedom){\r<br />if (parseInt(cross_marquee.style.left)>(actualwidth*(-1)+8))\r<br />cross_marquee.style.left=parseInt(cross_marquee.style.left)-copyspeed+\"px\"\r<br />else\r<br />cross_marquee.style.left=parseInt(marqueewidth)+8+\"px\"\r<br />\r<br />}\r<br />else if (document.layers){\r<br />if (ns_marquee.left>(actualwidth*(-1)+8))\r<br />ns_marquee.left-=copyspeed\r<br />else\r<br />ns_marquee.left=parseInt(marqueewidth)+8\r<br />}\r<br />}\r<br />\r<br />if (iedom||document.layers){\r<br />with (document){\r<br />document.write(\'<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><td>\')\r<br />if (iedom){\r<br />write(\'<div style=\"position:relative;width:\'+marqueewidth+\';height:\'+marqueeheight+\';overflow:hidden\">\')\r<br />write(\'<div style=\"position:absolute;width:\'+marqueewidth+\';height:\'+marqueeheight+\';background-color:\'+marqueebgcolor+\'\" onMouseover=\"copyspeed=pausespeed\" onMouseout=\"copyspeed=marqueespeed\">\')\r<br />write(\'<div id=\"iemarquee\" style=\"position:absolute;left:0px;top:0px\"></div>\')\r<br />write(\'</div></div>\')\r<br />}\r<br />else if (document.layers){\r<br />write(\'<ilayer width=\'+marqueewidth+\' height=\'+marqueeheight+\' name=\"ns_marquee\" bgColor=\'+marqueebgcolor+\'>\')\r<br />write(\'<layer name=\"ns_marquee2\" left=0 top=0 onMouseover=\"copyspeed=pausespeed\" onMouseout=\"copyspeed=marqueespeed\"></layer>\')\r<br />write(\'</ilayer>\')\r<br />}\r<br />document.write(\'</td></table>\')\r<br />}\r<br />}\r<br /></script>','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '38','Latest News','','1','user4','0','0000-00-00 00:00:00','0','mod_ijoomla_googlestyle','0','0','1','layout_size=336.280.4\ncount=6\nrandom=0\ntype=1\nshow_front=1\ncatid=1\nsecid=1\ncat_color=#000000\nbgcolor=#FFFFFF\nborder_color=#DCDFE1\nmax_char_title=40\ntitle_color=#C64934\ntitle_font_type=arial,sans-serif\ntitle_font_size=13\nmax_char_intro=100\ntext_color=#000000\ntext_font_type=arial,sans-serif\ntext_font_size=13\nhas_elink=0\nelink_color=#009933\nelink_font_type=arial,sans-serif\nelink_font_size=10\nhas_readmore=1\nreadmore_color=#0000FF\nreadmore_font_type=arial,sans-serif\nreadmore_font_size=10\ncache=0','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '39','The Flash Module','','1','left','0','0000-00-00 00:00:00','0','mod_flashmod','0','0','1','fm_path=images/flash/\nfm_source=ginjo.swf\nfm_width=230px\nfm_height=55px\nfm_name=\nfm_quality=high\nfm_version=8.0.22.0\nfm_usejs=yes\nfm_loop=true\nfm_wmode=window','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '43','Flash Rotator','','4','user1','0','0000-00-00 00:00:00','0','mod_flashrotator','0','0','0','width=393px\nheight=135px\nbgcolor=#FFFFFF\nrotatetime=10\ntransition=fade\nrandomplay=0\nshownavigation=0\ntransparent=opaque\nimage1=image1.jpg\nlink1=\nimage2=image2.jpg\nlink2=\nimage3=image3.jpg\nlink3=\nimage4=image4.jpg\nlink4=\nimage5=image5.jpg\nlink5=\nmoduleclass_sfx=','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '41','Click image for more info','','5','left','0','0000-00-00 00:00:00','1','mod_jw_ajaxhr','0','0','1','moduleclass_sfx=\nuniqueid=ad\nimagefolder=images/stories/ad\nspeed=600\ntimeout=5000\nwidth=162\nheight=128\nenablelink=1\nlink=http://wagyu.une.edu.au/index.php?option=com_content&task=blogcategory&id=21&Itemid=54\ntarget=0\ndisplay=random','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '42','Ultimate AJAX Newsflash','','14','left','0','0000-00-00 00:00:00','0','mod_jw_ajaxnf','0','0','1','','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '35','Latest Events','','4','right','0','0000-00-00 00:00:00','0','mod_jcalpro_latest','0','0','1','categories=General\nmoduleclass_sfx=\nnumber_of_events_to_list_upcoming=5\nnumber_of_events_to_list_recent=0\ntitle_max_length=256\nshow_times=1\nshow_category=1\nshow_description=1\ndescription_max_length=256\nstrip_bbcode_from_description=3\nshow_recurrent_events=3\noutput=1\nevent_separator=<br />\nshow_month_separators=0\nmonth_separator_style=background-color: none; border-top-color: #777777; border-bottom-color: #777777; border-top-width: 1px; border-bottom-width: 1px; border-top-style: solid; border-bottom-style: solid; font-style: italic; font-weight: bold; margin: 4px; text-align: center\nno_upcoming_events_text=There are no upcoming events currently scheduled.\nrecent_events_text=Recent Events\nrecent_events_style=font-size: 130%; font-weight: bold; background-color: none; border-top-color: #333333; border-bottom-color: #333333; border-top-width: 2px; border-bottom-width: 2px; border-top-style: solid; border-bottom-style: solid; margin: 10px; text-align: center\nshow_full_calendar_link=1\nfull_calendar_link_text=View Full Calendar\nshow_add_event_link=1\nadd_event_text=Add New Event\nuse_extcal_locale_settings=0\ntime_format_12_or_24=1\ndays_view=0\ncomponent_itemid=','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '36','Calendar of Events','','3','right','0','0000-00-00 00:00:00','0','mod_jcalpro_minical','0','0','1','mini_cal_def_picture=def_pic.gif\npicture=0\nnavigation_controls=1\nuse_component_itemid=0\ncomponent_itemid_mini=\nshow_minical_add_event_button=1\ntarget=\nmoduleclass_sfx=','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '48','Showcase Icons','','1','banner','0','0000-00-00 00:00:00','1','mod_html','0','0','0','fwd_html=<table width=\"700\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr><td><a href=\"http://wagyu.une.edu.au/index.php?option=com_content&task=blogcategory&id=30&Itemid=47\"><img src=\"images/merchandise.jpg\" width=\"184\" height=\"60\" border=\"0\" align=\"top\"/></a></td><td><a href=\"http://wagyu.une.edu.au/index.php?option=com_jcalpro&Itemid=72\"><img src=\"images/calendar.jpg\" width=\"147\" height=\"60\" border=\"0\" align=\"top\"/></a></td><td><a href=\"http://wagyu.une.edu.au/index.php?option=com_content&task=blogsection&id=6&Itemid=30\"><img src=\"images/culinary.jpg\" width=\"179\" height=\"60\" border=\"0\" align=\"top\"/></a></td><td><a href=\"http://wagyu.une.edu.au/index.php?option=com_content&task=blogcategory&id=21&Itemid=54\"><img src=\"images/advertising.jpg\" width=\"155\" height=\"60\" border=\"0\" align=\"top\"/></a></td></tr></table>','0','0');

INSERT INTO jos_modules (`id`,`title`,`content`,`ordering`,`position`,`checked_out`,`checked_out_time`,`published`,`module`,`numnews`,`access`,`showtitle`,`params`,`iscore`,`client_id`) VALUES ( '47','Corporate Sponsors','','7','left','0','0000-00-00 00:00:00','1','mod_jw_ajaxhr','0','0','1','moduleclass_sfx=\nuniqueid=sponsor\nimagefolder=images/stories/spnosors\nspeed=600\ntimeout=5000\nwidth=162\nheight=92\nenablelink=1\nlink=http://wagyu.une.edu.au/index.php?option=com_content&task=view&id=48&Itemid=70\ntarget=0\ndisplay=random','0','0');

Open in new window

0
 
LVL 11

Author Comment

by:Amanda Watson
ID: 24427301
Ok, its not working for the jos_modules table.
Everytime I change one id, it moves on to the next one and says there is another duplicate entry.

So there is an issue with the id definatley.

i just don't know how to fix this now!!
0
 
LVL 10

Accepted Solution

by:
OnALearningCurve earned 500 total points
ID: 24429257
Hi snowball77,

Sorry for the lack of response, have been away from my PC.

I am still unsure how joomla works but looking at this I am guessing that either there is already data stored in the jos_modules table or it just does not like the ID values you are entering.

I would try a couple of things. But check that this will not break anything before you do!!!

Firstly, if the only entries that should be in the tables should be the ones you are trying to insert, then I would try clearing out the tables completely and then try to re-import all of the data from scratch.

The command to clear down all the entries in a table is

TRUNCATE TABLE tablename;

So you would need to run

TRUNCATE TABLE jos_menu;

And

TRUNCATE TABLE jos_modules;

PLEASE ENSURE IT IS OK TO DELETE THE CONTENTS OF THESE TABLES BEFORE YOU TRY THIS!

If that does not work or is not an option, then it may be worth editing the SQL statements to not include the ID filed during the import.

To do this simply remove the 'id' field entry in the first section of the statement and the id value for the Values section of the statement.

For Example:

INSERT INTO jos_menu (`id`,`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ( '1','mainmenu','Home','index.php?option=com_frontpage','components','1','0','10','0','6','0','0000-00-00 00:00:00','0','0','0','3','num_leading_articles=1\r\nnum_intro_articles=2\r\nnum_links=1\r\nimage=1\r\nshow_page_title=0\r\npage_title=Welcome to the Frontpage\r\norderby_sec=front\r\nshow_print_icon=0\r\nshow_pdf_icon=0\r\nshow_email_icon=0\r\nback_button=0\nshow_title=1\n','home-mainmenu-1');


Will become

INSERT INTO jos_menu (`menutype`,`name`,`link`,`type`,`published`,`parent`,`componentid`,`sublevel`,`ordering`,`checked_out`,`checked_out_time`,`pollid`,`browserNav`,`access`,`utaccess`,`params`,`alias`) VALUES ('mainmenu','Home','index.php?option=com_frontpage','components','1','0','10','0','6','0','0000-00-00 00:00:00','0','0','0','3','num_leading_articles=1\r\nnum_intro_articles=2\r\nnum_links=1\r\nimage=1\r\nshow_page_title=0\r\npage_title=Welcome to the Frontpage\r\norderby_sec=front\r\nshow_print_icon=0\r\nshow_pdf_icon=0\r\nshow_email_icon=0\r\nback_button=0\nshow_title=1\n','home-mainmenu-1');


Again, I am not sure if this will work or if it is recommended, but it may be worth a shot.  Looking at the entries in the jos_menu table the very last item which goes into the 'alias' field seems to hold the same number as the 'id' filed.  I am not sure if this is important or not, but based on this I would probably try clearing down the tables and re-importing from scratch if that is an option.

Hope this helps an sorry if it has caused you more confusion.

Mark.

0
 
LVL 11

Author Comment

by:Amanda Watson
ID: 24437877
Hi There, and thanks for the response.
I suspect removing the id completely will infact cause a problem as joomla relies on these id's to reference the different, content, menus, modules etc.
Deleting the tables is a great idea.  I am only using a test site at the moment anyway, so I am not concerned with clearing out everything.  So I guess I can ask the server administrator to delete the tables (i don't have access to the database via cpanel or anything for this site!!)

I had thought trying to migrate a table meant that all tables were deleted before trying to add the new tables, so I didn't expect this kind of error.  Infact I had tried loading this data before any other tables were entered so it was the fresh data, but the error persists.  I am not certain this is going to work!!
0
 
LVL 11

Author Comment

by:Amanda Watson
ID: 24437882
If I use the TRUNCATE TABLE command, does it leave the table there, but just deletes the entries?
0
 
LVL 10

Expert Comment

by:OnALearningCurve
ID: 24438880
Hi snowball77

TRUNCATE TABLE tablename

Will just delete all the entries in a table leaving the table structure in place.

If you need to delete the actual table from the database then you need to use the DROP command:

DROP TABLE tablename

For these to work though your user account needs to have the correct permissions on the database.

I hope this makes sense.

Mark.
0
 
LVL 11

Author Comment

by:Amanda Watson
ID: 24445612
Yep, makes sense.
I will give it a go and see!
Cheers,
A
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 10

Expert Comment

by:OnALearningCurve
ID: 24448516
No problem,

Hope it works :)
0
 
LVL 11

Author Comment

by:Amanda Watson
ID: 24455573
Ok, so I gave it a go, but now I cannot get into my administrators panel to migrate the new table.
I have an install, and need to get into the backend to be able to test this, which I cannot do.
0
 
LVL 11

Author Comment

by:Amanda Watson
ID: 24455575
Ok, so I gave it a go, but now I cannot get into my administrators panel to migrate the new table.
I have an install, and need to get into the backend to be able to test this, which I cannot do.
0
 
LVL 10

Expert Comment

by:OnALearningCurve
ID: 24480670
Hi snowball77,

Sorry for the lack of response, I have been away.  Firstly, thanks for the points but looking at your posts you didn't get it sorted.

Have you managed to get it up and running or are you still now fighting to get into the Admin Panel?

Mark.
0
 
LVL 11

Author Comment

by:Amanda Watson
ID: 24481001
Hi Mark,
I am fighting to get in to the Admin Panel still, and I don't know how long its going to take as I am waiting on others to give me permission to get into the database.
 BIG HEADACHE!
0
 
LVL 10

Expert Comment

by:OnALearningCurve
ID: 24481072
OK,

I kind of feel responsible for this with my Gun ho "Just clear down the tables I know nothing about" comment, and you have already given me the points.  So ...

What (if any) error message to you get when you try to log in?

Also what account are you logging in as (i.e. is it the administrator account)?

With these snippets, I'll do some digging around.
0
 
LVL 11

Author Comment

by:Amanda Watson
ID: 24487235
Well, when I try to get into the admin panel, the password does'nt work.
So I need to get to the jos_user table to reset the hash password.

Then I could test migrating the sql into the tables, with the truncated tables ready to be populated
0
 
LVL 10

Expert Comment

by:OnALearningCurve
ID: 24491299
0
 
LVL 11

Author Comment

by:Amanda Watson
ID: 24497098
Yes, I know how to reset the admin password, but I do not have access to these tables and have had to ask someone else to do this for me who is incredibly slack at getting anything done, so as of last week when I asked for access to the database so I could do it, I havn't heard back

Thanks for sticking with me to help, but until I get direct access to the database I cannot test any further

0
 
LVL 10

Expert Comment

by:OnALearningCurve
ID: 24500850
Wow,

I'm a sysadmin and if our response times were as bad as your guy I be out of a job!

Hope you get it sorted soon.

Mark.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now