Please help!

[Guest]

1146 - Table 'pearlga_osc1.TABLE_PRODUCTS_EXTRA_FIELDS' doesn't exist

 

SELECT pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value FROM TABLE_PRODUCTS_EXTRA_FIELDS pef LEFT JOIN TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS ptf ON ptf.products_extra_fields_id = pef.products_extra_fields_id WHERE ptf.products_id = 431 AND ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='1') ORDER BY products_extra_fields_order

 

[TEP STOP]

 

 

 

 

I get this error message on checkout process.php. The order comes through but the above error comes up instead of the 'thankyou' page.

 

I have tried to re-install the 'extra fields contribution and checked all the table defines are correct and re-ran the sql query supplied. I have even tried to remove all trace of this contribution, which is where I am at now, but still getting the above error.

 

 

HELP!!!! anybody got any ideas??

[Guest]

looks like you forgot to add the definition for this table in catalog\includes\database_tables.php

[Guest]

looks like you forgot to add the definition for this table in catalog\includes\database_tables.php

 

 

I have added the table defines and it has not helped. I am going to try a complete re-install of the module again. Not sure where else to go with this.

[Guest]

I have added the table defines and it has not helped. I am going to try a complete re-install of the module again. Not sure where else to go with this.

you mean it is the same error? (as I really doubt it) And make sure you run the sql with phpmyadmin.

[Guest]

you mean it is the same error? (as I really doubt it) And make sure you run the sql with phpmyadmin.

 

 

It is the same error yes and I have used phpmyadmin. Still looking for the solution. I will post it when I find it (if I find it:/)

[Guest]

It is the same error yes and I have used phpmyadmin. Still looking for the solution. I will post it when I find it (if I find it:/)

You used phpmyadmin for what? The table definitions should be part of the catalog\includes\database_tables.php osc file. You cannot run that particular error query in phpmyadmin because you do not specify the correct table names.

Make sure you have the definitions in the correct file I mentioned.

[Guest]

You used phpmyadmin for what? The table definitions should be part of the catalog\includes\database_tables.php osc file. You cannot run that particular error query in phpmyadmin because you do not specify the correct table names.

Make sure you have the definitions in the correct file I mentioned.

 

 

I have removed all trace of the module and then re-installed it again. This may well be a classic case of needing to concentrate more on these things :/ it works fine now :)

[Melhor]

I have the same error. I double check my input and start all over again on a clean install, still got the error 1146 - Table 'kozak_xxxxxxx.TABLE_PRODUCTS_EXTRA_FIELDS' doesn't exist.

 

SELECT products_extra_fields_id, products_extra_fields_name, products_extra_fields_category, products_extra_fields_type, products_extra_fields_order, products_extra_fields_status from TABLE_PRODUCTS_EXTRA_FIELDS ORDER BY products_extra_fields_category

 

[TEP STOP]

 

I import again in phpmyadmin. Result ; #1050 - Table 'products_extra_fields' already exists, but when i search on this table i got 0.

 

This is the sql : CREATE TABLE `products_extra_fields` (

`products_extra_fields_id` int(11) NOT NULL auto_increment,

`products_extra_fields_name` varchar(64) NOT NULL default '',

`products_extra_fields_vendor` tinyint(2) NOT NULL default '0',

`products_extra_fields_category` int(36) NOT NULL default '1',

`products_extra_fields_type` varchar(12) NOT NULL default '',

`products_extra_fields_order` int(3) NOT NULL default '0',

`products_extra_fields_status` tinyint(1) NOT NULL default '1',

PRIMARY KEY (`products_extra_fields_id`)

) TYPE=MyISAM AUTO_INCREMENT=40 ;

 

--

-- --------------------------------------------------------

 

--

-- Table structure for table `products_to_products_extra_fields`

--

 

CREATE TABLE `products_to_products_extra_fields` (

`products_id` int(11) NOT NULL default '0',

`products_extra_fields_id` int(11) NOT NULL default '0',

`products_extra_fields_value` text,

PRIMARY KEY (`products_id`,`products_extra_fields_id`)

) TYPE=MyISAM;

 

thanks for help

 

kozak

[MrPhil]

What you are missing in your includes/database_tables.php and admin/includes/database_tables.php is the line

define('TABLE_PRODUCTS_EXTRA_FIELDS','products_extra_fields');

You installation is incomplete. The table is defined in MySQL, but you're not telling osC the name. Per earlier posts, there may be other missing definitions, such as

define('TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS','products_to_products_extra_fields');