\n
\n
![\"\"](\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2018\/03\/scr_clear_browsing_data.png\"){kind=spacer}
<\/p>\n<\/li>\nYou done all this and nothing helps. Time to dig a bit deeper. <\/p>\n
There is an error message<\/h2>\n
You see an error message on the page. This is good, it gives us something to work with. As a first step Google the error message. You will be surprised how often searching for an error message points you in the right direction. <\/p>\n
Here is an example:<\/p>\n
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='<\/pre>\nSearching for this error message points us to this article on Stackoverflow<\/a>. The best answer offers a few options to fix this issue, but option four is the easiest one. Altering all database tables to use the same collation is an easy fix and requires no changes in the code.<\/p>\n
Another error message you nay encounter. <\/p>\n
\r\nFatal error: Uncaught Error: Class 'ZipArchive' not found in \/home\/groupe\/public_html\/dynaco\/plugins\/PHPExcel\/Writer\/Excel2007.php:226 \r\nStack trace: \r\n#0 \/home\/groupe\/public_html\/dynaco\/include\/export_functions_excel.php(164): PHPExcel_Writer_Excel2007->save('\/home\/groupe\/pu...') \r\n#1 \/home\/groupe\/public_html\/dynaco\/include\/export_functions.php(125): ExportExcelSave('Localisations.x...', 'Excel2007', Object(PHPExcel)) \r\n#2 \/home\/groupe\/public_html\/dynaco\/classes\/exportpage.php(206): ExportToExcel(Object(mysqli_result), 0, Object(eventsBase), Object(RunnerCipherer), Object(ExportPage)) \r\n#3 \/home\/groupe\/public_html\/dynaco\/classes\/exportpage.php(188): ExportPage->exportTo('excel2007', Object(mysqli_result), 0) \r\n#4 \/home\/groupe\/public_html\/dynaco\/classes\/exportpage.php(65): ExportPage->exportByType() \r\n#5 \/home\/groupe\/public_html\/dynaco\/Localisations_export.php(87): ExportPage->process() \r\n#6 {main} \r\nthrown in \/home\/groupe\/public_html\/dynaco\/plugins\/PHPExcel\/Writer\/Excel2007.php on line 226\r\n<\/pre>\nWe do not need to search for the whole error message as it refers to specific files and line numbers. Just copy the generic part of this error message. <\/p>\n
Fatal error: Uncaught Error: Class 'ZipArchive' not found in<\/pre>\nThe very first result points to Stackoverflow article<\/a> that provides an answer:<\/p>\n
For the ZipArchive class to be present, PHP needs to have the zip extension installed.
\nSee this page<\/a> for installation instructions (both Linux and Windows).\n<\/p><\/blockquote>\nThere is no error message<\/h2>\n
This one is going to be more complicated. As a first step check if there are any Javascript errors behind the scene. This article<\/a> can help. <\/p>\n
Login and security errors<\/h3>\n
You enter correct username and password but getting ‘Invalid login’ message. A few things may go wrong. <\/p>\n
\n
- If email account activation is turned on make sure account is activated. Usually there is a column named ‘active’ in login table that holds value of 1 for active users.<\/li>\n
- If password encryption is turned on make sure that password is encrypted. When you turn on this option existing passwords stay in plain text and this is why login may not work.<\/li>\n
- You use Advanced Security option ‘Users can see and edit their own data only’ but users can see all data. Make sure that user doesn’t belong to an admin group.\n<\/ul>\n
Welcome\/menu page issues<\/h3>\n
Login works but menu is missing some tables or is completely empty. <\/p>\n
\n
- Make sure that current user has permissions assigned. If you added new table to the project make sure you assigned permissions for this table to all user groups.<\/li>\n
- check events like ModifyMenuItem or AfterSuccessfulLogin. Remove code from those events temporarily to see if this fixes the issue.<\/li>\n
- Reset welcome page in Visual Editor. This is unlikely to fix anything but we need to eliminate all possibilities<\/li>\n<\/ul>\n
If all of above doesn’t help it is time to contact support<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
This article will teach you how to troubleshoot your web applications like a pro. Most of these tips are specific to PHPRunner, ASPRunner.NET and ASPRunnerPro but some of them apply to all web applications. General troubleshooting tips This is where you start when something doesn’t work as expected. Make sure that you run the latest build of the software Synchronize database and project Perform a full project build If you test your project on remote web server make sure you upload all generated files Clear…<\/span>Continue Reading “Troubleshooting web applications”<\/span>