Topic:  MySQL  Subject:  Accessing MySQL  How do I access a MySQL database   Open a new Support Request by clicking here.   MYSQL AND PHP What can I use to setup a database? The main database available on our system is MySQL which is what you use to manage your database files. In order to display them on the Internet you have to use a program such as PHP or PERL. The Manuals for MySQL and PHP are available here: MySQL Manual PHP Manual How do I access my database? First you must request that a database be created for you.  You may do so by submitting a support request. From your telnet prompt type the following command line to access your database: /usr/local/mysql/bin/mysql yourdbname -u yourusername -pPassword (no space between the -p and the password)

Topic:  Shopping Cart  Subject:  Using the Shopping Cart  How do I use the Shopping Cart?   SHOPPING CART My 'Categories'drop down box in the 'Add Product' page comes up empty. When you add a category, you must define whether is contains subcategories or products. The default is products. If you change it to subcategories, then it will *not* appear in the pull-down list in the add product screen. Unfortunately, it cannot be changed after it has been created, so you will have to delete any that were incorrectly created, then recreate them correctly.   Will my added fields for a product listing appear when a category is selected, or only when you specifically click on that product? The first listing of products only shows the pre-defined fields. When you click on the product name, it will show your added fields then.   How do I edit the pre-defined category fields? i.e. delete "Weight"? You cannot delete the weight field. You can only leave it blank, or enter a value for it.   How do I edit the pre-defined main headings? i.e. "Browse Catalog"? Those too cannot be edited.   I try to add something to my basket, but when I check basket contents, it is not there. The Shopping Cart uses cookies to track a user's ordering actions. Make sure cookies are not disabled on your browser.   The logo in the upper-left corner of the checkout page is not showing. I get a broken-link gif. The problem is that the URL entered for the logo was entered as an absolute path, not a relative path. Since the checkout page is secure, it tries to call the insecure path, and this causes the error. To correct, go to the "Look and Feel" page of the Administration Suite. Change the "Logo URL (path and name of logo on the server):" to a relative path. For example, If it is currently: http://domainname.com/images/alogo.gif Change it to: ../images/alogo.gif This will grab the logo in reference to the current directory (s-cart) and correct the problem. The "../" at the beginning refers to the /your_domain-www directory on the server.   There is no 'Add to Basket' button on my Shopping Cart program. Make sure that the Cart is being called on port 7070. If it is called on the default port (80), sometimes the 'Add to Basket' button will not appear. Here is the format of the URL to call the program: http://your_domain.com:7070/s-cart/index.phtml To change this, perform the following steps: (1) Go to: http://your_domain.com:7070/s-cart/admin/index.phtml (you will have to enter your username and password to enter this page) (2) Change the URL to http://your_domain.com:7070/s-cart/admin/setup.phtml (3) Under "Change Paths", enter your username and password, and after "Your Domain Name", add :7070 to the end of your domain name. (4) Click "Update Path".   How do I change my password? (1) Go to: http://your_domain.com:7070/s-cart/admin/index.phtml (you will have to enter your username and password to enter this page) (2) Change the URL to http://your_domain.com:7070/s-cart/admin/setup.phtml (3) Under "Change Password", enter your current username and password, and your new password twice. (4) Click "Update Password".   My domain name is not registered yet.  Can I still setup my shopping cart? Yes, this is no problem.  Just tell support when they install the cart for you, and they will make the cart use the IP number.  After the name is registered, you can change the cart to use the domain name: (1) Go to: http://your_ipnumber:7070/s-cart/admin/index.phtml (you will have to enter your username and password to enter this page) (2) Change the URL to http://your_ipnumber:7070/s-cart/admin/setup.phtml (3) Under "Change Paths", enter your username and password, and after "Your Domain Name", change the IP number to your_domain.com:7070. (4) Click "Update Path".