1. Home
  2. Community
  3. Troubleshooting and Problems
  4. After IPB3 Upgrade Site Doesn't Work

This website can use cookies to improve the user experience

This website can use cookies to improve the user experience and to provide certain services and functions to users. Cookies contain small amounts of information (such as login information and user preferences) and will be stored on your device.

Enable All Cookies Privacy Policy

After IPB3 Upgrade Site Doesn't Work

Troubleshooting and Problems 156 This topic was started by ,


avatar
error 232
From: -
After IPB3 Upgrade Site Doesn't Work

I did upgrade to IPB3 forum and site doesn't wotk anymore.


The MySQL database of the IP.Board 3 installation has encountered the following problem:

The MySQL database server has returned 1054: Unknown column 'id' in 'field list' while executing SELECT COUNT(id) FROM ibf_members



SELECT COUNT(id) FROM ibf_members

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic

1 Re: After IPB3 Upgrade Site Doesn't Work
avatar
OP 232
From: -
Works like a charm. Thanks.

What about my post below this about images? Also all links kick me back to frontpage.
1 Re: After IPB3 Upgrade Site Doesn't Work
avatar
Editor
0
From: -
The following SQL queries should work:

    $results = $uwrapper -> bbquery( "SELECT COUNT(member_id) FROM " . $uwrapper -> bbescape( $preferences[ 'website_uwrapper_prefix' ] ) . "members" ); 
    list($total_users) = $database -> dbrow( $results );     
         
    $results = $uwrapper -> bbquery( "SELECT COUNT(pid) FROM " . $uwrapper -> bbescape( $preferences[ 'website_uwrapper_prefix' ] ) . "posts" ); 
    list($total_posts) = $database -> dbrow( $results );         
     
    $results = $uwrapper -> bbquery( "SELECT name FROM " . $uwrapper -> bbescape( $preferences[ 'website_uwrapper_prefix' ] ) . "members WHERE member_group_id = '3' ORDER BY joined DESC LIMIT 1" ); 
    list($new_member) = $database -> dbrow( $results );
1 Re: After IPB3 Upgrade Site Doesn't Work
avatar
OP 232
From: -
 

<?php



if( !defined( "CONTENTTELLER" ) )

{

 die( "Error" );

}



$ipb_stats = ( isset( $datastore[ 'ipb_stats' ] ) ) ? $datastore[ 'ipb_stats' ] : "" ;



if( !$ipb_stats )

{

  global $uwrapper;



   $ipb_stats = "";              

  $uwrapper -> bbconnect();

      

  $results = $uwrapper -> bbquery( "SELECT COUNT(id) FROM " . $uwrapper -> bbescape( $preferences[ 'website_uwrapper_prefix' ] ) . "members" );

   list($total_users) = $database -> dbrow( $results ); 

          

  $results = $uwrapper -> bbquery( "SELECT COUNT(pid) FROM " . $uwrapper -> bbescape( $preferences[ 'website_uwrapper_prefix' ] ) . "posts" );

    list($total_posts) = $database -> dbrow( $results );         

  

  $results = $uwrapper -> bbquery( "SELECT name FROM " . $uwrapper -> bbescape( $preferences[ 'website_uwrapper_prefix' ] ) . "members WHERE mgroup = '3' ORDER BY joined DESC LIMIT 1" );

        list($new_member) = $database -> dbrow( $results );          

  

  $ipb_stats .= "<li>Members: <b>".$total_users."</b></li>";

    $ipb_stats .= "<li>Posts on Forum: <b>".$total_posts."</b></li>";   

  $ipb_stats .= "<li>Welcome: <b>".htmlspecialchars($new_member)."</b></li>";

   $ipb_stats .= "<li><a href=\"" . $preferences[ 'website_uwrapper_forumpath' ] . "\">Enter the Forums</a></li>";   



    $uwrapper -> bbclose();

        $system -> datastoreput( "ipb_stats", $ipb_stats );        

}

   

echo $ipb_stats;

?>
1 Re: After IPB3 Upgrade Site Doesn't Work
avatar
Editor
0
From: -
The problem is your custom "Community Zone" block. The used SQL queries are for IPB2.

I can adapt the queries if you post the block here.

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.