Upgrade from 7.0.1 to 7.0.2 -> no data in search

After upgrading from 7.0.1 to 7.0.2 (without errors…), the data seems to be intact, but the search (global search, search for contacts, leads, calls) leads to an empty result.

Rebuild and so on with no success…

Does annyone have any idea?

Reagards, Andreas

Hi Andreas,

Have you checked your sugarcrm.log for errors?

Thanks,

Will.

Yes:

Fri Jan 24 15:31:18 2014 [4438][6f0f0f38-9582-c34f-5d4d-524e6c9571fc][DEPRECATED] Using row number in fetchByAssoc is not portable and no longer supported. Please fix your code.
Fri Jan 24 15:32:24 2014 [4975][6f0f0f38-9582-c34f-5d4d-524e6c9571fc][ERROR] Unable to find relationship projects_contacts_resources
Fri Jan 24 15:32:24 2014 [4975][6f0f0f38-9582-c34f-5d4d-524e6c9571fc][FATAL] project_resource for projects_contacts_resources failed to load

The

[DEPRECATED] Using row number in fetchByAssoc is not portable and no longer supported. Please fix your code.

line can be found many times…

There are many custom fields in SuiteCRM, maybe it´s related to them?

Kind regards, Andreas

To start, if you have not already try this:

From admin go to repair and try a quick repair and rebuild. See if that fixes your issue

Then try rebuild relationships if that doesn’t work.

Chad

1 Like

“rebuild relationships” was the right hint -> Thanks a lot, working now @7.0.2

Regards, Michael

Too early…works only for myself in “contacts” (not in “leads”), but not for other useres.

Still error in log

Mon Jan 27 16:24:30 2014 [23399][1][DEPRECATED] Using row number in fetchByAssoc is not portable and no longer supported. Please fix your code.
Mon Jan 27 16:24:34 2014 [7196][6f0f0f38-9582-c34f-5d4d-524e6c9571fc][DEPRECATED] Using row number in fetchByAssoc is not portable and no longer supported. Please fix your code.

Hmmm, any other idea?

Regards, Michael

That is not really an error it is more a warning… can you check your error log on the website and not the CRM log?

Also Check any custom associations you might have in Leads through the Studio… you may have to just save the association again or remove and read ad it.

Chad

Hi Andreas,

Have you turned off error reporting in your php.ini?

Thanks,

Will.

Hm, hi Chad, hi Will,

I did everything you mentioned. In the end I did an uploaf of the FULL 7.0.2 package and everything (fully tested, I sware) is fine know.

Maybe a transmission problem from my FTP client…

Thanks for your help, happy now,
Andreas

[solved]

phew glad it is working… I was about to start digging into my hat of magic tricks… :wink: