Jump to content
Latest News: (loading..)

B.C.

Members
  • Content count

    56
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    BC
  • Gender
    Male
  • Location
    USA

Recent Profile Visitors

5,107 profile views
  1. 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.
  2. 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.
  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?
×