Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1054 uknknown Column 'tax_class_id' in 'field list'


rockyroger

Recommended Posts

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..

Link to comment
Share on other sites

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());

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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..

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

 

Copyright © 2010 osCommerce

 

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');

 

?>

 

<table border="0" width="100%" cellspacing="0" cellpadding="2">

 

<tr>

 

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

 

<tr>

 

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

 

<td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

 

</tr>

 

</table></td>

 

</tr>

 

<tr>

 

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

 

<tr>

 

<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">

 

<tr class="dataTableHeadingRow">

 

<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_TAX_CLASSES; ?></td>

 

<td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_ACTION; ?> </td>

 

</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"><?php echo $classes['tax_class_title']; ?></td>

 

<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>

 

<td colspan="2"><table border="0" width="100%" cellspacing="0" cellpadding="2">

 

<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>

 

<td class="smallText" colspan="2" align="right"><?php echo tep_draw_button(IMAGE_NEW_TAX_CLASS, 'plus', tep_href_link(FILENAME_TAX_CLASSES, 'page=' . $HTTP_GET_VARS['page'] . '&action=new')); ?></td>

 

</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');

 

?>

Link to comment
Share on other sites

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

To improve is to change; to be perfect is to change often.

 

Link to comment
Share on other sites

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?

post-321107-0-35373000-1366662198_thumb.jpg

post-321107-0-25943000-1366662251_thumb.jpg

Link to comment
Share on other sites

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

To improve is to change; to be perfect is to change often.

 

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

To improve is to change; to be perfect is to change often.

 

Link to comment
Share on other sites

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

To improve is to change; to be perfect is to change often.

 

Link to comment
Share on other sites

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!!

To improve is to change; to be perfect is to change often.

 

Link to comment
Share on other sites

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...

post-321107-0-37063900-1366747366_thumb.jpg

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...