Page 1 of 1
help for display order
Posted: Fri Mar 09, 2012 1:41 am
by skau
Hi, ... running alegro 1.2.7 to SVN r148
in my site when I do orders i can see them in detail only from administrator panel
ERROR: as a user I can see in "My Order History" the summary of orders made, but clicking on "view" to see details it gives me always "The page you requested cannot be found."
This happens, I think, after I've deleted from admin all previous orders to make some cleanup ...
Can you help me ??
thanks in advance
Michele (from Rome)
Re: help for display order
Posted: Fri Mar 09, 2012 2:19 am
by leo
How did you delete the previous orders?
In the admin of AC or in phpMyAdmin?
Re: help for display order
Posted: Fri Mar 09, 2012 4:35 am
by skau
Hi.. from ADMIN AC...
I do not know if this is the cause
, but may be the problem is because i've reached last svn and I've not updated DB stucture (I cant find in my DB any table named "p2d") list from error log:
MySQL Error: Unknown column 'p2d.free' in 'where clause'
Error No: 1054
select * from product_to_download p2d left join download d on (p2d.download_id = d.download_id) left join download_description dd on (d.download_id = dd.download_id) where p2d.product_id = '46' and p2d.free = ' 0 ' and dd.language_id = '2'
Path: /admin/?controller=product
Query String: controller=product
But how can I create that table ??
thank in advance
Michele from Rome
Re: help for display order
Posted: Fri Mar 09, 2012 4:50 am
by leo
These are the new entries added to the upgrade.sql
Code: Select all
#Start of Version 1.2.7 ***********
SET @id=NULL;
SELECT @id:=setting_id FROM setting WHERE `group` = 'config' and `key` = 'config_discount_options';
INSERT INTO `setting` (`setting_id`, `type`, `group`, `key`, `value`) VALUES (@id, 'catalog', 'config', 'config_discount_options', '0') ON DUPLICATE KEY UPDATE setting_id=setting_id;
SET @id=NULL;
SELECT @id:=setting_id FROM setting WHERE `group` = 'config' and `key` = 'config_show_stock_icon';
INSERT INTO `setting` (`setting_id`, `type`, `group`, `key`, `value`) VALUES (@id, 'catalog', 'config', 'config_show_stock_icon', '0') ON DUPLICATE KEY UPDATE setting_id=setting_id;
SET @id=NULL;
SELECT @id:=setting_id FROM setting WHERE `group` = 'config' and `key` = 'config_low_stock_warning';
INSERT INTO `setting` (`setting_id`, `type`, `group`, `key`, `value`) VALUES (@id, 'catalog', 'config', 'config_low_stock_warning', '0') ON DUPLICATE KEY UPDATE setting_id=setting_id;
SET @id=NULL;
SELECT @id:=setting_id FROM setting WHERE `group` = 'config' and `key` = 'config_session_expire';
INSERT INTO `setting` (`setting_id`, `type`, `group`, `key`, `value`) VALUES (@id, 'global', 'config', 'config_session_expire', '3600') ON DUPLICATE KEY UPDATE setting_id=setting_id;
#Add free download
SET @id=NULL;
SELECT @id:=setting_id FROM setting WHERE `group` = 'config' and `key` = 'config_freedownload';
INSERT INTO `setting` (`setting_id`, `type`, `group`, `key`, `value`) VALUES (@id, 'catalog', 'config', 'config_freedownload', '0') ON DUPLICATE KEY UPDATE setting_id=setting_id;
ALTER TABLE `product_to_download` ADD `free` INT( 1 ) NOT NULL DEFAULT '0';
Run it on your database.
Re: help for display order
Posted: Mon Mar 12, 2012 2:41 am
by skau
Hi, ... running alegro 1.2.7 to SVN r148
From previous mail my DB structure is updated... but
ERROR:
1) as a user I can see in "My Order History" the summary of orders made, but clicking on "view" to see details it gives me always "The page you requested cannot be found"
2) because i've made more then 4 orders, I can see that the total orders are correct (results 1-4 of 7) but clicking on "next page" gives me an other time "The page you requested cannot be found"
NOTE: I can see correctly orders in detail from administrator panel
I went with HEIDiSql t see DB content, and it appears all ok (all table orders are filled corrertly)
Can you help me ??
Or, for a better debug, can You tell me how to put some string to screen to see the content of query that fails ???
thanks in advance
Michele (from Rome)
Re: help for display order
Posted: Mon Mar 12, 2012 2:45 am
by leo
Enable Error Handler in Admin/Configuration/Setting/Error Handling tab.
May be your files are corrupt. Try to re-upload them.
Re: help for display order
Posted: Tue Mar 13, 2012 10:38 pm
by skau
Hi.. sorry for my late answer...
after a lot of tries I've reinstalled from SVN 1.2.7, and performed upgrading via SVN to the latest r148...
Now it works
... my be the problem was a corrupted file !!
CAN I STILL ASK YOU A LITTLE HELP ????
When I do reinstalled all, and upgraded to last r148 version.. I must each time modify some files
according your specifications for bugs in (1) display mini-chart module and (2) bank transfer module
Can you just release a new Rev for this ??? It would help to have SVN complete working functions !
1) Ok, then in the catalog/controller/addtocart.php comment out the line
$output .= '$(\'#cart_products\').hide(3500);' . "\n";
and in the catalog/template/default/module/cart.php (o tpl ??) delete
$(document).ready(function(){
$('#cart_products').hide(0);
});
2) Change in catalog/controller/checkout_confirm.php about line 410 to
$email->set('email_banktr_ban', $this->language->get('email_banktr_ban'));
$email->set('banktr_ban', $this->config->get('banktr_ban'));
$email->set('email_banktr_iban', $this->language->get('email_banktr_iban'));
$email->set('email_banktr_swift', $this->language->get('email_banktr_swift'));
$email->set('banktr_iban', $this->config->get('banktr_iban'));
$email->set('banktr_swift', $this->config->get('banktr_swift'));
} else {
$email->set('email_banktr_message', NULL);
}
Thank you so much in advance
Michele from Rome
Re: help for display order
Posted: Wed Mar 14, 2012 12:05 am
by leo
The first one is not a bug. That was your idea/decision to change it.
The second one that is a bug will be fixed in r149 (as soon as I finish the auto detect currency mod).
If you have r148 installed you have manually modify your files to have the first one added and the second one fixed.
Re: help for display order
Posted: Wed Mar 14, 2012 5:12 am
by skau
thank you so much !!!
Michele