[FIXED] Joomla 3.6.3 and above and SQL Sevrer 2014

This forum is for issues with installing Joomla! 3.x on IIS webservers.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Locked
adam.hughes
Joomla! Intern
Joomla! Intern
Posts: 94
Joined: Thu Sep 15, 2005 7:30 am

[FIXED] Joomla 3.6.3 and above and SQL Sevrer 2014

Post by adam.hughes » Thu Apr 27, 2017 7:14 am

I've been trying to install a brand new fresh instance of Joomla on Windows Server 2012, with IIS and SQL Server 2014. I cannot get any verison above Joomla 3.6.2 to work.

The only version I can get to work is 3.6.2 and I can only get this to work by installing a fresh 3.6.0, then upgrading from 3.6.0 to 3.6.1 and then to 3.6.2, any attempts to install or upgrade above this fails.

To make it easier to diagnose I will list what happens on a fresh installation (to ensure no external issues etc.)

1. Download Joomla 3.7.0
2. Create a new SQL Server 2014 database
3. Unpack joomla 3.7.0 and create a new IIS web site and point it to the new 3.7.0 directory
4. Go to the new site in my browser (Mozilla 52.x)
5. Enter the configuration parameters (shown below) and click on next
Site name: test2.questleisure.local
Description: Quest test website 2
Email: [email protected]
Username: ******
Password: *****
Confirm password: ******
6. Enter the database parameters (shown below) and click on next
Database type: MIcrosoft SQL Server
Host name: localhost
Username: *****
Password: *****
Database name: THEDBNAME
Table prefix: left as is
Old database process: I have tried both backup and remove
7. I do not set up a FTP layer
8. I get to the Finalisation page and everything is okay
9. I click on install and the install starts. The progress bar jumps across to approx 1/3 the way across then stops for a few seconds and then I'm redirected to the finalisation page again.

I check the database and the installation routine has generated 71 database tables (full list in next post)

I have tried the above a number of times and got the exact same result. The same happens with a fresh install of everything from 3.6.3 and above (I have tried every one).
If I run the exact same process above with Joomla 3.6.0 it works fine, but then I cannot upgrade past 3.6.2.

One issue is that I cannot get any error message out in any error log or syslog so I cannot debug where the failure is. Any help would be much appreciated.

Cheers
Last edited by adam.hughes on Thu Apr 27, 2017 8:36 am, edited 2 times in total.

adam.hughes
Joomla! Intern
Joomla! Intern
Posts: 94
Joined: Thu Sep 15, 2005 7:30 am

Re: Joomla 3.6.3 and above and SQL Sevrer 2014

Post by adam.hughes » Thu Apr 27, 2017 7:53 am

Here is a list of the database tables that were generated as part of the failed install :
pcpef_assets
pcpef_associations
pcpef_banner_clients
pcpef_banner_tracks
pcpef_banners
pcpef_categories
pcpef_contact_details
pcpef_content
pcpef_content_frontpage
pcpef_content_rating
pcpef_content_types
pcpef_contentitem_tag_map
pcpef_core_log_searches
pcpef_extensions
pcpef_fields
pcpef_fields_categories
pcpef_fields_groups
pcpef_fields_values
pcpef_finder_filters
pcpef_finder_links
pcpef_finder_links_terms0
pcpef_finder_links_terms1
pcpef_finder_links_terms2
pcpef_finder_links_terms3
pcpef_finder_links_terms4
pcpef_finder_links_terms5
pcpef_finder_links_terms6
pcpef_finder_links_terms7
pcpef_finder_links_terms8
pcpef_finder_links_terms9
pcpef_finder_links_termsa
pcpef_finder_links_termsb
pcpef_finder_links_termsc
pcpef_finder_links_termsd
pcpef_finder_links_termse
pcpef_finder_links_termsf
pcpef_finder_taxonomy
pcpef_finder_taxonomy_map
pcpef_finder_terms
pcpef_finder_terms_common
pcpef_finder_tokens
pcpef_finder_tokens_aggregate
pcpef_finder_types
pcpef_languages
pcpef_menu
pcpef_menu_types
pcpef_messages
pcpef_messages_cfg
pcpef_modules
pcpef_modules_menu
pcpef_newsfeeds
pcpef_overrider
pcpef_postinstall_messages
pcpef_redirect_links
pcpef_schemas
pcpef_session
pcpef_tags
pcpef_template_styles
pcpef_ucm_base
pcpef_ucm_content
pcpef_ucm_history
pcpef_update_sites
pcpef_update_sites_extensions
pcpef_updates
pcpef_user_keys
pcpef_user_notes
pcpef_user_profiles
pcpef_user_usergroup_map
pcpef_usergroups
pcpef_users
pcpef_viewlevels

adam.hughes
Joomla! Intern
Joomla! Intern
Posts: 94
Joined: Thu Sep 15, 2005 7:30 am

[FIXED] Re: Joomla 3.6.3 and above and SQL Sevrer 2014

Post by adam.hughes » Thu Apr 27, 2017 8:36 am

I have just upgraded my installation of PHP from 7.0.9 (64 bit) to 7.1.1 (64 bit) and rerun the install.
The install has this time worked, so the issue was withing the software levels and seems to have been fixed with PHP 7.1.1.

Cheers


Locked

Return to “Joomla! 3.x on IIS webserver”