Global Announcements

[ℓσяєиz]

teşekürler power oldu

[JayBachatero]

Missing language string from Modifications.english.php.

[richiehale]

how do I fix it ?

[Farmacija]

is this mod compatibile with smf 1.1.1?

[JayBachatero]

On what step did it fail?

[Farmacija]

when i try to install it from admin panel above message get appear... i tried several time and always i got the same error ...

[mysticalone]

I'm getting errors when adding new announcements, or enabling.
The tables exist and all, but I believe the problem to be MySQL being in strict mode, but I'm not positive since I can't check until tomorrow

Code Select Expand

Database Error
Field 'modifiedTime' doesn't have a default value
File: C:\Server\Apache\htdocs\forums\Sources\GlobalAnnouncementsAdmin.php
Line: 270

[softtouch]

I have installed Global Announcements V1.0, under SMF 1.1.1

After installing (no errors, no warnings), all seems to be ok.
I can modify the settings, do a preview of announcements, but soon I try to add an announcement, I get:

Database Error: Field 'modifiedTime' doesn't have a default value


If I manually edit the database and give this field a default value, I get:

Database Error: Field 'modifiedName' doesn't have a default value


Same, I manually give this field a default value, and get:

Database Error: Incorrect integer value: '' for column 'ID_BOARD' at row 1

...and so on.

Whats wrong?

[Tanix]

Would it be possible to have a similar facility as the standard 'enable recycling' for topics and messages? That way, disabled global announcements could be kept in an archive board

[JayBachatero]

when i try to install it from admin panel above message get appear... i tried several time and always i got the same error ...

It should show the step that it failed on.

mysticalone and softtouch:  run this query in phpMyAdmin.

Code Select Expand


AlTER TABLE {$db_prefix}global_announcements
CHANGE COLUMN time time int(10) unsigned NOT NULL default '0',
CHANGE COLUMN modifiedTime modifiedTime int(10) unsigned NOT NULL default '0',
CHANGE COLUMN modifiedName modifiedName tinytext NOT NULL default '',
CHANGE COLUMN icon icon varchar(16) NOT NULL default '',
CHANGE COLUMN subject subject tinytext NOT NULL default '';

ALTER TABLE {$db_prefix}global_announcements_boards
CHANGE COLUMN ID_GA ID_GA mediumint(10) unsigned NOT NULL default '0',
CHANGE COLUMN ID_BOARD ID_BOARD mediumint(10) unsigned NOT NULL default '0';

This should make the mod MySQL Strict mode compatible.

[Farmacija]

[softtouch]

when i try to install it from admin panel above message get appear... i tried several time and always i got the same error ...

It should show the step that it failed on.

mysticalone and softtouch:  run this query in phpMyAdmin.

Code Select Expand


AlTER TABLE {$db_prefix}global_announcements
CHANGE COLUMN time time int(10) unsigned NOT NULL default '0',
CHANGE COLUMN modifiedTime modifiedTime int(10) unsigned NOT NULL default '0',
CHANGE COLUMN modifiedName modifiedName tinytext NOT NULL default '',
CHANGE COLUMN icon icon varchar(16) NOT NULL default '',
CHANGE COLUMN subject subject tinytext NOT NULL default '';

ALTER TABLE {$db_prefix}global_announcements_boards
CHANGE COLUMN ID_GA ID_GA mediumint(10) unsigned NOT NULL default '0',
CHANGE COLUMN ID_BOARD ID_BOARD mediumint(10) unsigned NOT NULL default '0';

This should make the mod MySQL Strict mode compatible.

No, it does not work. Now I get:

Incorrect integer value: '' for column 'ID_BOARD' at row 1
File: C:\apache\htdocs\cebucityforum.com\Sources\GlobalAnnouncementsAdmin.php
Line: 281

Oh, I figured out that this error ONLY appears if I select "All Boards". If I select any board, it works... any idea?

[JayBachatero]

Ok try this file.  Upload it to the Source dir.

[mohoganybrwn]

Question: How do I make topics that are already created into Global Annoucments?

On my older version of SMF, it was in the "Additional Options" link in the post...but now I don't see anything for it... am I over looking something?

[softtouch]

Ok try this file.  Upload it to the Source dir.

Does not work, getting

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 '' at line 3
File: C:\apache\htdocs\cebucityforum.com\Sources\GlobalAnnouncementsAdmin.php
Line: 283

[auroramae]

errors about the admin template

lines 520 and 519
which are only references to the BBC

Code Select Expand

'size' => array('code' => 'size', 'before' => '[size=10pt]', 'after' => '[/size]', 'description' => $txt[532]),
'face' => array('code' => 'font', 'before' => '[font=Verdana]', 'after' => '[/font]', 'description' => $txt[533]),


Is there a fix?

[JayBachatero]

softtouch try this one.

auroramae what is the exact error that you are getting?

[RogueDOC]

 I get this error when i try to install.

"Fatal error: packageinstall(): Failed opening required '/hsphere/local/home/crysis/crysiscentral.3dactionplanet.gamespy.com/forum/Packages/temp/./ga_install.php' (include_path='.:/hsphere/shared/apache/libexec/php4ext/php/:/hsphere/shared/php') in /hsphere/local/home/crysis/crysiscentral.3dactionplanet.gamespy.com/forum/Sources/Packages.php on line 549"

The Install actions all come back as "Test successful". Then when i hit the "Install Now" button i get the error.

[auroramae]

auroramae what is the exact error that you are getting?

sorry I didn't include it with my post
When I open the global announcement admin area to edit or add
I get the two following errors:

8: Undefined offset: 533
File: /home/xxxxxx/public_html/forum/Themes/default/GlobalAnnouncementsAdmin.template.php
Line: 520
   
8: Undefined offset: 532
File: /home/xxxxxx/public_html/forum/Themes/default/GlobalAnnouncementsAdmin.template.php

I think I've figured this out on my own
I installed a mod that adds drop down boxes for font size and color to the BBC options.
I looked at the XML file for that mod and noticed that it  refers to the replacement text entries 532 and 533.

So I am now not worried about the errors.  They seem benign.
Thanks for replying to me.

[mohoganybrwn]

Question: How do I make topics that are already created into Global Annoucments?

On my older version of SMF, it was in the "Additional Options" link in the post...but now I don't see anything for it... am I over looking something?

anyone?