#313 new
hunt529

wp_wpo_campaign TABLE does not get installed correctly?

Reported by hunt529 | April 27th, 2010 @ 11:57 AM

I can see where the problem lies -- but not how to fix it. For some reason the

wp_wpo_campaign Table is not getting created properly during the installation process. I can see the other tables there OK -- but not the wp_wpo_campaign table?

Of course the absence of this table just generates the following error.

http://members.takeclassaction.com/blog/

WordPress database error Table 'recall.wp_wpo_campaign' doesn't exist for query SELECT * FROM wp_wpo_campaign WHERE 1 = 1 AND active = 1 AND (frequency + UNIX_TIMESTAMP(lastactive)) < 1272378702 ORDER BY created_on DESC made by require, require_once, require_once, require_once, do_action, call_user_func_array, WPOMatic->init, WPOMatic->processAll, WPOMatic->getCampaigns
WordPress database error Table 'recall.wp_wpo_campaign' doesn't exist for query SELECT * FROM wp_wpo_campaign WHERE id = 6 made by require, require_once, include, the_permalink, apply_filters, call_user_func_array, WPOMatic->filterPermalink, WPOMatic->getCampaignById
WordPress database error Table 'recall.wp_wpo_campaign' doesn't exist for query SELECT * FROM wp_wpo_campaign WHERE id = 3 made by require, require_once, include, the_permalink, apply_filters, call_user_func_array, WPOMatic->filterPermalink, WPOMatic->getCampaignById
WordPress database error Table 'recall.wp_wpo_campaign' doesn't exist for query SELECT * FROM wp_wpo_campaign WHERE id = 6 made by require, require_once, include, the_permalink, apply_filters, call_user_func_array, WPOMatic->filterPermalink, WPOMatic->getCampaignById
WordPress database error Table 'recall.wp_wpo_campaign' doesn't exist for query SELECT * FROM wp_wpo_campaign WHERE id = 5 made by require, require_once, include, the_permalink, apply_filters, call_user_func_array, WPOMatic->filterPermalink, WPOMatic->getCampaignById
WordPress database error Table 'recall.wp_wpo_campaign' doesn't exist for query SELECT * FROM wp_wpo_campaign WHERE id = 6 made by require, require_once, include, the_permalink, apply_filters, call_user_func_array, WPOMatic->filterPermalink, WPOMatic->getCampaignById
WordPress database error Table 'recall.wp_wpo_campaign' doesn't exist for query SELECT * FROM wp_wpo_campaign WHERE id = 4 made by require, require_once, include, the_permalink, apply_filters, call_user_func_array, WPOMatic->filterPermalink, WPOMatic->getCampaignById
WordPress database error Table 'recall.wp_wpo_campaign' doesn't exist for query SELECT * FROM wp_wpo_campaign WHERE id = 4 made by require, require_once, include, the_permalink, apply_filters, call_user_func_array, WPOMatic->filterPermalink, WPOMatic->getCampaignById
WordPress database error Table 'recall.wp_wpo_campaign' doesn't exist for query SELECT * FROM wp_wpo_campaign WHERE id = 4 made by require, require_once, include, the_permalink, apply_filters, call_user_func_array, WPOMatic->filterPermalink, WPOMatic->getCampaignById
WordPress database error Table 'recall.wp_wpo_campaign' doesn't exist for query SELECT * FROM wp_wpo_campaign WHERE id = 4 made by require, require_once, include, the_permalink, apply_filters, call_user_func_array, WPOMatic->filterPermalink, WPOMatic->getCampaignById
WordPress database error Table 'recall.wp_wpo_campaign' doesn't exist for query SELECT * FROM wp_wpo_campaign WHERE id = 4 made by require, require_once, include, the_permalink, apply_filters, call_user_func_array, WPOMatic->filterPermalink, WPOMatic->getCampaignById

Any possibility you can send me a create new table command? for the wp_wpo_campaign table?

Comments and changes to this ticket

  • hunt529

    hunt529 April 27th, 2010 @ 12:00 PM

    I forgot to mention

    I am installing Wp-O-Matic version 1.0RC4-6 on Wordpress version 2.9.2

    Thanks.

  • hunt529

    hunt529 April 28th, 2010 @ 11:37 AM

    Alright I had successfully installed the same versions on another machine so what I did was to create a structure only SQL dump from the good install of the WP-O-Matic tables.

    I installed the tables into my target DB and that worked fine.

    The plot thickens....

    So then the majority of the functionality APPEARS to work. But I still have a DB problem.

    When I try to add a campaign I get the following error...

    WordPress database error Incorrect datetime value: '0' for column 'lastactive' at row 1 for query INSERT INTO wp_wpo_campaign (lastactive, count) VALUES ('0','0') made by require_once, do_action, call_user_func_array, WPOMatic->admin, WPOMatic->adminAdd, WPOMatic->adminProcessAdd
    WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 for query DELETE FROM wp_wpo_campaign_word WHERE campaign_id = made by require_once, do_action, call_user_func_array, WPOMatic->admin, WPOMatic->adminAdd, WPOMatic->adminProcessAdd, WPOMatic->adminProcessEdit
    WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 for query DELETE FROM wp_wpo_campaign_category WHERE campaign_id = made by require_once, do_action, call_user_func_array, WPOMatic->admin, WPOMatic->adminAdd, WPOMatic->adminProcessAdd, WPOMatic->adminProcessEdit
    WordPress database error Incorrect integer value: '' for column 'campaign_id' at row 1 for query INSERT INTO wp_wpo_campaign_category (category_id, campaign_id) VALUES ('1','') made by require_once, do_action, call_user_func_array, WPOMatic->admin, WPOMatic->adminAdd, WPOMatic->adminProcessAdd, WPOMatic->adminProcessEdit
    WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND url = 'http://rss.cnn.com/rss/cnn_topstories.rss'' at line 1 for query SELECT id FROM wp_wpo_campaign_feed WHERE campaign_id = AND url = 'http://rss.cnn.com/rss/cnn_topstories.rss' made by require_once, do_action, call_user_func_array, WPOMatic->admin, WPOMatic->adminAdd, WPOMatic->adminProcessAdd, WPOMatic->adminProcessEdit, WPOMatic->addCampaignFeed
    WordPress database error Incorrect integer value: '' for column 'campaign_id' at row 1 for query INSERT INTO wp_wpo_campaign_feed (url, title, description, logo, campaign_id) VALUES ('http://rss.cnn.com/rss/cnn_topstories.rss','CNN.com','CNN.com delivers up-to-the-minute news and information on the latest top stories, weather, entertainment, politics and more.','http://i2.cdn.turner.com/cnn/.element/img/1.0/logo/cnn.logo.rss.gif...) made by require_once, do_action, call_user_func_array, WPOMatic->admin, WPOMatic->adminAdd, WPOMatic->adminProcessAdd, WPOMatic->adminProcessEdit, WPOMatic->addCampaignFeed

    So now I am thinking my version of MySQL might be too new?

    THe version of MySQL is: 5.1.37-community MySQL Community Server+

  • EllieHarris

    EllieHarris December 8th, 2020 @ 11:53 AM

    Multiplayer team games are very good and interesting to play because these assignment help online games increase the level of interest. When you get a chance to play a game with your class-fellows and friends then it increases your interest level.

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป

WP-o-Matic project.

People watching this ticket

Tags

Pages