mayid Posted February 3, 2011 Share Posted February 3, 2011 I don't know what's going on, but i just cannot see my prestashop installation in remote host. We are under construction, and trying to import products from a csv. Anyway, i don't thinks that the cause of the issue. I'm just seeing neverending garbage instead of the page itself! ('1') ('1'), ('1','0'), ('1','0','0','1','2011-01-07 01:15:43','2011-01-07 01:15:43'), ('1','0','0',NULL,'1','0','0','0','0'), ('1','0','1','1','2011-01-07 01:15:43') ('1','0','1','lightblue','1','0','0','0'), ('1','0','AdminCatalog',NULL,'1'), ('1','0','index.php'), ('1','0.00','0','2011-01-07 01:15:43','2011-01-07 01:15:43') ('1','1') ('1','1'), ('1','1','1','1','1','1'), ('1','1','26'), ('1','1','2GB'), ('1','1','Administrator'), ('1','1','Awaiting cheque payment','cheque'), ('1','1','Catalog'), ('1','1','DE','1','0','0'), ('1','1','Default'), ('1','1','Discount on order (%)'), ('1','1','Disk space','Disk space'), ('1','1','Germany'), ('1','1','Height'), ('1','1','Home'), ('1','1','Home',NULL,'home',NULL,NULL,NULL), ('1','1','Pack 5€ de Descuento'), ('1','1','Pick up in-store'), ('1','1','VAT 19.6%'), ('1','1','Waiting for confirmation'), ('1','1',NULL), ('1','10','1','1','1','1'), ('1','10','Manufacturers'), ('1','11','0'), ('1','11','1','1','1','1'), ('1','11','Attributes and groups'), ('1','12','1','1','1','1'), ('1','12','Addresses'), ('1','13','1','1','1','1'), ('1','13','Statuses'), ('1','14','1','1','1','1'), ('1','14','Vouchers'), ('1','15','1','1','1','1'), ('1','15','Currencies'), ('1','16','1','1','1','1'), ('1','16','Taxes'), ('1','17','1','1','1','1'), ('1','17','Carriers'), ('1','18','1','1','1','1'), ('1','18','Countries'), ('1','19','1','1','1','1'), ('1','19','Zones'), ('1','19.600'), ('1','2','0.000000','10000.000000') ('1','2','1','1','1','1'), ('1','2','18'), ('1','2','2Go'), ('1','2','Accueil'), ('1','2','Accueil',NULL,'home',NULL,NULL,NULL), ('1','2','Allemagne'), ('1','2','Capacité','Capacité'), ('1','2','Customers'), ('1','2','Défaut'), ('1','2','En attente de confirmation'), ('1','2','En attente du paiement par chèque','cheque'), ('1','2','Hauteur'), ('1','2','Pack 5€ de Descuento'), ('1','2','Réduction sur la commande (%)'), ('1','2','Retrait au magasin'), ('1','2','TVA 19.6%'), ('1','2',NULL,'1','1','5.00'), ('1','20','1','1','1','1'), ('1','20','Price ranges'), ('1','2011-01-07 00:00:00','2011-01-07 23:59:59'), ('1','2011-01-07 01:15:43') ('1','21','1','1','1','1'), ('1','21','2','Alabama','AL','0','1'), ('1','21','Weight ranges'), ('1','22','1','1','1','1'), ('1','22','Positions'), ('1','23','1','1','1','1'), ('1','23','Database'), ('1','24','1','1','1','1'), ('1','24','Email'), ('1','26','1','1','1','1'), ('1','26','Image'), ('1','27','1','1','1','1'), ('1','27','Products'), ('1','28','1','1','1','1'), ('1','28','Contacts'), ('1','29','1','1','1','1'), ('1','29','Employees'), ('1','3','1','1','1','1'), ('1','3','14'), ('1','3','2Go'), ('1','3','Alemania'), ('1','3','Alto'), ('1','3','Capacidad','Capacidad'), ('1','3','Descuento orden (%)'), ('1','3','En espera de pago por cheque','cheque'), ('1','3','Inicio'), ('1','3','Inicio',NULL,'home',NULL,NULL,NULL), ('1','3','IVA 19.6%'), ('1','3','Orders'), ('1','3','Pack 5€ de Descuento') ('1','3','Pendiente de confirmación'), ('1','3','Predeterminado') ('1','3','Recogida en la tienda'), ('1','30','1','1','1','1'), ('1','30','Profiles'), ('1','31','1','1','1','1'), ('1','31','Permissions'), ('1','32','1','1','1','1'), ('1','32','Languages'), ('1','33','1','1','1','1'), ('1','33','Translations'), ('1','34','1','1','1','1'), ('1','34','Suppliers'), ('1','35','1','1','1','1'), ('1','35','Tabs'), ('1','36','1','1','1','1'), ('1','36','Features'), ('1','37','1','1','1','1'), ('1','37','Quick Accesses'), ('1','38','1','1','1','1'), ('1','38','Appearance'), ('1','39','1','1','1','1'), ('1','39','Contact'), ('1','4','1','1','1','1'), ('1','4','Payment'), ('1','40','1','1','1','1'), ('1','40','Aliases'), ('1','404'), ('1','41','1','1','1','1'), ('1','41','Import'), ('1','42','1','1','1','1'), ('1','42','Invoices'), ('1','43','1','1','1','1'), ('1','43','Search'), ('1','44','1','1','1','1'), ('1','44','Localization'), ('1','46','1','1','1','1'), ('1','46','States'), This keeps going and going, loading...If i look into "categories", all these is inserted there. 3956 record!!! Someone attacked our site? Or the csv import messed all up? We are just inserting five products! However, in localhost all goes ok. Help please. Link to comment Share on other sites More sharing options...
mayid Posted February 3, 2011 Author Share Posted February 3, 2011 Could you please guys move this thread to the security area? The problem is severe.I have 3920 records and i don't know how the get there. I made a mysql dump of all tables related to "categories", and take a look at these entries. INSERT INTO ps_category_lang VALUES ('1562', '1', 'CREATE TABLE `pshop_customization_field_lang` (', '', 'create-table-pshopcustomizationfieldlang-', '', '', ''); INSERT INTO ps_category_lang VALUES ('1562', '2', 'CREATE TABLE `pshop_customization_field_lang` (', '', 'create-table-pshopcustomizationfieldlang-', '', '', ''); INSERT INTO ps_category_lang VALUES ('1562', '3', 'CREATE TABLE `pshop_customization_field_lang` (', '', 'create-table-pshopcustomizationfieldlang-', '', '', ''); INSERT INTO ps_category_lang VALUES ('1563', '1', '`id_customization_field` int(10) unsigned NOT NULL,', '', 'idcustomizationfield-int10-unsigned-not-null', '', '', ''); INSERT INTO ps_category_lang VALUES ('1563', '2', '`id_customization_field` int(10) unsigned NOT NULL,', '', 'idcustomizationfield-int10-unsigned-not-null', '', '', ''); INSERT INTO ps_category_lang VALUES ('1563', '3', '`id_customization_field` int(10) unsigned NOT NULL,', '', 'idcustomizationfield-int10-unsigned-not-null', '', '', ''); INSERT INTO ps_category_lang VALUES ('1564', '1', '`name` varchar(255) NOT NULL,', '', 'name-varchar255-not-null', '', '', ''); INSERT INTO ps_category_lang VALUES ('1564', '2', '`name` varchar(255) NOT NULL,', '', 'name-varchar255-not-null', '', '', ''); INSERT INTO ps_category_lang VALUES ('1564', '3', '`name` varchar(255) NOT NULL,', '', 'name-varchar255-not-null', '', '', ''); INSERT INTO ps_category_lang VALUES ('1565', '1', 'PRIMARY KEY (`id_customization_field`,`id_lang`)', '', 'primary-key--idcustomizationfieldidlang', '', '', ''); INSERT INTO ps_category_lang VALUES ('1565', '2', 'PRIMARY KEY (`id_customization_field`,`id_lang`)', '', 'primary-key--idcustomizationfieldidlang', '', '', ''); INSERT INTO ps_category_lang VALUES ('1565', '3', 'PRIMARY KEY (`id_customization_field`,`id_lang`)', '', 'primary-key--idcustomizationfieldidlang', '', '', ''); INSERT INTO ps_category_lang VALUES ('1566', '1', '/* Scheme for table pshop_customized_data */', '', '-scheme-for-table-pshopcustomizeddata-', '', '', ''); INSERT INTO ps_category_lang VALUES ('1566', '2', '/* Scheme for table pshop_customized_data */', '', '-scheme-for-table-pshopcustomizeddata-', '', '', ''); INSERT INTO ps_category_lang VALUES ('1566', '3', '/* Scheme for table pshop_customized_data */', '', '-scheme-for-table-pshopcustomizeddata-', '', '', ''); INSERT INTO ps_category_lang VALUES ('1567', '1', 'CREATE TABLE `pshop_customized_data` (', '', 'create-table-pshopcustomizeddata-', '', '', ''); INSERT INTO ps_category_lang VALUES ('1567', '2', 'CREATE TABLE `pshop_customized_data` (', '', 'create-table-pshopcustomizeddata-', '', '', ''); INSERT INTO ps_category_lang VALUES ('1567', '3', 'CREATE TABLE `pshop_customized_data` (', '', 'create-table-pshopcustomizeddata-', '', '', ''); INSERT INTO ps_category_lang VALUES ('1568', '1', '`id_customization` int(10) unsigned NOT NULL,', '', 'idcustomization-int10-unsigned-not-null', '', '', ''); INSERT INTO ps_category_lang VALUES ('1568', '2', '`id_customization` int(10) unsigned NOT NULL,', '', 'idcustomization-int10-unsigned-not-null', '', '', ''); It's so weird. And i'm afraid of this. The CSV importer couldn't have anything to do with it, could it? Link to comment Share on other sites More sharing options...
Recommended Posts