Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 19 Apr 2018, 22:11
04wayne 04wayne is offline
 
Join Date: Nov 2009
Impex help with function mysql_connect error

Hoping someone can help. I have the following error message:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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?
Reply With Quote
Comments
  #2  
Old 19 Apr 2018, 22:26
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
I checked the code and it's caused by:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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?
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #3  
Old 19 Apr 2018, 22:48
04wayne 04wayne is offline
 
Join Date: Nov 2009
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.
Reply With Quote
  #4  
Old 19 Apr 2018, 22:49
Dave Dave is offline
 
Join Date: Jun 2010
Real name: 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.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #5  
Old 19 Apr 2018, 22:53
04wayne 04wayne is offline
 
Join Date: Nov 2009
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.
Reply With Quote
  #6  
Old 19 Apr 2018, 22:58
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
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.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #7  
Old 20 Apr 2018, 06:39
04wayne 04wayne is offline
 
Join Date: Nov 2009
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.
~~~~~~~~~
root@euk-88723 [~]# php -m | egrep mysql
mysqli
mysqlnd
pdo_mysql
~~~~~~~~~
root@euk-88723 [~]# 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?

Last edited by 04wayne; 20 Apr 2018 at 07:27.
Reply With Quote
  #8  
Old 20 Apr 2018, 14:01
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
In that case nothing can be done without making a bunch of changes to the code of Impex.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #9  
Old 21 Apr 2018, 10:22
04wayne 04wayne is offline
 
Join Date: Nov 2009
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.
Reply With Quote
  #10  
Old 21 Apr 2018, 14:32
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
Mainly this file needs to be modified to add MySQLi support.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 10:43.

Layout Options | Width: Wide Color: