The Confirmation Topic works in a Plus 1.52 ?

[oxpus]

The ALTER TABLE is correct, but not the DELETE.
Use them like this one:

Code: Alles auswählen

DELETE FROM phpbb_config THERE config_name = 'no_confirm_view';

[mariokaz]

Thank you my friend!!

So this one will be the complete correct SQL uninstall instruction, right ?

Code: Alles auswählen

DROP TABLE phpbb_forum_confirmation; 
ALTER TABLE phpbb_forums DROP COLUMNS forum_confirm TINYINT(1) DEFAULT '0' NOT NULL AFTER forum_topics; 
ALTER TABLE phpbb_topics DROP COLUMNS topic_confirm TINYINT(1) DEFAULT '0' NOT NULL; 
DELETE FROM phpbb_config THERE config_name = 'no_confirm_view';

I hope now yes!!

[oxpus]

Yes, that's all.

[mariokaz]

My friend I get this error after that.

[oxpus]

Learning SQL...
Dropping something must always be done without any definitions:

Code: Alles auswählen

DROP TABLE phpbb_forum_confirmation;
ALTER TABLE phpbb_forums DROP COLUMNS forum_confirm;
ALTER TABLE phpbb_topics DROP COLUMNS topic_confirm;
DELETE FROM phpbb_config THERE config_name = 'no_confirm_view';

[mariokaz]

Ok ok, thank you.

I solved one problem that I have right now, because I see that is DROP COLUMN not DROP COLUMNS jejeje in this lines:

Code: Alles auswählen

ALTER TABLE phpbb_forums DROP COLUMN forum_confirm;
ALTER TABLE phpbb_topics DROP COLUMN topic_confirm;

But I am still having one more error. ¦4

--------------------------------

My friend I installe this great Mod yours in my forum and it is working like a charm, really thank you very much very nice mod.


Only tell me my friend how can I fix the SQL error that I had???, please help me.

Cheers.

[oxpus]

Conditions in SQl statements begins with the keyword "where" not with "there"

[mariokaz]

I only copied and pasted the SQL instruction that you put me in your last post. ¦4

So this one is the correct ?

Code: Alles auswählen

DELETE FROM phpbb_config WHERE config_name = 'no_confirm_view';

[oxpus]

Yes "my friend"!

ANd instead asking point for point, buy a book and learn SQL

[mariokaz]

Thank you my "dear friend" now yes I can fix that error jejeje