The free forums are no longer in use. It remains available as read-only archive.
6:02 pm
January 12, 2011
I removed the cache section in the admin.cloner.html.php file but no change. I also downloaded the updated version and tried it, but no go. Still the login page shows up. I have also purged and emptied the Joomla cache.
The browser I'm using is Firefox on OSX. I tried it in Safari and got this error message when clicking "Generate backup":
PHP Warning: include(../cloner.config.php) [function.include]: failed to open stream: No such file or directory in E:WEB_SITESmarcusmodels_netadministratorcomponentscom_xcloner-backupandrestorebrowserfiles_inpage.php on line 6 PHP Warning: include() [function.include]: Failed opening '../cloner.config.php' for inclusion (include_path='.;C:php5pear') in E:WEB_SITESmarcusmodels_netadministratorcomponentscom_xcloner-backupandrestorebrowserfiles_inpage.php on line 6 PHP Warning: include(../common.php) [function.include]: failed to open stream: No such file or directory in E:WEB_SITESmarcusmodels_netadministratorcomponentscom_xcloner-backupandrestorebrowserfiles_inpage.php on line 7 PHP Warning: include() [function.include]: Failed opening '../common.php' for inclusion (include_path='.;C:php5pear') in E:WEB_SITESmarcusmodels_netadministratorcomponentscom_xcloner-backupandrestorebrowserfiles_inpage.php on line 7
The file "files_inpage.php" is present in the correct path, but perhaps the path (../cloner.config.php and so on)in the file itself is wrong?
NOTE: It seems that all of the backslashes are gone in the post above...but it's regular Windows paths.
—
8:18 pm
January 12, 2011
I tried to restore just the database (used the "skip files" option) when restoring to the same server. I deleted my database and created a new empty one with the same name. I ran the restore but got an error about not able to find the .sql file. So I extracted the .sql file from the TAR-archive (administrator/backups) into the restore folder. Tried the restore again but got an MySQL error:
###MYSQL error
Incorrect integer value: '' for column 'unsubdate' at row 1
###On Query:
## End Structure for table `jos_acymailing_listsub`#
## Dumping data for table `jos_acymailing_listsub`#
INSERT INTO `jos_acymailing_listsub` VALUES ('1', '1', '1282435304', '', '1')
Now, this is the Acymailing component and probably the first table in the database. Am I doing something wrong in this procedure?
Now, mind you that I haven't lost any data, I'm running the web server in a virtual machine and have taken snapshots that I can revert to. So no problem there, I'm free to experiment =)
9:08 pm
January 12, 2011
Sorry, still get the error. The progress stops really at the beginning, Xcloner says:
Processed 0.05% from sql backup!
I click "Skip query..." and it continues to the next step in the Acymailing component, I click "skip" four times and then it skips 4% ahead to the Fabrik component and the error:
###MYSQL error
Incorrect datetime value: 'NULL' for column 'checked_out_time' at row 1
###On Query:
## End Structure for table `jos_fabrik_connections`#
## Dumping data for table `jos_fabrik_connections`#
INSERT INTO `jos_fabrik_connections` VALUES ('1', 'localhost', 'root', '_Pajjas76_', 'marcusmodels_net', 'site database', '1', '0', 'NULL', '1', 'NULL')
I can continue clicking "skip" but it gets boring fast...
So it's seems that there is syntax interpretation problem of the data? I'm not a database guy so I'm just guessing here...
Yes, it seems to be related to the sql mode(presuming strict sql_mode) you have setup by default on the mysql server and the way XCloner exports the data, i have made an update in the restore script, could you try the restore again with the updated restore script on our site(mainly restore/XCloner.php)?
If you still have issues, could you run this query in your restore mysql environment phpmyadmin and send us the output so we can look further into it?
SELECT @@GLOBAL.sql_mode;
Regards, Ovidiu
1 Guest(s)