user_profil_gästebuch 0.0.5

[marcus6977]

Kann einen SQL Befehl nicht ausführen (ALTER TABLE `phpBB_profile_guestbook` CHANGE `message` `message` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;) da zeigt er mir immer das an #1146 - Table 'usr_web404_2.phpBB_profile_guestbook' doesn't exist

Code:Select All

CREATE TABLE `phpbb_profile_guestbook` (
`gb_id` int(10) NOT NULL auto_increment,
`user_id` int(10) NOT NULL default '0',
`poster_id` int(10) NOT NULL default '0',
`gb_time` int(10) NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`message` text NOT NULL,
`bbcode_uid` varchar(8) collate utf8_bin NOT NULL,
`bbcode_bitfield` varchar(5) collate utf8_bin NOT NULL,
`user_guestbook_limit` VARCHAR(255) NULL,
`user_guest_name` varchar(64) NOT NULL default '',
PRIMARY KEY (`gb_id`));

Code:Select All

ALTER TABLE `phpBB_profile_guestbook` CHANGE `message` `message` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

Code:Select All

ALTER TABLE `phpbb_users` ADD `user_guestbook_active` TINYINT( 1 ) DEFAULT '1' NOT NULL;

Code:Select All

ALTER TABLE `phpbb_users` ADD `user_guestbook_delete` TINYINT( 1 ) DEFAULT '1' NOT NULL;

Code:Select All

ALTER TABLE `phpbb_users` ADD `user_guestbook_send` TINYINT( 1 ) DEFAULT '1' NOT NULL;

Code:Select All

ALTER TABLE `phpbb_users` ADD `user_guestbook_limit` INT(11) DEFAULT '10' NOT NULL;

Code:Select All

ALTER TABLE `phpbb_users` ADD `user_guestbook_allow_pm` TINYINT( 1 ) DEFAULT '1' NOT NULL;

[Shugo]

Hi,
Du musst die Präfix anpassen
Siehe dazu auch hier --> http://www.phpbb.de/community/viewtopic ... h#p1079830