Forum Support

Shape 5
March 29, 2024, 09:22:48 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Shape 5 Forum
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: I cant access my user manager.  (Read 1037 times)
ianpogi22
Jr. Member
**
Offline Offline

Posts: 31



« on: July 20, 2012, 05:52:56 AM »

Hi, the real estate template ( site shaper ) was on Joomla 1.7.0, I uprade my joomla to Joomla 2.5.0 and later on to 2.5.6  ,  I am having a problem accessing my User Manager.  It gave me the following error.

500 - An error has occurred.
Table 'gcmagali_msh1.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 (42) AND n.state >= 0 GROUP BY n.user_id

Please help me..

Regards,
Logged
pmiddleton
Global Moderator
*****
Offline Offline

Posts: 2097



« Reply #1 on: July 21, 2012, 10:42:03 AM »

The joomla update process sometimes has an issue with existing users in the database.

You need to access the database via phpmyadmin and follow these instructions. Bear in mind that your prefix probably isn't jos_

Back up your database first, just in case...

1. Open your Joomla database using PHPMyadmin tool.
2. Open "jos_users" table,
3. Find record with "Super User" name and click on edit icon,
4. Change Super User id value to 42 and click on "Go" button,
5. Open "jos_user_usergroup_map" table.
6. Find the record with "group_id" value 8, change "user_id" value to 42, then click on "Go" button
Logged

Paul
------------
Shape 5 Team


- Using Firebug will save you so much time, frustration and forum questions:
http://getfirebug.com/


- Need some custom coding done on your site? Use our Shape 5 Hire a Coder program for free:
http://www.shape5.com/hire_a_coder/listauctions
ianpogi22
Jr. Member
**
Offline Offline

Posts: 31



« Reply #2 on: July 22, 2012, 09:17:11 AM »

Thank you so much.  God bless.
Logged
stavguru
Jr. Member
**
Offline Offline

Posts: 2



« Reply #3 on: March 05, 2013, 05:05:06 AM »

I get this XML error: syntax error at line 1 when i try to upgrade joomla 1.7 to 2.5.x on realestate template.
Logged
mikenicoll
Global Moderator
*****
Offline Offline

Posts: 20162



WWW
« Reply #4 on: March 05, 2013, 10:57:22 PM »

Hello,

I am not sure why this would occur. Joomla Updates are handled through the Joomla Core and the Template wouldn't have any impact on this. Try using the repair database feature and clearing the cache.

-Mike
Logged

Mike Nicoll
------------
Shape 5 Team

- Need a great host for your website? We highly recommend siteground.com!


- Put your trust in the hands of our extremely qualified staff to get your job done right!


- Firebug is the most powerful web development and debugging tool, and it will save you a lot of time, frustration and forum questions:
Install Firebug
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF | SMF © 2013, Simple Machines
Joomla Bridge by JoomlaHacks.com
Valid XHTML 1.0! Valid CSS!
Looking for the largest variety in template designs? Look no more. Never buy 1 theme again. Signups start at just $89 for access to all of our themes.
Send Us An Email
Please send us your questions and we will email you back as soon as we can. Product support questions should be posted in our support forums under the Help menu. Our staff will assist you from there.