add additional admin error

Posted: Tue Jul 13, 2010 9:20 am

I say error; I get a white screen when I try to add another administrator.

Any suggestions? I literally get a blank screen once I've completed the details and press submit.

I accidentally deleted the admin last week (don't ask Rolling Eyes

)

I checked in Sentinel, and it was still showing the admin in there. When I clicked to check/ refresh for new admins, it removed the entry (I expected that)

I've tried adding him back since- no luck.

Cheers

Andy

Posted: Tue Jul 13, 2010 10:34 am

enable error reporting in rnconfig.php. Then try adding an admin again. Look for errors listed on the screen or in an error_log file in the root of your site.

Posted: Tue Jul 13, 2010 3:20 pm

If it helps the directory that contains the database error log file is named rnlogs. The file within that contains any database errors is named dblog.

There may be other errors in there so you will want to make a note of exactly what time you tried adding the admin back and then look for errors at that time and date.

registered · Posted: Wed Jul 21, 2010 8:05 pm

Check in phpMyAdmin to see if the admin you are logging in as is the "God" admin. It would be in the nuke_authors table and the "name" field would have a value of "God".

Just curious if the user you deleted was the God admin.

Posted: Thu Jul 22, 2010 3:58 am

no. I'm god admin; user was a super admin. Not had chance to do as suggested (yet)

Posted: Mon Aug 02, 2010 6:06 am

Quick look shows the following:

$error_reporting = E_ALL^E_NOTICE; // This is the default and means: All errors except Notices

Db log in RNlogs has permissions set at 0644- is this correct?

I tried adding the user manually using phpmyadmin (although I'd not set the md_5 and crypt passwords up (would this matter for now?))- When I looked in Sentinel for the scan for new admins, it deleted it.... (from the db)

Posted: Mon Aug 02, 2010 1:31 pm

$error_reporting = E_ALL;

Change chmod from 644 to 666 for RN logs.
and change also displays-errors to true in your config.php file. I believe loglevel 1 is enough.

"$display_errors = false; //This should only be used (set to "true") when testing locally and not in a production environment".

Also there is no problem to add manually someone to the Db.However you should not get a white screen and therefore check for errors in your RN logs.

Posted: Wed Aug 04, 2010 5:14 am

thanks for the help so far; managed to do this- below is the results of the log file:

Code:

August 4, 2010, 12:10 pm 1136 : Column count doesn't match value count at row 1


SQL was: insert into nuke_authors values ('cq20v', 'cq20v', 'website', 'email', 'password', '0', '1', '')


 remote addr: IPAddress


August 4, 2010, 12:11 pm 1136 : Column count doesn't match value count at row 1


SQL was: insert into nuke_authors values ('cq20v', 'cq20v', 'website', 'email', 'password', '0', '1', '')


 remote addr: IPAddress

Guessing there's some problem with the table structures since I upgraded to RN? Had a problem in the past with user groups.....

Posted: Wed Aug 04, 2010 7:18 am

It looks like your PHP code is correct but your table structure is wrong. You are supposed to have 7 fields in the authors table:

Code:

DROP TABLE IF EXISTS $prefix.`_authors`;


CREATE TABLE IF NOT EXISTS $prefix.`_authors` ( `aid` varchar(25) NOT NULL default '', `name` varchar(50) default NULL, `url` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', `pwd` varchar(40) default NULL, `counter` int(11) NOT NULL default '0', `radminsuper` tinyint(1) NOT NULL default '1', `admlanguage` varchar(30) NOT NULL default '', PRIMARY KEY  (`aid`) ) ENGINE=MyISAM;

That definition is from the SQL file in the installation directory for RN. You code is trying to insert 7 fields so I suspect your tables are wrong.

There is a table compare utility in the utilityfiles directory of the RN distribution that you can use or you can do it by hand with PHPmyadmin. I would be concerned that if your authors table is out of date, most likely other tables are also. We have provided a table update capability with the last few releases of RN (rndb_upgrade.php) but apparently you aren't using it.

Posted: Wed Aug 04, 2010 9:16 am

If I was to run the code above, would that not remove all admin? If so, then what?
I'll take a look into the distro, upload the suggested files via ftp and run the compare utility and rndb_upgrade (think I've done that before though. Wonder if there were any errors.....

Posted: Wed Aug 04, 2010 9:20 am

I was not suggesting that you run the code. I only pasted it in because it was a quick way to show the official structure of the table. Sorry for any confusion. I'd run the compare utility. The upgrade utility depends on a correct version number in your config table ... I would not recommend running it right away. I'd run the comparison and/or just fix up the authors table using phpmyadmin and then see where you are.

Posted: Wed Aug 04, 2010 9:57 am

AndyB, run the DB compare utility and we will get all your errors fixed up.

Posted: Wed Aug 04, 2010 10:47 am

Code:

The database you are using for comparison is: TABLE


You are comparing this data base against the structure of the database represented in fieldlist_240_01.txt


field keys do not match nuke_config sitename : Base PRI Your table


default values do not match nuke_config minpass : Base 8 Your table 5


field keys do not match nuke_counter type : Base PRI Your table


field keys do not match nuke_counter var : Base PRI Your table








tables processed: 118


fields processed: 863


fields not found on your system 0


tables not found in your system: 0

Does that help?

Posted: Wed Aug 04, 2010 1:28 pm

Hmm. That is saying your db is basically fine other than for a couple missing keys, but that should case any major problems. Try re-uploading the admin folder.

Posted: Thu Aug 05, 2010 12:56 am

will do, thanks.

Posted: Thu Aug 05, 2010 7:40 am

I was sitting here looking at this and scratching my head. Then I went back and reread one of your early posts. You posted:

Code:

SQL was: insert into nuke_authors values ('cq20v', 'cq20v', 'website', 'email', 'password', '0', '1', '')

as what was happening when the error occurred. Counting carefully, that's 8 fields. The database table only has 7. So that explains the error. Palbin's suggestion about reuploading the admin folder should work but if it doesn't and you get the same error we just need to make sure you have the right versions of programs.

Edit ... oops. I screwed up. The table has 8 fields so having an incorrect version of the PHP program may not be the explanation. We'll just have to see what happens after you upload the the latest admin folder.

Posted: Sat Aug 07, 2010 5:52 am

ok, I've left it logging for a while....

I've reuploaded the admin folder today; here's the results:

Quote:

August 4, 2010, 5:05 pm 1146 : Table 'afnet_nuke1.nukeGCAL_CONF_TABLE' doesn't exist
SQL was: SELECT * FROM nukeGCAL_CONF_TABLE
remote addr: 66.249.66.153
August 4, 2010, 5:06 pm 1146 : Table 'afnet_nuke1.nukeGCAL_CONF_TABLE' doesn't exist
SQL was: SELECT * FROM nukeGCAL_CONF_TABLE
remote addr: 66.249.66.153
August 4, 2010, 5:11 pm 1146 : Table 'afnet_nuke1.nukeGCAL_CONF_TABLE' doesn't exist
SQL was: SELECT * FROM nukeGCAL_CONF_TABLE
remote addr: 66.249.66.87
August 4, 2010, 7:40 pm 1100 : Table 'nuke_session' was not locked with LOCK TABLES
SQL was: SELECT time FROM nuke_session WHERE uname='abud'
remote addr: 202.138.246.3
August 4, 2010, 7:40 pm 1100 : Table 'nuke_session' was not locked with LOCK TABLES
SQL was: INSERT INTO nuke_session (uname, time, host_addr, guest) VALUES ('abud', '1280947211', '202.138.250.88', '0')
remote addr: 202.138.246.3

August 6, 2010, 11:49 pm 1064 : 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 ')
GROUP BY word_id
' at line 3
SQL was: SELECT word_id FROM nuke_bbsearch_wordmatch WHERE word_id IN () GROUP BY word_id HAVING COUNT(word_id) = 1
remote addr: 86.140.119.237
August 6, 2010, 11:57 pm 1064 : 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 ')
GROUP BY word_id
' at line 3
SQL was: SELECT word_id FROM nuke_bbsearch_wordmatch WHERE word_id IN () GROUP BY word_id HAVING COUNT(word_id) = 1
remote addr: 90.221.32.134
August 7, 2010, 12:48 pm 1136 : Column count doesn't match value count at row 1
SQL was: insert into nuke_authors values ('cq20v', 'cq20v', 'www.audifans.net', 'email', 'password', '0', '0', '')
remote addr: 80.229.144.109

I left the other errors in, as it may show there's a global issue with the DB. Is it worth running a "Db upgrade" script? (if one exists)

Posted: Sat Aug 07, 2010 7:20 am

I don't think the upgrade script can or will do much about this problem.

The last error you list really has me puzzled -- the one with the authors table. Can you do an export of just your data structure in PHPmyadmin and paste the results in here in a code block.

Also, I just read back through the thread and don't get any sense of how your system "evolved". Was this a Ravennuke system from the start or did you start with PHPnuke or some other variation? How did you get a table "afnet_nuke1.nukeGCAL_CONF" TABLE? There is a table your_prefix_gcal_conf but where your prefixes came from and why they are different (apparently) from the prefixes in the rest of the system has me wondering.

Posted: Sat Aug 07, 2010 7:26 am

started with 6.8, then patched, then later upgraded to 7.6 (patched) and then finally onto RN. Will get the table structure and post back.

As for the GCal- it's not enabled on the site, so that's a bit "odd" to me as well....

oh, the GCalendar I installed at some point but didn't use...

Posted: Sat Aug 07, 2010 8:18 am

Don't think I can add it all (gets truncated) which part do you want exactly so I can add the correct bits for you....

Note for mods: can you please remove my post above? I can't edit it to make it smaller (no submit button at the bottom)

Posted: Sat Aug 07, 2010 9:17 am

Yes, I'll get rid of it for you. I was just suggesting dumping the author's table. Here's the part that was needed:

Code:

CREATE TABLE IF NOT EXISTS `nuke_authors` (


`aid` varchar(25) NOT NULL default '',


`name` varchar(50) default NULL,


`url` varchar(255) NOT NULL default '',


`email` varchar(255) NOT NULL default '',


`pwd` varchar(40) default NULL,


`counter` int(11) NOT NULL default '0',


`radminCalendarAdmin` tinyint(2) NOT NULL default '0',


`radminsuper` tinyint(1) NOT NULL default '1',


`admlanguage` varchar(30) NOT NULL default '',


`radminblocker` tinyint(2) NOT NULL default '0',

Here's what it should look like:

Code:




CREATE TABLE IF NOT EXISTS `nuke_authors` (


  `aid` varchar(25) NOT NULL default '',


  `name` varchar(50) default NULL,


  `url` varchar(255) NOT NULL default '',


  `email` varchar(255) NOT NULL default '',


  `pwd` varchar(40) default NULL,


  `counter` int(11) NOT NULL default '0',


  `radminsuper` tinyint(1) NOT NULL default '1',


  `admlanguage` varchar(30) NOT NULL default '',

You have extra fields that's causing the program to go bonkers. I'm not sure where you got them .. the `radminCalendarAdmin` tinyint(2) NOT NULL default '0', and the radminblocker. As far as I know, gcal never used a field like that. You might do a global search over your program directories and see if those fields are used anywhere. This kind of ties into the questions I had earlier about where those calendar tables came from. Things like this don't get created by accident and you kind of need to know why they are there. If you have the normal Gcal that comes with the RN distribution that field isn't needed.

Posted: Sat Aug 07, 2010 9:22 am

Note: I tried editing Andy's long post with a list of all his tables but I couldn't save the edited result. I was able to delete it. The relevant part is in my previous post.

Posted: Sat Aug 07, 2010 9:28 am

I think I added GCalendar a LONG time ago but didn't use it. There were some other bits that have been used over the years, but then deactivated.

Any program suggestions for doing a search on those fields in the programs? I'm guessing an FTP client (use Cute FTP- an older version)- not sure if it's something I can do with filezilla?

I'm also wondering if I followed the instructions correctly for the table comparison thing- it wasn't in the root with the rest of the nuke stuff, I had it in a subfolder called utils, or similar....

Posted: Sat Aug 07, 2010 12:17 pm

Gcalendar is only a couple of years old and never involved those fields you referenced, especially not the one in the authors table. To see what fields are in what tables you can just look in the rn_core.sql file in the INSTALLATION/SQL folder of the distribution. All the "official" table layouts are there. Any discrepancies will cause you problems. Most likely you did not follow the table comparison instructions correctly or those instructions did not deal your anomalous setup. They presume a standard setup of your tables.

You might backup your authors table then try deleting those two extra fields and see what happens. I think you have something more systematic causing the problem but that might be a temporary bandaid that will let you get operating again.

Posted: Sat Aug 07, 2010 8:07 pm

AndyB, you don't need to delete your admin table. Just use phpmyadmin to delete the columns that are not in a standard installation.

radminblocker
radminCalendarAdmi