database error from 1.1.6 to 1.1.8

[akosiparusa]

i have this strange error on my smf, before posting this thread, i have searched the entire site but none of the topics posted have had help me.

before the error:

i wanted to delete users on the awaiting for approval list, and after selecting reject, i had an error.

here's some of the screenshots.

error message


mysql db


Subs-members.php


btw, should i add the table manually would fix it, but how to make it?

i hope someone can help me. thanks.

[Spaceman-Spiff]

You can just recreate the table in phpmyadmin by running the following SQL code:

Code Select Expand

#
# Table structure for table `log_actions`
#

CREATE TABLE smf_log_actions (
  ID_ACTION int(10) unsigned NOT NULL auto_increment,
  logTime int(10) unsigned NOT NULL default '0',
  ID_MEMBER mediumint(8) unsigned NOT NULL default '0',
  ip char(16) NOT NULL default '                ',
  action varchar(30) NOT NULL default '',
  extra text NOT NULL,
  PRIMARY KEY (ID_ACTION),
  KEY logTime (logTime),
  KEY ID_MEMBER (ID_MEMBER)
) TYPE=MyISAM;

[greyknight17]

akosiparusa, is this issue resolved now after following the instruction above?

[akosiparusa]

hi, please plush this thread to the bowl, site is down already =)

Thanks

[JimM]

akosiparusa - Are you saying you no longer need assistance here because the site is down?

[akosiparusa]

yup. thanks. it doesn't exist anymore.

[Aleksi "Lex" Kilpinen]

yup. thanks. it doesn't exist anymore.

I will mark this solved then for now, but if you do still want help on this - feel free to mark the topic not solved, and post back with further details on your situation.