robertgouveia Posted August 11, 2006 Share Posted August 11, 2006 hi ive tried to install a florist site and i get this message on the actuall site 1146 - Table 'pristine_florist.whos_online' doesn't exist delete from whos_online where time_last_click < '1155327787' [TEP STOP] can someone point me in the right direction please Link to comment Share on other sites More sharing options...
Gil_e_n Posted August 11, 2006 Share Posted August 11, 2006 Looks like for some reason your who's online table didn't get created during the install. If that's the only thing wrong with your site, just run this query: CREATE TABLE whos_online ( customer_id int, full_name varchar(64) NOT NULL, session_id varchar(128) NOT NULL, ip_address varchar(15) NOT NULL, time_entry varchar(14) NOT NULL, time_last_click varchar(14) NOT NULL, last_page_url varchar(255) NOT NULL ); Always BACK UP your files and your database before making any changes. Before asking questions, check out the Knowledge Base. Check out the contributions to see if your problem's solved there. Search the forums. Useful threads: Store Speed Optimization How to make a horrible shop Basics for design change How to search the forums Useful contributions: Easypopulate Fast, Easy Checkout Header Tag Controller Link to comment Share on other sites More sharing options...
robertgouveia Posted August 11, 2006 Author Share Posted August 11, 2006 i know this sounds thick but where is this? Link to comment Share on other sites More sharing options...
Gil_e_n Posted August 11, 2006 Share Posted August 11, 2006 If you go to your website's control panel, there should be something for administering your database. Look for database or sql or something along those lines. If you use cpanel (probably the most common control panel), look for "MySQL Databases. Click that. Scroll to the bottom of the page, and look for phpmyadmin. Click on that. If you don't use cpanel, but your host uses phpmyadmin anyway, you can continue to follow these instructions. Go to your oscommerce database (It'll be called pristine_florist). Click on SQL. Copy the query I gave you into the box and hit go. Always BACK UP your files and your database before making any changes. Before asking questions, check out the Knowledge Base. Check out the contributions to see if your problem's solved there. Search the forums. Useful threads: Store Speed Optimization How to make a horrible shop Basics for design change How to search the forums Useful contributions: Easypopulate Fast, Easy Checkout Header Tag Controller Link to comment Share on other sites More sharing options...
robertgouveia Posted August 11, 2006 Author Share Posted August 11, 2006 ive done that and now its saying this 1146 - Table 'pristine_florist.specials' doesn't exist select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0 [TEP STOP] Link to comment Share on other sites More sharing options...
Gil_e_n Posted August 11, 2006 Share Posted August 11, 2006 It looks like your installation didn't import all the tables. For whatever reason. Unless you've made significant changes to your tables already, I'd suggest just importing your oscommerce.sql file in phpmyadmin. If you installed oscommerce yourself, you should find it in the install directory (assuming you haven't deleted it already. If you didn't, you'll need to download another copy of oscommerce and get it from there. Always BACK UP your files and your database before making any changes. Before asking questions, check out the Knowledge Base. Check out the contributions to see if your problem's solved there. Search the forums. Useful threads: Store Speed Optimization How to make a horrible shop Basics for design change How to search the forums Useful contributions: Easypopulate Fast, Easy Checkout Header Tag Controller Link to comment Share on other sites More sharing options...
robertgouveia Posted August 11, 2006 Author Share Posted August 11, 2006 ok when i goto import it gives me a few options like where do i import it to, which Character set do i choose and Number of records(queries) to skip from start Link to comment Share on other sites More sharing options...
Gil_e_n Posted August 11, 2006 Share Posted August 11, 2006 Import it to your pristine_florist database, use the default character set (utf8, I'm assuming) and skip 0 records. Always BACK UP your files and your database before making any changes. Before asking questions, check out the Knowledge Base. Check out the contributions to see if your problem's solved there. Search the forums. Useful threads: Store Speed Optimization How to make a horrible shop Basics for design change How to search the forums Useful contributions: Easypopulate Fast, Easy Checkout Header Tag Controller Link to comment Share on other sites More sharing options...
robertgouveia Posted August 11, 2006 Author Share Posted August 11, 2006 im sorry i ment which file to import from not to, Link to comment Share on other sites More sharing options...
Gil_e_n Posted August 11, 2006 Share Posted August 11, 2006 Go to the oscommerce files I told you to download if you didn't have an install folder in your oscommerce directory. Go to catalog/install and you will see a file calles oscommerce.sql. That's the file you want to import. Always BACK UP your files and your database before making any changes. Before asking questions, check out the Knowledge Base. Check out the contributions to see if your problem's solved there. Search the forums. Useful threads: Store Speed Optimization How to make a horrible shop Basics for design change How to search the forums Useful contributions: Easypopulate Fast, Easy Checkout Header Tag Controller Link to comment Share on other sites More sharing options...
robertgouveia Posted August 11, 2006 Author Share Posted August 11, 2006 thank you for all your help and here is the site you helped me build, thanks again Link to comment Share on other sites More sharing options...
robertgouveia Posted August 11, 2006 Author Share Posted August 11, 2006 http://www.unbeatablehosting.com/florist/ 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.