Jump to content

bsmither

Member
  • Posts

    17,974
  • Joined

  • Last visited

  • Days Won

    603

Everything posted by bsmither

  1. If you are on a hosted site, perhaps only your host (through your hosted site's control panel) can create a database. And the name of the database is usually the login name you've given to access it. But, once the database has been created and a user assigned (again, perhaps the user is automatically assigned), all you need are the parts of the backup SQL that creates the actual tables. That's how I see it. Then there's the task, as you mentioned, of importing objects from one database to another. You should realize that the backup SQL might have DROP TABLES before restoring the data. Watch for that. Then there's the idea that inventory has ProductID as auto-increment, but is that how the restore SQL is set to restore it. It's only the Inventory you are copying over, not any of the other tables?
  2. Looks like you've got it. Except for the colors of the hover links.
  3. At the top of all admin pages, the current calendar date is displayed. On one instance (CC 3.0.15, PHP 4.3.11 on Linux/Apache), I get the full "Sunday 20, January 2008". On another instance (CC 3.0.15, PHP 5.2.4, MS Server 2003 x64/IIS6), I only get "Sunday , Jan 2008". That is, the calendar day of the month is not being generated. The %e isn't showing. The resultant string is generated by the strftime function (of PHP) as it is being called from the FormatTime function in functions.inc.php. The formatTime function is called from header.inc.php and the $strftime variable is set in yourlanguage/config.inc.php. In yourlanguage/lang.inc.php, the system is being configured with the setlocale() function. I'm *guessing* that "en_EN" is not what Server 2003 is able to use. But I've tried several variants and no change. I did read something about this gets set on a per session basis, so maybe I need to close all browser windows and try again. (I changed "en_EN" to "usa" and logged in using IE (while keeping open FF windows), didn't work.) Any thoughts? The Time and Date panel in the Store Settings page are the same between the two instances. But the header.inc.php page doesn't use those.
  4. Dedicated box with Windows 2003 Server... PHP 4 or 5? and MySQL5. Did you install PHP and MySQL from 1and1's Control Panel, or did they give you a bare-bones Windows 2003 Server box? If from a Control Panel, can you manage the database from an application provided to you there? Or must you install your own MySQL Admin/Query utility? Did 1and1 give you a Host/User/Pass for your database? Does 1and1 lock your database against outside management, meaning you must remain within your own domain (hosted space)? If so, then PHPMySQLAdmin may be in your Control Panel as well. If not, then consider installing it on your hosted space. If 1and1 does let you manage it from a remote site, you might consider installing on your office computer the MySQL Administator/Query Browser from the MySQL folks. You will need to deal with the Secure Certificate. You will then copy over your CC files. I'm going to presume it's been customized somehow. If not, do a fresh install of the latest major version of your choice. (And do not restore the Config table on the new database.) There are tutorials on how to back up a MySQL database. Restore on the new database. Before you attempt to run your store, edit config.inc.php with the new site parameters. Get EDITCONF from this site and change necessary info in the Config table. Finally, cross your fingers.
  5. These are appropriate choices for a Windows Server NTFS file system. You will want to deselect Inherited and select Reader.
  6. How is it that you are doing this? Almost all FTP programs will allow you to bring up the Linux-based file/directory "Properties". What FTP program are you using? Also, what kind of hosting do you have with GoDaddy? Linux/Apache or Windows?
  7. FileZilla, as well as any FTP program as far as I know, cannot change directory security permissions on a remote NTFS file system. (But I could be wrong.) Instead, you will have to take remote control of the Windows server (RDP, VNC, VPN, etc) as an administrator and using the Properties page of the directory where global.inc.php is in, set it to Read-Only (or maybe Read/Execute) for IUSR_Machine name. This is how I remember doing it when I installed CC on a Windows server.
  8. What version of IE? In your IE Security Settings, do have "Navigate sub-frames across different domains" enabled/disabled? Have you verified this behavior with IE on different computers?
  9. I am by no means a SQL expert, but from the statements I've tried to grok (and my own SQL experiments gone horribly wrong), but is this an actual statement in the stock CC code? If so, what file can it be found in? If not a SQL statement actually found in the stock CC code, I'm inclined to suggest that you or your customer study up on the JOIN keyword. It may be a preferable solution to the convoluted (and possibly train-wrecked?) SQL statement included. Can you plug this statement in a SQL admin panel, like PHPMyAdmin and see if you get the same results.
  10. You might think. But the best place might be in (1) cart.inc.php, or perhaps (2) add a new function to the cart class. For each visitor, CC asks PHP to create a session. The session ID is stored in the database table "CubeCart_sessions". The basket contents are "serialized". You would need to do a lot of discovery to understand the serialization of the cart. (1) You would need to write new code to sort $basket at about line 44 (or maybe near line 354). Or, (2) You would need to write new code in the cart class to add a sort function to the class.
  11. I see that there have been some edits made to your .css files in the Classic skin. Can you re-upload the Classic skin (call it Classic2), then change your store to that skin in the admin panel? If your store is still frell'd, then we can look elsewhere. My experience tells me stock CC css files are quite uninteresting when it comes to creating anomalies with the various browsers.
  12. Look in /skins/your-skin/styleTemplates/content/cart.tpl at around line 18. This starts a table for the two (three ?) column layout containing the Invoice address and Delivery address. From the looks of things, the Invoice Address is taken from the Customer Profile info - if your store asked for it in the first place. But, I think here is where you can start commenting out the first column table data tags. Be sure to catch the colspan on line 21. I believe you CANNOT just delete the lines of code containing the {} placeholders. Otherwise you might get a class element error. Also, for example line 29 and line 83, they both contain placeholders for the "Invoice Address 1" you need to be concerned with. There are other pairs. On the other side of the coin, you can edit /includes/content/cart.inc.php at around line 241. You can try commenting out the entire group of lines there and see what happens.
  13. You might try this commercial mod: Custom Additional Registration Fields found in CubeCart dot org.
  14. You might go to CubeCartForums.org and look around in there for a Site Documents mod that allows for a doctype of PHP. I recall seeing one.
  15. Well, I'm sure you are going to get answers along the lines of: --this is a CC support forum, not a paypal forum. --post your query to the paypalsucks dot com web site forums. --re-read your paypal agreement. --configure paypal to accept only authenticated card account holders. --configure paypal to require the CVV2 number. --don't use paypal. But as far as managing a CubeCart store is concerned, you can delay shipping by a set number of days, say 14. That way, any customer claiming fraud has that much time to dispute the charge and you won't have lost anything. As for a potential mod to your store, you could develop a means where a customer needs to scan his face with the card held on top of his forehead and the headlines of today's newspaper held beneath his chin and have that image uploaded to your store for verification of a legitimate purchase. Or you could just realize that situations like this happen, as few and far between as they may be.
  16. A diamond with a ? in it is what I see when Firefox can't figure out what character (maybe can't figure out what character set) is called for. Maybe nothing has changed with your store, but something changed with the browser you're using to view it?
  17. Did you happen to catch this reply? http://www.cubecart.com/site/forums/index....showtopic=31945
  18. Uh, no. That's your GD Settings Panel on the General (Store) Settings page. Go to the bottom of the admin's navigation stack and click where it says: Misc * Server Info It's right under * Site Documents On the Server Info page, scroll through the list of installed PHP extensions and see if the "gd" extension is listed.
  19. I do think there is a mod where the visitor's preferred skin can be selected from the visitor's personal settings page and saved in the customers table in the database. So you can use this and then create "example customers". Tell your acquaintances to use these specific customers to see the various skins. In the admin page, the store administrator can select the skin to show. You might already know this. I am not aware of a mod that will allow you to put the name of the skin in the querystring. But you might try this: In /index.php, near line 78: Replace: $body = new XTemplate ("skins/".$config['skinDir']."/styleTemplates/global/index.tpl"); With: if(isset($_GET['skin'])){ $skinDir = (treatGet($_GET['skin'])); } else { $skinDir = $config['skinDir']); } $body = new XTemplate ("skins/".$skinDir."/styleTemplates/global/index.tpl"); This should work at the start of the store, but it will NOT persist. I will leave it up to you to figure out how to output "skin=yourskin" through the querystring in index.php, cart.php, and all the other files in the root of your store. I haven't tested this, so use it at your own peril.
  20. You might want to look at your layout.css file to fix the following errors. But I doubt this would be causing your problem. Warning: Expected declaration but found '{'. Skipped to next declaration. Source File: http://tradgardstomtar.se/store/skins/Tomt...eets/layout.css Line: 8 Warning: Error in parsing value for property 'background-image'. Declaration dropped. Source File: http://tradgardstomtar.se/store/skins/Tomt...eets/layout.css Line: 22 Warning: Expected color but found '#'. Expected color but found '#'. Expected end of value for property but found '#'. Error in parsing value for property 'border-right'. Declaration dropped. Source File: http://tradgardstomtar.se/store/skins/Tomt...eets/layout.css Line: 113 Warning: Expected color but found '#'. Expected color but found '#'. Expected end of value for property but found '#'. Error in parsing value for property 'border-bottom'. Declaration dropped. Source File: http://tradgardstomtar.se/store/skins/Tomt...eets/layout.css Line: 114 Warning: Expected color but found '#'. Expected color but found '#'. Expected end of value for property but found '#'. Error in parsing value for property 'border-left'. Declaration dropped. Source File: http://tradgardstomtar.se/store/skins/Tomt...eets/layout.css Line: 115 And seeing as how this is a custom skin, you may want to contact the author of the skin to see if there is a problem with the viewProd.tpl file for that skin. If you switch your store to one of the standard CC skins, does it work correctly?
  21. In your store's admin section, Server Info page, do you see a section headed "gd"? Maybe on your new server you have not included/enabled gd support in the php.ini file.
  22. You might want to review this thread: http://www.cubecart.com/site/forums/index....showtopic=30285 As such, you might want to start using FireFox to successfully manage your store. Your mileage may vary. Adding something to the basket worked for me using FF.
  23. See if this works for you: In the /modules/gateway/ folder, rename the folder names of the three gateways you have activated so that the first listed has an "a" as the first letter, "b" as the first letter of second to be listed, etc. So, a-HSBC b-eGold c-Authorize_AIM or whatever you need. If I recall, CC just enumerates all the folders in the gateway folder and presets them as a list in the admin section. But maybe you are referring to the list in the Cart. In /includes/content/gateway.inc.php, line 326, put an " ORDER BY folder asc" (without the quotes) after the status = 1. So, ...WHERE module='gateway' AND status = 1 ORDER BY folder asc"); See how that works for you.
  24. I haven't seen any smtp server have "auth.smtp". They've always been "authsmtp". Note the difference with the period. Just try it without the period and let us know.
  25. Please see thread: http://www.cubecart.com/site/forums/index....showtopic=29342
×
×
  • Create New...