Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [anup123] static pages and build related queries

Quote Reply
Re: [anup123] static pages and build related queries In reply to
Regarding Point Number (3). JIC the following Debug log could help evaluate the cause. Basically, It's the same as with many others, where some Links are editedable and the others are not. In this case it is wrt cats and subcats.

Subcats Which Can Be Modified

GT::SQL::Driver::MYSQL::sth (22080): Executing query: SELECT * FROM lsql_Category WHERE ( ID = 47 ) from Links::Browser::category_modify_form at (eval 641) line 12
GT::SQL::Driver::MYSQL::sth (19841): Executing query: SELECT ID,FatherID,Full_Name,Name,Number_of_Links FROM lsql_Category WHERE ID = 47 from Links::Category::_plg_modify at /admin/Links/Category.pm line 180
GT::SQL::Driver::MYSQL::sth (19841): Executing query: SELECT Timestmp FROM lsql_Category WHERE ( ID = 47 AND Timestmp > 20040301015901 ) from Links::Category::_plg_modify at /admin/Links/Category.pm line 201
GT::SQL::Driver::MYSQL::sth (19841): Executing query: UPDATE lsql_Category SET Description = '' , Newest_Link = '0000-00-00' , Category_Template = '' , Meta_Description = '' , Name = 'Driving Schools' , Footer = '' , Header = '' , Has_New_Links = 'No' , Number_of_Links = 0 , Has_Changed_Links = 'No' , Full_Name = 'Automobiles/Driving Schools' , Meta_Keywords = '' , FatherID = 30 WHERE ID = 47 from Links::Category::_plg_modify at /admin/Links/Category.pm line 201
GT::SQL::Driver::MYSQL::sth (19841): Executing query:
SELECT lsql_Links.ID
FROM lsql_CatLinks, lsql_Links
WHERE lsql_CatLinks.LinkID = lsql_Links.ID AND (lsql_CatLinks.CategoryID = '47')
ORDER BY isValidated DESC, Title ASC LIMIT 0, 25
from Links::Browser::_links_list_html at /admin/Links/Browser.pm line 1419

Subcats Which Cannot Modified

GT::SQL::Driver::MYSQL::sth (19842): Executing query: SELECT * FROM lsql_Category WHERE ( ID = 33 ) from Links::Browser::category_modify_form at (eval 641) line 12
GT::SQL::Driver::MYSQL::sth (19842): Query execution took: 0.000941s from Links::Browser::category_modify_form at (eval 641) line 12
GT::SQL::Driver::MYSQL::sth (21673): Executing query: SELECT ID,FatherID,Full_Name,Name,Number_of_Links FROM lsql_Category WHERE ID = 33 from Links::Category::_plg_modify at /admin/Links/Category.pm line 180
GT::SQL::Driver::MYSQL::sth (21673): Executing query: SELECT Timestmp FROM lsql_Category WHERE ( ID = 33 AND Timestmp > 20040226121328 ) from Links::Category::_plg_modify at /admin/Links/Category.pm line 201
GT::SQL::Table (21673): The record you are attempting to modify has changed since you last accessed it. at /admin/Links/Category.pm line 201.
[Mon Mar 1 03:52:12 2004] [error] Invalid Request: '' 'category_modify' at /admin/admin.cgi line 65.

Please note that the full paths have been removed from the above and only /admin onwards are given. There are no Links in the DB.

Any Clue?

Anup

Last edited by:

anup123: Feb 29, 2004, 2:16 PM
Subject Author Views Date
Thread static pages and build related queries anup123 8763 Feb 29, 2004, 6:44 AM
Thread Re: [anup123] static pages and build related queries
anup123 8579 Feb 29, 2004, 2:13 PM
Thread Re: [anup123] static pages and build related queries
anup123 8554 Mar 1, 2004, 6:53 AM
Thread Re: [anup123] static pages and build related queries
Karen 8578 Mar 1, 2004, 4:41 PM
Thread Re: [Karen] static pages and build related queries
anup123 8533 Mar 1, 2004, 7:51 PM
Post Re: [anup123] static pages and build related queries
Karen 8506 Mar 2, 2004, 9:04 AM
Thread Re: [anup123] static pages and build related queries
DogTags 8532 Mar 2, 2004, 4:27 AM
Post Re: [DogTags] static pages and build related queries
webmaster33 8429 Mar 13, 2004, 5:40 AM
Thread Re: [anup123] static pages and build related queries
Alex 8500 Mar 2, 2004, 8:49 AM
Thread Re: [Alex] static pages and build related queries
anup123 8500 Mar 2, 2004, 11:07 AM
Thread Re: [anup123] static pages and build related queries
Alex 8554 Mar 2, 2004, 11:23 AM
Thread Re: [Alex] static pages and build related queries
anup123 8466 Mar 2, 2004, 12:03 PM
Thread Re: [anup123] static pages and build related queries
Alex 8511 Mar 2, 2004, 12:07 PM
Thread Re: [Alex] static pages and build related queries
anup123 8515 Mar 2, 2004, 12:15 PM
Thread Re: [anup123] static pages and build related queries
Alex 8466 Mar 2, 2004, 12:20 PM
Thread Re: [Alex] static pages and build related queries
anup123 8536 Mar 2, 2004, 12:32 PM
Thread Re: [anup123] static pages and build related queries
Alex 8515 Mar 2, 2004, 12:48 PM
Post Re: [Alex] static pages and build related queries
anup123 8491 Mar 2, 2004, 1:38 PM
Post Re: [Alex] static pages and build related queries
sensovision 8413 Mar 18, 2004, 1:04 PM
Post Re: [Alex] static pages and build related queries
Robert_B 8395 Mar 18, 2004, 1:37 PM