esper

Could anyone help me please? It´s a bit complicated.. I have unistalled this module, because of an error with redirect to 404 page (Error Exception table doesn´t exist). Unistallation proceeded with error (error_2). Then I realized it probably did not function because in database, the table name was "processredirect" instead of "ProcessRedirect". Of course, renaming now did not help because of partial uninstallation. Consequently, I deleted table "ProcessRedirect" from database in order to delete whole module from the system and install it again. However still "Redirects" module was showing among "Site" modules (without "Redirects" in menu however, so I cannot use it), uninstall still did not work. I tried to delete "caches", which ended in losing all info about modules in administration. I imported cache back, however MySQL error "Duplicate entry Modules.wire/modules for key PRIMARY" emerged and modules still did not work. I deleted caches and imported it again with AUTO_INCREMENT option unchecked (default is checked), which worked for modules, however still I am concerned about SQL error "Multiple primary key defined". But it worked, I have info about Modules again. Redirects are still in on-site modules. I tried to find a line with ProcessRedirect in table "modules", but did not find it. I deleted relevant folder in "site/modules", refresh and copied it again, did not work, still Redirects are in "Site" modules. I deleted manually every data about this module from "caches" table, including line ModulesVerbose.info, Modules.site/modules and Modules.info. Did not help. Redirects are still showing among "Site" modules, if the folder is present, even when I deleted them from database. When the folder is not present, they are not showing at all, but I want to install the module again and I can´t because it never shows up among modules which can be installed. I even tried to upload module instead of copying it directly, but I land on the "New modules" tab again and ProcessRedirect is not here to be installed. There is notification "Session: Detected 1 new module: ProcessRedirects" showing, however only text "no modules found" is actually there. Cache module is not installed, PW installation is 2.7.2., I don´t know what else is relevant... Thank you very much for any help!

cstevensjr and Doug G, thank you both very much for response and useful links! Now I know where to start studying. Thanks again and have a nice day!

Thank you very much for your reply! However those posts refer mostly to setting up Processwire on Windows server. I need to know, if it is possible to communicate between MySQL of Processwire and MSSQL of intranet .NET systems, using LDAP authentication with several thousands users, and getting data from one another. Does the posts mean, that if all systems run on the same server, it would make the connection possible, even if they are different technologies? Maybe I ask the wrong way... I use ProcessWire over two years now and did some programming in PHP as well, however I have no experience with Windows servers, .NET and connecting to other systems in general. I don´t suppose Processwire could be safely set up with MSSQL instead of MySQL?

Do you think it would be possible to establish connection between Processwire (MySQL) and MSSQL? I mean large-scale web portal running on ProcessWire, which would communicate with intranet systems in .NET, all would use LDAP authentication.. Maybe with help of ODBC? Thanks for any insight!!!