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

Query problems

Help
Anonymous
2010-09-07
2013-04-26

  • 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.

    Thanks,
    Ivaylo