Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

xperyens

Archived
  • Posts

    34
  • Joined

  • Last visited

Profile Information

  • Real Name
    cezar darac

xperyens's Achievements

  1. Hi all. Maybe i didn't was very specific. My problem it's located here: http://www.multiservice-canon.ro/multiserv...mxm2-p-247.html . You should see there the product's photo, description when it was added to my store and a link to the product's homepage (to read more about the product from the manufacturer but not a manufacturer link like www.canon.com but a link to product's description like www.canon.com/product/name/). My link from my store look's like that: http://www.multiservice-canon.ro/multiserv...eID%3D26346%231 . Now you can see that Chemo's contrib also rewrite that external link and the link is broken. I need a sugestion on this one. Thank's in advance, Cezar.
  2. Hi. I've installed chemo seo url's. Everything is working just fine but a small problem. When you add a product you can add tha manufacturer url (for that product). Now the problem is, in front end, when i click the url my browser can't find that page because the rewrite function also rewrite that url. Any idea would be great. Thank's in advance, Cezar.
  3. Hello everybody. Well, i've got another problem here. I don't use an on-line payment module. I use only Payment @ delivery. My web site was working ok. Then i've tried to optimize my files for search engine. I've added a contribution for meta tags. The site was running smooth. After that i've added a contrib ("Ultimate Seo Url") and the site was working fine but the orders didn't show up in my admin and in my "history orders". Then i've uninstalled the "Ultimate Seo Url" contrib, but still i've got the same problem, My orders won't show up. After a few days i've reached the next conclusion. The main problem for not displaying my orders was because my sql `orders_total` table it's not populated. The rest of my orders tables are working fine, are populated. Here i'm gonna show you my orders tables: (clean fields). -- -- Dumping data for table `orders` -- -- -------------------------------------------------------- -- -- Table structure for table `orders_products` -- CREATE TABLE `orders_products` ( `orders_products_id` int(11) NOT NULL auto_increment, `orders_id` int(11) NOT NULL default '0', `products_id` int(11) NOT NULL default '0', `products_model` varchar(12) default NULL, `products_name` varchar(64) NOT NULL default '', `products_price` decimal(15,4) NOT NULL default '0.0000', `final_price` decimal(15,4) NOT NULL default '0.0000', `products_tax` decimal(7,4) NOT NULL default '0.0000', `products_quantity` int(2) NOT NULL default '0', PRIMARY KEY (`orders_products_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `orders_products` -- -- -------------------------------------------------------- -- -- Table structure for table `orders_products_attributes` -- CREATE TABLE `orders_products_attributes` ( `orders_products_attributes_id` int(11) NOT NULL auto_increment, `orders_id` int(11) NOT NULL default '0', `orders_products_id` int(11) NOT NULL default '0', `products_options` varchar(32) NOT NULL default '', `products_options_values` varchar(32) NOT NULL default '', `options_values_price` decimal(15,4) NOT NULL default '0.0000', `price_prefix` char(1) NOT NULL default '', PRIMARY KEY (`orders_products_attributes_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `orders_products_attributes` -- -- -------------------------------------------------------- -- -- Table structure for table `orders_products_download` -- CREATE TABLE `orders_products_download` ( `orders_products_download_id` int(11) NOT NULL auto_increment, `orders_id` int(11) NOT NULL default '0', `orders_products_id` int(11) NOT NULL default '0', `orders_products_filename` varchar(255) NOT NULL default '', `download_maxdays` int(2) NOT NULL default '0', `download_count` int(2) NOT NULL default '0', PRIMARY KEY (`orders_products_download_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `orders_products_download` -- -- -------------------------------------------------------- -- -- Table structure for table `orders_status` -- CREATE TABLE `orders_status` ( `orders_status_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '1', `orders_status_name` varchar(32) NOT NULL default '', PRIMARY KEY (`orders_status_id`,`language_id`), KEY `idx_orders_status_name` (`orders_status_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `orders_status` -- INSERT INTO `orders_status` VALUES (1, 1, 'Pending'); INSERT INTO `orders_status` VALUES (2, 1, 'Processing'); INSERT INTO `orders_status` VALUES (3, 1, 'Delivered'); -- -------------------------------------------------------- -- -- Table structure for table `orders_status_history` -- CREATE TABLE `orders_status_history` ( `orders_status_history_id` int(11) NOT NULL auto_increment, `orders_id` int(11) NOT NULL default '0', `orders_status_id` int(5) NOT NULL default '0', `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `customer_notified` int(1) default '0', `comments` text, PRIMARY KEY (`orders_status_history_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `orders_status_history` -- -- -------------------------------------------------------- -- -- Table structure for table `orders_total` -- CREATE TABLE `orders_total` ( `orders_total_id` int(10) unsigned NOT NULL auto_increment, `orders_id` int(11) NOT NULL default '0', `title` varchar(255) NOT NULL default '', `text` varchar(255) NOT NULL default '', `value` decimal(15,4) NOT NULL default '0.0000', `class` varchar(32) NOT NULL default '', `sort_order` int(11) NOT NULL default '0', PRIMARY KEY (`orders_total_id`), KEY `idx_orders_total_orders_id` (`orders_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `orders_total` -- This is how my 4 fields look like. I'm guessing that my table looks just fine. Now i'm thinking i've got a problem with a file but i don't know witch one. Please i really need help with this one. I've already post messages in Chemo's Ultimate Seo Contrib Url's, but they don't know the problem and sent me here. Thanks in advance, Cezar.
  4. Hy. I've got a problem with my on-line store http://www.multiservice-canon.ro . This problem appears when an order is made. I can't see the order in my admin page. After i've analized my database structure i've found a problem: my `orders_total` table is empty. It just doesn't populate with any information. I've manually write some insert lines in my sql and then, i was able to see my order. But again if i add a new order, it doesn't appear in my admin. My `orders_total` sql syntax is the next one: CREATE TABLE `orders_total` ( `orders_total_id` int(10) unsigned NOT NULL auto_increment, `orders_id` int(11) NOT NULL default '0', `title` varchar(255) NOT NULL default '', `text` varchar(255) NOT NULL default '', `value` decimal(15,4) NOT NULL default '0.0000', `class` varchar(32) NOT NULL default '', `sort_order` int(11) NOT NULL default '0', PRIMARY KEY (`orders_total_id`), KEY `idx_orders_total_orders_id` (`orders_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; It seems ti be just fine. So i'm guessing that my problem is located in one of my *.php file, but i don't know wich one. I really need an answer to my problem and i will be very thankful. Thanks in advance, Cezar.
  5. MultiService-Canon ------------------------------------------------------ numar comanda: 33 detalii factura: http://www.multiservice-canon.ro/multiserv...php/order_id/33 data comenzii: Sunday 18 February, 2007 produse ------------------------------------------------------ 1 x Digital Ixus 800 IS () = 1.195,950-RON ------------------------------------------------------ This is how my e-mail looks after i've made an order. If i follow the link, and o login, i can't see any history orders. Instead of this it appears a series of numbers like : -40 , -30, -20 , -10 , 0. And again, in my admin section no order appear. What could be the problem? Thanks.
  6. Hy Skittles. I've uninstalled tha Ultimate Seo Url's contrib. But, i have the same problem. I can't verify my orders in my admin section & my history orders is affected because it's empty. When i make an order, in the auto response in my e-mail, it appears the order number, the product bought and it's price. So the e-mail is ok, meaning that in my database, the information are stored corectly. So the problem must be in a file, and i can't figure wich one. What is your guess? Thanks Skittles.
  7. No. I've configured a new store with data samples. Then, i've dropt all the tables. After that, I've put my old data base (wich contain those two sql lines). The site now connect to the database and sees my tables with all the data, but I have the same problem. I can't view the orders in my admin account. Maybe, if you have an yahoo messenger id, we can communicate much easier, i can send you some files to look at the source codes. I don't know what to do anymore. Thank you Skittles.
  8. Hello Skittles. Thanks for reply to my messages. I apreciate that. Now, it seems that the problem is in my data base. In chemo's install instruction he altered 2 fields in my data base structure: `categories_seo_url` varchar(100) NOT NULL default '', `products_seo_url` varchar(100) NOT NULL default '', Do you think this could be the problem? I've tried to delete those lines from my data base, but then i get an sql error in phpmyadmin at this line and probably at the lines after: INSERT INTO `categories_description` VALUES (21, 1, 'Imprimante', ''); Thank you Skittles, you really help me out on this one ;) . My yahoo messenger id is: "xperyens".
  9. Well Skittles, i've found a post of yours in wich you said that you can modify your store from oscommerce-2.2ms2-060817 version to oscommerce-2.2ms2-051113 version. I did that. I haved configured a new store, i've installed the Ultimate Seo Url's contrib. It was working. I could see my orders in my admin account. After that, i've imported the old database ( from http://www.multiservice-canon.ro ) to the new store. I can see the products and all the settings, but still, i can't see my orders in my admin. The odd thing is that when i enter in my admin url like www.ad-grafx.ro/magazinvirtual/catalog/admin it appears that blue window. At the orders menu, at pending, i can see the number of orders. Should i think it's a problem with my data base??? Help will be very appreciated. Thanks in advance Skittles.
  10. Thanks Skittles. You have wright. I am using 060817 osCommerce version. If i want to modify it and transform it in a 051113 release version what should i do? Could you point me to some files, or something? Thank you.
  11. Thanks Skittles. You have wright. I am using 060817 osCommerce version. If i want to modify it and transform it in a 051113 release version what should i do? Could you point me to some files, or something? Thank you.
  12. :angry: Another problem with my web site :( . I've made a test and i bought a product from my web store. It does'n show up in my order in my admin. Does anybody has this problem, or i'm the only one who managed to mess with the code? :blush: . The odd thing is that i-am receiving a proccesing e-mail as a customer. So that command is in my data base, but in my admin doesn't show up. I really need some help. My web store is http://www.multiservice-canon.ro . Thanks.
  13. ;) Thanks man. Now it works just fine. In my configure.php my HTTP_COOKIE_DOMAIN line was 'http://www.multiservice-canon.ro' . Now it's set to 'www.multiservice-canon.ro' and it works just fine. But i've descoverd another problem with my web site. When you want to view the information about a product like: http://www.multiservice-canon.ro/multiserv...mxl2-p-248.html there you can go to the manufacturer's page to view more info. Now the link looks like that" http://www.multiservice-canon.ro/multiserv...eID%3D26346%231 . You can see that redirect.php is also modified and instead of output the link like ...redirect.php?action=goto.... it output it like redirect.php/action/url/goto . This has to be a problem because of Ultimate Seo URL's. Thank once again.
  14. Hello. I'm having this problem and i can't fix it. When i set in my admin section "Force Cookie Use" i get an error in my frontpage. When i click the "buy now" button, i get the error: "Your browser does not accept cookies". My browser accept cookies, it's set well. If i set "Force Cookie Use" to false then everithing is working fine but with session id path in my links like that: http://www.multiservice-canon.ro/multiserv...cac2c9fcb77eae0 . Thank you in advance.
×
×
  • Create New...