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.


Have you seen this error

Login / Search

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

Community saint


The Guest Book or Comments Main_Comments block produce's this error when comments are submitted. but when you refresh the page the comment is listed ok. shoild the comment show up in the forum section. I have the email sent about the error if it is needed to help. I have never modified the code.

The posts are not showing in the forums but if I run fix errors on the SMF then they show up. I think the portal is posting to the wrong place. Os there any where to chabge the post to location for the guest book.

The same error is occurring with the Gallaries.

Unfortunately a query has failed [UPDATE smf_boards SET ID_LAST_MSG=26, numPosts=(numPosts+1), lastUpdated=1183357243 WHERE ID_BOARD=27 LIMIT 1] [Unknown column 'lastUpdated' in 'field list'] (ocPortal version: 3.2.2, PHP version: 4.4.4, URL: /ocportal/site/index.php?page=guestbook)


Last edit: by OZSlayer

Back to the top
 
Posted
Rating:
#33693
Avatar

Some versions of SMF seem to have this field missing, but I was never able to find out which version myself. What version are you running if you don't mind me asking?

We don't have an official fix here, but we're happy to help you patch around it. Change line 501 of sources/forum/smf.php from:

Code

      $this->connection->query('UPDATE '.$this->connection->get_table_prefix().'boards SET ID_LAST_MSG='.(string)intval($pid).', numPosts=(numPosts+1), lastUpdated='.strval($time).' WHERE ID_BOARD='.(string)intval($cf),1);
to:

Code

      $this->connection->query('UPDATE '.$this->connection->get_table_prefix().'boards SET ID_LAST_MSG='.(string)intval($pid).', numPosts=(numPosts+1) WHERE ID_BOARD='.(string)intval($cf),1);

This command was failing due to the missing field, and is involved with updating the forums record of what was the latest post in the 'board'. This explains the other problem you mentioned.


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:
#33697
Avatar

Community saint

I know it can not be the newest one as I just tested it.
The newest is 1.1.3.

I run http://otakuplayground.com and am hopping to make themes and other things for ocportal even though I no longer use it for otakuplayground.com I still love it and feel it could go far with the right help. It needs themes and needs people to advertise for it.
Back to the top
 
Posted
Rating:
#33706
Avatar

Community saint

 Hi Chris,

The SMF is 1.1.3 and the OCportal I upgrade yesterday to 3.2.2

I will try the fix after I have dropped my boys off at School. about an Hour.

Report back soon.

Back to the top
 
Posted
Rating:
#33707
Avatar

Community saint

Hmm strange, I tested it.
Hope the fix works.

I run http://otakuplayground.com and am hopping to make themes and other things for ocportal even though I no longer use it for otakuplayground.com I still love it and feel it could go far with the right help. It needs themes and needs people to advertise for it.
Back to the top
 
Posted
Rating:
#33714
Avatar

Community saint

Works Now fine

Thanks Chris,

That fixed the problem.

Is there anyway to get the members button working with SMF or should I direct it to the SMF page.

OZSlayer

 

Back to the top
 
Posted
Rating:
#33717
Avatar

Community saint

redirect, thats what I have to do with ipb.

I run http://otakuplayground.com and am hopping to make themes and other things for ocportal even though I no longer use it for otakuplayground.com I still love it and feel it could go far with the right help. It needs themes and needs people to advertise for it.
Back to the top
 
There are too many online users to list.
Control functions:

Quick reply   Contract

Your name:
Your message: