Prime Trash Bin

[Solidjeuh]

• Adres van je forum: http://www.zeverhoekske.be
  Event. modificaties op je forum: http://www.phpbbhacks.com/download/8515
  phpBB versie: 3.0.7-PL1
  
  
  Wat is het probleem?

Hoe kan ik onderstaand script toevoegen? is dat via mijn SQL?
Kan me iemand uitleggen hoe en wat ik juist moet doen daarmee..
ben een beginneling, moet nog veel leren... lol

SQL

Code: Selecteer alles

INSERT INTO phpbb_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('f_delete_forever', 0, 1, 0);

Code: Selecteer alles

INSERT INTO phpbb_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('f_undelete', 0, 1, 0);

Code: Selecteer alles

INSERT INTO phpbb_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('m_delete_forever', 1, 1, 0);

Code: Selecteer alles

INSERT INTO phpbb_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('m_undelete', 1, 1, 0);

Code: Selecteer alles

ALTER TABLE phpbb_topics ADD ( topic_deleted_from mediumint(8) UNSIGNED DEFAULT "0" NOT NULL, topic_deleted_user mediumint(8) UNSIGNED DEFAULT "0" NOT NULL, topic_deleted_time int(11) UNSIGNED DEFAULT "0" NOT NULL, topic_deleted_reason varchar(255) DEFAULT "" NOT NULL);

Code: Selecteer alles

ALTER TABLE phpbb_posts ADD ( post_deleted_from mediumint(8) UNSIGNED DEFAULT "0" NOT NULL, post_deleted_user mediumint(8) UNSIGNED DEFAULT "0" NOT NULL, post_deleted_time int(11) UNSIGNED DEFAULT "0" NOT NULL, post_deleted_reason varchar(255) DEFAULT "" NOT NULL);

[Jim]

Ja, je kan met het programma phpMyAdmin SQL queries uitvoeren op je database.
Voor informatie hierover, kijk in onze wiki!

http://wiki.phpbb.nl/Sql_query_uitvoeren

[Solidjeuh]

Brrrr heb al schrik dat ik iets ga verkeerd doen.. lool
ach ja, met backup komt het wel goed hoop ik..
zullen eens proberen si

[Solidjeuh]

Code: Selecteer alles

SQL query:

ALTER TABLE phpbb_posts ADD (
post_deleted_from mediumint( 8 ) UNSIGNED DEFAULT "0" NOT NULL ,
post_deleted_user mediumint( 8 ) UNSIGNED DEFAULT "0" NOT NULL ,
post_deleted_time int( 11 ) UNSIGNED DEFAULT "0" NOT NULL ,
post_deleted_reason varchar( 255 ) DEFAULT "" NOT NULL
)

MySQL said: Documentation
#1060 - Duplicate column name 'post_deleted_time' 

een error? ik heb nogtands gwn gekopieerd en geplakt hoe het in de mod staat...

Deze:

Code: Selecteer alles

ALTER TABLE phpbb_topics ADD ( topic_deleted_from mediumint(8) UNSIGNED DEFAULT "0" NOT NULL, topic_deleted_user mediumint(8) UNSIGNED DEFAULT "0" NOT NULL, topic_deleted_time int(11) UNSIGNED DEFAULT "0" NOT NULL, topic_deleted_reason varchar(255) DEFAULT "" NOT NULL);

En deze:

Code: Selecteer alles

ALTER TABLE phpbb_posts ADD ( post_deleted_from mediumint(8) UNSIGNED DEFAULT "0" NOT NULL, post_deleted_user mediumint(8) UNSIGNED DEFAULT "0" NOT NULL, post_deleted_time int(11) UNSIGNED DEFAULT "0" NOT NULL, post_deleted_reason varchar(255) DEFAULT "" NOT NULL);

[Kevin]

Als dit telkens de error is dan wil dat meer zeggen dan dat de tabel die je wil toevoegen al bestaat in je database.

Code: Selecteer alles

MySQL said: Documentation
#1060 - Duplicate column name 'post_deleted_time'