Kryptronic Software Support Forum

RobH · 10-12-2009 12:17:29

Hi guys,

After having repeated problems which I can only blame on SQL Express (installed as SQLite) I've decided to try and update to MySQL. The MySQL (5.1) install went ok but I've now come to reconfigure CCP to use MySQL instead of SQLite and it's throwing me a few problems.

I need some type of database conversion tool to change my existing (and ever growing) khxc database into the correct format for use with MySQL, so if anyone can point me in the right direction for something that will do the job without breaking the bank it would be much appreciated.

Should it be possible to simply start a new khxc.db if worst comes to the worst? I was trying to do this (purely as a test at this stage) using the CCP installer script but it refused to go past steps 10 / 11, presumably I need to select the option in step 7, "Yes, reinstall/update the Hybrid X Core codebase"?

I'm also a bit confused as to what credentials I should be entering for 'Database username' and 'Database password' when selecting the 'MySQL (all versions)' database type in step 10, it defaults to 'none', do I need to set something up on the server myself??

Apologies for all the questions and for being completely useless with relational dbases, my feelings are that if I can get this set up with the minimum of knowledge I can just leave it alone...

Thanks in advance for any help/advice.

RobH

Dave · 10-12-2009 12:36:45

The database name, user and password are configured in MySQL and those values are what you provide to the installer. A quick Google revealed several possibilities for conversion tools and/or methods to get things converted.

http://www.sqlite.org/cvstrac/wiki?p=ConverterTools

http://forums.mysql.com/read.php?145,68 … #msg-94072

(2nd answer here ...) http://stackoverflow.com/questions/1867 … 3-to-mysql

http://www.sharewareconnection.com/dbco … -mysql.htm

About a third of the way down on this page ... http://amarok.kde.org/amarokwiki/index.php/MySQL_HowTo

Unless you want to start from scratch I'd work on getting things converted rather than starting with a fresh load. Perhaps it's time to update to version 7 and let the importer handle getting things from V6 into V7 for you.

RobH · 10-12-2009 13:05:52

Hi Dave,

Thanks for the prompt reply. Unfortunately V7 is somewhat out of the question at the moment as I've spent quite a lot of cash on custom development of CCP6 - which has only recently been completed, to duplicate the expense and the effort now would be impractical.

I did find a couple of tools through Google myself but was hoping someone might have had some 'real' experience with using a particular tool and could positively recommend.

I keep getting the same error in step 10/11, regardless of credentials:

An error was encountered while creating a new KHXC_DB object. Error Information: The mysql PHP extension is not loaded. This script requires the mysql PHP extension to be loaded in order to connect to the database requested. The KHXC_DB class attempted to load the extension at runtime, however the current server configuration did not permit the class to make this runtime change. Contact your server administrator and request that the mysql PHP extension be loaded at runtime.

Does this mean anything to anyone?

Thanks again

RobH

Dave · 10-12-2009 13:12:26

Your php INI file does not have the MySQL extension enabled. Look for

Code:

extension=php_mysql.dll

in php.ini and make sure it isn't commented out (if you're using a Linux box that will be php_mysql.so not .dll).

dh783 · 10-12-2009 13:15:06

You would also have to reboot the server to get the changes too take effect.

John

Dave · 10-12-2009 13:22:29

Only Apache would need to be restarted John. The server itself would only need to be restarted if he were using the CLI version of PHP.

RobH · 10-12-2009 15:57:15

Thanks guys! I'll have a look in the morning.

Cheers

H

RobH · 10-12-2009 16:17:12

couldn't wait ;-D

Just had a look, I have several different php.ini files, 1 in the default php folder which doesn't make reference to any extension dlls and another in the Windows folder which does refer to php_mysql.dll (not commented out). Not sure which one the install script is looking for but I tried copying the one with the extension reference into the Windows folder and it still doesn't work :-(

Cheers
H

Dave · 10-12-2009 17:20:22

Run phpinfo and it will tell you which one is being used. The quickest way to do that is to create a one line file named phpinfo.php, upload it to your server then hit it with your browser (you'll want to delete the file as soon as you get the results).

Code:

<?php phpinfo(); ?>

RobH · 10-13-2009 03:07:44

That's interesting, Configuration file (php.ini) path = C:\Windows, Loaded configuration file = C:\php\php.ini. Surely that can't be right, do I need to change the path setting? Assuming I have the same (correct) php.ini in both locations it shouldn't make any difference should it ?

Cheers
RobH

Dave · 10-13-2009 05:57:45

Apache has a variable in its configuration file named PHPIniDir which may be set to point to an INI file. You may also have a variable set at the "system" level. And then there are the default places PHP will look. Since, for now, you are interested in getting things to work with Apache I'd focus on the ini file Apache is trying to use and go from there.

RobH · 10-13-2009 06:14:19

Ah. I should probably have mentioned I'm using IIS on a Windows 2003 web edition server.

Cheers

RobH

Dave · 10-13-2009 06:17:01

Oh, in that case I have no idea what it might be doing or where it might be looking. You have my sympathy

RobH · 10-13-2009 06:47:15

I thought you might say that ;-)

Any other Windows php/MySQL experts out there? I won't be holding my breath.

Cheers

RobH

RobH · 10-13-2009 08:27:24

Oh nuts! I'm in a right mess now. Something's got corrupted and I can't even run the installer to clean up what mess I've made. It's coming up with:

The cURL PHP extension is not loaded. This script requires the cURL PHP extension to be loaded in order to function properly.

This script attempted to change this value at runtime, however the current server configuration did not permit the script to make this runtime change. Contact your server administrator and request that the cURL PHP extension be loaded at run time.

File: /installer.php Line: 823 Error Number: 256

I backed it all up before making changes but my backup gives me the same error! Really need some help with this...

Cheers
RobH

Dave · 10-13-2009 08:51:50

You've changed which PHP ini file IIS is seeing/using and it apparently has fewer extensions loaded than the previous one did.

RobH · 10-13-2009 09:44:42

I see where you're coming from but I don't think that's it, it's still looking at the same ini file(s). If I try to run the installer it complains about cURL not being installed, despite all instances of php.ini having the cURL extension uncommented and the appropriate .dlls being copied all over the place. I can confirm that cURL is not loaded according to phpinfo. I don't see what else I can do to get it loaded.

The problem seems to have arisen whilst I was running the install script, at screen 10/11 I rebooted the server, whether that has corrupted something I don't know. My probolem now is that I can't run the installer and I can't go back to the previous backup...

Cheers

RobH

Dave · 10-13-2009 09:52:42

You have multiple issues going on Rob so pick one of them and get it resolved before going on to the next one. If phpinfo doesn't show cURL as being loaded open a command prompt, switch to the directory where you have PHP installed and do php -m which will list all of the modules/extensions that are installed. If cURL is in the list then I would suspect that IIS is not using the same INI file as the command line version of PHP is and try to track that down.

RobH · 10-13-2009 10:56:19

Youre not wrong! Ok, I've finally managed to get cURL to load - more luck than judgement and have been able to run part way through the install script. It's now telling me that the SQLite module isn't loaded (!). To be honest I'd prefer to grab the bull by the horns now and simply start a new KHXC database running on MySQL, I'll convert and merge the existing data when I get round to it, just want to get the cart running again and preferably on MySQL..

Cheers

H

Kryptronic Software Support Forum

#1 10-12-2009 12:17:29

Changing to MySQL, could do with a bit of advice please

#2 10-12-2009 12:36:45

Re: Changing to MySQL, could do with a bit of advice please

#3 10-12-2009 13:05:52

Re: Changing to MySQL, could do with a bit of advice please

#4 10-12-2009 13:12:26

Re: Changing to MySQL, could do with a bit of advice please

Code:

#5 10-12-2009 13:15:06

Re: Changing to MySQL, could do with a bit of advice please

#6 10-12-2009 13:22:29

Re: Changing to MySQL, could do with a bit of advice please

#7 10-12-2009 15:57:15

Re: Changing to MySQL, could do with a bit of advice please

#8 10-12-2009 16:17:12

Re: Changing to MySQL, could do with a bit of advice please

#9 10-12-2009 17:20:22

Re: Changing to MySQL, could do with a bit of advice please

Code:

#10 10-13-2009 03:07:44

Re: Changing to MySQL, could do with a bit of advice please

#11 10-13-2009 05:57:45

Re: Changing to MySQL, could do with a bit of advice please

#12 10-13-2009 06:14:19

Re: Changing to MySQL, could do with a bit of advice please

#13 10-13-2009 06:17:01

Re: Changing to MySQL, could do with a bit of advice please

#14 10-13-2009 06:47:15

Re: Changing to MySQL, could do with a bit of advice please

#15 10-13-2009 08:27:24

Re: Changing to MySQL, could do with a bit of advice please

#16 10-13-2009 08:51:50

Re: Changing to MySQL, could do with a bit of advice please

#17 10-13-2009 09:44:42

Re: Changing to MySQL, could do with a bit of advice please

#18 10-13-2009 09:52:42

Re: Changing to MySQL, could do with a bit of advice please

#19 10-13-2009 10:56:19

Re: Changing to MySQL, could do with a bit of advice please

Board footer