andrea.freddi Posted July 19, 2012 Share Posted July 19, 2012 hello i've installed this great contribution and everything seems to working fine, but when i try to send the backup file via email, i'm getting this message: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. what am i doing wrong, can you help me to get it running? andrea osc 2.3.1 / database backup manager 1.5.2.1 sorry Quote Link to comment Share on other sites More sharing options...
trier Posted August 28, 2012 Share Posted August 28, 2012 Hi, Thank you for yet another very helpful contribution - non zipped backups seem to be less than half the size of those from the standard osc backup and the option to backup/restore selected tables is very useful. Sorry fot the trivia, but is line 190 of backup.php correct? if (!fp) { die ("No file handle open."); } Should it be if (!$fp)? The script ID reads v 1.5.1 though I believe it is the lastest 1.5.2 It's probably no too important, unfortunately I don't know/understand enough to be leave/change it. Many thanks Quote Link to comment Share on other sites More sharing options...
pedro.antunes Posted January 15, 2013 Share Posted January 15, 2013 Uploaded new version 1.5.2 Hi Sam, I'm using your latest version, and I think I found a bug: If a product model starts with 0, when we restore the database, the product model looses the starting 0. I checked the SQL and the correct product model is there, so the problem should be the database restore... For example, if the product model is 012345, when we restore the database it will become 12345. Can you have a look? I tried to check the code but I don't understand where the issue is... Br Quote Link to comment Share on other sites More sharing options...
pedro.antunes Posted January 21, 2013 Share Posted January 21, 2013 My issue was with Auto Backup Database contribution, not with this one. I fixed it and uploaded file to: http://addons.oscommerce.com/info/2314 as I can't upload to the spooks location. Quote Link to comment Share on other sites More sharing options...
mhsuffolk Posted December 9, 2013 Share Posted December 9, 2013 Used this to great effect on my RC2a store. Now I have installed it in my test 2.3 store and the backups it creates do not contain the Create Table command after the Drop table if exists command. I have this on a local host. Extract of backup below. The RC2a local host version still works correctly. Any ideas please. Martin # Backup Date: 12/08/2013 11:02:32 # Backed up tables: action_recorder, address_book, address_format, administrators, banners, banners_history, categories, categories_description, configuration, configuration_group, counter, counter_history, countries, currencies, customers, customers_basket, customers_basket_attributes, customers_info, geo_zones, information, information_group, languages, manufacturers, manufacturers_info, newsletters, orders, orders_products, orders_products_attributes, orders_products_download, orders_status, orders_status_history, orders_total, products, products_attributes, products_attributes_download, products_description, products_images, products_notifications, products_options, products_options_values, products_options_values_to_products_options, products_to_categories, reviews, reviews_description, sec_directory_whitelist, sessions, specials, tax_class, tax_rates, whos_online, zones, zones_to_geo_zones drop table if exists `action_recorder`; ; insert into `action_recorder` (`id`, `module`, `user_id`, `user_name`, `identifier`, `success`, `date_added`) values ('1','ar_admin_login','0','mhvideos','','0','2013-12-03 15:31:29'), ('2','ar_admin_login','0','mhvideos','','0','2013-12-03 15:31:39'), ('3','ar_admin_login','0','mhvideos','','0','2013-12-03 15:35:30'), ('4','ar_admin_login','0','mhvideos','','0','2013-12-03 15:35:53'), ('5','ar_admin_login','2','mhvideos','','1','2013-12-03 16:04:00'), ('6','ar_admin_login','0','mhvideos','','0','2013-12-06 17:29:12'), ('7','ar_admin_login','2','mhvideos','','1','2013-12-06 17:29:37'), ('8','ar_admin_login','2','mhvideos','','1','2013-12-06 18:01:32'), ('9','ar_admin_login','2','mhvideos','','1','2013-12-08 10:23:47'); drop table if exists `address_book`; ; insert into `address_book` (`address_book_id`, `customers_id`, `entry_gender`, `entry_company`, `entry_firstname`, `entry_lastname`, `entry_street_address`, `entry_suburb`, `entry_postcode`, `entry_city`, `entry_state`, `entry_country_id`, `entry_zone_id`) values Quote Live shop Phoenix 1.0.8.4 on PHP 7.4 Working my way up the versions. Link to comment Share on other sites More sharing options...
mhsuffolk Posted January 1, 2014 Share Posted January 1, 2014 Any ideas anybody? Martin Quote Live shop Phoenix 1.0.8.4 on PHP 7.4 Working my way up the versions. Link to comment Share on other sites More sharing options...
kru Posted March 6, 2014 Share Posted March 6, 2014 (edited) Used this to great effect on my RC2a store. Now I have installed it in my test 2.3 store and the backups it creates do not contain the Create Table command after the Drop table if exists command. I have this on a local host. Extract of backup below. The RC2a local host version still works correctly. Any ideas please. Martin He posted a link to a version specific to 2.3 one page back in this thread, I believe. Maybe you should check there. Perhaps there are additional changes for 2.3 that you will not find in the 2.2 thread... Edited March 6, 2014 by kru Quote Add-Ons personally installed:Step by Step Manual Order -- Request Reviews -- Reviews in Product Listing -- Reviews in Product Display -- Review Approval System -- Leverage Browser Cache --Header Tag Controller -- Multilayer SEO Pop Out Menu -- Follow Us Box -- View All Products -- USPS Shipping Labels -- UPS Shipping Labels -- Monthly Sales/Tax Report --htacess Optimisation -- Remove Unused Images -- Master Password -- Admin Change Customer Password -- Database Backup Manager -- Zero Stock Report --Searchbox Search In Descriptions -- Easy Populate 2.76i -- Barcode Rendering -- Admin Sort By Model -- Products Purchased ReportAdd-Ons personally developed:Search for email address, etc in Orders -- Discontinue ProductAdd-Ons installed by others:View Counter -- Site Monitor -- Image Thumbnailer -- Database Optimizer -- Recaptcha -- Discount Coupons -- Add More Fields Link to comment Share on other sites More sharing options...
Cheloki Posted May 25, 2014 Share Posted May 25, 2014 (edited) Hello: My problem is that it gives me the following error when trying to install and make a copy of the database. The version I am using oscommerce is v2.3.3.4 : Thanks for the help Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/www/xxxx.com/admin/backup.php on line 210 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/xxxx.com/admin/backup.php on line 183 Warning: Cannot modify header information - headers already sent by (output started at /home/www/xxxx.com/admin/backup.php:210) in /home/www/xxxx.com/admin /includes/functions/general.php on line 38 Edited May 25, 2014 by Cheloki Quote Link to comment Share on other sites More sharing options...
Guest Posted November 14, 2014 Share Posted November 14, 2014 Hello: My problem is that it gives me the following error when trying to install and make a copy of the database. The version I am using oscommerce is v2.3.3.4 : Thanks for the help Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/www/xxxx.com/admin/backup.php on line 210 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/xxxx.com/admin/backup.php on line 183 Warning: Cannot modify header information - headers already sent by (output started at /home/www/xxxx.com/admin/backup.php:210) in /home/www/xxxx.com/admin /includes/functions/general.php on line 38 I am having the same issue. This happened when we made the upgrade to php 5.5. Any ideas? Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted November 16, 2014 Share Posted November 16, 2014 You need to upgrade the contribution to work with 5.5. The functions to access the db have changed. HTH G Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Irin Posted December 20, 2014 Share Posted December 20, 2014 Hello, I have a problem with restoring a previously saved database. It only gives the message below: 1065 - Query was empty;[TEP STOP] Also, when I click Email button, it gives the message below. No email is sent. Warning, PEAR Mail not found or insufficient to email backup, reverting to standard mail function. Backup db_201412201511.sql sent by email OK How can I fix it? Thanks in advance. Quote Link to comment Share on other sites More sharing options...
4vrij Posted March 7, 2015 Share Posted March 7, 2015 (edited) @fourmat and @Cheloki catalog\admin\includes\functions\db_backup.php find line 34: if (strlen($a_name) && $a_name !== '*') { return '`' . str_replace('`', '``', $a_name) . '`'; Replace by: if ( is_string($value) && (strlen($a_name)) && $a_name !== '*') { return '`' . str_replace('`', '``', $a_name) . '`'; Edited March 7, 2015 by 4vrij Quote Link to comment Share on other sites More sharing options...
4vrij Posted March 7, 2015 Share Posted March 7, 2015 @fourmat and @Cheloki And in catalog\admin\backup.php line 108 $strlener_of_tables_backed_up_now = 0; to $counter_of_tables_backed_up_now = 0; line 138 $no_of_tables = strlen($tables); $no_of_tables_for_backup = strlen($_POST['dbtable']); to $no_of_tables = count($tables); $no_of_tables_for_backup = count($_POST['dbtable']); Quote Link to comment Share on other sites More sharing options...
pmsmiers Posted January 15, 2016 Share Posted January 15, 2016 Everything looks like it's working except for the restore function. When I select the file which I would like to restore and press restore I get the following error : 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1);[TEP STOP] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.