favorieten sorteren - foutmelding

[E-line]

Vandaag ging ik eens gebruikmaken van m'n favorieten, en ik had dus zo'n mooi lijstje gemaakt met favorieten. Toen zag ik daarboven een linkje staan dat er zo uitzag:

quote:

Sorteer op forumvolgorde en vervolgens op laatste reactie

Ik klik op dat linkje en m'n hele scherm stond vol onbegrijpelijke code... Lijkt me een bug die te fixen is

[Nunc]

quote:

E-line schreef op 06 december 2005 om 13:30:
Toen zag ik daarboven een linkje staan dat er zo uitzag:
[...]
Ik klik op dat linkje

Doet me denken aan een ander verhaal waar de nieuwsgierigheid van de vrouw ook fataal was  

[E-line]

 

[Zijnkind]

Werk je toevallig met een apple ?

[E-line]

nee niet eens...

[E-line]

* E-line heeft niet geleerd van de straf en ging kijken of de bug al was opgelost... autsj

[Zijnkind]

VastVol houdend typje

edit:Eventjes het experiment geprobeerd te reproduceren en kwam tot dezelfde uitkomst. zag er ongeveer zo uit:

query: SELECT FP.Content as topic_firstmessage_content, LP.Content as topic_lastmessage_content, IF(ISNULL(bm2.TopicID),1,0) as topic_is_bookmarked, bm2.Name as topic_bookmark_name, bm2.Postreminder as topic_bookmark_is_postreminder, F_Topics.Name as topic_name, F_Topics.TopicID as topic_id, F_Topics.Viewcount as topic_viewcount, F_Topics.Date as topic_timestamp, F_Topics.TopicaliasID as topic_alias_id, IF(F_Topics.TopicaliasID > 0,1,0) as topic_is_alias, FROM_UNIXTIME(F_Topics.Lastmessage,'%d-%m-%Y %H:%i') as topic_lastmessage_date, FROM_UNIXTIME(F_Topics.Date,'%d-%m-%Y %H:%i') as topic_date, F_Topics.Lastmessage as topic_lastmessage_timestamp, F_Topics.LastmessageID as topic_lastmessage_id, F_Topics.FirstmessageID as topic_firstmessage_id, F_Topics.Lastmodified as topic_lastmodified_timestamp, F_Topics.Status+0 as topic_status_id, F_Topics.Status as topic_status, F_Topics.Messagecount as topic_messagecount, F_Topics.Messagecount-'1' as topic_replycount, F_Topics.ForumID as topic_forum_id, CEILING((F_Topics.Messagecount)/25) as topic_pagecount, IF(F_Topics.Status='Closed',1,0) as topic_is_closed, F_Topics.UserID as topic_starter_id, F_Topics.LastposterID as topic_lastposter_id, F_Topics.Data as topic_data, IF(F_Topics.Lastmessage > 1134166021,1,0) as topic_has_new, '' as topic_insert_notificationlink, concat('http://forum.gkv.nl/forum/list_messages/',IF(F_Topics.TopicaliasID > 0,F_Topics.TopicaliasID,F_Topics.TopicID)) as topic_listmessageslink, concat('http://forum.gkv.nl/forum/list_messages/',IF(F_Topics.TopicaliasID > 0,F_Topics.TopicaliasID,F_Topics.TopicID),'/////1134166021') as topic_listmessages_resumelink, concat('http://forum.gkv.nl/forum/list_message/',F_Topics.LastmessageID,'#',F_Topics.LastmessageID) as topic_lastmessage_link, IF(F_Topics.TopicaliasID > 0,'',concat('http://forum.gkv.nl/forum/insert_bookmark/',F_Topics.TopicID)) as topic_insertbookmark_link, concat('http://forum.gkv.nl/forum/list_usernotes/',F_Users.UserID) as topic_starter_noteslink, F_Users.Notescount as topic_starter_notecount, concat('http://forum.gkv.nl/forum/list_pushmessages/1/',F_Users.UserID) as topic_starter_pushmessageslink, concat('http://forum.gkv.nl/forum/list_pushmessages/1/',F_Users.UserID,'/1') as topic_starter_pushmessages_alllink, concat('http://forum.gkv.nl/forum/list_sentpushmessages/1/',F_Users.UserID) as topic_starter_sent_pushmessageslink, concat('http://forum.gkv.nl/forum/send_pushmessage/',F_Users.UserID) as topic_starter_send_pushmessagelink, concat('http://forum.gkv.nl/admin/admin.php?data%5Bstep%5D=2&action=lookup_user&data%5Bsearch%5D=userid&data%5Busername%5D=',F_Users.UserID) as topic_starter_externaleditorlink, F_Users.Firstname as topic_starter_firstname, F_Users.Lastname as topic_starter_lastname, F_Users.Sex as topic_starter_sex, F_Users.Subtitle as topic_starter_subtitle, F_Users.Birthday as topic_starter_birthday, F_Users.Location as topic_starter_location, F_Users.Occupation as topic_starter_occupation, F_Users.Education as topic_starter_education, F_Users.Interests as topic_starter_interests, F_Users.Homepage as topic_starter_homepage, F_Users.Homepage as topic_starter_homepage, F_Users.Birthday as topic_starter_birthday, F_Users.UserID as topic_starter_id, F_Users.Title as topic_starter_title, F_Users.Status as topic_starter_status, F_Users.Nickname as topic_starter_nickname, F_Users.ICQ as topic_starter_icq, F_Users.IconURL as topic_starter_iconurl, F_Users.Icon as topic_starter_uploadedicon_filename, F_Users.Signature as topic_starter_signature, FROM_UNIXTIME(F_Users.LastprofileEdit,'%W %d %M %Y %H:%i') as topic_starter_lastprofile_edit_date, F_Users.LastprofileEdit as topic_starter_lastprofile_edit_timestamp, F_Users.Messagecount as topic_starter_messagecount, F_Users.Pushmessagecount as topic_starter_pushmessagecount, F_Users.Profilemessagecount as topic_starter_profilemessagecount, F_Users.LastProfilemessage as topic_starter_lastprofilemessage,F_Users.LastProfileActivity as topic_starter_lastprofileactivity, F_Users.CreationTime as topic_starter_creationtime, FROM_UNIXTIME(F_Users.CreationTime,'%W %d %M %Y %H:%i') as topic_starter_creationtime_date, IF(F_Users.IconURL != '', F_Users.IconURL, IF(F_Users.Icon != '',concat('http://forum.gkv.nl/usericons/',F_Users.UserID,'/',F_Users.Icon),'')) as topic_starter_icon, DATE_FORMAT(F_Users.Birthday,'%d-%m-%Y') as topic_starter_birthday_short, DATE_FORMAT(F_Users.Birthday,'%W %d %M %Y') as topic_starter_birthday_verbal, concat('http://forum.gkv.nl/forum/vcard/',F_Users.UserID) as topic_starter_vcardlink, concat('http://forum.gkv.nl/forum/user_profile/',F_Users.UserID) as topic_starter_profilelink, concat('http://forum.gkv.nl/forum/myreact/',F_Users.UserID) as topic_starter_myreactlink, '' as topic_starter_directmessagelink, IF(1024 & F_Users.Reactpreferences, concat('http://forum.gkv.nl/forum/list_profilemessages/',F_Users.UserID),'') as topic_starter_profilemessageslink, concat('http://forum.gkv.nl/forum/find/poster/',F_Users.UserID,'/topics') as topic_starter_findlink, concat('http://forum.gkv.nl/forum/find/poster/',F_Users.UserID,'/messages') as topic_starter_findmessageslink, IF(1 & F_Users.Reactpreferences,1,0) as topic_starter_has_lastvisitpublic, IF(1 & F_Users.Reactpreferences > 0,IF(F_Users.LastVisit > 1134208653,1,0),0) as topic_starter_is_online, IF(4096 & F_Users.Reactpreferences,F_Users.Lastaction,'') as topic_starter_last_action, IF(1024 & F_Users.Reactpreferences,1,0) as topic_starter_has_profilemessages_enabled, IF(4096 & F_Users.Reactpreferences,concat('http://forum.gkv.nl/forum/',F_Users.Lastaction),'') as topic_starter_last_action_link, IF(F_Users.EmailPublic = 1,1,0) as topic_starter_has_emailpublic, CEILING(F_Users.Messagecount / CEILING((UNIX_TIMESTAMP() - F_Users.CreationTime) / 86400)) as topic_starter_messages_per_day, F_Users.ItemLimit as topic_starter_limit, IF(F_Users.Birthday > '0000-00-00', CONCAT_WS('-',DAYOFMONTH(F_Users.Birthday),MONTH(F_Users.Birthday),YEAR(F_Users.Birthday)), '') as topic_starter_birthday_alt, IF((INTERVAL YEAR(NOW()) - YEAR(F_Users.Birthday) YEAR + F_Users.Birthday) >= NOW(), YEAR(NOW()) - YEAR(F_Users.Birthday) - 1, YEAR(NOW()) - YEAR(F_Users.Birthday)) as topic_starter_age, F_Users.Reactpreferences as topic_starter_preferences_raw, F_Users.LastVisit as topic_starter_lastvisit, F_Users.NoDoublePostCheck as topic_starter_no_doublepost_check, FROM_UNIXTIME(F_Users.LastVisit,'%d-%m-%Y %H:%i') as topic_starter_lastvisit_date, F_Users.Lastmessagehash as topic_starter_lastmessagehash, F_Users.Banned as topic_starter_is_banned, F_Users.Active as topic_starter_is_active, F_Users.Deleted as topic_starter_is_deleted, F_Users.IP as topic_starter_creationip, UNIX_TIMESTAMP(F_Users.RecordTimestamp) as topic_starter_lastmodified, F_Users.LastProfileActivity as topic_starter_lastactivity,F_Users.Locale as topic_starter_locale, F_Users.EmailRegistration as topic_starter_email_registration, F_Users.SessionTime as topic_starter_sessiontime, F_Users.Templateset as topic_starter_templateset, F_Users.RulesException as topic_starter_has_rules_exception, F_Users.CCLPassword as topic_starter_cclpassword, F_Users.Forumfilter as topic_starter_forum_filter, F_Users.Myreactforums as topic_starter_myreact_forums, F_Users.Myreactitemlimits as topic_starter_myreact_item_limits, F_Users.PasswordExpires as topic_starter_passwordexpires, F_Users.PasswordExpiration as topic_starter_passwordexpiration, F_Users.Password as topic_starter_password, F_Users.Email as topic_starter_email, F_Users.MSN as topic_starter_msnid , F_Users.MSN as topic_starter_msn , concat('http://forum.gkv.nl/forum/list_usernotes/',L_Users.UserID) as topic_lastposter_noteslink, L_Users.Notescount as topic_lastposter_notecount, concat('http://forum.gkv.nl/forum/list_pushmessages/1/',L_Users.UserID) as topic_lastposter_pushmessageslink, concat('http://forum.gkv.nl/forum/list_pushmessages/1/',L_Users.UserID,'/1') as topic_lastposter_pushmessages_alllink, concat('http://forum.gkv.nl/forum/list_sentpushmessages/1/',L_Users.UserID) as topic_lastposter_sent_pushmessageslink, concat('http://forum.gkv.nl/forum/send_pushmessage/',L_Users.UserID) as topic_lastposter_send_pushmessagelink, concat('http://forum.gkv.nl/admin/admin.php?data%5Bstep%5D=2&action=lookup_user&data%5Bsearch%5D=userid&data%5Busername%5D=',L_Users.UserID) as topic_lastposter_externaleditorlink, L_Users.Firstname as topic_lastposter_firstname, L_Users.Lastname as topic_lastposter_lastname, L_Users.Sex as topic_lastposter_sex, L_Users.Subtitle as topic_lastposter_subtitle, L_Users.Birthday as topic_lastposter_birthday, L_Users.Location as topic_lastposter_location, L_Users.Occupation as topic_lastposter_occupation, L_Users.Education as topic_lastposter_education, L_Users.Interests as topic_lastposter_interests, L_Users.Homepage as topic_lastposter_homepage, L_Users.Homepage as topic_lastposter_homepage, L_Users.Birthday as topic_lastposter_birthday, L_Users.UserID as topic_lastposter_id, L_Users.Title as topic_lastposter_title, L_Users.Status as topic_lastposter_status, L_Users.Nickname as topic_lastposter_nickname, L_Users.ICQ as topic_lastposter_icq, L_Users.IconURL as topic_lastposter_iconurl, L_Users.Icon as topic_lastposter_uploadedicon_filename, L_Users.Signature as topic_lastposter_signature, FROM_UNIXTIME(L_Users.LastprofileEdit,'%W %d %M %Y %H:%i') as topic_lastposter_lastprofile_edit_date, L_Users.LastprofileEdit as topic_lastposter_lastprofile_edit_timestamp, L_Users.Messagecount as topic_lastposter_messagecount, L_Users.Pushmessagecount as topic_lastposter_pushmessagecount, L_Users.Profilemessagecount as topic_lastposter_profilemessagecount, L_Users.LastProfilemessage as topic_lastposter_lastprofilemessage,L_Users.LastProfileActivity as topic_lastposter_lastprofileactivity, L_Users.CreationTime as topic_lastposter_creationtime, FROM_UNIXTIME(L_Users.CreationTime,'%W %d %M %Y %H:%i') as topic_lastposter_creationtime_date, IF(L_Users.IconURL != '', L_Users.IconURL, IF(L_Users.Icon != '',concat('http://forum.gkv.nl/usericons/',L_Users.UserID,'/',L_Users.Icon),'')) as topic_lastposter_icon, DATE_FORMAT(L_Users.Birthday,'%d-%m-%Y') as topic_lastposter_birthday_short, DATE_FORMAT(L_Users.Birthday,'%W %d %M %Y') as topic_lastposter_birthday_verbal, concat('http://forum.gkv.nl/forum/vcard/',L_Users.UserID) as topic_lastposter_vcardlink, concat('http://forum.gkv.nl/forum/user_profile/',L_Users.UserID) as topic_lastposter_profilelink, concat('http://forum.gkv.nl/forum/myreact/',L_Users.UserID) as topic_lastposter_myreactlink, '' as topic_lastposter_directmessagelink, IF(1024 & L_Users.Reactpreferences, concat('http://forum.gkv.nl/forum/list_profilemessages/',L_Users.UserID),'') as topic_lastposter_profilemessageslink, concat('http://forum.gkv.nl/forum/find/poster/',L_Users.UserID,'/topics') as topic_lastposter_findlink, concat('http://forum.gkv.nl/forum/find/poster/',L_Users.UserID,'/messages') as topic_lastposter_findmessageslink, IF(1 & L_Users.Reactpreferences,1,0) as topic_lastposter_has_lastvisitpublic, IF(1 & L_Users.Reactpreferences > 0,IF(L_Users.LastVisit > 1134208653,1,0),0) as topic_lastposter_is_online, IF(4096 & L_Users.Reactpreferences,L_Users.Lastaction,'') as topic_lastposter_last_action, IF(1024 & L_Users.Reactpreferences,1,0) as topic_lastposter_has_profilemessages_enabled, IF(4096 & L_Users.Reactpreferences,concat('http://forum.gkv.nl/forum/',L_Users.Lastaction),'') as topic_lastposter_last_action_link, IF(L_Users.EmailPublic = 1,1,0) as topic_lastposter_has_emailpublic, CEILING(L_Users.Messagecount / CEILING((UNIX_TIMESTAMP() - L_Users.CreationTime) / 86400)) as topic_lastposter_messages_per_day, L_Users.ItemLimit as topic_lastposter_limit, IF(L_Users.Birthday > '0000-00-00', CONCAT_WS('-',DAYOFMONTH(L_Users.Birthday),MONTH(L_Users.Birthday),YEAR(L_Users.Birthday)), '') as topic_lastposter_birthday_alt, IF((INTERVAL YEAR(NOW()) - YEAR(L_Users.Birthday) YEAR + L_Users.Birthday) >= NOW(), YEAR(NOW()) - YEAR(L_Users.Birthday) - 1, YEAR(NOW()) - YEAR(L_Users.Birthday)) as topic_lastposter_age, L_Users.Reactpreferences as topic_lastposter_preferences_raw, L_Users.LastVisit as topic_lastposter_lastvisit, L_Users.NoDoublePostCheck as topic_lastposter_no_doublepost_check, FROM_UNIXTIME(L_Users.LastVisit,'%d-%m-%Y %H:%i') as topic_lastposter_lastvisit_date, L_Users.Lastmessagehash as topic_lastposter_lastmessagehash, L_Users.Banned as topic_lastposter_is_banned, L_Users.Active as topic_lastposter_is_active, L_Users.Deleted as topic_lastposter_is_deleted, L_Users.IP as topic_lastposter_creationip, UNIX_TIMESTAMP(L_Users.RecordTimestamp) as topic_lastposter_lastmodified, L_Users.LastProfileActivity as topic_lastposter_lastactivity,L_Users.Locale as topic_lastposter_locale, L_Users.EmailRegistration as topic_lastposter_email_registration, L_Users.SessionTime as topic_lastposter_sessiontime, L_Users.Templateset as topic_lastposter_templateset, L_Users.RulesException as topic_lastposter_has_rules_exception, L_Users.CCLPassword as topic_lastposter_cclpassword, L_Users.Forumfilter as topic_lastposter_forum_filter, L_Users.Myreactforums as topic_lastposter_myreact_forums, L_Users.Myreactitemlimits as topic_lastposter_myreact_item_limits, L_Users.PasswordExpires as topic_lastposter_passwordexpires, L_Users.PasswordExpiration as topic_lastposter_passwordexpiration, L_Users.Password as topic_lastposter_password, L_Users.Email as topic_lastposter_email, L_Users.MSN as topic_lastposter_msnid , L_Users.MSN as topic_lastposter_msn , F_Bookmarks.Name as bookmark_name, F_Bookmarks.Folder as bookmark_folder_name, F_Bookmarks.Postreminder as bookmark_is_postreminder, concat('http://forum.gkv.nl/forum/update_bookmark/',F_Bookmarks.TopicID) as bookmark_updatebookmarklink, IF(F_Bookmarks.MessageID, concat('http://forum.gkv.nl/forum/list_message/',F_Bookmarks.MessageID,'#',F_Bookmarks.MessageID), concat('http://forum.gkv.nl/forum/list_messages/',F_Bookmarks.TopicID) ) as bookmark_listmessageslink , F_Forums.ForumID as topic_forum_id, F_Forums.Name as topic_forum_name, F_Forums.Messagecount as topic_forum_messagecount, F_Forums.Topiccount as topic_forum_topiccount, F_Forums.CategoryID as topic_forum_category_id, F_Forums.Days as topic_forum_days, F_Forums.Admins as topic_forum_admins, FROM_UNIXTIME(F_Forums.Lastmodified,'%d-%m-%Y %H:%i') as topic_forum_lastmodified_date, F_Forums.Lastmodified as topic_forum_lastmodified_timestamp, FROM_UNIXTIME(F_Forums.Lastmessage,'%d-%m-%Y %H:%i') as topic_forum_lastmessage_date, F_Forums.Lastmessage as topic_forum_lastmessage_timestamp, IF(F_Forums.Lastmessage > 1134166021,1,0) as topic_forum_has_new, concat('http://forum.gkv.nl/forum/list_topics/',F_Forums.ForumID) as topic_forum_link, '' as topic_forum_insert_notificationlink, F_Forums.Description as topic_forum_description, F_Forums.Abbr as topic_forum_abbr, F_Forums.Data as topic_forum_data, F_Forums.Topictypesmustappear as topic_forum_topictypesmustappear, F_Forums.Ordertopicsdateby as topic_forum_ordertopicsdateby, F_Forums.Ordertopicstypeby as topic_forum_ordertopicstypeby, F_Forums.Type as topic_forum_type, '0' as sort_by_forum,'0' as sort_by_folder FROM F_Bookmarks LEFT JOIN F_Topics ON F_Bookmarks.TopicID = F_Topics.TopicID LEFT JOIN F_Users ON (F_Users.UserID = F_Topics.UserID) LEFT JOIN F_Users AS L_Users ON (L_Users.UserID = F_Topics.LastposterID) LEFT JOIN F_Forums ON (F_Forums.ForumID = F_Topics.ForumID) LEFT JOIN F_Bookmarks as bm2 ON (bm2.UserID = 932 AND bm2.TopicID = F_Topics.TopicID) LEFT JOIN F_Messages as FP ON (F_Topics.FirstmessageID > 0 AND F_Topics.FirstmessageID = FP.MessageID) LEFT JOIN F_Messages as LP ON (F_Topics.LastmessageID > 0 AND F_Topics.LastmessageID = LP.MessageID) WHERE F_Bookmarks.UserID = '932' AND !F_Bookmarks.Deleted AND !F_Topics.Deleted AND !F_Forums.Deleted AND Postreminder ORDER BY F_Bookmarks.Postreminder DESC, F_Topics.Lastmessage DESC LIMIT 0, 25
db-error:1052
Column 'Postreminder' in where clause is ambiguous

[E-line]

die foutmelding? ja inderdaad

[AVee]

Tja, dat krijg je ervan...
Alsof linkjes bedoeld zijn om op te klikken...

Het fout laten gaan lukt mij ook, maar het lukt me nog niet echt om te ontdekken hoe het dan wel zou moeten werken...

[Nunc]

wat is 'favorieten sorteren' eigenlijk? Wat had het moeten doen als het werkte?
(* Nunc is gewoon niet zo nieuwsgierig ingesteld)

[AVee]

quote:

Nunc schreef op 13 december 2005 om 11:34:
wat is 'favorieten sorteren' eigenlijk? Wat had het moeten doen als het werkte?

Erm, het lijstje met favorieten sorteren misschien...
(op volgorde van het forum waar het topic in staat ipv op volgorde van de laatste reactie.)

[Harm]

Meld het eens aan Parse, vaak ontstaat deze fout doordat er iets niet helemaal goed is met de database namelijk. En dat kunnen zij wel weer oplossen.