joncg7 Posted May 2, 2009 Posted May 2, 2009 I have been populating /building my site everything was going fine and looked fine from the shop side and back side until I decided to upload/ install a PDF contribution to allow customers to download a manual or literature of my individual products. When I ventured into the database I ran into this: Error SQL query: ALTER TABLE `products` ADD `products_pdfupload` VARCHAR( 64 ) AFTER `products_image` ; MySQL said: #1146 - Table 'fireplacesupplywholesale_com.products' doesn't exist I think I am going to have to get professional help this is beyond my paygrade
FIMBLE Posted May 2, 2009 Posted May 2, 2009 do products still show up? If so the table is still there, if not you can take out the database table from the database in the install folder that you downloaded. In any case if you look at your database via phpmy admin you can see if its there or not, i would be surprised if it was not Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions
joncg7 Posted May 2, 2009 Author Posted May 2, 2009 do products still show up?If so the table is still there, if not you can take out the database table from the database in the install folder that you downloaded. In any case if you look at your database via phpmy admin you can see if its there or not, i would be surprised if it was not Nic Thank You for your help Nic, Yes the products show up in my catalog under "categories/products". looked in PHPmyadmin There are two tables: 1)documents and 2)documents_products. that is it. Is it a semantics thing? am I missing something? My computer tech guy said that maybe my "copy" of OScommerce is too butchered up because it was part of a package from my host. Is there a simple way around this missing table?? I am afraid that other contribs wont work either if this relatively simple add cant be accomplished.
FIMBLE Posted May 2, 2009 Posted May 2, 2009 Neither of these are oscommerce tables, the initial table for products is products, then products_descriptions etc... Your tech guy is wrong to suggest that the osc is butchered up, if things are done properly then there is not a limit as such to the contributions you are able to add. Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions
FIMBLE Posted May 2, 2009 Posted May 2, 2009 unless of course you are using a prefix to the table names, in this case find out which is being used and then alter the SQL to match Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions
joncg7 Posted May 2, 2009 Author Posted May 2, 2009 unless of course you are using a prefix to the table names, in this case find out which is being used and then alter the SQL to match Nic Could the table be invisible to me or am I looking in the wrong area? I am new to all this. I am in the control panel in administrative area of my host site. Click on my SQL database, then click on my actual database name. Then click on manage database and it brings me to PHPmyadmin localhost > fireplacesupplywholesale_com > documents_products. Funny thing is I don't know what it is supposed to look like. Again I think I need professional help to solve this. Because I do not see any table with products in it. I am completely confused. Thanks for the help
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.