https://www.icyphoenix.com/viewtopic.php?f=2&t=9748&p=61169#p61169
-----------------------------------
MWE_001
Thu 31 Aug, 2017 20:27

Re: Help, Problems With New Installation!
-----------------------------------
I can try as well. I have a WAMP installed and ready to go. 

Can you tell us exactly what error/s you are getting? It will not only help to help you right now, but help us fix this for future use as well.

Screenshots work real nice as well. Photobucket is no longer an option without paying them $300 per year. So if you do choose screenshots, try uploading to your album herre or using a offline site like imgur or something like that.

Take care!

**EDIT**

Ok I got the exact same WAMP server installed per the OP thread. 

Here is what I gather so far:

1.[strike]We need to release a patch real bad![/strike] Ok a patch would not work either. Maybe a minor upgrade and new release? If a patch was pushed it ouwld be just as easy to upgrade 2 files in the install folder and release a new minor updated version. We still have a storage engine issue that was reported long ago.
2. Once engine was fixed, the forum  rules error as told to us and luca commented on did in fact appear right on schedule.
3. Applying the fix Luca stated we now get this:

An error occurred trying to update the database
Field 'forum_rules' doesn't have a default value

So what if after we run the fix Luca suggested, we then alter the table via a query to this: ALTER TABLE phpbb_forums ALTER forum_rules SET DEFAULT ''  ?? 

**EDIT**
Just tried my fix to the fix and got this: 

An error occurred trying to update the database
BLOB, TEXT, GEOMETRY or JSON column 'forum_rules' can't have a default value

This is a strict mode BUG with MySQL and windows servers. I am going to try a live install on my linux server at a Data Center and see if the error exists.

Since the Op is trying to install on a WAMP server, I seriously doubt he is going to hack his own server. So in theory, any WAMp user can shut off strict mode and all should be well.

And also, I did a test install on linux and it installed flawless. No errors at all. not even the storage issue came up ironically enough. So i guess a patch or new version is not needed. So far all the errors seem windows related. I stand corrected if I am wrong.

Here is my Linux info if it helps any:

Apache Version 	2.2.31
PHP Version 	5.6.30
MySQL Version 	5.5.51-38.2
Architecture 	x86_64
Operating System 	linux

[b]Ronalito[/b] - Give me some time today and let me work on this and I will figure out how to do a install on WAMP Server without errors. It might take me a while as my code skills are slipping a bit in my older age  :mryellow:

**EDIT**

Ok [b]Ronalito[/b] problem solved. 

in your system tray, click on WAMP icon and mouse over MySQL and choose my.ini

look for [code linenumbers=false];sql-mode=""[/code]

replace with [code linenumbers=false]sql-mode=""[/code]

Save this file and Restart all services to WAMP.

if you get the Storage engine error, in your icy phoenix install/schemas folder

Open mysql_schema.sql and find at the top of the file

[code linenumbers=false]SET storage_engine=MYISAM;[/code]

Change it to 

[code linenumbers=false]SET default_storage_engine=MYISAM;[/code]

Open sql_update_ip.php

Find  [code linenumbers=false]$sql[] = "SET storage_engine=MYISAM";[/code]

Replace with [code linenumbers=false]$sql[] = "SET default_storage_engine=MYISAM";[/code]

Save and close all files.


Those modifications right there will allow you to install Icy Phoenix on you WAMP server error free. Now please understand, I am not responsible for any damage that may result if you use my fixes. This worked for me but might not for you. Use at your own risk! 

**DISCLAIMER**
This edit will shut off strict mode in you MySQL!!!!! Please be aware of that. Do not use this WAMP as a live server. if you do, please understand what we just did to make your install work.

Enjoy your new install!!!

if you have any other questions please feel free to come back and post and will help as soon as possible.


