I just tried doing Build All (changed the server few hours before) and am getting this error, anyone knows how to fix this?
GT::SQL::Driver::MYSQL::sth (9083): Query execution took: 0.000155s from Links::Table::Links::_plg_add_reviews at /home/hc8zp7yi/public_html/cgi/admin/Links/Table/Links.pm line 616
GT::SQL::Driver::MYSQL::sth (9083): Executing query: SELECT lsql_Links.ID FROM lsql_CatLinks,lsql_Links WHERE lsql_CatLinks.LinkID = lsql_Links.ID AND ((lsql_CatLinks.CategoryID = '106') AND (lsql_Links.isValidated = 'Yes')) ORDER BY my_swd_sortorder ASC, isNew DESC,isPopular DESC,Title from Links::Build::build_detailed at Links::Build::build_detailed line 527
GT::SQL::Driver::MYSQL::sth (9083): Query execution took: 0.002343s from Links::Build::build_detailed at Links::Build::build_detailed line 527
GT::SQL::Driver::MYSQL::sth (9083): Executing query: SELECT lsql_Links.*,lsql_Category.Meta_Description,lsql_Category.FatherID,lsql_Category.Meta_Keywords,lsql_Category.Payment_Mode,lsql_Category.Footer,lsql_Category.isCategory_link_title,lsql_Category.Direct_Links,lsql_Category.Newest_Link,lsql_Category.Payment_Description,lsql_Category.Number_of_Links,lsql_Category.Link_Add_Description,lsql_Category.isCategory_link,lsql_Category.categorytype,lsql_Category.Has_Changed_Links,lsql_Category.isCategory_link_url,lsql_Category.allow_link,lsql_Category.Category_Rank,lsql_Category.Category_Name,lsql_Category.CatRoot,lsql_Category.category_section_type,lsql_Category.Full_Name,lsql_Category.Has_New_Links,lsql_Category.Name,lsql_Category.CatDepth,lsql_Category.Header,lsql_Category.Category_Template,lsql_CatLinks.CategoryID FROM lsql_CatLinks,lsql_Category,lsql_Links WHERE lsql_CatLinks.LinkID = lsql_Links.ID AND lsql_CatLinks.CategoryID = lsql_Category.ID AND (lsql_CatLinks.CategoryID = '106' AND lsql_CatLinks.LinkID = '35796') from Links::Table::Links::category_detailed_url at /home/hc8zp7yi/public_html/cgi/admin/Links/Table/Links.pm line 499
GT::SQL::Driver::MYSQL::sth (9083): Query execution took: 0.000468s from Links::Table::Links::category_detailed_url at /home/hc8zp7yi/public_html/cgi/admin/Links/Table/Links.pm line 499
GT::SQL::Driver::MYSQL::sth (9083): Executing query: SELECT lsql_Links.*,lsql_Category.Meta_Description,lsql_Category.FatherID,lsql_Category.Meta_Keywords,lsql_Category.Payment_Mode,lsql_Category.Footer,lsql_Category.isCategory_link_title,lsql_Category.Direct_Links,lsql_Category.Newest_Link,lsql_Category.Payment_Description,lsql_Category.Number_of_Links,lsql_Category.Link_Add_Description,lsql_Category.isCategory_link,lsql_Category.categorytype,lsql_Category.Has_Changed_Links,lsql_Category.isCategory_link_url,lsql_Category.allow_link,lsql_Category.Category_Rank,lsql_Category.Category_Name,lsql_Category.CatRoot,lsql_Category.category_section_type,lsql_Category.Full_Name,lsql_Category.Has_New_Links,lsql_Category.Name,lsql_Category.CatDepth,lsql_Category.Header,lsql_Category.Category_Template,lsql_CatLinks.CategoryID FROM lsql_CatLinks,lsql_Category,lsql_Links WHERE lsql_CatLinks.LinkID = lsql_Links.ID AND lsql_CatLinks.CategoryID = lsql_Category.ID AND (lsql_CatLinks.CategoryID = '106' AND lsql_CatLinks.LinkID = '40281') from Links::Table::Links::category_detailed_url at /home/hc8zp7yi/public_html/cgi/admin/Links/Table/Links.pm line 499
GT::SQL::Driver::MYSQL::sth (9083): Query execution took: 0.000417s from Links::Table::Links::category_detailed_url at /home/hc8zp7yi/public_html/cgi/admin/Links/Table/Links.pm line 499
GT::Plugins (9083): Plugin: pre detailed_url running => Plugins::StaticURLtr::tr_detailed at /home/hc8zp7yi/public_html/cgi/admin/GT/Plugins.pm line 118.
GT::Plugins (9083): Plugin pre hook detailed_url stopped further plugins. at /home/hc8zp7yi/public_html/cgi/admin/GT/Plugins.pm line 123.
GT::Plugins (9083): Plugin: pre category_as_url running => Plugins::StaticURLtr::tr_category at /home/hc8zp7yi/public_html/cgi/admin/GT/Plugins.pm line 118.
GT::SQL::Driver::MYSQL::sth (9083): Executing query: SELECT * FROM lsql_Category WHERE Full_Name = 'Audio & Video' from Plugins::StaticURLtr::tr_category at /home/hc8zp7yi/public_html/cgi/admin/Plugins/StaticURLtr.pm line 36
GT::SQL::Driver::MYSQL::sth (9083): Query execution took: 0.000224s from Plugins::StaticURLtr::tr_category at /home/hc8zp7yi/public_html/cgi/admin/Plugins/StaticURLtr.pm line 36
GT::Plugins (9083): Plugin pre hook category_as_url stopped further plugins. at /home/hc8zp7yi/public_html/cgi/admin/GT/Plugins.pm line 123.
GT::Plugins (9083): Plugin: pre category_as_url running => Plugins::StaticURLtr::tr_category at /home/hc8zp7yi/public_html/cgi/admin/GT/Plugins.pm line 118.
GT::SQL::Driver::MYSQL::sth (9083): Executing query: SELECT * FROM lsql_Category WHERE Full_Name = 'Audio & Video/Media Management' from Plugins::StaticURLtr::tr_category at /home/hc8zp7yi/public_html/cgi/admin/Plugins/StaticURLtr.pm line 36
GT::SQL::Driver::MYSQL::sth (9083): Query execution took: 0.000180s from Plugins::StaticURLtr::tr_category at /home/hc8zp7yi/public_html/cgi/admin/Plugins/StaticURLtr.pm line 36
GT::Plugins (9083): Plugin pre hook category_as_url stopped further plugins. at /home/hc8zp7yi/public_html/cgi/admin/GT/Plugins.pm line 123.
The complete error is many more lines, however seems like it is repeating itself for every link in the system.
I think I need to install some perl modules or something... any ideas?
Thank you.
Vishal
-------------------------------------------------------
Code:
GT::SQL::Driver::MYSQL::sth (9083): Executing query: SELECT * FROM lsql_Reviews WHERE Review_Validated = 'Yes' AND Review_LinkID = '32227' from Links::Table::Links::_plg_add_reviews at /home/hc8zp7yi/public_html/cgi/admin/Links/Table/Links.pm line 616 GT::SQL::Driver::MYSQL::sth (9083): Query execution took: 0.000155s from Links::Table::Links::_plg_add_reviews at /home/hc8zp7yi/public_html/cgi/admin/Links/Table/Links.pm line 616
GT::SQL::Driver::MYSQL::sth (9083): Executing query: SELECT lsql_Links.ID FROM lsql_CatLinks,lsql_Links WHERE lsql_CatLinks.LinkID = lsql_Links.ID AND ((lsql_CatLinks.CategoryID = '106') AND (lsql_Links.isValidated = 'Yes')) ORDER BY my_swd_sortorder ASC, isNew DESC,isPopular DESC,Title from Links::Build::build_detailed at Links::Build::build_detailed line 527
GT::SQL::Driver::MYSQL::sth (9083): Query execution took: 0.002343s from Links::Build::build_detailed at Links::Build::build_detailed line 527
GT::SQL::Driver::MYSQL::sth (9083): Executing query: SELECT lsql_Links.*,lsql_Category.Meta_Description,lsql_Category.FatherID,lsql_Category.Meta_Keywords,lsql_Category.Payment_Mode,lsql_Category.Footer,lsql_Category.isCategory_link_title,lsql_Category.Direct_Links,lsql_Category.Newest_Link,lsql_Category.Payment_Description,lsql_Category.Number_of_Links,lsql_Category.Link_Add_Description,lsql_Category.isCategory_link,lsql_Category.categorytype,lsql_Category.Has_Changed_Links,lsql_Category.isCategory_link_url,lsql_Category.allow_link,lsql_Category.Category_Rank,lsql_Category.Category_Name,lsql_Category.CatRoot,lsql_Category.category_section_type,lsql_Category.Full_Name,lsql_Category.Has_New_Links,lsql_Category.Name,lsql_Category.CatDepth,lsql_Category.Header,lsql_Category.Category_Template,lsql_CatLinks.CategoryID FROM lsql_CatLinks,lsql_Category,lsql_Links WHERE lsql_CatLinks.LinkID = lsql_Links.ID AND lsql_CatLinks.CategoryID = lsql_Category.ID AND (lsql_CatLinks.CategoryID = '106' AND lsql_CatLinks.LinkID = '35796') from Links::Table::Links::category_detailed_url at /home/hc8zp7yi/public_html/cgi/admin/Links/Table/Links.pm line 499
GT::SQL::Driver::MYSQL::sth (9083): Query execution took: 0.000468s from Links::Table::Links::category_detailed_url at /home/hc8zp7yi/public_html/cgi/admin/Links/Table/Links.pm line 499
GT::SQL::Driver::MYSQL::sth (9083): Executing query: SELECT lsql_Links.*,lsql_Category.Meta_Description,lsql_Category.FatherID,lsql_Category.Meta_Keywords,lsql_Category.Payment_Mode,lsql_Category.Footer,lsql_Category.isCategory_link_title,lsql_Category.Direct_Links,lsql_Category.Newest_Link,lsql_Category.Payment_Description,lsql_Category.Number_of_Links,lsql_Category.Link_Add_Description,lsql_Category.isCategory_link,lsql_Category.categorytype,lsql_Category.Has_Changed_Links,lsql_Category.isCategory_link_url,lsql_Category.allow_link,lsql_Category.Category_Rank,lsql_Category.Category_Name,lsql_Category.CatRoot,lsql_Category.category_section_type,lsql_Category.Full_Name,lsql_Category.Has_New_Links,lsql_Category.Name,lsql_Category.CatDepth,lsql_Category.Header,lsql_Category.Category_Template,lsql_CatLinks.CategoryID FROM lsql_CatLinks,lsql_Category,lsql_Links WHERE lsql_CatLinks.LinkID = lsql_Links.ID AND lsql_CatLinks.CategoryID = lsql_Category.ID AND (lsql_CatLinks.CategoryID = '106' AND lsql_CatLinks.LinkID = '40281') from Links::Table::Links::category_detailed_url at /home/hc8zp7yi/public_html/cgi/admin/Links/Table/Links.pm line 499
GT::SQL::Driver::MYSQL::sth (9083): Query execution took: 0.000417s from Links::Table::Links::category_detailed_url at /home/hc8zp7yi/public_html/cgi/admin/Links/Table/Links.pm line 499
GT::Plugins (9083): Plugin: pre detailed_url running => Plugins::StaticURLtr::tr_detailed at /home/hc8zp7yi/public_html/cgi/admin/GT/Plugins.pm line 118.
GT::Plugins (9083): Plugin pre hook detailed_url stopped further plugins. at /home/hc8zp7yi/public_html/cgi/admin/GT/Plugins.pm line 123.
GT::Plugins (9083): Plugin: pre category_as_url running => Plugins::StaticURLtr::tr_category at /home/hc8zp7yi/public_html/cgi/admin/GT/Plugins.pm line 118.
GT::SQL::Driver::MYSQL::sth (9083): Executing query: SELECT * FROM lsql_Category WHERE Full_Name = 'Audio & Video' from Plugins::StaticURLtr::tr_category at /home/hc8zp7yi/public_html/cgi/admin/Plugins/StaticURLtr.pm line 36
GT::SQL::Driver::MYSQL::sth (9083): Query execution took: 0.000224s from Plugins::StaticURLtr::tr_category at /home/hc8zp7yi/public_html/cgi/admin/Plugins/StaticURLtr.pm line 36
GT::Plugins (9083): Plugin pre hook category_as_url stopped further plugins. at /home/hc8zp7yi/public_html/cgi/admin/GT/Plugins.pm line 123.
GT::Plugins (9083): Plugin: pre category_as_url running => Plugins::StaticURLtr::tr_category at /home/hc8zp7yi/public_html/cgi/admin/GT/Plugins.pm line 118.
GT::SQL::Driver::MYSQL::sth (9083): Executing query: SELECT * FROM lsql_Category WHERE Full_Name = 'Audio & Video/Media Management' from Plugins::StaticURLtr::tr_category at /home/hc8zp7yi/public_html/cgi/admin/Plugins/StaticURLtr.pm line 36
GT::SQL::Driver::MYSQL::sth (9083): Query execution took: 0.000180s from Plugins::StaticURLtr::tr_category at /home/hc8zp7yi/public_html/cgi/admin/Plugins/StaticURLtr.pm line 36
GT::Plugins (9083): Plugin pre hook category_as_url stopped further plugins. at /home/hc8zp7yi/public_html/cgi/admin/GT/Plugins.pm line 123.
The complete error is many more lines, however seems like it is repeating itself for every link in the system.
I think I need to install some perl modules or something... any ideas?
Thank you.
Vishal
-------------------------------------------------------
Install Error (Server Change)