Unknown column 'radmintopic' in 'field list' ERRORS

New Member Joined: Feb 28, 2006 Posts: 4

I need your help.
I have the version Raven 7.6 v.2 installed.
However I had some modules I used even with regular 7.6
But once i used your version which i appreciate dearly, every time I click in admin window for these modules ( which so far are 2 only),
here is all i get on the screen:
Unknown column 'radmindownload' in 'field list'
Unknown column 'radmindownload' in 'field list'
Access Denied

And on the other module, i get this:
Unknown column 'radmintopic' in 'field list'
Unknown column 'radmintopic' in 'field list'
Access Denied

Both modules work fine for a regular user and only used data in the db. I can not update them since I can not access the control Panel window in admin.php
Please help me to fix this, i am new so please be gentle in your explanation with me.
Thanks very much for all your great work and contribution,
sis. jm[/b]

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

It looks like you either did not install the Core files that came with the distro or you have third party modules that need to be reinstalled. Those fields are no longer in the core nuke_authors table in v7.6. Use phpmyadmin and verify that the fields are not in the nuke_authors table. If that's the case, then you will need to reinstall the modules.

Posted: Thu Mar 02, 2006 11:30 pm

Hello Raven,
Thank you for responding. I see I have a field "radminsuper".
Is this field you are talking about or another one?
Thank you very much.

Posted: Fri Mar 03, 2006 1:06 am

This is what the core nuke_author's table should look like in v7.6. If you are using modules that need those other columns then you need to reinstall those modules.

Code:

CREATE TABLE `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 '', 


PRIMARY KEY  (`aid`) 


) TYPE=MyISAM;

Posted: Fri Mar 03, 2006 6:33 am

juma

Did you have the attachment MOD installed before? I "Think" those go with the Attachment Mod.

Posted: Sat Mar 04, 2006 10:50 pm

No I did not have the attachment MOD installed before.
Also I want to understand better since i am not an expert in Mysql.
I see the table Authors, how do i make sure I have same as the one showed above? Do I have to reinstall Phpnuke?
Raven, you said if I am using modules that need those other columns , what Other columns? which columns?
Please be specific since I am still new in this.
Do I have to edit the sql of those modules or not?
Again thank u for being patient with me.
JumA

Posted: Sat Mar 04, 2006 10:54 pm

Sorry I forgot one thing, even after I deleye the module and reinstall it just behave same way with no change

registered · Posted: Sun Mar 05, 2006 7:29 am

juma, what patch level was your previous regular nuke76 site at?

Posted: Wed Jul 26, 2006 9:16 am

I'm using Raven's Distro straight out of the box and installed EDL2.1 for 7.6-7.9 and I get the same errors. I have no additional modules installed other than what came with Raven's package

So what modules do we need to reinstall??

It's craziness.

Also, in my nuke_authors table I ONLY have the fields raven mentioned above..so what is the deal?
I looked thru all the tables and I cannot find Unknown column 'radmindownload' in 'field list' anywhere.

Posted: Wed Jul 26, 2006 9:45 am

Myrtletrees: no it's not craziness though it may appear to be, it's the way programming and specifically SQL works. The additional modules that you have installed require the additional fields that you listed: radmindownload and radmintopic. No doubt the administration parts of those modules make reference to those fields and when they don't show up then you get the error you are seeing. Raven listed the fields that are present in the standard Ravennuke distribution. Since that distribution doesn't include the fields you listed since it doesn't include those modules.

There is probably some SQL that comes with the install program for those modules that adds those fields to your authors table. If so, you will need to rerun that. If not, you need to find out what the field types are from the instructions for the modules and add them thru PHPmyadmin or another tool.

Posted: Wed Jul 26, 2006 9:56 am

I know, I was being facetious.

After re-uploading core module files, it seems to be working now and the errors are gone.

My recommendation to others with similar issues. Re-upload all core files for the addon module you are installing.

Thanks

Posted: Wed Jul 26, 2006 9:58 am

Well then, if you were being facetious then I was being "thick as a brick". Glad your problem is resolved.

Posted: Wed Jul 26, 2006 10:27 am

fkelly wrote:

Well then, if you were being facetious then I was being "thick as a brick". Glad your problem is resolved.

hehe