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 9080 Feb 29, 2004, 6:44 AM
Thread Re: [anup123] static pages and build related queries
anup123 8895 Feb 29, 2004, 2:13 PM
Thread Re: [anup123] static pages and build related queries
anup123 8869 Mar 1, 2004, 6:53 AM
Thread Re: [anup123] static pages and build related queries
Karen 8893 Mar 1, 2004, 4:41 PM
Thread Re: [Karen] static pages and build related queries
anup123 8848 Mar 1, 2004, 7:51 PM
Post Re: [anup123] static pages and build related queries
Karen 8821 Mar 2, 2004, 9:04 AM
Thread Re: [anup123] static pages and build related queries
DogTags 8847 Mar 2, 2004, 4:27 AM
Post Re: [DogTags] static pages and build related queries
webmaster33 8744 Mar 13, 2004, 5:40 AM
Thread Re: [anup123] static pages and build related queries
Alex 8815 Mar 2, 2004, 8:49 AM
Thread Re: [Alex] static pages and build related queries
anup123 8817 Mar 2, 2004, 11:07 AM
Thread Re: [anup123] static pages and build related queries
Alex 8870 Mar 2, 2004, 11:23 AM
Thread Re: [Alex] static pages and build related queries
anup123 8782 Mar 2, 2004, 12:03 PM
Thread Re: [anup123] static pages and build related queries
Alex 8827 Mar 2, 2004, 12:07 PM
Thread Re: [Alex] static pages and build related queries
anup123 8830 Mar 2, 2004, 12:15 PM
Thread Re: [anup123] static pages and build related queries
Alex 8783 Mar 2, 2004, 12:20 PM
Thread Re: [Alex] static pages and build related queries
anup123 8852 Mar 2, 2004, 12:32 PM
Thread Re: [anup123] static pages and build related queries
Alex 8831 Mar 2, 2004, 12:48 PM
Post Re: [Alex] static pages and build related queries
anup123 8806 Mar 2, 2004, 1:38 PM
Post Re: [Alex] static pages and build related queries
sensovision 8728 Mar 18, 2004, 1:04 PM
Post Re: [Alex] static pages and build related queries
Robert_B 8712 Mar 18, 2004, 1:37 PM