2GB file size limit? | Page 3 | Joomla Support | Forum Archive

The free forums are no longer in use. It remains available as read-only archive.

Avatar
Lost password?
Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
The forums are currently locked and only available for read only access
sp_TopicIcon
2GB file size limit?
February 2, 2011
6:02 pm
Avatar
Marcus
Member
Members
Forum Posts: 20
Member Since:
January 12, 2011
sp_UserOfflineSmall Offline

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.

February 2, 2011
6:33 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

K, found the issue and updated the package on our site, feel free to download and test it again!

A big THANK YOU as we haven't had the chance to test it on a IIS server

 

Ovidiu

February 2, 2011
6:44 pm
Avatar
Marcus
Member
Members
Forum Posts: 20
Member Since:
January 12, 2011
sp_UserOfflineSmall Offline

Yes! Great job guys! Now it seems to work. I'm going to run a backup now and see how it goes.

I'll post back with the results.

//Marcus

February 2, 2011
7:00 pm
Avatar
Marcus
Member
Members
Forum Posts: 20
Member Since:
January 12, 2011
sp_UserOfflineSmall Offline

So far so good! The "Split backup archive" works beautifully, splitting at 2048 MB and the second part being 300MB, it seems to have got all the files backed up. Very nice!

I'll try a restore and see how that goes. 

February 2, 2011
8:18 pm
Avatar
Marcus
Member
Members
Forum Posts: 20
Member Since:
January 12, 2011
sp_UserOfflineSmall Offline

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')


 

## 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 =)

February 2, 2011
8:52 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Found the issue, and posted an updated package in our Downloads area, could you try and generate a new database backup with that one and see if you have anymore issues when restoring?

Ovidiu

February 2, 2011
8:54 pm
Avatar
Marcus
Member
Members
Forum Posts: 20
Member Since:
January 12, 2011
sp_UserOfflineSmall Offline

Sure, I'll try it out. Thanks.

February 2, 2011
9:08 pm
Avatar
Marcus
Member
Members
Forum Posts: 20
Member Since:
January 12, 2011
sp_UserOfflineSmall Offline

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')

## 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...

February 2, 2011
9:15 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

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

 


February 2, 2011
9:18 pm
Avatar
Marcus
Member
Members
Forum Posts: 20
Member Since:
January 12, 2011
sp_UserOfflineSmall Offline

Yes, I'll try it out. It's getting a bit late, so I might have to get back to you tomorrow. Thanks!

Forum Timezone: America/Chicago
Most Users Ever Online: 867
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
mlguru: 30
Django29: 29
Andy: 21
D: 21
Marcus: 20
Jamie F: 19
Member Stats:
Guest Posters: 738
Members: 10030
Moderators: 2
Admins: 3
Forum Stats:
Groups: 3
Forums: 7
Topics: 2397
Posts: 8236
Newest Members:
Omar Vera
Moderators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0