Stoffwunsch Posted April 25, 2014 Share Posted April 25, 2014 Hi all. Workin with 1.6 I checked the DB in phpmyadmin and saw that in the table "ps_product_download " one product has 6.342.322 entries! My server ist totally overloaded and i also dont know, if this product (.zip - data package) ist uploaded also this much. Can please anyone give me a tip, how to manage this. I dont want to delete just all entries and crash some links to other tables or something like that. Thanks Picture is from DB for first look. Link to comment Share on other sites More sharing options...
eburgaz Posted April 25, 2014 Share Posted April 25, 2014 Hello! How you can do this? I LIKE IT You how to delete so much from your database, if you dont you cant work of your site. 1 Link to comment Share on other sites More sharing options...
Stoffwunsch Posted April 25, 2014 Author Share Posted April 25, 2014 Think it happens when using "copy product". Link to comment Share on other sites More sharing options...
Stoffwunsch Posted April 25, 2014 Author Share Posted April 25, 2014 Saw on the server that in /download there are 8651 files (.htaccess) Seems a bit too much for me too.. (I still uploaded 63) The entries in the DB are also not shown in the Backend. There everything is fine. So it seems that the 6.342.322 entries are dead entries. Link to comment Share on other sites More sharing options...
eburgaz Posted April 26, 2014 Share Posted April 26, 2014 Maybe dead entries but not empty, is it? Saw on the server that in /download there are 8651 files (.htaccess) Seems a bit too much for me too.. (I still uploaded 63) The entries in the DB are also not shown in the Backend. There everything is fine. So it seems that the 6.342.322 entries are dead entries. Link to comment Share on other sites More sharing options...
Stoffwunsch Posted April 26, 2014 Author Share Posted April 26, 2014 Maybe dead entries but not empty, is it? Yes, not empty. Totally about 860 MB in the DB! 1 Link to comment Share on other sites More sharing options...
Stoffwunsch Posted April 26, 2014 Author Share Posted April 26, 2014 Are the .zip files saved as .htacces files in /download ? Can anyone tell me? I am working on a script to delete all this files. But not the files of the other products. Link to comment Share on other sites More sharing options...
NemoPS Posted April 26, 2014 Share Posted April 26, 2014 Seems pretty weird. My suggestion is to make a backup copy of the default folder and table, and empty both Link to comment Share on other sites More sharing options...
Stoffwunsch Posted April 26, 2014 Author Share Posted April 26, 2014 Seems pretty weird. My suggestion is to make a backup copy of the default folder and table, and empty both I would, but firefox always crashes, when i try to make a backup of the DB. Problem is, i still have other products running and just want to delete the files of the dead link, not of the running other products. :| Link to comment Share on other sites More sharing options...
NemoPS Posted April 26, 2014 Share Posted April 26, 2014 have you tried exporting that single table alone? Link to comment Share on other sites More sharing options...
Stoffwunsch Posted April 26, 2014 Author Share Posted April 26, 2014 No, but so much entries seems to be too much.. And it doesnt solve the problem of deleting only the dead entries and files.. Link to comment Share on other sites More sharing options...
Stoffwunsch Posted April 26, 2014 Author Share Posted April 26, 2014 isn't it possible to run a php script with a mysql-query and while order to delete the files first? Something like "SELECT ..." While ( ... unlink (filename) ) ? Would be the easiest way for me in the moment.. Link to comment Share on other sites More sharing options...
NemoPS Posted April 26, 2014 Share Posted April 26, 2014 you can use DELETE FROM... WHERE... for example where display_filename = "monster3.zip" Link to comment Share on other sites More sharing options...
Stoffwunsch Posted April 26, 2014 Author Share Posted April 26, 2014 Yes, but that does not delete the files (.htacces) in /download. Or am i wrong? Is there an option to delete files by an sql-query? Link to comment Share on other sites More sharing options...
musicmaster Posted April 27, 2014 Share Posted April 27, 2014 Nope, sql is only for the database. But you can select specific files with your FTP program and then delete them all. In Filezilla this is in the menu under Server->find external files. 1 Link to comment Share on other sites More sharing options...
NemoPS Posted April 28, 2014 Share Posted April 28, 2014 Exactly, sql only affects database. To erase file you have to use an ftp client (or ssh, or file manager from your control panel) Link to comment Share on other sites More sharing options...
Recommended Posts