Error 404 when creating project
-
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
-
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?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).Just moved my working setup from a shared hosting account to my VPS — now experiencing the same error. Up-to-date WP, BP, PHP, GTM.
The URL it forwards to is http:// As I've been having some file-permissions issues since moving to the VPS -- I'm curious if the plugin is supposed to write the data to SQL or otherwise?" class="bbcode_url">.com/groups/[GROUP]/gtm/projects/view/0?action=created , and displays the same error Andre describes.
As I’ve been having some file-permissions issues since moving to the VPS — I’m curious if the plugin is supposed to write the data to SQL or otherwise?@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).@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 …@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_termsNetwork-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 EditionMain 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.
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.1I 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’);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.
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.What do you see on lines 89 and 120 of the file bp-gtm.php?
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)
Topic is closed as outdated.
If you find any new bugs – create a new topic please.
You must be logged in to reply to this topic.