500 - An error has occurred

[radiobs]

Upgraded from 1.7 to 2.5.
Had to "fix" the DB
Now I get this error 500 every time I try to access the Users.

500 - An error has occurred.
Table 'amoa2012.jos_user_notes' doesn't exist SQL=SELECT n.user_id, COUNT(n.id) As note_count FROM jos_user_notes AS n WHERE n.user_id IN (62,210,65,124,64,63) AND n.state >= 0 GROUP BY n.user_id

Return to Control Panel

I would appreciate any insight, advice, direction, cooking tips, especially if you can tune me into a resolution.

Thank you for your help.

Eric

[nayihba]

Try creating the jos_user_notes table manually in your amoa2012 database.
Run the following query in your database context. PHPmyadmin, select the database and in SQL - as usual, i'd recommend first doing this on a staging copy and not production.

Code: Select all

CREATE TABLE `amoa2012.jos_user_notes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `catid` int(10) unsigned NOT NULL DEFAULT '0',
  `subject` varchar(100) NOT NULL DEFAULT '',
  `body` text NOT NULL,
  `state` tinyint(3) NOT NULL DEFAULT '0',
  `checked_out` int(10) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_user_id` int(10) unsigned NOT NULL,
  `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `review_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_category_id` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[radiobs]

Thank you for the information, nayihba. An added wrinkle to the matter is that my ISP interface has locked me out (for some reason the permissions have been wiped out when I upgraded Joomla). So they are now attempting to reset the permissions.

Once that is done, I will go to my File Manager, and get into the PHPmyadmin, and create the query.

To further complicate things, I did a backup with Akeeba prior to the update, but once update was accomplished, Akeeba wanted to upgrade to a newer version. In that process, my backup cannot be found. I would backup the site now, except with so many things NOT working, I don't know that it is genuinely worthwhile to save.

Insomuch as I have several issues, what are your thoughts as to now moving up to Joomla 3.2 (actually 3.1 is available through the ISP). Would that create a new "User" file (or find the old one) and will that resolve the 500 error?

While I sit and wait for the ISP, I am just trying to think of other ways around the matter.

Thanks again for your time and effort.

Eric

[itoctopus]

How did you update from 1.7 to 2.5? The problem is that I don't think this'll be the only issue you'll have (the missing user_notes table).

1.7 is very different from 2.5 and you need a migration to do this move (and not a simple update).

In any case, please keep this post updated...