Thread

So I’ve had a week.

One of my wordpress installs was sodomized by that dreaded base64_decode malware (whatever the flavor of the week is), and because of this, it took my EE install down with it.

I’ve been slowly trying to put stuff back together, I know I messed quite a few things up, didn’t do things in the right order, didn’t read the documentation… But I’m getting there. I fix something, get an error, wash, rinse, repeat.

My latest stumbling block has me, well… stumped:

A Database Error Occurred
Error Number: 1146

Table 'xxxx.exp_developer_log' doesn't exist

SELECT COUNT(*) AS `numrows` FROM (`exp_developer_log`) WHERE `viewed` = 'n'

Filename: models/tools_model.php

Line Number: 257

I had a db backup from 6 days ago before all this calamity started, and I’ve installed from that, but now I’m stuck.

Any ideas?

Hey Shad,

It sounds like you have uploaded the latest version of EE while your database is for an older version (exp_developer_log was added in 2.3 or 2.4). You need to follow the upgrade instruction:

http://ellislab.com/expressionengine/user-guide/installation/update.html

Or you could find your old zip of EE and upload those files instead of the latest release.

Hey Shad, aka: helbnt,

Nifty name. 😊

If you are on version 2.4 and you manage to get your DB in the right condition, you may still run into this. It’s a known Bug.

A quick fix is listed on the bug, basically add the table.

CREATE TABLE `exp_developer_log` (
  `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `timestamp` int(10) unsigned NOT NULL,
  `viewed` char(1) NOT NULL DEFAULT ‘n’,
  `description` text NULL,
  `function` varchar(100) NULL,
  `line` int(10) unsigned NULL,
  `file` varchar(255) NULL,
  `deprecated_since` varchar(10) NULL,
  `use_instead` varchar(100) NULL,
  PRIMARY KEY (`log_id`)
);

Please keep us posted on your progress. Would love to know how it turns out.

Cheers,

It looks like he messed up his config file before running the installer: https://support.ellislab.com/bugs/detail/17419/#13943

Hey guys,

Sorry for the long wait for reply. Got busy with other stuff.

Shane, that’s exactly what I was looking for, the actual SQL code I could input in my phpMyAdmin - however I’m getting an error:

#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 '‘n’, `description` text NULL, `function` varchar(100) NULL, `line` ' at line 4

I copied what you put, and copied that into a text editor (sublime) to get rid of any weird formatting it might’ve inherited but no dice. I know just enough about mysql to be dangerous, but not enough to figure this out.

Thanks for the help!

Give this version with standard single-quotes a try:

CREATE TABLE `exp_developer_log` (
  `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `timestamp` int(10) unsigned NOT NULL,
  `viewed` char(1) NOT NULL DEFAULT 'n',
  `description` text NULL,
  `function` varchar(100) NULL,
  `line` int(10) unsigned NULL,
  `file` varchar(255) NULL,
  `deprecated_since` varchar(10) NULL,
  `use_instead` varchar(100) NULL,
  PRIMARY KEY (`log_id`)
);

Hi Shad,

Have you had a chance to try out Chris’s query?

Chris, thanks for the help on this one, we appreciate that.

Sean

Hey guys,

Chris, thanks, that seemed to do the trick. I at least get into the Control Panel now.

However, now I’m getting “Your ExpressionEngine installation’s version (2.4.1) is not consistent with the reported version (2.4.0). Please update your installation of ExpressionEngine again.” I checked my config.php file and the line that reads:

$config['app_version'] = "241";

seems to be set correctly. At the bottom of my Control Panel now though, it says

v2.4.0 - Build: date  20120123 -

Is there somewhere other than the config.php where I need to set this? Or do I need to *gulp* go through the update process again?

Thanks again for all the help guys!

-shad

$config['app_version'] = "241";

Hey Shad, I’m pretty sure this should be “240.” There is no EE 2.4.1.

Sean: No problem. I want my hundred posts. 😉

Good lord, it’s a wonder I’m able to put pants on some mornings.

Thanks Chris. I really appreciate the help!

It’s not a problem. Does that get everything back up and running? I know there was another table added between EE 2.3 and 2.4: exp_remember_me. Several of the other tables had columns added or removed. Let me know if you want me to post the list of changes.

Yup - everything back-end wise seems peachy-keen now.

Now it’s all about my templates being borked. That I can fix 😉

Thanks all. Mods can close this thread out as resolved.

Hey All,

Nice work! I am glad to see this was resolved.

Have a great weekend!

Cheers,