Query problems

  • Anonymous - 2010-09-07

    Running 1.99.2 on a hosted server.
    Getting this error 6 times at the top of the page.  I still get the data, but it is very annoying:
    Unable to execute your query. Please correct this error.
    You may need to update your database structure.
    You have an error in your SQL syntax near 'ON companies.company_id=former_company_id WHERE contact_id=1 order by companycha' at line 1
    I tried to execute:
    SELECT CONCAT('<a href=\"http://************.com/xrms/companies/one.php?company_id=',former_company_id,'">',company_name,'</a>') as LINK, companychange_at FROM contact_former_companies JOIN companies ON companies.company_id=former_company_id WHERE contact_id=1 order by companychange_at desc
    Unable to execute your query. Please correct this error.

    Any ideas?

  • 360team.ca

    360team.ca - 2010-09-08

    Hosted server as in 'shared hosting'?  That is NOT RECOMMENDED for security reasons as well as because hosting companies tend to customize their environments to their own needs and those customizations may affect how XRMS runs - you may end up on a long and fruitless goose chase trying to figure out what the problem is exactly.

    If  you are certain that all of XRMS's prerequisites have been met and you have installed successfully without any suspicious errors or warnings, please post complete information on your environment and where/how you get this error.  On which page, after selecting what, etc.

    Did you download the stable XRMS version or are you installing from CVS?   Both are tagged with the same version number for the time being.



Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks