help i f***** up my db

[iGuest 3]

hi all after running newsflash.sql through phpMyAdmin on phpnuke 7.5 my db was f*****...pls help...thx

[iGuest 3]

Okay what errors do you get when you run the .sql file? As with my xperience with phpNuke it never backed up properly with the .sql file.Run the sql query file in phpMyAdmin and post error message you get here.

[iGuest 3]

ErrorSQL-query : ALTER TABLE `nuke_authors` ADD `radminNewsflashAdmin` TINYINT( 2 ) NOT NULL AFTER `radminency`MySQL said:#1054 - Unknown column 'radminency' in 'nuke_authors'

[iGuest 3]

Error
SQL-query :  

ALTER TABLE `nuke_authors` ADD `radminNewsflashAdmin` TINYINT( 2 ) NOT NULL AFTER `radminency`

MySQL said:

#1054 - Unknown column 'radminency' in 'nuke_authors'

Try this:

ALTER TABLE `nuke_authors` ADD `radminNewsflashAdmin` TINYINT( 2 ) NOT NULL AFTER `radminency`;

[iGuest 3]

nope doesnt work....

[iGuest 3]

hey, check the table nuke_authors. is it really exist?

[iGuest 3]

never mind i fixed it already....nazrin helped me...

[iGuest 3]

never mind i fixed it already....nazrin helped me...

so what do you have to say? :D