Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1194
  • Last Modified:

Cannot migrate my sql database to joomla 1.5 site

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
Amanda Watson
Asked:
Amanda Watson
  • 11
  • 8
1 Solution
 
OnALearningCurveCommented:
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
 
Amanda WatsonWeb DeveloperAuthor Commented:
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
 
Amanda WatsonWeb DeveloperAuthor Commented:
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Amanda WatsonWeb DeveloperAuthor Commented:
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
 
OnALearningCurveCommented:
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
 
Amanda WatsonWeb DeveloperAuthor Commented:
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
 
Amanda WatsonWeb DeveloperAuthor Commented:
If I use the TRUNCATE TABLE command, does it leave the table there, but just deletes the entries?
0
 
OnALearningCurveCommented:
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
 
Amanda WatsonWeb DeveloperAuthor Commented:
Yep, makes sense.
I will give it a go and see!
Cheers,
A
0
 
OnALearningCurveCommented:
No problem,

Hope it works :)
0
 
Amanda WatsonWeb DeveloperAuthor Commented:
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
 
Amanda WatsonWeb DeveloperAuthor Commented:
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
 
OnALearningCurveCommented:
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
 
Amanda WatsonWeb DeveloperAuthor Commented:
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
 
OnALearningCurveCommented:
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
 
Amanda WatsonWeb DeveloperAuthor Commented:
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
 
OnALearningCurveCommented:
0
 
Amanda WatsonWeb DeveloperAuthor Commented:
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
 
OnALearningCurveCommented:
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 11
  • 8
Tackle projects and never again get stuck behind a technical roadblock.
Join Now