Results 1 to 5 of 5

Thread: userdb_can_edit_blog error adding new user

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    May 2009
    Posts
    4

    Smile userdb_can_edit_blog error adding new user

    OK, so here's the scenario:

    Running O-R version 2.5.8, upgraded from previous version.
    Tried to add a new user, entered all the necessary details.
    Hit the add user button, and page goes to "Page cannot be found"
    Few second later, an email hits my mailbox with:

    Crashed by User at IP --> xx.254.84.13 ON December 15, 2009, 3:46:10 pm

    SQL Error Message: Field 'userdb_can_edit_blog' doesn't have a default value SQL statement that failed below:
    ---------------------------------------------------------
    INSERT INTO default_en_userdb (userdb_user_name, userdb_user_password,userdb_user_first_name ,userdb_user_last_name, userdb_emailAddress,
    userdb_creation_date,userdb_last_modified,userdb_a ctive,userdb_is_agent,userdb_is_admin,userdb_can_e dit_member_template,
    userdb_can_edit_agent_template,userdb_can_edit_lis ting_template,userdb_can_feature_listings,userdb_c an_view_logs,
    userdb_can_moderate,userdb_can_edit_pages,userdb_c an_have_vtours,userdb_can_have_files,userdb_can_ha ve_user_files,userdb_limit_listings,userdb_comment s,userdb_hit_count,
    userdb_can_edit_expiration,userdb_can_export_listi ngs,userdb_can_edit_all_users,userdb_can_edit_all_ listings,userdb_can_edit_site_config,userdb_can_ed it_property_classes,userdb_can_manage_addons,userd b_rank,userdb_featuredlistinglimit) VALUES
    ('username','1190','User','Name','username@domainn ame.com','2009-12-15','2009-12-15 15:46:10','yes','yes','no','no','no','no','no','no ','no','no','no','no','no','-1','',0,'no','no','no','no','no','no','no','0','-1')


    That's when I notice that, when addind new user, there is no option to set a Blog Related field.

    Have we got a fix for this? Thanks!

    Anthony

  2. #2
    the_sandking's Avatar
    the_sandking is offline hadron remnant - Moderation Fachmann
    Join Date
    Apr 2003
    Location
    Nullspace
    Posts
    5,289

    Default Re: userdb_can_edit_blog error adding new user

    That error would seem to indicate that you did not update the OR DB when you updated OR.

    OR installation docs:
    http://docs.google.com/View?id=dhk2c..._4993501130609

    Check the UPGRADING OPEN-REALTY section and make sure you only choose 'upgrade from OR 2.x' when re-running the installer.

    If you run the SQL query that is failing through whatever you use to manage you databases, you will receive the exact cause of the problem with that query.

    "Much of what looks like rudeness in hacker circles is not intended to give offense. Rather, it's the product of the direct, cut-through-the-BS communications style that is natural to people who are more concerned about solving problems than making others feel warm and fuzzy."

    "We gotta' go to the crappy town where I'm a hero!"
    -Hoban 'Wash' Washburne 2485-2519


    "When you’re born you get a ticket to the freak show. When you’re born in America, you get a front-row seat.."
    -George Carlin 1937-2008

    New to Open-Realty® and need help? Check the:
    -OR DOCUMENTATION -

    Important: Read this at least once in your lifetime
    How To Ask Questions The Smart Way

  3. #3
    Join Date
    Jul 2005
    Location
    Sao Paulo, BRAZIL
    Posts
    3,763

    Default Re: userdb_can_edit_blog error adding new user

    Quote Originally Posted by AMizzi View Post
    Running O-R version 2.5.8, upgraded from previous version.
    I went after it and found out it is a Bug at Open-Realty.

    The error will only occur when a user upgrade from v.2.5.6 or older - upgrading from v.2.5.7 the error will not occur.

    More, the standalone v.2.5.8 install file package is not creating the column "userdb_can_edit_blog" at userdb table. So we may face others users with problems related to this issue (I am not sure if we are really using this column).

    Once the Bug Tracker is offline for users, I will be opening a new ticket at the new Bug Tracker online only for O-R Devs.

    [EDITED]Bug Reported: Case #67 created at FogBugz[/EDITED]

    Eduardo
    Last edited by ebmarques; 12-15-2009 at 01:59 PM. Reason: Bug Reported

    Open-Realty® DOCs
    We can easily forgive a child who is afraid of the dark; the real tragedy of life is when men are afraid of the light. (Author Unknown)

  4. #4
    Join Date
    Jan 2009
    Posts
    1

    Default Re: userdb_can_edit_blog error adding new user

    i have same problem, Have we got a fix for this? Thanks!

  5. #5
    the_sandking's Avatar
    the_sandking is offline hadron remnant - Moderation Fachmann
    Join Date
    Apr 2003
    Location
    Nullspace
    Posts
    5,289

    Default Re: userdb_can_edit_blog error adding new user

    OR v2 is no longer being developed, and no new bug fixes for OR v2 have been released since 2009.

    The fix is to upgrade to OR v3.
    "Much of what looks like rudeness in hacker circles is not intended to give offense. Rather, it's the product of the direct, cut-through-the-BS communications style that is natural to people who are more concerned about solving problems than making others feel warm and fuzzy."

    "We gotta' go to the crappy town where I'm a hero!"
    -Hoban 'Wash' Washburne 2485-2519


    "When you’re born you get a ticket to the freak show. When you’re born in America, you get a front-row seat.."
    -George Carlin 1937-2008

    New to Open-Realty® and need help? Check the:
    -OR DOCUMENTATION -

    Important: Read this at least once in your lifetime
    How To Ask Questions The Smart Way

Similar Threads

  1. adding another user type?
    By subodh in forum Addon help, ideas and discussion (CLOSED)
    Replies: 5
    Last Post: 09-01-2008, 06:13 AM
  2. adding form field to user sign up
    By lukeroyffe in forum Installation/Configuration Help (CLOSED)
    Replies: 7
    Last Post: 04-05-2007, 03:45 PM
  3. Adding Listing, Selecting own User?
    By vegterb in forum HELP (CLOSED)
    Replies: 4
    Last Post: 06-07-2004, 06:33 AM
  4. Error adding User -New Install - FIXED 1.1.3
    By DocRock in forum HELP (CLOSED)
    Replies: 1
    Last Post: 08-17-2003, 08:09 AM
  5. Error on adding user
    By Anonymous in forum HELP (CLOSED)
    Replies: 1
    Last Post: 06-25-2003, 06:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •