New to the community? Start here

Bugs or is it :)

Hello Guys

Please have a look at the err below

I need to fix it but i need to know what i need to fix Is it a bot that is out of control ?

[03-Nov-2011 21:45:30] WordPress database error  for query

CREATE TABLE wp_users (

ID bigint(20) unsigned NOT NULL auto_increment,

user_login varchar(60) NOT NULL default '',

user_pass varchar(64) NOT NULL default '',

user_nicename varchar(50) NOT NULL default '',

user_email varchar(100) NOT NULL default '',

user_url varchar(100) NOT NULL default '',

user_registered datetime NOT NULL default '0000-00-00 00:00:00',

user_activation_key varchar(60) NOT NULL default '',

user_status int(11) NOT NULL default '0',

display_name varchar(250) NOT NULL default '',

PRIMARY KEY  (ID),

KEY user_login_key (user_login),

KEY user_nicename (user_nicename)

) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci made by wpmu_activate_signup, wpmu_create_blog, install_blog, make_db_current_silent, dbDelta, m_wpdb->query

Fri, 4 Nov 2011 9:33:18
  • Mark de Scande
    • Syntax Hero

    @Phil

    Is that just in your MySQL log? No it is the log when i ftp in to the box Ie /home/blogline/public_html error_log

    You do already have a wp_users table presumably? Yes it is in the blogline_global DB

    So i was thinking if it was not in one of the other 16 DB

    @Phil Thank you for always helping

  • Mark de Scande
    • Syntax Hero

    @masonjames there is about 30 plugs on the site here is a list of all of them

    * FEED MONSTER 6.0 by portaljumper.com

    Network Deactivate | Edit

    Feed-monster purposely does not overwrite older versions so you can easily roll back.DEACTIVATE OLDER VERSIONS FIRST THEN ACTIVATE THIS VERSION. IF EVERYTHING IS TO YOUR LIKING SIMPLY DELETE THE OLDER VERSION. turns any selected affiliate datafeed from networks like shareasale, commission junction, linkshare, tradetracker, webgains, clickbank, daisycon, m4n and many more in to full wordpress posts complete with SEO categories, post content and tags. Choose from over 65.000.000 products in thousands of automated datafeeds. Simply select your preferred feeds and start earning a steady income. PREMIUM mode for power-earnings includes more features, enhanced Search engine optimization and complete white label operations Go premium now !.

    Version 6.0 | By pete scheepens | Visit plugin site

    Select Admin Ads

    Admin Ads

    Network Deactivate | Edit

    Display ads in admin dashboard

    Version 1.0.9 | By S H Mohanjith (Incsub), Andrew Billits (Incsub) | Visit plugin site

    Select Ad Sharing

    Ad Sharing

    Network Activate | Edit

    Simply split advertising revenues with your users with this easy to use plugin. You can use adsense, context ads or any combination of advertising you like. Time to reap (and share) blogging rewards!

    Version 1.2 | By Andrew Billits, Ulrich Sossou (Incsub) | Visit plugin site

    Select Affiliate

    Affiliate

    Network Deactivate | Edit

    This plugin adds a simple affiliate system to your site.

    Version 2.4.2 | By Barry | Visit plugin site

    Select Akismet

    Akismet

    Network Deactivate | Edit

    Used by millions, Akismet is quite possibly the best way in the world to protect your blog from comment and trackback spam. It keeps your site protected from spam even while you sleep. To get started: 1) Click the “Activate” link to the left of this description, 2) Sign up for an Akismet API key, and 3) Go to your Akismet configuration page, and save your API key.

    Version 2.5.3 | By Automattic | Visit plugin site

    Select AutoBlog

    AutoBlog

    Network Activate | Edit | Delete

    An automatic blog feed reading plugin.

    Version 3.6.1 | By Barry Getty (Incsub) | Visit plugin site

    Select Cache Images

    Cache Images

    Network Activate | Edit

    Goes through your posts and gives you the option to cache all hotlinked images from a domain locally in your upload folder

    Version 3.1 | By Matt Mullenweg | Visit plugin site

    Select Floating Social

    Floating Social

    Network Activate | Edit | Delete

    Make sharing easy – add a floating social media box that scrolls with your content.

    Version 1.3.4 | By raggedrobins (Incsub), Ve Bailovity (Incsub) | Visit plugin site

    Select Google Analytics

    Google Analytics

    Network Deactivate | Edit

    It’s great to offer your users Google Analytics, but it’s even better to be able to offer it to individual bloggers AND at the same time capture sitewide stats for yourself!

    Version 1.2.1 | By Ivan Shaovchev, Andrey Shipilov (Incsub) | Visit plugin site

    Select Login Image

    Login Image

    Network Deactivate | Edit

    Allows you to change the login image

    Version 1.0.9.1 | By Andrew Billits, Ulrich Sossou (Incsub) | Visit plugin site

    Select Logout Redirect

    Logout Redirect

    Network Deactivate | Edit

    Redirects users to specified url after logging out – say goodbye to users logging out… and seeing the logout screen :slight_smile:

    Version 1.0.3 | By Andrew Billits, Ulrich Sossou | Visit plugin site

    Select MarketPress

    MarketPress

    Network Activate | Edit

    The complete WordPress ecommerce plugin – works perfectly with BuddyPress and Multisite too to create a social marketplace, where you can take a percentage! Activate the plugin, adjust your settings then add some products to your store.

    Version 2.3.2 | By Aaron Edwards (Incsub) | Visit plugin site

    Select Popover plugin

    Popover plugin

    Network Deactivate | Edit

    This plugin adds a customisable popover to a site. The content, size, position can be changed and rules determining if the popover should show or not.

    Version 3.0.1 | By Barry (Incsub) | Visit plugin site

    Select Pro Sites (Formerly Supporter)

    Pro Sites (Formerly Supporter)

    Network Deactivate | Edit

    The ultimate multisite site upgrade plugin, turn regular sites into multiple pro site subscription levels selling access to storage space, premium themes, premium plugins and much more!

    Version 3.0.3 | By Aaron Edwards (Incsub) | Visit plugin site

    Select Random Theme on Signup

    Random Theme on Signup

    Network Deactivate | Edit

    Activates a random theme for new blog signups

    Version 1.0.1 | By Aaron Edwards (Incsub) | Visit plugin site

    Select Simple Sitemaps For Multisite

    Simple Sitemaps For Multisite

    Network Deactivate | Edit

    The ultimate search engine plugin – Simply have sitemaps created, submitted and updated for every blog on your site

    Version 1.0.4 | By Viper007Bond (Incsub) | Visit plugin site

    Select Subscribe by Email

    Subscribe by Email

    Network Deactivate | Edit

    This plugin allows you and your users to offer subscriptions to email notification of new posts

    Version 1.1.0 | By S H Mohanjith (Incsub) | Visit plugin site

    Select Test Head Footer

    Test Head Footer

    Network Activate | Edit

    Tests for the existence and functionality of wp_head and wp_footer in the active theme

    Version 1.0 | By Matt Martz | Visit plugin site

    Select WordPress Importer

    WordPress Importer

    Network Deactivate | Edit

    Import posts, pages, comments, custom fields, categories, tags and more from a WordPress export file.

    Version 0.5 | By wordpressdotorg | Visit plugin site

    Select WordPress MU Sitewide Tags Pages

    WordPress MU Sitewide Tags Pages

    Network Deactivate | Edit

    Creates a blog where all the most recent posts on a WordPress network may be found.

    Version 0.4.1.1 | By Donncha O Caoimh | Visit plugin site

    Select WP-Cron Control

    WP-Cron Control

    Network Deactivate | Edit

    get control over wp-cron execution.

    Version 0.4 | By Thorsten Ott, Automattic | Visit plugin site

    Select WPMS Global Content

    WPMS Global Content

    Network Deactivate | Edit

    WPMS Global Content allow wordpress multisite network admin to set common header and footer content.

    Version 1.1 | By Neerav Dobaria | Visit plugin site

    Select WPMU DEV Update Notifications

    WPMU DEV Update Notifications

    Network Deactivate | Edit

    Notifies the Admin or Super Admin of available updates for WPMU DEV plugins and themes, new releases, and special member only offers. Allows auto-upgrades of supported themes/plugins. Required to be installed to use WPMU DEV products.

    Version 2.1.3 | By Aaron Edwards (Incsub) | Visit plugin site

    Select WP Smush.it

    WP Smush.it

    Network Activate | Edit

    Reduce image file sizes and improve performance using the Smush.it API within WordPress.

    Version 1.4.3 | By Dialect | Visit plugin site

    db.php

    Multi-DB

    Custom database class.

    Allows you to scale your standard Multisite install to allow for millions of blogs and segment your database across multiple physical servers.

    Version 3.1 | By Andrew Billits, S H Mohanjith (Incsub), Barry (Incsub) | Visit plugin site

    sunrise.php

    Executed before Multisite is loaded.

    Multi-Domains for Multisite

    Easily allow users to create new sites (blogs) at multiple different domains – using one install of WordPress Multisite you can support blogs at name.domain1.com, name.domain2.com etc.

    Version 1.1.5 | By Ulrich SOSSOU (Incsub) | Visit plugin site

    VHOST and directory enabled Domain Mapping plugin

    A domain mapping plugin that can handle sub-directory installs and global logins

    Version 3.0.5 | By Barry Getty (Incsub) | Visit plugin site

  • Mark de Scande
    • Syntax Hero

    @Phil

    When are the errors appearing – with every request or only after certain actions?

    I wish i can tell you but i have no idea it looks to me that it is some type of spam bot that is trying to make a blog

    Sorry i can give you more info and yes i know the err log is not much to go on

  • Mark de Scande
    • Syntax Hero

    I am posting this here if any body has the same bug please let me know

    [03-Nov-2011 19:22:09] PHP Warning:  mysql_get_server_info() expects parameter 1 to be resource, boolean given in /home/blogline/public_html/wp-content/db.php on line 699
    
[03-Nov-2011 19:22:25] PHP Warning:  mysql_get_server_info() expects parameter 1 to be resource, boolean given in /home/blogline/public_html/wp-content/db.php on line 699
    
[03-Nov-2011 19:22:55] PHP Warning:  mysql_get_server_info() expects parameter 1 to be resource, boolean given in /home/blogline/public_html/wp-content/db.php on line 699
    
[03-Nov-2011 19:22:56] PHP Warning:  mysql_get_server_info() expects parameter 1 to be resource, boolean given in /home/blogline/public_html/wp-content/db.php on line 699
    
[03-Nov-2011 19:23:41] PHP Warning:  mysql_get_server_info() expects parameter 1 to be resource, boolean given in /home/blogline/public_html/wp-content/db.php on line 699
    
[04-Nov-2011 00:00:48] WordPress database error  for query SELECT option_value FROM wp_5818_options WHERE option_name = 'affiliate_activated_addons' LIMIT 1 made by require, require_once, require_once, include_once, affiliate->__construct, load_affiliate_addons, get_option, m_wpdb->query
    
[04-Nov-2011 23:58:34] WordPress database error  for query SELECT * FROM wp_blogs WHERE domain = 'businessansweringservice.bloglines.co.za' made by require, require_once, require_once, require, get_blog_details, m_wpdb->query
    
[08-Nov-2011 06:11:11] PHP Warning:  mysql_get_server_info() expects parameter 1 to be resource, boolean given in /home/blogline/public_html/wp-content/db.php on line 699

  • Mark de Scande
    • Syntax Hero

    @Phill

    I have fix all of the errs on the site well it looks like it i did some hard MySQL hacks :slight_smile:

    BlogLines.co.za runs of 16DB

    So yes i know it is the wrong way of doing thing but it worked

    I used PHP My Admin and yes i did this 16 times Click the SQL past and click go i did this to all the DB and my err log was clean of the err below

    CREATE TABLE wp_users (
    
ID bigint(20) unsigned NOT NULL auto_increment,
    
user_login varchar(60) NOT NULL default '',
    
user_pass varchar(64) NOT NULL default '',
    
user_nicename varchar(50) NOT NULL default '',
    
user_email varchar(100) NOT NULL default '',
    
user_url varchar(100) NOT NULL default '',
    
user_registered datetime NOT NULL default '0000-00-00 00:00:00',
    
user_activation_key varchar(60) NOT NULL default '',
    
user_status int(11) NOT NULL default '0',
    
display_name varchar(250) NOT NULL default '',
    
PRIMARY KEY  (ID),
    
KEY user_login_key (user_login),
    
KEY user_nicename (user_nicename)
    
)

    I then did the same for some of the other tables that was missing.

    My log is now clean yes i know it was not the best way of doing it but it seems to have worked .

    Again thank you for all the help