500 - An error has occurred (Beta 2)

[Worxx]

When in the Control Panel as Super Admin I click on User Manager I get this error within the CP and an option to return to CP.

Table 'db********.lz85x_user_notes' doesn't exist SQL=SELECT n.user_id, COUNT(n.id) As note_count FROM lz85x_user_notes AS n WHERE n.user_id IN (44,43,42) AND n.state >= 0 GROUP BY n.user_id

I had installed (Clean no upgrade) Beta 1 and then upgraded to Beta 2 thinking it might be fixed.

I look in the database and do not see a 'user_notes' table.

Everything else and the Front end seems to work fine.

Ideas where to start or what I did wrong?

Eddy

[nidesing]

Very same problem here, after upgrade from 1.7 to 2.5
Will appreciate any help

[voytekj]

I have the same problem after update 1.7.3 to 2.5.

:Table 'mydomain.g50on_user_notes' doesn't exist SQL=SELECT n.user_id, COUNT(n.id) As note_count FROM g50on_user_notes AS n WHERE n.user_id IN (73,76,66,64,74,67,75,72,68,69,71,42,65,70) AND n.state >= 0 GROUP BY n.user_id

[nidesing]

go to Extension Manager: Check Database> Fix

should help

[voytekj]

Thank,
it did help with not getting the error, but it looks like it went back to joomla 1.7.3 ( or it never updated to 2.5), and when i try to update to 2.5 it gives me 'Invalid extension update'.
I did not read about joomla 2.5 (probably i should), but is it an update? or do i have to re-install joomla to go from 1.7 to 2.5?

Thank you

[dannyb12345]

I needed to go from 1.7.3 to 2.5.

Yes, I used jupgrade to move from 1.5 to 1.7, which certainly was the reason for this problem.

I took nidesing's and did Check Database fix, and now everything works perfect, my website was moved to 2.5, my user manager works now, and I can use the one click update.

My log and temp path are also correct, I had read a post that these can still be associated with jupgrade.

Thanks!

[kheme]

First you have change folder permission to 775 for the following folders:

cache, logs, tmp & administrator/cache

then go to: configuration.php

find code:
$log_path = 'XXXXXXXXXXXXX';
$tmp_path = 'XXXXXXXXXXXXX';

and change code into:
$log_path = './logs';
$tmp_path = './tmp';

problem solved

[janhelge]

Hi,

If it still doesn't work to do the upgrade you still have two options: Download upgrade package and install it. Or use old style upgrade: FTP Filezilla works fine!

Here you can find info: http://docs.joomla.org/Upgrading_from_a ... ng_version

[snajperista]

thanks, helped me