[Module] Announcements

[Tom M]

Im getting this error, when importing the module.

Have you installed the module previously?

[Eros]

Hello Tom, yeah i did installed is previously, in vB 3.5x. But after upgrading to vb 3.6x. I did a fresh install of vBa CMPS. so is thr any solution to fix it ?

[Our Sponsors]

[Tom M]

Hello Tom, yeah i did installed is previously, in vB 3.5x. But after upgrading to vb 3.6x. I did a fresh install of vBa CMPS. so is thr any solution to fix it ?The problem is that the phrases got installed into vb. Give this a try... Use the phrase manager and search for phrase titles that contain 'portal_ann' w/o the quotes and then "edit/delete" delete them. The other solution is to use phpMyAdmin to delete them from the db directly.

BTW - This module doesn't work with 3.6 unless you want to modify it to do so.

[Eros]

thx Tom, its installed fine & working without any problem (with the solution DMeNTED911 provided above, thx to him aswell). But the the Announcements URL's just pointing to the forum home rather then to the actual Announcements url :s

[Our Sponsors]

[hunteds911]

I get this error at this point.

Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT announcementid, startdate, title, announcement.views, forumid, enddate, pagetext, allowhtml, allowbbcode, allowsmilies,
user.username, user.userid, user.usertitle, user.customtitle
FROM announcement AS announcement
LEFT JOIN user AS user ON(user.userid = announcement.userid)
WHERE startdate <= 1174744061
AND enddate >= 1174744061
AND forumid IN (16,-1)
ORDER BY startdate DESC
LIMIT 3;

MySQL Error : Unknown column 'allowhtml' in 'field list'
Error Number : 1054
Date : Saturday, March 24th 2007 @ 10:47:42 AM
Script : http://www.realmgfx.com/?
Referrer : http://www.realmgfx.com/forum/forumdisplay.php?f=16
IP Address :
Username : Hunted
Classname : vb_database

[hunteds911]

NM I should learn to read. I got it fixed with the help of the post from DMeNTED911. lol Thanks for the fix DMeNTED911