Guest Posted June 16, 2009 Share Posted June 16, 2009 Need Help see if I can make the problem clearer On my home page (rhjgoldmfg.com) top left I have on line catalog (moissanite solitaires) (moissanite & Gems) (Wax Patterns) These folders are in my admin... categories/products and I can add product to them etc. But on my home page if you look lower left... Deal Of the Day an clear to the right I have six categories weddings, body jewelry, diamonds, etc. Somehow I deleted the folders inside admin in the categories/products. And on my homepage their now just dead links, if you click on them you get (There are no products to list in this category) What I need to do is get the folders back into admin under categories/products? If someone could show me how to fix one I could manage to fix the rest of them... LOL I hope. If anyone could take the time to help out I really need it ... I mean your looking at the dummie that deleted the folders out of my admin lol Thanks Mike E Link to comment Share on other sites More sharing options...
hodja451 Posted June 16, 2009 Share Posted June 16, 2009 These folders are in my admin... categories/products and I can add product to them etc. Somehow I deleted the folders inside admin in the categories/products. Which is true right now? My experience relates to osCommerce Online Merchant v2.2 RC2 Link to comment Share on other sites More sharing options...
Guest Posted June 17, 2009 Share Posted June 17, 2009 These folders are in my admin... categories/products and I can add product to them etc. Somehow I deleted the folders inside admin in the categories/products. Which is true right now? The deal of the day and all of the links clear to the right are no longer in my admin catalog... categories / products Link to comment Share on other sites More sharing options...
Guest Posted June 17, 2009 Share Posted June 17, 2009 Recreate them in your admin, then go into your database and renumber them (assuming that you have not created any others that have the same cat id). You can see the category id by mousing over the links. Of course this will not put any products back in those categories, you will have to do that through admin. The deal of the day and all of the links clear to the right are no longer in my admin catalog... categories / products Link to comment Share on other sites More sharing options...
Guest Posted June 17, 2009 Share Posted June 17, 2009 Recreate them in your admin, then go into your database and renumber them (assuming that you have not created any others that have the same cat id). You can see the category id by mousing over the links. Of course this will not put any products back in those categories, you will have to do that through admin. I'm sure the cat id is the same as I have not added any new catalogs. However, where do I find the database? and what do I re-number may need a bit more information I can add them back into the admin no problem and the mouse over shows the first one (wedding-c-1.html) but I don't know what you mean by renumbering them and not sure where to find the database? Mike e Link to comment Share on other sites More sharing options...
Guest Posted June 17, 2009 Share Posted June 17, 2009 I'm sure the cat id is the same as I have not added any new catalogs. However, where do I find the database? and what do I re-number may need a bit more information I can add them back into the admin no problem and the mouse over shows the first one (wedding-c-1.html) but I don't know what you mean by renumbering them and not sure where to find the database? Mike e If I go to my ftp and look at the files on the indexl.php I can see where all of the origional catalogs are when I mouse over them on the home page I now created Weddings in admin and what I need to know is where at or what file do I need to go to change the new number which is (wedding-c-115) back to the origional number which should be (wedding-c-1.html? If I FTP and look at my files under admin there is categories.php but I don't think thats the right place anyway I don't see (wedding-c-115) Where do I find them at after I created them in the admin categories / products. anyhelp please. Mike E Link to comment Share on other sites More sharing options...
Nullachtfuffzehn Posted June 17, 2009 Share Posted June 17, 2009 The categories are stored in your database. You can use i.e. phpMyAdmin (should be provided by your host) to edit the tables of your database. The tables you need to edit are categories and categories_description. Link to comment Share on other sites More sharing options...
Guest Posted June 18, 2009 Share Posted June 18, 2009 Manfred: I'm using a 2003 I think version osCommerce 2.2-MS2? and any case I connected to my web host opened the files all of them and I can fine categories.php and the catalog id is not in there. I can't fine anything that is categories_description. Below is whats in my files on my website hosting. admin cache download images includes php_uploads Pub stats tmp seems like all im doing is going in circles here need better info on where there located. Any help on this pLEASE Mike Link to comment Share on other sites More sharing options...
BryceJr Posted June 18, 2009 Share Posted June 18, 2009 The previous posts from Manfred and Rebecca are referring to your database server. This is something that is inside your webhost control panel. See >>images for reference. Link to comment Share on other sites More sharing options...
Guest Posted June 18, 2009 Share Posted June 18, 2009 I'm not following database server? I'm using core ftp and then I'm trying to find where the catalog id's are located so I can edit them to the same id's on my home page just can't believe this is so hard to find. Unless I'm miss understanding what you mean database ? If so how do I access the database? Link to comment Share on other sites More sharing options...
BryceJr Posted June 18, 2009 Share Posted June 18, 2009 I'm not following database server? I'm using core ftp and then I'm trying to find where the catalog id's are located so I can edit them to the same id's on my home page just can't believe this is so hard to find. Unless I'm miss understanding what you mean database ? If so how do I access the database? Re-read post #7. The tables are stored in your database. One of them is the categories table. Your database is located in your database server. Your database sever is somewhere in your webhost control panel. If you dont know the location of your database server and how to access it, you're stuck for now. Control panels differ from one webhost to another. Locations of certain features and services also differ from each other. Link to comment Share on other sites More sharing options...
Guest Posted June 18, 2009 Share Posted June 18, 2009 Ok your saying I can't make the chnages by just connecting to my website using my ftp connection all the files and folders are their but the changes I need to fix the site are in a database located in my control panal through I'm using godaddy. And no I can't get to my control panel because I don't remember the password lol. But i don't remember any database inside the cotrol panel? Thats where I can change passwords add emails my account payments etc. Is this what your telling me? Mike Link to comment Share on other sites More sharing options...
Guest Posted June 18, 2009 Share Posted June 18, 2009 To Set up a SQL Server Database for Your Web Site Is this what I should be looking for?********** see below Log in to your Account Manager. In the My Products section, select Hosting. Next to the hosting account you want to modify, click Manage Account. In the Databases section of the Hosting Control Center, click the SQL Server icon.********** Click Create New Database. Enter a description. If you want to use DSN with this database, select Create DSN. If you want to use an ASP Schema with this database, select ASP Schema. Enter a database name. Enter a user name and password. Specify whether you want to allow Direct Database Access. Link to comment Share on other sites More sharing options...
Guest Posted June 18, 2009 Share Posted June 18, 2009 I went to my hosting control panel and the only data base in there is MyQsl it this the database I need to go into to fix the admin catalog Thanks Mike Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.