Home     |     Java    |     Php General    |     Oracle Database    |     Oracle Server  

MS Dynamics CRM 3.0

  •  Setting up and Configuring Microsoft Dynamics CRM 3.0
  •  Managing Security and Information Access
  •  Entity Customization: Concepts and Attributes
  •  Entity Customization: Forms and Views
  •  Entity Customization: Relationships, Custom Entities, and Site Map
  •  Reporting and Analysis
  •  Workflow
  •  Server-Side SDK
  •  Client-Side SDK
  •  Integration with External Applications

    • Cervo Technologies
    The Right Source to Outsource

    Sharepoint Portal Server KB

    Microsoft CRM Info

    WPF Interview Questions

    SilverLight Interview Qs

    Asp.Net 2.0 Interview Qs

    Asp.NET 1.1 FAQs

    Oracle Interview Questions

    SAP Interview Questions

    Enterprise Resource Planning systems

    error


    I am could not get [Welcome to Administration] page after this URL:

    Instead use your browser to visit directly http://(domainname or
    localhost)/(osc root)/catalog/admin/ck-admin/index.php

    I just got error:
    //
    1146 - Table 'testerp.admin' doesn't exist

    SELECT admin_email_address as email from admin where admin_id=''

    [TEP STOP]

    //

    ???

    Regards,
    Sam.

    Hi, Samir,

     From the error message, it appears that your URL led you to access
    osCommerce's database table, instead of CK-ERP's table.

    Could you list in detail the URL you used and the configuration of your
    processing environment, ie, O/S, webserver, database engine, php and the
    version of the various software.  By the way, did you complete the
    process to install a working osCommerce + Admin Access 2.2 .

    Cheers,
    CK

    Thank you for your answer CK,

    I did finish setup osCommerce+Admin Access 2.2 (thank you for URL :)
    ).

    I use in hosting: FreeBSD; PHP Version 4.4.2; Apache/1.3.26; MySQL
    3.23.51;
    But I have now DB for osCommerce in MySQL and I creat inside this DB 3
    tables for Admin Access 2.2 but if really I do not knowe exactly:
    Do I need creat tables for CK-ERP inside this DB (osCommerce ) or
    creat new DB for CK-ERP ???
    I can succesefull open URL:

    http://mydomain.com/test4/catalog/admin/ck-admin/index.php

    and if I click to any icon I get error No: 1146;

    Regards,
    Samir

    On Mon, 01 May 2006 08:55:39 +0800
      C K Wu <c@cheerful.com> wrote:

    Hi, Samir,

    Under normal circumstances,

    http://mydomain.com/test4/catalog/admin/ck-admin/index.php

    will lead you through a process of creating CK-ERP's tables (within
    osCommerce's database) as indicated in CK-ERP's Installation Manual.  
    However, from the message you've quoted, it appears that the message is
    coming from non-CK-ERP source and most likely to be coming from
    (osCommerce + Admin Access).

    1146 - Table 'testerp.admin' doesn't exist

    testerp.admin is not a CK-ERP required table.  My suspicion is that you
    may not have completed all the required steps to set up a working
    (osCommerce + Admin Access) environment, ie not yet finished the normal
    osCommerce installation and Admin Access installation procedure.  My
    suggestion is that you test out your existing osCommerce + Admin Access
    environment (as suggested in CK-ERP's installation manual) and see if it
    is functioning properly (say,  log into osCommerce's admin menu and
    click on all the [non-CK-ERP] osCommerce menu choices).  For assistance
    to set up osCommerce + Admin Access, you would have to raise your query
    at osCommerce's forum.  I am no expert in osCommerce + Admin Access  :-(  .

    If everything is OK with osCommerce + Admin Access, you could follow on
    with (step 10-16 as listed in CK-ERP's Installation Manual).

    10. Read in detail the [Welcome to Administration] page.
    11. Pick the [Admin/Setup] choice at the top header menu.
    12. Choose action 1 - Install Test Environment
    13. Press [Start Action] button.
    14. Press [Start Action] button again.
    15. Numerous descriptive messages will appear.
    16. Press any one of the [Done] buttons.

    Cheers,
    CK

    Thanks CK,

    I check and I think osCommerce+Admin Access are OK.
    But when I am doing steps 10-16 as listed in CK-ERP's Installation
    Manual I was getting error like that:

    //
    1044 - Access denied for user: 'otR705z01Y@localhost' to database
    'testerp'

    CREATE TABLE ck_md5 (id int unsigned PRIMARY KEY auto_increment,app
    text,script text,version text,checksum text)
    //

    Is it osCommerece error or CK-ERP error?
    And from which file in CK-ERP I can try to change user and passwd for
    access to DB?

    Thanks and Regards,
    Sam

    On Thu, 04 May 2006 09:48:38 +0800
      C K Wu <c@cheerful.com> wrote:

    Hi, Samir,

    Presumably, testerp is the name of your osCommerce database.  If this is
    true and,

    1044 - Access denied for user: 'otR705z01Y@localhost' to database
    'testerp'

    That means you have not set up correctly your osCommerce database
    accessing mechanism via osCommerce's installation process.  You should
    go back and check if your have installed osCommerce correctly.  Once,
    osCommerce + Admin Access is setup correctly, CK-ERP will access
    osCommerce's database according to osCommerce's convention.

    Cheers,
    CK

    Hi Samir,

    Btw, if you intend to run CK-ERP within a ru language environment, you
    may like to take note of a platform specific note listed in,

    http://ck-erp.net/ckerp/sitemgr/sitemgr-site/?page_name=Platform

    FreeBSD :

    in some older FreeBSDs or tailored distributions, the embedded php is
    compiled without iconv support or the supported iconv function is
    alternatively named as libiconv(). So, if you are planning to install
    CK-ERP within a FreeBSD environment, you may like to check thru the
    phpinfo() listing to ensure presence of iconv() support.

    Cheers,
    CK

    Thank you CK,
    But may I just dump CK-ERP sql  tables via phpMyAdmin into 'testerp'
    DB and after that may be it will work.
     From wheare I can get sql tables file?

    I just want to check this way.

    Regards,
    Sam
    On Thu, 04 May 2006 14:24:39 +0800
      C K Wu <c@cheerful.com> wrote:

    Hi, Samir,

    I am afraid it would not work.  To allow seamless operation, CK-ERP
    always works through the middleware's database layer.  That goes for all
    the nine middlewares within which CK-ERP  is able to operate.  If you
    can't operate CK-ERP within the normal processing environment, I think
    you shouldn't spend any further time on CK-ERP, there are many other
    open source ERP software to choose from and try out.

    Cheers,
    CK

    Hi CK,

    I am sorry I found in which files was wrong in osCommerece it was in
    config:

    http://mydomain.com/test4/catalog/admin/includes/

    in file:
    configure.php

    in line 40 and 41:
    //
       define('DB_SERVER_USERNAME', 'name');
       define('DB_SERVER_PASSWORD', 'passwd');
    //

    I added correct info and did steps 10-16. =)
    Is it mean now I can start to use CK-ERP or I need to do something
    more?

    Rgards,
    Sam

    On Thu, 04 May 2006 14:24:39 +0800
      C K Wu <c@cheerful.com> wrote:

    Hello CK,

    Do you have manual or something where is instruction how to use
    installed  'CK-ERP'  for starting learning?

    Regards,
    Sam
    On Thu, 04 May 2006 16:17:11 +0800
      C K Wu <c@cheerful.com> wrote:

    Hi, Samir,

    I am no expert of osCommerce.  However, I would advise against just
    updating configure.php.  As far as my experience with osCommerce goes,
    the installation process would ask for the database server name,
    database name, password etc, etc, etc.....  As IT people, we know that
    osCommerce's installation process could then use these information to
    update configure.php, store it in a temporary secondary database
    (table), store it in ldap, or even as the name of a dummy folder, and
    what not.  The installation process could then do a whole host of other
    things to setup the required working osCommerce environment.   I just
    don't know whether the single manual action of updating configure.php is
    comprehensive enough, and whether the subsequent combination of
    osCommerce + Admin_Access + CK-ERP will work or not because I have not
    tested that mode of setting up CK-ERP myself.  My best advice is still
    to work through the normal installation process of osCommerce +
    Admin_Access, otherwise I must say I don't know.

    Cheers,
    CK

    Hi, Samir,

    I am afraid the CK-ERP installation manual is the only manual
    available.  CK-ERP is designed so experienced accountants could test
    drive the system without referring to any manual.  If you are unable to
    test drive CK-ERP without additional manual or instruction, I am afraid,

    a)  you are not one of CK-ERP's target user

    or

    b)  CK-ERP is not your target ERP software

    Please, refer to,  
    http://ck-erp.net/ckerp/sitemgr/sitemgr-site/?page_name=Principles
    and also the wording that appears on the index page of every CK-ERP module.

    *"Do not expect any help nor assistance on this module from anyone."
    *

    Cheers,
    CK

    Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc