Pages:
1
2 |
Xian
Member
 
Posts: 50
Registered: 9-12-2017
Location: Los Angeles, California
Member Is Offline
Mood: w00h00!
|
|
[Resolved] PHP7 and MYSQLI Compatibility
Full Board URL: http://xmbforum2.com
XMB Version: 1.9.11
I have ported the mysql.php and a couple of other related files so it will run on PHP7 if anyone is interested in the files.
Please let me know.
I haven't been at XMB in forever when I used to do support long ago. But I've still continued to use XMB.
christian.deguzman [at] gmail.com
I am not sure what the rules are still. I am not sure if we are allowed to re-package XMB and send but I can send the individual modified files if
needed.
Thanks guys! It's good to be back!
|
|
lottos
Administrator
      
Posts: 482
Registered: 6-3-2002
Member Is Offline
Mood: pass me a TimTam
|
|
Suggestion: zip it up and post it on here for others to try?
|
|
Xian
Member
 
Posts: 50
Registered: 9-12-2017
Location: Los Angeles, California
Member Is Offline
Mood: w00h00!
|
|
Updated: http://forums.xmbforum2.com/viewthread.php?tid=776996
Here is the zipped package of the ported XMB Forum.
I just upped the version number to: 1.9.12.beta (I didn't know what else to call it).
There are still some kinks to workout. Maybe someone else can figure out why nothing shows up in Today's Posts and maybe rework the
Captcha code to work again. I will attempt also to see what's up with those two things.
If you find more bugs please post them here so we can all work them out... hopefully together.
------------------------------------------------------------
New install:
Just follow the normal XMB installation instructions. If you have a modified board follow the instructions below:
------------------------------------------------------------
Instructions on how to make your existing XMB Forum software to be compatible with PHP7 and MYSQLI.
Discalimer:
THIS SOFTWARE MODIFICATION IS PROVIDED BY THE AUTHOR "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
WARRANTIES OF
MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
SPECIAL,
EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR
BUSINESS INTERRUPTION)
HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY
OUT OF THE USE OF THIS
SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
***USE AT YOUR OWN RISK***
***PLEASE TEST OUT THE MODIFICATIONS FIRST TO MAKE SURE IT WORKS ON THE SERVER YOU ARE INSTALLING IT ON.***
***MAKE BACKUPS OF YOUR EXISTING FILES AND DATABASE SO YOU CAN REVERT BACK TO THE PRE MODIFIED VERSION OF YOUR XMB INSTALLATION***
------------------------------------------------------------
Tested on a Windows DEV Server running:
Apache 2.4.27
MariaDB 10.1.26
PHP 7.1.8
------------------------------------------------------------
------------------------------------------------------------
Tested on a Linux Production Server running:
Apache: 2.4.25
MySQL: 5.5.57-cll
PHP: 5.6.30
------------------------------------------------------------
1. READ EVERYTHING ABOVE THIS FIRST!
2. Backup your existing XMB installation first. -> Download your entire "XMB" folder.
3. Backup your existing MySQL database.
4. BACKUP EVERYTHING!!
5. Upload ./db/mysqli.php to your .ROOT./db/ folder
6. Upload ./include/schema.inc.php to your .ROOT./include/ folder
7. Did you backup your files? You will need the old copy of your config.php files next.
8. Upload the config.php file to your .ROOT./ folder.
9. Copy the information from your old config.php file to the new config.php file.
10. Change $database = 'mysql'; to $database = 'mysqli';
11. Save the new config file.
12. Open misc.php file. (If you have an unmodified misc.php file just upload the one from the files folder.)
13. Replace all instances of like_escape with escape.
14. Open search.php file. (If you have an unmodified search.php file just upload the one from the files folder.)
15. Replace all instances of like_escape with escape.
16. Did I already mention to backup your files and database? Well did you do it?
20. If you did a full and complete backup good for you! Enjoy!
****~~~KNOWN BUGS~~~****
Today's Posts -> No posts display. (Fixed 09/12/2017 repatched mysqli.php and recoded result() function.)
Captcha Image not working. -> Must disable in Settings until this can be re-coded.
EDIT: Captcha still works with this version.
Updated the package file to ammend the Read Me. If you've already downloaded this file there is no need to do so again. Just updated the read me
file to match this post.
|
|
John Briggs
XMB Contributor
 
Posts: 30
Registered: 2-12-2002
Location: Illinois
Member Is Offline
Mood: Great
|
|
Did XMB-1.9.11.14 not work? Just curious if you were aware of those changes prior to this Xian? I have not been able to test on PHP7.
Retired XMB Contributor
|
|
lottos
Administrator
      
Posts: 482
Registered: 6-3-2002
Member Is Offline
Mood: pass me a TimTam
|
|
Quote: Originally posted by John Briggs  | Did XMB-1.9.11.14 not work? Just curious if you were aware of those changes prior to this Xian? I have not been able to test on PHP7.
|
Worked for me in my limited testing, however as noted in the readme on sourceforge, it was a temporary fix.
|
|
John Briggs
XMB Contributor
 
Posts: 30
Registered: 2-12-2002
Location: Illinois
Member Is Offline
Mood: Great
|
|
Quote: Originally posted by lottos  | Quote: Originally posted by John Briggs  | Did XMB-1.9.11.14 not work? Just curious if you were aware of those changes prior to this Xian? I have not been able to test on PHP7.
|
Worked for me in my limited testing, however as noted in the readme on sourceforge, it was a temporary fix. |
I never saw a readme so sorry. I just saw the package was updated and looked at the new files recently as I didn't even see what had changed. It's
being installed by Softaculous. Not sure what there vetting process is or what relationship they have with you guys here. I was installing some old
themes of mine on my internal 1.9.8 hybrid build from years ago and wanted to test on 1.9.11 version too and installed via cpanel as I was surprised
to see it there and it had 1.9.11.14 as an update to it.
Retired XMB Contributor
|
|
Xian
Member
 
Posts: 50
Registered: 9-12-2017
Location: Los Angeles, California
Member Is Offline
Mood: w00h00!
|
|
What's up JBriggs? Long time no talk. Glad to see you're still around.
I didn't even know about 1.9.11.14 I just downloaded the package that was on the main page and started patching the mysql file to mysqli. I should
check that out.
Where do I get the .14 build?
|
|
John Briggs
XMB Contributor
 
Posts: 30
Registered: 2-12-2002
Location: Illinois
Member Is Offline
Mood: Great
|
|
Hi Christian, I still keep an eye on the community. I check in from time to time. Good to see you around again. I know the community can use good
people like you to help out. Lottos holds down the community by himself for the most part. I am sure any help is appreciated.
You can find what you need here: https://sourceforge.net/projects/xmb-forum2/files/?source=na...
There was no ReadMe until recently so I had no idea what changed in the files until I looked harder a few days ago. I emailed Lottos and sent an U2U
but not sure he got it. The link on the forum has been to the old 1.9.11.13 build for ages so no one knew about 14.
Hope that helps.
Retired XMB Contributor
|
|
Xian
Member
 
Posts: 50
Registered: 9-12-2017
Location: Los Angeles, California
Member Is Offline
Mood: w00h00!
|
|
Thanks for the info John.
Hopefully together we can all keep XMB alive and live on. I was just reading the stuff about iEntry. What a bummer.
Let's try to keep making XMB better.
|
|
lottos
Administrator
      
Posts: 482
Registered: 6-3-2002
Member Is Offline
Mood: pass me a TimTam
|
|
Quote: Originally posted by Xian  | What's up JBriggs? Long time no talk. Glad to see you're still around.
I didn't even know about 1.9.11.14 I just downloaded the package that was on the main page and started patching the mysql file to mysqli. I should
check that out.
Where do I get the .14 build? |
damn, you probably used .14 as the base for your beta. probably better if the changes you made were done to .13 as .14 may be hiding other porting
issues.
|
|
Xian
Member
 
Posts: 50
Registered: 9-12-2017
Location: Los Angeles, California
Member Is Offline
Mood: w00h00!
|
|
Quote: Originally posted by lottos  | Quote: Originally posted by Xian  | What's up JBriggs? Long time no talk. Glad to see you're still around.
I didn't even know about 1.9.11.14 I just downloaded the package that was on the main page and started patching the mysql file to mysqli. I should
check that out.
Where do I get the .14 build? |
damn, you probably used .14 as the base for your beta. probably better if the changes you made were done to .13 as .14 may be hiding other porting
issues. |
crapola! well the header.php file just said 1.9.11 if I remember correctly. I'm not sure if the patch numbers were added in the header.php file.
But so far looks like it's working. I guess we will just have to patch up bugs when we find them.
|
|
John Briggs
XMB Contributor
 
Posts: 30
Registered: 2-12-2002
Location: Illinois
Member Is Offline
Mood: Great
|
|
I have not seen an issue so far with 14. I will report if I see anything.
Retired XMB Contributor
|
|
lottos
Administrator
      
Posts: 482
Registered: 6-3-2002
Member Is Offline
Mood: pass me a TimTam
|
|
Thanks, problem is that .14 was only ever intended to be a workaround, it hasn't been ported to work correctly with php7.x
I suspect that if the changes made in the new beta were backported to .13 a whole world of pain would open.
|
|
Scarlet
Member
 
Posts: 60
Registered: 9-15-2017
Location: England
Member Is Offline
Mood: Excited for XMB's resurrection!
|
|
You'll be able to tell the difference from .13 and .14 as the footer credits were updated from 2012 to 2017. Anyway, I'm pretty interested in seeing a
PHP 7 compatible XMB Forum, and it seems it has brought new activity - I'm really happy that you have taken the time to work on this!
Will existing hacks work, just to ask?
|
|
Xian
Member
 
Posts: 50
Registered: 9-12-2017
Location: Los Angeles, California
Member Is Offline
Mood: w00h00!
|
|
Quote: Originally posted by Scarlet  | You'll be able to tell the difference from .13 and .14 as the footer credits were updated from 2012 to 2017. Anyway, I'm pretty interested in seeing a
PHP 7 compatible XMB Forum, and it seems it has brought new activity - I'm really happy that you have taken the time to work on this! 
Will existing hacks work, just to ask? |
The beta package that is now downloadable can be a fresh install and there are also instructions to modify the files needed if your board is modified.
There are no major files affected by this port over. Just read the MySQLi Port Readme that is in the package.
|
|
Xian
Member
 
Posts: 50
Registered: 9-12-2017
Location: Los Angeles, California
Member Is Offline
Mood: w00h00!
|
|
Well, apparently captcha still works. It may have been a server misconfiguration on my DEV Server that caused Captcha to not work when I tested it.
Captcha works on my production test server.
lottos, could you please download this file and replace it with the one in the sourceforge downloads?
thanks.
|
|
Scarlet
Member
 
Posts: 60
Registered: 9-15-2017
Location: England
Member Is Offline
Mood: Excited for XMB's resurrection!
|
|
Definitely would be appreciated to see 1.9.12 officially released on the SourceForge page. I'm drinking a coffee (latte) waiting for this 
|
|
lottos
Administrator
      
Posts: 482
Registered: 6-3-2002
Member Is Offline
Mood: pass me a TimTam
|
|
Quote: Originally posted by Xian  |
lottos, could you please download this file and replace it with the one in the sourceforge downloads?
thanks. |
It appears the beta is still based on .14
It's pointless making changes to .14 as it already has a quick and dirty mod to make it work with php7.x [a class script to mainly replace the
connect, grab data etc. functions that worked in older mysql connections and use the equivalant mysqli] and would likely work without any in depth
code changes [which are the correct way to port and which should be done to .13].
|
|
Xian
Member
 
Posts: 50
Registered: 9-12-2017
Location: Los Angeles, California
Member Is Offline
Mood: w00h00!
|
|
I've downloaded 1.9.13 and will begin to test it out.
|
|
Xian
Member
 
Posts: 50
Registered: 9-12-2017
Location: Los Angeles, California
Member Is Offline
Mood: w00h00!
|
|
|
|
Pages:
1
2 |