vBulletin ModsThe Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=326321 |
Hoping someone can help. I have the following error message:
I've spoken with my hosts who assure me they've switched mysql_connect on for my domain but that hasn't done anything. I'm still getting the same error message. To confirm my steps thus far: 01. Downloaded impex from github. 02. Unpacked files from zip. 03. Renamed the folder to impex. 04. Edited config file to reflect both target and source. 05. Uploaded impex/ to public_html (same location as admincp directory). 06. Uploaded cpnav_impex.xml to includes/xml. 07. Signed into admincp > import > import > entered passcode Then get the error message outlined above. As I said, my hosts assure me mysql_connect is turned on but I'm still getting the error message. Any other suggestions? |
I checked the code and it's caused by:
And the only possible way this can happen is if the mysql_connect function does not exist. Maybe it's less of a pain if you perform the impex import locally on your own PC? |
My hosts said they have pinpointed the issue and taken it away to work on - not quite sure what they're doing then!
I'm a bit of a novice when it comes to this, so not sure how to do a local import on my PC? PS - thanks for responding Dave. |
Ah... well it involves setting up your own local webserver with use of XAMPP/WAMP.
Might be easier to wait for your host to resolve it. |
Ha! Sounds like a treat.
Will see what the host comes back with - shame vB stopped supporting impex. I remember using it many years ago (2009-ish) - wonderful tool. Not sure what we'll do if my host can't fix it. |
Well if your host cannot fix it then it sounds like you need a different host in my opinion.
I'd say they stopped supporting Impex because it requires a significant amount of work to keep track of all the different forum software, then making sure that if they release updates it will still work with Impex. Along with that, if vBulletin does an update then it possibly needs adjustments as well. Then we also have vBulletin 5 with a completely different database structure. It would of been a near full-time job to maintain it. |
My host came back with this:
As per your issue, we have checked and found that MySQL extension is been replaced with MySQLi. Because the MySQL extension is deprecated after 5.5 PHP version. Link to the same just for your reference http://php.net/manual/en/function.mysql-connect.php So, in this case, you need to use MySQLi Or PDO_MySQL to its backend to get the database connected and the required extensions are enabled on the server below are the same. ~~~~~~~~~ [email protected] [~]# php -m | egrep mysql mysqli mysqlnd pdo_mysql ~~~~~~~~~ [email protected]723 [~]# repoquery -q --whatprovides 'ea-php70-php-mysqli' | sort -V | tail -1 ea-php70-php-mysqlnd-0:7.0.29-1.1.5.cpanel.x86_64 ~~~~~~~~~ Also after further investigation, we have found that ImpEx requires MySQL extension for working. Kindly review the link >> https://www.vbulletin.com/forum/foru...-the-php-build Kindly get into contact with your developer and get the MySQL Or PDO_MySQL extension to be used to its backend as well get in contact with the application vendor for more details regarding same. Please check and do let us know If you have any further query/doubts. ================ Is there an easy way to do any of what my host is saying? My read into it is that impex requires mysql and the host has enabled that or has that extension enabled already. And that what I now need is something to do with impex? |
In that case nothing can be done without making a bunch of changes to the code of Impex.
|
Nightmare! Will probably leave this here for the time being.
If anyone familiar with Impex fancies talking me through the changes that need to be made (so I can understand the complexity of the task and possibly attempt the changes) or even undertaking paid work to make the changes, let me know. |
Mainly this file needs to be modified to add MySQLi support.
|
mysql extension is removed in PHP 7, so you must run ImpEx in PHP 5.6 or earlier.
|
All times are GMT. The time now is 12:56. |
Powered by vBulletin® Version 3.8.14
Copyright © 2022, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.