3 replies
Joined: 10/03/2008
Posts: 15
User offline. Last seen 34 weeks 5 days ago.

Another issue:

I tried to install adv Profile and everything was easy but:

When I try to auto create the uprofile node I get a bunch of errors

Quote:

# ser warning: Table 'dru_content_field_homepage' already exists query: CREATE TABLE dru_content_field_homepage ( vid int unsigned NOT NULL default '0', nid int unsigned NOT NULL default '0', PRIMARY KEY (vid) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in /var/www/htdocs/s13w44/html/includes/database.mysql.inc on line 172.
# user warning: Duplicate column name 'field_homepage_url' query: ALTER TABLE dru_content_field_homepage ADD COLUMN field_homepage_url varchar(255) NOT NULL default '' in /var/www/htdocs/s13w44/html/includes/database.mysql.inc on line 172.
# user warning: Duplicate column name 'field_homepage_title' query: ALTER TABLE dru_content_field_homepage ADD COLUMN field_homepage_title varchar(255) NOT NULL default '' in /var/www/htdocs/s13w44/html/includes/database.mysql.inc on line 172.
# user warning: Duplicate column name 'field_homepage_attributes' query: ALTER TABLE dru_content_field_homepage ADD COLUMN field_homepage_attributes mediumtext in /var/www/htdocs/s13w44/html/includes/database.mysql.inc on line 172.

I did some research and I found out that only the homepage field is created, besides the "contact" "links" "stats" and "about" fields in node_group.

The odd thing is: neither those four nor the homepage_field get a type_name so I think the node type uprofile is never created at all. While the four are simply blank the homepage_field is filled with create (in pointed brackets)

Did I have missed something? I saw there were some extra files but I had no idea what to do with them

Regards

Marc

0
Joined: 05/01/2008
Posts: 178
User offline. Last seen 4 hours 15 min ago.
Homepage

Looks like you already had a field named "homepage" and it's choking on it.

Michelle

Joined: 10/03/2008
Posts: 15
User offline. Last seen 34 weeks 5 days ago.
Ok, I've set up the test

Ok, I've set up the test site from scratch, installed panels 2, cck (dev versions) and advprofile. Now I've tried to generate the fields. Following error occured (among others)

Quote:
user warning: 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 ' ( vid int unsigned NOT NULL default query: CREATE TABLE dru_content_type_ ( vid int unsigned NOT NULL default '0', nid int unsigned NOT NULL default '0', PRIMARY KEY (vid) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in /var/www/htdocs/s13w44/html/includes/database.mysql.inc on line 172.

I looked into the database.mysql.inc but I can't find the statement. A colleague of mine suggested to skip the ' since they indicate a char while the statement demands an int. I would do that, but since I can't find it I'm a bit of lost. Even the google search for this error turned up empty.

EDIT: Every needed module is activated (including Content Copy).

Joined: 10/03/2008
Posts: 15
User offline. Last seen 34 weeks 5 days ago.
Is there a documentation

Is there a documentation what to do if I want (have to) create the content type manually?