#87 Error

closed
360team.ca
None
5
2011-04-05
2011-03-24
Bidbud
No

Hi I have tried to re-install XRMS CRM on our new linux account. I configured the include and vars files and imported my database but it still gives me the following error :

Catchable fatal error: Object of class ADODB_mysql could not be converted to string in /home/goblueco/public_html/crm/include/utils-misc.php on line 1752

Please could you advise what could be wrong and how I go about re-installing CRM

Thanks
Steven

Discussion

  • 360team.ca
    360team.ca
    2011-03-24

    Hi, Steven!

    What do you mean by imported your database? Which script is causing the fatal error? What is your environment?

    Cheers,
    Ivaylo

     
  • 360team.ca
    360team.ca
    2011-03-24

    More questions...

    Did you get any warnings before the fatal error? What is your error reporting level set at?

    Cheers,
    Ivaylo

     
  • Bidbud
    Bidbud
    2011-03-24

    Hi Ivaylo

    Thanks for the response.

    I tried to import my database that I backed up using myphpadmin. I am now on a linux server through my ISP, was on windows. I then run the install and it gave me that error.

    XRMS is causing the error but not sure about error levels etc

     
  • 360team.ca
    360team.ca
    2011-03-24

    Hi, Steve!

    If you executed the SQL file that was generated by the phpMyAdmin dump, you do not need to run the installation. Running the installation at that point will end up whipping out tons of warnings about tables that already exist in the database because the install script is trying to create the tables that the SQL already has created for you.

    I hope this helps.

    Cheers,
    Ivaylo

     
  • Bidbud
    Bidbud
    2011-03-25

    Hi Ivaylo

    Thanks for that. I have tried deleting the database and creating a fresh database then copying all the installation files across, I then setup include-locations and vars with the paths, by the way the path on windows was c:/..... etc but my ISP for linux says it is now /home/gobl........ etc would this make a difference.

    Then when I run the install with either a clean database or other it gives me :

    Catchable fatal error: Object of class ADODB_mysql could not be converted to string in /home/goblueco/public_html/crm/include/utils-misc.php on line 1752

     
  • 360team.ca
    360team.ca
    2011-04-01

    Hi, Steven!

    Please review this thread and answer all the questions that I asked with full, precise answers. I am very bad at "filling in the blanks".

    Cheers,
    Ivaylo

     
  • Bidbud
    Bidbud
    2011-04-01

    Hi Ivaylo

    Thanks I looked through the thread and the questions I found are :

    Did you get any warnings before the fatal error? What is your error
    reporting level set at?

    I didnt see or cannot remember any errors before the fatal error. Also how do I check the reporting level, not sure how to check it ?

    I did a clean install with a clean database yet it still happens.

    Thanks
    Steven

     
  • 360team.ca
    360team.ca
    2011-04-01

    You missed the question...

    What is your environment? (full description with versions) Frankly, I don't even know which version of XRMS you are trying to install!

    99.9% of the time these issues are rooted in the configuration of your environment. Please scour the forums for answers as well. Free support means that you have to do your part, too.

    As for the error reporting levels, please Google it. This is a general PHP question.

    Cheers,
    Ivaylo

     
  • Bidbud
    Bidbud
    2011-04-01

    Hi Ivaylo

    I looked in the forums and someone had the exact same question but there was no answer either.

    Please find my details below :
    Hosting package gstandard
    Server Name my-server7
    cPanel Version 11.28.87
    Theme x3
    Apache version 2.2.17
    PHP version 5.2.14
    MySQL version 5.0.92-community
    Architecture x86_64
    Operating system linux

    I am trying to install the version I found on this site ie : 2006-04-26-v1.99.1

    I will try check my reporting levels.

    Thanks
    Steven

     
  • 360team.ca
    360team.ca
    2011-04-01

    Hi, Steven!

    At least try to install the latest XRMS stable version which is 1.99.2. I don't even know what the issues with 1.99.1 were (I wasn't even around at that time) but I can tell you that 1.99.2 works well on PHP versions lower than 5.3.

    Also make sure that you have PEAR and, if you are using languages other than English, gettext installed.

    I hope that helps.

    Cheers,
    Ivaylo

     
  • Bidbud
    Bidbud
    2011-04-01

    Hi Ivaylo

    That is probably what the problem is thanks.

    Where do I get the latest version as Sourceforge only seems to have 1.99.1

    Thanks
    Steven

     
  • Bidbud
    Bidbud
    2011-04-01

    Hi thanks I found .2 but its not on the main XRMS page

    Will try it now.

    Kind regards
    Steven

     
  • Bidbud
    Bidbud
    2011-04-01

    Hi Ivaylo

    Good news the new version does work on my system.

    Installation is fine and then there are the errors displayed that the database structure needs to be updated which when I click on it does update and the errors dissappear.

    I have restored my backup data created with v1.

    The problem now is that when I login as an administrator I do not see the Administration menu and also there is no data shown.

    The only menu items shown are Home and Preferences.

    I will look in the forums but please let me know what could be the problem.

    Thanks
    Steven

     
  • 360team.ca
    360team.ca
    2011-04-01

    Hi, Steven!

    Did you import the data that you created with v1.99.1 after you updated the database? As far as I recall the role permission system was changed between 1.99.1 and 1.99.2 which would explain why you don't see any menus either.

    Run the upgrade again on the imported data. That will hopefully do the trick. The upgrade is non-destructive to the data but you best make sure you have a backup copy of your data first, just in case Tron is not on our side today.

    Let me know how it goes.

    Cheers,
    Ivaylo

     
  • Bidbud
    Bidbud
    2011-04-02

    Hi Ivaylo

    I import the v1.99.1 data after I have updated the database and have re-run the upgrade but still with errors, these can be fixed by updating the structure again but still no admin permissions.

    It seems the following tables have been removed in the new version
    Controlledobject
    controlledobjectrelationship
    groups
    groupuser
    permission
    role
    rolepermission

    and now with the v1.99.1 data and these tables removed the program is not able to determine who is an admin and to give them proper roles !

    Do you know maybe which tables I can manually add/edit data to give one of the users admin rights to see the menu etc.

    Thanks
    Steven

     
  • 360team.ca
    360team.ca
    2011-04-02

    Hi, Steven!

    I am going to ask you a favour - we need to move this whole issue to the forums. I have no idea why an open source project has a support tracker to begin with - it is how it was setup before I was here but I will probably close this channel down altogether. The forums are the best way to seek support for two reasons:

    1. You can get answers from the whole community who may have experienced a similar issue in the past and not just the developers who are usually the only ones to keep an eye on a tracker. Developer time has a high opportunity cost for the entire project.
    2. The answers may help someone in the future as well.

    OK, a few things:
    1. The fact that you upgraded the database BEFORE you imported the v1.99.1 data does nothing. Your import most probably starts with dropping all tables which means the update is wiped out before the 1.99.1 data is populated in the database
    2. Running an update a second time will not help you. XRMS assumes that the update has gone well the first time and has marked your database as updated. If you run the update script a second time, once it sees that the database has been updated (it marked it so the first time, regardless of the errors), it does not bother to actually go through the update process the second time. Silly, I know, but that is how it was written and I haven't had a chance to look at that yet.
    4. The error messages you receive during the update are our best lead at the moment.

    Please search the forums for "upgrade 1.99.1" or "upgrade 1.99.2" again. If you don't find an answer, then let's try this:

    1. Leave your 1.99.2 code as-is (you have already updated it, that is fine).
    2. Drop all tables in the XRMS database (you have a backup, right?).
    3. Import the data you created with 1.99.1
    4. Check to see if the XRMS database user has CREATE and ALTER privileges on the database tables.
    4. Run the database update
    5. Start a thread in the Help Forums on upgrading from 1.99.1 to 1.99.2
    6. Post the error messages (please, copy and paste) you got during the upgrade - that should help in narrowing down the issue.
    7. We continue this discussion in the forums :)

    Cheers,
    Ivaylo

     
  • Bidbud
    Bidbud
    2011-04-02

    Hi Ivaylo

    Thanks for taking the time to go through this with me,

    I will check the forums and post there but I assume the only way to sort this is to go back to the Windows Server using v1 and then export the data using XRMS not phpMyAdmin then installing v2 on the Linux server and using the XRMS import to get the companies back in etc whilst ignoring the other tables like roles etc.

    Will meet in the forums if that doesnt work either.

    Kind regards
    Steven

     
  • 360team.ca
    360team.ca
    2011-04-02

    Hi, Steven!

    The export/import approach will not transfer all data. You can export/import companies and contacts but not the activities, opportunities, etc. Not to mention that I don't know how well that will work across different versions (probably not well at all).

    Even if you don't find anything in the forums, the steps I outlined in my previous comment are probably a better bet. The tables you listed earlier:

    Controlledobject
    controlledobjectrelationship
    groups
    groupuser
    permission
    role
    rolepermission

    have NOT been dropped in 1.99.2. Assuming that you did not ignore capital letters and you typed them properly when you listed them, they may have been renamed but they should definitely be there.

    Finally, the update should NOT generate ANY errors. That is why I suspect the issue is with the XRMS database user not having CREATE or ALTER permissions in order to upgrade the data. If you want to keep things simple, grant the XRMS database user ALL privileges during the upgrade, then tighten the permissions again after - there is a list of what they should be in either the INSTALL or README.

    I know that you may be frustrated but please trust the process I am proposing.

    Cheers,
    Ivaylo

     
  • Bidbud
    Bidbud
    2011-04-02

    Hi Ivaylo

    Thanks again for the speedy response.

    I have finally done it. This is how :

    1) Install the new version as normal with sample data
    2) Login as User1
    3) Empty all the tables where the data sits. Dont have to empty countries etc unless they have changed
    4) Alter the SQL import file so that only the empty tables will be inserted thus the other tables will remain the same
    5) Change the administrator and you should be done.

    So far no issues and all activities etc are there but will keep checking.

    Kind regards
    Steven

     
  • 360team.ca
    360team.ca
    2011-04-05

    Hi, Steven!

    If you are happy with that solution, go for it, but I would strongly recommend that you ensure that you can run database updates or else you may run into upgrading problems in the future and at that point the sunk costs of the data residing in your database will be much higher.

    Cheers,
    Ivaylo

     
  • 360team.ca
    360team.ca
    2011-04-05

    • assigned_to: nobody --> gopherit
    • status: open --> closed