Localhost to Online

[VK2OZI]

I have moved my Cloudlog from my localhost to an online server and have got the following error.

A Database Error Occurred

Error Number: 1146

Table 'tszhfkad_cloudlog.TABLE_HRD_CONTACTS_V01' doesn't exist

SELECT COUNT( * ) as count FROM TABLE_HRD_CONTACTS_V01 WHERE station_id = 1 AND COL_TIME_ON between '2021-04-09 00:00:00' AND '2021-04-09 23:59:59'

Filename: models/Logbook_model.php

Line Number: 984

Is anyone able to help?

[AndreasK79]

It seems to me that your database name is not the same. Did you change the config for the database in config/database.php?

[VK2OZI]

All parameters are correct, checked more than once. Not sure whats going on.

[AndreasK79]

Ok, and the table does exist in the online server?

[VK2OZI]

Yes, the same as it does in my XAMPP server locally

[VK2OZI]

I zipped and dumped the files, exported the SQL dumped it and changed DB name etc

[AndreasK79]

I managed to reproduce it locally here when I renamed the table. I got exactly the same error message. When Cloudlog can't find the logbook table in the database, it gives the error you described.

[VK2OZI]

[VK2OZI]

for some reason when you dump the database on the live server the table HRD Contacts isn't in caps so you have to change in config to match. works now.