Amanda Watson
asked on
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`,`l ink`,`type `,`publish ed`,`paren t`,`compon entid`,`su blevel`,`o rdering`,` checked_ou t`,`checke d_out_time `,`pollid` ,`browserN av`,`acces s`,`utacce ss`,`param s`,`alias` ) VALUES ( '1','mainmenu','Home','ind ex.php?opt ion=com_fr ontpage',' components ','1','0', '10','0',' 6','0','00 00-00-00 00:00:00','0','0','0','3', 'num_leadi ng_article s=1\r\nnum _intro_art icles=2\r\ nnum_links =1\r\nimag e=1\r\nsho w_page_tit le=0\r\npa ge_title=W elcome to the Frontpage\r\norderby_sec=f ront\r\nsh ow_print_i con=0\r\ns how_pdf_ic on=0\r\nsh ow_email_i con=0\r\nb ack_button =0\nshow_t itle=1\n', 'home-main menu-1');
Query:INSERT INTO jos_menu (`id`,`menutype`,`name`,`l ink`,`type `,`publish ed`,`paren t`,`compon entid`,`su blevel`,`o rdering`,` checked_ou t`,`checke d_out_time `,`pollid` ,`browserN av`,`acces s`,`utacce ss`,`param s`,`alias` ) VALUES ( '1','mainmenu','Home','ind ex.php?opt ion=com_fr ontpage',' components ','1','0', '10','0',' 6','0','00 00-00-00 00:00:00','0','0','0','3', 'num_leadi ng_article s=1\r\nnum _intro_art icles=2\r\ nnum_links =1\r\nimag e=1\r\nsho w_page_tit le=0\r\npa ge_title=W elcome to the Frontpage\r\norderby_sec=f ront\r\nsh ow_print_i con=0\r\ns how_pdf_ic on=0\r\nsh ow_email_i con=0\r\nb ack_button =0\nshow_t itle=1\n', 'home-main menu-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
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`,`l
Query:INSERT INTO jos_menu (`id`,`menutype`,`name`,`l
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
ASKER
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?
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§ionid=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§ionid=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§ionid=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');
ASKER
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`,`o rdering`,` position`, `checked_o ut`,`check ed_out_tim e`,`publis hed`,`modu le`,`numne ws`,`acces s`,`showti tle`,`para ms`,`iscor e`,`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`,`o rdering`,` position`, `checked_o ut`,`check ed_out_tim e`,`publis hed`,`modu le`,`numne ws`,`acces s`,`showti tle`,`para ms`,`iscor e`,`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
And it worked...up until this error:
Error at the line 290: INSERT INTO jos_modules (`id`,`title`,`content`,`o
Query:INSERT INTO jos_modules (`id`,`title`,`content`,`o
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\"> 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');
ASKER
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!!
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!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!!
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!!
ASKER
If I use the TRUNCATE TABLE command, does it leave the table there, but just deletes the entries?
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.
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.
ASKER
Yep, makes sense.
I will give it a go and see!
Cheers,
A
I will give it a go and see!
Cheers,
A
No problem,
Hope it works :)
Hope it works :)
ASKER
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.
I have an install, and need to get into the backend to be able to test this, which I cannot do.
ASKER
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.
I have an install, and need to get into the backend to be able to test this, which I cannot do.
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.
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.
ASKER
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!
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!
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.
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.
ASKER
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
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
Does this link help:
http://kb.siteground.com/article/How_to_reset_my_Joomla_administrator_password.html
Mark.
http://kb.siteground.com/article/How_to_reset_my_Joomla_administrator_password.html
Mark.
ASKER
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
Thanks for sticking with me to help, but until I get direct access to the database I cannot test any further
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.
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.
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.