Lookup table does not work when I change hosting.
Help. I have an application made in phpmaker 18 that worked perfectly, I had to change the hosting and now the lookup lists do not display on the new hosting, everything else works fine. I already checked the addresses to the new hosting and database but I can’t find the error. Please help.
You may enable debug so you can see error message from your server:
- Make sure you enable “Debug” in ewcfg*.php.
- Enable PHP display_errors in php.ini https://www.php.net/manual/en/errorfunc.configuration.php#ini.display-errors
- Enable PHP error_reporting in php.ini to display all errors (i.e. E_ALL): https://www.php.net/manual/en/errorfunc.configuration.php#ini.error-reporting
Check with your new hosting provider about how to use your own php.ini, some hosting allow you to upload your own php.ini, some ask you to set in .htaccess, it varies with hosting provider.
Also, if you change hosting provider, you change database(s), review your project and check what have changed, e.g. table/field names, connection info, Database_Connecting server events, Linked Tables, etc.
This is the code in ewcfg*.php:
define(“EW_DEBUG_ENABLED”, FALSE, TRUE); // TRUE to debug
if (EW_DEBUG_ENABLED) {
@ini_set(“display_errors”, “1”); // Display errors
error_reporting(E_ALL ^ E_NOTICE); // Report all errors except E_NOTICE
}
If you see PHP errors, that is fine, but it may not work on some servers which does not allow ini_set() or error_reporting(). It doesn’t matter which way, point is that you must see PHP errors to find out what’s wrong with the old scripts on the new server.
i also spend much time to resolve this issue. The solution is:
there must be no blank lines before and after php tags.
remove blank lines before and after <?php or ?>
shahparzsoft wrote:
i also spend much time to resolve this issue. The solution is:
there must be no blank lines before and after php tags.
remove blank lines before and after <?php or ?>
Are you saying that I should remove all blank lines in all PHP files generated in PHPMAKER?
no. just in ewcfg*.*
which FTP u r using for transfer the file ?
shahparzsoft wrote:
no. just in ewcfg*.*
which FTP u r using for transfer the file ?
FileZilla
Check if there are extra blank lines in every file u copied on web server.
It seems this issue is related to the PHP version in your hosting server. Try to use the latest PHP version, like 7.3 or 7.4 and try again.