help for display order

[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)

[leo]

How did you delete the previous orders?
In the admin of AC or in phpMyAdmin?

[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

[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.

[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)

[leo]

Enable Error Handler in Admin/Configuration/Setting/Error Handling tab.

May be your files are corrupt. Try to re-upload them.

[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

[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.

[skau]

thank you so much !!!
Michele