Jump to content

IBICO

Members
  • Posts

    138
  • Joined

  • Last visited

Everything posted by IBICO

  1. Well. The picture changed when choosing French, but not Italian and German.. So why is that? Is this theme code related?
  2. I have this code though.. I got both text and link to a picture. Guess I need to put somewhere that is English and is also English, while and are French and so on. http://www.augdal.net/modules/uhufeatured/images/bayonetta_010410.jpg http://www.augdal.net/modules/uhufeatured/images/bayonetta_010410t.jpg http://www.augdal.net/product.php?id_product=244 <titleGoToURI>http://www.augdal.net/product.php?id_product=244</titleGoToURI> http://www.augdal.net/product.php?id_product=244 http://www.augdal.net/product.php?id_product=244 http://www.augdal.net/product.php?id_product=244 <title>G&G;G2010</title> Scope version in beautiful TAN. Solid piece of engineering made of Aluminum/Nylon/Fiber/Zinc/Plastic/Stainless Watch watchIcon
  3. Yeah.. This is lot better. now that I know what to look for when I edit. This would also maybe make the webshop work better without delay since bug in codes might slow or disable your shop. Still got lot of loading time for my webshop, but after checking my products one, by one I found lot of things like this I have to correct. Lot of work, but I guess the result would be an improved shop.
  4. ooh.. sweet. Why is this not implemented in the webshop itself so you could upload pictures after language in Home text editor and other places instead of having to add custom codes?.. would be a LOT better for those not so skillful in coding.
  5. I had multiple errors. I had to rebuild the whole webshop from scratch. 3rd day and still working on it. I got that error list I posted last when I did a FRESH install. Not while installing, but when I checked the SQL database from PhPMyAdmin.. so a bit strange..
  6. I got the latest version and I can`t get the taxes removed at all.. I try to both enable and disable but nothing happen. Still say Tax incl.
  7. I installed the Ajax sliding category now since I read about it here, but having a problem where a > symbol is showing inside the menu text. I was thinking it was the Navigation pipe: > but after removing it I still get it showing inside the text. Could it be that it is not really removed even if I did it in backoffice?
  8. Is it possible to add photos in the webshop and have them change according to what language you have when browsing the webshop? I know text is possible in homeeditor and products, but what about pictures? I have pictures/ads with text on them
  9. After I upgraded I get this message when going in to a product and try to change text or other and then press save. what could it be?
  10. I have a problem almost similar to yours after upgrade.. all my images vanished. Even when I upload the images to the site I get no images shown on the product.. only that "no image" one.
  11. Did not restore when I tried. So that would be the backup of my unstable 1.3.2 upgrade also missed the cms. Could I import the CMS files from my 1.2.5 backup?.. would the tables for CMS and CMS_LANG be the same?
  12. Where is the file that include Terms of service and all the other CMS stuff? I had to rebuild my database and are now adding back parts of the webshop, but I need my old Terms of service, Legal notice, About us and all that.. How do I restore it?.. I have backed up both my old sql and files that was on the server before the crash, so I should have all my files I need
  13. I also got lot`s of error when upgrading my prestashop to latest. Even when I do a fresh install I notice lot of error rapport in SQL. Problems with indexes of table `ps_category_group` More than one INDEX key was created for column `id_category` Problems with indexes of table `ps_customer` PRIMARY and INDEX keys should not both be set for column `id_customer` UNIQUE and INDEX keys should not both be set for column `email` Problems with indexes of table `ps_customer_group` PRIMARY and INDEX keys should not both be set for column `id_customer` Problems with indexes of table `ps_employee` PRIMARY and INDEX keys should not both be set for column `id_employee` Problems with indexes of table `ps_hook_module` PRIMARY and INDEX keys should not both be set for column `id_module` Problems with indexes of table `ps_image` UNIQUE and INDEX keys should not both be set for column `id_product` More than one INDEX key was created for column `id_product` Problems with indexes of table `ps_image_lang` UNIQUE and INDEX keys should not both be set for column `id_image` Problems with indexes of table `ps_module_currency` PRIMARY and INDEX keys should not both be set for column `id_module` Problems with indexes of table `ps_order_detail` More than one INDEX key was created for column `id_order` Problems with indexes of table `ps_product_attribute` PRIMARY and INDEX keys should not both be set for column `id_product_attribute` More than one INDEX key was created for column `id_product`
  14. This only work if you bill someone according to what the item cost.. And normally you bill them according to what a product weigh.
  15. I need something similar.. I have free shipping for over 200usd, but only with EMS. If they choose Fedex/UPS it should not be free. Don`t seems that prestashop support this option :-( Maybe I need to change to other shopping software
  16. FINALLY.. I removed ALL modules and there I suddenly saw the banner. Then tried to install each module one by one.. the first fucker that made it all go wrong is this one.. When I added the RSS feed, all got blank.. RSS feed block v1.0 Adds a block displaying an RSS feed augdal_net10_04_2010.sql.zip
  17. Yeah..Might change later, but for now it don`t solve my problem. I have found out that it is the sql that have lot of errors somehow. So I have backed up each tablet when logged in at https://dbadmin.one.com so I have now backed up each tablet. Then I installed a fresh installed Prestashop webshop and then backed up each tablet from this one also. Both 1.2.5.0. So now I am comparing each tablet to find errors. I have found some and while comparing both original and my backed up I THINK I am able to repair some tablets. PS!! I get many of these around.. This correct or???: More than one INDEX key was created for column `id_product`
  18. I fixed my bad SQL.. Backed up the PS2Subdomain fil and then edited it to PS_Subdomain.. Also edited all text inside the file to PS_Subdomain. Then dropped(deleted) the row called PS_Subdomain in my sql and imported my edited export file. Now Backoffice do work, but not my front office. I guess this is because they run a php version prestashop do not support?
  19. Here is a printscreen from an earlier attempt on installing prestashop that is still in the sql. The only differ I could see is that this line have 1 instead of my 0. PRIMARY PRIMARY 1 Edit Drop id_subdomain
  20. From what I understand, the change Subdomain is not related to what is on my webserver, but rather in the sql server. I have backup from my webserver, but I have not understood much on how to serve and backup my sql server. But I did find a place in the sql that said: PS_Subdomain ..
  21. Seems one.com might have downgraded the php server now. But now I am f*cked.. I did the same shit like this dude. Removed subdomain earlier because I thought it was a fault. http://www.prestashop.com/bug_tracker/view/error_message_bad_subdomain_sql_query/
  22. SET NAMES 'utf8' /* ##################################### */ /* STRUCTURE */ /* ##################################### */ ALTER TABLE `ps_product` CHANGE `reduction_from` `reduction_from` DATE NOT NULL DEFAULT '1970-01-01', CHANGE `reduction_to` `reduction_to` DATE NOT NULL DEFAULT '1970-01-01' ALTER TABLE `ps_order_detail` CHANGE `tax_rate` `tax_rate` DECIMAL(10, 3) NOT NULL DEFAULT '0.000' ALTER TABLE `ps_group` ADD `price_display_method` TINYINT NOT NULL DEFAULT 0 AFTER `reduction` (1060) Duplicate column name 'price_display_method' CREATE TABLE `ps_carrier_group` ( `id_carrier` int(10) unsigned NOT NULL, `id_group` int(10) unsigned NOT NULL, UNIQUE KEY `id_carrier` (`id_carrier`,`id_group`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 (1050) Table 'ps_carrier_group' already exists ALTER TABLE `ps_country` ADD `need_identification_number` TINYINT( 1 ) NOT NULL (1060) Duplicate column name 'need_identification_number' ALTER TABLE `ps_customer` ADD `dni` VARCHAR( 16 ) NULL AFTER `firstname` (1060) Duplicate column name 'dni' ALTER TABLE `ps_image` ADD INDEX `product_position` (`id_product`, `position`) (1061) Duplicate key name 'product_position' ALTER TABLE `ps_hook_module` ADD INDEX `id_module` (`id_module`) (1061) Duplicate key name 'id_module' ALTER TABLE `ps_customer` ADD INDEX `id_customer_passwd` (`id_customer`, `passwd`) (1061) Duplicate key name 'id_customer_passwd' ALTER TABLE `ps_tag` ADD INDEX `id_lang` (`id_lang`) (1061) Duplicate key name 'id_lang' ALTER TABLE `ps_customer_group` ADD INDEX `id_customer` (`id_customer`) (1061) Duplicate key name 'id_customer' ALTER TABLE `ps_category_group` ADD INDEX `id_category` (`id_category`) (1061) Duplicate key name 'id_category' ALTER TABLE `ps_image` ADD INDEX `id_product_cover` (`id_product`, `cover`) (1061) Duplicate key name 'id_product_cover' ALTER TABLE `ps_employee` ADD INDEX `id_employee_passwd` (`id_employee`, `passwd`) (1061) Duplicate key name 'id_employee_passwd' ALTER TABLE `ps_product_attribute` ADD INDEX `product_default` (`id_product`, `default_on`) (1061) Duplicate key name 'product_default' ALTER TABLE `ps_product_download` ADD INDEX `product_active` (`id_product`, `active`) (1061) Duplicate key name 'product_active' ALTER TABLE `ps_tab` ADD INDEX `class_name` (`class_name`) (1061) Duplicate key name 'class_name' ALTER TABLE `ps_module_currency` ADD INDEX `id_module` (`id_module`) (1061) Duplicate key name 'id_module' ALTER TABLE `ps_product_attribute_combination` ADD INDEX `id_product_attribute` (`id_product_attribute`) (1061) Duplicate key name 'id_product_attribute' ALTER TABLE `ps_orders` ADD INDEX `invoice_number` (`invoice_number`) (1061) Duplicate key name 'invoice_number' ALTER TABLE `ps_product_tag` ADD INDEX `id_tag` (`id_tag`) (1061) Duplicate key name 'id_tag' ALTER TABLE `ps_cms_lang` CHANGE `id_cms` `id_cms` INT(10) UNSIGNED NOT NULL ALTER TABLE `ps_tax` CHANGE `rate` `rate` DECIMAL(10, 3) NOT NULL ALTER TABLE `ps_order_detail` ADD `discount_quantity_applied` TINYINT(1) NOT NULL DEFAULT 0 AFTER `ecotax` (1060) Duplicate column name 'discount_quantity_applied' ALTER TABLE `ps_orders` ADD `total_products_wt` DECIMAL(10, 2) NOT NULL AFTER `total_products` (1060) Duplicate column name 'total_products_wt' /* ##################################### */ /* CONTENTS */ /* ##################################### */ UPDATE `ps_group` SET `price_display_method` = (SELECT `value` FROM `ps_configuration` WHERE `name` = 'PS_PRICE_DISPLAY') UPDATE `ps_configuration` SET `value` = ROUND(value / (1 + ( SELECT rate FROM ( SELECT t.`rate`, COUNT(*) n FROM `ps_orders` o LEFT JOIN `ps_carrier` c ON (o.`id_carrier` = c.`id_carrier`) LEFT JOIN `ps_tax` t ON (t.`id_tax` = c.`id_tax`) WHERE c.`deleted` = 0 AND c.`shipping_handling` = 1 GROUP BY o.`id_carrier` ORDER BY n DESC LIMIT 1 ) myrate ) / 100), 6) WHERE `name` = 'PS_SHIPPING_HANDLING' DELETE FROM `ps_configuration` WHERE `name` = 'PS_PRICE_DISPLAY' DELETE FROM `ps_product_attachment` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`) DELETE FROM `ps_discount_quantity` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`) DELETE FROM `ps_pack` WHERE `id_product_pack` NOT IN (SELECT `id_product` FROM `ps_product`) OR `id_product_item` NOT IN (SELECT `id_product` FROM `ps_product`) DELETE FROM `ps_product_sale` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`) DELETE FROM `ps_scene_products` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`) DELETE FROM `ps_search_index` WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product`) DELETE FROM `ps_search_word` WHERE `id_word` NOT IN (SELECT `id_word` FROM `ps_search_index`) DELETE FROM `ps_tag` WHERE `id_lang` NOT IN (SELECT `id_lang` FROM `ps_lang`) DELETE FROM `ps_search_word` WHERE `id_lang` NOT IN (SELECT `id_lang` FROM `ps_lang`) INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PRESTASTORE_LIVE', 1, NOW(), NOW()), ('PS_SHOW_ALL_MODULES', 0, NOW(), NOW()), ('PS_BACKUP_ALL', 0, NOW(), NOW()), ('PS_1_3_UPDATE_DATE', NOW(), NOW(), NOW()), ('PS_PRICE_ROUND_MODE', 2, NOW(), NOW()) (1062) Duplicate entry 'PRESTASTORE_LIVE' for key 2 INSERT INTO `ps_hook` (`name`, `title`, `description`, `position`) VALUES ('createAccountTop', 'Block above the form for create an account', NULL , '1'), ('backOfficeHeader', 'Administration panel header', NULL , '0'), ('backOfficeTop', 'Administration panel top hover the tabs', NULL , '1'), ('backOfficeFooter', 'Administration panel footer', NULL , '1') (1062) Duplicate entry 'createAccountTop' for key 2 INSERT INTO `ps_carrier_group` (id_carrier, id_group) (SELECT id_carrier, id_group FROM ps_carrier c, ps_group g WHERE c.active = 1) (1062) Duplicate entry '1-1' for key 1 /* PHP */ /* PHP:convert_product_price(); */ SET NAMES 'utf8' /* ####################################
  23. I think it is this one.. Not sure. I need a Norwegian/Scandinavian host that is reliable.. Looked at multihost and isp1.no, but not sure how good they are. Change the txt to .gz I tried to upgrade again and came almost to the end.. Got this message: Congratulations! Update is finished! Unfortunately, 24 SQL errors have occurred. When going to frontoffice : Bad SubDomain SQL query! latest.log.txt
  24. Have been looking for others also, but need free monthly traffic and low monthly cost :-( http://www.nsdesign.co.uk/ seems to have limited traffic and I would probably need to pay extra if I exceed.
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More