Installing extensions on windows server

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.
Post Reply
wellis321
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Wed Apr 29, 2009 11:27 pm
Location: Glasgow
Contact:

Installing extensions on windows server

Post by wellis321 » Thu Jul 06, 2017 6:45 pm

Hello

I'm using windows server 2012 R2 with MS SQL express.

Whenever I try to install an extension I get the message =

Code: Select all

[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot insert the value NULL into column 'system_data', table 'test.dbo.#__extensions'; column does not allow nulls. INSERT fails.


I tried removing the NOT NULL from the Joomla! SQL file before installation but that didn't work.

I've seen older posts along the same line so I think this is probably still a bug.

Sorry about using Windows Server but believe me - it's not through choice.

Thanks

William
Last edited by toivo on Thu Jul 06, 2017 9:19 pm, edited 1 time in total.
Reason: mod note: moved from 3.x Bug Reporting

User avatar
AMurray
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3760
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Installing extensions on windows server

Post by AMurray » Thu Jul 06, 2017 9:36 pm

I don't know MS SQL Express is one of the supported databases.The requirements state SQL Server v10.5.1600.1 as minimum/recommended, but doesn't mention SQL Server Express.

https://downloads.joomla.org/technical-requirements

If you can try the following, it may rule out Joomla as the problem (could be the extension that doesn't work well with SQL Server Express) or simply that JOomla doesn't work properly with SSE.

Install XAMPP on your PC, install the site you're working with there. (take backup with Akeeba Backup / restore with Kickstart). See if it runs correctly on MySQL/Apache or MySQL/IIS first, then we can come back to MS SQL Express/Windows.

It would help also to post the FPA Report for the windows server site.
See the red section, top of page - but follow the instructions laid out here: http://forum.joomla.org/viewtopic.php?f=621&t=582860

If a solution can't be found you might have to gently advise your client that MS SQL Express is not adequate for the task.

Some others might have ideas too since I'm no expert on web server stuff and all the above is just guesswork.
Regards,
--------------------------------------------------------------
A Murray
Millennium Falcon - it's the ship that made the Kessel run in less than 12 parsecs! The fastest hunk of junk in the galaxy.

User avatar
brian
Joomla! Master
Joomla! Master
Posts: 11671
Joined: Fri Aug 12, 2005 7:19 am
Location: Leeds, UK
Contact:

Re: Installing extensions on windows server

Post by brian » Fri Jul 07, 2017 7:47 am

William just dont do it. It will be a world of problems. Very few extensions are even tested on MS
"Exploited yesterday... Hacked tomorrow"
Blog http://brian.teeman.net/
Joomla Hidden Secrets http://hiddenjoomlasecrets.com/

User avatar
AMurray
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3760
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Installing extensions on windows server

Post by AMurray » Fri Jul 07, 2017 9:05 am

I think MS SQL support is planned to be dropped in Joomla 4.0 if I'm not mistaken.

https://developer.joomla.org/news/658-j ... festo.html

(obviously early days for J! 4.0 and could always be subject to change).
Regards,
--------------------------------------------------------------
A Murray
Millennium Falcon - it's the ship that made the Kessel run in less than 12 parsecs! The fastest hunk of junk in the galaxy.

wellis321
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Wed Apr 29, 2009 11:27 pm
Location: Glasgow
Contact:

Re: Installing extensions on windows server

Post by wellis321 » Mon Jul 10, 2017 8:10 am

Hello Both

I'm so embarrassed that I didn't even check the requirements!

OF course it won't work with this rubbish set-up. I should have known.

I'm going to run XAMPP as I should have done from the beginning.

Thank you both for making things clearer as always.


Post Reply

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