motoenvena
Pioneers-
Posts
17 -
Joined
-
Last visited
Profile Information
-
Real Name
Nacho
motoenvena's Achievements
-
[Contribtion] Year/Make/Model for OSC v2.3.x
motoenvena replied to a topic in General Add-Ons Support
Sure?? :D It's a relief for me to read your reply. From Google Spain, with Firefox is very slow. I'm afraid that harm me in Google search results because of slow execution times. @@joli1811, thanks for your reply. -
motoenvena reacted to a post in a topic: [Contribtion] Year/Make/Model for OSC v2.3.x
-
[Contribtion] Year/Make/Model for OSC v2.3.x
motoenvena replied to a topic in General Add-Ons Support
Hello: I found that when refresh the page, the SQL queries running quickly. [157] => 0.033258 etc etc etc.... [349] => 0.019945 This has made me think that the problem may be caused by cookies check when entering the first page. Can this be possible? The reality is that the page refreshes in 3 seconds when initially almost takes 13 to open. Thank you very much for your opinions and advice. Regards, -
[Contribtion] Year/Make/Model for OSC v2.3.x
motoenvena replied to a topic in General Add-Ons Support
Hello everyone, I checked the web and there are two particularly slow queries. I point these two queries if you can give me some advice: " Parse Time: 12.822s Current Parse Time: 12.823 s with 459 queries QUERY DEBUG: Array ( [QUERIES] => Array ( [0] => select value from sessions where sesskey = '88d2b2c52b144df681f7b8437b138038' and expiry > '1376319442' [1] => select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies [2] => select languages_id, name, code, image, directory from languages order by sort_order [3] => delete from whos_online where time_last_click < '1376318542' [4] => select count(*) as count from whos_online where session_id = '88d2b2c52b144df681f7b8437b138038' [5] => update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '87.221.28.120', time_last_click = '1376319442', last_page_url = '/' etc etc etc.... [157] => select distinct products_car_make, products_car_model, products_car_year_bof, products_car_year_eof from products_ymm where products_car_make != '' and products_car_model != '' and products_car_year_bof !=0 and products_car_year_eof != 0 order by products_car_make, products_car_model, products_car_year_bof, products_car_year_eof etc etc etc.... [349] => SELECT cd.categories_alt_imagen, p.products_id, p.products_image, p.products_tax_class_id, IF (s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, p.products_price, pd.products_name FROM products p LEFT JOIN specials s ON p.products_id = s.products_id LEFT JOIN products_description pd ON p.products_id = pd.products_id AND pd.language_id = '3' LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id LEFT JOIN categories_description cd ON p2c.categories_id = cd.categories_id LEFT JOIN featured f ON p.products_id = f.products_id WHERE cd.categories_id = p2c.categories_id and cd.language_id = '3' and p.products_status = '1' AND f.status = '1' order by rand(692469238) DESC limit 9 etc etc etc.... ) [TIME] => Array ( [0] => 0.005322 [1] => 0.001707 [2] => 0.002025 [3] => 0.002469 [4] => 0.002716 [5] => 0.003216 etc etc etc.... [157] => 5.927031 etc etc etc.... [349] => 1.116730 ) ) " -
[Contribtion] Year/Make/Model for OSC v2.3.x
motoenvena replied to a topic in General Add-Ons Support
Thank you all for your suggestions. I get to work on it. Regards, Nacho -
[Contribtion] Year/Make/Model for OSC v2.3.x
motoenvena replied to a topic in General Add-Ons Support
Hi, @@DunWeb: I have installed YMM contribution and it works perfectly on websites paddockmotor[dot]com and bateriaparamoto[dot]com, but I have a problem with loading times of web. Can you avoid the initial charge of the script on the main page (index.php) and run it from another page as index2.php or selecvehicle.php, for example? Thank you very much. -
I've solved my problem support and contributions USU5 YMM. Finally, I uninstalled USU5 and I installed Ultimate SEO Url v2.2 by Chemo. This works perfectly with YMM contribution in osCommerce 2.2 rca. You can check the result on the website PaddockMotor, my site for motorcycle parts and accessories. Thank you very much everyone for your help. I hope these pointers serve people who have the same problem as me.
-
[Contribtion] Year/Make/Model for OSC v2.3.x
motoenvena replied to a topic in General Add-Ons Support
Hi: I've solved my problem support and contributions USU5 YMM. Finally, I uninstalled USU5 and I installed Ultimate SEO Url v2.2 by Chemo. This works perfectly with YMM contribution in osCommerce 2.2 rca. You can check the result on the website paddockmotor[dot]com, my site for motorcycle parts and accessories. Thank you very much everyone for your help. I hope these pointers serve people who have the same problem as me. -
[Contribtion] Year/Make/Model for OSC v2.3.x
motoenvena replied to a topic in General Add-Ons Support
@@kenkja Hello: Can you help me? How I can run together USU5 and YMM contributions? Thank you very much. Regards, -
[Contribtion] Year/Make/Model for OSC v2.3.x
motoenvena replied to a topic in General Add-Ons Support
@@DunWeb Where should I add the SEO URL´s exceptions? It can be in one of these two options? /includes/modules/ultimate_seo_urls5/includes/uri_redirects_array.php .htacces file I just I have this problem with the YMM contribution and is very important to me that works perfectly. Please can you give me some more advice? Thank you very much. -
[Contribtion] Year/Make/Model for OSC v2.3.x
motoenvena replied to a topic in General Add-Ons Support
@@DunWeb I've done something like this but it only works sometimes: # Excepción YMM RedirectMatch 301 /(.*)-c-(.*).html?Make=(.*)&Model=(.*)&Year=(.*) /index.php?cPath=$2.html?Make=$3&Model=$4&Year=$5 I've done it in the .htaccess file -
[Contribtion] Year/Make/Model for OSC v2.3.x
motoenvena replied to a topic in General Add-Ons Support
I've done something like this but it only works sometimes: # Excepción YMM RedirectMatch 301 /(.*)-c-(.*).html?Make=(.*)&Model=(.*)&Year=(.*) /index.php?cPath=$2.html?Make=$3&Model=$4&Year=$5 I've done it in the .htaccess file -
[Contribtion] Year/Make/Model for OSC v2.3.x
motoenvena replied to a topic in General Add-Ons Support
Hello: Thank you very much for your quick response. But how I can create an exception for the contribution USU5? Something like this? #categories #note to work perfectly must make a symlink of index.php -> index2.php #condition: do following only if query_string not includes cPath RewriteCond %{QUERY_STRING} !cPath #rewrite "name path" to index.php?cPath RewriteRule ^(.*)-c-(.*)$ index2\.php?cPath=$2 [L,NC,QSA] #the same if you use the standard and no rewrite #RewriteRule ^index\.php/(.*)-c-(.*)$ index2\.php?cPath=$2 [L,NC,QSA] ###################################################### Thank you very much. Greetings from Spain. -
Hi all: First, I want to thank all developers to share their code. I have a problem with the Year, Make, Model contribution. This works perfectly with USU5 (Ultimate SEO Urls 5) off, but when the contribution USU5 is enabled, a SQL query fails when I'm browsing a category and use the box Year, Make, Model. V.g: Run ok: http://www.paddockmotor.com/index.php?Make=Honda&Model=CBR+1000+RR+Fireblade+&Year=2012 If I'm in a category: http://www.paddockmotor.com/aceites-c-6.html When selecting a motorcycle with the filter: http://www.paddockmotor.com/aceites-c-6.html?Make=Honda&Model=CBR1000RRFireblade&Year=2012&x=31&y=16 Then 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 ') and p.products_status = '1' and p.products_id = pc.products_id and cd.categor' at line 1 select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, cd.categories_id, cd.categories_alt_imagen from products p, categories_description cd, products_to_categories pc where p.products_id in () and p.products_status = '1' and p.products_id = pc.products_id and cd.categories_id = pc.categories_id and cd.language_id = '3' order by p.products_date_added desc limit 10 [TEP STOP] Please, can anyone help me? Thank you very much.
-
[Contribtion] Year/Make/Model for OSC v2.3.x
motoenvena replied to a topic in General Add-Ons Support
Hi all: First, I want to thank all developers to share their code. I have a problem with the Year, Make, Model contribution. This works perfectly with USU5 (Ultimate SEO Urls 5) off, but when the contribution USU5 is enabled, a SQL query fails when I'm browsing a category and use the box Year, Make, Model. V.g: Run ok: http://www.paddockmotor.com/index.php?Make=Honda&Model=CBR+1000+RR+Fireblade+&Year=2012 If I'm in a category: http://www.paddockmotor.com/aceites-c-6.html When selecting a motorcycle with the filter: http://www.paddockmotor.com/aceites-c-6.html?Make=Honda&Model=CBR1000RRFireblade&Year=2012&x=31&y=16 Then 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 ') and p.products_status = '1' and p.products_id = pc.products_id and cd.categor' at line 1 select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, cd.categories_id, cd.categories_alt_imagen from products p, categories_description cd, products_to_categories pc where p.products_id in () and p.products_status = '1' and p.products_id = pc.products_id and cd.categories_id = pc.categories_id and cd.language_id = '3' order by p.products_date_added desc limit 10 [TEP STOP] ===================================== Please, can anyone help me? Thank you very much. The urls will not work because the contribution YMM is disabled -
Sorry for my English. The question is: I need a product that can be associated with a brand of motorcycle, its model and year. Thank you very much.