Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Install Error (Server Change)

Quote Reply
Install Error (Server Change)
I just tried doing Build All (changed the server few hours before) and am getting this error, anyone knows how to fix this?

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
-------------------------------------------------------
Quote Reply
Re: [SWDevil.Com] Install Error (Server Change) In reply to
Mmm, I don't see any errors in that?? (just normal debugging, which would go away if you disable "debug" in Setup > Misc Options)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Install Error (Server Change) In reply to
My Bad.. I was getting some error and hence I turned the debugging on.. So here is what I get when debugging is off:

Code:
Content-type: text/html

<p><font face='Tahoma,Arial,Helvetica' size=2>A fatal error has occured:</font></p><blockquote><pre>Unable to open: &#039;/home/hc8zp7yi/public_html/download/32228/fileplay.php&#039;: No such file or directory at nph-build.cgi line 1017
main::_open_write(&#039;/home/hc8zp7yi/public_html/download/32228/fileplay.php&#039;) called at nph-build.cgi line 566
main::_build_detailed(&#039;HASH(0x1c06cd60)&#039;) called at /home/hc8zp7yi/public_html/cgi/admin/GT/Plugins.pm line 133
GT::Plugins::dispatch(&#039;GT::Plugins=HASH(0x1c06cea0)&#039;, &#039;create_detailed&#039;, &#039;CODE(0x1c00f0a0)&#039;, &#039;HASH(0x1c06cd60)&#039;) called at nph-build.cgi line 103
main::build_all() called at nph-build.cgi line 65
main::main() called at nph-build.cgi line 42
</pre></blockquote><p><font face='Tahoma,Arial,Helvetica' size=2>Please enable debugging in setup for more details.</font></p>
Unable to open: '/home/hc8zp7yi/public_html/download/32228/fileplay.php': No such file or directory at nph-build.cgi line 1017
main::_open_write('/home/hc8zp7yi/public_html/download/32228/fileplay.php') called at nph-build.cgi line 566
main::_build_detailed('HASH(0x1c06cd60)') called at /home/hc8zp7yi/public_html/cgi/admin/GT/Plugins.pm line 133
GT::Plugins::dispatch('GT::Plugins=HASH(0x1c06cea0)', 'create_detailed', 'CODE(0x1c00f0a0)', 'HASH(0x1c06cd60)') called at nph-build.cgi line 103
main::build_all() called at nph-build.cgi line 65
main::main() called at nph-build.cgi line 42

It is building detailed pages, however is not building category pages :(

Vishal
-------------------------------------------------------
Quote Reply
Re: [SWDevil.Com] Install Error (Server Change) In reply to
Quote:
Unable to open: '/home/hc8zp7yi/public_html/download/32228/fileplay.php':

Is this where your detailed pages build, or something else? I expect the problem is just that the file isn't CHMOD 666 (the path looks ok, but hard to tell obviously, as I don't have FTP)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!