1054 uknknown Column 'tax_class_id' in 'field list'

rockyroger · April 21, 2013

I am trying to set up a new T-shirt shop, and when I try to make a product, I get this error mesage:

1054 - Unknown column 'tax_class_id' in 'field list'

select tax_class_id, tax_class_title from tax_class order by tax_class_title

I have been trying to solve this for 7 hours, and I can`t seem to find out where the error might be...

Does anyone have a solution where to start?

Roger, newbee..

MrPhil · April 21, 2013

This is a new installation? Perhaps something went wrong with the database creation process. Go in to phpMyAdmin and examine the tax_class table. According to catalog/install/oscommerce.sql, it should be:

TABLE tax_class 
 tax_class_id int NOT NULL auto_increment,
 tax_class_title varchar(32) NOT NULL,
 tax_class_description varchar(255) NOT NULL,
 last_modified datetime NULL,
 date_added datetime NOT NULL,

 PRIMARY KEY (tax_class_id)

Does your tax_class exist, and does its structure look like this? You may have to edit the structure to fix it.

Then, it should have been initialized with one row:

INSERT INTO tax_class VALUES (1, 'Taxable Goods', 'The following types of products are included non-food, services, etc', now(), now());

rockyroger · April 21, 2013

Hello!

Thank you for the fast reply!

When I go to the Tax_class I get this error message:

1054 - Unknown column 'tax_class_id' in 'field list'

select tax_class_id, tax_class_title, tax_class_description, last_modified, date_added from tax_class order by tax_class_title limit 0, 20

I am new to this, and a beginner with this software..

Roger

rockyroger · April 21, 2013

I found the tax_class table in the php admin on my webserver. Clicking on the notepad sends me directly to the Oscommerce login page.

Anyone else who are experiencing this issue?

I can`t seem to add any products because of this error..

MrPhil · April 22, 2013

Go in to phpMyAdmin and examine the tax_class table.

I didn't say run it. I didn't say click on notepad. Go in to phpMyAdmin and look at the structure of this table. Does it match what it's supposed to be?

rockyroger · April 22, 2013

Hi!

Maybe I am to new in this program, but where do I find the phpMyAdmin?

Going into the File Manager on the server and click on the tax_class it sends me right back to the Oscommerce administrator page..

I opened the tax_class in the downloaded software and it looks like this:

<?php

/*

$Id$

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

*/

require('includes/application_top.php');

$action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');

if (tep_not_null($action)) {

switch ($action) {

case 'insert':

$tax_class_title = tep_db_prepare_input($HTTP_POST_VARS['tax_class_title']);

$tax_class_description = tep_db_prepare_input($HTTP_POST_VARS['tax_class_description']);

tep_db_query("insert into " . TABLE_TAX_CLASS . " (tax_class_title, tax_class_description, date_added) values ('" . tep_db_input($tax_class_title) . "', '" . tep_db_input($tax_class_description) . "', now())");

tep_redirect(tep_href_link(FILENAME_TAX_CLASSES));

break;

case 'save':

$tax_class_id = tep_db_prepare_input($HTTP_GET_VARS['tID']);

$tax_class_title = tep_db_prepare_input($HTTP_POST_VARS['tax_class_title']);

$tax_class_description = tep_db_prepare_input($HTTP_POST_VARS['tax_class_description']);

tep_db_query("update " . TABLE_TAX_CLASS . " set tax_class_id = '" . (int)$tax_class_id . "', tax_class_title = '" . tep_db_input($tax_class_title) . "', tax_class_description = '" . tep_db_input($tax_class_description) . "', last_modified = now() where tax_class_id = '" . (int)$tax_class_id . "'");

tep_redirect(tep_href_link(FILENAME_TAX_CLASSES, 'page=' . $HTTP_GET_VARS['page'] . '&tID=' . $tax_class_id));

break;

case 'deleteconfirm':

$tax_class_id = tep_db_prepare_input($HTTP_GET_VARS['tID']);

tep_db_query("delete from " . TABLE_TAX_CLASS . " where tax_class_id = '" . (int)$tax_class_id . "'");

tep_redirect(tep_href_link(FILENAME_TAX_CLASSES, 'page=' . $HTTP_GET_VARS['page']));

break;

}

require(DIR_WS_INCLUDES . 'template_top.php');

?>

<tr>

<tr>

</tr>

</table></td>

</tr>

<tr>

<tr>

</tr>

<?php

$classes_query_raw = "select tax_class_id, tax_class_title, tax_class_description, last_modified, date_added from " . TABLE_TAX_CLASS . " order by tax_class_title";

$classes_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $classes_query_raw, $classes_query_numrows);

$classes_query = tep_db_query($classes_query_raw);

while ($classes = tep_db_fetch_array($classes_query)) {

if ((!isset($HTTP_GET_VARS['tID']) || (isset($HTTP_GET_VARS['tID']) && ($HTTP_GET_VARS['tID'] == $classes['tax_class_id']))) && !isset($tcInfo) && (substr($action, 0, 3) != 'new')) {

$tcInfo = new objectInfo($classes);

}

if (isset($tcInfo) && is_object($tcInfo) && ($classes['tax_class_id'] == $tcInfo->tax_class_id)) {

echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_TAX_CLASSES, 'page=' . $HTTP_GET_VARS['page'] . '&tID=' . $tcInfo->tax_class_id . '&action=edit') . '\'">' . "\n";

} else {

echo' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_TAX_CLASSES, 'page=' . $HTTP_GET_VARS['page'] . '&tID=' . $classes['tax_class_id']) . '\'">' . "\n";

}

?>

<td class="dataTableContent" align="right"><?php if (isset($tcInfo) && is_object($tcInfo) && ($classes['tax_class_id'] == $tcInfo->tax_class_id)) { echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . tep_href_link(FILENAME_TAX_CLASSES, 'page=' . $HTTP_GET_VARS['page'] . '&tID=' . $classes['tax_class_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?> </td>

</tr>

<?php

}

?>

<tr>

<tr>

<td class="smallText" valign="top"><?php echo $classes_split->display_count($classes_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_TAX_CLASSES); ?></td>

<td class="smallText" align="right"><?php echo $classes_split->display_links($classes_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page']); ?></td>

</tr>

<?php

if (empty($action)) {

?>

<tr>

</tr>

<?php

}

?>

</table></td>

</tr>

</table></td>

<?php

$heading = array();

$contents = array();

switch ($action) {

case 'new':

$heading[] = array('text' => '<strong>' . TEXT_INFO_HEADING_NEW_TAX_CLASS . '</strong>');

$contents = array('form' => tep_draw_form('classes', FILENAME_TAX_CLASSES, 'page=' . $HTTP_GET_VARS['page'] . '&action=insert'));

$contents[] = array('text' => TEXT_INFO_INSERT_INTRO);

$contents[] = array('text' => '<br />' . TEXT_INFO_CLASS_TITLE . '<br />' . tep_draw_input_field('tax_class_title'));

$contents[] = array('text' => '<br />' . TEXT_INFO_CLASS_DESCRIPTION . '<br />' . tep_draw_input_field('tax_class_description'));

$contents[] = array('align' => 'center', 'text' => '<br />' . tep_draw_button(IMAGE_SAVE, 'plus', null, 'primary') . tep_draw_button(IMAGE_CANCEL, 'close', tep_href_link(FILENAME_TAX_CLASSES, 'page=' . $HTTP_GET_VARS['page'])));

break;

case 'edit':

$heading[] = array('text' => '<strong>' . TEXT_INFO_HEADING_EDIT_TAX_CLASS . '</strong>');

$contents = array('form' => tep_draw_form('classes', FILENAME_TAX_CLASSES, 'page=' . $HTTP_GET_VARS['page'] . '&tID=' . $tcInfo->tax_class_id . '&action=save'));

$contents[] = array('text' => TEXT_INFO_EDIT_INTRO);

$contents[] = array('text' => '<br />' . TEXT_INFO_CLASS_TITLE . '<br />' . tep_draw_input_field('tax_class_title', $tcInfo->tax_class_title));

$contents[] = array('text' => '<br />' . TEXT_INFO_CLASS_DESCRIPTION . '<br />' . tep_draw_input_field('tax_class_description', $tcInfo->tax_class_description));

$contents[] = array('align' => 'center', 'text' => '<br />' . tep_draw_button(IMAGE_SAVE, 'disk', null, 'primary') . tep_draw_button(IMAGE_CANCEL, 'close', tep_href_link(FILENAME_TAX_CLASSES, 'page=' . $HTTP_GET_VARS['page'] . '&tID=' . $tcInfo->tax_class_id)));

break;

case 'delete':

$heading[] = array('text' => '<strong>' . TEXT_INFO_HEADING_DELETE_TAX_CLASS . '</strong>');

$contents = array('form' => tep_draw_form('classes', FILENAME_TAX_CLASSES, 'page=' . $HTTP_GET_VARS['page'] . '&tID=' . $tcInfo->tax_class_id . '&action=deleteconfirm'));

$contents[] = array('text' => TEXT_INFO_DELETE_INTRO);

$contents[] = array('text' => '<br /><strong>' . $tcInfo->tax_class_title . '</strong>');

$contents[] = array('align' => 'center', 'text' => '<br />' . tep_draw_button(IMAGE_DELETE, 'trash', null, 'primary') . tep_draw_button(IMAGE_CANCEL, 'close', tep_href_link(FILENAME_TAX_CLASSES, 'page=' . $HTTP_GET_VARS['page'] . '&tID=' . $tcInfo->tax_class_id)));

break;

default:

if (isset($tcInfo) && is_object($tcInfo)) {

$heading[] = array('text' => '<strong>' . $tcInfo->tax_class_title . '</strong>');

$contents[] = array('align' => 'center', 'text' => tep_draw_button(IMAGE_EDIT, 'document', tep_href_link(FILENAME_TAX_CLASSES, 'page=' . $HTTP_GET_VARS['page'] . '&tID=' . $tcInfo->tax_class_id . '&action=edit')) . tep_draw_button(IMAGE_DELETE, 'trash', tep_href_link(FILENAME_TAX_CLASSES, 'page=' . $HTTP_GET_VARS['page'] . '&tID=' . $tcInfo->tax_class_id . '&action=delete')));

$contents[] = array('text' => '<br />' . TEXT_INFO_DATE_ADDED . ' ' . tep_date_short($tcInfo->date_added));

$contents[] = array('text' => '' . TEXT_INFO_LAST_MODIFIED . ' ' . tep_date_short($tcInfo->last_modified));

$contents[] = array('text' => '<br />' . TEXT_INFO_CLASS_DESCRIPTION . '<br />' . $tcInfo->tax_class_description);

}

break;

}

if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) {

echo ' <td width="25%" valign="top">' . "\n";

$box = new box;

echo $box->infoBox($heading, $contents);

echo ' </td>' . "\n";

}

?>

</tr>

</table></td>

</tr>

</table>

<?php

require(DIR_WS_INCLUDES . 'template_bottom.php');

require(DIR_WS_INCLUDES . 'application_bottom.php');

?>

♥14steve14 · April 22, 2013

Phpmyadmim can be found in your hosting cpanel if you have it. It will allow you to see, open and alter your database.

MrPhil · April 22, 2013

Ask your host where phpMyAdmin (or whatever the equivalent is they're using), and how to use it. It's possible that they use something else instead.

rockyroger · April 22, 2013

I found it!

This is what it looks like:

rockyroger · April 22, 2013

I am sorry, but I do not understand all this...

I might remove the whole thing and install it one more time and see if that helps..

♥joli1811 · April 22, 2013

Hi Roger,

Attached is screenshot of tax class table 2.3 series not sure what you have got there !!

If it is a new installation it would be better to reinstall the database completely as other files may also be corrupted

Regards

Joli

rockyroger · April 22, 2013

I have now removed it all and are installing everything one more time.

Hope it works better this time...

If not I will look for another program that might works..

♥joli1811 · April 22, 2013

Oh it works just have to do it right :thumbsup:

rockyroger · April 22, 2013

I just downloaded and installed everything again - and guess what?

I get the same error... !! It will not let me get any further than the tax_class.... and I can`t see what I do wrong, or where to fix it..

I use the 2.3.3

attached is the new screenshot of the php and the error message..

Can anyone please point me in the right direction please?

♥joli1811 · April 22, 2013

Go to phpmyadmin

MySQL® Databases

delete database mysql01

create new database mysql02 add user and password

go to phpMyAdmin click on database mysql02

go to import at the top and then search for your 2.33 download on your computer

open oscommerce-2.3.3/catalog/install/oscommerce.sql and import

Go to catalog/includes/configure.php

and

catalog/admin/includes/configure.php

open with a text editor change the DB entry's so that they correspond with the new database that you created

define('DB_SERVER_USERNAME', 'xxxxx');

define('DB_SERVER_PASSWORD', 'xxxxx');

define('DB_DATABASE', 'xxxxx');

and upload with a ftp program filezilla is good and free)

Should work do not really understand why you are seeing

innoDB free: 0KB at the top.

if the import does not work I would take the issue up with my hosting provider

Regards

Joli

MrPhil · April 23, 2013

That looks nothing like the tax_class table defined in osC 2.3.3. What version are you using? If it's osC 3.0, scrap everything and start over with 2.3.3. If you're on osC 2.2 RC2a because a template you need only works with that version, we'll have to see what we can do.

rockyroger · April 23, 2013

I am using the 2.3.3 verison. Just downloaded from the Oscommerce website.. Everything goes fine with the installation -until I try to create an item. Then the issue with the tax appears..

♥joli1811 · April 23, 2013

Yes roger and will continue until you get the database sorted.

regards

joli

rockyroger · April 23, 2013

To be honest, I am getting a bit frustrated here... How do I delete the mysql01 database...?

♥joli1811 · April 23, 2013

Go to phpmyadmin

MySQL® Databases

delete database mysql01

create new database mysql02 add user and password

go to phpMyAdmin click on database mysql02

go to import at the top and then search for your 2.33 download on your computer

open oscommerce-2.3.3/catalog/install/oscommerce.sql and import

Go to catalog/includes/configure.php

and

catalog/admin/includes/configure.php

open with a text editor change the DB entry's so that they correspond with the new database that you created

define('DB_SERVER_USERNAME', 'xxxxx');

define('DB_SERVER_PASSWORD', 'xxxxx');

define('DB_DATABASE', 'xxxxx');

and upload with a ftp program filezilla is good and free)

Should work do not really understand why you are seeing

innoDB free: 0KB at the top.

if the import does not work I would take the issue up with my hosting provider

Regards

Joli

Go to your cpanel and Just read carefully take your time it is a learning curve but with a bit of patience I am quite sure you will get there

Starts to make fun when the things work :thumbsup:

Regards

Joli

rockyroger · April 23, 2013

Hello! There are no way to delete the mysql01 database..!

This is what I se when I

Go to phpmyadmin

MySQL® Databases

I am sorry - but I am new to this...

♥joli1811 · April 23, 2013

Hi,

Sorry when I said

Go to phpmyadmin / MySQL® Databases / delete database mysql01

It should have been

Go to cpanel / MySQL® Databases / delete database mysql01

You can NOT delete the database in phpmyadmin

Look for MySQL Databases this is another button somewhere in your control panel

apologies

Joli

rockyroger · April 23, 2013

I am sorry... Where do I find the cpanel..?

♥joli1811 · April 23, 2013

Well a lot of hosting providers have different names but if you can access phpmyadmin you are already in your

cpanel / zpanel or whatever it is called.

cpanel = control panel

so now you got to find where your database/s are stored

Check the welcome mail from your hosting provider the details should be there!!

rockyroger · April 23, 2013

Hello again..

I am using Myhosting. The only thing in the control panel that shows where the datase is this.

Clicking on this leads me to the login for the phpmyadmin

I contacted the host manager support and were told it is not possible to remove the database...

1054 uknknown Column 'tax_class_id' in 'field list'

Recommended Posts

rockyroger

MrPhil

rockyroger

rockyroger

MrPhil

rockyroger

♥14steve14

MrPhil

rockyroger

rockyroger

♥joli1811

rockyroger

♥joli1811

rockyroger

♥joli1811

MrPhil

rockyroger

♥joli1811

rockyroger

♥joli1811

rockyroger

♥joli1811

rockyroger

♥joli1811

rockyroger

Archived

Browse

Activity