Jump to content

Crysties

Member
  • Posts

    39
  • Joined

  • Last visited

Posts posted by Crysties

  1. My cart has been up and working great for almost a year now.

    Today when I went to the site I got this error.

    1194: Table 'CubeCart_sessions' is marked as crashed and should be repaired

    QUERY = INSERT INTO CubeCart_sessions (`location`, `sessId`, `timeStart`, `timeLast`, `customer_id`) VALUES ('http://poolsandgames.com/store/index.php', '7cba703dea426ec4106c7840c477a1e7', '1231696951', '1231696951', 0)

    Anyone have any idea how to fix this and get my cart back up and running asap?

    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.

  2. Al / (Cube Cart)....

    First.... Thanks for providing cubecart.

    I would like to know when/if we can expect fedex support in v4? Not to sound ungrateful but the response I read from Al in the forums is weak - I would think that with the user base that cube cart has, getting FedEx support would not be as difficult as it's made out to be. Furthermore, if having Fedex support in cube cart is desired then why would cubecart not take KGB up on his offer? Would it be that difficult to get the v3 mod working with v4? We need a solution.

    Thanks,

    Shawn

    Previous forum response regarding fedex----

    "No.. only for one reason... etting an account with FedEx for testing has been an impossible task. They will not cooperate with us and I have spent a great deal of time on the phone to their customer support who pass me from dept to dept.

    Really frustrating. If anyone has a FedEx account they will let us use to develop a module we would be very grateful."

    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

  3. I believe thats the column for holding additional images. If you only have 1 image per product, then they would all be 0.

    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.

  4. I have just generated a bunch of test bulk emails during which I found your answer: ONLY PEOPLE WHO HAVE ENTERED THEIR EMAIL ADDRESS IN THE SUBSCRIBE TO MAILING LIST BOX. These may or may not be customers with or without orders.

    I just wish I knew where this list was stored in the database and how to access a complete listing other than downloading a text file of the email addresses.

    :)

    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.

  5. No problem... Glad it worked for you!!

    Adam

    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

  6. For every one to know:

    I opened ticket with my hosting, and above error was gone.

    Now I get on Confirmation Screen the following massage

    Sorry your order Failed

    Any Ideas

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

    Roz

  7. You have to find the global.inc.php in the includes directory. This is where you set all these URLs. It is hard to figure out what exactly they are meant to be but you need to make sure that what is in the root URL there is exactly what this error is looking for, including slashes.

    This is not the end of the drama I warn you because there are also the $config settings for SSL which are a real bugger, I am struggeling with them at the moment. Have not had a response to my question on here but heaps of people are having the saqme problems, very frustrating

    Juanita ;)

    Thank you so much for your help. B) 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

  8. My shopping cart seems to work ok and I can log into the Admin interface but after the login I get all these error messages about not being able to open the stream, whcih obviously means tehre is someting wrong with my rootdir. My hosting provider tells me the root dir is /home/websitename/public_html/.

    The error is

    Warning: include_once(/home/websitename/public_html/classes/db.inc.php) [function.include-once]: failed to open stream: No such file or directory in /home/websitename/public_html/admin/includes/auth.inc.php on line 60. I have set all the permissions to 777, the files are there, obviously something I am not seeing.

    Any help is greatly appreciated

    Juanita :(

    Realised myself eventually, the first / was missing!!!

    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

×
×
  • Create New...