Crysties

I have been having the same problem for several weeks with my site going down with a sessions error. I repaired sessions but still having problems. I contacted BlueHost.com tech support and they said that I have two databases with more that one index and it is making the program go nuts (in layman's terms). My two databases are inventory and countries. I have repaired inventories but I am still trying to find out about countries as it was loaded from first install of CubeCart with 3 indexes. PRIMARY KEY (`iso`), KEY `id` (`id`), KEY `id_2` (`id`) I am getting an error message re KEY 'id" ('id'), KEY "id_2" ("id") being the same but which one should be removed? "The following indexes appear to be equal and one of them should be removed: id, id_2" Check your databases or you may continue to have problems as I am having.

You need to go into myPhpAdmin and into the database. Scroll down until you find CubeCart_sessions and click on that. The CubeCart_sessions structure will appear on the right. Under Space Usage there were extra fields, more than "Data", "Index", and "Total". Under that was a "Optimize Table" in blue. I clicked on that and optimized the table and everything was then OK. If you can't get that to work what I did originally a couple of weeks ago was copy CubeCart_sessions in from a backup. I found out talking to a Tech Support at BlueHost.com tonight that there are two other tables that have multiple indexes that are causing these problems. (my systems has crashed 17 times today.) One is CubeCart_inventory and the other is CubeCart_countries. (It may be different databases on your system.) Click on each database and scroll down to the bottom. If there is a big Error message in red print on a yellow background in a red framed box than that is a database with a problem. Those need to be repaired or you will keep getting sessions errors. I have fixed the CubeCart_inventory by removing the one that was not PRIMARY. I am still researching the other one. When I installed CubeCart it put CubeCart_countries in with 3 indexes. PRIMARY KEY (`iso`), KEY `id` (`id`), KEY `id_2` (`id`) I am trying to find if that is correct as it is generating an error message. "The following indexes appear to be equal and one of them should be removed: id, id_2" I am trying to find out which one needs to be removed or if all but PRIMARY needs to be removed. I hope this helps and if you get any help pass it on as I still need to fix mine. Good luck.

I too would like FedEx (as standard option) as the UPS rates have become almost unreasonable. Several of my customers will not use UPS due to damages to one of a kind product. dizzy.gif

Ok thanks if thats the right answer. Thank you to Andy1960 for asking the question and to Mysty for pointing me in the right direction. When modifying the database put a 1 in the noImage column with 0=No and 1=Yes. This will allow you to add images to the CubeCart_img_idx to add additional images to an item. If you are in the program go to Administration and click View Products. Filter for the product where you want to add the extra images. Under the image is "Manage Images". You can add additional images. When you go to your site and view the product there will now be "[+] More Images" under the main picture. When you click on More Images you will see the original image and the additional images as thumbnails. When you click on the thumbnail you will an enlarged view of the thumbnail. See an example on my site http://crystiesgifts.com/index.php?act=vie...mp;productId=28 I think the same works with catagories as I see under View Products a link to Manage Catagories. I haven't tried it yet but I will soon as I have several products that should show in several catagories. Let me know if this works for you.

The list is kept in CubeCart_customer in the MySQL database. It is combined with the customers. Customers have addresses, etc.; email subscribers only have an email address in the database. You can export the database or you could import another email list into this database. Hope this helps.

I am having the pear/PayPal.php error message only with PayPal Express. I have done the chmod's that you recommended but still cannot make the PayPal Express work. PayPay Direct Payment works but not Express Pay. What is Default Yes/No used for and what should it be its setting. Thank you, Roz

I have that same message. Do you know how it was corrected? Did you get your second problem corrected? Roz

Thank you so much for your help. I did find the Config Tool which helped lots. I sent my host an email asking for location of PEAR. I found out that my PEAR.php path needed to be changed to where it was located on the server that is hosting my site. As soon as CubeCart Support changed it, everything worked. Nice to be able to get into admin finally. I still have to work on the SSL but for now I will just play with the site for a bit. This site is just a temporary one that will eventually be copied or transferred or whatever has to happen to my active website and replace that site's software/cart. Thanks again. I will probably be back asking more questions. Roz :P

How did you fix this? I may be getting different error messages than you. I am getting error messages "failed to open stream: No such file or directory in ..... as follows: Warning: main(httpdocs/Catalog/classes/db.inc.php): failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/websitename/httpdocs/Catalog/admin/includes/auth.inc.php on line 60 Warning: main(): Failed opening 'httpdocs/Catalog/classes/db.inc.php' for inclusion (include_path='.:/php/includes:/usr/local/share/pear:/usr/local/lib/php/pear') in /usr/local/psa/home/vhosts/websitename/httpdocs/Catalog/admin/includes/auth.inc.php on line 60 Warning: main(httpdocs/Catalog/admin/includes/navigation.inc.php): failed to open stream: No such file or directory in /usr/local/psa/home/vhosts/websitename/httpdocs/Catalog/admin/includes/header.inc.php on line 57 Warning: main(): Failed opening 'httpdocs/Catalog/admin/includes/navigation.inc.php' for inclusion (include_path='.:/php/includes:/usr/local/share/pear:/usr/local/lib/php/pear') in /usr/local/psa/home/vhosts/websitename/httpdocs/Catalog/admin/includes/header.inc.php on line 57 And a few more messages besides these. I am new at this as of last week so I am not sure what I am looking at or how to fix it. Any help would be appreciated. I have tried many of the corrections to get this far. I just downloaded the latest version last week as my first install. Roz