Help needed....

[Thalbitzer]

Hi,

 

I have tried to to install the contribution "subcategory textboxes" but it seems that I'm doing something wrong, I keep getteing this message:

 

1146 - Table 'Thalbit_oscommerce_st0.extra_cat_info' doesn't exist

 

select categories_description.categories_id, categories_name from categories left join categories_description using (categories_id) left join extra_cat_info on extra_cat_info.categories_id = categories_description.categories_id where extra_cat_info.categories_id is null and parent_id !=0 and categories_description.language_id=4 order by categories_name

 

[TEP STOP]

 

To be honest I do not have any clue what it says (I can read it but, as I'm not a genius with php - I do not understand what it says) - and I do not know how to correct the mistake....... :blink:

 

Can anyone help me to fix this little problem?

 

Thanks in advance :)

 

Best regards

Christine

[Thalbitzer]

You have not run the SQL that creates the new database bits and pieces.

 

 

Hi,

 

Thanks - could you tell me a little about what that is?

I'm pretty new with this oscommerce webshop :rolleyes:

 

I've read the installation guide and I did see that the first mark was "1. Run subcategory_textboxes.sql ** This is not optional! **"- but I thought that was what happend when I followed the installation guide :huh:

- my mistake

 

Could you tell me how to run this SQL, what do I have to do - is it me or the hosting company or do you have a link where I can read about SQL and how to make it work?

 

Thanks in advance

 

Best regards

Christine :blink:

[Guest]

Most webhosts have a control panel that you log into.

 

When you have logged into the control panel , you will have to find the databases section.

 

Click on the phpMyAdmin icon.

 

Select the user to configure database via phpMyAdmin and click on the Login icon.

 

A new window should open for phpMyAdmin.

 

In some cases, you may have to choose which database your OSC tables are located on. If this is the case, please choose the database from the list or the drop down box at the left.

 

To run a SQL query, click on "SQL" on the navigation bar (on the right side, click on the SQL tab at the top).

 

Then copy the code from the sql file and paste the code into the textarea on that page.

 

Click on the GO button and it is done.

 

If all goes well, your SQL query will now be succesfully entered.

[Thalbitzer]

Hi,

 

Thanks for the information - I'll see if I can make it work - otherwise I'll come back :)

 

Best regards

Christine

[Thalbitzer]

Hi again,

 

I'm still working with this probleme of mine with the subcategory textboxes - I can't make it work.

I have run the SQL textfile and the hosting company has confirmed that the query has been made - but I still get the same error:

 

"1146 - Table 'Thalbit_oscommerce_st0.extra_cat_info' doesn't exist

 

select categories_description.categories_id, categories_name from categories left join categories_description using (categories_id) left join extra_cat_info on extra_cat_info.categories_id = categories_description.categories_id where extra_cat_info.categories_id is null and parent_id !=0 and categories_description.language_id=4 order by categories_name

 

[TEP STOP]"

 

Have I overlooked something or doesn't this contribution work with my workshop - should I just give up and find an other solution?

 

Any advice and help will be most appreciated :huh:

 

Thanks in advance

 

Best regards

Christine