Skip to:
Content
Pages
Categories
Search
Top
Bottom

Error 404 when creating project

  • Avatar of AndreMartin
    AndreMartin
    Participant

    @andremartin

    Creating a new (first) project, I get this message when submitting the form:

    (red box)
    “There was an error creating new project, please try again.”

    (place of project list)
    “Error – 404
    There is no project in the database with such ID. Please go to the main projects list.”

    – Other features like creating tags and categories work.
    – The error happens with any account (admin/non-admin).
    – Group is set to private.
    – WP 3.0.1 multi-site, BP 1.2.5.2 with default theme, GTM 0.9.6

Viewing 15 replies - 1 through 15 (of 15 total)
  • Avatar of Slava UA
    Slava UA
    Participant

    @slaffik

    Well, strange. On my imstall it can even create a blank project (with no data entered).
    Do you enter some special chars into project name field? Could you give me a screenshot of that form you are submitting?
    And what about tasks?

    Avatar of AndreMartin
    AndreMartin
    Participant

    @andremartin

    No special characters, just entered “Test Project” as name, “test” as description.
    Creating tasks requires project first so that doesn’t work.
    I noticed the “Who is responsible” field gave me just once out of 10 trials a list of suggested users after filling in some letters. Every other time I enter an existing (even group member) name and then click on any other field, the “loading” icon appears for a second and then nothing. So that seems not processing well either.
    Not sure if that’s related but I already have datepicker problems with Jet Events. (in case both use js or so).

    Avatar of Slava UA
    Slava UA
    Participant

    @slaffik

    @swanzai – Plugin writes its data directly into MySQL DB.
    @andremartin – Check please whether wp_bp_gtm_projects and wp_bp_gtm_tasks exist in your DB.
    @andremartin – Please give a list of your currently installed plugins (for me to check datepicker problem).

    Avatar of milordk
    milordk
    Participant

    @milordk

    @Andre Martin,
    The problem with the date still there? Display a list of used plugins:) Usually the problem arises from the plug-ins – whose authors inserted fragments JQuery as found on the internet …

    Avatar of AndreMartin
    AndreMartin
    Participant

    @andremartin

    @SlaFFik
    Both wp_bp_gtm_projects and wp_bp_gtm_tasks do *not* exist in the database, however the 4 below do exist:
    wp_bp_gtm_discuss, wp_bp_gtm_resps, wp_bp_gtm_taxon, wp_bp_gtm_terms

    Avatar of AndreMartin
    AndreMartin
    Participant

    @andremartin

    @SlaFFik , @milordk

    Network-activated plugins:


    Add Users Sidebar Widget
    Backend Login Logo
    Blogger Importer
    BP Blog Author Profile Link
    BP GTM System
    BuddyPress
    BuddyPress Follow
    BuddyPress Forums Extras – Add CSS classes for Posts/Topics per user level
    BuddyPress Forums Extras – Forums Index
    BuddyPress Forums Extras – RSS Feeds
    BuddyPress Group Forum Extras
    BuddyPress Group Tags
    Buddypress Humanity
    BuddyPress Like
    BuddyPress Moderation
    BuddyPress Profile Privacy
    BuddyPress ScholarPress Courseware
    CD BuddyPress Avatar Bubble
    Custom Meta
    DotClear Importer
    Edit Category Slug
    Erocks Dashboard Lockdown
    Exclude Pages from Navigation
    GreyMatter Importer
    Jet Event System for BuddyPress
    LiveJournal Importer
    Movable Type and TypePad Importer
    OPML Importer
    Posterous Importer
    Random Posts from Category
    RSS Importer
    SI CAPTCHA Anti-Spam
    Twitter Importer
    Use Google Libraries
    Widget Logic
    WordPress Hashcash
    WordPress Importer
    WPMS Mobile Edition

    Main site-activated:


    Add All Nav Links to BP Adminbar
    BuddyPress Mass Messaging
    Fast Secure Contact Form
    Featured blogs
    Flash Photo Gallery
    Flickr Photos
    Frontpage-Slideshow
    Gigya Socialize
    Jet Site Unit Could
    MapPress Easy Google Maps
    Peter’s Login Redirect
    Sociable
    Theme Browser
    Video Sidebar Widgets
    Widgets on Pages
    WordPress.com Stats
    WP Activate Users
    WP Hide Categories
    WP Snap Preview AnywhereTMPlugin
    WP-Mail-SMTP
    WPMU-Block-Spam-By-Math
    Yet Another Related Posts Plugin

    @slaffik How strange — I don’t seem to have any GTM tables in my DB.

    @andremartin Oof. A copy of your header source might be more efficient — just do a view-source and ctrl+f for ‘jquery’ — see if the framework is called more than once. Keep in mind jQuery authors like to name their individual plugins with ‘jquery’ in them — so you’re just looking for jquery.js or jquery.min.js is many cases.

    Avatar of AndreMartin
    AndreMartin
    Participant

    @andremartin

    I only get these “jquery” calls with a “.js” extension but overall I have 106 “jquery” references in the source code.

    http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js
    http://ajax.googleapis.com/ajax/libs/jqueryui/1.7.3/jquery-ui.min.js
    http://teachnblog.com/wp-content/plugins/frontpage-slideshow/js/jquery-ui-effects.js?ver=3.0.1

    I think it might be easier if you take a look at the original source code (http://teachnblog.com) instead of me posting a never-ending header here and render this thread unreadable. Note the site is a work in progress so excuse some ugly code – but I didn’t change anything related to queries other than switching to Google via the “Use Google Libraries” plugin.

    Re “plugin list”:
    it’s quite a long one, I know. We still work on the best setup but the selection so far makes for quite a nice site assuming things like datepicker work. There are some other plugins blog admins can activate manually but I didn’t list those as they are not activated on the main site which runs BP and shows the problems discussed here.

    I’m open for code adjustments or plugin disabling if there would be a confirmed conflict. If any plugin developer recognizes an issue here that seems to be only happening to our site, contact me for advanced debugging access.

    Alright, I was able to solve this by manually grabbing the wp_bp_gtm_* tables from my working BP install. I wouldn’t recommend messing with your DB if you don’t know exactly what you’re doing, but here’s what I imported:


    — Table structure for table `wp_bp_gtm_discuss`

    CREATE TABLE `wp_bp_gtm_discuss` (
    `id` bigint(20) NOT NULL auto_increment,
    `text` longtext NOT NULL,
    `author_id` bigint(20) NOT NULL,
    `task_id` bigint(20) NOT NULL default ‘0’,
    `project_id` bigint(20) NOT NULL default ‘0’,
    `group_id` bigint(20) NOT NULL default ‘0’,
    `date_created` datetime NOT NULL,
    PRIMARY KEY (`id`),
    KEY `author_id` (`author_id`),
    KEY `task_id` (`task_id`),
    KEY `project_id` (`project_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


    — Dumping data for table `wp_bp_gtm_discuss`




    — Table structure for table `wp_bp_gtm_projects`

    CREATE TABLE `wp_bp_gtm_projects` (
    `id` bigint(20) NOT NULL auto_increment,
    `name` varchar(200) NOT NULL,
    `desc` longtext NOT NULL,
    `status` varchar(10) NOT NULL default ‘public’,
    `group_id` bigint(20) default NULL,
    `creator_id` bigint(20) NOT NULL,
    `resp_id` varchar(500) NOT NULL,
    `date_created` datetime NOT NULL,
    `deadline` datetime NOT NULL,
    `done` tinyint(1) NOT NULL default ‘0’,
    `discuss_count` bigint(20) NOT NULL default ‘0’,
    PRIMARY KEY (`id`),
    KEY `creator_id` (`creator_id`),
    KEY `resp_id` (`resp_id`(333)),
    KEY `status` (`status`)
    ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;


    — Dumping data for table `wp_bp_gtm_projects`

    INSERT INTO `wp_bp_gtm_projects` VALUES (1, ‘FilamentFourDesign Website’, ‘

    of the web variety.

    n’, ‘hidden’, 35, 1, ‘admin’, ‘2010-10-04 11:46:41′, ‘2010-10-21 00:00:00′, 0, 0);




    — Table structure for table `wp_bp_gtm_resps`

    CREATE TABLE `wp_bp_gtm_resps` (
    `task_id` bigint(20) NOT NULL default ‘0’,
    `project_id` bigint(20) NOT NULL default ‘0’,
    `group_id` bigint(20) NOT NULL default ‘0’,
    `resp_id` bigint(20) NOT NULL,
    KEY `resp_id` (`resp_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;


    — Dumping data for table `wp_bp_gtm_resps`

    INSERT INTO `wp_bp_gtm_resps` VALUES (0, 1, 35, 1);
    INSERT INTO `wp_bp_gtm_resps` VALUES (1, 1, 35, 1);
    INSERT INTO `wp_bp_gtm_resps` VALUES (2, 1, 35, 1);
    INSERT INTO `wp_bp_gtm_resps` VALUES (3, 1, 35, 1);




    — Table structure for table `wp_bp_gtm_tasks`

    CREATE TABLE `wp_bp_gtm_tasks` (
    `id` bigint(20) NOT NULL auto_increment,
    `name` varchar(200) NOT NULL,
    `desc` longtext NOT NULL,
    `status` varchar(10) NOT NULL default ‘public’,
    `parent_id` bigint(20) NOT NULL default ‘0’,
    `creator_id` bigint(20) NOT NULL,
    `group_id` bigint(20) default NULL,
    `project_id` bigint(20) NOT NULL,
    `resp_id` varchar(500) NOT NULL,
    `date_created` datetime NOT NULL,
    `deadline` datetime NOT NULL,
    `done` tinyint(1) NOT NULL default ‘0’,
    `discuss_count` bigint(20) NOT NULL default ‘0’,
    PRIMARY KEY (`id`),
    KEY `parent_id` (`parent_id`),
    KEY `creator_id` (`creator_id`),
    KEY `resp_id` (`resp_id`(333)),
    KEY `status` (`status`)
    ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;


    — Dumping data for table `wp_bp_gtm_tasks`

    INSERT INTO `wp_bp_gtm_tasks` VALUES (1, ‘Make a logo’, ‘

    and make it good.

    n’, ”, 0, 1, 35, 1, ‘admin’, ‘2010-10-04 11:47:31′, ‘2010-10-18 00:00:00′, 0, 0);
    INSERT INTO `wp_bp_gtm_tasks` VALUES (2, ‘subtask 1′, ‘

    suuuub

    n’, ‘hidden’, 1, 1, 35, 1, ‘admin’, ‘2010-10-04 11:48:00′, ‘2010-10-16 00:00:00′, 0, 0);
    INSERT INTO `wp_bp_gtm_tasks` VALUES (3, ‘Another Sub Task’, ‘

    suub2

    n’, ‘hidden’, 1, 1, 35, 1, ‘admin’, ‘2010-10-04 11:50:40′, ‘2010-10-03 00:00:00′, 0, 0);




    — Table structure for table `wp_bp_gtm_taxon`

    CREATE TABLE `wp_bp_gtm_taxon` (
    `id` bigint(20) NOT NULL auto_increment,
    `task_id` bigint(20) NOT NULL default ‘0’,
    `project_id` bigint(20) default NULL,
    `group_id` bigint(20) default NULL,
    `term_id` bigint(20) NOT NULL,
    `taxon` varchar(20) NOT NULL,
    PRIMARY KEY (`id`),
    KEY `task_id` (`task_id`),
    KEY `project_id` (`project_id`)
    ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;


    — Dumping data for table `wp_bp_gtm_taxon`

    INSERT INTO `wp_bp_gtm_taxon` VALUES (1, 0, 1, 35, 2, ‘tag’);
    INSERT INTO `wp_bp_gtm_taxon` VALUES (2, 0, 1, 35, 3, ‘tag’);
    INSERT INTO `wp_bp_gtm_taxon` VALUES (3, 1, 1, 35, 1, ‘cat’);
    INSERT INTO `wp_bp_gtm_taxon` VALUES (4, 3, 1, 35, 2, ‘tag’);




    — Table structure for table `wp_bp_gtm_terms`

    CREATE TABLE `wp_bp_gtm_terms` (
    `id` bigint(20) NOT NULL auto_increment,
    `taxon` varchar(20) NOT NULL,
    `group_id` bigint(20) default NULL,
    `name` varchar(100) NOT NULL,
    PRIMARY KEY (`id`)
    ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;


    — Dumping data for table `wp_bp_gtm_terms`

    INSERT INTO `wp_bp_gtm_terms` VALUES (1, ‘cat’, 35, ‘Websites’);
    INSERT INTO `wp_bp_gtm_terms` VALUES (2, ‘tag’, 35, ‘web’);
    INSERT INTO `wp_bp_gtm_terms` VALUES (3, ‘tag’, 35, ‘graphics’);

    Avatar of Slava UA
    Slava UA
    Participant

    @slaffik

    You can also deactivate the plugin with deleting all the data (there is an option to choose on GTM System admin page). Then activate it again – and all tables will be created.

    Avatar of AndreMartin
    AndreMartin
    Participant

    @andremartin

    Both manual SQL and reactivating the plugin with deleting tables didn’t work for me.
    Is there any MySQL requirement? I just get errors with @swanzai export file.. the same also with the plugin’s original table creation script. This only applies to the “projects” and “tasks” table creation.

    Avatar of Slava UA
    Slava UA
    Participant

    @slaffik

    What do you see on lines 89 and 120 of the file bp-gtm.php?

    Avatar of AndreMartin
    AndreMartin
    Participant

    @andremartin

    Both lines 89 and 120 of file bp-gtm.php show the same:

    `’discuss_count’ bigint(20) NOT NULL DEFAULT ‘0’,`

    (where discuss_count uses backticks but I changed them to apostrophes in order to post correctly in this forum)

    Avatar of Slava UA
    Slava UA
    Participant

    @slaffik

    Topic is closed as outdated.
    If you find any new bugs – create a new topic please.

Viewing 15 replies - 1 through 15 (of 15 total)

You must be logged in to reply to this topic.