Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#43 Reorder FCOM fact

closed-fixed
nobody
None
5
2008-08-30
2008-02-23
Im
No

Hi,

I found something on the indi's page. Small thing...

The order of some fact's are may not be correct.

There is a fact FCOM witch ends up after CONF if FCOM has no date.
Now, first comes always FCOM w/wo date than CONF.

Thanks,
-Im

Discussion

1 2 > >> (Page 1 of 2)
    • status: open --> open-fixed
     
  • Logged In: YES
    user_id=816380
    Originator: NO

    This was caused by the limitations of the sort functions in PHP, but now it is fixed in the latest CVS.

    Boudewijn

     
    • status: open-fixed --> pending-fixed
     
  • Im
    Im
    2008-08-09

    • status: pending-fixed --> open-fixed
     
  • Im
    Im
    2008-08-09

    Logged In: YES
    user_id=1262354
    Originator: YES

    Hi Boudewijn,

    Sorry for my late replies! I just got back from my vacation.
    So, now I'm back and ready for your questions :)

    I have just downloaded the latest version and have this for errors:
    Parse error: syntax error, unexpected T_SL in \config.php on line 2

    After I comment this line (<<<<<<< config.php) the next error is:
    Parse error: syntax error, unexpected T_IS_IDENTICAL in \config.php on line 19

    Commenting out this line (=======) gives the next error:
    Parse error: syntax error, unexpected T_REQUIRE_ONCE in config.php on line 50
    This is the line: require_once("includes/session.php");

    I suppose I should also comment this line: >>>>>>> 1.10

    I cant get passed the require_once function. Donno why...
    Any ideas?

    Regards,
    -Im

     
  • Im
    Im
    2008-08-09

    Logged In: YES
    user_id=1262354
    Originator: YES

    Update:

    I found "require_once("includes/session.php");" twice in the config file.
    So, I commented out one of them and now I can get passed this error.

    But I have now a new error:
    Fatal error encountered: Database cannot be reached.

    Error information: Query-> Error occured: Access denied for user 'ODBC'@'localhost' (using password: NO)
    Query: SELECT * FROM gm_sysconf WHERE 1
    Genmod is terminating.

    This is something new....

    Hmmm, gm_sysconf table? I don't have that. Should I reinstall genmod?
    Please, advice.

    Regards,
    -Im

     
  • Logged In: YES
    user_id=816380
    Originator: NO

    Hi Im,

    Hmmm funny that the absence of that table prevents you to startup Genmod....
    As a workaround you could comment out session.php line around 347: $SystemConfig = new SystemConfig();
    After login the table will be created and the line can be commented out again.
    If you still experience problems, please let me know.

    Regards,
    Boudewijn.

     
  • Logged In: YES
    user_id=816380
    Originator: NO

    Btw that missing table cannot be the cause of termination of Genmod. Please check your DB name, username and password in your config.php file. I suspect the problem is either in those credentials, or in the config.php file.

     
  • Im
    Im
    2008-08-09

    Logged In: YES
    user_id=1262354
    Originator: YES

    Commenting out the line you suggested gives this error:
    Fatal error encountered: Database cannot be reached.

    Error information: Query-> Error occured: Access denied for user 'ODBC'@'localhost' (using password: NO)
    Query: SELECT * FROM gm_lockout WHERE lo_ip='127.0.0.1'
    Genmod is terminating.

    I have gm_lockout table and it's fields, but the fields are empty, so '127.0.0.1' is not found.
    I wonder why 127.0.0.1 and not localhost. The genmod installation is configured for localhost.
    I changed the addresses in the config file from localhost to 127.0.0.1, but makes no differences.

    This installation worked with this configuration before. The config file is ok, just double checked it.
    The gm_sysconf table is still not created.

    I think I will try to reinstall everything, from scratch and see if that works.

    During installation, step 3:
    Successfully created Actions table.
    Table created Successfully created Blocks table.
    Table created Successfully created Changes table.
    Table created Successfully created Counters table.
    Table created Successfully created Dates table.
    Table created Successfully created Eventcache table.
    Table created Successfully created Facts table.
    Table created Successfully created Families table.
    Table created Successfully created Favorites table.
    Table created Successfully created Gedcoms table.
    Table created Successfully created Gedcom configuration table.
    Table created
    Table created Successfully created Individuals table.
    Table created Successfully created Language Settings table.
    Table created Successfully created Language table.
    Table created Successfully created Language Help table.
    Table created Successfully created Lockout table.
    Table created Successfully created Log table.
    Table created Successfully created Media table.
    Table created Successfully created Media Data Files table.
    Table created Successfully created Media Files table.
    Table created Successfully created Media mappings table.
    Table created Successfully created Media Thumb Files table.
    Table created Successfully created Messages table.
    Table created Successfully created Names table.
    Table created Successfully created News table.
    Table created Successfully created Other table.
    Table created Successfully created Pages table.
    Table created Successfully created Place links table.
    Table created Successfully created Places table.
    Table created Successfully created Gedcom privacy table.
    Table created Successfully created Source mappings table.
    Table created Successfully created Sources table.
    Table created Successfully created Statisticscache table.
    Table created
    Table created Successfully created Users table.
    Table created Successfully created Users_gedcoms table.

    There are some tables created, but no "Successfully...." followed. I donno if this is a problem.

    Step 4:
    User name = (empty)
    Last name = "admin"

    These two could be switched...
    And the password text box is set? To what?

    Step 6:
    Could not add language help string "menu_help";"Help" for language English to table
    Language import OK Language English imported succesfully.
    Language import NOK Help English imported failed.
    Language import OK Facts English imported succesfully.

    After the install, go to start page of genmod:
    Fatal error encountered: Database cannot be reached.

    Error information: Query-> Error occured: Access denied for user 'ODBC'@'localhost' (using password: NO)
    Query: SELECT * FROM gm_sysconf WHERE 1
    Genmod is terminating.

    Strange, Genmod doesn't like anymore when the password is empty. The log file says:
    GmErrorHandler-> ERROR 2: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'genmod'@'localhost' (using password: YES)
    Error occurred on line 39 of file mysqldb.php
    Using URL: /cvs/genmod/index.php?

    Added a DB passwd for a new user "genmod" and the ged file import is a success.

    Going to "My Account"
    The text box for "GEDCOM INDI record ID" is absence.

    So... going to Admin -> User Administration -> Editing the user (admin)
    The text box for "GEDCOM INDI record ID" is present and now set - > and "Update User Account". I got this error:

    ERROR 8: Undefined variable: username
    ERROR 8: Undefined variable: username
    Error occurred on line 430 of file useradmin.php
    Using URL: /cvs/genmod/useradmin.php?action=edituser2&filter=&namefilter=&sort=&ged=&usrlang=&oldusername=admin&uusername=admin&ufirstname=Im&ulastname=Sza&pass1=genmod&pass2=&emailadress=imsza@users.sourceforge.net&verified=yes&verified_by_admin=yes&user_language=english&user_theme=&new_contact_method=messaging2&visibleonline=yes&editaccount=yes&new_default_tab=0&new_comment=&new_comment_exp=&gedcomid_Family_ged=I2&rootid_Family_ged=I2
    0 Error occurred on line 430 of file useradmin.php

    User does not exist.

    Any questions? Is this informational?

    But anyway, the FCOM and CONF is working great.
    Thank you

    -Im

     
  • Logged In: YES
    user_id=816380
    Originator: NO

    Hi Im,

    Thanks for your extended report, it's very informational and helpful.

    I already suspected that commenting out wouldn't help.
    Still think the database connection was the bad guy here, as it seemed to fix most problems.

    Step 3: I fixed the empty "Succesfully" lines, the text was not added yet.

    Step 4: you mean that entering an empty username should be checked?

    Step 6: What do you mean with empty password? The DB pass? It would be odd if that worked in the past,
    as Genmod MUST have a value for user and dbname and password. The check on those not being empty has been in mysqldb.php for ages:

    if (empty($DBUSER) || empty($DBPASS) || empty($DBNAME) || empty($DBHOST)) return false;

    Gedcom indi missing: this is by design, as the admin must set this value, not the user himself. The user can only set his starting ID for the various charts.

    About the errors on user edit: I think I fixed the error message, but I can't figure out why Genmod couldn't find the user. The error is persistent?

    Will fix the step 6 language import error later.

    Best regards,
    Boudewijn

     
1 2 > >> (Page 1 of 2)