Manually create blocked_ips:PDOException:SQLSTATE[42S02]: Base table or view not found: 1146 Table 'x.blocked_ips' doesn't exist

Created the table like this:

CREATE TABLE `blocked_ips` (
  `iid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: unique ID for IP addresses.',
  `ip` varchar(40) NOT NULL DEFAULT '' COMMENT 'IP address',
  PRIMARY KEY (`iid`),
  KEY `blocked_ip` (`ip`)
)

As seen in this post:

And got the following errors instead:

Additional uncaught exception thrown while handling exception.

Original

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'jambodb.users' doesn't exist: SELECT uid, name, picture, data FROM {users} WHERE uid IN (:uids_36, :uids_49); Array ( [:uids_36] => 1 [:uids_49] => 1 ) in user_node_load() (line 3497 of C:\wamp\www\drupal7\Jambo\modules\user\user.module).

Additional

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'jambodb.watchdog' doesn't exist: INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 0 [:db_insert_placeholder_1] => php [:db_insert_placeholder_2] => %type: !message in %function (line %line of %file). [:db_insert_placeholder_3] => a:6:{s:5:"%type";s:12:"PDOException";s:8:"!message";s:240:"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'jambodb.users' doesn't exist: SELECT uid, name, picture, data FROM {users} WHERE uid IN (:uids_36, :uids_49); Array ( [:uids_36] => 1 [:uids_49] => 1 ) ";s:9:"%function";s:16:"user_node_load()";s:5:"%file";s:50:"C:\wamp\www\drupal7\Jambo\modules\user\user.module";s:5:"%line";i:3497;s:14:"severity_level";i:3;} [:db_insert_placeholder_4] => 3 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => http://localhost/drupal7/Jambo/ [:db_insert_placeholder_7] => [:db_insert_placeholder_8] => 127.0.0.1 [:db_insert_placeholder_9] => 1322129297 ) in dblog_watchdog() (line 155 of C:\wamp\www\drupal7\Jambo\modules\dblog\dblog.module).

Now I'm at a loss.

Hi Damien,

This is an issue concerning upgrade from Drupal 6 to Drupal 7 and I have seen similar posts listed under Drupal Core issues. The reason why I created a new one is because I have tried the other suggested solutions and none of them have worked because they modify the update process itself (changes to update.php) as opposed to making changes to the resultant database. I need to manually make changes to database because that's all I have. The errors are not unique to the theme, I've experienced something similar with other themes. Opening a support ticket is therefore futile.