Creloaded template gives error
You must have noticd several time that the creloaded template when installed gives error
The simplest solution is as follows
Eg error
1054 - Unknown column ‘popt.products_options_name’ in ‘field list’
select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from products_options popt, products_options_values poval, products_attributes pa where pa.products_id = ‘698{2}7′ and pa.options_id = ‘2′ and pa.options_id = popt.products_options_id and pa.options_values_id = ‘7′ and pa.options_values_id = poval.products_options_values_id and popt.language_id = ‘1′ and poval.language_id = ‘1′
Note this happens only on products that have options, like color, and sizes.
The best solution to such error ;
1. Notice the URL . In the above error the page would be http://domain.com/shopping_cart.php
2. Now open the template folder
3. Open the content folder
4. Copy the shopping_cart.tpl.php (for above example) and paste it into your active template’s content folder
Thats it. You are done.
The logic behind is that your template behind might not be compatible with the latest version of the crelaoded. So we are copying the sample template tpl file (which is provided with the creloaded itself ) to out new template.
If you enjoyed this post and found it useful, please write your comments. You comments would encourage us to write more. Also make sure you subscribe to our RSS feed!
We Provide Custom PHP Programming for Joomla , Wordpress, OScommerce, Creloaded, Xcart and any other opensource solution you can think of at www.technoIntellects.com.
Get our Joomla Hosting Packages at the affordable price with unlimited services
Comments
8 Responses to “Creloaded template gives error”
Leave a Reply
-
RSS Feeds
Pretty nice site, wants to see much more on it!
Hello, thanks for your solutions. I have an similar error but don’t know if I can use the same solution to solve that. My website has been used the template for 2 full years and work fine until Yesterday! What I got is error code below:
1054 - Unknown column ‘p.products_id’ in ‘on clause’
select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_price1,p.products_price2,p.products_price3,p.products_price4, p.products_price5,p.products_price6,p.products_price7,p.products_price8,p.products_price9,p.products_price10,p.products_price11, p.products_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_price4_qty, p.products_price5_qty,p.products_price6_qty,p.products_price7_qty,p.products_price8_qty,p.products_price9_qty,p.products_price10_qty,p.products_price11_qty, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_id = ‘1446′ and pd.products_id = ‘1446′ and pd.language_id = ‘1′
When the add to cart button is click, it shows up this error and then the website just doesn’t work anymore.
Any idea?? Thanks for any help, greatly appreciated.
Grace
How i may contact admin this site? I have a question.
iijiivei
Hi chelolync
Please leave your Queries or comments in the the comment box here and I will get it.
Hi,
I have the same problem on my site, I get the error messege:
——————————————-
1054 - Unknown column ‘popt.products_options_name’ in ‘field list’
select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix from products_options popt, products_options_values poval, products_attributes pa where pa.products_id = ‘3′ and pa.options_id = ‘2′ and pa.options_id = popt.products_options_id and pa.options_values_id = ‘2′ and pa.options_values_id = poval.products_options_values_id and popt.language_id = ‘3′ and poval.language_id = ‘3′
——————————————-
I tried to compy the file shopping_cart.php as you suggested into me templates content folder, but that did not help I still get the same error messege. You have any ideas on how I can fix this issue?
Your Web Site is really wonderful and I bookmarked it. Thank your for the hard work you must have put in to create this wonderful facility. Keep up the excellent work!
well, hi admin adn people nice forum indeed. how’s life? hope it’s introduce branch
well, hi admin adn people nice forum indeed. how’s life? hope it’s introduce branch