Catalog and admin -- few Errors , please help

[chowhan]

still with some error in catalog and admin.

 

Error 1. ) I get the Categorias in the infobox but when i click on any link it give me this error ...

 

1054 - Unknown column 'cd.categories_heading_title' in 'field list'

 

select cd.categories_name, cd.categories_heading_title, cd.categories_description, c.categories_image from categories c, categories_description cd where c.categories_id = '30' and cd.categories_id = '30' and cd.language_id = '3'

 

[TEP STOP]

 

 

Error 2.) In ADMIN , Clicking On Some Links i get this error

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 10' at line 1

 

 

In admin/Catalog/Manufacturers it says

 

Manufacturers 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 10' at line 1

 

select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from manufacturers order by manufacturers_name limit 0, 10 limit 0, 10

 

[TEP STOP]

 

 

 

AND

******************************

 

Reviews 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 10' at line 1

 

select reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit 0, 10 limit 0, 10

 

[TEP STOP]

 

 

 

and this one also

 

 

1146 - Table 'DB381514.customers_groups' doesn't exist

 

select customers_group_name, customers_group_id from customers_groups order by customers_group_id

 

[TEP STOP]

 

 

********************

 

Cross-Sell (X-Sell) Admin 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 10' at line 1

 

select p.products_id, p.products_model, pd.products_name, p.products_id from products p, products_description pd where p.products_id = pd.products_id and pd.language_id = "1" order by p.products_id asc limit 0, 10 limit 0, 10

 

[TEP STOP]

 

 

 

***********************

 

 

Customers Search: 1146 - Table 'DB381514.customers_groups' doesn't exist

 

select count(*) as total from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join customers_groups cg on c.customers_group_id = cg.customers_group_id

 

[TEP STOP]

*****************************

 

 

Countries 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 10' at line 1

 

select countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id from countries order by countries_name limit 0, 10 limit 0, 10

 

[TEP STOP]

 

 

 

 

 

 

And a lot more similar error with different link.

 

 

Can someone Please explain me why is this happening, and what is the solve os this problem , please i am not an expert so please try to explain.

 

Thanks

Regards

Chowhan

[Jan Zonjee]

still with some error in catalog and admin.

 

Can someone Please explain me why is this happening, and what is the solve os this problem , please i am not an expert so please try to explain.

You just answered your own question. You have no clue what you are doing but still messing with things. It would be a good idea to read a beginners book on PHP.

 

 

Error 1. ) I get the Categorias in the infobox but when i click on any link it give me this error ...

 

1054 - Unknown column 'cd.categories_heading_title' in 'field list'

The error says it all: there is no field categories_heading_title in the table categories_decription. You probably didn't run an sql statement.

 

Error 2.) In ADMIN , Clicking On Some Links i get this error

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 10' at line 1

In admin/Catalog/Manufacturers it says

 

Manufacturers 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 10' at line 1

 

select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from manufacturers order by manufacturers_name limit 0, 10 limit 0, 10

You can't have twice limit 0,10 like in limit 0,10 limit 0,10. You messed with code to add that. Only you know where you put that. Because you get the error multiple times it might be in the class admin/includes/classes/split_page_results.php

 

Customers Search: 1146 - Table 'DB381514.customers_groups' doesn't exist

The error says it all: there is not table customers_groups in the database. The SPPC contribution tells you to run the sppc_v42_install.sql. That adds that table to your database (among other things):

 

DROP TABLE IF EXISTS `customers_groups`;
CREATE TABLE customers_groups (
customers_group_id smallint UNSIGNED NOT NULL,
customers_group_name varchar(32) NOT NULL default '',
customers_group_show_tax enum('1','0') NOT NULL,
customers_group_tax_exempt enum('0','1') NOT NULL,
group_payment_allowed varchar(255) NOT NULL default '',
group_shipment_allowed varchar(255) NOT NULL default '',
group_specific_taxes_exempt varchar(255) NOT NULL default '',
PRIMARY KEY (customers_group_id)
);

INSERT INTO `customers_groups` VALUES('0','Retail','1','0','','','');

 

Not clear on how you messed that up.