You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Hi guys, got in a right mess when converting from SQLExpress (installed as SQLite) to MySQL, the upshot is that I've lost a fair bit of custom configuration.
Would there be an issue in copying a backed up khxc-private/apps folder over the reinstalled folders? I'm a bit concerned there may be some database specific code in the cart config files which will not work with MySQL - I really don't want to make a similar mistake to the one I made yesterday!!
I've had no luck in finding a suitable database conversion tool, dbconvert looked promising but it won't accept my SQLite file, is an ODBC connection required or should it be acceptable as a self contained 'flat file'?
Thanks in advance for your time and any advice.
RobH
Offline
What version are you trying to revert back to and what version are you at currently?
I always make a backup of my older ccp code before an update so that I can do just what you are asking about, that way I am able to get my mods in the newer code before I set the site to use the newest code.
John
Offline
Hi John, thanks for the reply. I'm in a right mess and could do with all the help I can get.
I'm running the last version of CCP6, was using SQLExpress with KHXC setup to use SQLite (seemed to work for most things, have changed to MySQL to rule it out as an intermittent problem). My concern is that there may be database specific code within the gbu0 (ccp0) folders which was written during the install, if I replace it with the code that was installed for SQLite (i.e. my backup) then it may cease to function. Even worse it may screw something up with my new database and installation and I couldn't even go back to the code which is currently working.
I guess the question is, are the files and folders beneath khxc-private\apps simple flat files or are they registered durng install and/or do they use code which is specific to the database version I'm using?
Hope you can throw me a line.
Cheers
RobH
Offline
There is nothing database specific that is done during installation Rob. The type of database specified when running the installer determines how interactions with a database are done. Every bit of code installed when running the installer is identical other than directory paths created in the default skins during installation.
Offline
Unless you modified the scripts to do something that is not a default ccp operation in which you created a specific call to a database then ccp's code is generic, it will connect to what ever database is specified with the installer.
John
Offline
ok, thanks guys, wish me luck!
Offline
ok, well not much seems to have changed. I was hoping it might have brought back some of my custom email notifications which are (were) linked to the batch shipping module and some custom options I had set up there. I have no problem creating the emails themselves in KHXC raw db admin KHXC_mail, I've already done this, but I'm not sure which file looks after the triggering of these emails. I'm currently getting an error if I try to send any of the custom notifications (awaiting stock, goods despatched after delay etc).
Fatal error: Cannot use object of type KHXCerror as array in D:\khxc-private\core\KHXC_Mail\KHXC_Mail.php on line 1177
Oh well. Thanks again
RobH
Offline