thecustomshop Posted May 4, 2007 Share Posted May 4, 2007 If you select any of the below, you receive the corresponding error. I understand its more then likely its from an admin control panel contribution that I had attempted to install, and then removed. And like an idiot, I had not backed up recently enough. But is there a way to replace the missing tables? Admin>Customers 1146 - Table 'c3683_oscom.table_admin_files' doesn't exist select admin_files_name from TABLE_ADMIN_FILES where FIND_IN_SET( '', admin_groups_id) and admin_files_is_boxes = '0' and admin_files_name = 'customers.php' Admin>Locations/Taxes 1146 - Table 'c3683_oscom.table_admin_files' doesn't exist select admin_files_name from TABLE_ADMIN_FILES where FIND_IN_SET( '', admin_groups_id) and admin_files_is_boxes = '0' and admin_files_name = 'countries.php' Admin>Localization 1146 - Table 'c3683_oscom.table_admin_files' doesn't exist select admin_files_name from TABLE_ADMIN_FILES where FIND_IN_SET( '', admin_groups_id) and admin_files_is_boxes = '0' and admin_files_name = 'currencies.php' Admin>Reports 1146 - Table 'c3683_oscom.table_admin_files' doesn't exist select admin_files_name from TABLE_ADMIN_FILES where FIND_IN_SET( '', admin_groups_id) and admin_files_is_boxes = '0' and admin_files_name = 'stats_products_viewed.php' Admin>Tools 1146 - Table 'c3683_oscom.table_admin_files' doesn't exist select admin_files_name from TABLE_ADMIN_FILES where FIND_IN_SET( '', admin_groups_id) and admin_files_is_boxes = '0' and admin_files_name = 'backup.php' Link to comment Share on other sites More sharing options...
thecustomshop Posted May 4, 2007 Author Share Posted May 4, 2007 Bump for assistance! Link to comment Share on other sites More sharing options...
Guest Posted May 4, 2007 Share Posted May 4, 2007 Hello Jason Why don't you just install the oscommerce.sql file again? Link to comment Share on other sites More sharing options...
thecustomshop Posted May 4, 2007 Author Share Posted May 4, 2007 Hello Jason Why don't you just install the oscommerce.sql file again? I compared the two files (the original versus mine) and see no differences. I will have to reinstall two contributions, but may be less stress then banging my head on this now. Link to comment Share on other sites More sharing options...
thecustomshop Posted May 5, 2007 Author Share Posted May 5, 2007 Anyone have any other thoughts? Link to comment Share on other sites More sharing options...
thecustomshop Posted May 7, 2007 Author Share Posted May 7, 2007 Other things I can try? Link to comment Share on other sites More sharing options...
thecustomshop Posted May 7, 2007 Author Share Posted May 7, 2007 I attempted to do a restore from the original SQL database, and would just reinstall the two previous contribution. Unfortunatly, while attempting to restore the database, I continuously get an error. Example: MySQL said: #1050 - Table 'address_book' already exists Link to comment Share on other sites More sharing options...
thecustomshop Posted May 7, 2007 Author Share Posted May 7, 2007 Resolved the original issue. Had to replace the modified admin/includes/boxes files with originals. Problem solved. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.