I had the problem like many others with my site going blank after upgrade from 1.3.2 to 1.4.0.
My solution until recently was a includes/def_tree.php file with all of the definition calls locked at cmod 644. <img> (might want to upload fresh file, make sure cmod 666, if you edited this file, that could be the problem.)
I ended up loosing that file with the recent site hack, and through some trial, and error figured out that the problem was originating from my auth_access table.
By replacing this table with a fresh one, I fixed the issue on my site.
I wish I could tell you that I knew if you were having the same problem or not, but if you have phpMyAdmin you could find out in about three minutes if you would like to give this solution a whirl.
Log into phpMyAdmin, and select your database.
Click SQL to run a query (Assuming your version is similar to the one I use)
In the query field insert:
- Code: Select all
-- -- Table structure for table `test_auth_access`-- CREATE TABLE `test_auth_access` ( `group_id` mediumint(8) NOT NULL default '0', `forum_id` smallint(5) unsigned NOT NULL default '0', `auth_view` tinyint(1) NOT NULL default '0', `auth_read` tinyint(1) NOT NULL default '0', `auth_post` tinyint(1) NOT NULL default '0', `auth_reply` tinyint(1) NOT NULL default '0', `auth_edit` tinyint(1) NOT NULL default '0', `auth_delete` tinyint(1) NOT NULL default '0', `auth_sticky` tinyint(1) NOT NULL default '0', `auth_announce` tinyint(1) NOT NULL default '0', `auth_global_announce` tinyint(1) NOT NULL default '0', `auth_vote` tinyint(1) NOT NULL default '0', `auth_pollcreate` tinyint(1) NOT NULL default '0', `auth_attachments` tinyint(1) NOT NULL default '0', `auth_mod` tinyint(1) NOT NULL default '0', `auth_download` tinyint(1) NOT NULL default '0', `auth_news` tinyint(1) NOT NULL default '0', `auth_cal` tinyint(1) NOT NULL default '0', `auth_ban` tinyint(1) NOT NULL default '0', `auth_greencard` tinyint(1) NOT NULL default '0', `auth_bluecard` tinyint(1) NOT NULL default '0', `auth_delayedpost` tinyint(4) NOT NULL default '3', KEY `group_id` (`group_id`), KEY `forum_id` (`forum_id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `test_auth_access`-- INSERT INTO `test_auth_access` (`group_id`, `forum_id`, `auth_view`, `auth_read`, `auth_post`, `auth_reply`, `auth_edit`, `auth_delete`, `auth_sticky`, `auth_announce`, `auth_global_announce`, `auth_vote`, `auth_pollcreate`, `auth_attachments`, `auth_mod`, `auth_download`, `auth_news`, `auth_cal`, `auth_ban`, `auth_greencard`, `auth_bluecard`, `auth_delayedpost`) VALUES (4, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 0, 0, 1, 1, 1, 0, 0, 0, 3);INSERT INTO `test_auth_access` (`group_id`, `forum_id`, `auth_view`, `auth_read`, `auth_post`, `auth_reply`, `auth_edit`, `auth_delete`, `auth_sticky`, `auth_announce`, `auth_global_announce`, `auth_vote`, `auth_pollcreate`, `auth_attachments`, `auth_mod`, `auth_download`, `auth_news`, `auth_cal`, `auth_ban`, `auth_greencard`, `auth_bluecard`, `auth_delayedpost`) VALUES (435, 3, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 0, 0, 1, 1, 1, 0, 0, 0, 3);INSERT INTO `test_auth_access` (`group_id`, `forum_id`, `auth_view`, `auth_read`, `auth_post`, `auth_reply`, `auth_edit`, `auth_delete`, `auth_sticky`, `auth_announce`, `auth_global_announce`, `auth_vote`, `auth_pollcreate`, `auth_attachments`, `auth_mod`, `auth_download`, `auth_news`, `auth_cal`, `auth_ban`, `auth_greencard`, `auth_bluecard`, `auth_delayedpost`) VALUES (298, 3, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 0, 0, 1, 1, 1, 0, 0, 0, 3);INSERT INTO `test_auth_access` (`group_id`, `forum_id`, `auth_view`, `auth_read`, `auth_post`, `auth_reply`, `auth_edit`, `auth_delete`, `auth_sticky`, `auth_announce`, `auth_global_announce`, `auth_vote`, `auth_pollcreate`, `auth_attachments`, `auth_mod`, `auth_download`, `auth_news`, `auth_cal`, `auth_ban`, `auth_greencard`, `auth_bluecard`, `auth_delayedpost`) VALUES (298, 4, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 0, 0, 1, 1, 1, 0, 0, 0, 3);
You can replace test with anything, as long as it doesn t already exist in your database.
Then open includes/constants.php (keep a backup of original)
Find
- Code: Select all
define('AUTH_ACCESS_TABLE', $table_prefix.'auth_access');
and replace with
- Code: Select all
define('AUTH_ACCESS_TABLE', 'test_auth_access');
(if you changed test in database change it here too)
save and upload.
Now if this fixes the problem, you will need to re-distribute any permissions that you may have given out, except to Admins.
If it doesn t work, re-upload original constants.php, and if you like drop the test_auth_access tables in database that you inserted.
Posted: Thu Aug 31, 2006 3:41 am