HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


[Resolved] Catalog entry comment stack trace

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#85683 (In Topic #17587)
Avatar

Community saint

Adding a comment to a catalog entry gave me this stack trace. The comment was created. Enjoy!  :thumbs:

Code

An error has occurred

A query that had to return something returned nothing: SELECT c_name FROM oc_catalogue_categories WHERE (id IS NULL) (version: 8.0.1, PHP version: 5.3.8, URL: /data/post_comment.php?keep_session=570090107)

Here is the stack trace:

Below is a stack trace revealing the state the software was in when the error occurred. If this represents a bug in the unmodified software, you may want to check ocPortal website for a fix, and if there isn't one, report this as a bug. Please note that merely posting a stack trace is not sufficient for us to solve your problem; the stack trace is just an aid that presents us with additional information. We still need to know the error message, what you tried to do, how you tried to do it, version numbers, and any other appropriate information.
We apologise for this problem and if it's a bug we hope you will work with us so that we can fix it for you promptly.

File    '/home/whiteisl/public_html/sources/failure.php'
Line    '696'
Function    'get_html_trace'
Args   

File    '/home/whiteisl/public_html/sources/global2.php'
Line    '1,000'
Function    '_fatal_exit'
Args   
object


File    '/home/whiteisl/public_html/sources/database.php'
Line    '584'
Function    'fatal_exit'
Args   
object


File    '/home/whiteisl/public_html/sources/feedback.php'
Line    '100'
Function    'query_value'
Class    'database_driver'
Object    object
Type    '->'
Args   
'catalogue_categories'

'c_name'

array ( 'id' => NULL, )


File    '/home/whiteisl/public_html/sources/hooks/systems/notifications/comment_posted.php'
Line    '120'
Function    'may_view_content_behind_feedback_code'
Args   
1198

'catalogues'

'_code_72'


File    '/home/whiteisl/public_html/sources/notifications.php'
Line    '214'
Function    'list_members_who_have_enabled'
Class    'Hook_Notification_comment_posted'
Object    Hook_Notification_comment_posted::__set_state(array( ))
Type    '->'
Args   
'comment_posted'

'catalogues__code_72'

NULL

0

300


Function    'dispatch'
Class    'Notification_dispatcher'
Object    Notification_dispatcher::__set_state(array( 'notification_code' => 'comment_posted', 'code_category' => 'catalogues__code_72', 'subject' => 'New comment posted for getGatewayIPAddress', 'message' => 'A new comment has been posted on GambasForum on **************.com, for getGatewayIPAddress: http://**************.com/index.php?page=catalogues&type=entry&id=code-snippets-home%2Fgambas-2-snippets%2Fgetgatewayipaddress The comment follows... [quote="http://**************.com/index.php?page=catalogues&type=entry&id=code-snippets-home%2Fgambas-2-snippets%2Fgetgatewayipaddress"]I just found this one. It should also work with G3 with little or no mods. I\'ll probably steal it for my PingCheck project. :thumbs: [/quote]', 'to_member_ids' => NULL, 'from_member_id' => NULL, 'priority' => 3, 'store_in_staff_messaging_system' => false, 'no_cc' => false, ))
Type    '->'
Args   

Parameters

options   
a:7:{i:0;s:16:\"catalogues__code\";i:1;s:2:\"72\";i:2;i:1;i:3;i:1198;i:4;s:131:\"http://**************.com/index.php?page=catalogues&type=entry&id=code-snippets-home%2Fgambas-2-snippets%2Fgetgatewayipaddress\";i:5;s:19:\"getGatewayIPAddress\";i:6;N;}
hash   
9e399u1hER8lvHvuK1KdLCVIX3QsSWd5MLWAS
_comment_form_post   
1
_validated   
1
comcode__post   
1
title   
http_referer   
http://**************.com/index.php?page=catalogues&type=entry&id=code-snippets-home%2Fgambas-2-snippets%2Fgetgatewayipaddress
post   
I just found this one.

It should also work with G3 with little or no mods. I\'ll probably steal it for my PingCheck project.  :thumbs:

Steve
Back to the top
 
Posted
Rating:
#85702
Avatar

Well, this was strange. The stack trace implies the entry is in a category 'NULL' and then then code fails to look it up. That should not be possible. I'll make the code tolerate this, but it's still strange.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#85704
Avatar

Never mind, I've got it…


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#85707
Avatar

Fixed:

Attachment
sources\hooks\systems\notifications\comment_posted.php
» Download: comment_posted.php (4 Kb, 109 downloads so far)
Attachment
sources\feedback.php
» Download: feedback.php (38 Kb, 99 downloads so far)


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#85710
Avatar

Community saint

Well, I'm good at finding the things that are not suppose to happen. I've always believed nothing about what I do is normal.  :lol:

Steve
Back to the top
 
Posted
Rating:
#85712
Avatar

Community saint

hmmm… feedback.php is one you've fixed before.

That fixed it.

I'll have to see what the previous feedback.php fixed and check it too, but later.

Steve
Back to the top
 
Posted
Item has a rating of 5 (Liked by sholzy)  
Rating:
#85713
Avatar

feedback.php is not actually needed for this change. feedback.php dealt with the symptoms, comment_posted.php was the cure.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#85716
Avatar

Community saint

Ah, ok. Thanks again, Chris!

Steve
Back to the top
 
Posted
Rating:
#86658
Avatar

Well-settled

Are these in the 8.1 package?  I got the same error message as in this thread, but comment_posted file I have is dated May 28th.

Thanks
Back to the top
 
Posted
Rating:
#86676
Avatar

Community saint

D-Train said

Are these in the 8.1 package?  I got the same error message as in this thread, but comment_posted file I have is dated May 28th.

Thanks
Yes.


Steve
Back to the top
 
Posted
Rating:
#86780
Avatar

It may be a different error, please post the full stack trace and I can check.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Contract

Your name:
Your message: