For a client, we moved a MySQL DB from a local web server to separate MySQL server (they have internal reasons for this move).
We’ve made the appropriate change to database.php, configured the stand alone Linux MySQL server accordingly (remote access, accounts etc).
We are getting this error when we launch the site:
An exception occurred while executing ‘SELECT t0.pkgID AS pkgID_1, t0.pkgHandle AS pkgHandle_2,
t0.pkgVersion AS pkgVersion_3,
t0.pkgIsInstalled AS pkgIsInstalled_4, t0.pkgAvailableVersion AS pkgAvailableVersion_5,
t0.pkgDescription AS pkgDescription_6, t0.pkgDateInstalled AS pkgDateInstalled_7,
t0.pkgName AS pkgName_8 FROM Packages t0 WHERE t0.pkgIsInstalled = ? ORDER BY t0.pkgID ASC’ with params [1]:
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘duraflex.Packages’ doesn’t exist
We know the MySQL box is fine and works because we can connect, login and then we get above error. We’ve used mysqldump and phpmyadmin to dump and load the database on the new server. No errors at all.
To eliminate any of our setup, we created a new db “Dummy” and installed Elemental on the local web server pointing it to the remote MySQL server. Works like a charm. We then installed the same packages on the “test elemental site”. Again, no errors.
We ran quite a few queries and all the data is intact as compared the results of the same queries on the original box.
I think we have an issue with Localhost (127.0.0.1) as this information is in the environment area of the exception:
| REMOTE_USER | |
|---|---|
| REMOTE_PORT | 61402 |
| REMOTE_HOST | 127.0.0.1 |
| REMOTE_ADDR | 127.0.0.1 |
| QUERY_STRING | |
| LOGON_USER | |
| LOCAL_ADDR | 127.0.0.1 |
We found several files with the ip address of 127.0.0.1 so we changed it to the ip of the actual MySQL server, same error. We changed the ip back to the original.
We would appreciate if anyone have any thoughts/ideas?