SQL Error for Global Announcements

Wondering why that MOD you have won't install correctly? Let's take a look
Forum rules
DO NOT give out any FTP passwords to anyone! There is no reason to do so! If you need help badly enough, create a temporary FTP account that is restricted to only the files that you need help with and give the information for that. Giving out FTP information can be very dangerous!
Locked
Shax
Registered User
Posts: 1
Joined: Sat Feb 03, 2007 12:44 am

SQL Error for Global Announcements

Post by Shax » Sat Feb 03, 2007 12:46 am

Code: Select all

Failed obtaining forum access control lists

DEBUG MODE

SQL Error : 1054 Unknown column 'a.auth_globalannounce' in 'field list'

SELECT a.forum_id, a.auth_view, a.auth_read, a.auth_post, a.auth_reply, a.auth_edit, a.auth_delete, a.auth_sticky, a.auth_announce, a.auth_vote, a.auth_pollcreate, a.auth_globalannounce, a.auth_mod FROM phpbb_auth_access a, phpbb_user_group ug WHERE ug.user_id = 2 AND ug.user_pending = 0 AND a.group_id = ug.group_id AND a.forum_id = 1

Line : 164
File : auth.php
Please Help :(

User avatar
Poomerio
Registered User
Posts: 552
Joined: Tue Jan 02, 2007 7:09 pm
Location: 4(x - 20y) = 20

Re: SQL Error for Global Announcements

Post by Poomerio » Sat Feb 03, 2007 9:19 am

I got that with the Announcement Suite.
Try the "Scrolling Announcement" MOD.
Search for announce on the phpBB MOD database.

- Poomie

User avatar
Nightrider
Registered User
Posts: 7219
Joined: Tue Nov 16, 2004 8:54 pm
Location: Florida, US
Contact:

Re: SQL Error for Global Announcements

Post by Nightrider » Thu Feb 08, 2007 7:20 pm

This means that you failed to update the database after installing a MOD. Check the Author's notes for instructions for updating your database. Many times, they include a file that you can upload to your phpBB forum folder and run from your browser...

If appears that you ignored the SQL Processing error when you installed the Global Announcement MOD using EM. So these two SQL queries still need to be applied to your database:

Code: Select all

# 
#-----[ SQL ]------------------------------------------------- 
# 
ALTER TABLE phpbb_forums ADD auth_globalannounce TINYINT (2) DEFAULT "3" NOT NULL AFTER auth_announce;
ALTER TABLE phpbb_auth_access ADD auth_globalannounce TINYINT (1) not null AFTER auth_announce;
You can either Restore the EM Backups and correct the queries above or you can apply these directly to your database. It would probably be easiest to explain on how to Restore the Backups...

Ok, try this:

OPEN
global_announcement1.2.9em.txt

FIND

Code: Select all

# 
#-----[ SQL ]------------------------------------------------- 
# 
ALTER TABLE phpbb_forums ADD auth_globalannounce TINYINT (2) DEFAULT "3" NOT NULL AFTER auth_announce;
ALTER TABLE phpbb_auth_access ADD auth_globalannounce TINYINT (1) not null AFTER auth_announce;
REPLACE WITH

Code: Select all

# 
#-----[ SQL ]------------------------------------------------- 
# 
ALTER TABLE phpbb_forums ADD auth_globalannounce TINYINT (2) DEFAULT "3" NOT NULL;
ALTER TABLE phpbb_auth_access ADD auth_globalannounce TINYINT (1) not null;
Next Restore the EM Backups for the Global Announcement MOD, then Save, upload, and try installing this MOD again using EM...

Restoring EM Backups

If a MOD that you installed with EM hosed your board or you decide that you just don't want it, simply go into EM History in your ACP MOD Center and click on the Details button next to the MOD entry..

Image

On the bottom of the next page, select Restore Backups and press the Go button. Make sure you DON'T select the Remove Record option or you will be forced to manually rolll back the EM backups that were created for you. I will have to walk you through that if need be...

Image

Next you will see a page to confirm eht operation. You would choose Yes:

Image

MODs can only be uninstalled in reverse order that they were installed: FILO (First In, Last Out). So if you installed a MOD, then several others, then decided to remove the first one, you would have to Restore the backups of the other MODs before you could Restore the backups on the first MOD...

Restoring EM Backups (Manual Instructions)

If you are unable to get into the ACP, you will need to use these manual instructions to Restore the EM Backups...

Download the backups folder that EM created for you in the MOD sub-folder found in admin/mods. Strip the .txt extension from each file in every folder in the backups folder. So the resulting file extensions will be php, tpl, css, and cfg. Upload the files back to their proper locations on your board; i.e.
  • copy backups/admin/*.* to phpBB/admin/*.*
  • copy backups/includes/*.* to phpBB/includes/*.*
  • copy backups/language/lang_english/*.* to phpBB/language/lang_english/*.*
  • copy backups/templates/subSilver/*.* to phpBB/templates/subSilver/*.*
  • copy backups/*.* to phpBB/*.*
Of course if you have alternate templates and language folders, you will need to copy the files for them as well. I'm referring to phpBB as your forum's root folder in the above copy commands. If your root folder has any other name, just substitute phpBB with the name of your forum's root folder name...

Image

User avatar
3Di
Registered User
Posts: 686
Joined: Tue Nov 01, 2005 9:50 pm
Location: Milano (I) Frankfurt (D)
Contact:

Re: SQL Error for Global Announcements

Post by 3Di » Sat Mar 10, 2007 11:25 pm

Moved from: EM SQL Parser Forum
Want to compensate me for my interest? Don't ask me, just do it
I'm available for custom phpBB jobs, you can PM me the details.
New: my Live Board, Extensions and Tools for phpBB - Men at works.

Locked

Who is online

Users browsing this forum: No registered users and 5 guests