global announcement mod sql??

[danielc2384]

Ok. Today was the first time I installed a mod and so far no errors.

I installed the global announcement mod and I think it installed correctly because if I go to the Admin CP is shows up fine.

The proplem is the SQL part. In the install.txt file it says:

#
#-----[ SQL ]------------------------------------------------
#
INSERT INTO phpbb_config (config_name, config_value) VALUES ('global_title', 'Global Announcement');
INSERT INTO phpbb_config (config_name, config_value) VALUES('global_announcement', 'Any important information relating to this site will be posted

here!');
INSERT INTO phpbb_config (config_name, config_value) VALUES('global_enable', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES('marquee_disable', '0');




I'm not to sure what to do there. Do I execute that SQL statement? If so how would I do that?

Thanks

[Raimon]

Easymod install automatic the sql update if you give easymod the command to.
But to answer your question you must put the codes into your phpmyadmin under the tab sql and hit the go button after that, you might like to read the article ; Knowledge Base - How to Install MODs

[danielc2384]

Thanks for the info. I just managed to find the phpMyAdmin lol

Im getting this error when I process the SQL code.

[Raimon]

Probably the prefix is different, check your forum database, on the example its a empty database , you will find a table called something_phpbb the something is the prefix, so the sql query would be ;
Example;

Code: Select all

INSERT INTO something_config (config_name, config_value) VALUES ('global_title', 'Global Announcement'); 

[Lumpy Burgertushie]

it looks like there is no underbar after the prefix.

so, instead of phpbb_config,

it would be;
phpbbconfig

try that and see what happens

robert

[danielc2384]

Awesome Stuff!

Thanks heaps for the help. It's now working

[Maxberillious]

i have just read this post and i have ried the same but mine does not fix when i update mine says...

[darcie]

Maxberillious, Nuke forums are not the same as phpBB2. EasyMOD or other phpBB2 MODs are not meant for Nuke.

[Maxberillious]

yes i know that, all im saying is i get this error msg as when i try to save config on admin on forums it says that this is missing!!!

[darcie]

I'm not quite sure how you expect it to work when the two are not compatible. EasyMOD is only for phpBB 2.0.x, as downloaded from phpbb.com. How about trying to add MODs written for nuke forums instead?