Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Install Error (Server Change)

Apr 25, 2011, 3:42 PM
SWDevil.Com
Enthusiast (974 posts)
Apr 25, 2011, 3:42 PM
Post #1 of 4
Views: 504
Shortcut
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

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------
Apr 26, 2011, 5:58 AM
Andy
Veteran / Moderator (17366 posts)
Andy's avatar
Apr 26, 2011, 5:58 AM
Post #2 of 4
Views: 478
Shortcut
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

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Apr 26, 2011, 3:13 PM
SWDevil.Com
Enthusiast (974 posts)
Apr 26, 2011, 3:13 PM
Post #3 of 4
Views: 458
Shortcut
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

-------------------------------------------------------
Web Hosting Kit: A to Z of Web Hosting! http://www.webhostingkit.com/
Software Devil: Software Search Made Easy! http://www.softwaredevil.com/
-------------------------------------------------------
Apr 27, 2011, 12:34 AM
Andy
Veteran / Moderator (17366 posts)
Andy's avatar
Apr 27, 2011, 12:34 AM
Post #4 of 4
Views: 439
Shortcut
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

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates