Err Log

Hey guys i see a log of these in my err logs

[25-Oct-2011 21:02:41] WordPress database error for query SELECT COUNT(*) FROM wp_supporter_ads WHERE blog_ID = '673' AND expire > '1319576561' made by require, require_once, include, the_content, apply_filters, call_user_func_array, ProSites_Module_Ads->advertising_output, ProSites_Module_Ads->show_ads, ProSites_Module_Ads->check, m_wpdb->query

Do i need to add a DB table or what should i do there is about 8000 errs like this The trunk is avalibile if you need to log in and have a look

Thank you Kindly
Mark

  • Mark de Scande
    • Syntax Hero

    @Phil running Multi DB what lines should i add in the db-config.php

    add_global_table('blogline_global');
    add_global_table('ust');
    add_global_table('affiliatedata');
    add_global_table('affiliatereferrers');
    add_global_table('am_actions');
    add_global_table('am_queue');
    add_global_table('am_schedule');
    add_global_table('autoblog');
    
    add_global_table('bp_activity');
    add_global_table('bp_activity_meta');
    add_global_table('bp_friends');
    add_global_table('bp_groups');
    add_global_table('bp_groups_groupmeta');
    add_global_table('bp_groups_members');
    add_global_table('bp_messages_messages');
    add_global_table('bp_messages_notices');
    
    add_global_table('bp_messages_recipients');
    add_global_table('bp_notifications');
    add_global_table('bp_user_blogs');
    add_global_table('bp_user_blogs_blogmeta');
    add_global_table('bp_xprofile_data');
    add_global_table('bp_xprofile_fields');
    add_global_table('bp_xprofile_groups');
    
    add_global_table('domain_mapping');
  • Mark de Scande
    • Syntax Hero

    @Phil i was just looking at ads.php and i do see this in there but if i go to PHP MyAdmin supporter_ads

    Now how can i add this to PHP MyAdmin in an easy and fast way

    function install() {
    		global $wpdb, $psts;
    
    		$table1 = "CREATE TABLE <code>{$wpdb->base_prefix}supporter_ads</code> (
    		  <code>supporter_ads_ID</code> bigint(20) unsigned NOT NULL auto_increment,
    		  <code>supporter_blog_ID</code> bigint(20) NOT NULL default '0',
    		  <code>blog_ID</code> bigint(20) NOT NULL default '0',
    		  <code>expire</code> bigint(20) NOT NULL default '0',
    		  PRIMARY KEY  (<code>supporter_ads_ID</code>)
    		);";
  • Philip John
    • DEV MAN’s Apprentice

    Ah okay, that's good then.

    I'm going to defer to Aaron and Barry on this one. It looks to me as though the Ads module hasn't created the database properly.

    This may be a Multi-DB issue but as I'm not sure and can't test right now I'll ask them to provide their thoughts.

    Phil

  • Mark de Scande
    • Syntax Hero

    @wp_supporter_ads I have done this old school :slight_smile:

    Yes i dont know what i am doing but i try :slight_smile: I have a test setup on BlogLines.co.za/test with no multi db on it so i logged in to PHP MyAdmin and i went to the WRDP_2 the DB of the test site and i click on the wp_supporter_ads table and i click export it cave me a file called wp_supporter_ads.sql i then went back to bloglines_global and i click the import tab and added the file wp_supporter_ads.sql and now the table is there :slight_smile: I will clean up err logs and update shortly As always my server is open box to you guys to test and get the rest of the community happy with all this here at WPMU Def LOVE YOU GUYS

    -- phpMyAdmin SQL Dump
    -- version 3.4.5
    -- http://www.phpmyadmin.net
    --
    -- Host: localhost
    -- Generation Time: Oct 26, 2011 at 02:19 PM
    -- Server version: 5.1.56
    -- PHP Version: 5.2.9
    
    SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
    SET time_zone = "+00:00";
    
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;
    
    --
    -- Database: <code>blogline_wrdp2</code>
    --
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table <code>wp_supporter_ads</code>
    --
    
    CREATE TABLE IF NOT EXISTS <code>wp_supporter_ads</code> (
      <code>supporter_ads_ID</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      <code>supporter_blog_ID</code> bigint(20) NOT NULL DEFAULT '0',
      <code>blog_ID</code> bigint(20) NOT NULL DEFAULT '0',
      <code>expire</code> bigint(20) NOT NULL DEFAULT '0',
      PRIMARY KEY (<code>supporter_ads_ID</code>)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
    
    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  • Mark de Scande
    • Syntax Hero

    @Phill @Aaron @Barry It now has been about 40 minutes and i dont see any thing in the err logs.

    I also don't see any data in the table wp_supporter_ads is there supposed to be any thing in there or will the table only fill up at a later stage.

    Please don't jump up and down for me posting so much i just like to keep you guys informed to what happening on the BlogLines.co.za as this is a production server :slight_smile:

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.