Jump to content
Latest News: (loading..)

B.C.

Members
  • Content count

    56
  • Joined

  • Last visited

Everything posted by B.C.

  1. On an old 2.2 shop (I know, I know) I have a drastic drop in orders, along with a few folks telling me they can't add anything to their cart. Like, it just takes them to the empty cart page.....I haven't changed anything on the site or the server, and I can make all the test orders I want on various browsers/devices. So, I am getting orders still, and I can't replicate the problem myself. Would something like an item not being added to the cart result in an error that I could see somewhere? And, if so, where? I've never done an error log thing, but I've seen it discussed over the years........Anyone that can drop a hint or share an experience similar to mine would be greatly appreciated.
  2. B.C.

    Another "can't add to cart" thread

    They hadn't, but I was on an old version of php (5.2.9) and they said they'd up it to the 5.6.33 version to see if that would help.
  3. I'll be following this closely, as I've been searching my brains out for something similar to what you need. Everything that works to shorten the stock checkout by several useless pages and/or allow customers to checkout without an account is either clunky and buggy, or simply won't work on 2.3.4/BS without being re-written.
  4. B.C.

    Shorter Checkout for osCommerce 2.3X

    Has anyone gotten this to work on 2.3.4?
  5. B.C.

    Upgrading to the latest version

    Yeah, I bet that's it, because I opened it in Notepad to rename it. Since I am trying to move it to a different hosting account, the naming scheme is different, that whole "account_dbname" thing, so I think I'll do what you suggest, but stop trying to move the db to a different server, since I think that's where the problem is.
  6. B.C.

    Upgrading to the latest version

    Yeah, it's failing on the import.........it could be buggy phpmyadmin, could be because of different versions of mysql on the different servers.....I don't know........another day of futilely grinding away at what is supposed to be so easy.........This is exactly why I put off even thinking about upgrading for years........Unfortunately your help is wasted on me at this point, I'm in the weeds again...I think I'll scrub everything and start the whole thing again fresh on the same server, just to hopefully avoid the import/export situation being the culprit. Thanks again, though, it is appreciated.
  7. B.C.

    Upgrading to the latest version

    Dan, I had seen that as well when I Googled it, and one of the suggestions was to upgrade phpmyadmin......are you suggesting that, or you saying go ahead and export with the possibly buggy phpmyadmin, then updating the database on the new server?
  8. B.C.

    Upgrading to the latest version

    Dan, it seems to be failing at the import with the above error message.....there are no errors on the new store, just no products, no categories, etc...Maybe I should have been doing all of this on the same server........I think all the advice here is exact and correct, I'm just screwing it all up by trying to export to another server/host.......
  9. B.C.

    Upgrading to the latest version

    this is what i have.......... -- phpMyAdmin SQL Dump -- version 4.0.10.14 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: Jul 02, 2017 at 01:10 PM -- Server version: 5.1.73-cll -- PHP Version: 5.4.31 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `newshop_oldStore` ------------------------------------------------------------ -- Table structure for table......etc, etc...
  10. B.C.

    Upgrading to the latest version

    I'm starting to get clear on that, it's making more sense. In my particular case, I'm rebuilding the new store on a different server with a different host, so I'm having to export/import tables and/or databases after running the update scripts on them....I'm successfully running the scripts you guys have made, I'm just hitting errors on the attempt to import the updated database into the new store..........I think I'm going to give up on updating the old stuff......I have installed the new shop (2.3.4 responsive) and all I really need from my old shop is the products/attributes and customer reviews.....Maybe it is easier to do that? A lot of my old contributions are stock in the new package anyway.......But I probably shouldn't clutter up this thread with it.....I assume I'll need help and I'll try to start a new thread in the appropriate place.
  11. B.C.

    Upgrading to the latest version

    OK, I have copied the old database, run the SQL changes script, run Burt's db update script to get it up to 2.3.4 Responsive. I exported that db to import it over the other server where I'm trying to set up the new store, but I'm hitting errors on the import: Error Static analysis: 2 errors were found during analysis. Unexpected beginning of statement. (near "phpMyAdmin" at position 0) Unrecognized statement type. (near "SQL" at position 11) SQL query: phpMyAdmin SQL Dump SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO" MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'phpMyAdmin SQL Dump SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"' at line 1 Not sure what that calls for?
  12. B.C.

    Upgrading to the latest version

    Brockley John--definitely time for a break, but thanks for the control click tip, I have never heard of that before. Dan- OK, light at the end of the tunnel, thanks, I'll do that and report back..... I graduated high school in prison, never went to college, and I just silk screen shirts....99% of all of this computer stuff is over my head.....what seems obvious to you is Latin to me. That's why for years I just Google and tinker and try not to bother the smart folks.....but this 2.3.4 stuff seems like a whole new ball game. Thanks for taking the time to help me........
  13. B.C.

    Upgrading to the latest version

    Dan, yes, absolutely, but I think I am using the version of that that goes up to 2.3.4, not just 2.3.3 or whatever.... But yes, I copied my database and renamed it "oldStore" then followed the instructions in this thread above and deleted everything that wasn't needed, and imported it. Now I'm on Step 4 of "Converting from OSC 2.2 to 2.3x, for dummies" where I'm supposed to select only certain tables for a custom export, which should then be able to be imported into the new store. But I can't select only certain tables. I can select all or deselect all.
  14. B.C.

    Upgrading to the latest version

    Dan, yes, I read that, and yes, that's exactly what he said. Then immediately after that, he said: And the thread he linked to was all about updating from BS 2.3.4 to Responsive 2.3.4. So, like I said, it seemed (to me, of course) like that post was all about showing you how to go from BS to Responsive. You may have to allow for the possibility that what someone says and what my limited understanding of what was said may not correspond, exactly. So if I express what I think was said and ask for clarification, I hope that isn't interpreted as an attempt to contradict anybody. I know I'm the deficient moron in this situation, humbly asking for assistance, so I appreciate any help. So anyway, does anyone have any idea why I can't select only certain tables for a custom export?
  15. B.C.

    Upgrading to the latest version

    How I missed that I don't know, but thanks, that worked for that step. Now I'm on the next step of doing the custom export of oldStore, but you say in your instructions to only export certain tables. For some reason I can either select all or deselect all, if I try to only select certain tables, I can't. If I select one, then go to select another, it deselects the previous one, like playing Wack-a-Mole. Normally I would Google and tinker and figure it out myself, but I'm so brain dead on this project I'm going to strictly go by the instructions exactly and post my results and hope you guys are patient enough to point out my obvious errors. So, if I can't do selective table exports, should I just select all tables and export?
  16. B.C.

    Upgrading to the latest version

    Thanks Dan........ Seems like Jack was mostly talking about going from Boot Strap to 2.3.4 Responsive in that post. I'm trying to make the jump from 2.2 to 2.3.4 Responsive. I was mainly using trying this by using Converting from OSC 2.2 to 2.3x, for dummies: https://docs.google.com/document/d/1AI6RquhcmO-u9GLAofk3RX2w9SWv0ddejdiRemUhWLo/edit I copied the database and renamed it oldStore, as per instructions. I imported " sql_changes_ms2.2_to_2.3.4" that everybody links to and got the first error: Error SQL query: ALTER TABLE specials ADD INDEX idx_specials_products_id( products_id ) ; MySQL said: Documentation #1061 - Duplicate key name 'idx_specials_products_id' When I google this error, I read a lot of stuff, but still don't know what, exactly, to do to solve it. Any help is appreciated.
  17. B.C.

    Upgrading to the latest version

    Maybe I'm just tired, but the thread you linked to, and suggested that I ask for help on, is, in fact, this very thread that I'm asking for help on. Or were you just saying I need to be more specific?
  18. B.C.

    Upgrading to the latest version

    I've used 2.2 for more than 12 years, thought I knew some stuff about OSC. Recently decided to take the plunge and update to 2.3.4-Responsive and after several days of frustrated futility, found out that I apparently am retarded. I believe I have read every single thread about updating from 2.2 to 2.3.4 and I haven't managed it. After 7.5 hours just today I can't even describe what I have tried.......download, backup, import, run sql scripts that are supposed to do whatever, you name it. Everything breaks everything. I thought it was easier: export old database, drop tables in new database, import old db into new shop, import that sql script that makes all the changes between 2.2 and 2.3.4, but it's all errors and broken pages. So I scrub everything, do a fresh install of the 2.3.4 and try again, after re-reading every thread. Now my brains are spaghetti and nothing makes sense anymore. If anybody out there has had a similar experience trying to figure this out and can point me in the right direction, that would be great.
  19. B.C.

    Database Optimizer

    I think I did something similar by accident. First I ran option A, I think, since it was the default and I didn't change it. So it deleted customers but not orders......Then I realized what happened and switched it to Option B, I think, to delete customers and orders, but 34,000 orders remain. How can I now delete all of these old orders?
  20. B.C.

    Header Tags SEO

    That worked, thanks a bunch. So yeah, since that worked on the renamed index.php, I just need to compare them to find out what I did wrong on the install.
  21. B.C.

    Header Tags SEO

    This site must use a url rewriter then, as the category (and product) pages end in .html ...........I guess this site has seo url contribution or something, so I toggled that off in admin (made "enable seo url" false) but that broke something and made category pages unreachable, so I turned it back on right quick. Whatever, I'm just a monkey pushing buttons at random, basically, and shouldn't be tinkering with anything at this point.
  22. B.C.

    Header Tags SEO

    Thanks for the response, but I don't quite understand. I took my site back over from a crooked webmaster years ago and what little has sunk into my brain isn't quite enough to understand your help completely. If I just rename the index file, how does that help me see changes to a category page? I don't know if my site uses a url rewriter or not, or what that is.
  23. B.C.

    Header Tags SEO

    Jack, apparently I installed this contribution to one of my sites with no problems years ago, mostly for the SEO benefits. I was recently trying to find a way to add text to the category page, and read that this could also be done with Header Tags SEO. I had never noticed or realized that. But I can't see how to do this. I ran the test and there were no problems really, but when I add text to the Header Tags Categories Description box and save my changes in admin....none of it appears on the category page of the site. Am I overlooking something simple? Any help appreciated in advance.
  24. I bought Better Checkout from Toste & Jensen........It takes your customer straight to checking out, and at the end it offers them the option to save all of their info (creating an account) or they can click, "No thanks," and be on their way without setting up an account. Works great, didn't cost much, and they can install it for you if you need them to. Here is the description: http://www.tostejensen.com/better-checkout.html Or you can click straight on the demo: http://www.bettercheckout.com/ Good luck..........
  25. Still looking for a 2.3.1 version of this contribution. I purchased Image Handler 2.3.1 from Dunweb, but that was before I read the warning the mods here have placed on his own profile page, and before I found out what a scammer Dunweb is. Do yourself a favor before sending this guy money and do a minute or two of research on him here.......
×