Client shows - No data available in table after migration

ninjago · December 3, 2020, 7:23pm

hello All,

I migrated white label 4.5.11 to 4.5.23.
4.5.23 is on different server brand new install and I imported all the data from 4.5.11 into new database and forced the update with /update.

When I go into client specific page ( clinets/2) i see “No data available in table” but if I run View statement it shows all the data, same is for all the invoices. I checked other clients and its the same issue.

All other functions work and I can see that all invoice and payment data is intact.

I appreciate any feedback so I can fix the issue.

hillel · December 3, 2020, 7:40pm

Hi,

Did you use mysqldump to transfer the data?

ninjago · December 3, 2020, 7:42pm

I used phpMyAdmin, export with default options

hillel · December 3, 2020, 7:43pm

I’m not familiar with it, we recommend using mysqldump

Do you see data in the activities table?

ninjago · December 3, 2020, 8:02pm

yep, table is full with data with correct client ID.

I have successfully migrated data before using phpmyadmin it just user interface to mysql.

Any other ideas where to look, assuming that data as migrated correctly. any specific files?

thanks for the help./

hillel · December 3, 2020, 8:16pm

Sorry, not sure what else to suggest

ninjago · December 3, 2020, 9:20pm

tried mysqldump and unfortunately got the same results.

Just cannot figure out what’s different from 4.5.11 to 4.5.23 to cause that isssue

ninjago · December 4, 2020, 12:33am

Hi Hillel,
I tried the following to narrow down the problem and make sure its not some sort of migration data problem.

I did brand new install of 4.4.11 and just duplicated database from working version and configured connection to it.

All is done on the same server. So database duplication was done right on the server.

When I go into new install, i am getting similar issue of data not showing, this time even invoices are not showing.

I tried the following:
I rebooted server
cleared all the cache ?clear_cache=true
new browser session

same issue.

I am trying to figure out if I am missing anything in environmental setup or some value in database.

Anything you can think off.

Thanks

hillel · December 4, 2020, 5:14am

Sorry, I’m not sure what would cause it

ninjago · December 4, 2020, 5:47pm

Thanks for sticking with me.

I tried the following. Brand new install of 4.5.23, created client and invoices. and nothing is showing up under activity, same message as before.

If I go into other tabs under client like Tasks, Invoices, Payments they all have records listed but Activity shows “No data available in table”

I checked all the logs to see if any error messages, did not find any.

Just a fact that Activity is blank on a brand new install without data migration, I think its a bug.

I am totally stumped

ninjago · December 4, 2020, 9:59pm

Sorry I am back with more information, looks like it’s a bug in SQL query.

I had debug = true on 4.5.11 and 4.5.23

loaded
/clients/2

Ran queries from both on DB, set from 4.5.11 give results but set from 4.5.23 does not

looks like main difference is in this
4.5.11 contacts.client_id = clients.id
4.5.23 contacts.id = activities.contact_id

I hope my research makes sense, thanks